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

2975 Rocky Springs Road
Bean Station, TN 37708

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1516
Agency: Crye-Leike Lakeway West

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 85 acre(s)
Property Type: Residential
Year Built: 1996
Notes: *****First Time On The Market*****Have you dreamt of your own custom, cozy cottage in the forest? This diamond-in-the-rough is hand-crafted from white oak harvested from these amazing woodlands. Thoughtfully built, large windows invite nature in, decks and porches allow you to enjoy. There are three bedrooms and two baths. One bedroom and one bedroom are unfinished and ready for your touches. This sturdy home has endless potential. Here, you can make this property your own.There are eighty-nine drop-dead gorgeous acres facing Cherokee Lake and The Clinch Mountain Gap! Gorgeous views. From the front porch you can watch the lake sparkle year-round. The property has a wet weather spring that creates am awe-inspiring waterfall and fills the seasonal duck pond. Seller says wood ducks previously lived on the pond.There are two pastures and an area for a large garden. Two small original barns show ancient Appalachian building techniques. Entering this driveway is thrilling. The one third mile long quintessential gravel-path through the woods is enchanting every time. Any stress will evaporate.The property has several building sites so it would also be good for a developer. This land is fully pedestrian with the maximum slope being approximately thirty percent. Wild life abounds here in these never-timbered woods. Don't let this one get away, take a moment to stop by and look at this incredible property. You won't be sorry.All information taken from CRS and Seller and deemed reliable Buyer is responsible for verifying information to their satisfaction.
MlsNumber: 702089


Listing Provided By: Crye-Leike Lakeway West, original listing
Name: Crye-Leike Lakeway West
Phone: (423) 586-4115
Office Name: Crye-Leike Premier Real Estate LLC
Office Phone: (423) 586-4115
Agent Name: Traci Rodimon
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