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
Donald Fabrikant with Country Living Realty, original listing - (423) 430-9012

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4994 Square Feet
Agency: Country Living Realty
Agency Phone: (423) 430-9012

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: Welcome to this exquisite 2-story brick, basement ranch home, perfectly nestled on 16 acres of serene countryside, offering unmatched privacy and breathtaking natural beauty. Built in 2002, this expansive residence boasts nearly 5,000 square feet of living space, providing a perfect blend of comfort and luxury. The home features a thoughtfully designed layout, starting with the main floor, where you'll find the elegant primary bedroom complete with a full bathroom, a spacious walk-in closet, its porch and a cozy sitting room. There is a stunning 24 x 32 sunroom, enveloped by windows that fill the space with natural light and offer picturesque views of the surrounding landscape. This sunroom connects to the front covered porch and is just off the well-appointed 20 x 22 kitchen, which is equipped with ample cabinetry and all appliances, perfect for both everyday meals and entertaining. The main floor is adorned with beautiful hardwood floors, crafted from timber sourced right from the property. Except the primary bedroom. Adding a unique and personal touch to the home. Upstairs, two generously sized bedrooms, a full bath, and a welcoming sitting room provide additional space for family or guests. The finished basement is a true retreat, featuring a large bedroom, a cozy living room with a wood stove, four storage rooms, a full bathroom, and a bar area which is ideal for relaxing or hosting gatherings. Walk out onto a porch that is the length of the house. It has large pieces of cut granite. In addition to the attached 1-car garage, the property includes a detached 1-car garage with its own full bathroom. For those who enjoy RV travel, there is a full hook-up RV site conveniently located next to the detached garage. Additional outbuildings include a lean-to and a shed for extra storage. Approximately 12 acres of the property are wooded, creating a natural haven perfect for outdoor enthusiasts. A large fishing pond adds to the property's charm, providing a peaceful retreat right in your backyard. The home is equipped with public water and a water softener that has never been used. With its blend of luxurious living spaces and expansive outdoor areas, this property is a rare gem that offers both comfort and seclusion. Morristown and Greeneville are roughly 30mins. For all your shopping needs and offers many medical facilities to choose from.
MlsNumber: --
ListingId: 302336


Listing Provided By: Country Living Realty, original listing
Phone: (423) 430-9012
Office Phone: (423) 430-9012
Agent Name: Donald Fabrikant
Disclaimer: Copyright © 2024 Great Smoky Mountains 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