The NYC Pied-à-Terre Tax Database

Looking for the city’s official list? A court ordered the DOF public lookup offline on August 10, 2026 — but on August 13 an appeals court allowed the city to continue its rollout while the appeal is heard (hearing Aug 31 — tracker, and the ruling), and the city’s roll files and deadline pages stayed online throughout (our Aug 12 check). This independent database — published by Conquest, not affiliated with the City or DOF — is built from DOF’s already-published July 2026 supplemental roll. The tax law itself is unchanged — and the safest course is still to file exemptions by October 6.

DOF roll date July 24, 2026 · updated when DOF corrects the roll

Questions owners ask

Where can I find the NYC pied-à-terre tax list?

A court ordered the city’s DOF lookup offline on August 10, 2026 as part of a rollout lawsuit — but on August 13 an appeals court allowed the city to continue its rollout while the appeal is heard (next hearing Aug 31), and the city’s files stayed posted throughout. This page is an independent, searchable version of the same underlying public data — DOF’s July 2026 Supplemental Market Value Roll of 959,710 records — organized as a list of the 2,236 buildings with units over the $1M Phase-1 threshold, each with its own analysis page.

Is there a pied-à-terre tax lookup by address?

Yes — free. Enter any NYC address and unit and Conquest emails you the unit’s official DOF market value (the surcharge base), the threshold test, and the estimated surcharge, usually within the hour. It works for condos, co-ops and 1–3 family houses, whether or not the building appears in the over-threshold list.

Can I download the pied-à-terre tax list as a spreadsheet?

The underlying roll is public DOF data, and this database presents it building by building rather than as a bulk file. If you need a structured extract for research or reporting, contact piedaterre@conquest.nyc and we can usually help.

Is the “Mamdani pied-à-terre tax list” the same as this database?

They draw on the same DOF roll. The list the city published — and was ordered to take down — covered roughly 900,000 records including hundreds of thousands of properties that will never owe the surcharge. This database analyzes the full roll but focuses on what matters: the buildings and units that actually test over the threshold, with per-building numbers.

Houses and townhouses, by ZIP code

6,763 one-to-three-family homes are over the threshold citywide. We publish those only as ZIP-level counts — they are private homes, not towers. Top 25 ZIPs of 77:

Where these numbers come from

Source: NYC Department of Finance Supplemental Market Value Roll, published July 2026 (roll date July 24, 2026; the roll is open to correction through December 2026 and this page is regenerated when DOF updates it). A building appears here when at least one of its condo or co-op units exceeds the Phase-1 surcharge threshold. "Max annual surcharge" sums the statute-exact Phase-1 surcharge of every over-threshold unit in the building — the ceiling if no unit qualifies for a primary-residence or rental exemption; actual collections will be lower. Values are DOF market values, not resale prices: co-ops and many condos are valued off rent rolls and sit far below market price. Buildings where DOF's own classification is legally ambiguous are marked †, and our data carries both possible schedules for every such unit. Full methodology in our roll analysis.

Tower-by-tower write-ups of 129 famous buildings →