FLU- this is fantastic, I really appreciate. What site did you use for your data by the way? I look forward to the time where you start tracking detached so diligently that will really peeve the people who believe CV is immune because there's an endless supply of doctors and C levels who want to live there :-)!
A few questions and favors, do you have the TOTAL number of people either who have SOLD or are listed as underwater versus above handy to spare me from counting or dumping the data myself? If you opt to update this in the futre, can you include % losses as a column? Thanks a million
I'll try to update the scripts I have that do this. Basically, the sources of data i'm using is pretty much
sdlookup.com's mlslisting.
sdlookup.com's sales history drilldown on each mls listing
sdlookup.com's sales history by address search
houserebate.com's sold/pending history
I have still yet to hook up to the san diego's tax assesor's office prop tax pages, and redfin,zestimate,etc.
i don't have access to realtor available information, so this probably isn't as accurate as what realtors could put together (some of the MLS listings might be outdated).
I noticed there was a gap in historyfor some homes. And I couldn't find either a sales transaction, or withdrawal or relisting information for a lot of properties.
If any of you have additional public websites that can suggest my web crawlers scrape for historical sales data that are free, let me know and I'll see what I can do.