Off market aug 2025 for $811K

$816,961

Est. refi paymentEst. refi $3,013/mo

•

3,645

sq ft

246 Waterhole Rd, Colchester, CT 06415

About this home

This amazingly detailed 3650 sq ft Ranch on 1.4 acres welcomes you upon entrance into its tiled grand foyer, leading into the Great Room. You will notice floor to ceiling stone fireplace, custom built-ins and Brazilian cherry floors. Follow along to the home's gourmet kitchen with maple cabinets, granite counters, stainless steel appliances and a breakfast nook for casual dining. The primary suite offers a luxurious master bathroom with double sinks, granite counters, whirlpool tub and separate shower. Right off the primary bedroom is a vaulted solarium with a temperature controlled therapy/lap pool that is beautifully appointed with custom tile and remote controlled skylights. There is also a bonus room over the garage with a full bathroom, which is currently being used as the 4th bedroom. The 1185 sq ft 3 car garage is fully insulated with radiant heat flooring and plenty of space for additional storage and/or a workshop. This home has steel beam construction, is energy efficient, digitally controlled and includes a 1700 kw generator that will help you weather any storm. Outdoors there is also an 800 sq ft wrap around porch and a stamped concrete patio with built in fire pit, for your relaxation and enjoyment. The outdoors also boasts a professionally manicured lawn, beautiful stone wall and a shed for additional storage.

If you are looking for a home with elegance, comfort and one floor living, this should be at the top of your list!

Single-familyProperty Type

2005Year Built

1.4 acresLot Size

$224Est. Price/Sq.Ft.

3 garage spacesParking

Buyer's agent

Stephanie Liriano Redfin Corporation

Listed by Bill Mooney • William Raveis Real Estate

Listed by Beth Mishler • William Raveis Real Estate

Source:Smart MLS #24112413

Redfin Estimate

$816,961

$5,961 since sold in August 2025$37K since September

Recently sold homes
Estimate history
Homes for sale

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

SOLD APR 20, 2026
$600,000
A
3 beds2.5 baths2,721 sq ft
190 Waterhole Rd, Colchester, CT 06415
SOLD JUL 22, 2026
$575,000
B
3 beds2.5 baths2,144 sq ft
97 Collie Brook Rd, East Hampton, CT 06424
SOLD SEP 22, 2026
$590,000
C
3 beds2.5 baths2,407 sq ft
99 Fox Ridge Dr, Colchester, CT 06415
SOLD SEP 22, 2026
$765,000
D
3 beds2.5 baths2,304 sq ft
151 Alger Rd, East Haddam, CT 06423
SOLD MAY 15, 2026
$749,000
E
3 beds2.5 baths2,386 sq ft
14 Farm Gate Rd, Colchester, CT 06415
SOLD JUL 24, 2026
$445,000
F
3 beds2.5 baths1,862 sq ft
3 Old Acres Rd, Moodus, CT 06469

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

Earn from this home

Sell

$131,983

Est. take-home

List your home with Redfin and save $8,170

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$2,875/mo

Redfin rental estimate

List your home for rent

Market trends in 06415, CT

Last updated September 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

103.9%

0.8% MoM

Median sale price

$461K

$49K MoM

Avg. days on market

30d

3 days MoM

Recently sold homes

2 MoM

New listings for sale

OPEN SAT, 11AM TO 1PM
$719,900
3 beds3 baths2,948 sq ft
9 Oak Farm Dr, Colchester, CT 06415
$125,000
2 beds1.5 baths960 sq ft
17 Cardinal Rd, Colchester, CT 06415
3D WALKTHROUGH
$339,900
2 beds2 baths872 sq ft
46 Briarcliffe Rd, East Haddam, CT 06415
$334,900
2 beds1 bath960 sq ft
235 Westchester Rd, Colchester, CT 06415
See all

Provided by Redfin

Sale history for 246 Waterhole Rd

Date

Event

Price

Smart MLS #24112413

Aug 20, 2025

Sold

$811,000

$222/sq ft

Aug 6, 2025

Pending

—

Jul 26, 2025

Listed

$725,000

$199/sq ft

Jul 21, 2025

Coming Soon

$725,000

$199/sq ft

Smart MLS #170036113

Jun 18, 2018

Sold

$460,000

$126/sq ft

Jun 13, 2018

Listing Removed

—

Mar 5, 2018

Price Changed

$499,900

$137/sq ft

Feb 12, 2018

Relisted

—

Feb 7, 2018

Contingent

—

Dec 5, 2017

Listed

$509,000

$140/sq ft

