You need to enable JavaScript to use this site.647 Sheffield Avenue, Brooklyn Report | Augrented NYC Apartment Ratings & Reviews
Building and Landlord Data Analysis Report

647 Sheffield Avenue, Brooklyn, NY 11207

7
DOB Complaints
7
311 Housing Calls
1
Housing Violations
4
Permits

Risk Assessment

96
Low Risk

This building shows minimal signs of maintenance issues based on our analysis.

Our AI predicts there is a 96% chance of no major maintenance issues.
Augrented Insights Report for 647 Sheffield Avenue

The 8-unit, 4-story residential building at 647 Sheffield Avenue in East New York, owned by Gurwinder Singh, was constructed in 2018 and has experienced several notable issues since its completion. Most recently, in mid-2024, there were multiple complaints regarding unsanitary conditions and a heavy water leak, though inspectors were unable to gain access to verify these issues.

Prior to this, in 2023, there were violations related to door/window issues that required attention. During the building's early years, significant construction-related concerns were documented, particularly in late 2018 through 2019, including multiple violations for inadequate housekeeping, failure to provide proper site safety measures, and issues with construction debris and debris management, resulting in several Environmental Control Board (ECB) violations and penalties totaling $3,750.

The building's rodent inspection history shows both passing and failing results between 2011 and 2019, with the last inspection in 2019 passing for compliance. The property has maintained a bedbug-free record according to three consecutive reporting periods from 2021 through 2023, with no reported infested or re-infested units. While the building's more recent history shows fewer violations, the repeated inability of inspectors to verify reported conditions in 2024 raises concerns about potential ongoing maintenance issues.

Last updated: July 27, 2025
This report is created with AI and based on the most recent 10 data items in each category. Full reports with 50+ data points are available to subscribers.

647 Sheffield Avenue Report Contents

Download Full Report for 647 Sheffield Avenue

Sign up to download the full building report in PDF or Excel format

Sign Up for Free

647 Sheffield Avenue Building Overview

Renter Risk Rating

This building is in the riskiest 10% of buildings in East New York.

Building Characteristics

Total units 8
Year built 2018
Total area 6293 sq ft
Floors 4
Tax Abatements None
Building Class HEREAFTER ERECTED CLASS A
Preview of building report data and features

Unlock Complete Building History

Get access to comprehensive violation records, court cases, landlord portfolios, and detailed maintenance history for this building and thousands of others.

Full violation history
Landlord portfolios
Court case records
PDF/Excel reports
Sign Up for Free Access
No credit card required • Instant access

Key Building Statistics

7
DOB Complaints
Complaints filed with the Department of Buildings in the last 7 years.
1
Housing Violations
Class B & C housing maintenance code violations.
7
311 Housing Calls
Housing-related 311 service requests in the last 7 years.
0
Work Orders
Repair orders issued by city agencies.
19
ECB Violations
Environmental Control Board violations on record.
1
Evictions
Evictions executed by city marshalls.
2
Rodent Inspections
Rodent inspections conducted by DOHMH.
4
Building Permits
Permits issued by DOB in the last 7 years.

Map and Aerial View of 647 Sheffield Avenue

Street Map View

Loading street map...

Click and drag to explore the area
Satellite View

Loading satellite view...

Aerial view of the surrounding area

Reviews of 647 Sheffield Avenue

See what current and past tenants have to say

No reviews yet

Be the first to share your experience living at this property. Your review helps future tenants make informed decisions.

Rate your experience Share honest feedback Help other tenants

Share Your Experience

Help future tenants by leaving an honest review of this property

Login Required

You must be logged in to leave a review. Join our community and share your experience!

Login to Continue
Don't have an account? Sign up here

647 Sheffield Avenue Landlord Information

HPD Registration Contacts

Contact data is from NYC HPD building registration.

RoleNameAddress

Landlord Portfolio

Other NYC buildings registered to this landlord.

AddressUnitsCode ViolationsRisk Rating

Landlord Court Records

NYC housing court and civil court records. Name matching only; verify parties are actually the owners by reviewing the case files!

Date FiledCase TitleCourtLink
First five items shown. Sign up to see more.

