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 = 1598 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 = 1598 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 = 1598 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;

870 Wayne 353
Piedmont, MO 63957

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,999
Beds: 3
Baths: 1
Status: Active
SqFt: 2100
Agency: Living The Dream Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 85 acre(s)
Property Type: Residential
Year Built: --
Notes: Welcome to your dream getaway! This stunning 85-acre property offers the perfect blend of natural beauty and modern convenience. With 76 acres of mature hardwood forest and 15+ acres of lush pasture, you'll find peace and privacy in every corner. A picturesque, stocked pond and the charming Lick Branch winding through the property add to the serene atmosphere.<br /> <br /> Main Residence<br /> The main residence is a cozy, three-bedroom, one-bath earth home with a rustic rock front, providing both comfort and character. Enjoy ample storage and workspace in the three-car detached garage, which includes a versatile office area for your projects or remote work needs.<br /> <br /> Additional Features<br /> Barn: An older barn adds a touch of historic charm and additional storage or livestock shelter.<br /> Second Residence: A second residence, currently framed out and ready for your finishing touches, offers excellent potential for rental income via Airbnb or VRBO.<br /> Outdoor Amenities: Relax on the screened-in porch or stay warm with the outdoor wood stove and indoor wood stove.<br /> Prime Location<br /> Located just five minutes from Clearwater Lake, a premier destination for fishing and boating, this property is a haven for outdoor enthusiasts. The lake is fed by the pristine Black River, and the area boasts an abundance of deer and turkey, making it ideal for hunting and wildlife observation.<br /> <br /> This property combines the best of rural tranquility and modern living, offering a unique opportunity to create your perfect retreat or income-generating rental. Don't miss out on this exceptional piece of paradise!
MlsNumber: --


Listing Provided By: Living The Dream Inc., original listing
Name: Living The Dream Inc.
Phone: (855) 289-3478
Office Name: Living The Dream Outdoor Properties - Leasbur
Office Phone: (855) 289-3478
Agent Name: Lance Cureton
Disclaimer: Copyright © 2024 LandLeader. 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