Public-Record Property Investigation: Philadelphia Edition

Editorial Skills: , ,

The City of Philadelphia’s online presence has been a bad joke for a very long time. But in the past several years the city has taken steps to modernize its website and there are now a number of useful tools for citizens to easily access publicly available data, including basic property records and associated data about that property’s tax status, L&I records, and its water usage.

This tutorial, and particularly the part about gathering information about a property’s water usage, is based on a great article that used to be on, but since the site’s archive is no longer available, I am reproducing the steps here.

Part I: Use the Philadelphia Stormwater Map to Identify a Property

Water and sewer services are provided to properties in Philadelphia by a city-owned utility, the Philadelphia Water Department (PWD). You can use the PWD website to identify a property parcel by its address or map location and use PWD’s record for that property to learn who the listed owner is and make basic guesses about the property’s occupancy.

  1. Open your browser and go to to access the PWD’s Stormwater Billing Map Viewer.
  2. If you have the property’s address, you can enter it in the Search bar. You can also enter a street intersection close to the property or, if you already have it, the PWD account number for the property.
  3. You can also find a property by scrolling across and zooming in on the map of the city until you are zoomed in enough to click on the property parcel you are researching.
  4. After selecting a parcel, you see a pop-up with the address and two sets of data:

    • Property Info
      • OPA/BRT Account: The city’s account number for this property parcel.
      • Owner: The listed owner of this property.
      • Property Type: Residential, Non-Residential, etc.
      • Gross Area: The total area of the parcel, in square feet (if the structure has multiple stories, the area of each is included).
      • Impervious Area: The area of the structure and of any paved area of the property parcel that is impervious to drainage and therefore generates stormwater, which PWD bills for.
    • PWD Info
      • Account: The PWD account number, attached to the property.
      • Account Holder: The name of the current account holder who receives a monthly bill from PWD.
      • Address: The address of the property.
      • Service Type: The code and types of service that the property is being billed for.
      • Meter Size: The type of meter installed at the property.
  5. You can also click the More info link to see more detailed PWD info for the property, including a Charge Summary of the stormwater rates over the past several years.
  6. Record the PWD account number. You can just copy it and paste it into a text document; if you are researching multiple properties, gather their PWD account numbers before proceeding to the next section. You may also want to copy the OPA/BRT Account number, too.

Part II: Use the PWD Account Number to Look up a Water Bill

You can use the PWD’s online bill-pay feature to look up the property’s water bill.

  1. Go to
  2. Click Pay a water bill.
  3. Click Pay now.
  4. On the Account Lookup screen, paste the PWD account number, type in the characters from the CAPTCHA test and click Look Up.
  5. The Water/Sewer & Stormwater Bill will appear with the following information:

    • Your Account Balance
    • Name
    • Service Address
    • Last Bill
    • Last Payment
    • Next Payment Due
    • Delinquent Balance
    • Account Number
    • Current Charges
    • Last Payment Amount
  6. Take a screenshot or otherwise record this information and continue with your investigation. Do not pay somebody else’s water bill.

Water/Sewer & Stormwater Bill Examples – Side by Side

You can use the information from the Water/Sewer & Stormwater Bill screen to learn a lot about the property you are investigating.

  • Are they paying their bill? Check the Your Account Balance, Last Payment and Delinquent Balance sections. If there are large numbers here, that is a red flag. Absentee landlords, slumlords, blightlords and other scofflaw owners may not be paying their bill. And if you go long enough without paying your water bill, PWD will shut off your water. A residential property without water service cannot legally be inhabited, so if you find a property with suspended service, that is significant, especially if you believe it may be inhabited.
  • Monthly charges: Any property, including a parking lot with no water hookup, will generate some amount of charges based on the stormwater and sewage charges calculated from its “Impervious Area.” The monthly charge is is a clue to what goes on inside of the structure. Using a standard Philadelphia rowhome as an example:
    • Somebody living there? The bill will be at least $60 month, and more depending on how many people are in the house and their water-usage habits.
    • Abandoned house? If the bill is less than $20 a month, the property is likely not being actively lived in and is just racking up stormwater charges.
    • Squatters? If the house looks abandoned but is generating a higher water bill, somebody may have succeeded in getting service to the house and is living there.

