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 e.expertIdNum = 1833042 AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 e.expertIdNum = -1 AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 e.expertIdNum = -1 AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;

23245 Virginia Trail
Bristol, VA 24202

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,795,000
Beds: 4
Baths: 5
Status: Active
SqFt: 5234
Agency: GRIFFIN HOME GROUP

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1996
Notes: This renovated residence in The Virginian, a gated golf community,<br /> sits on 2+ manicured acres with stunning 360-degree views.<br /> A large open foyer with views from front to back greets you as you<br /> enter. A library with custom built-ins and fireplace sits to the right,<br /> while the formal dining room, with easy kitchen access, is on the left.<br /> The chef's kitchen boasts top-of-the-line appliances, an enormous<br /> granite island; an adjoining large butler's pantry with ½ bath leads to<br /> an attached two-car garage.<br /> The open concept flows from the kitchen into the casual dining area<br /> and living room with vaulted ceiling and fireplace. The main level<br /> living/entertaining room features a wet bar with wine cooler, bar sink,<br /> and entertainment storage. This floor also has a beautiful powder<br /> room, coat closet, and large storage closet. The downstairs master<br /> bedroom includes a walk-in closet, two additional closets, and an<br /> ensuite bath with a custom stained-glass window, walk-in shower, and<br /> heated floors. An office/sitting area opens out to a screened in porch<br /> with drop down screens so you can enjoy it while staying dry and<br /> listening to the rain.<br /> The second floor features an additional family room, two bedrooms<br /> with ensuite baths; a third full bath and bedroom/office with both<br /> climatized and under roof storage areas. The back patio offers<br /> extraordinary views and includes an outdoor kitchen complete with a<br /> 2-burner gas stovetop, warming drawer, sink with hot and cold water,<br /> granite countertops and the BEST mountain views. The concrete and<br /> stone huge patio is completed with a stone fireplace with gas logs. A<br /> detached two-car garage with workshop, wine cellar, and office space<br /> was added in 2015. This space features ample storage and a fantastic<br /> opportunity for an in-law suite, mancave, home business space, or<br /> whatever your heart desires! The property showcases meticulous<br /> attention to detail and must be seen to be fully appreciated!
MlsNumber: 9963517


Listing Provided By: GRIFFIN HOME GROUP, original listing
Name: GRIFFIN HOME GROUP
Phone: (423) 302-0333
Office Name: eXp Realty - Griffin Home Group
Office Phone: (423) 302-0333
Agent Name: Jim Griffin
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

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 e.expertIdNum = 1833042 AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 Gayle Macomber
Gayle Macomber
ASCIIKeller Williams Realty Professionals
Mobile: (985) 290-2573
Direct: (985) 646-4028

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App