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;

19529 Lawrence 2152
Aurora, MO 65605
Donna Cleous with Murney Associates - Primrose, original listing - (417) 823-2300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $625,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3136 Square Feet
Agency: Murney Associates - Primrose
Agency Phone: (417) 823-2300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Spectacular all brick & stone home setting on 5.1 acres near Aurora's Honey Creek Golf Course overlooking the beautiful countryside with stunning views of the sunrises, sunsets, deer, turkey, and wildlife plus an in-ground, salt-water pool with automatic cover for family fun! This 4 bedroom, 3 1/2 bath home was custom built in 2012 by Bill Michel with quality features. Amenities include gorgeous hardwood floors, two gas fireplaces, high ceilings, formal dining room with built-in China hutch/bookcase. The cook in the family will love the gourmet kitchen with an abundance of custom Alder cabinets, granite counters, a double sink plus a 2nd prep sink, high-end stainless-steel appliances including a Wolf gas cooktop with griddle, double ovens, built-in microwave, & refrigerator. Main floor laundry with washer & dryer that stay with the home. Spacious breakfast nook with breakfast bar and easy access to the maintenance-free, TimberTeck deck for grilling & outdoor entertaining. Large primary suite with sitting area & luxurious master bath with heated marble floors, tile shower, jetted tub, dual vanities & a large walk-in closet. The upper level also includes two additional bedrooms and a full bath. The lower-level walk-out basement includes a second living area, 4th bedroom, a full bath, and a hobby/craft room or office that is soundproofed and designed for music or instrument playing. The stone patio features a built-in firepit, pergola & lush landscaping. Other amenities include a sprinkler system in the front and east side yards, a buried propane tank, a tankless hot-water heater, a water softener, a generator, and a storage shed. The spacious 3-car attached garage is heated and cooled and has a built-in bar perfect for a man cave. Paved driveway, security system & so much more. Call today to schedule your private showing to see how much this wonderful home has to offer!
MlsNumber: --
ListingId: 60273036


Listing Provided By: Murney Associates - Primrose, original listing
Phone: (417) 823-2300
Office Phone: (417) 823-2300
Agent Name: Donna Cleous
Disclaimer: Copyright © 2024 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