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','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 = 2472 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 = 2472 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;

2835 Cross Mountain Road
Shady Valley, TN 37688
Sandy Poe with Alliance Sotheby's International Realty, original listing - (865) 357-3232

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 36 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: Spectacular Equestrian Mountain Estate on 36+ rolling acres with majestic mountain views! Located in the upper corner of Northeast Tennessee, surrounded by thousands of acres of the Cherokee National Forest and the Appalachian Trail that provide access to miles of scenic riding/hiking trails. Every equestrian lover's dream! The custom luxury log cabin home sourced with large, artful logs offers 4BR/3BA, soaring ceilings, beautiful hardwood floors, stacked stone fireplaces, a chef's kitchen featuring designer granite countertops, high-end appliances, custom crafted cabinetry, and a walk-in pantry. The primary bedroom suite along with another ensuite bedroom is located on the main level. There is a spacious loft landing area that serves as a multi-purpose room for an office, playroom, recreation room, etc. On the lower, terrace level of the home there are two additional bedrooms, great room, exercise room, a safe room and wine cellar. The expansive covered porches provide the perfect setting to absorb the surrounding natural beauty that help begin and end a day. Relax and unwind in the sauna, enjoy amazing sunsets, pastoral views and take in all that life on the farm has to offer. In addition to the main log home, there is a 3BR/1.5BA guest home or caretaker quarters, an off-grid log cabin in the woods, and a state of the art 13-stall barn with electricity, heat, automatic watering system, generator, fenced pasture and a pond. For those who work from home there is Skyview fiber optic internet available to keep you connected. While the property provides serene country living, it is located just minutes from the quaint town of Shady Valley with close proximity to Mountain City, the Tri-Cities area, Abingdon and Boone, NC where all the every day conveniences can be found. Whether an equestrian farm, a private mountain get-away, multi-generational family farm or an income producing vacation home or retreat center, this property will not disappoint. Don't miss your opport
MlsNumber: --
ListingId: 9970631


Listing Provided By: Alliance Sotheby's International Realty, original listing
Phone: (865) 207-0004
Office Phone: (865) 357-3232
Agent Name: Sandy Poe
Disclaimer: Copyright © 2024 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