The biggest users of the open data movement are, in fact, real estate professionals. It's companies like Trulia and Estately and Zillow and what not that are actually taking open data from government and putting it to good use. It'd be interesting to see some kind of startup come out of this. Though it's fairly hands-on, real estate is still a fairly hands on market, and with real estate lobbying being what it is, it…
Don't forget http://www.redfin.com ; their presentation of properties with the associated public data is beautiful. No association, just a huge fan.
A few years ago, I shopped for a home in an area that Redfin serviced. The data they had and the way the presented it made it easy to find the house we wanted, and figure out what we would be comfortable paying for it.
A few weeks ago we closed on a house in a non-Redfin serviced area. The shopping experience was night and day. Here, none of the local MLS databases, or Zillow or Truila, list things like past purchase prices, and even generally hide past listing prices. I'm not sure if that has to do with local regulations here (ID) vs. the last place we tried to buy a house (CA), or if it's something specific to Redfin.
Either way, buying a house in a non-Redfin service area involved quite a few extra trips to the local courthouse, and made me really appreciate the data it offers.