Independent site. Data from NYC Open Data; not affiliated with the City of New York.

NYC Property Factsfree public-records reference

247 Avenue U, Brooklyn, NY 11223

BBL 3071010125 (Borough 3, Block 7101, Lot 125) · BIN 3191333 · Last updated:

Also recorded in city data as: 292 Van Sicklen St · 292905 Van Sicklen St · 2922/2 Van Sicklen St

Summary · as of October 31, 2026

247 Avenue U (Brooklyn, NY 11223; tax lot BBL 3071010125) is a store building (building class K7: store building (subtype K7)), built around 1931, on a 3,240 sq ft lot zoned R5B. City tax records list the owner as 247 AVENUE U PARTNERS LLC; per ACRIS, a deed to this owner dated November 3, 2010 lists a price of $1,285,000. The Department of Finance's final market value for tax year 2027 is $2,316,000. As of October 31, 2026, NYC Open Data shows two active DOB violations. There were three 311 requests in the past 12 months and no HPD complaints since 2019. (Source: NYC Open Data — DOB, HPD, OATH, DOF, DCP and ACRIS datasets — compiled by NYC Property Facts.)

Owner of record
247 AVENUE U PARTNERS LLC
Building class
K7 · Store building
Year built · units
1931 · 0 res.
Lot area · zoning
3,240 sq ft · R5B
Market value (DOF)
$2,316,000 FY2027
Last priced deed
$1,285,000 · 2010-11-03
BBL
3071010125
BIN
3191333

How to cite: NYC Property Facts, “247 Avenue U, Brooklyn, NY 11223 (BBL 3071010125)”, data as of 2026-10-31, https://nycpropertyfacts.com/ny/brooklyn/247-avenue-u-3071010125. Source: NYC Open Data.

Lot & building

Basic facts about the tax lot and building from the city’s PLUTO database.

Owner (as listed by the city)
247 AVENUE U PARTNERS LLCThe owner name on the city’s tax records. It can lag behind recent sales and is often an LLC.
Building class
K7 – Store building (subtype K7)The Department of Finance’s category for what kind of building this is.
Land use
Commercial & officeCity Planning’s broad category of how the lot is used.
Year built
1931Often an estimate for older buildings. Major alteration recorded: 1998, 2011.
Floors
2
Units
0 residential / 1 totalResidential units are apartments; total includes stores and offices.
Buildings on lot
1
Lot size
3,240 sq ft (19.75 ft × 100 ft)
Building floor area
6,038 sq ft (incl. 6,038 sq ft commercial)
Zoning
R5B, C2-3The zoning district sets what can be built and used here. Residential district; the overlay (C1/C2…) allows local retail on residential blocks.
Built vs. allowed density (FAR)
1.86 built / 1.50 max residentialFloor Area Ratio = building floor area ÷ lot area. If built FAR is below the maximum, zoning may allow more floor area (other rules apply).
Identifiers
BBL 3071010125 (Borough 3, Block 7101, Lot 125) · BIN 3191333BBL identifies the tax lot; BIN identifies each building (from DOB/HPD/footprint records).

Source: PLUTO (Dept. of City Planning) — city dataset updated 2026-08-24; data as of 2026-11-02; Building Footprints — city dataset updated 2026-10-25; data as of 2026-11-01

Tax assessment

How the Department of Finance values this lot for property tax.

Market value (tax year 2027, final roll)
$2,316,000The Department of Finance’s estimate of value for tax purposes. It is not an appraisal and is often far from the sale price.
Assessed value
$1,042,200The portion of market value that taxes are calculated on (capped by law for small homes).
Taxable value (final)
$997,740Assessed value minus any exemptions.
Tax class
Tax class 4 – commercial / industrial
Tax yearRollMarket valueAssessed valueTax class
2027Final$2,316,000$1,042,2004
2026Final$2,288,000$1,029,6004
2025Final$2,315,000$1,041,7504

Source: DOF Property Valuation and Assessment Data — city dataset updated 2026-09-14; data as of 2026-11-02

Sales & deed history 4

Deeds recorded with the City Register (ACRIS). A deed transfers ownership. A $0 or very low price usually means a transfer between related parties, an estate, or a refinance-related transfer, not a market sale. This is not a title search; mortgages, liens and other documents are not shown.

