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

Tbd N Big Lick
Prairie Home, MO 65068
Derek Payne with Midwest Land Group, original listing - (913) 674-8010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,065,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Midwest Land Group
Agency Phone: (913) 674-8010

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 163 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Not often does a farm of this caliber come available in Eastern Cooper County! This 163.22 surveyed acre phenomenal CRP farm is conveniently located just under 20 minutes west of Columbia, MO, 4 miles south of Interstate 70, and only a few miles west of Big Muddy National Wildlife Refuge! If you’re looking for an income producing recreational farm that is truly one of a kind then this is it! Your jaw will drop as you pull down the newly graveled driveway that leads thorough the timber and opens up into one of the many different CRP fields. This is by far the cleanest CRP farm I have ever been on and that you will likely ever find! There are two CRP contracts totaling 68.47 acres paying $9649 annually and expire in 2031 and 2032. The farm features many different fields, miles of field edge, massive elevation changes, high ridge tops and pinch points, a number of food plots, a large creek, two small ponds, partial terracing, road frontage on two sides for access, and an abundance of beautiful mature oak, hickory, and walnut timber. Income producing recreational farms simply do not get any better than this farm! The farm is jam packed with deer and turkey sign and both were seen while getting photos of the farm! Located this close to the Missouri River bottom and Big Muddy NWR you can imagine the type of whitetail that roam this farm and that are in the immediate area! This area is known by many for producing big deer!
MlsNumber: --
ListingId: 97684


Listing Provided By: Midwest Land Group, original listing
Phone: (573) 999-4574
Office Phone: (913) 674-8010
Agent Name: Derek Payne
Disclaimer: Copyright © 2024 West Central 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