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

2133 S Farm Road 241
Rogersville, MO 65742
Faunlee Harle with AMAX Real Estate, original listing - (417) 855-2333

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,399,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 7657 Square Feet
Agency: AMAX Real Estate
Agency Phone: (417) 855-2333

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2014
Notes: Welcome to this private oasis on 16+ac. This custom home is a timber frame home. Much of the timber and beams were custom cut from the property which adds to the spectacular feel of the home. The home sets back away from the county road with a gated graveled lane that winds past the custom barn to add to the privacy. The 2-story foyer offers a double door entry to a spectacular custom staircase. Upon entering the great room you will enjoy the 2 story flagstone woodburning fireplace and a lovely view to the in-ground pool and wooded back yard. Wood flooring and wood posts add to the uniqueness of this home. Double barn doors open to the second living area with a gas fireplace enhanced with Oklahoma Flagstone. This area will be enjoyed from the gourmet kitchen with a stainless countertop and granite counter top plus a center island snack bar. A commercial gas stove with double convection ovens, a stainless vent hood, stainless refrigerator, microwave and two sinks will be enjoyed by the family chef. A large walk-in pantry adds additional space to the lovely wood cabinetry storage. Large commercial windows open this area to bring the outdoors in. Also on this floor is an office, which could be a non-conform bedroom and a second staircase that leads to the bedrooms upstairs including the master suite. Notice the vaulted wood ceiling in the master suite with custom wood shutters and large bath with a walk-in closet. Two additional bedrooms are on the 2nd floor, one with a tree-house play area. The full bath is a Jac and Jill arrangement The partial basement area includes a recreation area , work-out area, bedroom and bath. Outside, enjoy the 'super' screened-in patio, outdoor kitchen and an in-ground pool. The pool is 20x40 and includes a sun-bathing area. Fencing surrounds the perimeter of the pool and yard area. The barn (56x80) actually could be an RV garage with 2-14 ft. doors and a loft (15X80) for storage. Many extra amenities to enjoy!
MlsNumber: --
ListingId: 60274197


Listing Provided By: AMAX Real Estate, original listing
Phone: (417) 861-0008
Office Phone: (417) 855-2333
Agent Name: Faunlee Harle
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