mark nottingham

The Flipperdex

Monday, 16 October 2006

I’ve been playing with sales data for houses in the Bay area for a while, and have always wanted to come up with an index of same-home sales — reputed to be one of the more accurate ways to do an index, because you’re not having to compensate for differences in intrinsic value between different houses.

I’m kind of stuck on that*, but in the meantime, the Flipperdex is a list of same-house sales in the Bay area, sorted by annualised gain.

I’ve filtered out sales where the square footage or build year of the house changes (figuring it to be the result of a teardown or an improvement, and therefore not suitable), as well as sales that happen very close together (to avoid capturing corrections in the data). I’ve also tried to get rid of apartments, as much of the data doesn’t include a unit number.

It’s not perfect, of course, but it is very interesting. There are lots of sales where a substantial loss is made; I imagine that these are mortgagee sales and the like. OTOH, there are some with stupendous gains; probably private transactions within a family (or just very astute/lucky investors).

The most interesting, though, is the median. If you scroll to the middle of the page, it looks like the median annualised return for a short-term housing investment in the Bay area over the last few years has been about 22%, not including expenses like transaction costs, interest, upkeep, or property tax (which is substantial in California).

That’s a pretty good return on investment, but not stellar; most self-respecting (if delusional) mutual funds seemed to be claiming that kind of return in the boom, and there was far less hassle in buying one of those.


3 Comments

Tom said:

Very interesting. Any chance you can paginate that 4MB table so it doesn’t kill my browser?

Tuesday, October 17 2006 at 1:27 AM

Richard Veryard said:

Isn’t there a difference between the kind of houses that people live in for a year before moving on, and the kind of houses that people live in for decades?

People who move frequently are going to be attracted to low-maintenance houses. People who intend to settle for a longer period may be attracted to houses with greater character and potential.

Or doesn’t that happen in the Bay area?

Tuesday, October 17 2006 at 2:55 AM