40 Sterling Ridge Ct, Cheshire, CT 06410

Off market jan 2026 for $1.2M

$1,332,743

Est. refi paymentEst. refi $1,782/mo

•

3,942

sq ft

40 Sterling Ridge Ct, Cheshire, CT 06410

About this home

Exquisite Colonial with Pool, Finished Basement & Elegant Finishes. Welcome to this beautifully maintained 4-bedroom, 3.5-bath colonial, perfectly situated on 1.4 private acres at the end of a quiet cul-de-sac. From the moment you step inside, you'll be greeted by gleaming hardwood floors, crown molding, and wainscoting that flow seamlessly throughout the home, creating an atmosphere of timeless elegance. The spacious floor plan offers a perfect blend of formal and casual living spaces. The updated primary suite is a true retreat, featuring a newly renovated spa-like bathroom with a luxurious soaking tub and heated flooring for year-round comfort. The beautifully finished lower level expands your living space with a large living room, a full bar/kitchen, a full bathroom with shower, a dedicated exercise room, and a pantry for extra storage-all designed with the same attention to detail and beautiful finishes found throughout the home. Step outside to your own backyard oasis. The in-ground pool, pool house, built-in fire pit and expansive patios are ideal for summer entertaining or relaxing in total privacy. Meticulously maintained inside and out, this home offers the perfect combination of classic style and modern upgrades.

Single-familyProperty Type

2007Year Built

1.4 acresLot Size

$338Est. Price/Sq.Ft.

3 car garageParking

Listed by Leanne Delrosso • Lamacchia Realty

Listed by Marilyn Rock • Lamacchia Realty

Contact: Agent Attribution Contact: (860) 426-6886 | Office Attribution Contact: (860) 426-6886

Bought with Cindy Cox • William Raveis Real Estate

Source:Smart MLS #24123003

Redfin Estimate

$1,332,743

$103K since sold in January 2026$29K since September

Recently sold homes
Estimate history
Homes for sale

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

SOLD OCT 19, 2026
$865,000
A
4 beds3.5 baths4,178 sq ft
136 Village Gate Dr, Southington, CT 06489
SOLD JUL 9, 2026
$755,000
B
4 beds2.5 baths3,068 sq ft
1274 Cheshire St, Cheshire, CT 06410
SOLD OCT 2, 2026
$875,000
C
4 beds3.5 baths3,855 sq ft
570 Riverside Dr, Cheshire, CT 06410
SOLD SEP 21, 2026
$845,000
D
4 beds2.5 baths2,474 sq ft
19 E Ridge Ct, Cheshire, CT 06410
SOLD OCT 16, 2026
$525,000
E
4 beds3 baths3,557 sq ft
89 Shweky Ln, Southington, CT 06489
SOLD AUG 5, 2026
$650,000
F
4 beds2.5 baths2,329 sq ft
40 Southshire Dr, Southington, CT 06489

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

Earn from this home

Sell

$283,159

Est. take-home

List your home with Redfin and save $13,327

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$4,155/mo

Redfin rental estimate

List your home for rent

Market trends in 06410, CT

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

103.8%

+0.2% MoM

Median sale price

$621K

$13K MoM

Avg. days on market

44d

4 days MoM

Recently sold homes

113

7 MoM

New listings for sale

NEW 27 HRS AGO
$389,900
2 beds1 bath977 sq ft
45 Broadview Rd, Cheshire, CT 06410
OPEN OCT 31 TO 2PM
$675,000
4 beds2.5 baths2,256 sq ft
35 Brookside Pl, Cheshire, CT 06410
$519,900
3 beds2 baths1,564 sq ft
120 Hilltop Rd, Cheshire, CT 06410
OPEN TODAY, 12PM TO 2PM
$839,900
4 beds2.5 baths3,309 sq ft
256 Beacon Hill Dr, Cheshire, CT 06410
EARLY ACCESS
$500,000
4 beds2 baths2,250 sq ft
171 Cornwall Ave, Cheshire, CT 06410
COMING SOON
$425,000
2 beds2.5 baths1,700 sq ft
72 Quarry Village Rd #72, Cheshire, CT 06410
$589,900
3 beds2 baths2,054 sq ft
178 Harrison Rd, Cheshire, CT 06410
$230,000
2 beds2 baths1,122 sq ft
420 Robin Ct #420, Cheshire, CT 06410
See all

