$2,875,000
$225K PRICE DROP

24 Indigo Trail Madison, CT 06443

Estimated payment $17,228/month

Total Views 307,928
4 Beds
4.5 Baths
6,194 Sq Ft
$464 Price per Sq Ft

Highlights

  • Waterfront
  • 5.65 Acre Lot
  • ENERGY STAR Certified Homes
  • Walter C. Polson Upper Middle School Rated A
  • Colonial Architecture
  • Attic

About This Home

Come see this stately custom Brick English Georgian home in sought after Madison CT, nestled on a sprawling 5.65 acre lot with Neck River frontage. This exquisite 6,194 square foot Brick English Georgian offers an unparalleled blend of luxury, privacy and natural beauty. With 4 bedrooms and 4.5 baths, it is designed for those who appreciate both elegance and tranquility. This unique residence is surrounded by lush woodlands and features a picturesque river that winds through the property, creating a serene and peaceful retreat. An expansive entry foyer with classic marble flooring and a stunning circular stairway and coffered ceiling is a showstopper. The chef's kitchen is an entertainer's dream with custom cabinetry and butler's pantry. The elegant living room features gorgeous molding and a grand fireplace. Overlooking a private courtyard is the library showcasing exceptional quality and attention to detail with magnificent custom cabinetry. Throughout the interior, this home boasts spacious living areas, high-end finishes, and classic architectural details that reflect timeless charm. Whether you are entertaining or simply enjoying the beauty of your surroundings, this property offers a rare opportunity to experience refined living in a completely private setting. A true sanctuary, this home provides the perfect balance of sophistication and seclusion, while being conveniently located near Madison's charming Town Center, expansive beaches, and top-rated schools.

Listing Agent

Ron Stewart

Houlihan Lawrence WD License #RES.0815415 Listed on: 04/07/2025

Houlihan Lawrence WD

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $24,554

Year Built

  • Built in 2003

Lot Details

  • 5.65 Acre Lot
  • Waterfront
  • Stone Wall
  • Garden
  • Property is zoned RU-1

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Asphalt Shingled Roof
  • Masonry Siding
  • Radon Mitigation System
  • Masonry

Interior Spaces

  • 6,194 Sq Ft Home
  • Central Vacuum
  • Built In Speakers
  • Sound System
  • 2 Fireplaces
  • Thermal Windows
  • French Doors
  • Workshop
  • Home Gym
  • Gas Cooktop
  • Storm Doors

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry Room
  • Laundry on upper level

Attic

  • Storage In Attic
  • Walkup Attic
  • Partially Finished Attic

Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Basement Storage

Parking

  • 4 Car Garage
  • Automatic Garage Door Opener
  • Circular Driveway

Outdoor Features

  • Balcony
  • Patio
  • Porch

Schools

  • Daniel Hand High School

Utilities

  • Central Air
  • Heating System Uses Oil
  • Heating System Uses Propane
  • Power Generator
  • 60 Gallon+ Oil Water Heater
  • 60 Gallon+ Propane Water Heater
  • Private Company Owned Well
  • Fuel Tank Located in Basement
  • Cable TV Available

Additional Features

  • ENERGY STAR Certified Homes
  • Property is near a golf course

Community Details

  • Indigo Woods Subdivision

Listing and Financial Details

  • Exclusions: Chandelier in entryway, see inclusive/exclusive
  • Assessor Parcel Number 1157887

Home Details

Home Type

Single Family

Est. Annual Taxes

$24,554

Year Built

Built in 2003

Lot Details

0

Listing Details

  • Neighborhood: N/A
  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 6194
  • Total Sq Ft: 6194
  • Year Built: 2003
  • New Construction: No/Resale
  • Nearby Amenities: Basketball Court, Golf Course, Health Club
  • In Law Access: First Floor
  • Remarks Public Addendum: Make sure to watch the attached You Tube video for an informative tour of the home by the builder/ owner and ask us about the possiblity of subdividing. It's also possible to make a Primary Bedroom suite or 5th bedroom for a in-law space on the first floor.
  • Exclusions: Chandelier in entryway, see inclusive/exclusive
  • Direct Waterfront: Yes
  • Home Warranty Offered: No
  • Radon Mitigation Air Ynu: Yes
  • Radon Mitigation Water Ynu: Unknown
  • Directions: GPS
  • In Law Apartment: Possible
  • Living Area Sq Ft Per Public Record: 6194
  • Street Type: Trail
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Total Bedrooms: 4
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Fireplaces: 2
  • Attic Description: Storage Space, Partially Finished, Walk-up
  • Basement Description: Full, Storage, Full With Walk-Out
  • Interior Amenities: Audio System, Auto Garage Door Opener, Cable - Pre-wired, Central Vacuum
  • Appliances: Gas Cooktop
  • Additional Rooms: Breezeway, Exercise Room, Laundry Room, Workshop
  • Laundry Room Info: Upper Level
  • Attic: Yes
  • Home Automation: Built In Audio
  • Street Number Modifier: 24

Exterior Features

  • Exterior Features: Balcony, Porch, Garden Area, Stone Wall, French Doors, Patio
  • Exterior Siding: Brick
  • Foundation Type: Masonry
  • Roof Information: Asphalt Shingle
  • Waterfront Description: River Access
  • Swimming Pool: No
  • Construction Description: Brick

