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

176 Flat Hollow Marina Rd
Speedwell, TN 37870
Lisa Haskell with United Real Estate Solutions, original listing - (865) 444-2400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $970,000
Beds: 2
Baths: Full: 7, ½: 1
Status: Active
SqFt: 3802 Square Feet
Agency: United Real Estate Solutions
Agency Phone: (865) 444-2400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Other
Year Built: 2024
Notes: Two bedrooms plus Six extra guest/sleeping rooms plus large living areas will give everyone space to enjoy their privacy.Welcome to your dream home nestled amidst the breathtaking scenery of Norris Lake! This stunning new construction home offers an unparalleled fusion of modern luxury and rustic charm, all while showcasing captivating lake views. Step through the front door and be enveloped by the spaciousness of the interior. Sunlight streams through expansive windows, illuminating the open-concept living area adorned with high ceilings and stylish finishes. Imagine cozying up by the stone fireplace on cool evenings, or hosting gatherings with friends and family in the inviting atmosphere of the large kitchen, complete with brand new stainless steel appliances and granite countertops. Venture outdoors to experience the ultimate lake life adventure right in your backyard. Whether it's swimming, fishing, or boating, Norris Lake offers endless opportunities for outdoor recreation and relaxation. Spend lazy afternoons lounging on the expansive double decker lakefront dock, soaking up the sun's rays while taking in the panoramic views of the lake and surrounding mountains. For the adventurous at heart, Norris Lake is a playground waiting to be explored. Launch your boat from your private dock and embark on a day of water skiing, tubing, or simply cruising along the pristine shoreline. End your day with a leisurely stroll to Flat Hollow Marina to have your dinner. This home is expected to be completed by the end of May 2024. Home is not lake front, but dock lot it. Home is across the street, but has a beautiful lake view! Most photos are of a similar home with the same floor plan as this home is still under construction!
MlsNumber: --
ListingId: 1255572


Listing Provided By: United Real Estate Solutions, original listing
Phone: (865) 621-2040
Office Phone: (865) 444-2400
Agent Name: Lisa Haskell
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