The search for affordable housing in San Francisco is a "trope". It's one of those thing that any Bay Area local will recognize when you drop it into a conversation. Think of it as looking for a particular antique in a market of pawn shops, except you don't quite know how to describe what you're looking for and the sellers are convinced that they have it, and so you have no power in negotiating.
After five days of viewings in a week, we finally agreed on a a second-floor Edwardian apartment in the Richmond District. Most days around here see fog or sun with an ocean breeze in the summer, but Fall (crossing fingers!) should be warmer. We move in Sunday morning, and I start work on Monday. So that'll be fun.