There is no easy answer to your question. Markets are influenced by forces that are not predictable. I believe that consumer confidence is the biggest factor in the short term of the real estae market. Confidence right now is low and with out some good news on any front it may stay that way.
The reality is you can't time a market, whether its stocks, gold or anything. It might go down a little bit or stay flat but there is one thing that will always be true - San Francisco housiing costs will rise over time.