I know this area VERY well because I both work here as a local, full-time Realtor and live nearby since 1999.
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! ;)