In addition to those. You can work with a Realtor who has access to the MLS listings. After the bank has foreclosed on a home, they list them on the MLS. Your Realtor will be able to show you a list of all foreclosures on the market in Fremont, Newark, or any city in the area.
Hope this helps,
Brian Ripp, CRS, GRI
Real Estate Market Weekly Update Webcast: http://realtytimes.com/REUv/BrianRipp
Realtor since 1985
You can find out more about this by visiting this FAQ site:
This site provides the results of the last auction (except for 2 props, all were in Oakland):
I live in Fremont and can easily meet with you should you like to explore other distressed property purchasing strategies.
Best Regards, Steve