Data Investigations · New Haven, CT

What the public record shows when you look.

Long-form investigations grounded in the Elm City Explorer dataset. Every piece is data first, citation second, opinion last. New findings are added as the data reveals them.

Findings №4 · June 2026 · New

The second boom has new names.

2025 buying came within four percent of the all-time peak — but Mandy's share collapsed from 35% to 10%, and 60% of the wave traces to LLCs formed since 2024. Plus: an SFR fund's 36-house exit, and the busiest flipping market on record.
~7 min readRead →
Findings №1 · April 2026 · Updated June 2026

One name behind 841 doors.

How Mandy Management became New Haven's largest residential landlord through a network of 113 shell LLCs — and what 236 acquisitions in a single year says about single-family rental consolidation.
~7 min readRead →
Findings №2 · April 2026

The LLPs Connecticut can't see.

A small but persistent slice of New Haven's corporate housing is held by Limited Liability Partnerships filed in other states — entities the CT Secretary of State's own business-entity search overlooks. What the gap looks like, and what could close it.
~6 min readRead →
Findings №3 · April 2026

The four-year buying boom.

From 2019 through 2022, corporate landlords closed on 2,236 New Haven properties — more than the prior five years combined. A look at the groups that built or doubled their entire portfolios in that window, and why 2025 looks like a sequel.
~7 min readRead →