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

1153 Whispering Oaks Road
Marshfield, MO 65706
Elizabeth A. Hill with Keller Williams, original listing - (417) 883-4900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $840,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 5066 Square Feet
Agency: Keller Williams
Agency Phone: (417) 883-4900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Rare offering! MARSHFIELD SCHOOL DIST. This One-of-a-kind estate is situated on 40.75ac in a convenient location, minutes to I-44 at Northview just off Cologna Rd. The home is a custom-built showplace featuring over 5,000 sq.ft. of quality living space, 4 bedrooms, 3 full bathrooms, two living areas, a beautiful pond, a 45x70 pole barn and a 20x50 shop. You'll be welcomed by beautiful Brazilian Cherry Hardwoods, gorgeous woodwork & crown moldings, 10' ceilings on the main, abundant natural light and custom blinds throughout... The main floor features a formal dining room, generous size study, inviting living area with pretty hearth and gas insert, two nice sized bedrooms, full bath and laundry room with garage access. The spacious kitchen/dining area is made for entertaining and features granite countertops, oak cabinetry, stainless appliances, undermount sink, pantry and access to the back deck. The covered back deck is the perfect space to take in the breathtaking views of the countryside, watching the horses graze or to sit and listen to a spring thunderstorm roll in. Just off the kitchen you'll find a generous laundry space, coat area/mudroom that comes in off of the 2-car garage. The master suite is spacious, offers access to the covered deck, a jetted tub, dual vanity and walk-in closets. The basement houses the 2nd living area which features a wood burning fireplace and space for your future wet bar. Guests will enjoy having a private room with patio access... There's plenty of room for the kids to play, too! This package is made complete with a beautiful pond, John Deere room, a 45x70 pole barn with water and a 20x50 shop with concrete floor and overhead door. The home is framed with mature landscaping, pipe and cable fencing; Pasture is fenced and cross fenced. Propane tank owned. Situated just 25 min east of Springfield with great access to prime shopping, dining and healthcare. Call today for your private showing!
MlsNumber: --
ListingId: 60270336


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