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

948 County Road 318
Tecumseh, MO 65760

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $529,900
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2763 Square Feet
Agency: Murney Associates - Primrose
Agency Phone: (417) 823-2300

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Refrigerator, Garbage Disposer, Dryer, Water - Softener
Architectural Style: Other
Construction Materials: Vinyl Siding, Concrete, Block
Cooling: Attic Fan, Ceiling Fan(s)
Flooring: Vinyl, Hardwood
Heating: Central Furnace, Forced Air
Interior Features: Security System, Wet Bar, High Ceilings, Vaulted Ceiling(s), Hot Tub, Laminate Counters, Smoke Detector(s), W/D Hookup, Cultured Marble Counters, Water Filtration
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
Security Features: Security System
Utilities: Water Available

Window Features

Exterior Features: Rain Gutters, Water Access
Parking Features: Garage, Underground/Basement, Covered, Driveway
Roof: Metal
View: River
Waterfront Features: Waterfront, North Fork River

Neighborhood/Schools

Elementary School/District: Gainesville
Middle/Junior High School/District:
High School/District: Gainesville
Subvidision Name: Ozark-Not in List

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Experience the tranquility of riverside living at its finest in Tecumseh, MO, where the gentle flow of the North Folk River creates a serene backdrop for daily relaxation. Nestled on ~.6 acres, this charming 4-bedroom, 2-bathroom residence offers captivating views overlooking the renowned Dawt Mill Resort. The original mill dating back to 1866. The addition of a delightful loft dubbed the 'Eagles Nest' adds to the appeal, providing a cozy retreat for kids or grandkids.Upon entering, discover a spacious two-story layout featuring two expansive living areas, perfect for hosting guests or unwinding in comfort. The well-appointed kitchen boasts an inviting eating bar and three sets of sliding glass doors, seamlessly blending indoor and outdoor living.This property offers both personal enjoyment and investment potential, ideal for an enchanting Airbnb retreat. With a durable metal roof and low-maintenance vinyl siding, you can spend more time enjoying the beauty of the Ozarks.Convenience meets practicality with a one-car attached garage featuring a convenient shower, perfect for rinsing off after a day of adventure on the river. Two detached carports provide ample space for storing boats, vehicles, or an RV, catering to all your recreational needs.For the hobbyist or craftsman, a dedicated woodworking shop awaits, offering endless opportunities for creative pursuits and DIY projects.Don't miss out on the opportunity to make this riverside sanctuary your own, where everyday life feels like a vacation surrounded by the tranquility of nature. Schedule your viewing today and let the peacefulness of the North Folk River welcome you home.
MlsNumber: --
ListingId: 60265184


Listing Provided By: Murney Associates - Primrose, original listing
Phone: (417) 848-9500
Office Phone: (417) 823-2300
Agent Name: John Elkins
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.


Local Real Estate Expert

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 = 205 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;
Linda Ojeda
ASCIILinda Ojeda and Associates, JohnHart Real Estate
Call Today!: (818) 442-7504

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App