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

10560 State Hwy Cc
Niangua, MO 65713
Greg M Hill with Keller Williams, original listing - (417) 883-4900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,400,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 4000 Square Feet
Agency: Keller Williams
Agency Phone: (417) 883-4900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 244 acre(s)
Garage: Garage
Property Type: Farm-Single Family Residence
Year Built: 2005
Notes: Gorgeous, 1-owner Home with Shop & Buildings Situated on 244.08ac in Webster Co! Rustic elegance found here... this home, built in 2005 has been meticulously maintained and offers 4,000 sq. ft. of quality living space, 4 bedrooms (2 masters), 3 full baths, a wonderful kitchen/dining room, second living area & home office. Upon entry, you're welcomed by a stunning mahogany door, clean lines, tall ceilings, medium tone wood finishes, lots of natural & recessed lighting and a living area that is both comfortable & functional. Wood beams and car siding grace this area, giving it a truly rustic feel. The kitchen is an entertainers delight featuring white cabinetry accented by brushed nickel hardware, plenty of counter space, island, pendant lighting, stainless/black appliances, a prep sink, pantry and oversized tile. All appliances stay! The dining room features a magnificent view of the back property & offers patio access. Just off the kitchen is the oversized Mud Room w/access to both the garage and backyard. This is the perfect space to keep your extra fridge, deepfreeze and collection of cowboy boots! Upstairs you will find the generously sized second master with full bath and storage area/5th bedroom space. Across the home you will find the Master which is spacious and offers a luxury bath experience; soak your worries away here! This bath features his and hers sinks, a walk-in closet with custom shelving and shiplap accents. Two other nice sized rooms, the second living area and an incredible, rustic inspired office space can be found on the south side of the home. This package is made complete with a 30x40 shop with concrete floor & overhead door, a newer 50x100 hay barn/covered riding arena, a 40x80 barn w/a 16ft full length shed on the south side, 3 automatic waterers and Rental Income from the second home on N side. This home has been lovingly cared for and well maintained. Situated on the NE side of Webster Co.; convenient access to I-44. Conway Schools
MlsNumber: --
ListingId: 60282784


Listing Provided By: Keller Williams, original listing
Phone: (417) 883-4900
Office Phone: (417) 883-4900
Agent Name: Greg M Hill
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