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;

165 Pleasant View Road
Bulls Gap, TN 37711
Michael McNeese with Century 21 Legacy - Greeneville, original listing - (423) 639-6781

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $885,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4994 Square Feet
Agency: Century 21 Legacy - Greeneville
Agency Phone: (423) 639-6781

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Custom 4BR/4BA Private Estate with 16.8 Acres, almost 5,000 ft2, exceptional Mountain Views, huge stocked pond, detached garage with bath. Most of the hardwood flooring and baseboards have been sourced from the property including red and white oak, Ash, and Hickory. The main level of the home has 2 ramps for easy access. The main level features a large kitchen with all appliances, wood custom cabinets, that flows into a fabulous sunroom/great room that is 24X32 with a wall of windows to take in the views of the property and the Appalachian Mountains in the background. Off of the great room is another large living area that leads into the foyer. There is a convenient half bath located off the foyer as well as the laundry room. Also on the main level is the primary suite that features a full bath with tub and walk-in shower, a sitting room, and a walk-in closet. The lower level of the home holds another bedroom, a den with a brick hearth and wood or coal burning stove, a bar, equipment room and a bonus room if another bedroom or office option is needed. There is also a half bath, walkout level 2 car garage and best of all the same gorgeous views from the windows! On the upper level there are 2 more large bedrooms and a full bath. The home has 9ft ceilings on the main level and basement, 8ft ceilings upstairs, and it also has 2 heat pumps to service the different zones. There is also public water with a step up pump to upstairs. Heading outdoors, there is a massive pond (estimated at 1 acre) that is stocked with catfish, bass, bluegill and is approximately 20-25 ft deep at the dam. There is a detached garage/shop that features a full bath as well as a full RV hookup site. The property also features lots of fruit trees and an abundance of wildlife, mainly deer and turkey.
MlsNumber: --
ListingId: 9976975


Listing Provided By: Century 21 Legacy - Greeneville, original listing
Phone: (423) 552-5330
Office Phone: (423) 639-6781
Agent Name: Michael McNeese
Disclaimer: Copyright © 2025 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