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

3737 Smyrna Road
Rogersville, MO 65742
Trevor Teabeau with Alpha Realty MO, LLC, original listing - (417) 719-1560

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $989,900
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 5118 Square Feet
Agency: Alpha Realty MO, LLC
Agency Phone: (417) 719-1560

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Discover a rare gem in the Ozark School District at the end of a private lane! This stunning all-brick walkout basement home, situated on a private 5-acre parcel offers endless possibilities. With its rolling landscape, beautiful vistas, and abundance of natural light, this property is sure to inspire. NEW roof, NEW HVAC, NEW flooring throughout, NEW man cave w/ half bath, NEW pool updates, NEW appliances, Updated kitchen & NEW paint throughout! The impressive first floor boasts vaulted ceilings, wood beams and a massive stone see-through fireplace, creating the perfect atmosphere for relaxation and entertainment. The split floor plan features three bedrooms on the main level, including a luxurious primary suite with its own fireplace, tub, walk-in shower, dual vanities and a spacious walk-in closet. The kitchen and adjacent dining are designed for effortless entertaining, with a walk-in pantry, granite counters, double Oven and glass cooktop. The possibilities for entertaining are endless! The expansive covered back deck invites you to savor the serene surroundings and watch the deer roam. The basement is a haven for entertainment, featuring a wet bar, multiple livings areas, two bedrooms, a bathroom, and a bonus room perfect for a home office or exercise room. There is also a Washer and Dryer hook-up in the utility room that makes laundry a breeze. The incredible 282 sq/ft. enclosed sunroom is an added bonus complete with a private hot tub. Outdoor enthusiasts will appreciate the large patio and deck, above-ground pool, and fenced area for kids, dog yard or a chicken pen. The primary three-car garage is oversized, and the additional detached shop/garage offers well portioned space for hobbyists and outdoor enthusiasts. Don't miss the opportunity to make this unique property your own and experience the ultimate in privacy, relaxation and entertainment.
MlsNumber: --
ListingId: 60294237


Listing Provided By: Alpha Realty MO, LLC, original listing
Phone: (314) 201-4040
Office Phone: (417) 719-1560
Agent Name: Trevor Teabeau
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