647 Sheffield Avenue Rent Control Status

Year Built
Built after 1974
Units
More than 6 units
RGB Registration
Registered
Tax Abatement
None found
Year BuiltUnitsRGB RegistrationTax Abatement
After 1974 >6 units Registered None

Full Building Data for 647 Sheffield Avenue

Housing Maintenance Code Complaints

This table shows complaints to 311 related to potential NYC Housing Maintenance Code (HMC) for 647 Sheffield Avenue. These complaints are related to conditions such as lack of heat, hot water, mold, pests, and other habitability issues. Class B and C violations are the most serious and may indicate significant problems with building maintenance or safety.

Date ReceivedSttatus DateCategoryTypeStatus
2024-06-132024-07-16Water Leak-Heavy FlowEmergencyCLOSE
2024-06-132024-07-16Unsanitary Condition-PestsNon EmergencyCLOSE
2024-06-132024-07-16Unsanitary Condition-PestsNon EmergencyCLOSE
2024-06-132024-07-16Unsanitary Condition-PestsNon EmergencyCLOSE
2023-02-102023-09-23Appliance-RefrigeratorNon EmergencyCLOSE
First five items shown. Sign up to see more.

Housing Maintenance Code Violations

This table shows violations of the NYC Housing Maintenance Code (HMC) issued by HPD for 647 Sheffield Avenue. These violations are related to conditions such as lack of heat, hot water, mold, pests, and other habitability issues. Class B and C violations are the most serious and may indicate significant problems with building maintenance or safety.

Inspection DateClassStatusStatus DateApartmentNOV DescriptionCertified Date
2023-09-08CCloseNoneNone§ 27-2005, 27-2007, 27-2041.1 HMC, §238, § 309; § 107 (2) ( C) MDL AND 28 RCNY §25-171: REPLACE OR REPAIR THE SELF-CLOSING DOORS THAT IS MISSING OR DEFECTIVE ... , 1st STORY2023-09-28T00:00:00.000Z
2021-04-20ACloseNoneNone(A) § HMC:FILE ANNUAL BEDBUG REPORT IN ACCORDANCE WITH HPD RULE AS DESCRIBED ON THE BACK OF THIS NOTICE OF VIOLATION OR AS DESCRIBED ON HPDS WEBSITE, WWW.NYC.GOV\HPD, SEARCH BED BUGS.None
First five items shown. Sign up to see more.

311 Service Requests

Service requests made to 311 for 647 Sheffield Avenue. Data from NYC 311.

Created DateTypeDescriptionStatusAgencyResolution
2024-06-13 17:25UNSANITARY CONDITIONPESTSClosedHPD
2024-06-13 17:25WATER LEAKHEAVY FLOWClosedHPD
2024-06-13 17:25UNSANITARY CONDITIONPESTSClosedHPD
2024-06-13 17:25UNSANITARY CONDITIONPESTSClosedHPD
2023-06-18 09:39DOOR/WINDOWDOORClosedHPD
First five items shown. Sign up to see more.

DOB Complaints

Department of Buildings complaints regarding 647 Sheffield Avenue.

Complaint #FiledStatusCategoryInspection DateDisposition
36970952019-04-17CLOSEDConstruction: Contrary/Beyond Approved Plans/Permits2019-06-12No Violation Warranted For Complaint At Time Of Inspection (2019-06-12)
36833972019-01-19CLOSEDAfter Hours Work – Illegal2019-01-26No Violation Warranted For Complaint At Time Of Inspection (2019-01-26)
36743052018-11-05CLOSEDCSC: Low-Rise Tracking Complaint2018-11-13Stop Work Order Fully Rescinded (2018-11-13)
36743032018-11-05CLOSEDCSC: Low-Rise Tracking Complaint2018-12-05Stop Work Order Fully Rescinded (2018-12-07)
36670092018-09-12CLOSEDSustainability Enforcement Work Order2018-11-02No Violation Warranted For Complaint At Time Of Inspection (2018-11-02)
First five items shown. Sign up to see more.

DOB Violations

Department of Buildings violations regarding 647 Sheffield Avenue.

