After some thinking I've decided that I'm not going to maintain the Flagstaff, AZ Home Supply Chart any longer. I've been diligently punching in numbers from the MLS and zillow for a long time now and I don't want to do it any more. My interest in housing bubbles and economics in general has waned and I'm not going to spend any more of my time watching home prices. Life is just too damned short to be worrying about some jackass asking too much for his crappy three-bedroom ranch house in ponderosa trails.
If you want to download the spreadsheet and keep it going yourself then you can download it here. It's in Excel 2007 format. I never had much luck converting it to Apple's Numbers, OpenOffice, or anything but Microsoft's Office formats.
To update the data all you have to do is head over to www.northernarizonamls.com every week or so and do three "Flagstaff" property searches: one for single family + townhouse + condo, one for mobile + manufactured, and one with everything selected. The zindex data for Flagstaff can be found here.
My advice for those trying to time the market using charts like this is: Don't Bother. If you need or want a home and you have the money then buy one. If you don't then rent. It's a pretty simple choice. If you can, skip the realtors and their high commissions, lies, and conflicts of interest. Instead, look at the FSBOs, talk with the owner, and work out a deal. You know, kind of like the old days before middlemen and hucksters convinced everyone that we couldn't do business without them.