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 = 2907 AND i.igate IN ('usahud','vahud','ushud') 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 s.locationid = 2907 AND i.igate IN ('usahud','vahud','ushud') 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 s.locationid = 2907 AND i.igate IN ('usahud','vahud','ushud') 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;

2608 Boulder Lane
Duffield, VA 24244
Jim Griffin with eXp Realty - Griffin Home Group, original listing - (423) 302-0333

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $199,900
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: eXp Realty - Griffin Home Group
Agency Phone: (423) 302-0333

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 68 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Welcome to your mountain paradise! Nestled on 68.7 acres of picturesque Virginia mountains, this incredible property boasts an idyllic location along the serene banks of the Clinch River. With nearly 1/2 mile of riverfront stretching 2,545 feet, you'll be captivated by the tranquil beauty that surrounds you.<br /> One of the standout features of this property is the views that stretch for miles in every direction. A unique and charming addition to this property is the swing bridge that spans the Clinch River. Situated just beyond the railroad trestle at the corner of Bridge Street and Dewey Avenue, this quaint bridge connects your property to the other side, allowing for easy exploration and access to further adventures. Best of all, the bridge is diligently maintained by the Virginia Department of Transportation (VDOT), ensuring a convenient and safe passage.<br /> Immerse yourself in the natural wonders of this heavily wooded and mountainous landscape. Towering trees create a canopy of shade, offering a cool respite during the warmer months. Additionally, the property features a railroad easement, showcasing a historic train tunnel that adds to the property's allure.<br /> Modern amenities have not been overlooked, as the property already benefits from electric infrastructure, cable TV connectivity, and fiber internet accessibility via the Scott County Telephone Cooperative (SCTC). This means you can enjoy the best of both worlds - the tranquility of the wilderness combined with the convenience of modern technology.<br /> Don't miss this extraordinary opportunity to own a slice of Virginia's natural beauty. Whether you're seeking a hunting retreat, an outdoor enthusiast's haven, or a private sanctuary away from it all, this property offers endless possibilities. Explore the magic of the mountains, indulge in the serenity of the river, and create a lifetime of unforgettable memories in this remarkable haven.
MlsNumber: --
ListingId: 9953646


Listing Provided By: eXp Realty - Griffin Home Group, original listing
Phone: (423) 302-0333
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App