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

8252 Highway 297
Pioneer, TN 37847

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $230,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 2726
Agency: eXp Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1989
Notes: **Virtual Tour and Photos UPDATED** Welcome to your serene retreat nestled near famed ATV trails, the Elk Viewing Tower and so much more. The property boasts oak hardwood throughout, accentuated by a captivating spiral staircase, Juliet balcony and foyer to welcome you. Fresh paint in the Foyer, staircase and bedroom! With black quartz countertops adorning both bathrooms and kitchen, with some updating this home could really shine. Boasts Newer roof, and HVAC. With a spacious bonus room that can double as a master suite, office, or entertainment space, and the potential to create an additional master suite on the main level with additional bathroom materials ready for installation, the possibilities are endless. Spanning 2,726 square feet, this home offers 4 bedrooms and 2.5 baths, with ample room to stretch your legs. Enjoy breathtaking mountain views from both the front and back of the property.<br /> <br /> The 2,001 square foot basement offers a bar, man-cave, and workshop providing the perfect canvas for expansion and customization. Whether you envision a home gym, theater room, or additional living space, the basement offers boundless potential. Exterior access to garage and basement leaves the option for income property, or mother-in-law suite. No steep, winding driveways here! Situated on 2.4 acres of level terrain, there's plenty of room for outdoor activities, including a raised garden bed and a fire pit. Unrestricted use allows for additional outbuildings, parking RVs, boats, and more. Conveniently located near Knoxville, and Lexington, Kentucky, this home offers easy access to amenities while preserving rural tranquility. Whether you're seeking a primary residence, investment property, or vacation rental, this home promises unparalleled bliss amidst nature's beauty. Don't miss your chance to experience the epitome of mountain living. This property is being sold as-is, but some TLC could unlock so much potential in this home. <br /> Proof of funds or pre-qualification letter required. No sight unseen offers. https://twra.maps.arcgis.com/apps/webappviewer/index.html?id=95392547223b427b9a5a518b7ae29b44
MlsNumber: 1253975


Listing Provided By: eXp Realty LLC, original listing
Name: eXp Realty LLC
Phone: (888) 519-5113 xext101
Office Name: eXp Realty, LLC
Office Phone: (888) 519-5113 xx101
Agent Name: Michael Cutali
Disclaimer: Copyright © 2024 Knoxville Area 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