by Markor » Mon Nov 12, 2007 8:32 pm
I'm getting confused... just where is the big housing bubble in Seattle, in the data? The closer I look at the numbers, I just don't see it.
For example, by Fortune Magazine tells us that the (house price) / (annual rent) ratio in the Seattle metro area is currently 38, whereas the 15-year historical average is 23. To revert to the mean the site predicts that Seattle real house prices will fall by 20%.
But let's check that price/rent ratio of 38. The first rental I see on craiglist is a 4 br 1.5 ba 1970s-style Rose Hill (Kirkland) rambler for $1650 / month. It has an old kitchen and blue & green (i.e. yuck) carpets. ( if the link is still good.) That's a $450K house at the most, so the price/rent ratio is 23, the 15-year historical average. No bubble for this house!
According to the site, the house should be salable at $752K. But never was this house worth that much, not even close. It's a typical rental at a typical rental price. So where in the heck is Fortune getting its figures from?
The median figures so often reported look bogus too. Seattle median house prices have jumped 18% since the end of 2005? Well whatever, because the price of a typical 3 br house has not risen that much since then. Maybe half that much, if that.
What I'd like to see is 30 unremodeled Seattle area houses chosen, and let's find out for ourselves what the actual increase in prices has been since the beginning of 1997, the supposed start of the bubble. Not what is being reported based on seemingly bogus data. The number of houses, 30, should give us a result with a good confidence level. More houses = higher confidence level.
The result should be of interest to most on this site. I'm hoping that we can all pitch in. Here's how:
Using Redfin's past sales search feature, find a typical 3-4 br unremodeled, maintained SFR that recently sold and also sold around Jan. 1997 (plus or minus a year should be okay). Input the previous sale date and previous sale price into a spreadsheet. Input the recent sale date and the recent sale price. Divide the recent sale price by the previous sale price; we'll call the result the gain factor. Subtract the previous sale date from the recent sale date; we'll call the result the number of days. Take the gain factor to the (1 / number of days) power (in Excel, = gain factor ^ (1 / number of days)); we'll call the result the daily factor. Take the daily factor to the power of 365.25, the number of days in a year, and subtract 1 (in Excel, = (daily factor ^ 365.25) - 1); we'll call the result the annualized rate of return. Post it here. Or avoid all the math by just posting the raw data (past & recent dates & prices) and I'll crunch the numbers in one swoop.
I think it's a safe bet that the average annualized rate of return for 30 houses in the Seattle area since about the beginning of 1997 is about 7%, which is a little more than a doubling of prices since then. Zillow thinks the rate is 9.7% for King county for the past 10 years. At that rate a house that sold for $250K in Nov. 1997 would be worth $630K today. I highly doubt that, for an unremodeled house.