Free SF apartment background check

400-410 Cole St

Haight Ashbury, SF 94117 1225027 7 units · 3 fl · 1900

This building has more problems than most buildings in this neighborhood. Few open issues; problems get fixed quickly. A reasonable bet for a smooth tenancy.

NOVs (7y) vs. neighborhood
Compared to a typical building in Haight Ashbury
At or below average
avg 1.8
0
FewerMore

This building has 0 novs (7y), at or below the Haight Ashbury average of 1.8.

Rent & eviction protection

Is 400-410 Cole St 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.

Built before 1979
Built 1900
2 or more units
7 units
Property type
Multi-Family Residential
Zoning
RM2
Likely rent-controlled. Building age and unit count suggest this property falls under San Francisco's Rent Ordinance.

Based on SF Assessor records. Not legal advice — confirm with the SF Rent Board.

Building characteristics
Units7
Floors3
Year built1900
Total area9,300 sq ft
Property typeMulti-Family Residential
Tax statusNone
Blocklot1225027
Ownership

Registered owner per SF Assessor-Recorder (secured roll).

Owner name
Macphee Robert C
Mailing address
Po Box 411567 San Francisco CA 94141
Last sale
021208

Landlord portfolio

Other SF properties this owner holds, with risk grades for each.

Unlock complete report
Multiple entrances & addresses

Included addresses

All street addresses sharing this blocklot that are covered by this report.

410 Cole St, San Francisco, CA 94117
400 Cole St, San Francisco, CA 94117
408 Cole St, San Francisco, CA 94117
402 Cole St, San Francisco, CA 94117
404 Cole St, San Francisco, CA 94117
406 Cole St, San Francisco, CA 94117
Augrented Insights
Initial analysis

The 7-unit, 3-story apartment building at 400-410 Cole Street in Haight-Ashbury, built in 1900 and owned by Robert C. Macphee, has undergone several significant improvements in recent years. The most substantial was a mandatory soft-story retrofit completed in 2018 at a cost of $61,000, with subsequent structural revisions based on site conditions. The building has maintained its historical character while addressing modern safety requirements, though it has experienced multiple smoke detector activations (all non-fire related) and one gas leak incident, with no civilian injuries reported in any of these events. A comprehensive renovation of unit #404 was completed in 2010, modernizing both kitchen and bathroom facilities.

The building's history includes several routine housing inspections between 2002 and 2016, during which various issues were identified and subsequently resolved. These included concerns about lead paint hazards, a fire escape ladder, security locks, and egress obstructions, all of which were abated by September 2007. Recent years have seen the building endure typical urban challenges, as evidenced by multiple 311 calls in 2024 regarding nearby street conditions, though these are external to the building itself. The most recent soft-story retrofit work was classified as Tier 3, with the city confirming that work is complete and a Certificate of Final Completion (CFC) has been issued.

AI-generated · may contain errors · check the source data tables below

Free account unlocks the full analysis — plus 2× more records across all data categories and the complete landlord portfolio.
Risk rating

How 400-410 Cole St'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

Grade A–B — Low risk

DBI rarely finds violations here. Strong maintenance history and a clean complaint record.

Grade C — Moderate risk

Some past violations or complaints on record. Worth asking the landlord about any open issues before signing.

Grade D–F — High risk

Elevated violation and complaint history. DBI has found issues here before and is statistically likely to again.

Neighborhood percentile
22th percentile

Out of 581 buildings in this neighborhood, 453 are predicted to be safer.

RiskiestSafest
Predicted 12-month outcome
54%
No DBI
violation
46%
DBI violation
likely
Model explanation

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.

Number of units

The number of units affects how the model reads complaint and violation totals — more units means more potential sources.

Building size

Total floor area — a proxy for building scale and the number of systems (plumbing, electrical, HVAC) that can fail.

DBI tenant complaints (past 7 years)

Formal complaints tenants filed with DBI about this building over 7 years.

12-Month severity forecast
No violation 41.3%
Moderate concern 46.5%
Severe concern 12.2%
Estimated probability of receiving a DBI Notice of Violation in the next 12 months at each severity level. Model: full_hgb_balanced.
Apartment reviews

400-410 Cole St 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…

On the map

Compare nearby alternatives

This building and nearby alternatives, color-coded by risk level. Click any marker to explore.

Buildings nearby
Loading…
The story over time

400-410 Cole St event timeline

Violations, complaints, fire incidents, permits, and buyouts — most recent records in order.

2026
311 Request Feb 20
Not offensive
pole
311 RequestJan 23
Garbage and debris

See all 10 events

Full history back to 2020 — violations, complaints, permits, buyouts, and fire incidents.

Unlock complete timeline
Every record we have

Full data for 400-410 Cole St apartments

13 SF public datasets for this parcel — permits, violations, complaints, fire records, 311 calls, planning records, and buyouts.

Still apartment hunting in SF?

Look up the next apartment before you sign

Search any SF address free — no account needed to see the risk rating.

Simple pricing

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

$10 one-time

~$3.33 per building. No subscription ever. Each credit unlocks one building's premium report for 30 days.

  • 3 full AI-powered reports
  • Download PDF reports
  • Advanced safety analysis
  • Compare multiple buildings
  • Credits never expire until you use them
  • Full public records (200 rows per dataset)
Buy 3 Reports — $10

Apartment Hunter

For a wide search across many buildings

$39 one-time

30 reports — ~$1.30 each. No subscription ever.

  • 30 full AI-powered reports
  • Download PDF reports
  • Advanced safety analysis
  • Compare multiple buildings
  • Credits never expire until you use them
  • Full public records (200 rows per dataset)
Buy 30 Reports — $39

Cancel anytime · Data sourced from SF Open Data, DBI, SFFD, SF Rent Board & Planning

Watch 400-410 Cole St
Get alerted the moment a new violation or complaint is filed.