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

1898 Kennedy Way
Del Rio, TN 37727
Rob Dansereau with Alliance Sotheby's International Realty, original listing - (865) 357-3232

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 1792 Square Feet
Agency: Alliance Sotheby's International Realty
Agency Phone: (865) 357-3232

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: The Aerie at Little Bull Mountain is nestled between Cherokee National Forest and Martha Sundquist State Park in the Mountains of East Tennessee. This is the Private Side of The Great Smoky Mountains and just to the west of the iconic Max Patch Bald and all of the outdoor activities that the Appalachian Trail and Pigeon River bring. Upon entering the gate at Little Bull Mountain, you will know that your are in a special place as unique mountain vistas are experienced at every turn of the road. Little Bull Mountain is an exclusive community of 5+ acre mountain view tracts with high quality infrastructure including underground electricity and fiberoptic communications lines. The Aerie is a luxury home with a separate guest house that sits on the premier flat location of a 3 tract estate-sized mountain parcel that totals over 16 acres. Built in 2023, this custom smart home maximizes the owner's privacy while rejuvenating their soul with the incomparable mountain views. The main house at The Aerie features a 1,792 square foot open concept/split bedroom floor plan with 3 bedrooms and 2.5 baths. The home was built from the highest quality materials with much of the wood milled onsite. Exterior spaces include large wrap around covered porches, a fire pit and a secluded area with a hot tub. The guest house with a nice-sized covered porch measures 579 square feet with one bedroom/one bathroom and a full suite of amenities including a kitchen, living room, and dining room combination. The designers included a private 800 feet deep well, 4 bedroom shared septic system, and a Generac Whole Home Generator for self-sufficiency. Every detail of The Aerie was meticulously planned to enhance the uniqueness of this mountain oasis through a combination of calm, comfort, and beauty. ***SELLER FINANCING AVAILABLE!***
MlsNumber: --
ListingId: 1248860


Listing Provided By: Alliance Sotheby's International Realty, original listing
Phone: (865) 406-0877
Office Phone: (865) 357-3232
Agent Name: Rob Dansereau
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.


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 = 2441 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;
Real Estate Expert Photo for Robert Tucker, Making Your Realty Dreams Reality
Robert Tucker, Making Your Realty Dreams Reality
ASCIIWeichert, Realtors - Tiger Real Estate
Call Today!: (865) 919-6831

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App