Date
Details
Price
Change
Source
9/02/2025
Listed
$5,000,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/40
$5,000,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/40
Property Description
Exceptional Contemporary Direct Waterfront Estate. Located in Guilford, CT, on a private cove of Little Harbor, this stunning home has a private Beach, pier / dock and pool. Built in 1969 and designed by renowned architect Judith Chafee, the thoughtfully designed open-concept floor plan maximizes water views from almost every room and boundless natural light throughout. The Living Room, with expansive windows overlooking the water, and custom sliders for easy outside access, offers the "million dollar" view. Adjacent to the Living Room is "The Nook", cozy and comfortable with a massive fireplace. The remodeled Kitchen hosts an island for extra seating and granite counters. The convenient first-floor Primary Suite provides retreat-style living, with a full bath, dressing room & fireplace, all complimented by water views. The 1st floor also hosts a Library and Family Room. Four additional bedrooms on the 2nd floor also have water views and the other 2.5 baths offer privacy for family and guests. Two nooks on the 2nd floor (one with a fireplace) can provide the perfect home office spaces. Enjoy seamless indoor-outdoor entertaining with expansive decks - perfect for hosting gatherings or quiet moments with loved ones. The view offers a sparkling in ground gunite pool & spa, private sandy beach, and your own pier & dock. The expansive 3.10-acre property ensures complete privacy. The back "field" has a "boat house" for extra storage and has hosted two weddings! SPECTACULAR!
Full Property Details
Full Property Details for 51 Andrews Rd
General
- Price: $5,000,000
- Taxes: (July 2025-June 2026)
- Status: Active
- Type: Single Family
- Source: SMARTMLS
- MLS ID: 24122655
- Updated: 4/10/2026
- Added to Site: 224 day(s) ago
Interior
- Number of Rooms: 12
- Interior Features: Auto Garage Door Opener, Cable - Available, Open Floor Plan
- Fireplace: Yes
- Number of Fireplaces: 3
- Appliances: Gas Cooktop, Wall Oven, Microwave, Freezer, Subzero, Dishwasher, Disposal, Washer, Electric Dryer, Wine Chiller
Rooms
Bathrooms
- Total Bathrooms: 4
- Full Bathrooms: 3
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 4
- Primary Suite: Book Shelves, Bedroom Suite, Fireplace, Full Bath, Wal, 24 x 19, Main
- Bedroom 1: Bedroom - Wall/Wall Carpet, 11 x 16, Upper
- Bedroom 2: Bedroom - Hardwood Floor, 23 x 11, Upper
- Bedroom 3: Bedroom - Hardwood Floor, 23 x 11, Upper
Other Rooms
- Living Room: Living Room - Vaulted Ceiling, Balcony/Deck, Sliders, Hardwood Floor, 34 x 23, Main
- Kitchen: Kitchen - 2 Story Window(s), Vaulted Ceiling, Book Shelves, Granite Counters, Island, Tile Floor, 27 x 19, Main
- Dining Room: Dining Room - Hardwood Floor, 23 x 11, Main
- Office: Office - Wall/Wall Carpet, 16 x 7, Upper
- Den: Den - 2 Story Window(s), Vaulted Ceiling, Wall/Wall Carpet, 18 x 16, Main
- Study: Fireplace, Hardwood Floor, 16 x 9, Upper
- Library: Library - Vaulted Ceiling, Book Shelves, Built-Ins, W, 19 x 15, Main
- Loft: Loft - Hardwood Floor, 15 x 10, Upper
- Laundry: Main Level
Additional Information
- Pool: Yes
- Pool Description: Gunite, In Ground Pool
Exterior
- Exterior Features: Shed, Deck, Garden Area, Covered Deck
- Color: Grey
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Spaces: 2
- Total Spaces: 10
- Parking: Attached Garage, Driveway
Location
- County: New Haven
- Neighborhood: Old Quarry
- Driving Directions: Route 146, Leete's Island Road. Take left onto Old Quarry Rd. Take 1st left onto Andrews Road. Take 2nd driveway and follow signs for "Johnson".
School Information
- Elementary School: A. W. Cox
- Middle School: Adams
- Intermediate School: Baldwin
- High School: Guilford
Community
- Community Name: Old Quarry
Heating & Cooling
- Cooling Type: Central Air, Zoned
- Heating Type: Hot Air, Oil
- Heating Fuel: Oil
- Water Heater: Domestic
Utilities
- Sewer: Septic
- Water: Private Well
Structural Information
- Architectural Style: Contemporary
- Construction Status: No/Resale
- Exterior Const.: Shingle
- Basement Desc.: Crawl Space, Unfinished, Storage, Concrete Floor
- Roof: Flat
- Square Feet: 5,640
- Above Ground: 5,640 Sq. Ft.
- Year Built: 1969
Lot Features
- Lot Size (Acres): 3.1
- Driveway/Sidewalk: Private, Unpaved, Crushed Stone
- Zoning: R-5
- Lot Description: Secluded, Lightly Wooded, Sloping Lot, Water View
Water Features
- Water Front: Yes
- Water View: Yes
- Water Front Desc.: Harbor, L. I. Sound Frontage, Beach, Dock or Mooring, View, Access
Financial Considerations
- Assessment Amount: $2,260,580
- Tax Year: July 2025-June 2026
Disclosures and Reports
- Exclusions: Telephone Booth and flip-top sculpture
- Property ID: 1116172
Listed by William Pitt Sotheby's Int'l, Kirsten Adams
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agent
— 51 Andrews Rd —
Kirsten Adams
William Pitt Sotheby's Int'l
Agent Contact: (203) 500-4000 Office Contact: (203) 245-6700
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 51 Andrews Rd
School District:Guilford School District
| Name | Grades | Distance |
|---|---|---|
A. Baldwin Middle School 68 Bullard Drive, Guilford, CT 06437 | 5-6 | 5.3 mi |
E. C. Adams Middle School 233 Church Street, Guilford, CT 06437 | 7-8 | 3 mi |
Guilford High School 605 New England Road, Guilford, CT 06437 | 9-12 | 3.6 mi |
Disclaimer:
School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 51 Andrews Rd
Tax History
Tax History for 51 Andrews Rd
Year
Property Taxes
Change
Tax Assessment
Change
2024
$62,505
3%
$2,260,580
-1%
2023
$60,408
3%
$2,272,690
—
2023
$58,817
19%
$2,272,690
52%
2022
$49,580
2%
$1,491,130
—
2021
$48,641
1%
$1,491,130
—
2020
$48,178
1%
$1,491,130
—
2019
$47,761
2%
$1,491,130
—
2018
$46,643
-2%
$1,491,130
-8%
2017
$47,699
2%
$1,624,620
—
2016
$46,578
2%
$1,624,620
—
2015
$45,879
3%
$1,624,620
—
2014
$44,547
8%
$1,624,620
-9%
2011
$41,289
—
$1,790,510
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 51 Andrews Rd
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 2 hours ago
- 4Beds
- 3Total Baths
- 2,253Sq. Ft.
Listed by Cathy Lynch & Team (203) 627-2331
- Single Family
- Active
- Updated 4 days ago
- 3Beds
- 2Total Baths
- 864Sq. Ft.
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 2Total Baths
- 3,882Sq. Ft.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 2 days ago
- 5Beds
- 6Total Baths
- 5,543Sq. Ft.
- Single Family
- Active
- Updated 8 hours ago
- 6Beds
- 2Total Baths
- 2,728Sq. Ft.
Listed by Samantha Celentano (203) 871-8254
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
51 Andrews Road, Guilford, CT 06437 (MLS# 24122655) is a Single Family property with 4 bedrooms, 3 full bathrooms and 1 partial bathroom. 51 Andrews Road is currently listed for $5,000,000 and was received on September 02, 2025. Want to learn more about 51 Andrews Road? Do you have questions about finding other Single Family real estate for sale in Guilford? You can browse all Guilford real estate or contact a Coldwell Banker agent to request more information.