Title Page Background
DEBUG FN args: Array ( [0] => 2920 [1] => [2] => [3] => agent ) BEFORE: Site: 2920 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2920 Igate: njhud LocID: 2920 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2920 AND i.igate IN ('mdhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2920 [1] => [2] => [3] => lender ) BEFORE: Site: 2920 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2920 Igate: njhud LocID: 2920 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2920 AND i.igate IN ('mdhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2920 [1] => [2] => [3] => other ) BEFORE: Site: 2920 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2920 Igate: njhud LocID: 2920 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2920 AND i.igate IN ('mdhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

14457 Highlands Trail Trail
Bristol, VA 24202

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,000,000
Beds: 5
Baths:
Status: Active
SqFt: 7609 Square Feet
Agency: Premier Sotheby's North Carolina

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Luxurious home in a fantastic location on hole #5 inside The Virginian's private gated community. This beautiful home has 6 bedrooms, 5 full baths, and 3 half baths. Primary bedroom has two huge walk-in closets, one w/chandelier & window seat. The primary bathroom is breathtaking w/a champagne tub, dome ceiling and Fine Art chandelier, his & her vanities, and separate toilet room with Toto bidet. Beautiful designer kitchen with Wolf gas range, subzero refrigerator, warming drawers, and butler pantry. The most beautiful grand patio with captivating view overlooking the Tom Fazio designed golf course. Upstairs has 3 bedroom suites with walk in closets, 2.5 baths and an open room. One of the bedrooms has custom built-in bunk beds, 4 beds total. The downstairs level has a large family room, game room/office, second kitchen, guest en-suite, pool table and gym with mirrored walls & Centaur flooring. Golf cart garage that holds 2 golf carts, has built in cabinetry and a mini fridge. Gorgeous back yard designed to resemble an English garden with beautiful landscaping and rolling hills. Bottom patio has outdoor kitchen with built in gas grill, sink, refrigerator, island w/ bar height seating for 6 & built-in fireplace. Gorgeous custom built fire pit with fire glass, 3 large heated benches w/custom iron seatbacks encircling the fire pit. The home has 4 car garages total with two attached to the main and the other two detached with guest apartment above them with full bathroom. This home has irrigation system, underground dog invisible fence, ring cameras around entire home perimeter & in-ground trampoline. Patio has built in ceiling heaters. Sonos sound system throughout inside and outside. Formal dining room on main with gorgeous John Richards chandelier. Glamours powder room. Gated on both ends of the neighborhood w/onsite security 24 hours a day. Lovely clubhouse with restaurant, bar and grill, swimming pool w/restaurant, tennis courts, gym, and 18-hole golf course.
MlsNumber: --


Listing Provided By: Premier Sotheby's North Carolina, original listing
Phone: (423) 646-5554
Office Phone: (828) 898-5022
Agent Name: Loretta Trayer
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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => washington [3] => VA [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: washington State: VA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: washington State: VA Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2920 AND i.igate IN ('mdhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mdhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Brie Kite
Brie Kite
ASCIITHE ADDINGTON AGENCY
Call Today!: (423) 741-4846

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App