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','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;

891 Ness Lane
Greenback, TN 37742
Debbie Spencer with Keller Williams, original listing - (865) 977-0770

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,249,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3840 Square Feet
Agency: Keller Williams
Agency Phone: (865) 977-0770

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 19 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 1973
Notes: This incredible and unique property is situated on almost 20 acres with 1800 feet of waterfront on the Bass filled and multiple spring fed Hammondtree Lake!. The recently remodeled main home is 3240 square feet and has a 2 car ''detached'' garage (but connected by a tunnel) and additional 600 square foot guest house or rental apartment. Other features include an in ground swimming pool with enclosed equipment room, a safety fence and a new 1200 square foot wood entertaining deck! There is an old pole barn with stalls and equipment storage areas, level and gently rolling pastoral land and wooded areas. The garage and apartment are connected by a service tunnel for added security and safety. The main home upgrades include a metal roof, two fireplaces 3 bedrooms, 3 bathrooms, new kitchen cabinetry, stainless appliances, new paint, tiled walk-in showers, new flooring (tile & wood throughout), new exterior stone and wood siding, HVAC unit is only 2 years old, and so much more. You'll love the large dining area overlooking your private lake and covered porches and uncovered decks that are featured in both the main and guest home. Build a dock and go fishing every day on the private lake. Privacy and peace at its finest! This is luxury living, a prepper's paradise and small farm all in one! With a strong water well, independent septic tank, fenced pastures, you just add solar and this property can be off grid! The electrical panel has a brand new emergency backup EcoFlow Smart Panel 2, which can be powered by solar, a generator or the EcoFlow DELTA Pro Ultra. The long private driveway gently follows the lake, could be gated for added security, and circles around to the main home and other structures. All this on UNRESTRICTED land! Priced to sell, taking your best offer now. This incredible and unique property is situated on almost 20 acres with 1800 feet of waterfront on the Bass filled and multiple spring fed Hammondtree Lake!. The recently remodeled main home is 3240 square feet and has a 2 car ''detached'' garage (but connected by a tunnel) and additional guest house or rental apartment. Other features include an in ground swimming pool with enclosed equipment room, a safety fence and a new 1200 square foot wood entertaining deck! There is an old pole barn with stalls and equipment storage areas, level and gently rolling pastoral land and wooded areas. The garage and 600 square foot apartment are connected by a service tunnel for added security and safety. The main home upgrades include a metal roof, two fireplaces 3 bedrooms, 3 bathrooms, new kitchen cabinetry, stainless appliances, new paint, tiled walk-in showers, new flooring (tile & wood throughout), new exterior stone and wood siding, HVAC unit is only 2 years old, and so much more. You'll love the large dining area overlooking your private lake and covered porches and uncovered decks that are featured in both the main and guest home. Build a dock and go fishing every day on the private lake. Privacy and peace at its finest! This is luxury living, a prepper's paradise and small farm all in one! With a strong water well, independent septic tank, fenced pastures, you just add solar and this property can be off grid! The electrical panel has a brand new emergency backup EcoFlow Smart Panel 2, which can be powered by solar, a generator or the EcoFlow DELTA Pro Ultra. The long private driveway gently follows the lake, could be gated for added security, and circles around to the main home and other structures. All this on UNRESTRICTED land! Priced to sell, taking your best offer now.
MlsNumber: --
ListingId: 1295474


Listing Provided By: Keller Williams, original listing
Phone: (423) 404-8174
Office Phone: (865) 977-0770
Agent Name: Debbie Spencer
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 = 2479 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 Danielle Belcher
Danielle Belcher
ASCIIRealty Executives
Call Today!: (386) 663-5504

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App