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

NYC Property Factsfree public-records reference

42-04 Berrian Boulevard, Queens, NY 11105

BBL 4007910032 (Borough 4, Block 791, Lot 32) · BIN 4617264 · Last updated:

Also recorded in city data as: 42-02 Berrian Blvd

Summary · as of November 5, 2026

42-04 Berrian Boulevard (Queens, NY 11105; tax lot BBL 4007910032) is a warehouse (building class E2: warehouse (subtype E2)), built around 2009, on a 10,001 sq ft lot zoned M1-1. City tax records list the owner as 42 BERRIAN LLC; the most recent deed with a stated price is dated June 19, 2006 at $712,500 (per ACRIS). The Department of Finance's final market value for tax year 2027 is $2,350,000. As of November 5, 2026, NYC Open Data shows one DOB job with a permit issued but no sign-off. 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
42 BERRIAN LLC
Building class
E2 · Warehouse
Year built · units
2009 · 0 res.
Lot area · zoning
10,001 sq ft · M1-1
Market value (DOF)
$2,350,000 FY2027
Last priced deed
$712,500 · 2006-06-19
BBL
4007910032
BIN
4617264

How to cite: NYC Property Facts, “42-04 Berrian Boulevard, Queens, NY 11105 (BBL 4007910032)”, data as of 2026-11-05, https://nycpropertyfacts.com/ny/queens/42-04-berrian-boulevard-4007910032. 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)
42 BERRIAN LLCThe owner name on the city’s tax records. It can lag behind recent sales and is often an LLC.
Building class
E2 – Warehouse (subtype E2)The Department of Finance’s category for what kind of building this is.
Land use
Industrial & manufacturingCity Planning’s broad category of how the lot is used.
Year built
2009Often an estimate for older buildings.
Floors
2
Units
0 residential / 3 totalResidential units are apartments; total includes stores and offices.
Buildings on lot
1
Lot size
10,001 sq ft (100.01 ft × 100 ft)
Building floor area
16,234 sq ft (incl. 6,234 sq ft commercial)
Zoning
M1-1The zoning district sets what can be built and used here. Manufacturing district.
Built vs. allowed density (FAR)
1.62 built / 0.00 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 4007910032 (Borough 4, Block 791, Lot 32) · BIN 4617264BBL 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-05; 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,350,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,057,500The portion of market value that taxes are calculated on (capped by law for small homes).
Taxable value (final)
$961,920Assessed value minus any exemptions.
Tax class
Tax class 4 – commercial / industrial
Tax yearRollMarket valueAssessed valueTax class
2027Final$2,350,000$1,057,5004
2026Final$2,289,000$1,030,0504
2025Final$2,189,000$985,0504

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

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
2011-05-20DEED$0 / not statedRestivo, Charles Sr.; Restivo, Charles42 Berrian Llc2011080101039001
2006-06-19DEEDO$712,500Estate Of Vincent Piraneo; Restivo, Charles; Marie Piraneo, As ExecutrixRestivo, Charles2006062701688001
1977-08-10DEED$0 / not stated
one deed covering 2 lots; price is for all of them
Mintz Charlotte (Partner); Mintz Lee R (Partner); Mint FactorsVincent Piraneo; Charles RestivoBK_7740100601860
1977-06-17DEED$0 / not stated
one deed covering 2 lots; price is for all of them
Hammer Jon H (Referee); Barnaby Concrete Corporation Def EtalMint FactorsBK_7740099400235

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

