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

18252 Lawrence 2187
Aurora, MO 65605
Roxanne Stout with Keller Williams, original listing - (417) 883-4900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $595,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3013 Square Feet
Agency: Keller Williams
Agency Phone: (417) 883-4900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2017
Notes: Your Dream Hobby Farm Awaits - Move-in Ready with 10 Acres of PossibilitiesLooking for the perfect blend of comfort, style, and countryside living? This gorgeous hobby farm offers everything you need to live the life you've always dreamed of. Situated on 10 acres of lush, fenced pastureland, this property is ready for horses, livestock, or simply to be your personal retreat. Easy commute to Hwy 60 and close to town!A Home with Heart and CraftsmanshipThis beautiful move-in ready home is custom crafted with high-end materials throughout. From the moment you step inside, you'll notice the engineered hardwood floors that flow seamlessly from room to room. The spacious open layout makes it easy to entertain and enjoy time with family. The custom cabinets and granite countertops in the kitchen create a perfect space for cooking, while the cozy gas fireplace is ideal for warming up on chilly evenings. The heated and cooled sunroom provides a perfect space to relax and enjoy the views of your surrounding acreage, no matter the season.Comfort and Privacy with Room to GrowThe master suite is conveniently located on the first floor, providing privacy and easy access. Upstairs, you'll find two additional bedrooms and a versatile office area, perfect for working from home or having a quiet space to unwind. The finished basement is wired for audio and video, making it the ideal space for a home theater or entertainment area. Plus, the whole-home surveillance system gives you peace of mind, knowing your property is always secure.For those needing extra space, the basement also features two additional non-conforming bedrooms (perfect for guests or storage) and a third full bath that has been roughed in.Farm and Workshop Spaces GaloreWhether you're an equestrian enthusiast, hobby farmer, or just love having space for hobbies, this property delivers. A 60x14 shop with 220 electric. Also included is a newer 50x30 metal barn, ideal for all your farm needs.
MlsNumber: --
ListingId: 60285324


Listing Provided By: Keller Williams, original listing
Phone: (417) 883-4900
Office Phone: (417) 883-4900
Agent Name: Roxanne Stout
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