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

14897 St Highway Ff
Ava, MO 65608

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 5
Baths: 5
Status: Active
SqFt: 5010
Agency: Murney Associates, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 59 acre(s)
Property Type: Residential
Year Built: 2000
Notes: This magnificent 5-bedroom, 4.5-bath residence boasts a 2-car attached garage and a walk-out basement, nestled on an expansive 59-acre estate with a separate lodge-style barn with a full kitchen. Surrounded by breathtaking rolling hills, mature woods, and captivating water views, this home offers a private well-water-fed lake. The towering covered entry opens up to a grand living room, with soaring ceilings anchored by a floor-to-ceiling brick fireplace. Neutral tones and plush carpeting create a cozy ambiance with natural light from large windows. Ascend the grand staircase to the loft, overlooking the first floor. Here, you'll find a spacious master suite, offering panoramic views from surrounding windows, trayed ceilings with accent lights, and a private master bath with a double vanity, jetted tub, separate shower, and a generously sized walk-in closet. Adjacent to the loft is a charming second bedroom. On the main floor, an expansive kitchen awaits, featuring exquisite granite countertops, solid oak cabinets, and a built-in raised bar for convenient seating, all overlooking the dining area, framed by picturesque bay windows. High-end narrow plank hardwood floors flow seamlessly from the kitchen and dining area into the second living space, complete with recessed lighting, a wall flanked by windows, and French doors that open to an all-season enclosed porch with access to open-air decks on each side. Stairs lead to the lower deck, a covered patio with brick columns, a hot tub, and an entrance to the walk-out basement. The spacious basement boasts an oversized bedroom suite with trayed ceilings and a private bathroom. The shared basement bathroom offers a walk-in shower near a spacious fifth bedroom. The home also includes a versatile non-conforming room with ample storage space, a third open living area with a beautiful brick corner fireplace, and a large second full kitchen. With too many features to list, don't miss your chance to see this gorgeous esate!
MlsNumber: 60254421


Listing Provided By: Murney Associates, LLC, original listing
Name: Murney Associates, LLC
Phone: (417) 575-1205
Office Name: Murney Associates - Primrose
Office Phone: (417) 823-2300
Agent Name: Langston Group
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