48 Andrews Rd

3,948 Sq. Ft.
$557 / Sq. Ft.
3,948
Sq. Ft.
$557
per Sq. Ft.

Description

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...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.
  1. Listed by Joseph Piscitelli • Coldwell Banker Realty
    P: (203)-982-3511 C: (203)-982-3511 joe.piscitelli@coldwellbankermoves.com
  2. Listed by John L Guarino • Coldwell Banker Realty
    P: (203)-878-7424 C: (203)-308-7684 john.guarino@cbmoves.com

Property Details for 48 Andrews Road

Basement Description
Full, Partially Finished
Direct Waterfront
No
Garages Number
2
Neighborhood
Old Quarry
Style
Colonial, Contemporary
Garage Parking Info
Detached Garage, Off Street Parking, Driveway
Swimming Pool
Yes
LISTING CLOSED: 12/12/2025 12:00 AM

Property Details for 48 Andrews Road

StatusClosed
MLS #24074214
Days on Market143
Taxes$39,124 / year
HOA Fees-
Condo/Co-op Fees-
Property TypeSingle Family
MLS TypeResidential
Year Built1981
Lot Size3.39 AC / 147,668 SF
CountyNew Haven County

Location

Listing Courtesy of Coldwell Banker Realty, Joseph Piscitelli; Coldwell Banker Realty, John L Guarino

Sold By William Raveis Real Estate, Rose Ciardiello

Add your commute

Building Information for 48 Andrews Road

Stories-Year Built1981Building Size-Lot Size3.39 AC / 147,668 SF

Payment Calculator

$14,443 per month

30 year fixed, 6.55% Interest

Principal and Interest

$11,182

Property Taxes

$3,260

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 48 Andrews Road

Summary
Property and Location
  • Acres Source: Public Records
  • Directions: Route 146 to Old Quarry Rd, left on Andrews, house on right
  • Elementary School: A. W. Cox
  • Flood Zone: No
  • High School: Guilford
  • Intermediate School: Baldwin
  • Latitude: 41.262411
  • Longitude: -72.726301
  • Middle Jr High School: Adams
  • State: Connecticut
Parking
  • Parking Total Spaces: 5
HOA and Fees
  • Home Owner's Assocation: No
  • Tax Year: July 2025-June 2026
  • Property Tax: $39,124
Interior and Exterior Features
Exterior Features
  • Exterior Features: Balcony, Deck, Garden Area, Lighting, Stone Wall, Patio
  • Pool Description: In Ground Pool
  • Waterfront Description: Walk to Water, Dock or Mooring, View, Access
Interior Features
  • Appliances Included: Gas Range, Range Hood, Subzero, Washer, Dryer
  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Attic YN: No
  • Fireplaces Total: 3
  • Interior Features: Cable - Pre-wired
  • Rooms Total: 12
Room 1
  • Room Entry Order: 1
  • Room Features: 2 Story Window(s),9 ft+ Ceilings,Fireplace,Hardwood Floor
  • Room Length: 22.0
  • Room Level: Main
  • Room Type: Great Room
  • Room Width: 19.0
Room 2
  • Room Entry Order: 10
  • Room Features: Balcony/Deck,Bedroom Suite,Fireplace,Full Bath,Sliders,Hardwood Floor
  • Room Length: 19.0
  • Room Level: Lower
  • Room Type: Bedroom
  • Room Width: 15.0
Room 3
  • Room Entry Order: 11
  • Room Features: Balcony/Deck,Partial Bath,Sliders,Hardwood Floor
  • Room Length: 21.0
  • Room Level: Lower
  • Room Type: Rec/Play Room
  • Room Width: 15.0
Room 4
  • Room Entry Order: 2
  • Room Features: 9 ft+ Ceilings,Balcony/Deck,Sliders,Hardwood Floor
  • Room Length: 21.0
  • Room Level: Main
  • Room Type: Living Room
  • Room Width: 14.0
Room 5
  • Listing Key: 2DF679C09845026EE063D501100AF778
  • Room Entry Order: 3
  • Room Features: Breakfast Bar,Granite Counters,Pantry,Hardwood Floor
  • Room Length: 22.0
  • Room Level: Main
  • Room Type: Kitchen
  • Room Width: 19.0
