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

2276 Mosquito Point Road
White Stone, VA 22578
Emily Carter with Jim & Pat Carter R. E.. Inc., original listing - (804) 435-3131

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,600,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 3470 Square Feet
Agency: Jim & Pat Carter R. E.. Inc.
Agency Phone: (804) 435-3131

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1940
Notes: On a picturesque country lane at the confluence of the Rappahannock River and the Chesapeake Bay, this exceptional property showcases the remarkable features of its setting: stunning vistas of the Bay, a narrow barrier island, a sandy shoreline, breathtaking sunrises, and the moonrises on the shimmering Rappahannock River. A winding lane meanders through the park-like grounds with expansive lawns and mature trees, offering glimpses of the Bay. Built in 1940, this rambling Tidewater design is situated on a knoll, providing privacy and elevation. The home boasts a spacious living room with a masonry fireplace, which opens onto a large deck. This deck extends the length of the house and highlights the spectacular view, allowing you to enjoy the soothing sound of waves lapping the shoreline and gentle bay breezes. The light-filled dining room is simple yet elegant. For a more relaxed gathering space, there is the cozy family room with a full bath. Overlooking the water, the kitchen includes a bright breakfast nook. The expansive first-floor primary bedroom features its own fireplace and private riverside deck. Two walk-in closets complement the spacious bathroom. The second floor is divided by an upper hall with an office, two bedrooms, a bath on one side, and a hall bath with two bedrooms on the other. A screened porch opens to the pool terrace, ideal for outdoor entertaining. The 3-bay garage can house cars, boats, bikes, golf carts. Down the gentle hill is a waterside deck leading to the private dock & sand beach. This is the perfect place to create enduring traditions.
MlsNumber: --
ListingId: 118034


Listing Provided By: Jim & Pat Carter R. E.. Inc., original listing
Phone: (804) 436-4949
Office Phone: (804) 435-3131
Agent Name: Emily Carter
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