The meth labs are all in Harlan Country: https://en.wikipedia.org/wiki/Justified_(TV_series)
On Piedmont Avenue we have http://homesteadoakland.com, http://www.dopoadesso.com/adesso/, http://gregoirerestaurant.com, http://bajaonpiedmont.com, http://commisrestaurant.com, http://misturapiedmont.com (new Peruvian!), and the like.
Oakland is not Detroit. Here's a sample of houses available in our neighborhood: http://www.zillow.com/temescal-oakland-ca/
Here's what's available around Piedmont Avenue: http://www.zillow.com/homes/for_sale/Piedmont-Avenue-Oakland-CA/pmf,pf_pt/268405_rid/37.835124,-122.232535,37.818209,-122.270601_rect/14_zm/
The other morning, somebody from Sotheby's showed up on the porch to try to get us to put our house on the market. I told him to get out and not come back.