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;

979 Ne 100th Road
Sheldon, MO 64784
Jeff Quade with Whitetail Properties Real Estate, original listing - (417) 540-0691

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $540,000
Beds: 5
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2848 Square Feet
Agency: Whitetail Properties Real Estate
Agency Phone: (417) 540-0691

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: If you have been searching for that hard-to-find perfect home on a smaller acreage to bring your horses or livestock to, we have it! Everything is here! Located eleven miles east of Sheldon and I-49, this 2017 site built 5 bedroom/2 ½ bath home offers 2848 sqft of wonderful living space. Upon entering, you are greeted by the spacious open gathering area with a wide set of windows which provide lovely natural light. The kitchen is the heart of the home with a large center island, beautiful custom cedar cabinets, concrete counter tops, and a large/deep farmhouse sink. Off the dining area you will find a wonderful porch overlooking the above ground pool, which provides great additional entertaining space. The east wing includes the primary ensuite with bath and walk-in closet, a second bedr a second bedroom, half bath with barrel cabinet sink, and storage/pantry. West wing is home to 3 additional bedrooms, a full bath, a large utility area with soaking sink and 2 custom cedar dog kennels. The amenities this acreage offers just get better when you tour the large heated/insulated shop, horse barn, and machine shed. The remaining acreage is home to a pond and excellent shady pasture. This property is so versatile, you can do it all! Bring your family, animals, entertain or enjoy the privacy! If you have any questions or would like to view the property, just give us a call.<br /> <br /> " Wonderful site-built home.<br /> " Electric appliances and air.<br /> " Propane heat.<br /> " Above ground pool.<br /> " 40' x 40' horse barn.<br /> " 30' x 50' heated/insulated shop.<br /> " 40' x 60' machine shed.<br /> " Pond.<br /> " Shaded pasture.<br /> " Fenced.<br /> " 11 miles to Sheldon Mo. and I-49.
MlsNumber: --
ListingId: 244541


Listing Provided By: Whitetail Properties Real Estate, original listing
Phone: (417) 540-0691
Office Phone: (417) 540-0691
Agent Name: Jeff Quade
Disclaimer: Copyright © 2024 Ozark Gateway Association of Realtors. 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