You need to enable JavaScript to use this site.501-543 Columbus Ave, San Francisco Report | Augrented SF Apartment Ratings & Reviews
Building and Landlord Data Analysis Report

501-543 Columbus Ave, San Francisco, CA 94133

41
Complaints
0
Fire Incidents
230
311 Calls
12
Permits

Risk Assessment

4
High Risk

This building is in the riskiest 10% of buildings in Presidio Heights with significant maintenance issues.

Our AI predicts there is a 4% chance of no major maintenance issues.
Augrented Insights Report

The 32-unit, 3-story multi-family residential building at 501-543 Columbus Avenue in North Beach, owned by 501 Columbus LLC, was constructed in 1907 and has undergone numerous significant renovations and maintenance work over the past few years. Most notably, there have been recent serious maintenance issues, with two significant tenant complaints filed in late 2024 regarding lack of heat and power (December 2024) and ceiling collapse with water leakage (November 2024). The building has completed several major improvements, including ADA compliance updates, plumbing and electrical upgrades, and a substantial re-roofing project in 2022 costing $52,000.

A concerning pattern emerged in 2024-2025 with multiple tenant complaints regarding basic services, including heat and water systems. The building is classified as a "Soft Story" structure, having completed its Tier 4 requirements, and has had some fire safety violations that were subsequently corrected. Recent building improvements (2022-2023) include the installation of ADA bathrooms, electrical systems upgrades, and various plumbing works, though there have been several cancelled or expired permits that indicate some work may have been deferred.

The property underwent a significant commercial space transformation in 2021-2022, including the addition of a barber shop, with associated signage and utility upgrades. Historical maintenance records show previous issues with fire safety systems and building access requirements, though these have been generally addressed. The building's recent inspection history shows periodic fire alarm system issues and violations related to sleeping area requirements, which remain open as of November 2023. The property has a history of 311 calls regarding various maintenance and infrastructure issues in the surrounding area, including tree maintenance, sidewalk defects, and street repairs, with several cases still marked as "Open accepted."

Last updated: January 17, 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.

Share This Report

Download Full Report for 501-543 Columbus Ave

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

Sign Up for Free

Building Overview

Renter Risk Rating

This building is in the safest 40% of buildings in North Beach.

Building Characteristics

Total units 32
Year built 1907
Total area 24678 sq ft
Floors 3
Tax Abatements None
Building Class A15 - Apartment 15 Units or more
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

41
Building Complaints
Number of complaints filed with the Department of Building Inspection in the last 7 years.
61
Code Violations
Building code violations issued by DBI in the last 7 years.
0
Fire Incidents
Total number of fire incidents reported at this building.
9
DBI Director Hearings
Number of Director's Hearings held by DBI in the last 7 years.
230
311 Calls
Number of 311 calls for this building.
0
Fire Injuries
Number of fire injuries reported by SFFD.
12
Building Permits
Number of building permits issued by DBI.

Included Addresses

  • 535 Columbus Ave, San Francisco CA 94133
  • 537 Columbus Ave, San Francisco CA 94133
  • 515 Columbus Ave, San Francisco CA 94133
  • 533 Columbus Ave, San Francisco CA 94133
  • 527 Columbus Ave, San Francisco CA 94133
  • 513 Columbus Ave, San Francisco CA 94133
  • 620 Green St, San Francisco CA 94133
  • 622 Green St, San Francisco CA 94133
  • 543 Columbus Ave, San Francisco CA 94133
  • 521 Columbus Ave, San Francisco CA 94133
  • 541 Columbus Ave, San Francisco CA 94133
  • 519 Columbus Ave, San Francisco CA 94133
  • 501 Columbus Ave, San Francisco CA 94133
  • 517 Columbus Ave, San Francisco CA 94133
  • 531 Columbus Ave, San Francisco CA 94133
  • 511 Columbus Ave, San Francisco CA 94133
  • 525 Columbus Ave, San Francisco CA 94133
  • 523 Columbus Ave, San Francisco CA 94133
  • 507 Columbus Ave, San Francisco CA 94133
  • 612 Green St, San Francisco CA 94133
  • 529 Columbus Ave, San Francisco CA 94133

Map and Aerial View of 501-543 Columbus Ave

Street Map View
Loading map...

Loading street map...

Satellite View
Loading satellite view...

Loading satellite view...

Reviews of 501-543 Columbus Ave

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

501-543 Columbus Ave Landlord Information

Ownership Data

Ownership data from the Secured Roll (property tax) provided by the SF Assessor-Recorder.

NameAddress
501 Columbus Llc1152 Barroilhet Ave Hillsborough CA 94010

Landlord Portfolio

We cross-reference landlords' property tax registrations to find the other buildings they own or manage.

AddressUnitsCode ViolationsRisk Rating
First five items shown. Sign up to see more.

Landlord Court Records

From CA Court Service & DocketAlarm. Note: 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.

501-543 Columbus Ave Rent Control Status

Year Built
Built before 1979
Units
More than 1 unit
Rent Board Registration
Not applicable
Additional Info
N/A
Year BuiltUnitsRent Board RegistrationAdditional Info
Before 1979 >1 unit N/A N/A

Full Building Data for 501-543 Columbus Ave

311 Housing Complaints

The table below shows the 311 housing complaints received regarding the conditions at 501-543 Columbus Ave, as well as requests for service nearby.

