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 = 1529 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 1529 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 = 1529 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;

15258 Us - 54
Weaubleau, MO 65774
Clayton Campbell with Midwest Land Group, LLC, original listing - (913) 674-8010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $794,400
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1800 Square Feet
Agency: Midwest Land Group, LLC
Agency Phone: (913) 674-8010

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 82 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Here is a great opportunity to own a beautiful 80 +/- acre grazing farm in Hickory County, Missouri! Sitting between Weaubleau and Wheatland MO, right off Highway 54, sits this immaculate farm ready for your family and your livestock. The pasture ground is primarily Class II and III soils and is currently seeded in fescue, clover, and other warm season grasses including Timothy. With several large automatic waterers and 2 ponds you'll never have to worry about a shortage of water. Fully fenced and cross-fenced, 5 paddocks are in place to rotational graze or keep pasture separate from hay production. Additional features include a very large and well designed area that is pipe fenced with automatic waterers to keep animals segregated when working livestock. A 40x60 machine shed including 2 extra stalls with a shared waterer is handy to keep all farm equipment and prized animals out of the elements. The main shop spans 80x70 including an inside wash area, more stalls, oversized doors and a 16 ft overhang to give shade while the livestock are in the catch pins. <br /> <br /> The farm has a beautiful 1,800 sq ft home with 2 beds, 2 baths built in 2021. The open floor plan design is a great space between the kitchen, dining room, and living room with a wood stove perfectly placed to help create a perfect environment to spend most of your time. With a detached, oversized 2 car garage with a 44x27 foot print there is plenty of space for storage of yard equipment as well as vehicles. As an added bonus there are 4 fenced kennels that are lit, shaded, and have partial concrete off the long side of the garage with separate doors for each kennel.<br /> <br /> The location and condition of this farm are top notch and will be hard to beat. If you are in the market for a pristine 82 acre farm to raise your family and your livestock, then look no further! Shown by appointment only and requires 48 hours notice.
MlsNumber: --
ListingId: 243590


Listing Provided By: Midwest Land Group, LLC, original listing
Phone: (620) 687-2789
Office Phone: (913) 674-8010
Agent Name: Clayton Campbell
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