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;

498 Seaboard Road
Reedville, VA 22539
Becky Haynie with Long & Foster Real Estate, Inc., original listing - (804) 435-2673

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,995,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3540 Square Feet
Agency: Long & Foster Real Estate, Inc.
Agency Phone: (804) 435-2673

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Seaboard is a beautiful waterfront home located in Reedville, VA, just minutes to the Chesapeake Bay. Situated on a private point on Cockrell Creek with panoramic views and deep water to accommodate large power boats and sailboats. Experience unparalleled waterfront living in this exquisite 3,450 square foot home with 4 bedrooms and 2.5 baths nestled on 2.79 acres. Inside is designed for comfort and entertaining with a large eat-in kitchen with a grilling deck and waterside screen porch for picking crabs. Adjacent to the porch is a large family room and downstairs ensuite primary bedroom both with fireplaces. The front of the house boasts a light -filled entryway with staircase, formal living room with fireplace and dining room. The first floor rounds out with a mud/ laundry room and half bath directly off of the kitchen leading to the attached one car garage. Upstairs are three large bedrooms and a full bath. Space over the garage is accessible by elevator and has been roughed-in for an additional bathroom. Expansive outdoor spaces include two decks overlooking Cockrell Creek as well as a dock with an enclosed boathouse, a shed/workshop and plenty of room for a garden. The property is elevated for super summer breezes and freedom from flooding and flood insurance. This unique property offers a place to unwind and watch the world go by or jump in to hosting others and heading out for a day on the water.
MlsNumber: --
ListingId: 117629


Listing Provided By: Long & Foster Real Estate, Inc., original listing
Phone: (804) 436-2968
Office Phone: (804) 435-2673
Agent Name: Becky Haynie
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