Here are some places you can go to find out what Bay Area Homes are going to be open:

http://www.sfgate.com/classifieds/openhomes/

http://www.homebuyerstour.com/

http://homes.insidebayarea.com/openhomes/