Title Page Background
DEBUG FN args: Array ( [0] => 1783 [1] => [2] => [3] => agent ) BEFORE: Site: 1783 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1783 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1783 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1783 [1] => [2] => [3] => lender ) BEFORE: Site: 1783 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1783 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1783 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1783 [1] => [2] => [3] => other ) BEFORE: Site: 1783 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1783 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1783 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;

1898 Terrell Valley Drive
Republic, MO 65738

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 4625 Square Feet
Agency: Orenda Real Estate

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Refrigerator, Garbage Disposer, Water - Softener, Cooktop - Gas, Oven - Double, Oven - Double Gas
Architectural Style: Contemporary
Construction Materials: Stucco, Frame
Flooring: Carpet, Vinyl
Heating: Forced Air, Fireplace
Interior Features: High Speed Internet, Cable Tv, Wet Bar, High Ceilings, Walk-in Closet(s), Vaulted Ceiling(s), Walk-in Shower, Hot Tub, Jetted Tub, Granite Counters, Smoke Detector(s), Skylight(s), W/D Hookup, Tv Antenna, Internet - Cable, Internet - Cellular/Wireless, Air Purifier
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5
Utilities: Cable Available

Window Features

Exterior Features: Rain Gutters, Cable Available
Parking Features: Garage, Driveway, Secured, Heated, RV, Oversized, Gated
Roof: Shingle, Asbestos Shingle

Neighborhood/Schools

Elementary School/District: RP McCulloch
Middle/Junior High School/District:
High School/District: Republic
Subvidision Name: Christian-Not in List

Description/Comments


Lot Size: 18 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Once in a lifetime opportunity to own this comfortably modern home. Acreage has potential for another home or two, a mother-in-law or guest house. This spacious home features large windows overlooking Terrell Creek along with 2 other perennial spring fed creeks. Enjoy your coffee watching the sunrise from your bed through extra wide and 5 feet tall, oversized windows. Ideal locations on this property for peaceful glamping and hammocking. Escape the noise of the city. Live in the tree-top, wooded view with nature walks that span over 1 mile along the banks of the streams winding along fields and forestry. An 1890's barn, 2 feeding bins, pioneer homestead footprint, rock lined well, root cellar and a vast number of mature trees can be enjoyed along your relaxing trail walk. About 7 months out of the year, a serene 30' long and 6' high waterfall runs on the property on Terrell Creek. Dozens of bird species can be heard and watched from nearly every room of the house along with spotted white tail deer fawns. It is a true nature experience. Amenities for large friend and family gatherings include a large deck, a year-round heated Tidal Fit pool to train for lap swims against adjustable currents, a large hot tub with powerful foot jets and a large flagstone patio with a 5' firepit. Wired for entertainment with speakers inside and outside. Park your boat or RV in the detached 30x40 garage/workshop. Parking areas to accommodate 10 plus vehicles in addition to the heated and air conditioned oversized 3 car garage. This home's master bedroom features a dream closet, coffee bar, a large shower with 6 body jets, 2 shower heads and a rain shower head. Bonus rooms include a loft overlooking the great room, large storage room in the basement and a storm shelter. This quality-built dream home nestled in the woods with year-round live streams is a place you will love to call home. Beautiful home with option to buy 5.1 additional acres. Builder and Investment Opportunity
MlsNumber: --


Listing Provided By: Orenda Real Estate, original listing
Phone: (417) 708-2998
Office Phone: (816) 355-4242
Agent Name: Christopher Dawson
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