I too would love to find this. I have searched many websites. The only info I got was from a local re agent and was only five years of local data.
try your local real estate board. for canadians there is www.royallepage.com that has records dating back to the mid 70s.
its a super-bubble. if u have big cheese, prepare for the right moment (maybe not soon) and pounce short.
I think a good area to study would be inter market analysis (John Murphy). Study the relation of the bond market, business cycle, interest rate cycles etc to the real estate market. Not so sure a MACD or EMA on real estate sales would be that useful.
i think you'd have a hard time using TA on real estate because you wouldn't have enough quality information on the market... there are not enough transactions and comparable properties to make good judgement.
A bit off topic here, but I recently found charts of gas prices which were averaged from local retailer info in Illinois...Its a very interesting chart...I have to imagine that someone has been clever enough to download median sales prices in many metropolitan and suburban areas for different parts of the country and then chart it into Excel...I definitely think this would be real interesting to chart the TA of say gas prices, real estate median price sales and some other slightly obscure markets...
How about finding a REIT that concentrates on the market that you're interested in, then just use the TA for their company? Wouldn't that be the shortcut to compiling your own RE stats and making charts? Or are there other factors that go into REIT profitability that would mitigate the accuracy of their charts?