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;

251 Siler Street St
Jellico, TN 37762

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $185,000
Beds: 4
Baths: 2
Status: Pending
SqFt: 2302
Agency: REMAX FIRST

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1946
Notes: Mountain retreat in the heart of East Tennessee! This stunning one level home with 4 bedrooms and 2 bathrooms spans 2302 square feet. Nestled in a picturesque setting with breathtaking mountain views, this property is a haven for outdoor enthusiasts, situated near the renowned Ride Royal Blue ATV trails.<br /> <br /> This home offers a spacious living room with floor-to-ceiling windows, wood ceiling, and brick fireplace with gas logs. The kitchen has been thoughtfully expanded into the dining area, featuring a custom-built bar that is perfect for entertaining.<br /> <br /> One of the unique features of this home is the finished carport-garage, complete with windows and heat and air. This versatile space can serve as extra living quarters or be converted back into a carport/garage. <br /> <br /> The exterior of the property is equally impressive, boasting a gazebo, chicken coop, fenced backyard, and two storage buildings. Enjoy outdoor gatherings on the side patio or relax on the back patio while taking in the serene mountain surroundings.<br /> <br /> The bathrooms have been tastefully remodeled, and the home has received updates such as replaced sub floors in hallway/main BR with added support, new drywall, and trim throughout. The owners have also added fencing and repaired tiles on the outside of the home, ensuring a well-maintained and inviting exterior.<br /> <br /> For those with a vision for expansion or investment, an additional home on the adjoining lot is available for purchase. While needing renovation, this presents an excellent opportunity for rental income, extra space for family, or additional storage.<br /> <br /> Don't miss the chance to make this mountain retreat your own - schedule a viewing today and experience the perfect blend of comfort, style, and outdoor adventure in East Tennessee!
MlsNumber: 1250697


Listing Provided By: REMAX FIRST, original listing
Name: REMAX FIRST
Phone: (865) 405-9105
Office Name: ReMax First
Office Phone: (865) 405-9105
Agent Name: Darlene Dehart
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App