Yep I agree about RH and Pacific Heights. I don't think its a small part of SF, that's the thing.. Central Waterfront and Mission Bay has so much potential.
http://www.pier70sf.com http://missionrock.org http://www.bizjournals.com/sanfrancisco/blog/real-estate/201...
Central SOMA up north and hunters point in the south, eastern neighborhoods will add 50k+ residents to SF in the next 10 years
http://208.121.200.84/ftp/files/Citywide/Central_Corridor/Ce...