Off Market Nov 2025 for $345K

$398,262

Est. refi paymentEst. refi $592/mo

•

923

sq ft

42 Windsor Rd, Hamden, CT 06517

About this home

Renovated Gem in Hamden's Ridge Hill Neighborhood Looking for a move-in ready home that fits your life right now? Welcome to 42 Windsor Road. This Cape has been redone from top to bottom, so you can skip the projects and just enjoy it. The main level gives you an open layout with hardwood floors, a brand-new kitchen, and a first-floor primary suite with its own full bath-no more sharing the bathroom first thing in the morning- and a second full bath. Upstairs you'll find two more bedrooms, perfect for kids, guests, or even a home office. Fresh paint, updated finishes, and all the big stuff done make it easy to picture yourself here. The basement is ready to finish down the road if you need more space, and the detached garage keeps your car (and all your gear) tucked away. There's even a nice yard for summer cookouts or a game of fetch with the dog. Tucked between Ridge Road and State Street, it's a quick hop to the Parkway, I-91, I-95, or Metro-North. Groceries, parks, and restaurants are close by, so everything you need is right at hand. This is the kind of house you settle into and stay a while. Come take a look-you might not want to leave.

The finished space on the second floor brings the total sqft to 1380 per the owner.

Single-familyProperty Type

1951Year Built

6,969 sq ftLot Size

$431Est. Price/Sq.Ft.

1 garage spacesParking

Listed by Heike Hyka Severine • Coldwell Banker Realty

Contact: Agent Attribution Contact: (860) 385-6315 | Office Attribution Contact: (203) 795-6000

Bought with Stacey Schwartz • Coldwell Banker Realty

Source:Smart MLS #24128735

Redfin Estimate

$398,262

$53K since sold in November 2025$7,000 since July

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 2.6% higher than the average sale price ($388K) of 6 comparable homes.

SOLD JUN 15, 2026
$405,000
A
3 beds1.5 baths1,307 sq ft
122 Corbin Rd, Hamden, CT 06517
SOLD MAY 18, 2026
$385,000
B
3 beds1.5 baths1,690 sq ft
110 Corbin Rd, Hamden, CT 06517
SOLD JUL 2, 2026
$295,000
C
3 beds1.5 baths1,152 sq ft
1002 Winchester Ave, Hamden, CT 06517
SOLD MAY 31, 2026
$245,000
D
3 beds2 baths1,509 sq ft
53 Park Rd, New Haven, CT 06517
SOLD JUN 15, 2026
$625,000
E
3 beds2.5 baths1,722 sq ft
12 Orchard Ct, Hamden, CT 06517
SOLD MAY 28, 2026
$374,000
F
4 beds2 baths1,310 sq ft
78 Edgecomb St, Hamden, CT 06517

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$101,317

Est. take-home

List your home with Redfin and save $3,983

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,462/mo

Redfin rental estimate

List your home for rent

Market trends in 06517, CT

Last updated July 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

102.6%

0.6% MoM

Median sale price

$409K

$14K MoM

Avg. days on market

46d

3 days MoM

Recently sold homes

24 MoM

New listings for sale

COMING SOON
$199,999
1 bed1 bath738 sq ft
22 N Lake Dr Unit D2, Hamden, CT 06517
$122,700
1 bed1 bath790 sq ft
1730 State St #106, Hamden, CT 06517
$380,000
4 beds1.5 baths1,637 sq ft
118 Bryden Ter, Hamden, CT 06517
$399,000
3 beds2 baths1,586 sq ft
17 Ralston Ave, Hamden, CT 06517
$399,900
4 beds2 baths1,970 sq ft
355 Goodrich St, Hamden, CT 06517
$317,500
3 beds1.5 baths1,170 sq ft
138 Sebec St, Hamden, CT 06517
3D WALKTHROUGH
$189,900
3 beds1.5 baths1,102 sq ft
337 Mill Rock Rd #337, Hamden, CT 06517
OPEN SAT, 12PM TO 2PM
$410,000
3 beds2.5 baths1,481 sq ft
30 Wright Ln, Hamden, CT 06517
$499,900
3 beds2.5 baths2,248 sq ft
52 Putnam Ave, Hamden, CT 06517
See all

Provided by Redfin

Sale history for 42 Windsor Rd