Room 6
  • Room Entry Order: 4
  • Room Features: Sliders,Hardwood Floor
  • Room Length: 18.0
  • Room Level: Main
  • Room Type: Formal Dining Room
  • Room Width: 13.0
Room 7
  • Room Entry Order: 5
  • Room Features: 9 ft+ Ceilings,Balcony/Deck,Fireplace,Full Bath,Sliders,Walk-In Closet
  • Room Length: 37.0
  • Room Level: Upper
  • Room Type: Primary BR Suite
  • Room Width: 28.0
Room 8
  • Room Entry Order: 6
  • Room Features: Jack & Jill Bath,Hardwood Floor
  • Room Length: 18.0
  • Room Level: Main
  • Room Type: Bedroom
  • Room Width: 12.0
Room 9
  • Listing Key: 2DF679C09845026EE063D501100AF778
  • Room Entry Order: 7
  • Room Features: Jack & Jill Bath,Hardwood Floor
  • Room Length: 18.0
  • Room Level: Main
  • Room Type: Bedroom
  • Room Width: 13.0
Room 10
  • Room Entry Order: 8
  • Room Features: Hardwood Floor
  • Room Length: 15.0
  • Room Level: Upper
  • Room Type: Bedroom
  • Room Width: 11.0
Room 11
  • Room Entry Order: 9
  • Room Features: Hardwood Floor
  • Room Length: 14.0
  • Room Level: Upper
  • Room Type: Bedroom
  • Room Width: 11.0
Property
Property and Assessments
  • Color: Natural wood shingle
  • Construction Description: Frame
  • Driveway Type: Private, Circular, Crushed Stone, Dirt
  • Exterior Siding: Shake, Cedar
  • Foundation Type: Concrete
  • Fuel Tank Location: Above Ground
  • New Construction Type: No/Resale
  • Roof: Asphalt Shingle, Gable
  • Year Built: 1981
  • Year Built Source: Public Records
  • Bank Owned Property: No
  • In Law Apartment: No
  • Living Area SQFT Per Public Records: 3948
Lot Information
  • Lot Description: Lightly Wooded, Rocky, Sloping Lot, Water View
  • Parcel Number: 1116091
  • Sq Ft Est Heated Above Grade: 3948.0
  • Sq Ft Total: 3948.0
  • Zoning: R-5
Utilities
  • Energy Features: Generator
  • Heat Fuel Type: Oil
  • Hot Water Description: Other, Tankless Hotwater
  • Radon Mitigation Air: Unknown
  • Radon Mitigation Water: Unknown
  • Sewage System: Septic
  • Water Source: Private Well
Multi Family
Income and Expenses
  • Occupied By: Owner

Property History for 48 Andrews Road

DateEvent & SourcePriceAppreciation
Dec 9, 2025

Closed (Public Record)

Public Record #1924102192

$2,200,000

+3.5% / yr

May 5, 1999

Closed (Public Record)

Public Record #92189348

$875,000
DateEvent & SourcePrice
12/09/2025

Closed (Public Record)

Public Record #1924102192

$2,200,000

+3.5% / yr

05/05/1999

Closed (Public Record)

Public Record #92189348

$875,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 48 Andrews Road

Taxable ValueLand$1,178,660Additions$236,320Total$1,414,980
Tax Record2024$39,124 ($3,260 / month)
Home Facts
Beds6Baths5Total Finished SqFt3,948 SqFtAbove Grade Finished SqFt3,948 SqFtUnfinished Basement SqFt1,164 SqFtStories2Lot Size139,392 SqFtStyleSingle Family ResidenceYear Built1981Year Renovated2003ZoningR-5CountySOUTH CENTRAL CONNECTICUAPNGUIL M:012077A

Schools near 48 Andrews Road

This home is within Guilford School District.
Rating
School
Type
Grades
Distance
Public - 5 to 6
Public - 7 to 8
Public - 9 to 12
Public - K to 4
Rating
School
Distance
A. Baldwin Middle School
Public5 to 6

E. C. Adams Middle School
Public7 to 8

Guilford High School
Public9 to 12

A. W. Cox School
PublicK to 4

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Nearby home values

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Coldwell Banker Realty, Joseph Piscitelli; Coldwell Banker Realty, John L Guarino

Based on information from one of the following Multiple Listing Services: Darien MLS, Smart MLS and Greenwich Multiple Listing Service. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by Darien MLS, Smart MLS and Greenwich Multiple Listing Service is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.