Your price range of $400-600K and your predilection for condos seem to be the top on your search criteria. Because the Bay area is HUGE -- I'll make a pitch. For my wonderful and picturesque island of Alameda, between San Francisco and Oakland.
Here's a link to tell you what to expect about this historic, picturesque, diverse, exciting island
http://www.alamedahomefinders.com/About_Alameda/page_95171.html
Some of the best things about this island:
>> Easy commute via ferry or express bus to San Francisco, less than 5 minutes away from Oakland and BART
>> Fabulous climate. Almost always sunny, and warmer than San Francisco
>> More reasonably priced than San Francisco
>> More peaceful, with the small town feel to this island of 80,000 people
>> Good schools, good restaurants, various types of entertainment (including an 8-theater cineplex at the newly restored and historic Alameda Theater)
If you're in the area, cone to Alameda this Saturday and Sunday for our annual art and wine fair at Park Street.
http://www.shopparkstreet.com/special_events/art_wine_faire
And discover Alameda. Start your search here. You may never leave.
AND....if you are looking for a condo...would you be interested in a waterfront condo overlooking the Alameda-Oakland Estuary? Built it 2005, this sold for $810K then. I'm listing this next week at $599k(aggressive price to move this short sale fast!).
This is the larget model with 1993 sq ft, tandem 2-car garage with interior entry, some bamboo floor mostly carpet, covered and spacious balcony overlooking the water and the promenade. Walk across the Park Street bridget to Alameda and you're downtown for fabulous restaurants, shops, theater, etc. Believe it or not, we even have a gelato place. Try the wine bar next to Alameda Theater. Or enjoy mojitos at Havana's restaurant and bar.
- Earlier today