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

789 Waterfront Way
Ten Mile, TN 37880
Teresa Congioloso with Keller Williams Ridge to River, original listing - (423) 664-1900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,425,000
Beds: 4
Baths: Full: 3, ½: 2
Status: Active
SqFt: 4400 Square Feet
Agency: Keller Williams Ridge to River
Agency Phone: (423) 664-1900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Come Home to Lakeside Coves.<br /> Discover the perfect harmony of refined elegance and serene natural beauty in this stunning lakefront estate with year round water access on the pristine shores of Watts Bar Lake. Situated in the exclusive Lakeside Coves gated community, this custom-built 4-bedroom, 3 full bath, and 2 half bath home is a rare gem designed for the most discerning buyer. Nestled at the end of a cul-de-sac, this home offers a exceptional outdoor living, boasting a quality built covered dock with an electric hoist lift, a swim deck, and unparalleled access to year-round deep water. Enjoy outdoor living at its finest with a screened porch off the kitchen, an open deck with a cozy gas fire pit and lower-level patio deck wired and reinforced for a spa or sauna. Step inside the elegant interior, and be greeted by a bright, airy interior featuring towering vaulted ceilings and crisp black-framed windows that perfectly frame breathtaking lake views. The open floor plan boasts a striking fireplace with custom storage and display shelving a gourmet kitchen with an oversized accent island, Zline gas range with double ovens, prep sink, matte finish quartz countertops and a walk-in pantry and a laundry room so thoughtfully designed it could double as a home office. The main-level features luxurious primary suite is a view-ti-ful oasis featuring Large windows with built-in blinds overlooking the lake and spa-like en suite with a freestanding soaking tub, separate shower, double vanities, and an enviable walk-in closet. The walkout lower level retreat offers a large den, full wet bar with drink cooler, sink, and cabinetry, plus three additional bedrooms. You'll also find expansion space perfect for a media room or gym, safe/storm room for peace of mind and Dedicated outdoor toy storage.<br /> Extra Features:<br /> Tankless water, lake irrigation system, whole-house generator for reliability, a dog bath for your pets.
MlsNumber: --
ListingId: 1504224


Listing Provided By: Keller Williams Ridge to River, original listing
Phone: (423) 421-7852
Office Phone: (423) 664-1900
Agent Name: Teresa Congioloso
Disclaimer: Copyright © 2024 Greater Chattanooga 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