Date IssuedCategoryDescriptionStatusComments
2019-11-13V*-DOB VIOLATION - DISMISSEDFAILURE TO CERTIFY CORRECTION ON IMMEDIATELY HAZARDOUS (CLASS 1) ECB VIOLATIONRBG PAID INVOICE 621418982019-11-20
First five items shown. Sign up to see more.

Indoor Environment Complaints (DOHMH)

The table below shows indoor environment complaints received regarding the conditions at 647 Sheffield Avenue. The information includes the date, type, description, and status of each complaint. The data is sourced from DOHMH/311.

DateTypeDescriptionStatus
First five items shown. Sign up to see more.

Bedbug Infestations

The table below shows the bedbug reports filed by the landlord for 647 Sheffield Avenue. The information includes the file date, infested units, eradicated units, re-infested units, filing start date, and filing end date. The data is sourced from DOHMH. Landlords are required to file these reports; missing data may indicate non-compliance.

File DateInfested UnitsEradicated UnitsRe-infested UnitsFiling Start DateFiling End Date
2023-12-270002022-11-012023-10-31
2022-12-210002021-11-012022-10-31
2022-01-250002020-11-012021-10-31
2021-07-250002019-11-012020-10-31
First five items shown. Sign up to see more.

Rodent Inspections

Recent rodent inspection results for 647 Sheffield Avenue. Data from NYC DOHMH.

DateTypeResult
2019-10-30CompliancePassed
2019-09-25InitialFailed for Other R
2017-05-01InitialPassed
2012-10-02CompliancePassed
2012-08-02InitialFailed for Other R
First five items shown. Sign up to see more.

HPD Litigation Explanation

The table below shows the HPD litigation records for 647 Sheffield Avenue. The information includes the open date, case type, status, judgement, penalty and whether harassment was found. The data is sourced from HPD.

Source: HPD
Open DateCase TypeStatusJudgementPenaltyHarassment found
Sign in to view this data.

OATH Cases Explanation

The table below shows the Office of Administrative Trials and Hearings cases for 647 Sheffield Avenue. The information includes the date, agency, respondent, charge, result, penalty, and status. The data is sourced from OATH.

Source: Office of Administrative Trials and Hearings (OATH)
DateAgencyRespondentChargeResultPenaltyStatus
Sign in to view this data.

ECB Violations

Environmental Control Board violations for 647 Sheffield Avenue. Data from ECB.

DateNumberRespondentDescriptionStatusPenaltyBalance Due
2019-08-2035444659NIDEA BUILDERS LLCFAILURE TO MAINTAIN ADEUQATE HOUSEKEEPING PER SECTION REQUIREMENT AS NOTED AT TIME OF INSPECTION IT WAS OBSERVED THAT A LARGE AMOUNTS OF DEBRIS ON THE EXPOSURE # 1 AND 3 AND ON THE 3RD FLOOR LARGE AMOUNTS TO OFRESOLVE0.00.0
2019-04-2035420406ZIDEA BIULDERS LLCJOB SITE FENCE NOT CONSTRUCTED OR MAINTAINED PURSUANT TO SUBSECTION. NOTED: AT TIME OF INSPECTION I OBSERVED FENCE IN PLACE THAT NOT SOLID PLYWOOD. THE PANEL IS PARTICLE BOARD W/EASILY INJURED PEOPLE IT GET INTRESOLVE0.00.0
2018-11-0235368035NHIMMAT SINGHCONSTRUCTION SUPERINTENDENT FAILED TO PERFORM DUTIES PER CODE. AT THE TIME OF INSPECTION IT WAS OBSERVED THAT THE CONSTRUCTION SUPERINTENDENT FAILED TO PERFORM HIS DUTIES BY NOT HAVING A COMPETENT PERSON WHILERESOLVE2500.00.0
2018-11-0235368034LIDEAL BUILDERS LLCFAILURE TO MAINTAIN ADEQUATE HOUSEKEEPING PER SECTION REQUIREMENTS. ATTHE TIME OF INSPECTION IT WAS OBSERVED THAT THE CONTRACTORS HAD AN EXCESSIVE AMOUNT OF CONSTRUCTION DEBRIS AT EXP#1&3 CREATING A HAZADOUSRESOLVE625.00.0
2018-11-0235368037RIDEAL BUILDERS LLCSEC. 3309.1 FAILURE TO PROTECT OR ADEQUATELY PROTECT ADJOINING PROPERTIES DURING CONSTRUCTION OR DEMOLITION OPERATION. AT THE TIME OF INSPECTION IT WAS OBSERVED THAT THE CONTRACTORS FAILED TO INSTALL ANY ROOFRESOLVE625.00.0
First five items shown. Sign up to see more.

