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

6760 Wilson Road
Marshall, VA 20115

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,950,000
Beds: 4
Baths: 4
Status: Active
SqFt: 6012
Agency: Middleburg Real Estate, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 166 acre(s)
Property Type: Residential
Year Built: 2003
Notes: Welcome to 6760 Wilson Rd, a breathtaking 167-acre estate offering an exquisite blend of luxurious living and natural beauty. This remarkable property features two stunning homes, a detached garage with living space, barns, a captivating 4-acre spring-fed stocked pond, with 7 Bedrooms total, and all embraced by majestic mountain views.<br /> <br /> The main residence, a contemporary log home, underwent extensive upgrades in 2022 and 2023. Set beside, the detached 2-car garage includes an apartment with exceptional views of the property.<br /> <br /> Stepping inside the main home, meticulous updates are evident throughout. The gourmet kitchen is a culinary haven, equipped with top-tier appliances, custom cabinetry, and exquisite granite countertops. The spacious great room with high ceilings offers an ideal setting for hosting gatherings, and an adjacent butler's pantry simplifies entertaining. A well-appointed home office caters to remote work needs.<br /> <br /> The entire top floor is a sanctuary of luxury. The primary bedroom and bathroom provide a spa-like experience, with a 3-sided Kingsman gas fireplace, heated floors, and a programmable Thermasol steam shower. The bedroom boasts panoramic mountain views and a separate sitting area.<br /> <br /> Set amid the expansive acreage, a separate 800-square-foot log cabin built in 2002 offers modern comfort with 2 bedrooms, 1 bath, and a loft. <br /> <br /> Nearby, a substantial brick and block shop, constructed in 2001, includes an attached covered storage area with four large open bays. Inside, there is ample space and a half bathroom. <br /> <br /> The property is well-equipped to accommodate farm animals and operations, with a barn, nine Mirafount waterers, and an extensive network of underground water lines. It features miles of well-maintained fencing, an extensive trail system, three wells, a four-acre spring-fed stocked pond with a beach and an 80-foot dock, along with four smaller ponds, two creeks, and several natural springs. In total, the property boasts 7 bedrooms and 5.5 bathrooms.<br /> <br /> This exceptional farm property offers an unparalleled blend of luxury and natural beauty. Contact us without delay to seize this remarkable opportunity for a showing.Please reference Upgrade/Highlight document.
MlsNumber: VAFQ2009900


Listing Provided By: Middleburg Real Estate, LLC, original listing
Name: Middleburg Real Estate, LLC
Phone: (540) 687-6321
Office Name: Middleburg Real Estate
Office Phone: (540) 687-6321
Agent Name: Peter Pejacsevich
Disclaimer: Copyright © 2024 Bright MLS. 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 s.locationid = 94 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;
Shantel Williams
ASCIILOAN DEPOT
Call Today!: (520) 954-2275

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App