Garage/Parking

  • Garages Number: 4
  • Driveway Type: Circular, Unpaved, Asphalt, Crushed Stone
  • Total Parking Spaces: 4
  • Garage And Parking: Attached Garage, Driveway

Utilities

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

Schools

  • Elementary School: Per Board of Ed
  • High School: Daniel Hand

Green Features

  • Energy Features: Energy Star Rated, Generator, Storm Doors, Thermopane Windows

Lot Info

  • Acres: 5.65
  • Lot Description: Level Lot On Cul-De-Sac Rolling
  • Flood Zone: No
  • Zoning: RU-1
  • Parcel #: 1157887

Tax Info

  • Tax Year: July 2025-June 2026
  • Property Tax: 24554
  • Total Assessed Value: 1094700
  • Mil Rate Total: 22.43

MLS Schools

  • Elementary School: Per Board of Ed
  • High School: Daniel Hand

Map

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

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 $24,554 $1,094,700 $235,300 $859,400
2024 $24,083 $1,094,700 $235,300 $859,400
2023 $22,654 $755,900 $194,600 $561,300
2022 $22,231 $755,900 $194,600 $561,300
2021 $21,808 $755,900 $194,600 $561,300
2020 $21,430 $755,900 $194,600 $561,300
2019 $21,430 $755,900 $194,600 $561,300
2018 $19,777 $705,300 $142,700 $562,600
2017 $19,255 $705,300 $142,700 $562,600
2016 $18,683 $705,300 $142,700 $562,600
2015 $18,169 $705,300 $142,700 $562,600
2014 $28,815 $1,144,800 $247,400 $897,400
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/29/2025 05/29/25 Price Changed $2,875,000 -7.3% $464 / Sq Ft
04/07/2025 04/07/25 For Sale $3,100,000 -- $500 / Sq Ft
Source: SmartMLS

Purchase History

Date Type Sale Price Title Company
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Quit Claim Deed -- --
Quit Claim Deed -- --
Warranty Deed $225,000 --
Warranty Deed $225,000 --
Warranty Deed $165,000 --
Warranty Deed $375,485 --
Quit Claim Deed -- --
Quit Claim Deed -- --
Warranty Deed $225,000 --
Warranty Deed $165,000 --
Warranty Deed $375,485 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $797,000 Stand Alone Refi Refinance Of Original Loan
Closed $797,000 Stand Alone Refi Refinance Of Original Loan
Previous Owner $80,000 No Value Available
Previous Owner $970,000 Stand Alone Refi Refinance Of Original Loan
Source: Public Records

About the Listing Agent

Ron Stewart

Houlihan Lawrence WD

(475) 405-2519

Section Image

When clients work with Ron Stewart, they are not just getting a realtor; they are gaining a trusted partner committed to helping them achieve their real estate goals. Ron has consistently proven himself as a trusted and reliable realtor who goes above and beyond for his clients. His extensive knowledge of the local real estate market and his ability to adapt to market trends have consistently enabled him to secure the best deals for his clients, whether they are buying or selling. Whether his

Ron's Other Listings

  • 113 Trolley Crossing Ln Unit 113, Middletown, CT 06457

    $149,000 Under Contract

    • 1 Bed
    • 1 Bath
    • 644 Sq Ft
    • 113 Trolley Crossing Ln
    • Unit 113
    • Middletown, CT

    Seller is calling for HIGHEST AND BEST BY 9/16 at 6:30pm Step out onto your private back porch and enjoy tranquil water views-the perfect setting for morning coffee or evening unwinding. This second-floor end unit features one bedroom, a full bathroom, a galley kitchen with ample cabinet space, a comfortable living room, and a dining area. Affordable HOA dues add even more appeal, covering heat,

    Ron Stewart Houlihan Lawrence WD

    Section Image
  • 225 Cosey Beach Ave, East Haven, CT 06512

    $569,000 Sold Feb 14, 2025

    • 4 Beds
    • 2.5 Baths
    • 2,096 Sq Ft
    • 225 Cosey Beach Ave
    • East Haven, CT

    Water views. This custom home has an open, bright floor plan, capitalizing on the views with a perfectly appointed kitchen, 4 bedrooms and 2 and a half baths. This property has modern, high end finishes and hardwood floors throughout. Enjoy the wonders of the sea as you walk down to a beautiful beach, perfect for kayaking, swimming and fishing. Simply drop anchor and enjoy. FEMA Compliant.

    Ron Stewart Houlihan Lawrence WD

  • 31 Grove St, Middletown, CT 06457

    $70,000 Sold Jan 02, 2025

    • Land
    • 8,276 Sq Ft Lot
    • 31 Grove St
    • Middletown, CT

    Welcome to Grove Street located between 89 and 99 Grove Street. You have the potential to build your dream home or multi -unit house for rental income! It is a hot area for rental houses. The land has been approved for residential and commercial use by the City of Middletown. Electricity, Natural Gas, City Water, City Sewer, Cable, and Trash Removal Service on the street. Property is close to

    Ron Stewart Houlihan Lawrence WD

Source: SmartMLS

MLS Number: 24083085

SmartMLS

APN: MADI-000070-000000-000001-000013