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

1852 Ocran Road
White Stone, VA 22578
Amanda Hardesty with Hardesty Homes, original listing - (804) 745-8516

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,295,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Hardesty Homes
Agency Phone: (804) 745-8516

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 23 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Cedar Lane Farm: A Timeless Waterfront Estate in Whitestone, VA. Nestled along the pristine shores of Tabs Creek, this property presents an unparalleled opportunity to own a piece of Virginia's storied past. This exquisite 23+ acre estate, named for the majestic cedar trees that gracefully line its private driveway, has been cherished by a single family since the 1950s, offering a legacy of privacy & natural beauty. A serene enclave known for its tranquility, yet conveniently located for those seeking the perfect balance between nature & accessibility. Your backyard opens onto this charming waterway, providing not just views but a lifestyle revolving around the water. The property is enveloped by water on 3 sides, ensuring utmost seclusion. High ground offers both a strategic advantage for construction & breathtaking views over the water. Enjoy direct access to deep water suitable for docking on 2 sides, ideal for boating enthusiasts. Remarkably, the ownership extends to the oyster beds in the surrounding water, presenting a unique opportunity for aquaculture or simply enjoying the freshest seafood right from your property. The property includes older structures, grandfathered in, which not only add character but also provide a legal footprint for future accessory buildings without the typical restrictions. The drive into your sanctuary is marked by cedar trees, creating a natural corridor of beauty & privacy. Perfect for building your dream home with minimal flooding concerns, enjoying panoramic views & the cooling breezes off the water. Cedar Lane Farm is more than a property; it's a legacy. Retaining its charm and privacy through generations, this estate invites you to continue its story. Whether for a family retreat, a permanent residence, or an investment in land that promises enduring value, & is a rare gem in today's real estate market. Experience the serene waterfront lifestyle that Cedar Lane Farm has offered for over half a century & imagine the possibilities it holds for you
MlsNumber: --
ListingId: 2426306


Listing Provided By: Hardesty Homes, original listing
Phone: (804) 745-8516
Office Phone: (804) 745-8516
Agent Name: Amanda Hardesty
Disclaimer: Copyright © 2024 Central Virginia Regional Multiple Listing Service. 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