Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
Copied
Photo
Copied
Photo
Photo
Photo
Photo
See all photos

$2,875,000

For Sale - Active
24 Indigo Trl, Madison, CT 06443
4 Beds
5 Baths
6,194 Square Feet
0.00 Acres Lot
Built in 2003
For Sale - Active
Units n/a
Checked: 13 hours ago
Updated: Aug 08, 2025 at 03:05AM

Investment Summary


Monthly Cash Flow
-$12,546
Cap Rate
0.4%
Cash-on-Cash Return
-22.8%
Debt Coverage Ratio
0.08
Internal Rate of Return (5 years)
-18.0%

Property Description


0.00 Acres Lot
Built in 2003
For Sale - Active
Units n/a

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.

Build Your Team


Quickly find investor-friendly professionals who can help you succeed in real estate investing at any stage of the investing journey.

Avatar
Avatar
Avatar

Agents

Match with investor-friendly agents who can help you find, analyze, and close your next deal

Find an Agent
Avatar
Avatar
Avatar

Lenders

Get the best funding…find investor-friendly lenders who specialize in your deal strategy

Find a Lender
Avatar
Avatar
Avatar

Property Managers

Transition to passive investing. Find a trusted property management partnership that lasts.

Find a Property Manager
Avatar
Avatar
Avatar

Tax Pros & Accountants

Taxes and financial reporting made easy—find experts to create tax savings strategies, file taxes, and more

Find a Tax Pro

Location


Property Details


Parking

  • Details: Asphalt, Circular Driveway, Gravel, Paved, Garage Door Opener, Unpaved, Driveway, Attached
  • Garage Spaces: 4
  • Spaces Total: 4

Bedroom Information

  • # of Bedrooms: 4

Bathroom Information

  • # of Baths (Full): 4
  • # of Baths (Partial): 1
  • # of Baths (Total): 5.0

Interior Features

  • # of Rooms: 10
  • # of Stories: 2
  • Basement: Yes
  • Basement Description: Full, Walk-Out Access, Storage Space
  • Fireplace: Yes

Exterior Features

  • Exterior Walls Materials: Brick
  • Roof Type: Gable
  • Roof Material: Asphalt

Land Information

  • Land Use: Residential
  • Land Use Subtype: Single Family Residential

Lot Information

  • Parcel ID: MADIM:70B:113
  • Lot Size: 0 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Colonial
  • Year Built: 2003

Tax Information

  • Annual Tax: $24,554

Utilities

  • Water & Sewer: Well
  • Heating: Oil, Propane, Forced Air
  • Cooling: Central Air

Location

  • County: New Haven

Listing Details


Listed by:
Ron Stewart
Houlihan Lawrence WD
(203) 415-8174

Source:
SmartMLS
MLS#: 24083085
SmartMLS

Investment Summary


Monthly Cash Flow
-$12,546
Cap Rate
0.4%
Cash-on-Cash Return
-22.8%
Debt Coverage Ratio
0.08
Internal Rate of Return (5 years)
-18.0%

Purchase Details

Find an Agent

Purchase price:
$2,875,000
Amount financed:
-$2,300,000
Down payment:
$575,000
Closing costs:
$86,250
Rehab costs:
$0
Initial cash invested:
$661,250
Square feet:
6,194
Cost per square foot:
$464
Monthly rent per square foot:
$0.73

Financing Details

Find a Lender

Loan amount:
$2,300,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
5.875%
Principal & interest:
$13,605
Property tax:
$2,046
Insurance:
$315
Private mortgage insurance (PMI):
$0
Monthly payment:
$15,966

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$4,500 $54,000
Vacancy loss: (6%)
6% -$270 -$3,240
Operating income:
$4,230 $50,760

Operating Expenses


% Rent Monthly Yearly
Property taxes: (45%)
45%-$2,046-$24,554
Insurance: (7%)
7%-$315-$3,780
Property management: (8%)
8%-$360-$4,320
Repairs & maintenance: (5%)
5%-$225-$2,700
Capital expenditures: (5%)
5%-$225-$2,700
HOA fees: (n/a)
n/an/an/a
Total operating expenses: (70%)
70%-$3,171-$38,054

Cash Flow


Monthly Yearly
Net operating income:
$1,059 $12,708
Mortgage payments:
-$13,605 -$163,260
Cash flow:
$12,546 $150,552