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

1059 Long Spur Trail
Dandridge, TN 37725

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $789,900
Beds: 2
Baths: 2
Status: Active
SqFt: 2450
Agency: Franklin Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2005
Notes: Enjoy all seasons at this quiet respite nestled in a cul-de-sac amongst the trees on the shores of a lovely waterfront on beautiful Douglas Lake. Located just minutes from Tennessee's Interstate 40 and 81 this charming home is close to Dollywood, Gatlinburg, Smoky Mountains and a host of other attractions. The home is fully furnished and ready for you to enjoy this summer. You will find it accommodates four rooms as sleeping quarter choices. The lower-level entertainment room is well suited for bunk beds, if needed to accommodate additional guests, and has a full bath. This room opens to a large screened in porch that accesses the stairs to your lakeside dock. The main floor offers two choices of sleeping quarters and a full bath. Also on the main floor is the kitchen with stainless steel appliances, center island, and dining area that all open to the great room with a couch and chairs surrounding a gas fireplace. Step out the doors in the all glass front wall from either the great room or kitchen and enjoy the expansive deck overlooking the pristine green waters of the lake. Under the deck is a very large, secure storage area for all your lake toys. Your upper loft master has an overlook that can serve as an office or reading nook and provides a stunning view of the mountains and the lake. To the rear is the primary bedroom featuring an ensuite with a jetted tub and a shower. Added features / uses: 1) recreation room has a pool table, wet bar, and mini fridge. 2) Screened room can accommodate multiple tables for a large number of people. Also, a great NAP AREA TOO! Picnic station if you choose. Overnight rentals are permitted. What better way to have a ''paid vacation'' home! Your option. This location connects within 1 to 6 hours so many places to enjoy from Nashville, TN/Greeneville, S.C. to include the Carolina Coastline ''blowing Rock, N.C.'', etc. Mini vacations galore while having no ''state income tax'', low utilities, pleasant weather and so much more. Come On Home ''Lakeside breezes'', ''boating-kayaks/canoes - ski and fish'', ''hike and bike''. Look up Cades Cove, TN. Google Dandridge/Douglas Lake-Sevierville-Pigeon Forge-Gatlinburg-Great Smoky Mountains - See ya soon!
MlsNumber: 703827


Listing Provided By: Franklin Realty, Inc., original listing
Name: Franklin Realty, Inc.
Phone: (865) 484-0660
Office Name: Franklin Realty
Office Phone: (865) 484-0660
Agent Name: Tammy Franklin
Disclaimer: Copyright © 2024 Lakeway 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.


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 = 2471 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 Jennifer Scates
Jennifer Scates
ASCIIWallace Real Estate
Call Today!: (404) 403-9855

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App