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;

3630 Kenyon Road
Parrottsville, TN 37843

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,900
Beds: 3
Baths: 3
Status: Active
SqFt: 2820
Agency: REMAX Rising JC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Property Type: Residential
Year Built: 2005
Notes: Welcome to your mountain oasis at 3630 Kenyon Rd, Parrotsville, TN. This charming property boasts breathtaking views and a plethora of amenities, making it the perfect retreat for those seeking tranquility and comfort.<br /> <br /> As you enter the property, you'll be greeted by the winding paved driveway, flanked by picturesque pasture areas on both sides. The tranquil sound of your very own creek sets the tone for the serene environment awaiting you.<br /> <br /> Inside, the home offers a perfect blend of functionality and comfort. The main level features a primary bedroom, office space, and a den adorned with gas logs and a bay window offering captivating mountain vistas. The spacious laundry/mudroom boasts built-in storage for added convenience.<br /> <br /> Upstairs, you'll find additional bedrooms, including a flex room that can be utilized asa office or craft room providing ample space for your hobbies and creative endeavors.<br /> <br /> Step outside onto the oversized front porch to soak in the panoramic views of the mountains, or explore the property's outdoor offerings, including a shed ready for equipment or coverting into barn area, a storage building, and a garage area.<br /> <br /> Don't miss the opportunity to make this mountain oasis yours.Some of the information in this listing may have been obtained from a 3rd party and/or tax records and must be verified before assuming accuracy. Buyer(s) must verify all information.
MlsNumber: 9964186


Listing Provided By: REMAX Rising JC, original listing
Name: REMAX Rising JC
Phone: (423) 620-8531
Office Name: REMAX Rising JC
Office Phone: (423) 620-8531
Agent Name: Kimberly Hock
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