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 = 1561 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 1561 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 1561 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;

3036 P Highway
Alton, MO 65606
Denver Wade with Wild Hills Realty, original listing - (417) 250-2560

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $284,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3070 Square Feet
Agency: Wild Hills Realty
Agency Phone: (417) 250-2560

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 1975
Notes: This 3 bedroom, 3 bathroom hobby farm has everything you've been looking for. Located on 9+/- acres less than 3 miles from the town center, this mixture of cleared and wooded acreage offers all the amenities of living close to shopping, schools, and grocery stores, but provides all the privacy and independence of owning your own secluded hideaway. This brick ranch style home with a basement opens into the living room with a wall of windows flooding the room with natural light. This flows into the dining and kitchen combo with ease and allows for effortless entertainment. The kitchen comes with a truly amazing amount of cabinets. Every pot you own, your mom owns, and your grandma owns could fit in these cabinets. The island makes the transition to the dining area seamless and inclusive. Off of the kitchen is an oversized laundry room with even more cabinet storage. On the other end of the house is the guest bathroom and three bedrooms, including the primary bedroom with its own private bathroom. Tile throughout the main living areas and bathrooms.Out the back you are treated to a covered deck with a spectacular view of the property, including: the upper pond, a couple of the grassy paddocks, metal barn and chicken coop (both of which have electricity). Around the corner you have an amazing fenced in garden area with water always nearby with frost free hydrants. Wandering through the beautiful cleared land near the house through the trees towards the back fence will lead you to the lower pond and the bulk of the acreage which is teeming with wildlife. The full basement provides plenty of storage, the third bathroom, a workshop area, and walkout double doors allowing you to use a portion of the space as a John Deere garage. Rounding out the specs are new gutters, a whole house generator hookup, and a lot of hard work that truly shows this home has been cared for.
MlsNumber: --
ListingId: 60292393


Listing Provided By: Wild Hills Realty, original listing
Phone: (417) 293-6404
Office Phone: (417) 250-2560
Agent Name: Denver Wade
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