I am using 2645 Agate Street as an example of a very bad actor. This is a house in my neighborhood. The owner, George Capewell, is a slumlord and tax deadbeat. He’s even been quoted on the local TV news in September 2012, denying responsibility for the collapse of one of his buildings. If you want to get angry at government bureaucracy (which I do not, but sometimes you can’t help it), consider the fact that this guy has accumulated a $13,000 water bill while also racking up a stack in unpaid taxes. Here’s his PWD account status as of August 2018:

Compare that to a nearby location. It’s not a rowhouse – it’s actually a large junkyard with its own legal issues that was the site of a huge fire in July 2018. But at least they pay their water bills.

Part III: Property Tax Info

We’ve looked at the water billing for the property. Now let’s look at the actual property info.

  1. Take the OPA/BRT number you gathered from the PWD website in Part I.
  2. Go to
  3. Enter the OPA number in the search field, and select Account from the drop-down menu to the left of the search field and click the magnifying-glass icon or press Enter.
  4. When the property screen loads, you will see lots of important information, from the name of the Owner and the Mailing Address where they receive their bills and notices from the city, to the sales date and price, to an annual breakdown of the property values assessed by the city.
  5. You can continue the investigation into any taxes owed to the city by the owner by clicking on View the Tax Balance.
  6. The button links you to Philadelphia’s Revenue Department at You can look up a property by its address or OPA/BRT number. Enter one search criteria or the other and click the >> button next to the search field.
  7. The Real Estate Tax Balance Information table that loads farther down the page loads information by year, including Principal (the still-unpaid amount for a given year), any Interest, Principal, or Other charges that derived from the unpaid Principal, and the Total amount owed to the city. If there was a lien placed on the property for unpaid tax in a year, the Lien # is listed, along with the City Solicitor assigned to the property and the Status, an abbreviation which is referenced in the table below.

Property Tax Info Examples – Side by Side

Again, the example I am using here is George Capewell’s 2645 Agate Street. Without going into too much detail, you can see that as of August 8, 2018, he owes almost $4,000 in taxes to the city, in addition to his water bill of $13,000.

Actually, it was worse. In this screenshot from the BRT website from October 2017, you can see Capewell owed an extra thousand and change. After repeatedly bothering the local city councilman, we were able to have the property listed for Sheriff’s Sale, which is what the city is supposed to do when you don’t pay your property taxes. It looks like Capewell paid a nominal amount, about $1,000, and he got to keep his blighted, abandoned property, which continues to accumulate unpaid tax and PWD charges.

Part IV: L&I Violations

If Capewell doesn’t pay his water bill or his taxes, you know that there’s going to be something else wrong with the property. Let’s see the Licenses & Inspections department’s history for 2645 Agate Street.

  1. Go to
  2. Enter your chosen search criteria and click the magnifying-glass icon or press Enter.
  3. When the property screen loads, scroll down to Permits, Licenses, and Violations and click View the L&I Records.
  4. You will be taken to’s L&I Property History listing for that property, which includes the owners name, the address L&I is sending correspondence to, and the open Permits, Business Licenses, Violations, and Appeals.
  5. Under Business Licenses, George Capewell does have a rental license, which is required when you are renting out a residential property… but it expired in 2012.
  6. Under Violations, click under the link for the case number. I picked the one with five violations.
  7. Click on the plus sign next to the Violation Number. Unfortunately, the current site design only allows you to see one violation at a time.
  8. There are too many violations to go over on this property, so I have picked one related to the unpaid water bill: PM-408.1/3 states that the property does not have water service.

Part V: Sheriff Sale Records

As I said, this property was taken to Sheriff’s Sale once. See what property info is available on the Sheriff’s website.

  1. Go to the Philadelphia Sheriff’s site at
  2. Click Sheriff Sales in the header menu.
  3. Select Sheriff Sale Properties from the drop-down menu.
  4. Twirl down the Search by Property menu to the right side of the map.
  5. Enter the address of the property and click Search.
  6. The property will display as a pin dropped on the map. Click the pin.
  7. The Sale Information and Property Information appear on the right side of the screen.
  8. In this case we see that the sale of the Capewell property was Stayed, but we don’t know how much Capewell paid to make that happen. (Refer back to the info from the Revenue website and you can see that 2645 Agate is not under any payment plan.)