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

352 State Highway 245
Dadeville, MO 65635
Billy Bruce with Billy Bruce Realty, original listing - (417) 326-2106

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,995,000
Beds: 6
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5987 Square Feet
Agency: Billy Bruce Realty
Agency Phone: (417) 326-2106

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 182 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 2012
Notes: Welcome to your equestrian dream! This property spans 182 rolling acres, making it a haven for horse enthusiasts. Nestled within this vast expanse of land is a massive custom-built home, offering a total of 6 bedrooms and 6 bathrooms. With its spacious layout, the residence can easily be divided into two separate living areas, providing flexibility and convenience.The home has a large master suite, offering a private sanctuary for relaxation. The family room boasts a magnificent wood-burning rock fireplace, creating a warm and inviting ambiance. The main level of the house is fully handicap accessible, featuring oversized automatic doors and an oversized walk-in shower that allows for chair access with ease. Surrounding the home are wrap-around covered porches, both on the upper and lower levels. These provide the perfect setting to enjoy breathtaking sunsets and soak in the beauty of the surrounding landscape. A true gem of this property is the Cadillac of indoor riding arenas. This state-of-the-art facility comes equipped with 17 horse stalls, each with turnouts. It also includes an office area, a bath, wash stalls, LED lighting, heating, and large sliding doors on both ends. Whether you are a professional equestrian or a passionate horse lover, this riding arena will exceed your expectations. Additionally, there is a secondary home on the property. The estate also features multiple structures including a large hay barn with a lean-to for storing ranch equipment, a partial under-roof working facility with a loafing shed, and a shop building with an attached ranch office. The rolling acreage offers a multitude of paddocks, complete with an intense grazing system in place. Water is plentiful across the acreage, with an added bonus of ponds and wet weather creeks. White vinyl fencing, complemented by the no climb woven wire offset, encloses the property. Located in SW MO, this property offers excellent country living while being less than an hour form Springfield.
MlsNumber: --
ListingId: 60246349


Listing Provided By: Billy Bruce Realty, original listing
Phone: (417) 399-4800
Office Phone: (417) 326-2106
Agent Name: Billy Bruce
Disclaimer: Copyright © 2024 Southern Missouri Regional MLS, LLC (SOMO). 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