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;

145 Brave Drive
Oneida, TN 37841

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $875,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3481
Agency: Keller Williams Realty, Knoxville-West, mc814

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential
Year Built: 1999
Notes: This stunning 4-sides brick luxury estate sits on 4 serene acres and offers an unparalleled living experience with breathtaking mountain views.<br /> <br /> As you enter, you'll be captivated by the airy and expansive atmosphere created by the 15 and 20-foot ceilings on the main level. This level features three spacious bedrooms, each with large walk-in custom closets. The owner's suite is a true retreat, featuring a spa-like en-suite bathroom and direct access to a huge deck with Trex decking, where you can enjoy stunning views of the pool and covered patio. The open-concept great room, complete with a gas fireplace and built-in surround sound, flows seamlessly into the gourmet kitchen with high-end finishes, making it perfect for entertaining.<br /> <br /> Throughout the home, you'll find custom built-ins that enhance its elegance and functionality. Step outside to the expansive deck, accessible from both the owner's suite and great room, and immerse yourself in the tranquility of the outdoor oasis. This private setting is perfect for outdoor dining and relaxation, with picturesque views of the pool and surrounding landscape.<br /> <br /> The finished walk-out basement boasts 10-foot ceilings and includes a fourth bedroom and a bonus room that can function as a fifth bedroom, both with large walk-in custom closets. This level provides additional living and entertainment space, ideal for family gatherings and social events, and offers direct access to the covered patio and pool area, creating seamless indoor-outdoor living.<br /> <br /> Custom plantation shutters, crown molding, and exquisite trim work add to the home's elegance. The heated and cooled 2-car garage provides ample storage space and convenience. Located just minutes from Big South Forks of the River National Park and the Air Park, this home offers endless recreational opportunities.<br /> <br /> Combining elegance, comfort, and modern amenities, this luxurious home is in a prime location. Don't miss your chance to own this extraordinary property. Schedule a private tour today and experience the exceptional lifestyle this home has to offer. Home sits on two lots, totaling in 4 acres. Must include parcel IDs "069 001.06" and "069 001.16" in contract. <br /> A/C and roof are four years old<br /> Windows replaced and deck redone in 2021<br /> Pool is heated and pump was replaced 2 years ago<br /> Garage has a 3rd bay that has had garage door replaced with french doors and cabinets added. Large enough to park additional lawn equipment or golf cart in 3rd bay. <br /> Septic tank serviced 6 months ago<br /> Home is built with steel beam framework
MlsNumber: 1264887


Listing Provided By: Keller Williams Realty, Knoxville-West, mc814, original listing
Name: Keller Williams Realty, Knoxville-West, mc814
Phone: (865) 694-5904
Office Name: Keller Williams Realty
Office Phone: (865) 694-5904
Agent Name: Tylor Holt
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