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

839 State Highway T
Bolivar, MO 65613

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,650,000
Beds: 3
Baths: 4
Status: Active
SqFt: 4007
Agency: Missouri Home, Farm & Land Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 72 acre(s)
Property Type: Residential
Year Built: 2005
Notes: 3 Waters Ranch, where you get that Big Ranch feel, but right here in the Missouri Ozarks! From the moment you enter this Gated Entry you'll find that the circle Blacktop drive leads the way to this AMAZING property. As soon as you step out you'll see and hear the peaceful running waters of the 3 Waters Ranch flowing directly under your walk-way. As you enter this Stunning Custom Built Home through the Double entry doors you find that it features 4,000 Sq. Ft. and was strategically placed on 72.3 Acres! Inside, you'll find both Character and Class as you notice the tall ceilings and various windows throughout to enjoy all the views this place has to offer. The Master Bedroom Wing includes a very large bedroom with covered patio access, His/Hers walk-in closets, Grand Master bath with Walk-in Shower, jetted tub and His/Hers vanities. You also have a large Office Area equipped with Built-ins, Formal Dining, Formal Living, Family Room with cozy Fireplace, Breakfast Nook, Spacious Kitchen with Custom Cabinetry, Granite Counter Tops, Tile back splash, large Pantry, amenities include, trash compactor, dishwasher, wall oven with built-in microwave, Jenn-Air cooktop, Double sinks in the bar area and vegetable sink in the island. You'll also find Two Additional Bedrooms with Private Baths, Laundry Room, Appliance Room, Sunroom and Stamped Concrete Covered Patio. Upgrades include, Dual Fuel Heat, water softener, oversized pressure tank, Central Vacuum and a Brand New Roof! As if that's not ENOUGH, there is also a 2,600 sq ft. Horse Barn fitted with 8 horse stalls and an additional 630 sq ft of living space! Want more? How about another 4,250 sq. ft Steel Barn with, electric and approx. 2/3 concrete floor. The land is fully fenced pasture with a well, 3 ponds, Ready and Waiting for your horses or livestock. This is Ranch Living at its BEST! Check out the Pictures and Video!
MlsNumber: 60266850


Listing Provided By: Missouri Home, Farm & Land Realty LLC, original listing
Name: Missouri Home, Farm & Land Realty LLC
Phone: (417) 327-6483
Office Name: Missouri Home, Farm & Land Realty, LLC
Office Phone: (417) 327-6483
Agent Name: Jacquetta R Hensley
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.


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 = 1570 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;
Brad Middlemas
ASCIITriLake Realty at Keller Williams Realty Greater Springfield
Call Today!: (816) 520-6943

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App