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;

3702 Lost Branch Rd
Sevierville, TN 37862

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,500,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1800
Agency: Your Home Sold Guaranteed Realty TN

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Property Type: Residential
Year Built: 2011
Notes: BUY THIS HOME AND GET $22,000+ in savings GUARANTEED! Buy this awesome home with $0 Down and up to 2 mo. No Payments. Buy this home if YOU Are Not Satisfied in 24 Months I'LL Buy It back or SELL IT FOR FREE NO Gimmicks! For information on this exclusive Buyer Protection Plan, call the listing agent directly see info below Bonus 1 ** Love it or Leave it Guaranteed! Buy this home if YOU Are Not Satisfied in 24 Months I'LL Buy It back or SELL IT FOR FREE NO Gimmicks! A $16,000+ value to our VIP buyers! Bonus 2 **Don't get stuck owning two homes. BUY THIS HOME, I WILL BUY YOURS! If you are looking to buy a home but have one to sell, you are finding yourself in the same dilemma that most homeowners find themselves in. We can help! To discuss the details of this incredible option, call the listing agent or for a free report on this exclusive offer and how it works visit my website see below for info ** Bonus 3 **This home comes with a 12 Month Limited Home Warranty ($500 VALUE), a $500 lender credit, $300 attorney credit, $100 home inspection credit for our VIP buyers. Call to become a VIP Buyer! Bonus 4****This home qualifies for a 1% buy down rate for our VIP buyers ***************************************************** A cabin developers dream!!! ~12.5 acres, just outside Pigeon Forge city limits, off Wears Valley, situated next to Black Bear Ridge Cabin Resort, surrounded on all sides by highly lucrative rental cabins, already zoned & approved for overnight cabin rentals (or primary residence), was originally 6 lots (~5.5, 1.75, 1, 1, 1.5, 1.5 acres respectively), and can be subdivided! This prime property currently has 2 homes and a trailer onsite, one of which is an only 12 year old custom built home with 3 beds, 2 bath, fantastic kitchen, large bedrooms, and gorgeous master ensuite. The other home is a 1930 2/2 that is almost 1,700 square feet, while the trailer is a 2011 model, 3/2, with ~1,350 square feet. Multiple access drives + unfinished roads, this land already has 4 fill lines, and 2 wells! Make this your family compound, private retreat, subdivide & fill it with overnight rental cabins, or develop it into the next multi-million dollar resort!
MlsNumber: 11241200


Listing Provided By: Your Home Sold Guaranteed Realty TN, original listing
Name: Your Home Sold Guaranteed Realty TN
Phone: (865) 365-1670
Office Name: Your Home Sold Guaranteed Realty TN
Office Phone: (865) 365-1670
Agent Name: Tannor Giles
Disclaimer: Copyright © 2024 My State MLS. 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