Off market aug 2017 for $765K

$1,173,124

Est. refi paymentEst. refi $5,164/mo

•

3,122

sq ft

5 Sterling Ridge Ct, Cheshire, CT 06410

About this home

This spectacular colonial blends warmth and sophistication in one. The quality and attention to detail come together to make this luxury home stand apart from the rest. Situated on a picturesque parcel with a level back yard in the desirable Sterling Ridge neighborhood, it is less than 5 min to highway access. Pristine 13 room home features a dramatic 2 story foyer, HW flooring on the 1st level & a gourmet kitchen w the finest amenities. The formal living/dining rooms have custom trim & moldings. The family room boasts a vaulted ceiling, gas FP w marble surround and triple window. The master bedroom is accented by a tray ceiling and spa-like bath w whirlpool tub & double sinks, & a custom designed walk in closet. The 2nd floor includes 3 add'l spacious bedrooms, a bonus room and an add'l full bath. The sun drenched 1100 sf lower level has a full bath and 2 add'l rooms for visiting in laws, au pair, guests etc. Enjoy outdoor living on the 3 tiered deck overlooking heated in-ground pool, hot tub & patio surrounded by seasonal gardens. Resort style living at its best. This is the quintessential home where traditions start and memories are made! Add'l features: 3 car garage w overhead storage & bike racks, prof outdoor lighting of home, deck & pool, stamped concrete driveway, storage shed, Andersen windows, sprinkler system, 325 gal buried propane tank for pool, FP, grill & cooking. See drone video attached.

Single-familyProperty Type

2006Year Built

0.99 acresLot Size

$376Est. Price/Sq.Ft.

3 car garageParking

Listed by Doreen Duchette • Coldwell Banker Realty

Listed by Robin Thurston • Coldwell Banker Realty

Bought with Sharon Peel • Berkshire Hathaway NE Prop.

Source:Smart MLS #N10220008

Redfin Estimate

$1,173,124

$408K since sold in August 2017$14K since September

Recently sold homes
Estimate history
Homes for sale

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

SOLD SEP 21, 2026
$845,000
A
4 beds2.5 baths2,474 sq ft
19 E Ridge Ct, Cheshire, CT 06410
SOLD OCT 2, 2026
$875,000
B
4 beds3.5 baths3,855 sq ft
570 Riverside Dr, Cheshire, CT 06410
SOLD SEP 28, 2026
$840,000
C
4 beds4.5 baths3,480 sq ft
101 Claudia Dr, Southington, CT 06489
SOLD SEP 22, 2026
$670,000
D
4 beds2.5 baths2,392 sq ft
665 Quinnipiac Ct, Cheshire, CT 06410
SOLD AUG 31, 2026
$700,000
E
3 beds2.5 baths2,934 sq ft
132 Debbie Dr, Meriden, CT 06451
SOLD JUL 9, 2026
$755,000
F
4 beds2.5 baths3,068 sq ft
1274 Cheshire St, Cheshire, CT 06410

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

Earn from this home

Sell

$610,702

Est. take-home

List your home with Redfin and save $11,731

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$4,164/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

EARLY ACCESS
$500,000
4 beds2 baths2,250 sq ft
171 Cornwall Ave, Cheshire, CT 06410
OPEN TODAY, 4:30PM TO 6PM
$1,050,000
4 beds3.5 baths4,515 sq ft
20 Baxter Ct, Cheshire, CT 06410
COMING SOON
$425,000
2 beds2.5 baths1,700 sq ft
72 Quarry Village Rd #72, Cheshire, CT 06410
COMING SOON
$839,900
4 beds2.5 baths3,309 sq ft
256 Beacon Hill Dr, Cheshire, CT 06410
$499,999
3 beds2.5 baths1,642 sq ft
268 Eastgate Dr, 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
OPEN SAT, 11:30AM TO 2PM
$538,000
2 beds2 baths1,960 sq ft
3 Racebrook Ct, Cheshire, CT 06410
OPEN SUN, 12PM TO 2PM
$415,000
2 beds1 bath974 sq ft
1016 Sperry Rd, Cheshire, CT 06410
See all

Provided by Redfin

Sale history for 5 Sterling Ridge Ct

Join or sign in to view all info

Year

Property tax

Land + Additions

Assessment*

2023

$15,659 (+2.2%)

$136,400 + $309,840

$446,240

2022

$15,315 (+1.8%)

$136,400 + $309,840

$446,240

2021

$15,047 (+1.5%)

$136,400 + $309,840

$446,240

2020

$14,824

$136,400 + $309,840

$446,240

2019

$14,824 (+1.6%)

$136,400 + $309,840

$446,240

2018

$14,597 (+2.1%)

$137,000 + $310,490

$447,490

2017

$14,293 (+2.4%)

$137,000 + $310,490

$447,490

2016

$13,957 (+3.1%)

$137,000 + $310,490

$447,490

2014

$13,537 (−3.6%)

$137,000 + $310,490

$447,490

2011

$14,045

$152,990 + $355,890

$508,880

Tax history for 5 Sterling Ridge Ct

Year

Property tax

Land + Additions

Assessment*

2023

$15,659 (+2.2%)

$136,400 + $309,840

$446,240

2022

$15,315 (+1.8%)

$136,400 + $309,840

$446,240

2021

$15,047 (+1.5%)

$136,400 + $309,840

$446,240

2020

$14,824

$136,400 + $309,840

$446,240

2019

$14,824 (+1.6%)

$136,400 + $309,840

$446,240

2018

$14,597 (+2.1%)

$137,000 + $310,490

$447,490

2017

$14,293 (+2.4%)

$137,000 + $310,490

$447,490

2016

$13,957 (+3.1%)

$137,000 + $310,490

$447,490

2014

$13,537 (−3.6%)

