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 = 2459 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 = 2459 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 = 2459 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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;

826 Pickett Rd
Sale Creek, TN 37373
Chris Wrede with East TN-LPT Realty, original listing - (865) 500-4663

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $300,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2100 Square Feet
Agency: East TN-LPT Realty
Agency Phone: (865) 500-4663

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Mobile Home
Year Built: 2019
Notes: Just imagine a charming 3-bedroom, 2-bathroom home nestled in the tranquil Tennessee countryside, surrounded by over an acre of picturesque land. Here's a detailed description:<br /> The home is situated on a spacious plot of land, gently rolling with lush greenery and some mature trees providing shade and privacy. A gravel driveway leads up to the home and offers ample parking space for multiple vehicles. The exterior of the home itself is well-maintained, with vinyl siding that blends harmoniously with the natural surroundings.<br /> Upon entering the home, you step into a cozy living room adorned with warm tones and natural light streaming in through large windows. The focal point of the living area is a rustic wood-burning fireplace, perfect for creating a cozy ambiance during chilly evenings. This area serves as the heart of the home, ideal for relaxation and gathering with family and friends.<br /> Adjacent to the living room is a spacious kitchen, featuring ample cabinet storage, and plenty of counter space for meal preparation. The kitchen includes a large central island, offering additional seating and serving as a convenient hub for daily activities.<br /> The master bedroom is generously sized, offering a peaceful retreat with views of the surrounding countryside. It includes 2 large closets, and an ensuite bathroom with an over-sized soaking tub and seperate walk in shower, ensuring comfort and privacy. The two additional bedrooms are located seperate from the owner's bedroom and are perfect for guests, children, or can be used as home offices or hobby rooms, each offering ample closet space and natural light.<br /> <br /> Additional Features:<br /> <br /> Wood-Burning Fireplace: The focal point of the living room, providing warmth and charm.<br /> Over an Acre of Land with plenty of outdoor space for gardening, recreation, or simply enjoying the peaceful rural setting.<br /> Tranquil Setting: Away from the hustle and bustle of city life, offering serenity and a connection with nature.<br /> Privacy: Surrounded by natural vegetation a remote controlled gate and a fenced in yard, ensuring a sense of seclusion and quiet.<br /> This 3-bedroom, 2-bathroom mobile home with a wood-burning fireplace and over an acre of land epitomizes country living at its finest. It blends comfortable living spaces with the beauty of natural surroundings, providing a perfect retreat from the demands of everyday life while offering ample opportunities for outdoor activities and relaxation.
MlsNumber: --
ListingId: 1285839


Listing Provided By: East TN-LPT Realty, original listing
Phone: (865) 712-8192
Office Phone: (865) 500-4663
Agent Name: Chris Wrede
Disclaimer: Copyright © 2025 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 = 2459 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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;
Real Estate Expert Photo for Jannis Sams, The Jannis Sams Team
Jannis Sams, The Jannis Sams Team
ASCIICrye-Leike Realtors
Call Today!: (423) 503-2945

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App