I moved from the SF Bay Area...in a very popular east bay location near public trans, great shopping .... in between the city and traditional suburbs....North Oakland, one of the lower priced but still attractive areas.
A home of approx 2000 sq. feet, very small yard, 3 BR, 2BA craftsman style cottage, no garage or off street parking sells for at least $600K. 2BRs go for over $400K.
In my move to Portland I thought things would be less, but I selected a fairly trendy neighborhood (Pearl) where condos/flats which are very small (800-1200 sq feet) sell for between $400-600K. I am told you can find nice homes for much less. Needless to say I will look carefully before deciding to buy!
Of course, SF is one of the most expensive areas to live with prices holding very strong even with the roller coaster ride going on in Calif.