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

3774 Edgewater Way
Louisville, TN 37777
Lucas Haun with Keller Williams Signature, original listing - (865) 588-9300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,400,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 6585 Square Feet
Agency: Keller Williams Signature
Agency Phone: (865) 588-9300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2007
Notes: Located in the lakeside community of Lashbrooke, this grand home offers some of the best waterfront living with lovely water views and ample space for living. Up the brick paved drive and off of the covered front porch, this home unfolds showcasing beautiful hardwood floors, moldings, and custom touches throughout. Left of the foyer is an amazing home office or personal library. With a vaulted ceiling, exposed beams, and ample built-ins, this space yearns for your book collection; mementos from your travels; or frames upon frames holding precious photographic memories. To the right of the foyer is a bright formal dining space with a large picture window and ample room for hosting dinners. The primary living space is large, offering room for multiple seating areas and has coffered ceilings, custom built-ins and a large focal fireplace. With views of the water and access to the rear patio, this space will surely be the central location for you to entertain your family and guests. This kitchen! With an oversized island/breakfast bar, six-burner gas cooktop, beverage fridge, ice maker, stainless appliances, and so much cabinetry for all your gadgets, china, glassware and serving pieces, this kitchen can handle meals for any number of people! An adjacent dining room allows for more informal dining and daily meals and flows directly into an additional informal living space - where you can unwind and relax after a long day - has views of the water, fireplace, custom built-ins and access to the back terrace. The primary suite is on the main level and has its own sitting room where morning coffee can be enjoyed in solitude. The attached bath offers dual vanities, walk-in shower, soaking tub and a large walk-in closet with built-ins for all your dresses, suits, bags and shoes. The upstairs offers additional living space with a fireplace and three large bedrooms and two additional full baths. The outdoor terrace has ample room for dining or seating and also has a large stack stone fireplace for cooler nights or when the craving for s'mores cannot be denied! The lawn is lush and extends all the way to the water and it is a beautiful canvas unto itself or a canvas to create and design what you have always imagined for exterior living.
MlsNumber: --
ListingId: 1298253


Listing Provided By: Keller Williams Signature, original listing
Phone: (865) 694-5904
Office Phone: (865) 588-9300
Agent Name: Lucas Haun
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','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;
Real Estate Expert Photo for Alexandra Hughes
Alexandra Hughes
ASCIIKeller Williams Signature Real Estate
Call Today!: (865) 603-1320

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App