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','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 = 2921 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 = 2921 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;

115 Drum Bay Lane
Hague, VA 22469

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,500
Beds: 4
Baths: 3
Status: Active
SqFt: 3312
Agency: Joe Self Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1998
Notes: Beautiful, spacious home with large rooms for entertaining and open floor plan...This home was built by the current sellers, as their dream retirement home. You'll appreciate the workmanship, throughout! The kitchen is so roomy. Notice the light, pickled cabinetry and tremendous work areas. The kitchen flows nicely into the great room. Witness one of the most beautiful brick fireplaces, you'll ever see! I imagine many peaceful hours will be spent in the waterside sunroom. The sunroom has its own mini-split, heat and air system. When you need to work from home, you'll appreciate the dedicated waterside office, with all of the natural light and views. There are 2 guest bedrooms, on the first floor, and one of the most beautiful bathrooms you'll ever see. If you're working outside, you'll appreciate the convenient mudroom. The entire upper level is dedicated to 2 owners' suites. Each suite has its own spectacular bath. The master even has a jetted tub, for the ultimate in relaxation. The master bedroom has a private, waterside glass room, with awesome views of the Lower Machodoc. On chilly nights, you'll enjoy the propane stove. Don't worry about power outages. Your whole-house generator will save the day! You'll appreciate the attached garage and covered portico. For the hands-on person, there's a detached, 1280 square foot workshop. Keep your boat out of the weather, with the boat lift and covered roof. Fish and crab, right off your pier, or take a short boat ride, to some premier rock fishing spots or seafood restaurants.
MlsNumber: 115500


Listing Provided By: Joe Self Realty, Inc., original listing
Name: Joe Self Realty, Inc.
Phone: (804) 450-7963
Office Name: Joe Self Realty
Office Phone: (804) 529-6393
Agent Name: A. Joseph Self, Jr.
Disclaimer: Copyright © 2024 Northern Neck Association of Realtors. 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