DOB job filings 1 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
Permitted, not signed off
PERMIT ISSUED - ENTIRE JOB/WORK · 2022-04-12
421523453
BIS
A2 – Alteration with multiple work types (no change to use/occupancy)2017-07-12$252,000
Not open
PLAN EXAM - DISAPPROVED · 2017-09-28
421555819
BIS
A1 – Major alteration (changes use, egress or occupancy)2017-09-19$5,000
Not open
SIGNED OFF · 2016-12-14
421351067
BIS
A3 – Minor alteration (one type of work)2016-07-20—
Not open
COMPLETED · 2012-12-07
420792486
BIS
SI2012-12-07—
Not open
SIGNED OFF · 2011-11-30
420126401
BIS
A2 – Alteration with multiple work types (no change to use/occupancy)2010-01-11$33,500
Not open
SIGNED OFF · 2016-10-25
410140217
BIS
A3 – Minor alteration (one type of work)2008-07-21—
Not open
SIGNED OFF · 2017-03-14
410128277
BIS
NB – New building2008-06-23—
Not open
SIGNED OFF · 2008-12-01
402680194
BIS
DM – Demolition2008-05-20—

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

Work permits 21

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
2022-04-122023-04-12421523453
BIS
Equipment work / SprinklerISSUED (renewal)
2020-01-212021-01-20421523453
BIS
Plumbing / PlumbingISSUED (renewal)
2020-01-212021-01-20421523453
BIS
Equipment work / SprinklerISSUED (renewal)
2019-01-292020-01-29421523453
BIS
Plumbing / PlumbingISSUED (renewal)
2019-01-292020-01-29421523453
BIS
Equipment work / SprinklerISSUED (renewal)
2018-02-122019-02-12421523453
BIS
Plumbing / PlumbingISSUED (initial)
2018-02-122019-02-12421523453
BIS
Equipment work / SprinklerISSUED (initial)
2018-02-082018-06-11421523453
BIS
Equipment work / Other / general constructionISSUED (initial)
2018-02-082018-06-11421523453
BIS
Equipment work / Mechanical/HVACISSUED (initial)
2016-07-292017-03-01421351067
BIS
Alteration / Curb cutISSUED (initial)
2010-06-102011-06-10410128277
BIS
Plumbing / PlumbingISSUED (renewal)
2010-03-092010-09-29410128277
BIS
Construction equipment (scaffold, fence, shed) / Construction equipmentISSUED (renewal)

Showing 12 of 21 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-05; DOB Permit Issuance (BIS) — city dataset updated 2026-10-31; data as of 2026-10-31

DOB violations 0 active of 1

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
Resolved/dismissed
V*-DOB VIOLATION - Resolved
2011-09-15E-ELEVATOR ELEVATORREQUIREDV*091511E9027/397262

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

ECB violations (DOB) 0 active of 2

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.

StatusIssuedSeverityWhat it was forPenalty / paid / balanceECB #
Resolved
Hearing: ADMIT/IN-VIO · Certification: CERTIFICATE ACCEPTED
2016-11-14CLASS - 2FAILURE TO PROVIDE APPROVED/ACCEPTED PLANS AT JOB SITE AT TIME OF INSPECTION. ON A LOC REQUEST JOB # ALT 2 AT THE TIME OF INSPECTION. NO APPRVOED PLANS WAS PROVIDED AT STIE FOR AUDIT INSPECTION.RMDY: PROVIDE AP$530 / $530 / $035112571H
Resolved
Hearing: IN VIOLATION · Certification: CERTIFICATE ACCEPTED
2018-03-21CLASS - 1C/U 5A10,40R9,41B10.(5A10)DOOR ZONE RESTRICTOR HAS BEEN TAMPERED WITH DISABLED & RENDERED INOPERATIVE.THIS IS A SAFETY DEVICE TO ENSURE ELEVATOR PASSENGERS SAFETY.REPAIR RESTRICTOR & CONTACT NYCDOB @ EIR@BUILDI$1,250 / $1,250 / $038262301K

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

