My first Philadelphia sheriff sale bid went fine, the second one handed me a $23,000 lien I never saw coming.

The line about the searcher pulling from the wrong index is the part people skip over and it costs them every time. Philadelphia has this layered municipal lien structure where L&I violations can be filed in ways that don't show up in a standard UCC or judgment search, and a lot of generalist title searchers don't know to look at the Department of Revenue's own records separately from the prothonotary index. I had a smaller version of this on a note I was evaluating in West Philly in 2022, not a purchase, just due diligence before I walked away, and even then the preliminary search I paid $400 for missed a demo lien that was sitting right there in the city's online portal if you knew where to click. I did not bid. The guy who did bid is still working through a dispute with the city about whether that lien transferred.

What was the date range on the L&I violations, like were they pre-2019 or did some of them accumulate during the foreclosure proceedings themselves? That matters a lot because violations that stack up while the property is in active foreclosure can sometimes be challenged, and I have seen servicers eat those costs in workout negotiations when the borrower was judgment-proof anyway.

The assumption doing the most work in your original underwriting was treating the $38k purchase price as a clean basis. Philadelphia's lien survival rules mean the bid price is a floor, and the real question before any Philly sheriff sale bid is what the city has been building against that address for years, not what the mortgage balance says.

The L&I and PWD gap you hit is a known failure mode with generalist title searches. The city's L&I violation database and the PWD account history sit in systems that a searcher pulling standard county index records will miss entirely. Those are not title defects in the traditional chain-of-title sense, so a searcher optimized for deed and mortgage index pulls will come back clean while the municipal exposure is sitting in a completely separate database. What you described is not a searcher error so much as a scope-of-work mismatch.

The deed recording lag is the risk almost nobody prices in. Eleven weeks of holding costs on a property you cannot permit or resell cleanly is dead carry. On a $38k purchase with even modest hard money, that timeline matters to your annualized return. Worth building a minimum twelve-week dead-carry assumption into any Philly acquisition model before you bid.

The squatter resolution through the city's process rather than standard eviction is also Philly-specific and slower than operators expect coming from other markets. The $2,800 you spent is probably close to the floor for that track.

Your actual all-in at $61k against a $110k optimistic ARV leaves you with less cushion than it looked like at bid, especially if the renovation scope moved at all. What did the property ultimately cost you fully resolved, and did the ARV hold?

That $23,000 lien surprise is one of the most useful things someone can share in this forum, so thank you for writing it out in detail.

For anyone reading who is new to the vocabulary: a lien is a legal claim against a property for an unpaid debt. When you buy a property at a sheriff sale (a court-ordered auction after a foreclosure), some liens get wiped out and some survive, meaning they attach to the new owner. Which ones survive depends on the state, the city, and exactly how and when each lien was recorded. Philadelphia is genuinely more complicated than most markets on this point.

The UPB, or unpaid principal balance, on the original note was $91,000. The poster bought the note for $38,000, which looked like a deep discount against a property worth roughly $110,000. Then $23,400 in surviving liens changed the actual cost basis from $38,000 to over $61,000 before any repair work. That is the math the discount has to survive.

The practical checklist the poster built from this experience is solid: find a title company that specifically handles Philadelphia sheriff sales, pull the water and sewer account history directly from the Philadelphia Water Department, and call Licenses and Inspections yourself for the full violation history. Those are primary sources. A general title search pulling from the wrong index, as happened here, will miss things.

I want to be clear that I am not sure how lien survival rules vary across Philadelphia sale types, and a local real estate attorney familiar with Pennsylvania sheriff sales is the right person to confirm which liens are extinguished and which survive in a given situation.

What was the resolution path you ended up taking on the property once the deed recorded?