DateTypePriceSeller (grantor)Buyer (grantee)Doc ID
2010-11-03DEED$1,285,000Manna, Louisa; Manna, A/K/A Louise247 Avenue U Partners Llc2010111200909001
1990-10-15DEED$0 / not statedManna, SalvatoreManna, Louisa; Manna, SalvatoreFT_3970001580097
1980-02-11DEED$0 / not stated247 Ave U Realty CorpManna SalvatoreBK_8030114001513
1979-07-02DEED$0 / not statedBaratta Emil C247 Avenue U Realty CorpBK_7930108300219

Source: ACRIS Real Property Master — city dataset updated 2026-10-08; data as of 2026-11-02; ACRIS Real Property Legals — city dataset updated 2026-10-08; data as of 2026-11-02; ACRIS Real Property Parties — city dataset updated 2026-10-08; data as of 2026-11-02

DOB job filings 0 open of 8

A “job” is an application to the Department of Buildings to do construction work. A job marked Permitted, not signed off had a work permit issued but the city has no record of final sign-off (inspection/completion). Old jobs left in this state are common and appear in buyer and lender due diligence; the work may or may not have been done.

StatusJob #TypeFiledEst. cost
Not open
SIGNED OFF · 2011-11-17
320286800
BIS
A3 – Minor alteration (one type of work)2011-03-25$3,000
Not open
SIGNED OFF · 2011-11-17
320286784
BIS
A3 – Minor alteration (one type of work)2011-03-25$3,000
Not open
SIGNED OFF · 2011-11-17
320286819
BIS
A3 – Minor alteration (one type of work)2011-03-25$3,000
Not open
SIGNED OFF · 2011-11-17
320286793
BIS
A3 – Minor alteration (one type of work)2011-03-25$3,000
Not open
SIGNED OFF · 2012-01-27
320277419
BIS
A3 – Minor alteration (one type of work)2011-03-08—
Not open
SIGNED OFF · 2011-11-15
320260748
BIS
A3 – Minor alteration (one type of work)2011-01-11—
Not open
SIGNED OFF · 2013-05-22
320258635
BIS
A2 – Alteration with multiple work types (no change to use/occupancy)2011-01-07$12,300
Not open
SIGNED OFF · 2013-06-07
320235143
BIS
A1 – Major alteration (changes use, egress or occupancy)2010-11-04$582,888

Source: DOB NOW: Build – Job Application Filings — city dataset updated 2026-11-01; data as of 2026-11-02; DOB Job Application Filings (BIS) — city dataset updated 2026-10-30; data as of 2026-10-31

Work permits 13

Individual permits issued under DOB jobs (one job can have several permits, e.g. plumbing and construction). Permit expiration alone does not mean the job was completed or signed off.

IssuedExpiresJob #WorkPermit status
2011-04-122011-11-01320286793
BIS
Alteration / Other / general constructionISSUED (initial)
2011-04-122011-11-01320286784
BIS
Alteration / Other / general constructionISSUED (initial)
2011-04-122012-04-11320286837
BIS
SignISSUED (initial)
2011-04-122011-11-01320286819
BIS
Alteration / Other / general constructionISSUED (initial)
2011-04-122011-11-01320286800
BIS
Alteration / Other / general constructionISSUED (initial)
2011-04-122012-04-11320286846
BIS
SignISSUED (initial)
2011-04-122012-04-11320286828
BIS
SignISSUED (initial)
2011-03-082012-03-07320277419
BIS
Construction equipment (scaffold, fence, shed) / Construction equipmentISSUED (initial)
2011-02-182012-02-18320235143
BIS
Plumbing / PlumbingISSUED (initial)
2011-02-152012-02-10320235143
BIS
AlterationISSUED (renewal)
2011-02-152012-02-10320260748
BIS
Construction equipment (scaffold, fence, shed) / Construction equipmentISSUED (renewal)
2011-02-012011-02-20320235143
BIS
AlterationISSUED (initial)

Showing 12 of 13 records. The API and the source dataset have the full list.

Source: DOB NOW: Build – Approved Permits — city dataset updated 2026-11-02; data as of 2026-11-02; DOB Permit Issuance (BIS) — city dataset updated 2026-10-31; data as of 2026-10-31

DOB violations 2 active of 19

Violations issued by the Department of Buildings for building-code or zoning conditions. Active means DOB has not recorded the violation as resolved or dismissed. Many active DOB violations are old (e.g. elevator or boiler inspection paperwork).

