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

2625 Snake Hollow Rd
Sneedville, TN 37869
Jeanette McKendry with Realty Star Group SC LLC, original listing - (864) 907-7076

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,700,000
Beds: 7
Baths: Full: 4
Status: Active
SqFt: 4325 Square Feet
Agency: Realty Star Group SC LLC
Agency Phone: (864) 907-7076

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 332 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: Exceptional turn-key property where luxury meets Hunting Retreat! Discover the ultimate primary estate, Income form AirBNB or occasional getaway with this remarkable 333 acre hunting lodge, located in the serene mountains of Sneedville, Tennessee. This secluded property offers unparalleled privacy and an impressive array of features tailored for outdoor enthusiasts including creek, stream and Ponds. Property Highlights: 333+ Acres of Prime Hunting Land, 5 Miles of Trails for exploration and accessibility, 4 Acres of Food Plots to attract and sustain wildlife, 15 Deer Stands strategically positioned for optimal hunting, and Multiple Ponds enhancing the natural beauty and habitat. At the heart of the property is a stunning newly constructed 4,500+ sq. ft. barn dominium, seamlessly blending modern comforts with rustic charm. Barn dominium Features: 7 Spacious Bedrooms and 4 Full Bathrooms, Open-concept layout with expansive recreational areas, Granite Countertops and Stained/Polished Concrete Floors, Covered Porch perfect for relaxing and enjoying Mountain View's, Workshop/Garage for all your storage and project needs. Versatile Opportunities: Whether you're seeking a hunting retreat, a lucrative short-term rental property (Airbnb potential), or a unique primary residence, this property delivers unmatched flexibility. Priced at $1.7 million, this rare opportunity offers a turnkey experience with all amenities thoughtfully designed and ready to enjoy. Contact us today to schedule your private showing!
MlsNumber: --
ListingId: 11382362


Listing Provided By: Realty Star Group SC LLC, original listing
Phone: (843) 653-5264
Office Phone: (864) 907-7076
Agent Name: Jeanette McKendry
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