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

3859 Bear Track Way
Del Rio, TN 37727

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $574,999
Beds: 3
Baths: 4
Status: Active
SqFt: 3718
Agency: CRYE-LEIKE, REALTORS

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2007
Notes: : BACK ON THE MARKET AT NO FAULT TO THE SELLERS: Nestled in a serene, gated community River Crest Development in Del Rio, Tennessee only 15 minutes from Hot Springs, NC and the majestic Smoky Mountains at your back door. This enchanting cabin boasts three cozy bedrooms, and 3.5 bath with one of the bedrooms, and bath on the main level for convenience, and ease of access offering ample space and privacy. The property exudes charm and sophistication, with a gardener's dream featuring a greenhouse, terrace landscaping, and a garden adorned with vibrant plants, and flowers that are meticulously tended to.The cabin boasts a newly stained exterior as of June 2020, adding to its appeal, and creating a warm welcoming atmosphere. The interior is well - maintained, and thoughtfully updated, with solid oak flooring throughout and a living room featuring a newly relined chimney in February 2021 that adds warmth and character.A new water heater, and drainage line were installed in December 2020, enhancing convenience and efficiency. Two new HVAC units with Halo led to clean the air installed April 2022 the air ducts were thoroughly cleaned in November 2020, ensuring a fresh, and healthy environment. peace of mind for the residents. The cabin is equipped with termite protection installation in April 2021, with quarterly service and Bee treatment annually.Septic was inspected, and pumped 10/22, and a 50-amp generator hookup was installed so you can bring your generator and hook it up to the cabin. This cabin offers the best of both worlds - a peaceful escape in nature while still being within reach of amenities including high speed fiber optic cable to the cabin. Whether you're unwinding in the screened in back porch, or exploring the lush surroundings, this cabin is the ideal place to create lasting memories and enjoy the beauty of the great outdoors. CALL AND SET UP YOUR PRIVATE SHOWING TODAY...MAKE SURE TO CHECK OUT THE VIDEO AND CHECK OUT THE RIVER CREST DEVELOPMENT ON SOCIAL MEDIA ......
MlsNumber: 702814


Listing Provided By: CRYE-LEIKE, REALTORS, original listing
Name: CRYE-LEIKE, REALTORS
Phone: (865) 774-1414
Office Name: Crye-Leike Realtors
Office Phone: (865) 774-1414
Agent Name: Shawn Oaks
Disclaimer: Copyright © 2024 Lakeway Area Association of Realtors. 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