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;

2167 Susanna Road
Niangua, MO 65713
Ashley N Hicks with Murney Associates - Primrose, original listing - (417) 823-2300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4700 Square Feet
Agency: Murney Associates - Primrose
Agency Phone: (417) 823-2300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 18 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: Stunning farmhouse situated on 18.5 acres in Webster Co. While the original part of this home was constructed in 1950, the entire home was renovated and addition added in 2016. As you enter the home your breath will be taken away by every inch of beauty in this home, including the beautiful and functional mud room. Rustic meets modern glam here! Some of the homeowners favorite features of the home include; the incredible views, privacy, the radiant flooring throughout, ample storage, two living spaces, outdoor living to its fullest and the in-ground concrete pool featuring fountains, lights and a slide. Summers are about to be AMAZING! The pool area is the ultimate hang out with lots of space to entertain. The outdoor kitchen offers everything you need to host your next party by the pool, day or night! Once back inside and on the main floor you'll be impressed by the kitchen that was just updated, Aug 2023, with trendy white custom shaker cabinets, complimented by gold hardware and quartz counters. The home is equipped with a high efficiency HVAC system and a central vac for both levels. The master bedroom has extra insulation to help reduce noise. The wood ceilings are stunning and such a compliment to the kitchen and living area! On the main floor you will also find the master bedroom which offers a private deck overlooking the pool, vaulted ceilings, custom built in cabinets in the massive closet, and a gas fireplace. Also included on the main floor are the dining, living and the mudroom, as well as two large bedrooms with a jack and jill bathroom and another full bath for guests. As you head downstairs you are sure to be impressed by the cedar staircase! Once downstairs you will find the second living space, (plumbed for 2nd kitchen), with another large bedroom and one bonus room w/a closet which would make a great 5th bedroom option, but would be nonconforming, the huge laundry room & another full bath. Be sure to ask for the list of highlights. Starlink avail
MlsNumber: --
ListingId: 60267710


Listing Provided By: Murney Associates - Primrose, original listing
Phone: (417) 288-9137
Office Phone: (417) 823-2300
Agent Name: Ashley N Hicks
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