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

947-957 Columbus Ave, San Francisco, CA 94133

0
Complaints
0
Fire Incidents
347
311 Calls
0
Permits

Risk Assessment

18
High Risk

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

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

The 6-unit, 3-story multi-family residential building at 947-957 Columbus Avenue in Russian Hill, owned by the Vincent P Larocca Revocable Trust, has undergone several significant safety upgrades and maintenance projects over the past two decades. Most notably, in 2024, the building received substantial improvements including a complete reroofing ($23,500) and a comprehensive fire alarm system upgrade ($22,380) to comply with current safety standards. Earlier infrastructure improvements include a water main upgrade from galvanized to copper piping in 2021, demonstrating ongoing maintenance of essential systems.

The building has a documented history of addressing safety concerns, with multiple fire safety enhancements including the installation of low-frequency sounders in sleeping areas, though past violations related to fire equipment maintenance were noted in 2006. The property has experienced various maintenance and safety issues over the years, particularly evident in a cluster of violations documented in 2002-2004 addressing concerns such as weatherproofing, window maintenance, interior damage, and fire safety equipment. While these violations were ultimately abated, they reflect historical maintenance challenges.

More recent complaints from late 2023 regarding construction noise from residential units added inside the La Rocca bar basement are currently active, warranting attention to potential unit modifications. The building's history also shows attention to basic infrastructure needs, with a water heater replacement in 2010 and earlier roofing work in 1994, though some permits from the 2000s are listed as expired. Regular inspections and maintenance work suggest an ongoing commitment to building upkeep, particularly in terms of fire safety and basic infrastructure modernization.

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 947-957 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 riskiest 10% of buildings in Russian Hill.

Building Characteristics

Total units 6
Year built 1917
Total area 4672 sq ft
Floors 3
Tax Abatements None
Building Class A5 - Apartment 5 to 14 Units
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
Building Complaints
Number of complaints filed with the Department of Building Inspection in the last 7 years.
0
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.
0
DBI Director Hearings
Number of Director's Hearings held by DBI in the last 7 years.
347
311 Calls
Number of 311 calls for this building.
0
Fire Injuries
Number of fire injuries reported by SFFD.
0
Building Permits
Number of building permits issued by DBI.

Included Addresses

  • 947 Columbus Ave, San Francisco CA 94133
  • 955 Columbus Ave, San Francisco CA 94133
  • 949 Columbus Ave, San Francisco CA 94133
  • 957 Columbus Ave, San Francisco CA 94133

Map and Aerial View of 947-957 Columbus Ave

Street Map View
Loading map...

Loading street map...

Satellite View
Loading satellite view...

Loading satellite view...

Reviews of 947-957 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

947-957 Columbus Ave Landlord Information

Ownership Data

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

NameAddress
Vincent P Larocca Revoc TruLarocca Eleanor M & Leo Mar 82 Buckelew St Sausalito CA 94965

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.

947-957 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 947-957 Columbus Ave

311 Housing Complaints

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

OpenedCategoryResponsible AgencyRequest TypeRequest DetailsStatus
2025-07-28 14:21:29+00:00 Tree Maintenance PW - Urban Forestrydamaged_treefallen_tree Closed
2025-07-26 12:36:06+00:00 Tree Maintenance PW - Street and Environmental Servicesdamaged_treefallen_tree Open
2025-07-22 20:51:32+00:00 General Request Healthy Streets Operation Center - Individualhomelessness_and_supportive_housinghousing_homeless request_for_service Closed
2025-07-16 13:56:02+00:00 Street and Sidewalk Cleaning Recology - Abandonedgarbage_and_debrisother_bagged_boxed_contained_garbage Closed
2025-06-27 16:43:04+00:00 Blocked Street and Sidewalk MTA - Access/Mobility Services Receivedblocked_sidewalkscooter_without_license_plate Closed
First five items shown. Sign up to see more.

DBI Complaints

Complaints received by the Department of Building Inspection.

Date FiledDate AbatedAssigned DivisionComplaint DescriptionStatusLink
2023-12-11 00:00:00+00:00NoneBuilding Inspection DivisionConstruction noise, residential units added inside la rocca bar basement. (311 sr 17646962) Not Active View on DBI
2015-11-04 00:00:00+00:002016-02-23 00:00:00+00:00Housing Inspection ServicesRoutine inspection Not Active View on DBI
2015-11-02 00:00:00+00:002016-01-28 00:00:00+00:00Housing Inspection ServicesDate last observed: 31-oct-15; time last observed: 4:00pm; identity of person performing the work: n/a; floor: 3; unit: 3; exact location: main bldg; building type: residence/dwelling fire safety/fire escape; insects/rodents; mold; ; additional information: door to building entrance is broken; Not Active View on DBI
2009-11-18 00:00:00+00:002010-03-03 00:00:00+00:00Housing Inspection ServicesMold and mildew in bathtub and at walls; inoperable windows and chipping interior paint. Not Active View on DBI
2006-01-11 00:00:00+00:002006-03-16 00:00:00+00:00Housing Inspection ServicesDamaged wall in the bathroom. Not Active View on DBI
First five items shown. Sign up to see more.

DBI Violations

Building code violations records.

Date FiledDate AbatedItemViolation DescriptionStatus
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
First five items shown. Sign up to see more.

Fire Incidents

Historical fire incident records for the property.

Incident DatePrimary SituationIgnition CauseCivilian Injuries
2019-02-10 00:00:00+00:00653 Smoke from barbecue, tar kettleNone0
First five items shown. Sign up to see more.

Building Permits

Permit records for 947-957 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
First five items shown. Sign up to see more.

How 947-957 Columbus Ave Compares

Loading...

Loading comparison data...

Compare with buildings in Russian Hill:
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