My good friend, Mark Choey specializes in properties in SOMA, South Beach, and Mission Bay. And especially condos. He told me that the market in those areas are still strong despite the national weakness. Especially premium properties, well staged, are getting multiple offers. He can provide so much more specifics and comps (he's closed on a number of transactions this month). His contact info is at:
He's a great guy, and I highly recommend him.