StatusIssuedTypeDescriptionNumber
Active
V-DOB VIOLATION - ACTIVE
1993-08-16LL6291-LOCAL LAW 62/91 - BOILERS BOILER REQUIREDV081693LL629133461
Active
V-DOB VIOLATION - ACTIVE
1993-08-16LL6291-LOCAL LAW 62/91 - BOILERS BOILER REQUIREDV081693LL629133462
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
2015-03-03LBLVIO-LOW PRESSURE BOILER BOILER REQUIREDVIOLATION ISSUED FOR FAILURE TO FILE ANNUAL BOILER 2013 INSPECTION REPORTV*030315LBLVIO07906
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
2014-05-15LBLVIO-LOW PRESSURE BOILER BOILER REQUIREDVIOLATION ISSUED FOR FAILURE TO FILE ANNUAL BOILER 2012 INSPECTION REPORTV*051514LBLVIO11067
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
2013-03-01LBLVIO-LOW PRESSURE BOILER BOILER REQUIREDVIOLATION ISSUED FOR FAILURE TO FILE ANNUAL BOILER 2011 INSPECTION REPORTV*030113LBLVIO11547
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
2011-12-13LBLVIO-LOW PRESSURE BOILER BOILER REQUIREDVIOLATION ISSUED FOR FAILURE TO FILE ANNUAL BOILER 2010 INSPECTION REPORTV*121311LBLVIO15197
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
2009-12-31LBLVIO-LOW PRESSURE BOILER BOILER REQUIREDV*123109LBLVIO17631
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
2009-01-01LL6291-LOCAL LAW 62/91 - BOILERS BOILER REQUIREDV*010109LL629116892
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
2007-01-19LL6291-LOCAL LAW 62/91 - BOILERS BOILER REQUIREDV*011907LL629117228
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
1999-03-16LL6291-LOCAL LAW 62/91 - BOILERS BOILER REQUIREDV*031699LL629123949
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
1998-05-04LL6291-LOCAL LAW 62/91 - BOILERS BOILER REQUIREDV*050498LL629125204
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
1998-05-04LL6291-LOCAL LAW 62/91 - BOILERS BOILER REQUIREDV*050498LL629125205
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
1997-09-16LL6291-LOCAL LAW 62/91 - BOILERS BOILER REQUIREDV*091697LL6291247376
Resolved/dismissed
V*-DOB VIOLATION - DISMISSED
1997-09-16LL6291-LOCAL LAW 62/91 - BOILERS BOILER REQUIREDV*091697LL6291247377
Resolved/dismissed
VP*-VIOLATION UNSERVED ECB- DISMISSED
1994-12-15C-CONSTRUCTION OTHER OPTIONALVP*121594C11T1

Showing 15 of 19 records. The API and the source dataset have the full list.

Source: DOB Violations — city dataset updated 2026-11-02; data as of 2026-11-02

ECB violations (DOB) 0 active of 0

DOB violations that go to a hearing at OATH (formerly the Environmental Control Board) and can carry fines. Active or Resolved follows the DOB violation status field. The hearing status is about the hearing and its penalty: written off means the city stopped collecting the fine, not that the condition was corrected. A balance due is a fine the city says is unpaid.

No records found in this dataset for this lot.

Source: DOB ECB Violations — city dataset updated 2026-10-31; data as of 2026-11-02

OATH tickets (all agencies) 0 unpaid of 23

Summonses heard at the Office of Administrative Trials and Hearings, from agencies like Sanitation, Buildings, Fire and Health, linked to this lot’s block and lot. Default means the respondent did not appear at the hearing, which typically results in the maximum penalty. Tickets may be issued to tenants or businesses at the address, not just the owner. DOB ECB tickets appear here too.

