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 = 2887 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 = 2887 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 = 2887 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;

2319 Lighthouse View Drive
Heathsville, VA 22473
Robbie Booth & Melissa L. Bradley ABR with Shore Realty, Inc., original listing - (804) 529-7020

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,675,000
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 3725 Square Feet
Agency: Shore Realty, Inc.
Agency Phone: (804) 529-7020

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Coming Soon! Showings Start July 8! Be one of the first to see this Exceptional, Custom Designed Waterfront Home with Guest House, Pool & Pier on the Chesapeake Bay! See the views as soon as you enter into the impressive Main House with all the Great Designs as this was a Builders Home with the extra bells and whistles! Some Highlights include: Beautiful hardwood floors, private Guest Room or Gameroom over the garage, Formal Dining Room, Living Room with gas log fireplace & cathedral ceilings, powder room, Waterside Breakfast Nook and so much more. The Kitchen features granite countertops, propane cooking, pantry & custom cabinets. The waterside Owner's Suite is located on the main level with double closets and a luxurious private Bathroom. Upstairs features 2 Guest Rooms, another Full Bath, and a huge walk in attic. The spacious Guest House above the detached garage includes very impressive wood flooring, a large Kitchen with Island and Quartz Countertops, Living Room with freestanding electric Fireplace, Full Size Bedroom, Full Bathroom and a balcony to enjoy the bay breezes. Exterior highlights include: inground heated swimming pool with retractable cover, large pier complex, 2 jet ski lifts & a boat lift, fenced yard, rip rap shoreline, screened gazebo, waterside deck, attached 2 car and detached 3 car garage. This 2.7 acre property has been meticulously landscaped and cared for by the owner for many years! High Speed Internet is available. Private Neighborhood Sandy Beach located just steps away from this home. Call today to schedule your showing!
MlsNumber: --
ListingId: 116495


Listing Provided By: Shore Realty, Inc., original listing
Phone: (804) 339-1504
Office Phone: (804) 529-7020
Agent Name: Robbie Booth & Melissa L. Bradley ABR
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