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

846 Browns Chapel Road
Parrottsville, TN 37843

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $715,000
Beds: 2
Baths: 2
Status: Active
SqFt: 968
Agency: Envision Realty Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Property Type: Residential
Year Built: 2004
Notes: This property is joined with parcel ID/Tax 043 022.09 to make this property equal 15.11 +/- acres. Centrally located is a man-made pond, spring fed. Located in close proximity are 2 cabins; the first cabin is on the right as you access the property. It is fully furnished with a full kitchen, bath with shower, one bedroom in a loft, containing a queen bed. The second cabin will need some furnishings and a queen mattress for the bed. There is a full kitchen, bath and shower also has a loft that a mattress could go for extra persons sleeping. Each cabin has a queen bed. Each cabin has its own septic tank with field lines. At the big pond there is a structure with electricity but no water. It has a large porch overlooking the pond. There are a total of 6 additional cabins located on the property that are primitive. There is underground electricity to the cabins but not water. Down at the big pond there is a bath house with a sink, shower and toilet for the primitive cabins. There is also a large, covered pavilion located in close proximity to the pond for outside cooking and tables to eat on. This was used for family reunions and parties. Behind Cabin 2 there is a game room with a pool table, a jukebox and dart board. Inside the game room also is a bar for you to have parties also. The game room also has a bathroom for your guest. There is still plenty of room on the property for more cabins if one needs to build more. There is a road around to the cabins, but a few trees are down, so it is a beautiful walk around the hill to see all the cabins through the forest. There are a lot of large hardwood trees on the property including oak, maple and popular are a few of the large trees. This property is absolutely a magnificent investment for a large family or for investment for a cabin rental, retreats, or just to get back to nature. Buyer and buyer's agent to verify all information is correct.
MlsNumber: 9964238


Listing Provided By: Envision Realty Group, original listing
Name: Envision Realty Group
Phone: (423) 525-5767
Office Name: Envision Realty Group
Office Phone: (423) 525-5767
Agent Name: Libby Kickliter
Disclaimer: Copyright © 2024 Tennessee Virginia Regional Multiple Listing Service. 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