Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1523 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1523 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1523 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

127 East 5th Street
Hermann, MO 65041
David Hartman with Hartman Real Estate, original listing - (573) 486-2927

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 1916 Square Feet
Agency: Hartman Real Estate
Agency Phone: (573) 486-2927

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1842
Notes: Now Offering the Eduard Haus on 5th and Hanna's Cottage in the Rear at 127 East 5th Street in Historic Hermann. These Operating Short Term Vacation Rental Guest Houses come Turnkey with all Furniture and Equipment Included, Inside & Out! Eduard Haus is Recently Renovated with Plenty of Charm & Hanna's Cottage is a Recently Fully Renovated Quaint Cottage that will Steal Your Heart! Walking Distance to Restaurants, Winery, Shopping, Nightlife and Downtown! Full Kitchen in Eduard Haus and Kitchenette in Hanna's Cottage. Featuring Keyless Entry, Wi-Fi Thermostats, Fiber Optic Internet, Wood Floors, Luxury Vinyl Plank, Custom Bathroom, Smart TV's, Washer & Dryer, Off Street Parking & More! Eduard Haus is 3 Bedroom, 3 Baths, with 8 Queen Beds & Sleeps 16. Hanna's Cottage is 1 Bedroom, 1 Bath, 1 Queen Bed & 1 Queen Sleeper Sofa & Sleeps 4. Currently Booked with AirBnB, VRBO & Booking.com this Quality Money Maker Grossed $65,218 in 2023. Don't Miss Out on this Opportunity! Call Today!
MlsNumber: --
ListingId: 24015819


Listing Provided By: Hartman Real Estate, original listing
Phone: (314) 609-8889
Office Phone: (573) 486-2927
Agent Name: David Hartman
Disclaimer: Copyright © 2024 MARIS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App