Provided by Redfin

Sale history for 40 Sterling Ridge Ct

Year

Property tax

Land + Additions

Assessment*

2023

$15,784 (+2.2%)

$160,130 + $289,680

$449,810

2022

$15,437 (+6.0%)

$160,130 + $289,680

$449,810

2021

$14,557 (+1.5%)

$160,130 + $271,580

$431,710

2020

$14,341

$160,130 + $271,580

$431,710

2019

$14,341 (−0.9%)

$160,130 + $271,580

$431,710

2018

$14,473 (+2.1%)

$160,830 + $282,860

$443,690

2017

$14,171 (+2.4%)

$160,830 + $282,860

$443,690

2016

$13,839 (+3.1%)

$160,830 + $282,860

$443,690

2014

$13,422 (−6.6%)

$160,830 + $282,860

$443,690

2011

$14,366

$180,040 + $340,470

$520,510

Tax history for 40 Sterling Ridge Ct

Year

Property tax

Land + Additions

Assessment*

2023

$15,784 (+2.2%)

$160,130 + $289,680

$449,810

2022

$15,437 (+6.0%)

$160,130 + $289,680

$449,810

2021

$14,557 (+1.5%)

$160,130 + $271,580

$431,710

2020

$14,341

$160,130 + $271,580

$431,710

2019

$14,341 (−0.9%)

$160,130 + $271,580

$431,710

2018

$14,473 (+2.1%)

$160,830 + $282,860

$443,690

2017

$14,171 (+2.4%)

$160,830 + $282,860

$443,690

2016

$13,839 (+3.1%)

$160,830 + $282,860

$443,690

2014

$13,422 (−6.6%)

$160,830 + $282,860

$443,690

2011

$14,366

$180,040 + $340,470

$520,510

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

Public record

Beds

Baths

3.5

Stories

Lot width

—

Lot depth

—

Lot size

1.4 Acres

Year renovated

—

Sq. Ft.

3,092

Year built

2007

Style

Single Family Residential

County

New Haven County

APN

2516671

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 12, 2023.

Property details

Parking

Garage Information
Garage & Parking: Attached Garage
Garages Number: 3

Interior

Virtual Tour Information

Interior Information
Total Rooms: 10
Laundry Room Location: Second Floor
Laundry Room Info: Upper Level
Interior Features: Cable - Pre-wired, Security System
Lighting, Security System
Fireplaces Total: 1
Cooling System: Central Air, Heat Pump
Appliances Included: Electric Cooktop, Wall Oven, Microwave, Refrigerator, Dishwasher, Washer, Electric Dryer

Bathroom Information
# of Baths (Full): 3
# of Baths (Half): 1

Bedroom Information
Beds Total: 4

Room Information
Basement Description: Full
Has Attic
Attic Description: Pull-Down Stairs

Exterior

Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Vinyl Siding
Exterior Features: Gutters, Lighting, Patio, Underground Utilities, Sidewalk, Deck, Covered Deck, Stone Wall, Underground Sprinkler

Lot Information
Lot Description: In Subdivision, Lightly Wooded, On Cul-De-Sac, Professionally Landscaped

Pool Information
Swimming Pool
Pool Description: Heated, Pool House, Vinyl, In Ground Pool

Building Information
Foundation Type: Concrete
Construction Description: Frame
Color: Brown/Taupe

Property Information
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 3092

Financial

Assessments Information
Assessed Value: $607,530

Utilities

Utility Information
Water Source: Public Water Connected
Sewage System: Septic
Hot Water Description: 50 Gallon Tank
Heat Type: Hot Air
Heat Fuel Type: Oil
Fuel Tank Location: In Basement
Energy Features: Generator, Thermopane Windows

Location

School Information
Middle Jr High School: Dodd
High School: Cheshire
Elementary School: Chapman

Location Information
State: Connecticut
Nearby Amenities: Golf Course, Health Club, Library, Medical Facilities, Park, Public Pool, Public Rec Facilities, Shopping/Mall
Directions: Route 10 to East Johnson, then Right onto Cheshire Str and Left onto Sterling Ridge Court
County: New Haven

Public facts

Beds: 4
Baths: 3.5
Sq. Ft.: 3,092
Stories: 2.0
Lot Size: 1.4 acres
Style: Single Family Residential
Year Built: 2007
Year Renovated: —
County: New Haven County
APN: 2516671

