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

5719 Lakeshore Drive
Tallassee, TN 37878
Nola Collins with Tennessee Mountain Real Estate, original listing - (865) 980-8830

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $748,500
Beds: 3
Baths: Full: 2, ½: 2
Status: Active
SqFt: 2841 Square Feet
Agency: Tennessee Mountain Real Estate
Agency Phone: (865) 980-8830

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1999
Notes: Private Lakefront Retreat in the Smokies.<br /> Experience the ultimate lakefront lifestyle in this stunning lake lodge nestled in the heart of the Smokies. Enjoy serene waterfront living with 150 feet of private shoreline on the pristine ''Lake in the Sky'' - a crystal-clear, spring-fed lake where only trolling motors are allowed, ensuring peaceful surroundings perfect for sailing, kayaking, paddleboarding, fishing, and swimming.<br /> Located just 30 minutes from Knoxville Airport, 40 minutes from Tail of the Dragon, 45 minutes from Cades Cove, and an hour from Pigeon Forge and Gatlinburg, this property offers unparalleled access to world-class hiking, scenic drives, and outdoor adventures.<br /> Property Features:<br /> Spacious Lake Lodge with 3 bedrooms, 2 full baths, 2 half baths, plus an office and/ or craft room - music room.<br /> Primary suite on the main level with walk-in closet.<br /> Open-concept living with cathedral ceilings and two fireplaces<br /> Kitchen with solid-surface countertops<br /> Sunroom, screened porch, and a wrap-around covered porch with breathtaking lake views<br /> Lower-level recreation room with additional storage<br /> Outdoor & Additional Amenities:<br /> Whole-house generator for peace of mind<br /> Private boat dock with covered area<br /> Fishing boat, canoe, paddle boat, and kayak included<br /> Newer furnace (2 years) and water heater (3 years)<br /> Whether you're looking for a full-time residence, vacation home, or investment property, this lakefront retreat offers a rare blend of seclusion, natural beauty, and modern comforts.
MlsNumber: --
ListingId: 1293659


Listing Provided By: Tennessee Mountain Real Estate, original listing
Phone: (865) 980-8830
Office Phone: (865) 980-8830
Agent Name: Nola Collins
Disclaimer: Copyright © 2025 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 = 2431 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;
Real Estate Expert Photo for Melony Colquitt
Melony Colquitt
ASCIIKeller Williams Realty - Maryville
Call Today!: (865) 384-7937

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App