Multi-family report

1417 E Columbia Ave

5 bd · 5 ba · 3 stories · 2,564 sqft · RSA5 · built 1915

Investor / LLC · assessed $519K (2026) · 2027 OPA assessment $530K · 5 licensed units · sold 2×. On the 1400 block of E Columbia Ave.

Property summary

“Open” reflects records available then historical records keep their source dates estimates are labeled

BlockReport AI · cited public records

Ask the questions this record raises.

These curated questions are free. Choose one to open its cited answer.

Question or correct this record

BlockReport can explain a discrepancy, but it cannot rewrite an official City record. Use the agency that owns the underlying fact:

Street view of 1417 E Columbia Ave
From the street — imagery © Google
From above — imagery © Esri, Maxar

The estimate, live balance, and back-tax record are different.

BlockReport can calculate the annual tax from the City’s taxable assessment. Payments, credits, interest, and a current amount due live separately in Philadelphia Tax Center.

Estimated annual Real Estate Tax$7,264/year

2026 taxable assessment $518,900 × 1.3998%. Estimate—not a bill or account balance.

OPA also publishes a 2027 assessment of $530,000; it is not the 2026 billed-year value.

Official current account balanceCheck live

A Tax Center balance is net of bills, payments, credits, interest, and adjustments. A credit—or an amount due—is not automatically “back taxes.”

OPA 181107100
Open Philadelphia Tax Center →Choose “View period balance” to see the tax year and any credit, interest, or delinquency.
Exemption classificationNo exemption shown

2026 taxable assessment equals the full assessed value.

Historical delinquency sources No current conclusion

This parcel did not match the June 2022 delinquency snapshot. That absence does not confirm the account is current today.

For a purchase, refinance, or closing, request the City’s official Property Payoff statement in Tax Center under “More options.”

What stands out

From the public record

Fetched L&I and zoning records

Every row successfully fetched for this report is counted below. Dataset availability and matching can differ from the City's interactive file; use the official link for current detail.

Open the City record ↗
Recorded owner
Flounder LLC
Tax mailing address
1610 SPRUCE ST STE 400, PHILADELPHIA PA, 19103
L&I district
CENTRAL EAST
Building ID (BIN)
1008783
OPA account
181107100
Permits0No match
Violation cases47 violation records · 0 open
Investigations147 failed · 5 passed · 2 closed
Building certifications5Latest result: Certified
Business licenses21 active
Appeals0No match
PermitsPermit number, issued date, work and City status0

No permits matched this parcel in the fetched City dataset.

Violation cases7 individual violation records; resolved history remains visible4
Case 410666CLOSED

STANDARD · Opened Nov 13, 2013

  • LICENSE-RES GENERALViolation 3192065Nov 12, 2013 COMPLIED
Case 625202CLOSED

STANDARD · Opened Mar 14, 2018 · completed Dec 20, 2018

  • EXTERIOR STRUCT ROOF DRAINAGEViolation 4705383Mar 14, 2018 COMPLIED
  • EXIT SIGNS REQUIREDViolation 4705381Mar 14, 2018 COMPLIED
  • FIRE ALARM TESTED/CERTIFIEDViolation 4705382Mar 14, 2018 COMPLIED
Case 663024CLOSED

STANDARD · Opened Nov 8, 2018 · completed Dec 6, 2018

  • FIRE ALARM TESTED/CERTIFIEDViolation 4867997Nov 6, 2018 COMPLIED
Case CF-2025-119004CLOSED

NOTICE OF VIOLATION · Opened Oct 29, 2025 · completed Dec 3, 2025

  • INSPECTION, TESTING & MAINTENANCE Violation VI-2025-085444Oct 29, 2025 COMPLIED
  • PERIODIC TESTING Violation VI-2025-085445Oct 29, 2025 COMPLIED
InvestigationsEvery inspector visit, including CLOSED outcomes14
HCEU INSPCase 410666

Nov 12, 2013 FAILED

HCEU INSPCase 410666

Jan 6, 2014 FAILED

HCEU INSPCase 410666

Feb 11, 2014 CLOSED

PRECOURTCase 410666

May 23, 2014 FAILED

PRECOURTCase 410666

Feb 23, 2018 PASSED

HCEU INSPCase 625202

Mar 14, 2018 FAILED

