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

3184 E 7
Clinton, MO 64735
Ethan Olson with Midwest Land Group, original listing - (913) 674-8010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,730,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 4300 Square Feet
Agency: Midwest Land Group
Agency Phone: (913) 674-8010

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 80 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Midwest Land Group is honored to represent this beautiful 80.6 +/- acre farm just outside of Clinton, MO. Farms of this caliber do not hit the market often. This pristine property is tailored for equestrian enthusiasts seeking the perfect blend of luxury and functionality. This remarkable equestrian property boasts meticulous attention to detail, evident in every aspect of its design and layout. Tight perimeter fencing ensures security and privacy, while cross fencing divides the land into multiple pastures, providing ample space for horses to roam and graze freely. As you travel down the driveway, you will notice white vinyl fencing bringing a sense of elegance to the property. This equestrian property features tight perimeter fencing, white vinyl fencing, cross fencing, multiple ponds, waterers, multiple pastures, class 2 silt loam soils, 15,000+ square foot facility and a 3000 square foot home. Tight perimeter fencing ensures security and privacy, while cross fencing divides the land into multiple pastures, providing ample space for horses to roam and graze freely. Step inside to discover a welcoming ambiance, where every detail has been thoughtfully curated to create a sense of warmth and comfort. The main level of the home features three formal bedrooms, including a luxurious master suite that serves as a serene sanctuary, complete with a spa-like ensuite bathroom. Also on the main level you will discover a formal dining room; ready to entertain guests, a quaint office, and an inviting living room seamlessly connected to the open-concept kitchen. Just off of the living room you can escape to the sun porch, where relaxation and rejuvenation await featuring an elegant hot tub. Downstairs, two additional nonconforming bedrooms provide flexibility and versatility, perfect for accommodating guests or gym space. With four full bathrooms throughout the home, convenience and comfort are always within reach. Outside the home lies a sprawling 15,000+ square foot facility, meticulously designed to meet the needs of even the most discerning equestrian. Featuring 13 spacious stalls, well-equipped tack rooms, and a variety of amenities tailored to the needs of both horse and rider, this facility sets a new standard for equestrian excellence. Nine moveable stalls are also featured within the facility. The property also boasts a large outdoor arena with a viewing area.
MlsNumber: --
ListingId: 97310


Listing Provided By: Midwest Land Group, original listing
Phone: (573) 821-7533
Office Phone: (913) 674-8010
Agent Name: Ethan Olson
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.


Local Real Estate Expert

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 = 1528 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;
Real Estate Expert Photo for Lora Anstine, Broker/Owner
Lora Anstine, Broker/Owner
ASCIIAnstine Realty & Auction, LLC
Call Today!: (660) 525-9914

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App