$2,485,000
$615K PRICE DROP

48 Andrews Rd Guilford, CT 06437

Estimated payment $16,866/month

Total Views 16,048
6 Beds
6 Baths
3,948 Sq Ft
$629 Price per Sq Ft

Highlights

  • In Ground Pool
  • Sub-Zero Refrigerator
  • Colonial Architecture
  • E.C. Adams Middle School Rated A-
  • 3.39 Acre Lot
  • Deck

About This Home

Guilford ~ Old Quarry Area ~ Waterview Contemporary ~ one of the most unique homes on the entire Eastern seaboard. Set on 3.39 Acres. Designed to capture spectacular southerly views over Little Harbor as well as Long Island Sound. With its walls of glass, high ceilings & numerous Transom windows this Unique Designed Home allows for natural views to flow easily through nearly every living area. The Main Level Features Dramatic Entertaining area including a spacious Renovated Chefs Kitchen with Wolf & Subzero Appliances, Granite counters & Center Island with Breakfast Bar. A Generous Great Room featuring wood burning FP, Curved 20ft ceiling, Family rm also with 20 ft Ceiling & Sliders to Large Deck, great for entertaining and evening dinners. Two Bedrooms overlooking Pool Area, plus full bath & powder rm complete this Floor. The upper level offers a Spectacular Primary Bedroom Suite w/deck for enjoying morning sunrises and evening sunsets, featuring a domed ceiling. Sitting Area/office w/FP & Sliders to Deck. Two additional bedrooms with Waterview's & bath. The Lower Level Offers a Guest bedroom w/ Wood Burning FP w/Sliders to Deck, Entertainment room leading to the pool area. Additional features include access to Little Harbor, Koi Pond, whole house generator, 2 car detached garage & circular driveway. Enjoy some of the best Boating, Kayaking & Hiking trails on the CT Shoreline. Convenient to Town, Yale and Train.

Listing Agent

Joseph Piscitelli

Coldwell Banker Realty License #RES.0542931 Listed on: 05/10/2025

Coldwell Banker Realty

Co-Listing Agent

John Guarino

Coldwell Banker Realty License #RES.0800672

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $39,124

Year Built

  • Built in 1981

Lot Details

  • 3.39 Acre Lot
  • Stone Wall
  • Garden
  • Property is zoned R-5

Home Design

  • Colonial Architecture
  • Contemporary Architecture
  • Concrete Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Cedar Siding
  • Shake Siding

Interior Spaces

  • 3,948 Sq Ft Home
  • 3 Fireplaces
  • Partially Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Gas Range
  • Range Hood
  • Sub-Zero Refrigerator

Bedrooms and Bathrooms

  • 6 Bedrooms

Laundry

  • Dryer
  • Washer

Parking

  • 2 Car Garage
  • Parking Deck
  • Circular Driveway
  • Dirt Driveway

Outdoor Features

  • In Ground Pool
  • Balcony
  • Deck
  • Patio
  • Exterior Lighting

Schools

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

Utilities

  • Central Air
  • Heating System Uses Oil
  • Heating System Uses Oil Above Ground
  • Power Generator
  • Private Company Owned Well
  • Tankless Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 1116091

Home Details

Home Type

Single Family

Est. Annual Taxes

$39,124

Year Built

Built in 1981

Lot Details

0

Listing Details

  • Neighborhood: Old Quarry
  • Property Type: Single Family For Sale
  • Style: Colonial, Contemporary
  • Sq Ft Est Heated Above Grade: 3948
  • Total Sq Ft: 3948
  • Year Built: 1981
  • New Construction: No/Resale
  • Remarks Public Addendum: 75 Miles to NYC. Only 45 miles to Bradley International A MUST SEE for those seeking a unique Waterfront community.
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: Unknown
  • Radon Mitigation Water Ynu: Unknown
  • Directions: Route 146 to Old Quarry Rd, left on Andrews, house on right
  • In Law Apartment: No
  • Living Area Sq Ft Per Public Record: 3948
  • Street Type: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 6
  • Total Bathrooms: 6
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Fireplaces: 3
  • Basement Description: Full, Partially Finished
  • Interior Amenities: Cable - Pre-wired
  • Appliances: Gas Range, Range Hood, Subzero, Washer, Dryer
  • Attic: No
  • Street Number Modifier: 48

Exterior Features

  • Exterior Features: Balcony, Deck, Garden Area, Lighting, Stone Wall, Patio
  • Exterior Siding: Shake, Cedar
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle Gable
  • Waterfront Description: Walk to Water Dock or Mooring View Access
  • Swimming Pool: Yes
  • Pool: In Ground Pool
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 2
  • Driveway Type: Private, Circular, Crushed Stone, Dirt
  • Total Parking Spaces: 5
  • Garage And Parking: Detached Garage, Off Street Parking, Driveway

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Oil
  • Fuel Tank Location: Above Ground
  • Hot Water Description: Other, Tankless Hotwater
  • Water Source: Private Well
  • Sewer: Septic

Schools

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

