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
Jacquetta R Hensley with Missouri Home, Farm & Land Realty, LLC, original listing - (417) 327-6483

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,650,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4007 Square Feet
Agency: Missouri Home, Farm & Land Realty, LLC
Agency Phone: (417) 327-6483

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 72 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
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: --
ListingId: 60266850


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


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App