OATH tickets (all agencies) 0 unpaid of 22

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 Default
PAID IN FULL · DEFAULTED
2024-04-27Fire Department Of NycFIRE PROTECTION SYSTEMS:FAIL TO PREVENT UNNECESSARY UNWARRANTED ALARMS42 BERRIAN LLC$5,000 / $5,000 / $0012149901X
No balance due Default
PAID IN FULL · DEFAULTED
2024-04-02Fire Department Of NycFIRE PROTECTION SYSTEMS:FAIL TO PREVENT UNNECESSARY UNWARRANTED ALARMS42 BERRIAN LLC$1,000 / $1,017 / $0012148935J
No balance due
PAID IN FULL · IN VIOLATION
2019-09-04Fire Department Of NycAFFIDAVITS, DESIGN INSTALLATION DOCUMENTS, AND OTHER DOCUMENTATIONRESTANI CONSTRUCTION$600 / $1,258 / $-629011694065R
No balance due
PAID IN FULL · IN VIOLATION
2018-12-14Fire Department Of NycFIRE PROTECTION SYSTEMS:FAIL TO PREVENT UNNECESSARY UNWARRANTED ALARMS42 BERRIAN LLC$935 / $935 / $0012086591Y
No balance due
PAID IN FULL · IN VIOLATION
2018-07-21Fire Department Of NycFIRE PROTECTION SYSTEMS:FAIL TO PREVENT UNNECESSARY UNWARRANTED ALARMS42 BERRIAN LLC$935 / $935 / $0012081415M
No balance due
HEARING COMPLETED · DISMISSED
2018-06-15Fire Department Of NycAFFIDAVITS, DESIGN INSTALLATION DOCUMENTS, AND OTHER DOCUMENTATIONRESTANI CONSTRUCTION CORP.$0 / $0 / $0011614523M
No balance due Default
PAID IN FULL · DEFAULTED
2018-06-05Fire Department Of NycFIRE PROTECTION SYSTEMS:FAIL TO PREVENT UNNECESSARY UNWARRANTED ALARMS42 BERRIAN LLC$5,000 / $5,409 / $0012076743P
No balance due
HEARING COMPLETED · IN VIOLATION
2018-03-22Fire Department Of NycFIRE PROTECTION SYSTEMS:FAIL TO PREVENT UNNECESSARY UNWARRANTED ALARMS42 BERRIAN LLC$0 / $0 / $0012074416Z
No balance due
PAID IN FULL · IN VIOLATION
2018-03-21Dept. Of BuildingsFAILURE TO MAINTAIN ELEVATOR OR CONVEYING SYSTEM42 BERRIAN LLC$1,250 / $1,250 / $0038262301K
No balance due
PAID IN FULL
2016-11-14Dept. Of BuildingsWORK DOES NOT CONFORM TO APPROVED CONSTRUCTION DOCUMENTS AMENDMENTS42 BERRIAN LLC$530 / $530 / —035112571H
No balance due
PAID IN FULL · IN VIOLATION
2015-11-30Env ProtectFAILED TO SUBMIT AN ANNUAL TEST REPORT FOR A BACKFLOW PREVENTER42 BERRIAN LLC$50 / $50 / —0189351461
No balance due
PAID IN FULL · IN VIOLATION
2015-11-30Env ProtectFAILED TO SUBMIT AN ANNUAL TEST REPORT FOR A BACKFLOW PREVENTER42 BERRIAN LLC$50 / $50 / —0189351452

Showing 12 of 22 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-05

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-11-04; data as of 2026-11-05; HPD Registration Contacts — city dataset updated 2026-11-04; data as of 2026-11-05

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-05; data as of 2026-11-05

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-05; data as of 2026-11-05

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-10-25NYPDNoise - Vehicle – Car/Truck MusicClosed2026-10-26
2026-09-23DCWPConsumer Complaint – Tow Truck CompanyClosed2026-10-24
2025-12-02DSNYDerelict Vehicles – Derelict VehiclesClosed2025-12-03

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

Nearby properties

On Berrian Blvd

Same tax block (791)

All properties on Berrian Blvd, Queens · All of Queens 11105

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