Year

Property tax

Land + Additions

Assessment*

2023

$6,465 (+1.6%)

$35,210 + $79,450

$114,660

2022

$6,361 (+5.8%)

$35,210 + $79,450

$114,660

2021

$6,013 (+15.1%)

$35,210 + $79,450

$114,660

2020

$5,225 (+6.4%)

$45,920 + $54,600

$100,520

2019

$4,911 (+1.9%)

$45,920 + $54,600

$100,520

2018

$4,821 (+6.0%)

$45,920 + $54,600

$100,520

2017

$4,550 (−0.2%)

$45,920 + $54,600

$100,520

2016

$4,560 (+7.0%)

$45,920 + $54,600

$100,520

2014

$4,260 (+2.6%)

$48,160 + $58,520

$106,680

2011

$4,154

$48,160 + $58,520

$106,680

Tax history for 42 Windsor Rd

Year

Property tax

Land + Additions

Assessment*

2023

$6,465 (+1.6%)

$35,210 + $79,450

$114,660

2022

$6,361 (+5.8%)

$35,210 + $79,450

$114,660

2021

$6,013 (+15.1%)

$35,210 + $79,450

$114,660

2020

$5,225 (+6.4%)

$45,920 + $54,600

$100,520

2019

$4,911 (+1.9%)

$45,920 + $54,600

$100,520

2018

$4,821 (+6.0%)

$45,920 + $54,600

$100,520

2017

$4,550 (−0.2%)

$45,920 + $54,600

$100,520

2016

$4,560 (+7.0%)

$45,920 + $54,600

$100,520

2014

$4,260 (+2.6%)

$48,160 + $58,520

$106,680

2011

$4,154

$48,160 + $58,520

$106,680

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Permits

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

6,970 Sq. Ft.

Year renovated

—

Sq. Ft.

924

Year built

1951

Style

Single Family Residential

County

New Haven County

APN

1130359

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 13, 2023.

Feb 8, 2026 • Final

Plmb

Install a new bathtub, vanity, and kitchen sink.

Bathroom

Kitchen

Plumbing

Feb 8, 2026 • Final

Elec

Install recessed lighting and ground fault circuit interrupter outlets in the kitchen and bathrooms. Perform electrical wiring for the bathrooms.

Bathroom

Electrical

Kitchen

Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.

Property details

Parking

Garage Information
Garage & Parking: Detached Garage, Driveway
Garages Number: 1

Parking Information
Parking Total Spaces: 3

Interior

Virtual Tour Information

Interior Information
Total Rooms: 5
Laundry Room Location: basement
Laundry Room Info: Lower Level
Interior Features: Open Floor Plan
In-Law Apartment: No
Appliances Included: Oven/Range, Microwave, Refrigerator, Dishwasher

Bathroom Information
# of Baths (Full): 2

Bedroom Information
Beds Total: 3

Room Information
Basement Description: Full, Unfinished, Full With Hatchway

Exterior

Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Vinyl Siding
Exterior Features: Sidewalk, Gutters, Lighting

Lot Information
Lot Description: Level Lot

Building Information
Foundation Type: Block, Concrete
Construction Description: Frame
Color: tan

Property Information
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 924
Driveway Type: Private

Financial

Assessments Information
Assessed Value: $177,380

Utilities

Utility Information
Water Source: Public Water Connected
Sewage System: Public Sewer In Street
Hot Water Description: Natural Gas
Heat Type: Hot Air, Wall Unit, Zoned
Heat Fuel Type: Electric, Natural Gas
Energy Features: Thermopane Windows

Location

School Information
Middle Jr High School: Hamden
Intermediate School: Per Board of Ed
High School: Hamden
Elementary School: Ridge Hill

Location Information
State: Connecticut
Nearby Amenities: Commuter Bus, Library, Park, Walk to Bus Lines
Directions: Use GPS
County: New Haven

Public facts

Beds: 2
Baths: 1.0
Sq. Ft.: 924
Stories: 1.0
Lot Size: 6,970 square feet
Style: Single Family Residential
Year Built: 1951
Year Renovated: —
County: New Haven County
APN: 1130359

Home facts updated by county records on Jul 13, 2023

Other

Documents & Disclosures
Supplement Count Public: 2

Around this home

Schools