Green Features

  • Energy Features: Generator

Lot Info

  • Acres: 3.39
  • Lot Description: Lightly Wooded Rocky Sloping Lot Water View
  • Flood Zone: No
  • Zoning: R-5
  • Parcel #: 1116091

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 39124
  • Total Assessed Value: 1414980
  • 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 $43,639 $1,641,780 $1,198,680 $443,100
2023 $42,489 $1,641,780 $1,198,680 $443,100
2022 $19,414 $583,890 $294,270 $289,620
2021 $19,046 $583,890 $294,270 $289,620
2020 $18,865 $583,890 $294,270 $289,620
2019 $18,702 $583,890 $294,270 $289,620
2018 $18,264 $583,890 $294,270 $289,620
2017 $18,112 $616,900 $283,230 $333,670
2016 $17,687 $616,900 $283,230 $333,670
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/01/2025 08/01/25 Price Changed $2,485,000 -6.2% $629 / Sq Ft
07/11/2025 07/11/25 Price Changed $2,650,000 -5.4% $671 / Sq Ft
06/25/2025 06/25/25 Price Changed $2,800,000 -9.7% $709 / Sq Ft
05/10/2025 05/10/25 For Sale $3,100,000 -- $785 / Sq Ft
Source: SmartMLS

Purchase History

Date Type Sale Price Title Company
Warranty Deed $875,000 --
Deed $1,037,500 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $1,500,000 No Value Available
Previous Owner $400,000 No Value Available
Previous Owner $300,000 No Value Available
Previous Owner $550,000 No Value Available
Source: Public Records

Similar Homes in the area

  • 75 Half Mile Rd, Guilford, CT 06437

    $2,450,000

    • 5 Beds
    • 7.5 Baths
    • 8,476 Sq Ft
    • 75 Half Mile Rd
    • Guilford, CT

    Introducing a custom-built Adirondack-style masterpiece, set on over 5 acres of pristine land. Designed with care by the current owners, this home boasts a seamless layout, ideal for entertaining. Spacious, elegantly appointed rooms feature a custom-designed kitchen, soaring ceilings, and a stunning two-sided stone fireplace. Each bedroom is en suite, offering both privacy and luxury. The

    Cathy Lynch Coldwell Banker Realty

    Section Image
  • 24 Indigo Trail, Madison, CT 06443

    $2,875,000

    • 4 Beds
    • 4.5 Baths
    • 6,194 Sq Ft
    • 24 Indigo Trail
    • Madison, CT

    Come see this stately custom Brick English Georgian home in sought after Madison CT, nestled on a sprawling 5.65 acre lot with Neck River frontage. This exquisite 6,194 square foot Brick English Georgian offers an unparalleled blend of luxury, privacy and natural beauty. With 4 bedrooms and 4.5 baths, it is designed for those who appreciate both elegance and tranquility. This unique residence is

    Ron Stewart Houlihan Lawrence WD

    Section Image
  • 65 Water St, Guilford, CT 06437

    $2,000,000

    • 4 Beds
    • 3.5 Baths
    • 3,376 Sq Ft
    • 65 Water St
    • Guilford, CT

    Welcome to this beautifully reimagined colonial home, perfectly situated just a short Stroll from Guilford's historic green. Blending timeless charm with modern luxury, this exquisite four-bedroom, three and a half bath residence offers refined living in one of Connecticut's most coveted coastal communities. From the moment you step through the front door, you're welcomed by a grand three-story

    Meig Walz Newcomb Coldwell Banker Realty

    Section Image
  • 173 Highwoods Dr, Guilford, CT 06437

    $1,950,000

    • 5 Beds
    • 9 Baths
    • 5,414 Sq Ft
    • 173 Highwoods Dr
    • Guilford, CT

    A MAGNIFICENT REVIVAL & TIMELESS BLEND OF SOMETHING OLD & SOMETHING NEW. One of the finest restorations in New England, the Pitkin mansion is a true historical treasure. Carefully dismantled & moved to its current site in 1955, the property is nestled within nearly 4 acres of mature trees, manicured lawns, & magical gardens. This classic revival will be celebrated by the most discerning antique

    Kiara Rusconi William Raveis Real Estate

    Section Image
  • 412 Tanner Marsh Rd, Guilford, CT 06437

    $2,150,000

    • 4 Beds
    • 4.5 Baths
    • 4,000 Sq Ft
    • 412 Tanner Marsh Rd
    • Guilford, CT

    NEW CONSTRUCTION: Discover the perfect blend of elegance and comfort in this newly constructed home, located on scenic Tanner Marsh Rd. Just minutes to I-95 and the Guilford train station, it has easy access to Yale, Guilford historic district, shopping and restaurants. Convenience is an integral part of the lifestyle. This property has four luxurious bedrooms and 4.1 bathrooms, including a

    Diane Dupont William Pitt Sotheby's Int'l

    Section Image

Source: SmartMLS

MLS Number: 24074214

SmartMLS

APN: GUIL-000120-000000-000077A