Stunning 3650 sq ft brick Colonial w/ beautiful Brazilian cherry floors, imported granite, marble, travertine tile & stately 9 ft ceilings! A grand foyer welcomes your entrance into the home, which leads to a large Great Room w/ a gorgeous stone fireplace that extends from floor to ceiling surrounded by custom built ins. This is followed by a gourmet kitchen perfect for entertaining w/ plenty of maple cabinets for storage, granite counters, ss appliances, & a wonderful breakfast bar for casual dining! Vaulted ceilings add splendor & grandeur in the master bedroom along with the luxurious master ba w/ double sinks, granite counters, whirlpool tub & a separate shower. Off the master is a vaulted solarium w/ a temperature controlled therapy/lap pool that is beautifully appointed w/ custom tile & skylights that are remotely controlled! The second story offers a bonus room & a half bath for guests/home office and/or library, you decide! There is also a fabulous 800 sq ft wrap around porch for your relaxation & enjoyment that overlook the professionally manicured lawn & beautiful stone walls! In addition, there is an 1185 sq ft garage, fully insulated w/ radiant heat flooring; w/ plenty of space for 4 cars, a workshop and/or storage! This home has steel beam construction, is energy efficient, digitally controlled & includes a 1700kw generator that will help you weather any storm! If you are looking for a home w/ elegance along w/ comfort & convenience this home is sure to please!

Smart MLS #N10132155

May 5, 2017

Listing Removed

—

May 5, 2016

Listed

$539,900

$148/sq ft

Year

Property tax

Land + Additions

Assessment*

2022

$11,550 (−0.7%)

$41,900 + $384,600

$426,500

2021

$11,635

$44,100 + $310,200

$354,300

2020

$11,635

$44,100 + $310,200

$354,300

2019

$11,635 (+1.7%)

$44,100 + $310,200

$354,300

2018

$11,437 (−0.3%)

$44,100 + $310,200

$354,300

2017

$11,469 (+11.8%)

$44,100 + $310,200

$354,300

2016

$10,256 (+1.1%)

$56,800 + $275,000

$331,800

2014

$10,143 (+1.0%)

$56,800 + $275,000

$331,800

2011

$10,047

$56,800 + $275,000

$331,800

Tax history for 246 Waterhole Rd

Year

Property tax

Land + Additions

Assessment*

2022

$11,550 (−0.7%)

$41,900 + $384,600

$426,500

2021

$11,635

$44,100 + $310,200

$354,300

2020

$11,635

$44,100 + $310,200

$354,300

2019

$11,635 (+1.7%)

$44,100 + $310,200

$354,300

2018

$11,437 (−0.3%)

$44,100 + $310,200

$354,300

2017

$11,469 (+11.8%)

$44,100 + $310,200

$354,300

2016

$10,256 (+1.1%)

$56,800 + $275,000

$331,800

2014

$10,143 (+1.0%)

$56,800 + $275,000

$331,800

2011

$10,047

$56,800 + $275,000

$331,800

*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

Stories

Lot width

—

Lot depth

—

Lot size

1.4 Acres

Year renovated

—

Sq. Ft.

3,645

Year built

2005

Style

Single Family Residential

County

New London County

APN

2468895

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 14, 2023.

Property details

Parking

Garage Information
Garage & Parking: Attached Garage, Paved, Off Street Parking, Driveway
Garages Number: 3

Parking Information
Parking Total Spaces: 6

Interior

Interior Information
Total Rooms: 5
Laundry Room Location: Primary Bathroom
Laundry Room Info: Main Level
Interior Features: Auto Garage Door Opener, Cable - Pre-wired, Central Vacuum, Security System
In-Law Apartment: No
Handicap Features: Accessible Bath, Roll-In Shower
Fireplaces Total: 1
Cooling System: Central Air
Appliances Included: Electric Cooktop, Wall Oven, Microwave, Refrigerator, Icemaker, Dishwasher, Washer, Dryer

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

Bedroom Information
Beds Total: 3

Room Information
Rooms Additional: Bonus Room
Basement Description: Full, Unfinished, Garage Access, Concrete Floor
Has Attic

Exterior

Exterior Features
Roof Information: Asphalt Shingle
Exterior Siding: Vinyl Siding, Other
Exterior Features: Porch-Wrap Around, Shed, Porch, Gutters, Lighting, Stone Wall, Patio

Lot Information
Lot Description: Dry, Level Lot, Cleared, Professionally Landscaped

Land Information
Encumbrances Restrictions: Right of Way

Pool Information
Swimming Pool
Pool Description: Heated, Indoor Pool

