Title Page Background
DEBUG FN args: Array ( [0] => 2460 [1] => [2] => [3] => agent ) BEFORE: Site: 2460 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2460 Igate: njhud LocID: 2460 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2460 AND i.igate IN ('mihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2460 [1] => [2] => [3] => lender ) BEFORE: Site: 2460 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2460 Igate: njhud LocID: 2460 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2460 AND i.igate IN ('mihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2460 [1] => [2] => [3] => other ) BEFORE: Site: 2460 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2460 Igate: njhud LocID: 2460 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2460 AND i.igate IN ('mihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

6827 Snake Hollow Rd
Sneedville, TN 37869

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2253 Square Feet
Agency: Your Home Sold Guaranteed Realty TN

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Refrigerator, Dryer
Architectural Style: Other
Construction Materials: Log, Log Siding
Cooling: Central A/C
Flooring: Carpet, Vinyl, Hardwood
Heating: Heat Pump
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Dining Room

Window Features

Parking Features: Garage, Garage - Detached
Roof: Metal
View: Mountain

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Cabin
Year Built: --
Notes: 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 TODAY. If you would like to get the CURRENT price of this home, or for the most up-to-date information on this home, call the actual listing agent! ***************************************************** Imagine your very own piece of PARADISE in Eastern Tennessee! Surround yourself with your very own waterfall, 3 creeks, and a SPRING that even brings fresh spring water into your home YEAR ROUND! Listen as the sound of nature dances all around you and heals your spirit. Keep your eyes peeled as wildlife of all kinds knocks on your doorstep and frolics in the six and a half acres that surround you on this lulling wooded softly sloping hillside. The main home on the property features TWO levels of gorgeous front decks that beckon you to sit outside and listen to your very own waterfall and birds singing in the trees. Its history dates back to when it originally was a Mill House and now transformed into a warm, cozy home. Inside features rustic and vintage touches that accentuate the overlap of classic and contemporary, with a highly-functional kitchen and wooden and gas stoves that state self-sufficiency is #1 on the list. Three full stories allow for functionality and growth. The neighboring 1200 square foot guest house features 4 bedrooms and a compostable toilet, and gives an open edge to create a homestead or just appreciate the convenience to have separate lodgings to family or guests. Across the drive, a huge 48' x 56' workshop and 12' x 33' greenhouse also add a farm-feel to this uniquely one-of-a-kind property and give it so much versatility already, with plenty of room to still add to it if needed! Get your pre approval letter ready and contact the listing agent today to schedule your private showing! Make this piece of history your very own PARADISE to enjoy EVERYDAY!! ****************************************************** YOUR HOME SOLD GUARANTEED, OR I WILL BUY IT. That's right, if you list your home through me and it does not sell, I will buy it myself. To see more about my Guaranteed Sale Program, call me directly. Seller and Agent simply must agree upon the price and time of possession.
MlsNumber: --


Listing Provided By: Your Home Sold Guaranteed Realty TN, original listing
Phone: (865) 505-8215
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App