Here's a link to gert you started http://www.dqnews.com/Charts/Monthly-Charts/SF-Chronicle-Cha
For example, see zip code 94618 where the price drop isn't as significant as the rest of the city. The median price for 94618 is at $827K; 94610 median price is $666K; 94619 is $429K.
And yes, in some areas, the high number of foreclosures and short sales have tended to lower the price since homeowners who are selling their homes as regular sales have had to also adjust their asking price to compete.
In some areas of Oakland, it isn't investors who are responsible for selling properties; rather, it's the result of people defaulting on their loans.
I just checked and there are 1251 homes for sale in Oakland as of this writing. 477 are bank-owned or 38% of total, and 351 are short sales or 28%. Essentially, that means that 2/3 rds of the properties actively offered for sale are either bank-owned or short sales.
This is not true of other Bay area cities. For example, in Alameda, bank owned listings account for less than 10%.
Hope this helps.
However, if you look at areas in certain parts of East Oakland like Chabot Estates & King Estates in zip code 94605 prices have dropped about $100K but properties sold in those areas have increased from 2007. Why? Because when people default on their loans and lose their homes to foreclosures, prices go down and investors come in and buy at low values. It affects the whole neighborhood and the surrounding home values. You can find specific stats for each zip code on my blog: eastbayhomes.blogspot.com
Were in Oakland you are looking will greatly affect the median price. Oakland is a very diverse city and pretty large geographically. Right now you can buy a house for $60,000 or $100,000,000 ++. Location is the big differential. Certain neighborhoods are considered highly desirable and home prices are in the $700,000s to over a million. In areas that have been hit harder with foreclosures you will see many homes listed at $200,000 and below.
Yes prices have softened and in some areas much more than others. When looking at the median price overall for Oakland, keep in mind this is the median based on prices throughout the city. Because there are so many distinct areas of Oakland, looking at one number for the whole of the city does not give a truly accurate picture. I find it best to look at the particular neighborhoods you are considering and look at the data for those particular areas to get a more accurate picture of the market for the neighborhood you are looking. This will help to give a better picture for the homes values and the market where you are looking.
Hope this helps,
Alain Pinel Realtors