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

320 Pine Road
Hague, VA 22469
Tracy Vasquez with Redfin Corp, original listing - (410) 823-0033

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,990,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 3000 Square Feet
Agency: Redfin Corp
Agency Phone: (301) 658-6186

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 165 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Welcome Home to the property affectionately known as TRAVELERS REST. Whether you are looking for a 165 acre farm or you're looking for a magnificent waterfront home, you get it all right here in this serene slice of heaven. Let's start with the home... This custom built, brick rambler will impress the moment you walk in, when all of your attention is drawn to the gorgeous wall of windows showcasing the water views. Not to be overshadowed by the incredible, vaulted, tongue and groove pine ceiling, floor to ceiling stone fireplace, custom mantle, and the French door on either side of those windows to access two covered porches. The main living area is the perfect open floor place to keep everything together and simple. The kitchen has custom cabinetry, granite countertops and a bar style island, while still having an eat-in area that is big enough to fit your dining room table. The home has two generous sized secondary bedrooms and a full bathroom to the right of the main living area. To the left is the den and primary suite with water views and it's own access to the porch. The home has a concrete floored conditioned crawlspace that houses the Geothermal 4 Zone HVAC System (with transferable 10 year parts and 5 year labor warranty), the Water Conditioning/Softener System and a 50 gallon water heater. Now for the outside... If waterfront is what you're looking for then look no more. Over one half of a mile of water frontage and a pier with a mean low water depth of 2.8' at the end. There is a huge (56'x44') red barn/workshop with 14' clearance complete with a rebar reinforced concrete floor. 165.42 acres zoned agricultural except the 1 acre for home site. 70 of these acres are currently farmland (renewable lease with farmer) as well as an enclosed 17 acre pasture with automatic livestock waterer. This property has no HOA or restrictions. Make your dream a reality.
MlsNumber: --
ListingId: VAWE2008554


Listing Provided By: Redfin Corp, original listing
Phone: (410) 675-1550
Office Phone: (410) 823-0033
Agent Name: Tracy Vasquez
Disclaimer: Copyright © 2025 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App