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;

307 Lake Drive
Colonial Beach, VA 22443

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,000
Beds: 2
Baths: 2
Status: Active
SqFt: 2564
Agency: Exit Mid-Rivers Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1990
Notes: WATERFRONT 2 homes that give a warm welcome in a place away from life's hustle and bustle with unforgettable views along Crystal Lake, as it sits on almost one-acre. The renovations include a 2 year young roof (both homes), newer windows (some bay) that bring in tons of natural light and overlooks the water, some new flooring, a newer 10' x 38' Trex deck, a newly resurfaced roundabout driveway, a fresh coat of paint, new gutter leaf guards, and a newer bulkhead/retaining wall throughout the length of the property. This lovely spacious home has a large living room with oak hardwood floors and gas fireplace. The hickory floor to ceiling custom wrap-around kitchen cabinets give a stylish look & extra space, a sizable kitchen island w/breakfast bar and lots of counter space, recess lighting, an oversized 6' x 8' pantry room, a huge 5' x 13' walk-in laundry room w/shelving and space to spare, and the 12 x 13 formal dining room comes equipped with a sink, buffet bar and cabinets. Who doesn't want to be able to sit back relax, and enjoy the wide-reaching water view from every angle across the backyard overlooking the lake in a beautiful 12' x 26' glass sunroom? The whole house generator brings you piece of mind knowing the power will always be restored. The cozy studio apartment has a generous amount of space, a 13' x 20' living area, 12' x 16' kitchen area, private full bath, closets, and shelving. The dock has a perfect landing to launch a small boat with ample exterior lighting and flood lights. Also, includes a 30' x 36' deep 3 car/large boat garage and so much more to see.
MlsNumber: 115362


Listing Provided By: Exit Mid-Rivers Realty, original listing
Name: Exit Mid-Rivers Realty
Phone: (804) 493-1888
Office Name: Exit Mid-Rivers Realty
Office Phone: (804) 493-1888
Agent Name: Tina Marshall
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