HCEU INSPCase 625202

Apr 19, 2018 FAILED

HCEU INSPCase 625202

Jun 11, 2018 CLOSED

HCEU INSPCase 663024

Nov 6, 2018 FAILED

HC BOARDCase 663022

Nov 6, 2018 PASSED

PRECOURTCase 625202

Nov 6, 2018 PASSED

HCEU INSPCase 663024

Dec 6, 2018 PASSED

L&I investigationCase CF-2025-119004

Oct 29, 2025 FAILED

L&I investigationCase CF-2025-119004

Dec 3, 2025 PASSED

Building certificationsInspection result and filed expiration date by L&I building ID5
Fire Alarm CertificationCertification BC-2021-005191

Inspected Jul 30, 2021 Certified Expires Jul 30, 2022

Fire Alarm CertificationCertification BC-2022-010088

Inspected Jul 15, 2022 Certified Expires Jul 15, 2023

Fire Alarm CertificationCertification BC-2023-015138

Inspected Jul 12, 2023 Certified Expires Jul 12, 2024

Fire Alarm CertificationCertification BC-2024-020886

Inspected Jul 19, 2024 Certified Expires Jul 19, 2025

Fire Alarm CertificationCertification BC-2025-030336

Inspected Jul 9, 2025 Certified Expires Jul 9, 2026

Business licensesHistorical and active licenses are both retained2
RentalLicense 260542

K & T PROPERTIES

Revenue code 3202 · First issued Apr 26, 2004 Inactive Expiration Feb 28, 2019 Inactive Apr 29, 2019

RentalLicense 777053

Flounder LLC

Revenue code 3202 · First issued May 17, 2018 Active Expiration May 16, 2027

AppealsApplication status and decision are separate City fields0

No appeals matched this parcel in the fetched City dataset.

City of Philadelphia OPA, L&I and Zoning Board records, shown as filed. A CLOSED investigation is an outcome label, not a missing visit; an appeal's application status and decision may differ.

Records to verify together

Rule-based groupings across this property's dated public records. Each flag shows the records that belong in the same verification step and where the inference stops.

Dated record flagAssessment/permit mismatch

The assessment jumped 61% in 2023, but no matching permit appears in the property timeline.

Evidence: assessment moved from $317,900 to $510,800 · no permit shown in 2022-2024

Limit: Not proof of unpermitted work; reassessment, corrected data, or a permit under another parcel can also explain it.

Transparent record rules, not a score or forecast. Each flag is a prompt to verify the cited records, not a prediction or allegation.

What to do with this

The record, translated into moves — what a buyer, the owner, and a landlord would each want to check next under Philadelphia's actual rules.

If you’re buying

Built 1915: lead rules apply

Federal law requires a lead-paint disclosure at sale for any pre-1978 home. If it will be rented, Philadelphia also requires a lead-safe or lead-free certificate before a rental license can issue.

5 units and RSA5 zoning need reconciliation

The assessment or license record describes multiple units while the zoning district is generally single-family. That does not establish whether the use is lawful, nonconforming, abandoned, or incorrectly coded. Verify the registered use and Certificate of Occupancy with L&I before pricing multiple rents.

If you’re the landlord

Lead certificate is not optional

Built 1915: every rental unit needs a lead-safe or lead-free certificate on file with the City. Without one: fines up to $2,000/day per unit, tenants may withhold rent, courts can order rent refunded — and no eviction will stand.

Licensed rental — keep it that way

Renewal requires city tax clearance and zero open L&I violations on the property. A lapsed license suspends the right to collect rent or evict.

Derived from the fetched property records and linked City guidance as of 2026. Assessment treatment is not a substitute for an exemption approval, live balance, title report, license, occupancy certificate, or inspection. Informational only — not legal, tax, or investment advice.

Who's behind it

Flounder LLC · corporate / LLC owner

• Owns 3 properties across Philadelphia under this name, assessed at $1.6M combined
• Tax bills mail to 1610 Spruce St Ste 400, Philadelphia PA, 19103
• Holds an active rental license for this address

The investment read

How this building has moved and where it's pointed: the city's assessed value (not a listing price) over 12 years, charted against its block; appreciation is that history's pace, and the 5-year figure simply extends it. Yield estimates rent-vs-price from area rents. Ask the record to dig into any number.

