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 = 2433 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 = 2433 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 = 2433 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;

125 Fox Lane
Lafollette, TN 37766

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 1
Baths: 2
Status: Active
SqFt: 790
Agency: resultsmls.com

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1988
Notes: AGENTS: Please see special instructions on MLS listing for property contact info.<br /> <br /> Cozy Log Cabin in Big Creek on beautiful Norris Lake! This charming cabin boasts approx. 135 ft. of water frontage with a gently sloped lot and includes a covered 1 bay dock with swim platform. TVA Dock permit and year-round deep water with brand new concrete steps for dock gangway. The exterior is completely renovated. Within the last 12 months, Logs have been cleaned, caulked, resealed, new gutters and roof. The Cabin features 1-bedroom, and full loft that sleeps 4. 1 1/2 baths. The interior has been completely updated and the full bathroom remodeled. The interior has many unique accents, including walls, ceilings and moldings of barn wood, redwood, oak and several other wood types. The cabin features tons and tons of outdoor space including a side deck off the kitchen that is great for grilling. The screen porch is facing the lake plus a sitting area beneath the screen porch to relax and enjoy evenings with family & friends. This cabin sits on a wooded lot giving you lots of privacy. It truly feels like you are in a treehouse looking at the lake. The lot has plenty of room to add an addition if needed. Nice level driveway to the home and great curb appeal. If you are looking for a home away from home, this is it! Electric heat and air with Starlink internet service. Won't last long in today's market! Currently a successful Airbnb and has income potential. CALL TODAY! All measurements are approximate. Buyer to verify.
MlsNumber: 1247354


Listing Provided By: resultsmls.com, original listing
Name: resultsmls.com
Phone: (615) 822-5808
Office Name: ResultsMLS.com
Office Phone: (615) 822-5808
Agent Name: Phil Hopewell
Disclaimer: Copyright © 2024 East Tennessee 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