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;

201 Crown Jewel Lane
Lafollette, TN 37766

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $11,997,000
Beds: 6
Baths: 10
Status: Active
SqFt: 13340
Agency: Realty Executives Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2023
Notes: This magnificent lake home offers 6 bedrooms, 6 baths, 4 1/2 baths and 13,340 sq ft of living space on 0.71 acre. Enjoy lakefront living at the Peninsula with panoramic views of the Chuck Swan State Forest and Wildlife Management Area in Lafollette, Tennessee. Great location. Close to Springs Dock Marina, Deerfield Resort and the Cedar Creek jumping bridge just minutes away by boat.<br /> <br /> Interior Amenities: cathedral ceilings throughout house, modern stairway with glass railings, open floor concept, large tile flooring, panoramic windows with Lutron automated blinds, modern style kitchen with all high-end Kitchen-Aid appliances, pantry with Beverage Air Horizon Series refrigerator & freezer, modern chandeliers and lighting, Master bedroom with dual sided fireplace and 2 HDTV's, panoramic window with balcony access, all Kitchen-Aid appliances, Master bath with his/her seperate vanities, walk-in shower, sauna room, modern tub and walk-in closet organizer system, Wet Entry with Elkay water fountain, Beverage Air refrigerator, Avantco ice Avantco cooler, Vulcan deep fryer, Beverage Air cooler, Bakers Pride pizza ovens, Vulcan oven/stove, Garland grill, Solwave microwave, Avantco cooler and Beverage Air cooler, whole house audio system, 2 Central vac systems, office, 2 laundry room, 2 Central vac systems and more.<br /> <br /> Exterior Amenities: modern pool with Jacuzzi, four car garage, outdoor ceiling fans, glass railings, landscaping, 2 outdoor stone fireplaces, outdoor kitchen, Alfresco grill with vent, Alfresco burners with vent, Avantco refrigerator, dual slip boat dock with walkway bridge.
MlsNumber: 1234565


Listing Provided By: Realty Executives Associates, original listing
Name: Realty Executives Associates
Phone: (865) 693-3232
Office Name: Realty Executives Associates
Office Phone: (865) 693-3232
Agent Name: Bo Caldwell
Disclaimer: Copyright © 2024 Knoxville 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