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;

21243 State Highway N
Ava, MO 65608
Calvin & Gwen Chambers with Southern Missouri Homes and Farms LLC, original listing - (417) 894-8005

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,500,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3000 Square Feet
Agency: Southern Missouri Homes and Farms LLC
Agency Phone: (417) 894-8005

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 214 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Custom-quality brick home includes a 3000 sq ft. open floor plan with three bedrooms and 2.5 baths. The great room's focal point is a brick full masonry wood-burning fireplace, expansive vault ceiling, and skylights. The kitchen's custom wood house cabinetry has 52 in. upper cabinets, all soft closed with pull-out shelves on the lower cabinets. Quartz countertops, all Bosch appliances, propane oversized cooktop with pot filler, and a double oven including a speed cooker. Hardwood floors and 8 ft. custom knotty elder doors. Ceilings are 10 and 11 ft. with some very tall vaults. Divided floor plan; the master has a luxury bath and doors leading to the back screened-in porch. Two bedrooms have a jack-and-jill bath and an additional playroom or office. All bedrooms have walk-in closets. The family /game room is upstairs--large laundry room w/ wash sink, walk-in pantry, and a two-car attached garage. The whole house is networked. Speakers in ceilings in the great room and on the back porch. The screened back porch has a built-in propane grill and exhaust hood. The shop has 750 sq. ft. charming in-laws quarters/apartments with a private entrance. The shop area is fully insulated and drywalled with 12 ft drive-thru doors and a large open loft area for storage above the apartment. The greenhouse has water and electricity, and a raised bed garden is fenced to keep out wildlife.The chicken coop is 10x30 with a 20 ft. enclosed run. All this on 214 acres. If you are looking for a place to live that is secluded, peaceful, and quiet and where you can enjoy wildlife and spring waters, you have found the place. Bring the family; there is an in-law quarter with two bedrooms, where they can have their own space. Hiking, exploring, hunting, and relaxing in the country make the best place to live. About 20 min from Ava
MlsNumber: --
ListingId: 60289498


Listing Provided By: Southern Missouri Homes and Farms LLC, original listing
Phone: (417) 894-8005
Office Phone: (417) 894-8005
Agent Name: Calvin & Gwen Chambers
Disclaimer: Copyright © 2025 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