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;

802 Cherry Point Road
Callao, VA 22435
Kevin Kuykendall with Middle Bay Realty - B, original listing - (804) 453-5380

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,725,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Middle Bay Realty - B
Agency Phone: (804) 453-5380

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 109 acre(s)
Property Type: Land-Single Family Residence
Year Built: --
Notes: "CHERRY POINT FARM" - ONE OF A KIND!!! THE ONLY 109 ACRE POTOMAC RIVER FARM FOR SALE IN VA .Water, Water Everywhere! BEACH, BEACH, BEACH!! 109 + acre private farm on spectacular waterfront peninsula. 30 ac open land/farmland. 2,000' +/- Potomac River beach frontage to the North with breathtaking 8-mile views to Point Lookout, MD and endless views across the Chesapeake Bay. 2,500' +/- frontage on protected Garners Creek to the East. 1,200' +/- of tidal creek/pond/wetland to the West. Charming 4BR, 3 BA farmhouse, hardwood floors, stained glass, 3 fireplaces with elaborate trim and ceramic tile. Whole house Generator. New 1 1/2 story shop. Sheds. 2-mile trail along river and 2 creeks. Quiet Cherry Pt Drive great for biking. Hunter's dream. Live in existing farmhouse, remodel, or build dream home in paradise ON RIVER OR CREEK! Ignore those half-million dollar 10-acre lots. WHERE ELSE CAN YOU OWN A SECLUDED WATERFRONT PENINSULA BORDERED BY CREEKS ON EITHER SIDE AND ALMOST 1/2-MILE WIDE, WIDE, WIDE SAND BEACH? BOAT ON CREEK, RIVER, OR TO THE BAY IN 20 MINUTES. 2 Hrs N VA, 1 Richmond or Tidewater. Minutes from Callao and quaint village of Lewisetta. TRULY, ONE OF A KIND!!!
MlsNumber: --
ListingId: 110287


Listing Provided By: Middle Bay Realty - B, original listing
Phone: (804) 761-4125
Office Phone: (804) 453-5380
Agent Name: Kevin Kuykendall
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