Even within SF the weather can be pretty variable depending on what part of the city you're in. My friend living in Richmond has a nice view of the ocean, theoretically, but it's pretty cold and cloudy out in the yard for a lot of the year. I live in the southeast side of the city near Hunter's Point, and we probably have totally overcast days in the single digits, it's basically always sunny and 70 during the day. It does get really windy for a good chunk of the day for a good chunk of the year, but our warmest days are during the spring and summer when that dies down.

My guess is when the candlestick park / shipyard redevelopment happens this is going to be prime residential real estate, it's the best weather in the city IMO.