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

197 Columbia Street, Brooklyn, NY 11231

0
DOB Complaints
3
311 Housing Calls
0
Housing Violations
0
Permits

Risk Assessment

97
Low Risk

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

Our AI predicts there is a 97% chance of no major maintenance issues.
Augrented Insights Report for 197 Columbia Street

The three-story, two-family house at 197 Columbia Street, owned by Humberto Lopes, was constructed in 1931 and has experienced several noteworthy maintenance incidents over the past several years. In late September 2019, the building faced multiple rodent-related complaints, with three separate incidents reported to the Department of Health and Mental Hygiene (DOHMH) between September 21 and September 29, all concerning conditions that were attracting rodents.

While all these complaints were officially closed, it is notable that there was no documented resolution provided in the records. However, following these complaints, a DOHMH inspection conducted on October 4, 2019, was successful, with the building passing the rodent inspection.

More recently, in December 2023, the building filed its bedbug report for the period between November 2022 and October 2023, showing no infested dwelling units, no eradicated units, and no re-infestation cases, suggesting effective pest management practices during this period. The bedbug report indicates that for the specified reporting period, the building experienced no infestations, which is a positive sign regarding the current pest control status of the property.

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.

197 Columbia Street Report Contents

Download Full Report for 197 Columbia Street

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

Sign Up for Free

197 Columbia Street Building Overview

Renter Risk Rating

This building is in the riskiest 10% of buildings in Columbia St.

Building Characteristics

Total units 2
Year built 1931
Total area 3150 sq ft
Floors 3
Tax Abatements None
Building Class 2 FAMILY HOUSE
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

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

Map and Aerial View of 197 Columbia Street

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 197 Columbia Street

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

197 Columbia Street 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.

197 Columbia Street Rent Control Status

Year Built
Built before 1974
Units
Less than 6 units
RGB Registration
Not registered
Tax Abatement
None found
Year BuiltUnitsRGB RegistrationTax Abatement
Before 1974 <6 units Not registered None

Full Building Data for 197 Columbia Street

Housing Maintenance Code Complaints

This table shows complaints to 311 related to potential NYC Housing Maintenance Code (HMC) for 197 Columbia Street. 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
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 197 Columbia Street. 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
First five items shown. Sign up to see more.

311 Service Requests

Service requests made to 311 for 197 Columbia Street. Data from NYC 311.

Created DateTypeDescriptionStatusAgencyResolution
2019-09-29 14:02RodentCondition Attracting RodentsClosedDOHMH
2019-09-24 09:29RodentCondition Attracting RodentsClosedDOHMH
2019-09-21 14:37RodentCondition Attracting RodentsClosedDOHMH
First five items shown. Sign up to see more.

DOB Complaints

Department of Buildings complaints regarding 197 Columbia Street.

Complaint #FiledStatusCategoryInspection DateDisposition
First five items shown. Sign up to see more.

DOB Violations

Department of Buildings violations regarding 197 Columbia Street.

Date IssuedCategoryDescriptionStatusComments
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 197 Columbia Street. 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 197 Columbia Street. 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-050002022-11-012023-10-31
First five items shown. Sign up to see more.

Rodent Inspections

Recent rodent inspection results for 197 Columbia Street. Data from NYC DOHMH.

DateTypeResult
2019-10-04InitialPassed
First five items shown. Sign up to see more.

HPD Litigation Explanation

The table below shows the HPD litigation records for 197 Columbia Street. 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 197 Columbia Street. 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 197 Columbia Street. Data from ECB.

DateNumberRespondentDescriptionStatusPenaltyBalance Due
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 197 Columbia Street. 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 197 Columbia Street. 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 197 Columbia Street. 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 197 Columbia Street. 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 197 Columbia Street. Data includes sale date, price, buyer, and seller.

DatePriceBuyerSeller

Asbestos Records

Asbestos abatement filings and records for 197 Columbia Street. 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 197 Columbia Street. Data includes connection type, date, and status.

MaterialRecord Type

Elevator Permits

Elevator permit records for 197 Columbia Street. Data includes permit type, issue date, and status.

TypeIssue DateStatus

Landmark Violations

Landmark preservation violations for 197 Columbia Street. 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 197 Columbia Street Compares

Loading comparison data...

Compare with buildings in Columbia St:

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 Columbia St