My wife and I have put in more than 20 unsuccessful offers attempting to stay in our unfortunately popular neighborhood in the last two years. We have been chasing the affordability train for some years now, our increasing bids never getting ahead of the frenzy... (today, it seems we're at peak market and it'd be foolhardy to buy perhaps...)
NB: we don't just 'move further out' not only because of 20 years of community, our love of bike commuting, and our great 'hood...
...we are bound by the location of our excellent public school. Non-parents may not realize the staggering import of lucking into a K8 public school you truly love... for two siblings in SF, staying in our school instead of paying for some private (assuming we could get into one) will amounts to well over half a million dollars in post-tax income over the next decade...
We too are part of the tired story of 'middle' class (by SF standards... :P) professional families with 2x full time incomes finding it almost impossible to hold on to a life of modest middle class comfort in SF (where middle class means: a 1000 sq ft 2 bedroom home for family of four; one 25K car; public schools; etc.)