Assessed value
$518,900
2026 billed-year assessment · 2027: $530,000 · built 1915
Price / sq ft
$207
block $264 · below block
Appreciation
+277%
+14%/yr, city 6.5%
In 5 years (~2031)
~$534K
+14%/yr own pace held 5 yrs — extrapolation, not a forecast
Est. tax bill / yr
$7,264
1.37% effective
Jun 2022 tax snapshot
No match
not proof the account is current
Gross yield
4.4%
≈$2K/mo rent
Times sold
2
licensed rental

Value vs. the block, over time — sales, permits & L&I events marked on the line

$0$500K$1.0MBefore this chart — 2003: Sold $335K 2013: L&I violation 2013: Inspection failed 2014: Inspection failed ×22018: Sold $1.5M 2018: 4 L&I violations 2018: L&I: 3 failed, 4 passed2025: 2 L&I violations 2025: L&I: 1 failed, 1 passed$519K201620212026
This houseBlock median & rangeSaleL&I violationPermit

The paper trail

Traded 2×: $335K in 2003 → $1.5M in 2018 (+356%).

  1. 2003 $335KSold
  2. 2013 L&I violationL&IInspection failedL&I visit
  3. 2014 Inspection failed ×2L&I visit
  4. 2018 $1.5MSold4 L&I violationsL&IL&I: 3 failed, 4 passedL&I visit
  5. 2025 2 L&I violationsL&IL&I: 1 failed, 1 passedL&I visit

Flags: active rental license. Informational only — not investment advice or a consumer report (FCRA).

The property, on paper

The city assessor's field record — the physical spec sheet behind the assessed number.

Bedrooms
5
Bathrooms
5
Stories
3
Interior
2,564 sqft
livable area
Lot
1,590 sqft
Basement
Full, unfinished
city code C
Heat
Hot water / radiators
city code B
Central air
No
Exterior condition
Average
city code 4
Interior condition
Average
city code 4
Quality grade
C
assessor's grade
Zoning
RSA5
city zoning code

OPA field-assessment attributes. Condition and grade are the assessor's codes, not an inspection.

Run the numbers

What owning 1417 E Columbia Ave takes, at your price and your rate. Taxes start with an annual estimate from the City’s taxable assessment, not a current bill or balance; rent starts at 5 licensed units × ~85% of the area's median unit rent — the whole building's income, not one unit's. Assessed value is not an asking price — set the price slider to the real one.

$530K
20%
6.875%
$8K/mo

When this house last sold (2018) a 30-year mortgage ran about 4.54% — Freddie Mac's average that year.

Mortgage
P&I · 30-yr fixed
All-in monthly
+ taxes & insurance
Cash to close
down + ~4% costs
Cash flow
rent − all costs · /mo
Cap rate
NOI ÷ price
Cash-on-cash
year-1 return on cash in

Estimates for orientation, not advice. Assumes a 30-year fixed loan, $3,500/yr insurance, 1% of price/yr maintenance; taxes use this parcel's taxable assessment, not a live Tax Center balance.

Block context

1417 E Columbia Ave sits on the 1400 block of E Columbia Ave. Open the block report to compare its parcels, ownership and public-record history.

See the whole block →

Next door: 1415 E Columbia Ave  ·  1419 E Columbia Ave

Where this comes from

Methodology & freshness

This report was assembled Jul 10, 2026, 2:13 AM ET. Available City datasets are queried from OpenDataPhilly (phl.carto.com) and the cited City ArcGIS feeds; record queries paginate rather than silently taking a first page. For this property: Permits: queried · Violations: queried · Investigations: queried · Appeals: queried · Licenses: queried · Building certifications: queried. “Unavailable” means the source query failed or was not supplied, not “no record.” Reports re-pull on view after seven days and on an overnight rolling schedule; citywide benchmarks recompute weekly. Source dates still govern: the parcel-level tax-delinquency snapshot is June 2022 and the separate detailed tax ledger ends in 2016, so neither establishes today’s balance. The live balance and date-effective payoff must be verified in Tax Center. AI-written passages are grounded in the assembled record and rejected if they state a number the record does not hold.

Official city record ↗  ·  L&I history ↗  ·  See the whole block  ·  Download this record (JSON)