OpenedCategoryResponsible AgencyRequest TypeRequest DetailsStatus
2025-07-28 10:48:06+00:00 Street and Sidewalk Cleaning Recology - Abandonedgarbage_and_debrisother_bagged_boxed_contained_garbage Closed
2025-07-26 13:40:50+00:00 General Request Healthy Streets Operation Centerhomelessness_and_supportive_housinghousing_homeless request_for_service Closed
2025-07-26 13:16:01+00:00 Street and Sidewalk Cleaning PW - Street and Environmental Servicesgarbage_and_debrisother_loose_garbage_debris_yard_waste Closed
2025-06-16 14:23:14+00:00 Sewer PUC - Sewer Opssewage_back-up_dischargefrom_side_sewer_vent Closed
2025-06-06 13:46:08+00:00 Sewer PUC - Sewer Opssewage_back-up_dischargefrom_other_location Open
First five items shown. Sign up to see more.

DBI Complaints

Complaints received by the Department of Building Inspection.

Date FiledDate AbatedAssigned DivisionComplaint DescriptionStatusLink
2025-04-25 00:00:00+00:00NoneCode Enforcement SectionVacant storefront. Active View on DBI
2024-12-20 00:00:00+00:00NoneHousing Inspection ServicesNo heat, no power in the whole apartment except the kichen Not Active View on DBI
2024-11-26 00:00:00+00:00NoneHousing Inspection ServicesThere are several holes in the ceiling of my bedroom. i have to use a garbage bag to cover the ceiling holes. last wednesday the ceiling in the corridor collapsed and now there is a large hole in the ceiling. the water is leaking and we are using buckets to catch the water. we did inform the apartment manger but nothing has been fixed. Not Active View on DBI
2024-05-28 00:00:00+00:00NoneCode Enforcement SectionDate last observed: 24-may-24; exact location: main bldg; building type: commercial/business vacant structure; ; additional information: update on complaint 202307528; Not Active View on DBI
2023-05-02 00:00:00+00:00NoneCode Enforcement SectionDate last observed: 01-may-23; floor: ground; exact location: main bldg; building type: commercial/business vacant structure; other building; ; additional information: vacant commercial space & non-transparent windows; Not Active View on DBI
First five items shown. Sign up to see more.

DBI Violations

Building code violations records.

Date FiledDate AbatedItemViolation DescriptionStatus
2023-03-14T00:00:00.000Z No description entered Nonenot active
2022-09-26T00:00:00.000Z this notice includes violations for the areas noted. this notice includes violations of the san francisco housing code. unless noted otherwise, all violations were observed on the date of inspection at 535 columbus avenue. this was a complaint generated routine inspection initiated by a complaint filed under the same tracking number. building sectionnot active
2022-09-26T00:00:00.000Z inspector comments important note: due to the nature of this violation, this property has been defined as a nuisance per section 1001-d of the san francisco housing code. it is the property owner¿s responsibility to be present or direct his/her representative to attend the re-inspection as scheduled on this notice of violation for the purpose of providing entry to the inspector of those areas not accessed during the initial inspection as specified, and/or to provide access to all areas cited within this notice. if the property owner cannot attend the scheduled re-inspection (as specified on this notice) it is his/her responsibility to secure a different inspection date and time with the inspector, and provide all tenants with notification as required by california civil code section 1954 (san francisco housing code section 303(b), if any dwellings, apartment units or guest rooms are to be accessed during the re-inspection. other sectionnot active
2022-09-26T00:00:00.000Z relocate low voltage wiring on the roof 810, 1001d, e, l sfhc there are low voltage cables strung across the roof, unstrapped and left as an obvious trip hazard. many are tied to the fire escape ladders. rerun and strap cables to remove the trip hazard for any and all future occupants of the roof including repair and emergency service personnel. building sectionnot active
2022-09-26T00:00:00.000Z repair the roof access door 706 & 805 & 912 sfhc the roof has two roof access doors, both need repairs. the door nearest green street has no knob and does not remain closed or latched when released. the other door has a wad of caulking at the threshold keeping the door from closing completely. repair the roof access doors as necessary. upon completion the door and jamb shall be tight fitting, in good condition, self-closing and self-latching. building sectionnot active
First five items shown. Sign up to see more.

Fire Violations

Fire code violations recorded by the San Francisco Fire Department.

Violation DateDisposition DateAddressViolation DescriptionStatus
2023-11-18T00:00:00.000Z501 - 543 Columbus Avesleeping area requirements open
First five items shown. Sign up to see more.

Fire Incidents

Historical fire incident records for the property.

Incident DatePrimary SituationIgnition CauseCivilian Injuries
2024-06-22 00:00:00+00:00440 Electrical wiring/equipment problem, otherNone0
First five items shown. Sign up to see more.

Building Permits

Permit records for 501-543 Columbus Ave.

Permit Creation DateEstimated CostDescriptionStatusPermit Number
First five items shown. Sign up to see more.

Electrical Permits

Electrical system permits for the building.

Application DateDescriptionStatusPermit Number
First five items shown. Sign up to see more.

Plumbing Permits

Plumbing system permits for the building.

Application DateDescriptionStatusPermit Number
First five items shown. Sign up to see more.

Planning Records

Planning records for the property.

DateProject AddressDescriptionApplicant
First five items shown. Sign up to see more.

Tenant Buyouts

Tenant buyout records for the property.

BlocklotAddressAgreement DateAmountTenants
0117005535 Columbus AvenueNoneNoneNone
First five items shown. Sign up to see more.

How 501-543 Columbus Ave Compares

Loading...

Loading comparison data...

Compare with buildings in North Beach:
Showing buildings that are: within 0.5 miles , of similar age (±15 years), of similar size (±50% units)

0

Comparable Buildings

0

Better Rated

0

Worse Rated

Comparison with Similar Buildings
Hover over metrics for details
BuildingYear BuiltUnits Violations Complaints Fire Incidents Risk Rating
Loading...---000-
This BuildingBetterWorse
Upgrade to view more metrics

Get access to all building comparison metrics and insights with a premium account.

Upgrade Now

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
Preview of building report data and features

Nearby Buildings