$5,000,000

51 Andrews Rd Guilford, CT 06437

Estimated payment $31,718/month

Total Views 6,005
4 Beds
3.5 Baths
5,640 Sq Ft
$887 Price per Sq Ft

Highlights

  • In Ground Pool
  • Sub-Zero Refrigerator
  • 3.1 Acre Lot
  • E.C. Adams Middle School Rated A-
  • Waterfront
  • Open Floorplan

About This Home

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!

Listing Agent

Kirsten Adams

William Pitt Sotheby's Int'l License #RES.0789096 Listed on: 09/02/2025

William Pitt Sotheby's Int'l

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $62,505

Year Built

  • Built in 1969

Lot Details

  • 3.1 Acre Lot
  • Waterfront
  • Garden
  • Property is zoned R-5

Home Design

  • Contemporary Architecture
  • Flat Roof Shape
  • Concrete Foundation
  • Frame Construction
  • Flat Tile Roof
  • Concrete Siding
  • Shingle Siding

Interior Spaces

  • 5,640 Sq Ft Home
  • Open Floorplan
  • 3 Fireplaces
  • Concrete Flooring

Kitchen

  • Built-In Oven
  • Gas Cooktop
  • Microwave
  • Sub-Zero Refrigerator
  • Dishwasher
  • Wine Cooler
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry on main level
  • Electric Dryer
  • Washer

Unfinished Basement

  • Crawl Space
  • Basement Storage

Parking

  • 2 Car Garage
  • Parking Deck
  • Automatic Garage Door Opener
  • Private Driveway

Pool

  • In Ground Pool
  • Gunite Pool

Outdoor Features

  • Covered Deck
  • Shed

Schools

  • A. W. Cox Elementary School
  • Adams Middle School
  • Baldwin Middle School
  • Guilford High School

Utilities

  • Zoned Heating and Cooling
  • Heating System Uses Oil
  • Private Company Owned Well
  • Fuel Tank Located in Basement
  • Cable TV Available

Listing and Financial Details

  • Exclusions: Telephone Booth and flip-top sculpture
  • Assessor Parcel Number 1116172

Home Details

Home Type

Single Family

Est. Annual Taxes

$62,505

Year Built

Built in 1969

Lot Details

0

Listing Details

  • Neighborhood: Old Quarry
  • Property Type: Single Family For Sale
  • Style: Contemporary
  • Sq Ft Est Heated Above Grade: 5640
  • Total Sq Ft: 5640
  • Year Built: 1969
  • New Construction: No/Resale
  • Remarks Public Addendum: To see a video of the home, click on camera icon underneath the main photo.
  • Exclusions: Telephone Booth and flip-top sculpture
  • Direct Waterfront: Yes
  • Encumbrances Restrictions: Deed Restrictions, Easements
  • Home Warranty Offered: No
  • 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".
  • Living Area Sq Ft Per Public Record: 5640
  • Street Type: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 4
  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Fireplaces: 3
  • Basement Description: Crawl Space, Unfinished, Storage, Concrete Floor
  • Interior Amenities: Auto Garage Door Opener, Cable - Available, Open Floor Plan
  • Appliances: Gas Cooktop, Wall Oven, Microwave, Freezer, Subzero, Dishwasher, Disposal, Washer, Electric Dryer, Wine Chiller
  • Laundry Room Location: main floor
  • Laundry Room Info: Main Level
  • Attic: No
  • Street Number Modifier: 51

Exterior Features

  • Exterior Features: Shed, Deck, Garden Area, Covered Deck
  • Exterior Siding: Shingle
  • Foundation Type: Concrete
  • Roof Information: Flat
  • Waterfront Description: Harbor L. I. Sound Frontage Beach Dock or Mooring View Access
  • Swimming Pool: Yes
  • Pool: Gunite, In Ground Pool
  • Construction Description: Frame, Concrete

Garage/Parking

  • Garages Number: 2
  • Driveway Type: Private, Unpaved, Crushed Stone
  • Total Parking Spaces: 10
  • Garage And Parking: Attached Garage, Driveway

Utilities

  • Cooling System: Central Air, Zoned
  • Heat Type: Hot Air
  • Heat Fuel Type: Oil
  • Fuel Tank Location: In Basement
  • Hot Water Description: Domestic
  • Water Source: Private Well
  • Sewer: Septic

Schools

  • Elementary School: A. W. Cox
  • Middle School: Adams
  • High School: Guilford
  • Intermediate School: Baldwin

Lot Info

  • Acres: 3.1
  • Lot Description: Secluded Lightly Wooded Sloping Lot Water View
  • Flood Zone: No
  • Zoning: R-5
  • Parcel #: 1116172

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 62505
  • Total Assessed Value: 2260580
  • Mil Rate Total: 27.65

MLS Schools

  • Elementary School: A. W. Cox
  • Middle Jr High School: Adams
  • High School: Guilford

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $60,408 $2,272,690 $1,732,430 $540,260
2023 $58,817 $2,272,690 $1,732,430 $540,260
2022 $49,580 $1,491,130 $1,148,210 $342,920
2021 $48,641 $1,491,130 $1,148,210 $342,920
2020 $48,178 $1,491,130 $1,148,210 $342,920
2019 $47,761 $1,491,130 $1,148,210 $342,920
2018 $46,643 $1,491,130 $1,148,210 $342,920
2017 $47,699 $1,624,620 $1,311,650 $312,970
2016 $46,578 $1,624,620 $1,311,650 $312,970
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/02/2025 09/02/25 For Sale $5,000,000 -- $887 / Sq Ft
Source: SmartMLS

Purchase History

Date Type Sale Price Title Company
Quit Claim Deed -- --
Quit Claim Deed -- --
Quit Claim Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $322,700 No Value Available
Previous Owner $290,000 No Value Available
Source: Public Records

Source: SmartMLS

MLS Number: 24122655

SmartMLS

APN: GUIL-000000-000000-012077