$137,000 + $310,490

$447,490

2011

$14,045

$152,990 + $355,890

$508,880

*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

0.99 Acres

Year renovated

—

Sq. Ft.

3,122

Year built

2006

Style

Single Family Residential

County

New Haven County

APN

2516664

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: 13
Laundry Room Location: First Floor
Interior Features: Auto Garage Door Opener, Fire Suppression System, Security System
In-Law Apartment: No
Fireplaces Total: 1
Cooling System: Ceiling Fans, Central Air
Appliances Included: Dishwasher, Disposal, Gas Cooktop, Microwave, Refrigerator, Range Hood, Wall Oven, Wine Chiller

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

Bedroom Information
Beds Total: 5

Room Information
Rooms Additional: Bonus Room
Room Count: 13
Basement Description: Full With Walk-Out, Partially Finished, Heated
Has Attic
Attic Description: Pull-Down Stairs

Exterior

Exterior Features
Exterior Siding: Vinyl Siding, Brick
Exterior Features: Deck, Hot Tub, Lighting, Patio, Shed, Sidewalk, Stone Wall, Underground Sprinkler, Underground Utilities

Lot Information
Lot Description: On Cul-De-Sac, Fence - Partial, Fence - Rail, Fence - Stone

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

Building Information
Color: Beige

Property Information
Radon Mitigation Air
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 3122
Driveway Type: Cement

Financial

Assessments Information
Assessed Value: $447,490

Rental Information
Lease Purchase YN: No

Utilities

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

Location

HOA Information
Association Amenities: Park, Playground/Tot Lot, Tennis Courts

School Information
Intermediate School: Dodd
High School: Cheshire
Elementary School: Chapman

Location Information
Subdivision: Sterling Ridge
State: Connecticut
Nearby Amenities: Library, Park, Playground/Tot Lot, Private School(s), Public Pool, Tennis Courts, Public Trash Pickup
Directions: Rt 68/70 South Meriden Rd to Cheshire Street to Sterling Ridge Ct.
County: New Haven

Public facts

Beds: 5
Baths: 3.5
Sq. Ft.: 3,122
Stories: 2.0
Lot Size: 0.99 acres
Style: Single Family Residential
Year Built: 2006
Year Renovated: —
County: New Haven County
APN: 2516664

Home facts updated by county records on Jul 12, 2023

Other

Documents & Disclosures
Supplement Count Public: 2

Around this home

Schools

Chapman School

Public K-6 • Assigned • 2.4mi

8/10

Dodd Middle School

Public 7-8 • Assigned • 3.2mi

8/10

Cheshire High School

Public 9-12 • Assigned • 4.4mi

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.12M – $1.35M

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

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

Nearby similar homes

NEW 17 HRS AGO

$239,900

2 beds1.5 baths1,196 sq ft

661 Allen Ave, Meriden, CT 06451

$649,000

5 beds3.5 baths4,044 sq ft

30 Rolling Hills Dr, Meriden, CT 06451

$295,000

3 beds1 bath1,674 sq ft

34 Sylvan Ave, Meriden, CT 06451

$1,049,000

5 beds4 baths3,963 sq ft

143 Rochela Dr, Southington, CT 06489

$639,000

3 beds2.5 baths2,226 sq ft

139 S End Rd, Southington, CT 06489

FOR SALE BY OWNER

$425,000

3 beds2.5 baths1,284 sq ft

54 Tanya Ct, Plantsville, CT 06479

New listings for sale in 06410

EARLY ACCESSCOMPASS COMING SOON

$500,000

4 beds2 baths2,250 sq ft

171 Cornwall Ave, Cheshire, CT 06410

OPEN TODAY, 4:30PM TO 6PM

$1,050,000

4 beds3.5 baths4,515 sq ft

20 Baxter Ct, Cheshire, CT 06410

COMING SOON

$425,000

2 beds2.5 baths1,700 sq ft

72 Quarry Village Rd #72, Cheshire, CT 06410

COMING SOON

$839,900

4 beds2.5 baths3,309 sq ft

256 Beacon Hill Dr, Cheshire, CT 06410

$499,999

3 beds2.5 baths1,642 sq ft

268 Eastgate Dr, 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

OPEN SAT, 11:30AM TO 2PM

$538,000

2 beds2 baths1,960 sq ft

3 Racebrook Ct, Cheshire, CT 06410

OPEN SUN, 12PM TO 2PM

$415,000

2 beds1 bath974 sq ft

1016 Sperry Rd, Cheshire, CT 06410

Home values near 5 Sterling Ridge Ct

Data from public records.

Address	Redfin Estimate
30 Sterling Ridge Court, Cheshire, CT 5 Beds \| 5 Baths \| 3800 Sq. Ft.	$1,070,128
25 Sterling Ridge Court, Cheshire, CT 5 Beds \| 4 Baths \| 4268 Sq. Ft.	$1,164,827

Address	Redfin Estimate
45 Sterling Ridge Court, Cheshire, CT 4 Beds \| 3.5 Baths \| 3079 Sq. Ft.	$1,109,508
15 Sterling Ridge Court, Cheshire, CT 4 Beds \| 5 Baths \| 3361 Sq. Ft.	$1,058,856

Address	Redfin Estimate
35 Sterling Ridge Court, Cheshire, CT 4 Beds \| 3.5 Baths \| 3063 Sq. Ft.	$1,032,063
10 Sterling Ridge Court, Cheshire, CT 4 Beds \| 3.5 Baths \| 3100 Sq. Ft.	$1,041,613

Property information provided by Smart MLS when last listed in 2017. 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	Westport, 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	Norwalk, 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 06410, CT

Sale history for 5 Sterling Ridge Ct

Tax history for 5 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 5 Sterling Ridge Ct

More real estate resources