NOT LISTED FOR SALE

242 Waterhole Rd Colchester, CT 06415

Estimated Value: $729,000 - $771,000

3 Beds
2.5 Baths
3,317 Sq Ft
$225/Sq Ft Est. Value

Last Sold March 29, 2023

Last sale price $620,000 $187 Per Sq Ft

Est. 20% increase in value since last sale

Current estimated payment $5,131/month

66 Days on Market

Highlights

  • Open Floorplan
  • Ranch Style House
  • 1 Fireplace
  • William J. Johnston Middle School Rated A-
  • Partially Wooded Lot
  • No HOA

About This Home

As of March 2023

Custom built expansive Ranch style home. Large living area with floor to ceiling stone fireplace, stones where taken right from property to build this fireplace (3) flues. Cathedral ceilings, wood flooring with inlay. Formal dining room with crown molding. Large kitchen features a bow window for seating area, maple cabinetry, island with cooktop and breakfast bar, double oven, wine cooler, granite countertops and large pantry. First floor laundry and half bath. Primary bedroom with full walk in closet, huge full bath with jetted tub, double sinks and oversized shower. Heated 3 car heated garage with finished bonus room above that has been plumbed for an additional bath. Huge basement that has 9ft ceiling and metal beams should you want to finish at some point, also plumbed for bath. 2 - 330 oil tanks, 5 zone heating, 80 gallon heat water heater, 3 central air units. Lots of natural light throughout with large windows and fantastic attention to detail. Beautifully landscaped yard with open wrapped front porch, stone walls, covered back porch with large patio. Located on country road, convenient to route 2 and route 9, lots of walking trails in the area.

Last Agent to Sell the Property

Dana Flanagan

William Pitt Sotheby's Int'l License #RES.0766217 Listed on: 01/21/2023

William Pitt Sotheby's Int'l

Last Buyer's Agent

Erik Sousa

William Raveis Real Estate License #REB.0790391

William Raveis Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,736

Year Built

  • Built in 2004

Lot Details

  • 1.39 Acre Lot
  • Stone Wall
  • Level Lot
  • Partially Wooded Lot
  • Property is zoned r2

Home Design

  • Ranch Style House
  • Concrete Foundation
  • Frame Construction
  • Asphalt Shingled Roof
  • Wood Siding

Interior Spaces

  • 3,317 Sq Ft Home
  • Open Floorplan
  • Central Vacuum
  • Ceiling Fan
  • 1 Fireplace
  • Thermal Windows
  • Unfinished Basement
  • Basement Fills Entire Space Under The House
  • Home Security System

Kitchen

  • Built-In Oven
  • Cooktop
  • Dishwasher
  • Wine Cooler

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Laundry on main level
  • Washer

Parking

  • 3 Car Attached Garage
  • Automatic Garage Door Opener
  • Gravel Driveway
  • Shared Driveway

Outdoor Features

  • Patio
  • Porch

Schools

  • Bacon Academy High School

Utilities

  • Central Air
  • Heating System Uses Oil
  • Underground Utilities
  • Private Company Owned Well
  • Oil Water Heater
  • Fuel Tank Located in Basement
  • Cable TV Available

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,736

Year Built

Built in 2004

Lot Details

0

Listing Details

  • Property Type: Single Family For Sale
  • Style: Ranch
  • Sq Ft Est Heated Above Grade: 3317
  • Public Record Living Room Sq Ft: 3317
  • Total Sq Ft: 3317
  • Year Built: 2004
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Public Record Gross Sq Ft: 9293
  • Directions: East Hampton line on Waterhole Rd.
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 7
  • Total Bedrooms: 3
  • Total Bathrooms: 3.00
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Fireplaces: 1
  • Basement Description: Full, Unfinished
  • Interior Amenities: Auto Garage Door Opener, Cable - Available, Central Vacuum, Open Floor Plan, Security System
  • Appliances: Cook Top, Wall Oven, Refrigerator, Dishwasher, Washer, Wine Chiller
  • Laundry Room Info: Main Level
  • Attic: No
  • Street Number Modifier: 242

