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

48595 Us 127
Pikeville, TN 37367
Amy Backstrom with eXp Realty, LLC, original listing - (888) 519-5113 xx101

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $795,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2736 Square Feet
Agency: eXp Realty, LLC
Agency Phone: (888) 519-5113 xx101

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 21 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1991
Notes: Welcome to this DREAM Mountain View RETREAT! This one-of-a-kind property offers unmatched opportunities of privacy, scenic mountain views, and rental INCOME potential all in one property listing! This property showcases a Primary Home residence with an additional GUEST HOUSE and CABIN. The property is situated on 21.5 Acres listed in the Greenbelt program with stunning mountain views and a seasonal waterfall. Inside the home you will find over 2,700 square feet with open floor plan including 3 beds and 3 baths (each bedroom with its own ensuite). In the Kitchen, note the Quartz countertops, extra cabinet storage, and spacious laundry area. Outside, take in the mountain air and enjoy the scenic views from the back deck complete with hot tub. Entertain past sunset while being illuminated by the outdoor lighting set for evening entertainment. Host several of your friends and family with the accommodations from the Guest House and Cabin! The Guest House features over 800 square feet with one bedroom and one bath, ideal for extended family, a caretaker, or additional rental income. The Cabin has over 950 square feet of living space with 1 bedroom, and 1 bath including a spacious upstairs loft area. The Cabin comes furnished almost ready for arriving guests! Easy to ensure privacy at each dwelling as each residence has its own separate address. Additional outdoor property features include a detached 24x40 garage, 12x40 Workshop, ideal for hobbies or small business needs, and storage outbuildings. Be sure to check out the 36x48 RV Garage at the base of the driveway, perfect for holding your recreational and outdoor vehicles. <br /> This property is your opportunity for the perfect escape into the peace and quiet of the countryside while enjoying the ability to generate additional income. The opportunities abound! Schedule your showing today and experience all this remarkable estate has to offer! This property will not last long on the market. Schedule to see it today! Buyer to verify all information and measurements prior to making an informed offer.
MlsNumber: --
ListingId: 1284877


Listing Provided By: eXp Realty, LLC, original listing
Phone: (888) 519-5113 xx101
Office Phone: (888) 519-5113 xx101
Agent Name: Amy Backstrom
Disclaimer: Copyright © 2024 East Tennessee Realtors®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 2430 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;
Cindy Nipper
ASCIIRe/Max Finest
Call Today!: (423) 762-6370

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App