Alternative Enforcement Program (AEP) Explanation

The table below shows the Alternative Enforcement Program (AEP) records for 647 Sheffield Avenue. The information includes the start date, start violations, discharge date, and status. The data is sourced from HPD.

Source: Department of Housing Preservation and Development (HPD)
Start DateStart ViolationsDischarge DateStatus
Sign in to view this data.

Vacate Orders Explanation

The table below shows the vacate orders for 647 Sheffield Avenue. The information includes the effective date, rescinded date, reason, type, and units. The data is sourced from DOB.

Source: Department of Buildings (DOB)
Effective DateRescinded DateReasonTypeUnits
Sign in to view this data.

Work Orders Explanation

The table below shows the work orders for 647 Sheffield Avenue. The information includes the date created, type, description, and charge. The data is sourced from HPD.

Source: Department of Housing Preservation and Development (HPD)
Date CreatedTypeDescriptionCharge
Sign in to view this data.

Liens Explanation

The table below shows tax and water liens for 647 Sheffield Avenue. Information includes tax class, month, water only flag, amount, and cycle. Data is sourced from NYC Department of Finance.

Source: NYC Department of Finance
Tax ClassMonthWater OnlyAmountCycle
Sign in to view this data.

Sign in to view this data.
Case NumberDateTypeStatusDetails

Sales Records

Sales transactions for 647 Sheffield Avenue. Data includes sale date, price, buyer, and seller.

DatePriceBuyerSeller

Asbestos Records

Asbestos abatement filings and records for 647 Sheffield Avenue. Data includes filing date, type, and status.

Start DateEnd DateStatusProcedureFloor

Fire Violations

Violations issued by the Fire Department for this property.

Violation NumberDateDescriptionStatus
Sign in to view this data.

Fire Inspections

Fire Department inspection records for this property.

DateTypeResult
Sign in to view this data.

Fire Certificates

Fire safety certificates for this property.

TypeIssue DateExpiration
Sign in to view this data.

Water Connections

Water connection permits and records for 647 Sheffield Avenue. Data includes connection type, date, and status.

MaterialRecord Type

Elevator Permits

Elevator permit records for 647 Sheffield Avenue. Data includes permit type, issue date, and status.

TypeIssue DateStatus

Landmark Violations

Landmark preservation violations for 647 Sheffield Avenue. Data includes violation date, type, and status.

DateTypeStatus

Planning Projects

City Planning (ZAP) project applications for this building. Data includes project ID, status, borough, and lot/block information.

Project IDStatusBoroughBlockLot
Sign in to view this data.

Building Permits

Department of Buildings issued building permits for this property. This includes permits for construction, alteration, and demolition work. Data includes permit type, job number, status, and issue date.

Permit TypeJob NumberStatusIssue Date

Electrical Permits

Department of Buildings issued electrical permits for this property. This includes permits for electrical work, installations, and modifications. Data includes permit type, job number, status, and issue date.

Permit TypeJob NumberStatusIssue Date

How 647 Sheffield Avenue Compares

Loading comparison data...

Compare with buildings in East New York:

0

Comparable Buildings

0

Better Rated

0

Worse Rated

Preview of building report data and features

Unlock Complete Building History

Get access to comprehensive violation records, court cases, landlord portfolios, and detailed maintenance history for this building and thousands of others.

Full violation history
Landlord portfolios
Court case records
PDF/Excel reports
Sign Up for Free Access
No credit card required • Instant access

Nearby Buildings

Search More Buildings in East New York