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','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 = 2455 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 = 2455 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;

1039 Cherokee Drive
Bean Station, TN 37708

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3466
Agency: Crye-Leike Lakeway West

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Residential
Year Built: 1964
Notes: Here is the Farm on the lake you have been looking for! This gorgeous property has 9.26 acres and agricultural rights to the TVA land in front of the house. Dreaming of your own Horse Farm? Want chickens? Love Lake Life? Want space to store your vehicles inside? Homesteading? Hobby Farm? Personal Paradise? Flower Farm? Here is the Farm on the lake you have been looking for! This property has all the potential. And all the buildings, there is a detached 24 x 40 two bay garage, a large workshop, 17 x 58 equipment shed, an incredible 32 x 40 two story barn with attached 28 x 40 shed, two bay garage and there is another detached carport. Both fenced pastures are walkable. Access to the home is via a paved driveway with a slight curve that rises to the back of the home where there is an impressive double carport.The home is spacious and comfortable with an incredible great room,dining room, kitchen combination that makes this home perfect for entertaining. The Great room is large enough for a full set of large furniture, a dining room set and a pool table with enough room left for people. It is an amazing, versatile space that has gorgeous water views. The home's floor plan offers versatility. For example, the dining room could also make a really nice library/den and one would still have space to set up a dining table elsewhere in the home. Situated in lush, mature neighborhood. The home is on Cherokee Drive right across from the lake. This home will always have an amazing view. Because the land across the street is TVA protected nothing will be built between you and the lake. Due to TVA protection, the property is not dockable. Tying out is permitted. Boat dock/public ramp are both 5 minutes away. All information taken from CRS and Seller and deemed reliable. Verifying all information is Buyer's Responsibility. Sold as-is, where-is. Drone Photos are used in This Listing.
MlsNumber: 703214


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