Exterior Features

  • Exterior Features: Patio, Porch, Stone Wall, Underground Utilities
  • Exterior Siding: Wood
  • Foundation Type: Concrete
  • Roof Information: Asphalt Shingle
  • Swimming Pool: No
  • Construction Description: Frame

Garage/Parking

  • Garage Parking Info: Attached Garage
  • Garages Number: 3
  • Driveway Type: Shared, Gravel

Utilities

  • Cooling System: Ceiling Fans, Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Oil
  • Fuel Tank Location: In Basement
  • Hot Water Description: Oil
  • Water Source: Private Well
  • Sewer: Septic

Condo/Co-op/Association

  • HOA: No
  • Special Association Assessment Y: No

Schools

  • Elementary School: Per Board of Ed
  • High School: Bacon Academy

Green Features

  • Energy Features: Thermopane Windows

Lot Info

  • Acres: 1.3900
  • Lot Description: Level Lot, Lightly Wooded
  • Zoning: r2

Tax Info

  • Tax Year: July 2022-June 2023
  • Property Tax: 11736
  • Total Assessed Value: 433400
  • Mil Rate Base: 27.080
  • Mil Rate Total: 27.080
  • Assessor Parcel Number: 2468894

MLS Schools

  • Elementary School: Per Board of Ed
  • High School: Bacon Academy

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 21, 2023
Closed on
Mar 27, 2023
Sold by
Trendowski Jan C
Bought by
Macauley James A and Macauley Ellen A
Seller's Agent
Dana Flanagan
William Pitt Sotheby's Int'l
Buyer's Agent
Erik Sousa
William Raveis Real Estate
List Price
$624,000
Sold Price
$620,000
Premium/Discount to List
-$4,000
-0.64%
Views
152
Current Estimated Value
$744,717

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$124,717
Avg. Annual Appreciation
6.61%
Original Mortgage
$496,000
Outstanding Balance
$481,516
Interest Rate
6.12%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$242,836

Purchase Details

Listed on
Apr 15, 2022
Closed on
Oct 4, 2022
Sold by
Ripley Kenneth A
Bought by
Trendowski Jan C
Seller's Agent
Ginger Pensa
William Raveis Real Estate
Buyer's Agent
Lisa Genovali
Re/Max Valley Shore
List Price
$649,900
Sold Price
$595,000
Premium/Discount to List
-$54,900
-8.45%
Views
22

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.95%
Original Mortgage
$476,000
Interest Rate
5.28%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Macauley James A $620,000 None Available
Trendowski Jan C $595,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Macauley James A $496,000
Previous Owner Trendowski Jan C $476,000
Previous Owner Ripley Kenneth $100,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/29/2023 03/29/23 Sold $620,000 +3.5% $187 / Sq Ft
03/28/2023 03/28/23 Pending -- -- --
02/02/2023 02/02/23 Price Changed $599,000 -4.0% $181 / Sq Ft
01/21/2023 01/21/23 For Sale $624,000 +4.9% $188 / Sq Ft
10/04/2022 10/04/22 Sold $595,000 0.0% $179 / Sq Ft
08/21/2022 08/21/22 Pending -- -- --
07/15/2022 07/15/22 Price Changed $595,000 -4.8% $179 / Sq Ft
05/21/2022 05/21/22 Price Changed $624,900 -3.8% $188 / Sq Ft
04/15/2022 04/15/22 For Sale $649,900 -- $196 / Sq Ft
Source: SmartMLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $12,967 $433,400 $41,900 $391,500
2024 $12,426 $433,400 $41,900 $391,500
2023 $11,797 $433,400 $41,900 $391,500
2022 $11,736 $433,400 $41,900 $391,500
2021 $10,161 $309,400 $44,100 $265,300
2020 $10,161 $309,400 $44,100 $265,300
2019 $10,161 $309,400 $44,100 $265,300
2018 $9,987 $309,400 $44,100 $265,300
2017 $10,015 $309,400 $44,100 $265,300
2016 $10,002 $323,600 $56,800 $266,800
2015 $9,954 $323,600 $56,800 $266,800
2014 $9,892 $323,600 $56,800 $266,800
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170545405

SmartMLS

APN: COLC-000002-000020-000003-000018