To the extent there are any left in the San Francisco area, take a look at these FHA, Freddie and Fannie REO (real estate owned) properties – essentially, a database for foreclosed homes: https://www.homepath.com/