947-957 Columbus Ave
A handful of records on file over the last seven years, and our model sees a moderate chance of more in the next 12 months. A few records worth reading before you sign. Check whether they were closed out, and ask what was actually fixed.
This building has 0 novs (7y), at or below the Russian Hill average of 1.9.
Is 947-957 Columbus Ave rent-controlled?
San Francisco's Rent Ordinance caps rent increases and provides eviction protection for most residential units built before 1979 with 2+ units. Here's how this building scores.
Based on SF Assessor records. Not legal advice — confirm with the SF Rent Board.
California Tenant Protection Act of 2019
Even when a building isn't covered by local rent stabilization, the statewide Tenant Protection Act (AB 1482) may still apply. It caps annual rent increases and requires the landlord to state a legal reason to end most tenancies.
AB 1482 does not apply to single-family homes and condos unless owned by a corporation, REIT, or an LLC with a corporate member; to owner-occupied duplexes; or to deed-restricted affordable housing. The Act is in effect until January 1, 2030. Not legal advice — see the California landlord–tenant guide.
| Units | 6 |
|---|---|
| Floors | 3 |
| Year built | 1917 |
| Total area | 4,672 sq ft |
| Property type | Multi-Family Residential |
| Tax status | None |
| Blocklot | 0065017 |
Registered owner per SF Assessor-Recorder (secured roll).
Landlord portfolio
Other SF properties this owner holds, with a risk rating for each.
Unlock complete reportIncluded addresses
All street addresses sharing this blocklot that are covered by this 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.
AI-generated · may contain errors · check the source data tables below
How 947-957 Columbus Ave's risk score is calculated
We trained a model on 7 years of SF DBI inspection data — notice of violation filings, complaint history, and owner track records. It estimates the probability that DBI inspectors will issue a Notice of Violation at this address in the next 12 months. Lower % = safer.
What the score means for you
Lower risk — safer than most nearby
DBI rarely finds violations here. Strong maintenance history and a clean complaint record.
Typical — about average for the neighborhood
Some past violations or complaints on record. Worth asking the landlord about any open issues before signing.
Higher risk — riskier than most nearby
Elevated violation and complaint history. DBI has found issues here before and is statistically likely to again.
Out of 1133 buildings in this neighborhood, 725 are predicted to be safer. The band is relative to this neighborhood, so a share of every neighborhood falls in each colour.
violation
likely
What's driving this score
The three data points that most influenced this building's risk rating — ranked by the weight the model placed on each one.
947-957 Columbus Ave apartment reviews
Real experiences from people who have lived here. Share yours to help other renters decide.
Share your experience — Help other renters by leaving an honest apartment review
Loading reviews…
947-957 Columbus Ave event timeline
Violations, complaints, fire incidents, permits, and buyouts — most recent records in order.
See all 12 events
Full history back to 2021 — violations, complaints, permits, buyouts, and fire incidents.
Unlock complete timelineFull data for 947-957 Columbus Ave apartments
13 SF public datasets for this parcel — permits, violations, complaints, fire records, 311 calls, planning records, and buyouts.
What this is
Permits issued by the SF Department of Building Inspection for new construction, alterations, and repairs. Includes estimated cost and current permit status.
| Permit # | Description | Cost | Filed | Status |
|---|---|---|---|---|
| Loading… | ||||
What this is
Plumbing permit applications filed with the SF Department of Building Inspection. Covers plumbing installation, repair, and replacement work.
| Permit # | Description | Filed | Status |
|---|---|---|---|
| Loading… | |||
What this is
Electrical permit applications filed with the SF Department of Building Inspection. Covers electrical wiring, panel upgrades, and related work.
| Permit # | Description | Filed | Status |
|---|---|---|---|
| Loading… | |||
What this is
Notices of Violation issued by the SF Department of Building Inspection for code violations. Unresolved notices can escalate to legal action.
| Date Filed | Complaint # | Description | Item | Category | Status |
|---|---|---|---|---|---|
| Loading… | |||||
What this is
Complaints filed with the SF Department of Building Inspection about code violations. Tracks the complaint lifecycle from filing through abatement or referral.
| Complaint # | Date Filed | Date Abated | Division | Status | Description |
|---|---|---|---|---|---|
| Loading… | |||||
What this is
Planning Department project entitlements — discretionary review, conditional use, variances, and environmental review for this parcel.
| Address | Opened | Closed | Status | Description | Applicant |
|---|---|---|---|---|---|
| Loading… | |||||
What this is
Planning Department administrative and compliance records that are not full project entitlements — pre-application meetings, code violations, and referrals.
| Address | Opened | Closed | Status | Description | Applicant |
|---|---|---|---|---|---|
| Loading… | |||||
What this is
SFFD fire incidents geo-joined to this parcel. Covers structure fires, alarms, and emergency responses with injury and fatality counts.
| Date | Situation | Civilian Injuries | Civilian Fatalities |
|---|---|---|---|
| Loading… | |||
What this is
Fire code violations issued by the SFFD. Tracks corrective actions required and resolution status for fire safety code enforcement.
| Violation Date | Description | Corrective Action | Status | Close Date |
|---|---|---|---|---|
| Loading… | ||||
What this is
Fire code complaints received by the SF Fire Department geo-joined to this parcel. Includes complaint type, disposition, and outcome.
| Received | Description | Disposition Date | Disposition |
|---|---|---|---|
| Loading… | |||
What this is
SF 311 service requests geo-joined to this parcel. Includes maintenance complaints, street/sidewalk issues, and quality-of-life requests.
| Opened | Type | Agency | Category | Details | Status |
|---|---|---|---|---|---|
| Loading… | |||||
What this is
Buildings subject to SF's mandatory soft-story seismic retrofit program. Unreinforced multi-story wood-frame buildings must meet compliance tiers.
| Tier | Status |
|---|---|
| Loading… | |
What this is
Tenant buyout (Ellis Act pre-cursor) agreements recorded with the SF Rent Board. Tracks amounts paid to tenants to vacate rent-controlled units.
| Disclosure Date | Buyout Date | Amount | Tenants |
|---|---|---|---|
| Loading… | |||
How 947-957 Columbus Ave compares to the neighborhood
This building against comparable properties in Russian Hill. Toggle filters to narrow the peer group.
No comparable buildings found with the selected filters. Try removing a filter.
Look up the next apartment before you sign
Search any SF address free — no account needed to see the risk rating.
Get the complete picture
Every plan unlocks the complete report: all 13 SF datasets, full history, landlord portfolio, and PDF & Excel exports.
Report Bundle
For the buildings you're deciding on right now
$10one time
3premium reports
$3.33 per report · charged once, never renews
Each credit unlocks one building's premium report for 30 days.
- 3 premium reports — AI executive summary included
- Live data across all 27 public record types
- 200 records per dataset
- PDF & Excel exports included
- Compare up to 10 buildings side-by-side
- Credits never expire until you use them
Apartment Hunter
For a wide search across many buildings
$39one time
30premium reports
$1.30 per report · charged once, never renews
Each credit unlocks one building's premium report for 30 days.
- 30 premium reports — AI executive summary included
- Live data across all 27 public record types
- 200 records per dataset
- PDF & Excel exports included
- Compare up to 10 buildings side-by-side
- Credits never expire until you use them
Renter
For the weeks when the stakes are highest
$8.33/mo
5premium reports / mo
Billed $100/year — save $44 vs monthly
Renews automatically until you cancel.
- Unlimited standard reports — 50 records per dataset
- 5 premium AI reports per month — live data, 200 records per dataset, all 27 record types
- PDF & Excel exports on every report
- Compare up to 10 buildings side-by-side
- Full event timeline — every year of history
- Landlord portfolio & ownership insights
Less than $0.28/day. Cancel anytime.
Cancel anytime · Data sourced from SF Open Data, DBI, SFFD, SF Rent Board & Planning