Actually, I have 2 clients who live in the newish condo building at 29th and Mission. Both got great deals and are enjoying life in this little "in-between" 'hood.
I think it is totally up-an-coming because it's an area that is part-Bernal, part-Mission, part-Noe Valley and almost part-Glen Park. You can walk to great restaurants like Blue Plate, Emmy's, Cortland Ave places like Liberty and Moki's Sushi, into the Mission or upper Church area of Noe (Deep Sushi, etc). You can have easy public transit too with the Mission buses, the J-Church and even the 24th BART not too far away.
Actually, I have a special name for this area that I can't publish here but do share with my clients... Ask me about it! ;)
It is also a great place to live if you can commute to work downtown on a bike. Valencia to Market is a blast. Which reminds me that Valencia street has a great scene going on now too. 18th and Valencia is very hot. Enjoy!