Home facts updated by county records on Jul 12, 2023

Other

Documents & Disclosures
Supplement Count Public: 3

Around this home

Schools

Chapman School

Public K-6 • Assigned • 2.5mi

8/10

Dodd Middle School

Public 7-8 • Assigned • 3.2mi

8/10

Cheshire High School

Public 9-12 • Assigned • 4.5mi

9/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

5/10 Heat Factor

7 days above 98° expected this year, 15 days in 30 years

6/10 Wind Factor

27% chance of strong winds in next 30 years

3/10 Air Factor

2 unhealthy days expected this year, 4 days in 30 years

Provided by First Street

Historical weather

Cheshire, CT • 06410

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

$1.27M – $1.53M

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

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

Nearby similar homes

OPEN OCT 31 TO 2PM

$675,000

4 beds2.5 baths2,256 sq ft

35 Brookside Pl, Cheshire, CT 06410

$699,000

4 beds4 baths4,475 sq ft

367 S End Rd, Plantsville, CT 06479

NEW CONSTRUCTION

$890,000

5 beds2.5 baths3,650 sq ft

171 Oregon Rd, Meriden, CT 06451

$239,900

2 beds1.5 baths1,196 sq ft

661 Allen Ave, Meriden, CT 06451

$399,000

3 beds1.5 baths1,504 sq ft

58 Home Ave, Meriden, CT 06451

$649,000

5 beds3.5 baths4,044 sq ft

30 Rolling Hills Dr, Meriden, CT 06451

New listings for sale in 06410

NEW 27 HRS AGO

$389,900

2 beds1 bath977 sq ft

45 Broadview Rd, Cheshire, CT 06410

OPEN OCT 31 TO 2PM

$675,000

4 beds2.5 baths2,256 sq ft

35 Brookside Pl, Cheshire, CT 06410

$519,900

3 beds2 baths1,564 sq ft

120 Hilltop Rd, Cheshire, CT 06410

OPEN TODAY, 12PM TO 2PM

$839,900

4 beds2.5 baths3,309 sq ft

256 Beacon Hill Dr, Cheshire, CT 06410

EARLY ACCESSCOMPASS COMING SOON

$500,000

4 beds2 baths2,250 sq ft

171 Cornwall Ave, Cheshire, CT 06410

COMING SOON

$425,000

2 beds2.5 baths1,700 sq ft

72 Quarry Village Rd #72, Cheshire, CT 06410

$589,900

3 beds2 baths2,054 sq ft

178 Harrison Rd, Cheshire, CT 06410

$230,000

2 beds2 baths1,122 sq ft

420 Robin Ct #420, Cheshire, CT 06410

Home values near 40 Sterling Ridge Ct

Data from public records.

Address	Redfin Estimate
50 Sterling Ridge Ct, Cheshire, CT 4 Beds \| 4.5 Baths \| 3530 Sq. Ft.	$1,169,662
45 Sterling Ridge Ct, Cheshire, CT 4 Beds \| 3.5 Baths \| 3079 Sq. Ft.	$1,159,874

Address	Redfin Estimate
55 Sterling Ridge Ct, Cheshire, CT 4 Beds \| 4.5 Baths \| 4406 Sq. Ft.	$1,255,209
35 Sterling Ridge Ct, Cheshire, CT 4 Beds \| 3.5 Baths \| 3063 Sq. Ft.	$1,038,008

Address	Redfin Estimate
30 Sterling Ridge Ct, Cheshire, CT 5 Beds \| 5 Baths \| 3800 Sq. Ft.	$1,068,426
25 Sterling Ridge Ct, Cheshire, CT 5 Beds \| 4 Baths \| 4268 Sq. Ft.	$1,162,997

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.

Guilford homes for sale
Wallingford homes for sale
Fairfield homes for sale
Glastonbury homes for sale
Farmington homes for sale

Houses for rent in Cheshire Village	Agents near me	Westport, CT homes for sale	Cheshire Village 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	Cheshire Village Property Records
Condos for sale near me	Norwalk, CT homes for sale	CT New Listings

06408 homes for sale
06410 homes for sale
06411 homes for sale

New Haven homes for sale
West Hartford homes for sale
Milford homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 06410, CT

Sale history for 40 Sterling Ridge Ct

Tax history for 40 Sterling Ridge Ct

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 06410

Home values near 40 Sterling Ridge Ct

More real estate resources