Ridge Hill School

Public PreK-6 • Assigned • 0.4mi

5/10

Hamden Middle School

Public 7-8 • Assigned • 2.8mi

5/10

Hamden High School

Public 9-12 • Assigned • 2.2mi

4/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

6/10 Heat Factor

7 days above 99° expected this year, 16 days in 30 years

6/10 Wind Factor

56% chance of strong winds in next 30 years

5/10 Air Factor

6 unhealthy days expected this year, 8 days in 30 years

Provided by First Street

Historical weather

Hamden, CT • 06517

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 8.9 hours in June and 4.4 hours in December, placing it below the U.S. average for solar exposure.

8.9 hrs

4.4 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$379,000 – $459,000

Reach more buyers when you sell with Redfin. Save up to $3,983 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

$265,000

2 beds1 bath1,305 sq ft

46 Watson St, New Haven, CT 06511

$277,990

3 beds1.5 baths902 sq ft

54 Lombard St, New Haven, CT 06513

$369,900

3 beds1.5 baths1,262 sq ft

52 Glen Haven Rd, New Haven, CT 06513

$459,000

4 beds2 baths1,616 sq ft

19 Armory St, Hamden, CT 06517

$399,000

2 beds1.5 baths1,120 sq ft

15 Hine Pl, New Haven, CT 06511

FOR SALE BY OWNER

$585,000

6 beds2.5 baths3,171 sq ft

150 Ridgewood Ave, North Haven, CT 06473

New listings for sale in 06517

COMING SOON

$199,999

1 bed1 bath738 sq ft

22 N Lake Dr Unit D2, Hamden, CT 06517

$122,700

1 bed1 bath790 sq ft

1730 State St #106, Hamden, CT 06517

$380,000

4 beds1.5 baths1,637 sq ft

118 Bryden Ter, Hamden, CT 06517

$399,000

3 beds2 baths1,586 sq ft

17 Ralston Ave, Hamden, CT 06517

$399,900

4 beds2 baths1,970 sq ft

355 Goodrich St, Hamden, CT 06517

$317,500

3 beds1.5 baths1,170 sq ft

138 Sebec St, Hamden, CT 06517

3D WALKTHROUGH

$189,900

3 beds1.5 baths1,102 sq ft

337 Mill Rock Rd #337, Hamden, CT 06517

OPEN SAT, 12PM TO 2PM

$410,000

3 beds2.5 baths1,481 sq ft

30 Wright Ln, Hamden, CT 06517

$499,900

3 beds2.5 baths2,248 sq ft

52 Putnam Ave, Hamden, CT 06517

Home values near 42 Windsor Rd

Data from public records.

Address	Redfin Estimate
21 Windsor Road, Hamden, CT 3 Beds \| 1 Baths \| 1116 Sq. Ft.	$347,178
30 Windsor Road, Hamden, CT 2 Beds \| 1.5 Baths \| 1488 Sq. Ft.	$290,904

Address	Redfin Estimate
18 Windsor Road, Hamden, CT 1 Beds \| 1 Baths \| 744 Sq. Ft.	$258,382
48 Windsor Road, Hamden, CT 3 Beds \| 1 Baths \| 1524 Sq. Ft.	$361,555

Address	Redfin Estimate
24 Windsor Road, Hamden, CT 3 Beds \| 2 Baths \| 1116 Sq. Ft.	$373,505
69 Windsor Road, Hamden, CT 3 Beds \| 1 Baths \| 1116 Sq. Ft.	$354,129

Property information provided by Smart MLS when last listed in 2025. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in New Haven County	Agents near me	Norwalk, CT homes for sale	New Haven County Housing Market
Houses for sale near me	Greenwich, CT homes for sale	New Haven, CT homes for sale
Land for sale near me	Stamford, CT homes for sale	Milford, CT homes for sale
Open Houses near me	West Hartford, CT homes for sale	New Haven County Property Records
Condos for sale near me	Westport, CT homes for sale	CT New Listings

New Haven homes for sale
Trumbull homes for sale
Milford homes for sale

Westchester County homes for sale
Nassau County homes for sale
Suffolk County homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 06517, CT

Sale history for 42 Windsor Rd

Tax history for 42 Windsor Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 06517

Home values near 42 Windsor Rd

More real estate resources