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

23780 Moberly Road
Polo, MO 64671
Sarah Nuckols with RE/MAX Revolution, original listing - (816) 466-8600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $717,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2880 Square Feet
Agency: RE/MAX Revolution
Agency Phone: (816) 466-8600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 52 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Tucked away on a quiet hilltop, this beautifully maintained, open-concept ranch home offers the perfect blend of comfort, functionality, and seclusion on 52.5 acres of land. If you're looking for a peaceful homestead, a working ranch, or a peaceful getaway, this property has it all! Step inside to a spacious layout designed for easy living and entertaining. Double ovens in the kitchen, ideal for hosting holidays & gatherings and don't miss the walk in pantry! The primary suite includes a walk-in closet, a jetted tub & a walk-in tiled shower for a spa-like experience. The finished walk-out basement features a large rec room, a non-conforming 3rd bedroom, and double doors leading to a patio overlooking the countryside. Outdoors, this land is as functional as it is beautiful. You'll find a perfect mix of pasture, timber, creeks, & trails Fully fenced and ready to support 50+ head of cattle. One stocked pond for fishing & one drinking pond for livestock. The 45x50 outbuilding offers electricity & a lean-to. Steel cattle pens include water faucet and a heated water source for year-round convenience as well as a "cattle chute" For outdoor enthusiasts, the land is a hunter’s paradise—rich with turkey, deer, squirrels, & rabbits. Whether you're watching the sunset over the hills or tracking game through the timber, this property offers the best of country living. Don’t miss the chance to own this rare combination of comfort, privacy and entertainment!
MlsNumber: --
ListingId: 2549423


Listing Provided By: RE/MAX Revolution, original listing
Phone: (816) 466-8600
Office Phone: (816) 466-8600
Agent Name: Sarah Nuckols
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