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

1527 Stone Mountain Road
Trade, TN 37691
Elizabeth Cornett with Ace Realty, original listing - (423) 727-5554

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,199,000
Beds: 3
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3406 Square Feet
Agency: Ace Realty
Agency Phone: (423) 727-5554

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Resting at an elevation of 4,233 feet, this stunning custom hand-hewn log home offers panoramic views of the mountains of North Carolina, Tennessee, and Virginia. The generous great room features a dramatic floor-to-ceiling stone fireplace with gas logs, flowing seamlessly into a chef's kitchen equipped with Jenn Air stainless steel appliances, granite countertops, and custom cabinetry. The main-level primary suite boasts double vanities and serene mountain views. Upstairs, a versatile loft space—perfect for a home office—complements a large, light-filled bedroom and a full bath.<br /> The lower level is an entertainer's dream, featuring a custom granite-topped bar, a second gas fireplace, a handcrafted pool table, and an intimate wine cellar and tasting room with custom cabinetry. A bonus/sleeping room (currently used as a bedroom) and a full bath complete this level. Above the two-car garage is a 780 sq ft guest apartment currently operating as an Airbnb. It includes a king-size bed, cozy sitting area with gas fireplace, kitchenette, and full bath—ideal for guests or rental income. Exceptional outdoor amenities include a 1,490 sq ft covered wrap-around deck, a covered outdoor kitchen with a 52'' Viking gas grill, refrigerator, sink, fire pit, and an 8-person hot tub—all designed to take full advantage of the breathtaking scenery. Practical features include a propane-powered whole-house generator, metal privacy gate, water filtration and softening system, exterior security cameras, and tasteful outdoor lighting. Located near the NC High Country with the benefit of lower taxes and county-maintained roads. Furnishings & an ATV convey with an acceptable offer. Whether you're seeking a primary residence, second home, or income-producing rental, this property delivers unmatched luxury, comfort, and views. Seller's plans have changed. Call today for your private tour. Information sourced from tax & seller's information. Buyer/buyer's agents encouraged to verify.
MlsNumber: --
ListingId: 9980532


Listing Provided By: Ace Realty, original listing
Phone: (423) 471-1652
Office Phone: (423) 727-5554
Agent Name: Elizabeth Cornett
Disclaimer: Copyright © 2025 Tennessee Virginia Regional Multiple Listing Service. 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