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

18128 Lighthouse Pointe Drive
Lenoir City, TN 37772
Joseph Ayres with WindRiver Properties, original listing - (865) 988-1864

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,990,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 5162 Square Feet
Agency: WindRiver Properties
Agency Phone: (865) 988-1864

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2008
Notes: Discover the epitome of lakeside luxury at this exquisite residence located in the prestigious WindRiver community. With 5162 square feet of meticulously designed living space, this home offers an incredible setting on Tellico Lake, designed to capture the breathtaking morning sunrise and expansive views across to Federal Protected Land. This property is a sanctuary of elegance and comfort, featuring a three-car garage, elevator, steps leading directly into the lake for easy access, and impeccable landscaping that enhances its serene lakeside setting. Put out your mooring ball and enjoy the summer lake in a quiet natural harbor. <br /> <br /> Inside, the home boasts four spacious bedrooms and four full bathrooms, plus a large office with a private bathroom that could serve as an additional ensuite. The oversized living room, dining area, and kitchen are designed to maximize the dramatic views of Tellico Lake and the Cumberland Mountains, creating an open, inviting space for entertainment and relaxation. The lower level with 12 ft ceilings includes a large family room complete with a full kitchen, 2 bathrooms, and 3 bedrooms alongside 1,000 sq ft of heated and cooled storage area with rear garage entry, perfect for lake toys and a work room. All appliances and TVs, including the washer/dryer and a freezer in the large laundry room, remain to ensure a seamless move-in experience.<br /> <br /> WindRiver Lakefront & Golf Community offers an array of exclusive amenities, including a 18-Hole Championship Bob Cupp Designed Golf Course, fine dining at the on-site restaurant, Citico's, a lakefront park for leisurely strolls, a community garden for green thumbs, a state-of-the-art fitness facility, a full-service marina, and a resort-style pool. Outdoor enthusiasts will appreciate the pickleball, bocce ball, tennis, and basketball courts, as well as 30 miles of scenic walking trails. Don't miss this opportunity to own a slice of paradise in one of the most exclusive communities in the region. Schedule your private tour today and experience the luxury, serenity, and unparalleled lifestyle this WindRiver masterpiece has to offer. Call now to make this dream home your reality!
MlsNumber: --
ListingId: 1259470


Listing Provided By: WindRiver Properties, original listing
Phone: (865) 988-1864
Office Phone: (865) 988-1864
Agent Name: Joseph Ayres
Disclaimer: Copyright © 2024 Knoxville Area Association of Realtors &#174;. 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 = 2479 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 Steve Larimer
Steve Larimer
ASCIIKnox Realty
Mobile: (703) 342-9163
Office: (865) 357-8800

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App