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

905 Leisure Lane
Sevierville, TN 37876

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $389,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1248
Agency: Jackson Real Estate & Auction

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2003
Notes: This home was built with 3 bedrooms; however, it was only permitted for a 2-bedroom septic. Live by the Lake! Permanent or overnight rentals (STR) are both permitted. This beautiful home is nestled in the foothills of The Great Smoky Mountains next to Douglas Lake on a paved country road and is just a few minutes from ALL the Smoky Mountain Attractions. This home has an open floor plan accented with cathedral ceilings, large main suite, split bedroom plan and a cozy fireplace with an insert for those winter chilled nights. There is a pantry and laundry closet, and a large kitchen complete with appliances. Relax in the mornings sipping your favorite beverage in the custom 10x20 Sunroom. Plenty of outside shade with the 10x7 covered front and rear porches. Bring the kids or the pets and enjoy the fenced yard. This home features a large 2 car detached garage, large 10x22 workshop and a 10x16 she-shed / he shed! Enjoy an evening on the private concrete patio. It's a great place for hot tub. Create memories and smores with the 12x13 firepit area. PLENTY of lake access with 2 gated boat launches- $75 annual fee. The home has a security alarm system as well as a ring doorbell. Improvements have been made to the home such as: Marathon Water Heater installed in 2017, Trane Heat Pump & Wi-Fi Thermostat installed in 2022, Genie Garage Door Openers installed in 2024, Shingle Roof is approximately 9 years old. Douglas Lake has over 550 miles of pristine shoreline. A boating and fishing paradise all with the backdrop of the Great Smoky Mountains within minutes of the home. Over 16 million people visit this area annually but only the very lucky ones get to call this place home. Call us today for your appointment to see this home.
MlsNumber: 703569


Listing Provided By: Jackson Real Estate & Auction, original listing
Name: Jackson Real Estate & Auction
Phone: (865) 548-4215
Office Name: Jackson Real Estate & Auction
Office Phone: (865) 397-4214
Agent Name: Kathy C. Derrick
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 = 2504 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 Cassie Clabough
Cassie Clabough
ASCIIMonarch Realty
Call Today!: (865) 405-6348

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App