Chleaned up my data and made

[Eugene]

Chleaned up my data and made some graphs.

First, a consistency check (making sure my numbers are roughly the same as official Case-Shiller).

[img_assist|nid=5965|title=Consistency Check|desc=|link=node|align=left|width=466|height=336]

Not a perfect match but good enough. There are too many implementation subtleties and my data is lower quality, so I can’t hope for a perfect match.

Notice that I have two more points. Official Case-Shiller numbers for October are based on sales in August through October. I also have data for November.

Next, regional graphs.

[img_assist|nid=5968|title=Regional HPI – 07/11|desc=|link=node|align=left|width=466|height=306]

Coastal areas are almost at the peak levels. November blip is probably seasonal. From Coronado to CV to Carlsbad, bubble denial is still strong.

Affluent north county inland neighborhoods are still holding. Middle-class and Mexican zip codes are in free fall.

Finally a quick look at specific resales, to see what kinds of transactions contibute to apparent 27% decline south of 94.

http://www.sdlookup.com/Property-37101EFF-3242_San_Carlos_Dr_Spring_Valley_CA_91978
Bought in June ’05 for 595k (2% off the peak), sold for 460k

http://www.sdlookup.com/Property-439233E6-1332_Santa_Cora_Ave_Chula_Vista_CA_91913
Bought in 11/2003 for 442k (31% off the peak), sold for 440k

http://www.sdlookup.com/Property-27FBE78D-9252_Brookside_Cir_Spring_Valley_CA_91977
Bought in Sep ’05 for 650k (1% off the peak), sold for 422k

http://www.sdlookup.com/Property-A586DFE8-3643_Byrd_St_San_Diego_CA_92154
Bought in Dec ’03 for 351k (28% off the peak), sold for 307k