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

977 Ne 100th Road
Lamar, MO 64759
Jeff Quade with Whitetail Properties Real Estate, original listing - (417) 540-0691

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $669,990
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: 41 acre(s)
Property Type: Farm-Other
Year Built: --
Notes: If you have been searching for that hard-to-find perfect homestead property to bring your family, 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 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 2 ponds and excellent shady pasture or hay ground. If you enjoy hunting this tract offers an active deer population, plentiful wildlife forage and water sources. This property is so versatile, you can do it all! 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 /> " 2 Ponds. <br /> " Shaded pasture.<br /> " Perimeter fencing.<br /> " Pasture/hay ground.<br /> " Hunting.<br /> " Active wildlife.<br /> " 11 miles to Sheldon Mo. and I-49.<br /> " 18 miles to Lamar.<br /> " 20 Miles to Stockton Lake.
MlsNumber: --
ListingId: 245450


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