Building Information
Foundation Type: Concrete
Construction Description: Frame
Color: Tan

Property Information
Radon Mitigation Air
Property Type: Single Family For Sale
Living Area SQFT Per Public Record: 3645
Driveway Type: Private, Circular, Paved

Financial

Assessments Information
Assessed Value: $426,500

Utilities

Utility Information
Water Source: Private Well
Sewage System: Septic
Hot Water Description: Electric, Domestic
Heat Type: Hot Water
Heat Fuel Type: Oil
Fuel Tank Location: In Basement
Energy Features: Generator, Programmable Thermostat, Ridge Vents, Thermopane Windows

Location

School Information
High School: Per Board of Ed
Elementary School: Per Board of Ed

Location Information
State: Connecticut
Directions: USE GPS
County: New London

Public facts

Beds: 2
Baths: 3.0
Sq. Ft.: 3,645
Stories: 1.0
Lot Size: 1.4 acres
Style: Single Family Residential
Year Built: 2005
Year Renovated: —
County: New London County
APN: 2468895

Home facts updated by county records on Jul 14, 2023

Other

Documents & Disclosures
Supplement Count Public: 2

Around this home

Schools

Jack Jackter Intermediate School

Public 3-5 • Assigned • 6.5mi

7/10

William J. Johnston Middle School

Public 6-9 • Assigned • 6.6mi

7/10

Bacon Academy

Public 9-12 • Assigned • 7.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

4/10 Heat Factor

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

6/10 Wind Factor

48% chance of strong winds in next 30 years

3/10 Air Factor

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

Provided by First Street

Historical weather

Colchester, CT • 06415

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 9 hours in June and 4.5 hours in December, placing it below the U.S. average for solar exposure.

9 hrs

4.5 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$777,000 – $940,000

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

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

Nearby similar homes

$1,000,000

3 beds1.5 baths2,131 sq ft

155 Bear Swamp Rd, East Hampton, CT 06424

$354,900

3 beds2 baths1,242 sq ft

6 E Hayes Rd, East Hampton, CT 06424

$125,000

2 beds1.5 baths960 sq ft

17 Cardinal Rd, Colchester, CT 06415

$169,000

2 beds1 bath1,160 sq ft

19 Phoenix Rd, Colchester, CT 06415

NEW CONSTRUCTION

$869,900

4 beds3.5 baths2,800 sq ft

Lot 8 Taylor Rd, Colchester, CT 06415

$1,550,000

4 beds4 baths4,070 sq ft

77 Main St, East Haddam, CT 06423

New listings for sale in 06415

OPEN SAT, 11AM TO 1PM3D WALKTHROUGH

$719,900

3 beds3 baths2,948 sq ft

9 Oak Farm Dr, Colchester, CT 06415

$125,000

2 beds1.5 baths960 sq ft

17 Cardinal Rd, Colchester, CT 06415

3D WALKTHROUGH

$339,900

2 beds2 baths872 sq ft

46 Briarcliffe Rd, East Haddam, CT 06415

$334,900

2 beds1 bath960 sq ft

235 Westchester Rd, Colchester, CT 06415

Home values near 246 Waterhole Rd

Data from public records.

Address	Redfin Estimate
222 Waterhole Rd, Colchester, CT 3 Beds \| 2.5 Baths \| 2387 Sq. Ft.	$616,745
242 Waterhole Rd, Colchester, CT 3 Beds \| 2.5 Baths \| 3317 Sq. Ft.	$752,250

Address	Redfin Estimate
226 Waterhole Rd, Colchester, CT 3 Beds \| 2.5 Baths \| 2135 Sq. Ft.	$618,476
258 Waterhole Rd, Colchester, CT 4 Beds \| 2.5 Baths \| 2415 Sq. Ft.	$609,389

Address	Redfin Estimate
206 Waterhole Rd, Colchester, CT 4 Beds \| 3.5 Baths \| 3104 Sq. Ft.	$547,190
250 Waterhole Rd, Colchester, CT 4 Beds \| 2.5 Baths \| 2570 Sq. Ft.	$647,047

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.

South Windsor homes for sale
Old Saybrook homes for sale
Glastonbury homes for sale
Windsor homes for sale
Madison homes for sale

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

Manchester homes for sale
Groton homes for sale
Middletown homes for sale

06415 homes for sale
06249 homes for sale
06231 homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 06415, CT

Sale history for 246 Waterhole Rd

Tax history for 246 Waterhole Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 06415

Home values near 246 Waterhole Rd

More real estate resources