82 recorded events, 1975–2025, from 9 city data systems. The city's paper trail here is mostly 30 311 service requests, 26 ACRIS deeds & mortgages, 9 DOB permits.
Full record, year by year Support this site
The city's published records show little recorded distress here in the last three years. Less recorded distress than 100% of 1-5-unit residential buildings citywide. The citywide median for 1-5-unit residential buildings is 0 penalty points per 10 units; this building carries 0. In ZIP 11231, 56% of residential buildings hold an A and 6% grade D or F. How grades work
Among 699,345 1-5-unit residential buildings citywide · left is less recorded distress, right is more
No current HPD flags in the latest weekly snapshot: no open violations, no pending litigation, no active vacate orders, and not in the Alternative Enforcement Program.
No heat or hot-water complaints in the last three years.
No bedbug-infested units reported in the last three years of filings.
5 service requests in the last three years. Most common: Graffiti (2) · Consumer Complaint (1) · Noise (1) · Root/Sewer/Sidewalk Condition (1).
$79,000 in permitted construction work filed since 2016 (3 filings with a declared cost) — a rough measure of how actively the owner maintains the building. Permit costs cover filed construction work only — they do not capture routine maintenance or repairs done without a permit.
| Yes | Built before 1974 (1931) |
| No | Six or more residential units (2) |
| No | 421-a / J-51 tax benefit on the current tax roll |
1 of 3 signals present. Only a partial profile — stabilization is possible but less likely. The definitive answer for any unit: request its rent history from NYS Homes & Community Renewal (free, at hcr.ny.gov).
| Registered owner(s) | 197 COLUMBIA REALTY CORP. |
| Head officer | HUMBERTO LOPES |
| Managing agent | HL. PROPERTY MANAGEMENT LLC. |
| Last registered | 2025-09-30 |
as filed by the owner in the building's HPD registration
| Tax year | City market value | Assessed value |
|---|---|---|
| 2025 | $2,950,000 | $177,000 |
| 2026 | $3,064,000 | $183,840 |
| 2027 | $3,407,000 | $204,420 |
The city's market estimate has risen 15% between tax years 2025 and 2027.
Not in the FEMA 1%-annual-chance floodplain (2015 preliminary maps).
Hurricane evacuation zone 3 of 6 — zone 1 evacuates first.
Not in the city's stormwater (cloudburst) flood maps under any modeled scenario.
No street-flooding or sewer-backup complaints on record at this address.
Sources: FEMA flood maps (coastal), NYC DEP Stormwater Flood Maps (cloudburst), NYC hurricane evacuation zones, and 311 records for this address.
| Subway | Carroll St — F G · 0.5 mi straight-line (about a 13-minute walk) · station accessibility: none |
| Bus | Nearest boarding stop: Columbia St / Sackett St — B61 · 250 ft |
| Citi Bike | Columbia St & Degraw St · 250 ft · station location as of 2026-09-23; live availability |
| School zones (2024–25 map) | Elementary: P.S. 029 John M. Harrigan. Confirm with the DOE's school search. |
Distances are straight-line, not walking routes. Transit locations from the MTA and Citi Bike, bike facilities from NYC DOT, school zones from the DOE's 2024–25 maps.
197 Columbia Street
| Heat or hot water | Heat or hot water |
| Apartment maintenance | Apartment maintenance |
| Bed bugs | Bed bugs |
| Residential pests | Residential pests |
| Rats or mice | Rats or mice |
| Anything else | Anything else |
5 311 service requests from this address in the last three years.
311 will ask for the address, the apartment if the problem is inside, and what's wrong. Contact details are optional for most complaints; food-poisoning reports can be anonymous. Complaints appear in the city's public 311 data, usually within a day or two, and then in the Live from 311 box on this page.
Managed by HL. PROPERTY MANAGEMENT LLC. — 22 buildings, 91 units. Grades across the portfolio: A13 · B6 · C1 · D2. See the whole portfolio
| Building | Borough | Units | Grade |
|---|---|---|---|
| 446 Senator Street | BK | 20 | B |
| 2062 73 Street | BK | 13 | B |
| 322 Van Brunt Street | BK | 9 | A |
| 260 67 Street | BK | 6 | A |
| 234 Van Brunt Street | BK | 3 | A |
| 84 Coffey Street | BK | 3 | A |
| 33 Garnet Street | BK | 3 | A |
| 190 West 9 Street | BK | 3 | B |
| 76 Coffey Street | BK | 3 | A |
| 80 Coffey Street | BK | 3 | A |
| 360 Columbia Street | BK | 3 | D |
| 556 Court Street | BK | 2 | C |
| 482 Smith Street | BK | 2 | A |
| 39 Garnet Street | BK | 2 | D |
| 88 Pioneer Street | BK | 2 | A |
| 484 Smith Street | BK | 2 | A |
| 480 Smith Street | BK | 2 | A |
| 463 3 Avenue | BK | 2 | B |
| 45 Dikeman Street | BK | 2 | A |
| 328 57 Street | BK | 2 | B |
| 197 Columbia Street | BK | 2 | A |
| 246 24 Street | BK | 2 | B |
Most recent mortgage recorded against this lot: $458,790 on 2024-02-16 (lender: Valley National Bank). Face amount at recording — it may have since been paid down, refinanced or satisfied. View the recorded document.
| Date | Record | Amount | Per res. unit |
|---|---|---|---|
| 2024-02-16 | AL&R $930,000 — from 197 COLUMBIA REALTY CORP. to VALLEY NATIONAL BANK | $930,000 | |
| 2024-02-16 | Agreement $930,000 — from 197 COLUMBIA REALTY CORP. to VALLEY NATIONAL BANK | $930,000 | |
| 2024-02-16 | Mortgage $458,790 — from 197 COLUMBIA REALTY CORP. to VALLEY NATIONAL BANK | $458,790 | |
| 2013-11-15 | AL&R $825,000 — from 197 COLUMBIA REALTY CORP. to INVESTORS BANK | $825,000 | |
| 2013-11-15 | Agreement $825,000 — from 197 COLUMBIA REALTY CORP. to INVESTORS BANK | $825,000 | |
| 2013-11-15 | Mortgage $245,000 — from 197 COLUMBIA REALTY CORP. to INVESTORS BANK | $245,000 | |
| 2010-02-25 | AL&R $50,000 — from 197 COLUMBIA REALTY CORP. to MARATHON NATIONAL BANK OF NEW YORK | $50,000 | |
| 2010-02-25 | Mortgage $50,000 — from 197 COLUMBIA REALTY CORP. to MARATHON NATIONAL BANK OF NEW YORK | $50,000 | |
| 2006-04-05 | AL&R $550,000 — from MARATHON NATIONAL BANK OF NEW YORK to 197 COLUMBIA REALTY CORP. | $550,000 | |
| 2006-04-05 | M&CON $550,000 — from 197 COLUMBIA REALTY CORP. to SUCCESSOR BY MERGER TO INTERBANK OF NEW ; MARATHON NATIONAL BANK OF NEW YORK | $550,000 | |
| 2005-03-01 | AL&R $420,000 — from MARATHON NATIONAL BANK OF NEW YORK to 197 COLUMBIA REALTY CORP. | $420,000 | |
| 2005-03-01 | Agreement $420,000 — from MARATHON NATIONAL BANK OF NEW YORK; SBM TO INTERBANK OF NEW YORK to 197 COLUMBIA REALTY CORP. | $420,000 | |
| 2002-06-27 | Mortgage $420,000 — from 197 COLUMBIA REALTYCORP to INTERBANK OF NEW YORK | $420,000 | |
| 1992-03-19 | Mortgage $55,000 — from 197 COLUMBIA REALTYCORP to NAVARRO,DALILA RODRIGUEZ | $55,000 |
| Year | Construction | Enforcement | Housing & tenants | Ownership & money | Health & systems | Total |
|---|---|---|---|---|---|---|
| 2017 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2018 | 0 | 0 | 2 | 0 | 0 | 2 |
| 2019 | 0 | 0 | 6 | 0 | 1 | 7 |
| 2020 | 0 | 0 | 1 | 0 | 0 | 1 |
| 2021 | 0 | 0 | 2 | 0 | 0 | 2 |
| 2022 | 0 | 1 | 5 | 0 | 0 | 6 |
| 2023 | 4 | 0 | 3 | 0 | 0 | 7 |
| 2024 | 2 | 0 | 4 | 6 | 0 | 12 |
| 2025 | 0 | 1 | 1 | 0 | 0 | 2 |
| 2026 | 0 | 0 | 0 | 0 | 0 | 0 |
Every one of the 82 recorded events, 1975–2025, is laid out year by year in the full report (print-ready).
Explore: ZIP 11231 · Landlord rankings · How grades work · The map · The Mice Map