How to Find Delinquent Tax Properties in Philadelphia

If you invest in Philadelphia real estate, “delinquent tax list” is one of those phrases that gets thrown around a lot — usually attached to a $99 spreadsheet someone is trying to sell you. The good news: the underlying data is public, free, and updated monthly directly from the City of Philadelphia. The less good news is that most people misread it, because delinquency data has more nuance than a simple yes/no flag.

Where this data actually comes from

The City of Philadelphia publishes two closely related — but distinct — real estate tax datasets through its open data program:

• Real Estate Tax Balances — the broader dataset, covering both overdue accounts (a current-year balance that isn't yet considered delinquent) and true delinquencies (unpaid balances from previous tax years).
• Real Estate Tax Delinquencies — a more narrowly scoped monthly view focused specifically on delinquent accounts, published by the Department of Revenue.

Both are available through OpenDataPhilly and the City's data.phila.gov visualization portal. Neither requires a paid data broker — the City makes this available directly.

Overdue vs. delinquent: the distinction that trips people up

Not every property with a balance owed is actually “delinquent” in the legal sense that matters for investors. A property can show a current-year balance simply because the bill was mailed a month ago. That's overdue, not delinquent — the owner still has time, and no enforcement action has started.

True delinquency means unpaid balances carrying over from a prior tax year. That's the population that eventually becomes eligible for collection action — and, if unresolved, a Sheriff Sale. Filtering for years-owed > 0, not just balance-due > 0, is the single most common mistake people make when working with this data.

What happens after a property goes delinquent

Unpaid real estate tax doesn't jump straight to a public auction. Philadelphia's process runs through a few stages:

1. Collection and outreach — the Department of Revenue and its collection counsel (including outside firms handling assigned accounts) attempt payment plans and legal notices before pursuing a sale.
2. Sheriff Sale petition — if unresolved, the City files a petition in the Court of Common Pleas and serves a Rule to Show Cause on anyone with an ownership interest.
3. Tax Sheriff Sale — the property is auctioned. Philadelphia runs several tax-related Sheriff Sales each month (in addition to separate mortgage foreclosure sales), each identified by a book and writ number.

Two details matter enormously if you're evaluating a property that shows up in a delinquency dataset:

• Right of Redemption — if a property was owner-occupied within 90 days of the sale, the original owner has up to nine months after the deed is acknowledged to reclaim it by repaying back taxes plus what the winning bidder paid. Unoccupied or abandoned properties don't carry this right.
• Liens are cleared at sale — sale proceeds are applied to municipal liens, and title passes without those debts attached, even if the sale price didn't fully cover them. That's part of what makes tax sale properties attractive — but it also means the process is genuinely adversarial, not a quiet backdoor deal.

Public data on a property doesn't mean it's actually headed to sale. The City's own reporting shows the large majority of delinquent accounts get resolved — paid in full, put on a payment plan, or under active appeal — before ever reaching auction. A delinquency list is a pool of leads to investigate, not a shopping list of guaranteed acquisitions.

A basic due-diligence checklist

• Confirm current occupancy status (affects Right of Redemption)
• Check for open Licenses & Inspections violations tied to the property
• Pull the OPA record to confirm assessed value and ownership details
• Verify whether the account is under an active payment plan or appeal — both can pull a property off the sale track with no notice

Where this gets slow (and where reporting helps)

The friction most investors hit isn't a lack of data — it's that checking these facts one property at a time, address by address, doesn't scale past a handful of leads a week. A live, filterable dashboard connected directly to the City's data — rather than a static export someone ran last month — is the difference between reacting to a stale list and actually working a real pipeline.

This article is general information about how Philadelphia's public tax data works, not legal or investment advice. Sheriff Sale purchases carry real legal and financial risk — title issues, redemption rights, and property condition among them. Talk to a real estate attorney before bidding on anything.