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 = 1504 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 1504 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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 = 1504 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;

214 County Road 443
Ellsinore, MO 63937

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,900
Beds: 3
Baths: 3
Status: Active
SqFt: 2473
Agency: United Country American Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 160 acre(s)
Property Type: Residential
Year Built: 1978
Notes: Nature Lover's Paradise - Embrace the Outdoors, Escape the city's hustle and immerse yourself in the serene beauty of nature with this remarkable 3-bedroom, 2.5-bath home on an expansive 160-acre property surrounded by majestic government forest land. Discover the perfect retreat as you step onto this picturesque property, where peace and tranquility await at every turn .The beauty of the surrounding landscape will captivate your heart and soul. A large older Barn that is still usable .The full walkout basement offers endless possibilities - from extra living space to a workshop or recreational area. Let your imagination roam free! The well-appointed kitchen is designed with functionality and style in mind. It boasts ample counter space, and cabinets for all your culinary needs. Gather around the fireplace during chilly nights, creating cherished memories with family and friends. With an incredible 160 acres at your disposal, you have plenty of room for outdoor adventures, hiking, hunting, or simply savoring the great outdoors. If you're a wildlife enthusiast, you'll be delighted by the diverse flora and fauna that thrive on this property, thanks to its proximity to the pristine government forest land. It offers a year around creek and beautiful spring encased in block and runs into several ponds. Surrounded by government forest, you'll enjoy unmatched privacy, ensuring that your peaceful sanctuary remains undisturbed. While reveling in this natural oasis, you'll still have easy access to nearby amenities, ensuring you have the best of both worlds. Ellsinore Mo is 5 miles and Poplar Bluff Mo is 30 miles to this prime piece of real estate. Live Your Dream Life Amidst Nature!
MlsNumber: 11219717


Listing Provided By: United Country American Realty, original listing
Name: United Country American Realty
Phone: (573) 996-3901
Office Name: United Country American Realty
Office Phone: (573) 996-3901
Agent Name: Malinda "Mendy" Reece
Disclaimer: Copyright © 2024 My State MLS. 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