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

3345 Sw H Highway
Schell City, MO 64783
John Rummel with Stockton Lake Properties, LLC, original listing - (417) 276-4295

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $330,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2600 Square Feet
Agency: Stockton Lake Properties, LLC
Agency Phone: (417) 276-4295

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Wow, Wow, WOW! An absolutely wonderful well kept home on approximately 8 acres situated in the middle of outdoor recreation opportunities. The ground level all electric house is a 3 bedroom 2 bath home with a wide open floor plan in the dining, living and kitchen area perfect for family or friends get togethers. Custom cherry cabinets provide tons of space for storage. The kitchen boasts center island with electric range. laminate counter tops and a breakfast bar to round it out. Loads of space in the living family area with natural light provided by double pane vinyl windows. Go off the living dining area is the remarkable large master bedroom and bath with walk in shower. The second bedroom is a nice sized room as well as the 3rd bedroom. The third bedroom has its own entry from the garage or outside as well. All bedrooms share a large walk in closet. There is a 10 x20 sun room off the back to enjoy your morning coffee taking in the country vistas and perhaps catch a glimpse of wildlife. An 8 x 75 ft. covered front porch provides that place to relax in the evening in your rocker. There is a 20 X 20 unfinished basement providing storage and safety. All this is topped off with a single car attached garage. Outside is a garden spot most just dream of with 2 rows of black berries and an asparagus bed already established. It has a freeze proof hydrant to provide irrigation. How about a large 23 x 60 enclosed building with a 26 ft overhang . Perfect to store RV, boat and machinery as the current owner does . If this isn't enough, there is an older will maintained building current owner uses to process game, clean fish, can vegetables and provide central location for the occasional fish fry. Both buildings have electric. The older of the two has water. This beautiful hardwoods on the south side of property. This is a perfect location for the development of an RV Park. Within 5 minutes of Taberville Public Access and a short distance to Shell Osage
MlsNumber: --
ListingId: 60282502


Listing Provided By: Stockton Lake Properties, LLC, original listing
Phone: (417) 276-4295
Office Phone: (417) 276-4295
Agent Name: John Rummel
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