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;

278 Little Fawn Lane
Lafollette, TN 37766
Debbi Gierat with Lakeside Realty, LLC, original listing - (423) 626-5820

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,650,000
Beds: 10
Baths: Full: 5, ½: 1
Status: Active
SqFt: 6484 Square Feet
Agency: Lakeside Realty, LLC
Agency Phone: (423) 626-5820

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2000
Notes: ''Field of Dreams'' could very well be your Lake Life Living Dream Come True! The perfect name for this custom built and masterfully designed Norris Lakefront home. From the moment you enter into the massive great room with soaring ceilings framing a wall of windows overlooking the breathtaking views across the broad waters of Norris Lake to Chuck Swan Wildlife Mngmt Preserve. Boasting a 6484 sqft split & open main floor plan with 9 bedrooms, 5 1/2 baths, hardwood floors, hand placed stone fireplace(s) both on main and lower level, custom cabinets, huge island (easily seats 6), speaker systems, maintenance free decks and patio with hot tub. Custom over sized windows thru out the 2 & 1/2 floors to bring the outdoors inside. Positioned on a 1.34 acre RARE level to Lake Lot, with NO steps. A paved path affords a gentle stroll or golf card ride (handicap accessible) to the 2 story, double slip dock with (2) Jet Ski Ports & (1) lift nestled along 280ft of shoreline. (Dock Permit on File) It literally feels as though you have your own Nature Park with all the bells and whistles of private Lakefront deep water year round Lake access! <br /> <br /> Located in well-known Lake Community, Deerfield Resort, boasting a myriad of amenities including but not limited to: private air strip, Golf Course, Pool, Tennis Courts and Marina!<br /> <br /> Property would make a fabulous executive family home or high income rental property. The property would be turn-key and has an outstanding guest rental history: $215K Gross Income for 2024 and an already total of $150K bookings for 2025. Primary Suite & and addl (2) Bedrooms and full bath on Main, En-suite and additional 2 Bedrooms down with a 10 bed bunk room and another 2 bedrooms & full Bath up stairs. Current owner has done an amazing job with updates including but not limited to: interior painting through out, new LVT flooring downstairs & has added 2 bedrooms and an additional full bath. There are 2 each, refrigerators and dishwashers to help you further entertain family, friends and guests. The list goes on and on! This is the home to ''See to Believe''! (Please note: Virtual Tour is prior to the many updates)<br /> <br /> Buyer and or Buyers agent to confirm details and any additional details of current Rental Management readily available upon request.
MlsNumber: --
ListingId: 1280483


Listing Provided By: Lakeside Realty, LLC, original listing
Phone: (828) 593-9929
Office Phone: (423) 626-5820
Agent Name: Debbi Gierat
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.


Local Real Estate Expert

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;
Candy Priestley
ASCIIAyers Auction Real Estate
Call Today!: (423) 215-0316

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App