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;

2811 Happy Hollow Road
Parrottsville, TN 37843

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 2359
Agency: Regal Real Estate Tn, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 41 acre(s)
Property Type: Residential
Year Built: 1977
Notes: ***41.2 UNRESTRICTED ACRES***Meticulously maintained house (2 homes) and farm with stunning mountain views in Parrottsville, Tn. These farms rarely ever hit the market in this coveted area of East Tn. especially a farm that has been cared for in the manner that this one has. You will find nothing out of place around the farm, and the main home has been maintained to the point that it's almost flawless.Main Home is 3br/3ba, updated kitchen with new cabinets and stainless steel appliances with gorgeous mountain views out the window over the kitchen sink.Enormous living room/dining area with gable ceilings, with a wall of windows to the front that provides ample lighting and views. A sliding glass door is to the rear of the room, that leads to the newly constructed deck on the rear of the home. A custom stone fireplace sits in the center of the living room and is easily the center of attention. The custom stone work is incredible. The fireplace is currently a propane insert for convenience but could easily be converted back to the original wood burning fireplace. All bedrooms have private baths attached, two of the bathrooms have been remodeled with walk in tile showers.2/3's of the downstairs is finished and has its own fireplace and den area as well. The unfinished section of the basement has a 3rd wood burning stove that has ventilation leading from the stove through ductwork to the upstairs rooms all of which was professionally installed. There is canned food storage area in the unfinished area as well. The basement is designed in such a way that a bathroom and/or bedrooms could be added on. Basement can be accessed from main home or from the attached two car garage. Home also comes with a matching 2nd detached garage or workshop that has an abundant amount of space and comes with several work benches.Home number 2 is a possible income producing property, that could help offset your mortgage. This cozy cabin was built in 2001, and is a 2br/2ba that could easily be an overnight rental, long term rental or guest house, numerous possibilities and upside. Farm has several barns/sheds as well as cattle working areas. A portion of the property is wooded and filled with nice mature hardwoods with ample amounts of wild game. There are open fields for pasture, hay fields, and a creek that runs through the eastern side of the property. Numerous house sites are still left with amazing views of the Cherokee National Forest. This one of a kind property is conveniently located 20 minutes from Greeneville, 15 minutes from Newport, 30-45 minutes from Sevierville, Pigeon Forge, Gatlinburg and the Smoky Mountains. It's an hour drive to Knoxville, Johnson City, Bristol and Asheville. An hour from 2 major airports, with multiple hospitals within 15-45 mins drive as well. These are motivated sellers and this will not last long, call me at (423) 237-1991 to schedule your appointment today. Multiple lenders in place and ready to get to work for you. Let's start moving your dreams into reality!!
MlsNumber: 702873


Listing Provided By: Regal Real Estate Tn, LLC, original listing
Name: Regal Real Estate Tn, LLC
Phone: (865) 908-4567
Office Name: Regal Real Estate Tn, LLC
Office Phone: (865) 908-4567
Agent Name: Darrin Costner
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App