341 recorded events, 1966–2026, from 13 city data systems. The city's paper trail here is mostly 116 311 service requests, 66 ACRIS deeds & mortgages, 35 HPD complaints.
Full record, year by year Support this site
A modest record — below the level that usually signals systemic problems. More recorded distress than 73% of 6-24-unit residential buildings citywide. The citywide median for 6-24-unit residential buildings is 16.3 penalty points per 10 units; this building carries 54.3. In ZIP 10453, 41% of residential buildings hold an A and 19% grade D or F. How grades work
Among 46,798 6-24-unit residential buildings citywide · left is less recorded distress, right is more
| Open HPD violations | 6 total — 3 class C (immediately hazardous), 3 class B, 0 class A. Oldest open since 2026-03-06. |
status snapshot refreshed weekly from HPD records
4 heat or hot-water complaints in the last three years (winter 2025–26: 4).
No bedbug-infested units reported in the last three years of filings.
$5,000 in enforcement penalties imposed (ECB/OATH) in the last three years.
65 service requests in the last three years. Most common: UNSANITARY CONDITION (11) · Water System (10) · Illegal Parking (7) · Noise (5) · ELECTRIC (4) · GENERAL (4).
$4,214,550 in permitted construction work filed since 2016 (22 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 (1920) |
| Yes | Six or more residential units (24) |
| No | 421-a / J-51 tax benefit on the current tax roll |
2 of 3 signals present. This is the classic profile of a rent-stabilized building (pre-1974, 6+ units) — many units in such buildings remain stabilized. The definitive answer for any unit: request its rent history from NYS Homes & Community Renewal (free, at hcr.ny.gov).
| Registered owner(s) | SHG 174 LLC |
| Head officer | Shimshon Grunstein |
| Managing agent | Frontgate Management |
| Last registered | 2025-08-25 |
as filed by the owner in the building's HPD registration
| Tax year | City market value | Assessed value |
|---|---|---|
| 2025 | $2,135,000 | $960,750 |
| 2026 | $2,190,000 | $985,500 |
| 2027 | $2,275,000 | $1,023,750 |
The city's market estimate has risen 7% between tax years 2025 and 2027.
Not in the FEMA 1%-annual-chance floodplain (2015 preliminary maps).
Not in a hurricane evacuation zone.
Not in the city's stormwater (cloudburst) flood maps under any modeled scenario.
2 street-flooding or sewer-backup complaints at this address since 2015 (1 in the last three years).
Sources: FEMA flood maps (coastal), NYC DEP Stormwater Flood Maps (cloudburst), NYC hurricane evacuation zones, and 311 records for this address.
| Subway | 176 St — 4 · 950 ft straight-line (about a 5-minute walk) · station accessibility: none |
| Bus | Nearest boarding stop: Macombs Rd / W 174 St — Bx18A · 350 ft |
| Citi Bike | Macombs Rd & W 175 St · 300 ft · station location as of 2026-09-23; live availability |
| School zones (2024–25 map) | Elementary: P.S. 204 Morris Heights. 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.
51 West 174 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 |
65 311 service requests from this address in the last three years — 2 of them about heat or hot water.
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 FRONTGATE MANAGEMENT — 77 buildings, 1,379 units. Grades across the portfolio: A25 · B31 · C10 · D5 · F5. See the whole portfolio
showing 60 of 77 buildings
Most recent mortgage recorded against this lot: $2,600,000 on 2023-01-04 (lender: Broad X Funding LLC). Face amount at recording — it may have since been paid down, refinanced or satisfied. View the recorded document.
| Date | Record | Amount | Per res. unit |
|---|---|---|---|
| 2026-07-17 | AL&R $6,510,000 — from SHG 174 LLC to FIRST COUNTY BANK | $6,510,000 | |
| 2026-07-17 | M&CON $6,510,000 — from SHG 174 LLC to FIRST COUNTY BANK | $6,510,000 | |
| 2023-01-04 | Mortgage $2,600,000 — from SHG 174 LLC to BROAD X FUNDING LLC | $2,600,000 | |
| 2023-01-04 | AL&R $2,600,000 — from SHG 174 LLC to BROAD X FUNDING LLC | $2,600,000 | |
| 2023-01-03 | Deed $1,015,000 — from MERCADO, MARCOS A to SHG 174 LLC | $1,015,000 | |
| 2023-01-03 | Mortgage $1,800,000 — from SHG 174 LLC to BROAD X FUNDING LLC | $1,800,000 | |
| 2022-12-19 | Sold for $1,015,000 | $1,015,000 | $42,292 |
| 2021-02-23 | Mortgage $465,000 — from MERCADO, MARCOS A to MERS | $465,000 | |
| 2018-02-07 | Mortgage $465,000 — from MERCADO, MARCOS A to MERS INC. AS NOMINEE FOR JET DIRECT FUND | $465,000 | |
| 2013-06-05 | Mortgage $61,794 — from MERCADO, MARCOS A to CONTINENTAL HOME LOANS, INC.; MERS | $61,794 | |
| 2013-06-05 | Agreement $380,545 — from MERCADO, MARCOS A to CONTINENTAL HOME LOANS, INC.; MERS | $380,545 | |
| 2011-02-02 | Mortgage $330,000 — from MERCADO, NANCY; MERCADO, MARCOS A to MERS | $330,000 | |
| 2003-08-26 | Mortgage $203,000 — from MERCADO, HORTENCIA; MERCADO, FAUSTO A to MORTGAGE ENTERPRISE, LTD. | $203,000 | |
| 1998-10-28 | Mortgage $6,000 — from MERCADO, HORTENSIA to ULTRA SASH WINDOW FACTORY, INC. | $6,000 | |
| 1995-07-24 | Mortgage $35,000 — from MERCADO, MARCO A.; MERCADO, HORTENSIA; MERCADO, FAUSTO A. to CITIBANK N. A. | $35,000 |
| Year | Construction | Enforcement | Housing & tenants | Ownership & money | Health & systems | Total |
|---|---|---|---|---|---|---|
| 2017 | 0 | 0 | 3 | 0 | 1 | 4 |
| 2018 | 0 | 0 | 0 | 2 | 0 | 2 |
| 2019 | 0 | 0 | 5 | 0 | 0 | 5 |
| 2020 | 0 | 0 | 9 | 0 | 0 | 9 |
| 2021 | 0 | 0 | 4 | 2 | 0 | 6 |
| 2022 | 11 | 0 | 8 | 3 | 0 | 22 |
| 2023 | 22 | 11 | 5 | 10 | 2 | 50 |
| 2024 | 7 | 2 | 9 | 10 | 1 | 29 |
| 2025 | 6 | 0 | 16 | 6 | 1 | 29 |
| 2026 | 4 | 0 | 94 | 11 | 2 | 111 |
Every one of the 341 recorded events, 1966–2026, is laid out year by year in the full report (print-ready).
Explore: ZIP 10453 · Landlord rankings · How grades work · The map · The Mice Map