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

12472 Liv 420 Road
Chillicothe, MO 64601
Bob Gaekwad with RE/MAX Town and Country, original listing - (660) 663-5757

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,999
Beds: 4
Baths: Full: 5
Status: Active
SqFt: 4817 Square Feet
Agency: RE/MAX Town and Country
Agency Phone: (660) 663-5757

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 42 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: This secluded country estate is nestled on 42.5 acres. The property is a beautiful combination of pastures and timber lending itself to great hunting opportunities, privacy and enjoyment of nature. The main house has 3,170 sq. ft. and has a finished walkout basement. This affords 4 bedrooms, 4 full bathrooms and a large storage storage area with severe weather room in the basement. The main house is enhanced with a large wraparound Trex deck. Large floor-to-ceiling windows brings scenic views of the surrounding nature into your living room. The custom design features blur the boundaries between indoors and outside with natural stone fireplaces and a wood ceiling in the great room. The open-concept living area and beautifully appointed kitchen with high-end Thermador appliances are perfect for entertaining. The master bedroom has an en-suite bathroom with a spa-like feel complete with a soaking tub.<br /> The property also offers a renovated stables that at one time was a functioning horse stable on the property. All of the rustic allure of the horse stalls were kept. The one of kind custom renovation offers two more bedrooms and a full bathroom. This building has its own AC, heating and water heater. There is a beautiful country kitchen with a wood bar. There is a covered patio on a concrete slab offering the perfect venue for a peaceful sunset dinner or rousing entertainment with friend. Adjacent to the patio is an above-ground pool 18 foot circular with sand filter and pump. The property also offers a 70x30 outbuilding with concrete floors throughout. There are a total of four oversized garage doors, with the two forward facing doors being electric with remote openers. This building is fully electric with lights. It is also plumbed. The outbuilding and stables share a septic tank that is separate from the main house. The pool will stay with the property. All furniture and furnishings in the stable and patio area are negotiable.
MlsNumber: --
ListingId: 2492888


Listing Provided By: RE/MAX Town and Country, original listing
Phone: (660) 973-6286
Office Phone: (660) 663-5757
Agent Name: Bob Gaekwad
Disclaimer: Copyright © 2024 Heartland Multiple Listing Service. 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