Every market number on Life On Broad comes from Bright MLS, the multiple listing service that covers Philadelphia. Every number shows the period it covers. Where I do the math myself, I say so on the page.
Where the numbers come from
- ZIP code figures. These come from Bright Stats, the monthly market reports in Bright MLS. They include the median sold price, the change from a year ago, days on market, closed sales, active listings, months of supply and the sale price compared with the original list price.
- Showing totals. Showing counts also come from Bright Stats. The year-over-year changes for showings are calculated by Life On Broad.
- Neighborhood figures. Bright reports by ZIP code, and ZIP codes do not line up with neighborhoods. So for each neighborhood I take the Bright MLS closed sales for the past six months and place each one on the map. Life On Broad calculates the results.
How I match sales to neighborhoods
I turn each sold address into a map point using the US Census geocoder, with OpenStreetMap as a backup. Then I count the sale in a neighborhood if the point falls inside its boundary. For most neighborhoods I use the City of Philadelphia neighborhood boundaries from OpenDataPhilly. East Passyunk is the exception. I define it as Washington Avenue to Snyder Avenue, and Broad Street to 6th Street, because the city map does not draw it that way.
Whitman, Dickinson Narrows and Lower Moyamensing are drawn as one combined boundary from the City’s three neighborhood polygons. When two of my boundaries overlap, I count a sale once, in the older guide. If part of a neighborhood sits in a zip that is not in my Bright MLS pull, the page says so, and I do not publish a median for a neighborhood where most of the boundary is missing.
Port Richmond is drawn from the City’s Richmond neighborhood area, limited to ZIP 19134, where the homes are. The part of the City’s Richmond area in ZIP 19137 is not counted. Rittenhouse Square, Fitler Square and Washington Square West use the City’s Rittenhouse, Fitler Square and Washington Square polygons. When I add a zip to my Bright MLS pull, I rerun the numbers for the guides it touches, which is why a guide’s numbers can change a little between updates.
Neighborhood figures use a rolling six months, so each update covers the latest six full months. Active listings are a count of what was for sale on the day of the update.
How often I update
I refresh the numbers once a month, after the month closes. The as-of month and the exact dates are printed next to every table. If a page does not show a date, do not trust the number.
What the numbers cannot tell you
- They only include sales and listings in Bright MLS. Private sales and sales by owner may be missing.
- A median is a middle value, not a price for any one house. Rowhomes, condos and new builds can sit far apart on the same block.
- Small areas swing. When a ZIP code or neighborhood had only a few sales, the page says so, and the median is a rough guide.
- A small number of addresses cannot be matched to a map point. I leave those out of the neighborhood figures instead of guessing.
- Nothing here is an appraisal or a prediction of future prices. Information is deemed reliable but not guaranteed.
Spot something that looks off?
Tell me and I will check it against the source. Email Marco@Rarityre.com with the page and the number, and I will fix it or explain it. See the full numbers on the Philadelphia market reports page.