Reading the ledger…
THE INDEX: 99 ▲6 · week of Nov 9 — permits soft, openings firm
Reading the ledger…
The raw feed behind the newsletter. Free tier: the trailing 90 days, 25 rows a page — enforced at the query, not just the pixels.
Reading the record?Get the week's biggest deals, permits, and the LLCs behind them — one free email every Thursday, every number checkable here.
Index Pro — full history, CSV exports, and morning-of alerts. $39/mo, coming soon. Get notified at launch:
New · The distress rolls
39,333 properties owe the city back taxes — 1,734 flagged for sheriff sale.
| Date | Address | Title | Kind | Status | Owner |
|---|---|---|---|---|---|
| Jul 1, 2026 | 1421 GILHAM ST | EXTERIOR AREA WEEDS | Violation | OPEN | NG JING W |
| Jul 1, 2026 | 1430 GILHAM ST | EXTERIOR AREA WEEDS | Violation | OPEN | RAMOS SANDRA I |
| Jul 1, 2026 | 4558 RICHMOND ST | EXTERIOR AREA WEEDS | Violation | OPEN |
Free tool
Want open violations and unsafe designations mapped weekly? Get the free Building Report →
| Jul 1, 2026 | 4558 RICHMOND ST | EXTERIOR AREA SANITATION | Violation | OPEN | FORTY-FIVE FIFTY RICHMOND |
| Jul 1, 2026 | 4001-03 KENSINGTON AVE | EXTERIOR AREA SANITATION | Violation | OPEN | SASI4001 LLC |
| Jul 1, 2026 | 4001-03 KENSINGTON AVE | VACANT STRUCTURE & LAND | Violation | OPEN | SASI4001 LLC |
| Jul 1, 2026 | 12 FARSON ST | INTERIOR DEMOLITION | Violation | OPEN | 12NF REALTY LLC |
| Jul 1, 2026 | 118 N PAXON ST | NEW USE | Violation | OPEN | ZCQ REAL ESTATE INVESTMENT LLC |
| Jul 1, 2026 | 118 N PAXON ST | NEW ELECTRICAL WIRING | Violation | OPEN | ZCQ REAL ESTATE INVESTMENT LLC |
| Jul 1, 2026 | 118 N PAXON ST | NEW PLUMBING | Violation | OPEN | ZCQ REAL ESTATE INVESTMENT LLC |
| Jul 1, 2026 | 118 N PAXON ST | UNAPPROVED USED MATERIALS | Violation | OPEN | ZCQ REAL ESTATE INVESTMENT LLC |
| Jul 1, 2026 | 118 N PAXON ST | PLANS REQUIRED TO COMPLY | Violation | OPEN | ZCQ REAL ESTATE INVESTMENT LLC |
| Jul 1, 2026 | 1510 S 8TH ST | EXTERIOR AREA SANITATION | Violation | OPEN | WONG DOUGLAS |
| Jul 1, 2026 | 1510 S 8TH ST | VACANT & OPEN PROPERTIES | Violation | OPEN | WONG DOUGLAS |
| Jul 1, 2026 | 1805 N 6TH ST | UNFIT STRUCTURE | Violation | OPEN | 1805 N 6TH LLC |
| Jul 1, 2026 | 1805 N 6TH ST | PLUMBING SYSTEMS- SANITARY DRAINAGE | Violation | OPEN | 1805 N 6TH LLC |
| Jul 1, 2026 | 1805 N 6TH ST | PLUMBING SYSTEMS- HAZARDS | Violation | OPEN | 1805 N 6TH LLC |
| Jul 1, 2026 | 1805 N 6TH ST | PLUMBING SYSTEMS- GENERAL | Violation | OPEN | 1805 N 6TH LLC |
| Jul 1, 2026 | 2959 A ST | SMOKE ALARM LOCATION | Violation | OPEN | SAEZ IRMA ISAMAR |
| Jul 1, 2026 | 2959 A ST | CARBON MONOXIDE DETECTION REQUIRED | Violation | OPEN | SAEZ IRMA ISAMAR |
| Jul 1, 2026 | 2959 A ST | EXTERIOR AREA WEEDS | Violation | OPEN | SAEZ IRMA ISAMAR |
| Jul 1, 2026 | 2959 A ST | INTERIOR SURFACES | Violation | OPEN | SAEZ IRMA ISAMAR |
| Jul 1, 2026 | 2959 A ST | ABATEMENT OF ELECTRICAL HAZARDS | Violation | OPEN | SAEZ IRMA ISAMAR |
| Jul 1, 2026 | 1313 ROBBINS ST | EXTERIOR AREA WEEDS | Violation | OPEN | CHEN WEN HAI, CHEN ZHOAO HAN |
| Jul 1, 2026 | 2959 A ST | ZONING AND USE REGISTRATION PERMITS | Violation | OPEN | SAEZ IRMA ISAMAR |