StatusDateAgencyChargeRespondentImposed / paid / balanceTicket #
No balance due
PAID IN FULL
2025-01-15Sanitation OthersIMPROPER RECEPTACLE NON-RESIDENTIAL 1STNORTHFIELD BANK$50 / $50 / $0048876364R
No balance due
PAID IN FULL
2016-07-28Sanitation DeptPOSTING OF SIGN PERMIT, WASTE REMOVALNORTHFIELD BANK$100 / $100 / —041897901L
No balance due
PAID IN FULL
2014-09-29Sanitation DeptFAILURE TO CLEAN 18 INCHES INTO STREETNORTHFIELD BANK$100 / $100 / —041895420L
No balance due
PAID IN FULL
2013-08-05Dos - Enforcement AgentsDIRTY SIDEWALK DIRTY AREANORTHFIELD BANK$100 / $100 / —041848017J
No balance due
PAID IN FULL · IN VIOLATION
2012-02-23Dos - Enforcement AgentsIMPROPER USE OF DSNY LITTER BASKETROBLES$100 / $100 / —042183764X
No balance due Default
PAID IN FULL · DEFAULTED
2012-01-04Dept Of TransportationTEMPORARY PAVEMENT NOT FLUSH WITH SURROUNDING AREAKEYSPAN ENERGY DELIVERY N Y C$530 / $500 / —0180020950
No balance due Default
PAID IN FULL · DEFAULT
2011-08-31FAILED TO RETURN METER PERMITEASY STREET PLUMBING INC$1,000 / $350 / —0176379969
No balance due
PAID IN FULL
2010-09-16Sanitation OthersDIRTY SIDEWALK DIRTY AREASALVATORE$100 / $100 / —0173678551
No balance due Default
PAID IN FULL · DEFAULTED
2010-07-30Sanitation OthersDIRTY SIDEWALK DIRTY AREAN A$300 / $300 / —0173818710
No balance due Default
PAID IN FULL · DEFAULTED
2010-07-19Sanitation OthersFAILURE TO CLEAN 18 INCHES INTO STREETMANNA$300 / $300 / —0171872040
No balance due Default
PAID IN FULL · DEFAULTED
2010-07-08Sanitation OthersDIRTY SIDEWALK DIRTY AREAMANNA$300 / $300 / —0173818572
No balance due Default
PAID IN FULL · DEFAULTED
2010-05-19Dos - Enforcement AgentsSTORAGE OF RECEPTACLESSALVATORE$300 / $302 / —041862471K

Showing 12 of 23 records. The API and the source dataset have the full list.

Source: OATH Hearings Division Case Status — city dataset updated 2026-11-02; data as of 2026-11-02

HPD registration & contacts

Owners of most rental buildings must register with the Department of Housing Preservation and Development each year and list an owner and managing agent.

No HPD registration found. Registration is required for buildings with 3 or more apartments (and for 1–2 family homes where neither the owner nor family lives there).

Source: HPD Multiple Dwelling Registrations — city dataset updated 2026-10-28; data as of 2026-11-02; HPD Registration Contacts — city dataset updated 2026-10-28; data as of 2026-11-02

HPD housing-code violations 0 open of 0

Violations HPD inspectors issued for conditions in residential buildings (heat, leaks, mold, pests, lead paint, etc.). Class letters show how serious: Class A – non-hazardous (HPD gives 90 days to correct); Class B – hazardous (30 days to correct); Class C – immediately hazardous (24 hours to correct for most conditions); Class I – information / order (e.g. orders to register, lead or other administrative orders). Open means HPD has not recorded the condition as corrected.

No records found in this dataset for this lot.

Source: HPD Housing Maintenance Code Violations — city dataset updated 2026-11-02; data as of 2026-11-02

HPD complaints 0

Complaints tenants or others made to HPD (usually via 311) about housing conditions, from 2019 onward. A complaint is not a violation; HPD may inspect and issue one.

No records found in this dataset for this lot.

Source: HPD Housing Maintenance Code Complaints and Problems — city dataset updated 2026-11-02; data as of 2026-11-02

311 requests (last 12 months) 3

Recent 311 service requests the city geocoded to this lot: noise, illegal parking, heat, sanitation and more. Anyone can file them, so they describe activity at or near the address, not necessarily the building itself.

OpenedAgencyComplaintStatusClosed
2026-04-22DSNYDirty Condition – TrashClosed2026-04-24
2026-04-15DSNYLitter Basket Request – New BasketClosed2026-04-17
2026-03-26DSNYDirty Condition – Dirt or GravelClosed2026-03-27

Source: 311 Service Requests from 2020 to Present — city dataset updated 2026-11-02; data as of 2026-11-02

Nearby properties

On Ave U

Same tax block (7101)

All properties on Ave U, Brooklyn · All of Brooklyn 11223 (Gravesend (East)-Homecrest)

Open-item counts as of October 31, 2026; each section lists its own dataset date. Machine-readable: JSON API · Markdown · Plain text · API & MCP docs