Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Avenues

Property view
Listing view 2
Listing view 3

242 Old Farm Drive, 
Shacklefords, VA 23156

$1,195,000


4

Beds


5

Baths


4,198

Sq Ft


Single Family

Active

Listed by

Danielle Rosso

Dalton Realty

804-723-5750

Last updated:

August 4, 2026, 02:31 PM

MLS#

2615841

Source:

RV

About This Home

242 Old Farm Drive

FIRST TIME OFFERING of this RARE AND REMARKABLE YORK RIVER WATERFRONT ESTATE!! 150' of PRIVATE SAND BEACH W/FLEXAMAT, COVERED BOAT LIFT, AND BREATHTAKING SUNRISE and SUNSET VIEWS! EXQUISITELY and MASTERFULLY CRAFTED featuring rich chestnut, oak, and pine woods, wide-plank flooring, rough cut beams and intricately, hand-carved trim! OPEN CONCEPT design! Original Hoosier cabinetry and antique bakery countertop island in the eat-in kitchen thoughtfully incorporated w/historical accuracy, as were all of the time-period appointments throughout this work of art! 15'*26' Living room w/incredible water views opens to the Sunroom which boasts Brissette brick flooring and reclaimed Douglas fir accents!! A 17'x17' den (easy convert to a 1st floor bedroom) and a full bath complete the main level! Owner's Suite offers a WB fireplace, river views, and a custom closet fit for a king! Royal Quarters-Style bathroom showcasing Victorian era dresser vanities, clawfoot tub and a walk-in shower! 2 spacious guest bedrooms, an office/4th bedroom, a hobby room/nursery and an addt'l bathroom complete the 2nd level! THIS MASTERPIECE IS UNMATCHED and THE OUTDOOR SPACE IS equally REMARKABLE boasting a colonial-style brick patio, Koi pond, Crepe Myrtles, Pecan, Golden Rain and one of the oldest Ginko trees in the area alongside a country front porch and gazebo overlooking the river! The pavilion space is erected on the foundation of the original outdoor kitchen! 30'x30' det. garage offers a full kitchen, workshop, and full bath to rinse off after a day of water play, along w/an above studio boasting 850 sqft, pine hardwood flooring, walk-in storage space and a full bath! High speed internet available along w/Wal-Mart delivery! PRIVATE, TRANQUIL SETTING IN THE PERFECT LOACTION; just 15 min to Gloucester, 30 min to Williamsburg and only a 15 min boat ride to Yorktown and 30 min to the Bay! An additional waterfront parcel is also available, bringing the total shoreline to 225'!!

Home Facts

Single Family

5 Baths

4 Bedrooms

Built in 1980

Subdivision & Development:

Beuna Vista

Price Summary

1,195,000

$284 per Sq. Ft.

MLS #:

2615841

Last Updated:

August 4, 2026, 02:31 PM

Added:

1 month(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

4

Bathrooms

Total Bathrooms:

5

Full Bathrooms:

4

Interior

Living Area:

4,198 Sq. Ft.


Structure

Structure

Architectural Style:

Colonial, Custom, Two Story

Building Area:

4,198 Sq. Ft.

Year Built:

1980


Lot

Lot Size (Sq. Ft):

54,450


Finances & Disclosures

Finances

Price:

$1,195,000

Price per Sq. Ft:

$284 per Sq. Ft.

MLS Logo
The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties for purchasing. All information provided is deemed reliable but is not guaranteed accurate.The multiple listing information is provided by Central Virginia Regional Multiple Listing Service, LLC from a copyrighted compilation of listings. The compilation of listings and each individual listing are © 2026 Central Virginia Regional Multiple Listing Service, LLC. All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.