Sponsored by Homebase
Homebase powers $300M+ in real estate syndications. Streamline your fundraising, investor management, and distributions today.
”Homebase helped me raise $3M in 2024 and already $2M in 2025—plus saved me 100+ hours setting up my deals. It’s become the true ‘home base’ for my capital raising and investor experience.” - Jarek Chu, Haven Residential
Build a distress intelligence dataset by cross-referencing two public data sources: NYC property ownership records (PLUTO) and New York State UCC lien filings (Department of State). The goal is to identify multifamily property owners who have pledged new collateral, amended existing liens, or had liens terminated in the last 12 months — all signals of refinancing activity, lender stress, or financial distress.
When an LLC that owns a 200-unit apartment building files a new UCC lien, it means they just pledged collateral to a lender. That's either a new loan (refinancing) or an additional pledge against existing collateral (stress). When a lien gets terminated, the lender may have been paid off — or may have foreclosed. When a lien gets amended, terms are changing, often because the borrower is in trouble.
The final output should be a clean, sortable spreadsheet that a real estate GP could use to identify distressed acquisition targets and a dashboard to visualize the results.
Filtering for multifamily owners with 10+ units: