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

117 New Life Road
Rogersville, TN 37857
Melissa Carpenter with East TN Real Estate & Appraisal, original listing - (865) 500-4909

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,999
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2184 Square Feet
Agency: East TN Real Estate & Appraisal
Agency Phone: (865) 500-4909

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 27 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: WELCOME to Tennessee Highland Farm situated on 27.6 acres, in a serene valley surrounded by enchantingly beautiful East Tennessee mountains. Construction on the meticulously crafted, custom Timber Frame house began in 2022 and was recently completed in September 2024. Walking through the front door you will be greeted by a grand staircase and open concept living, dining and kitchen areas with a vaulted ceiling of knotty pine and oak hardwood flooring that complements the elegant oak cabinetry in the kitchen. Natural quarried Crab Orchard Stone from Crossville, TN surrounds the fireplace and woodstove. A 16x16 primary bedroom with ensuite that boasts a floor to ceiling tiled, walk-in shower is located on the main level. There is a large walk-in closet located in the primary bedroom. You will also find a half bath and a laundry room with washer/dryer hookup and utility sink on the main floor. At the top of the staircase is a second spacious living area, a large closet and plenty of room for a home office. Two bedrooms and a full bath with a soaker tub overlook the first floor from the balcony. An Automatic switch has been installed and ready for a generator. Enjoy quiet mornings and cool fall evenings sitting on the covered back porch observing wildlife and admiring a view of the pond fully stocked with blue gill and large mouth bass. A spacious front porch also adorns this one of a kind home. The property offers fully fenced/cross fenced pastures and two creeks. There is a 60X60 red barn with a tack room and corral. There are fruit trees, red raspberry bushes, black walnut trees, etc. High speed internet is available. This is an exceptionally beautiful property just waiting to become your family legacy! All information is deemed reliable from Hawkins County Tax Documents and Owner. Buyer and Buyer's agent to perform due diligence.
MlsNumber: --
ListingId: 9971700


Listing Provided By: East TN Real Estate & Appraisal, original listing
Phone: (423) 754-0439
Office Phone: (865) 500-4909
Agent Name: Melissa Carpenter
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