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

27471 E Axle Road
Schell City, MO 64783
Ashlee Whittington-Duncan with CURTIS & SONS REALTY, original listing - (417) 667-7868

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $119,000
Beds: 1
Baths: Full: 1
Status: Active
SqFt: 439 Square Feet
Agency: CURTIS & SONS REALTY
Agency Phone: (417) 667-7868

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1996
Notes: Your Ultimate Country Getaway!<br /> <br /> Looking for the perfect hunting cabin, weekend retreat, or a place to call your own in the countryside? This 30' x 30' studio-style property on 4.6 acres m/l is packed with potential and ready for you to make it your own.<br /> <br /> The bold blue exterior stands out in the rolling Missouri landscape, while the open-concept interior keeps things simple and functional. Wood-look flooring and plenty of natural light make it a comfortable spot to kick back after a day in the woods or working on the land.<br /> <br /> The large main living area is perfect for setting up your gear, hanging out, or catching some shut-eye. The oversized bathroom offers plenty of space and features a sleek white shower.<br /> <br /> This property also includes an attached oversized garage, providing ample space for your tools, equipment, and outdoor gear. The garage’s easy access makes it a great spot to store ATVs, hunting supplies, or even use as a workshop.<br /> <br /> With 4.63 acres of open land, the opportunities are endless. Whether you want space for hunting, riding ATVs, building a workshop, or starting a garden, this property gives you room to do it all. It’s the ideal spot to enjoy campfires, set up shooting targets, or just soak in the peace and quiet of the country.<br /> <br /> If you’ve been dreaming of a low-maintenance place to relax, hunt, or make your own, this is it. Stay tuned—this rural getaway is coming soon, and it’s ready to help you live the simple life you’ve been looking for. Call to schedule your showing!
MlsNumber: --
ListingId: 2526594


Listing Provided By: CURTIS & SONS REALTY, original listing
Phone: (417) 321-7125
Office Phone: (417) 667-7868
Agent Name: Ashlee Whittington-Duncan
Disclaimer: Copyright © 2025 Heartland Multiple Listing Service. 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