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

4775 S 50th Rd Road
Aldrich, MO 65601
Teresa G Cunningham with Murney Associates - Primrose, original listing - (417) 823-2300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,150,000
Beds: 1
Baths: Full: 1
Status: Active
SqFt: 504 Square Feet
Agency: Murney Associates - Primrose
Agency Phone: (417) 823-2300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 73 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: LIVE, WORK, PLAY..This unique DESTINATION property 2 mi m/l from Stockton Lake, offers numerous possible uses. On 73+ open and wild wooded acres you will find many diverse ecosystems! There is a creek running through the entire property with dozens of meanders, pools, and ripples. Even a beaver population had built a dam winter of 2021-22! You will find cliffs, hills, valleys, water, marsh, boulders, pasture, woods, forest, pond, a Confluence of two creeks, and more! This is a bird watchers paradise! Not uncommon to see eagles, osprey, ducks, geese, blue heron, pigeons, doves and assorted owls, hawks, woodpeckers, grouse, songbirds, hummingbirds and of course turkey. Close by, Stockton Lake even has White Pelicans!Many paths and trails have been cut through the woods and creek side for a natural adventure you won't soon forget! The 36 open Acres m/l of this land was farmed for cattle a decade or so ago, but otherwise has not been lived on in many many decades creating a Wildlife Haven, due to adjoining properties being unoccupied land.There is a thriving Bobcat population as well as coyote, deer, and all of the other wonderful Wildlife you can imagine. Prolific variety of turtles and frogs and pollinators. February brings the joys of frog sounds from the pond, and year-round you will hear the cacophony of coyote yodeling and yips, owls calling and more.Sunrises and sunsets are to die for!There is also a 3-year-old 500 sqft tiny house, heated, cooled, plumbed and electrified.. five additional storage buildings/tiny homes, a very nice 14x20 Greenhouse, two frost free hydrants, Garden area, equipment shed... the well and septic system are only 3 years old. All of this sits way off the seldom used Farm Road, so you rarely ever hear or see any traffic.But wait there's more! An RV road has been professionally excavated/built, and has four RV sites with electric Towers, with 20, 30, and 50 amp hookups... (see more marketing remarks in documents) OWNER/AGENT
MlsNumber: --
ListingId: 60286335


Listing Provided By: Murney Associates - Primrose, original listing
Phone: (417) 823-2300
Office Phone: (417) 823-2300
Agent Name: Teresa G Cunningham
Disclaimer: Copyright © 2025 Southern Missouri Regional MLS, LLC (SOMO). 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