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

170 Stan Reed Ln
Oneida, TN 37841

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $924,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2400
Agency: United Real Estate Solutions

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 54 acre(s)
Property Type: Residential
Year Built: 2022
Notes: Welcome to your very own piece of East Tennessee paradise! This custom-built barndominium home is a dream come true for the outdoors enthusiast! Nestled on over 54 acres of both rolling hills and level land, this property offers a unique blend of modern comfort, rustic charm, yet the ability to get away from it all in your very own back yard. Built in 2022, this spacious home boasts over 2200 sq ft of living space, perfect for enjoying the serene countryside lifestyle.<br /> <br /> As you step inside, you'll be greeted by a cozy yet spacious interior featuring a massively open floor plan with very high ceilings, tasteful finishes throughout, yet with a simple nature that this home offers. The heart of the home is the inviting living area, built for a social atmosphere no matter if you are relaxing with the family or entertaining guests. The gourmet kitchen is a chef's delight, complete with premium appliances, ample counter space, and an open space with an additional living area ideal for gatherings<br /> <br /> This property is not just a home; it's a lifestyle. Outside, you'll find a charming guest quarters, perfect for friends, the in-laws, or just a peaceful retreat. The expansive cleared space offers endless possibilities for outdoor activities, gardening, or even keeping up with your animals. The outdoors enthusiasts will absolutely love the private trails throughout the 54 acre property, ideal for hiking, ATV rides, hunting, or simply enjoying the beauty of the surroundings.<br /> <br /> Located in the scenic town of Oneida, Tennessee, this home offers tranquility; all while still being conveniently located just over an hour north of Knoxville and easily accessible from I-75. Don't miss this opportunity to own your slice of paradise in East Tennessee's stunning countryside!<br /> <br /> *Buyer to verify sq ft, sq ft is a combination of all finished square footage, including the additional guest suite.
MlsNumber: 1256006


Listing Provided By: United Real Estate Solutions, original listing
Name: United Real Estate Solutions
Phone: (865) 621-2040
Office Name: United Real Estate Solutions
Office Phone: (865) 444-2400
Agent Name: Chris Overbay
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