There’s Going to Be a Whole Lot of Rubber-Necking Going On…

First of all, a warning. If you’re browsing this post in a car, or while you’re listening to someone blather away on the phone, pull over, mute the line, buckle up, REMAIN CALM. We’ve got some good stuff to tell you about. Really good stuff.

Sometime in the wee hours of the night last night, Redfin upgraded our website to show photos, prices, and all the gory details on every property sold for the past two years, in almost every area we serve. So far, we’ve loaded up 9 million photos of 1.4 million recently sold properties, quadrupling the amount of real estate information we store.

And since we turned on our data slurpers full blast for new past-sales records, the data will keep piling up: within 15 minutes of an agent’s taking a property off the market, you can expect to see the pictures and the price on Redfin’s site. This investment in near-real-time sales history continues our multi-year journey into Freakish Depth, which is our strategy for taking property data to ridiculous extremes of accuracy, freshness and depth. We meet our customers exclusively via our website, and if the site isn’t trustworthy, why would anyone expect the service to be?

Yes, OK, You Do Have to Register…

The only hitch is that outside of the Seattle and Washington DC areas you need to register before going deep. OK, so requiring registration is not normally our style — we’re not looking to spam you or call you out of the blue — but there’s a reason for it. The Multiple Listing Services that share this data with us first want to make sure we’re not posting it everywhere willy-nilly, limiting it instead to the folks who are serious.

But It’s Worth It

Once you’re registered, you can do all sorts of fun stuff, like checking out all the $1M+ homes that sold last week in Los Angeles, San Francisco or Boston. Or do your own search on recent past sales: visit our search page and look underneath the Search Listings button for a More Options link.

More Real Estate Search Options

Clicking that link opens a big search dialog where the options for searching past-sales records appear bottom left:

Real Estate Search Box

After you run a query on past sales, the map fills up with pretty baby-blue icons representing homes that recently sold. Just as with listings, pictures and basic details pop up to the right:

Homes for Sale Map

If you click through the thumbnail picture for more details, you get a staggering amount of detail on the property that just sold, usually all the information the seller’s agent provided when listing the house in the first place — which we then pair with parcel outlines, tax record, automated appraisals and all sorts of other goodies too numerous to include in the screenshot.

3439 KAREN Ave Long Beach CA

Before the upgrade, we only showed public records of recent sales: the most basic facts about the property’s bedrooms and bathrooms, the price, no pictures, all after waiting two to twelve weeks for the records first to get recorded by the county, then aggregated by a data-collection service and then syndicated out to sites like ours. What we have up today is a big improvement.

The Killer Application

But now that we’ve published a near-real-time feed of pictures and details of virtually every recent sale, there’s still the question of what you as a consumer can do with that data. And the first, most obvious application is a Comparative Market Analysis, or CMA. If you’re trying to price a property, you can usually establish a reasonable range by putting together a list of similar properties that sold in the area over the past month or two — use the photos to exclude all the dumps, unless you’re buying or selling a dump — with the same square footage plus or minus 10% — and usually the same number of bedrooms and bathrooms plus or minus one. Then take what each of the comparable properties cost per square foot and multiply it by the square footage of the property in question, sorting the resulting prices from high to low. This is the starting point for any real estate professional to think about a property’s price range.

Now you can take this on yourself, using the same data that agents have, even if later on you still want agent’s help corroborating which comparables you picked and analyzing the results — Redfin agents put together CMAs every day, and don’t expect to stop any time soon. But even if you get a little help, it’s nice to be able to see for yourself what the agent can see, and to go as far as you like on your own.

The Other Big Feature… Trackbacks

The other big new feature in this release is blog trackbacks. Any time a blogger links to a listing on our site, we now link back to the blogger, so consumers can easily see what everybody on the Internet is saying about a house. If a blogger reviews a condo in a new development, any link to that listing on Redfin will generate a reciprocal link from the listing on Redfin back to the reviewer’s site, along with a snippet of text from the review.

Real Estate Trackback

Tying together everything that’s being said about a property can, we hope, socialize the lonely, scary process of buying a home, and it will almost certainly boost the quality and quantity of online discussion. The same trackback technology that almost overnight created the blogosphere’s ecosystem of criss-crossing links  can now nurture the growing number of real estate bloggers — many of them agents — who use Redfin and other brokerage sites as a reference for their real estate discussions.

For the industry, both of these features are a little bit daring. Real estate agents don’t like the idea of some crazy blogger trashing their listings, and most everywhere they have preserved the option for sellers to opt out of any type of blog integration or online commentary. We think opting out is a very bad move, just because social media drives traffic like nothing else to a listing — but we can’t argue with giving the sellers a choice.

Really, it’s impressive that we got this data at all. A long time ago and with plenty of the evidence to the contrary, we made a bet that the industry would become more open, that we could challenge the status quo as a broker without being squashed, that complying with local MLS rules would be worth the extra hassle so we could get information directly from other brokers. This turned out to be a very lucky bet.

You can argue that this version of Redfin would never have happened without last year’s Department of Justice settlement with the National Association of Realtors, which gave online brokers the right to share any data with our customers that an agent can divulge to a customer face to face. Both trackbacks and the newly available past-sales data would not have seen the light of day if not for this settlement. But the hole in that argument is that MLSs not even governed by the settlement nonetheless have agreed to many of the same terms.

We still have plenty of gripes, but the industry is changing for the better. So in addition to the thanks we owe to all the Redfin folks who worked on this gargantuan effort — hats off to the whole team —  we also wanted to thank the other brokers for agreeing to a more open data-sharing policy. We’re excited to see what consumers think of the new policy and the new site.

Discussion

  • Pingback: Tweets that mention There’s Going to Be a Whole Lot of Rubber-Necking Going On… | Redfin Corporate Blog, There’s Going to Be a Whole Lot of Rubber-Necking Going On… | Redfin Corporate Blog -- Topsy.com

    • http://www.bostonbubble.com/ bostonbubble

      Question – when you say “within 15 minutes of an agent’s taking a property off the market, you can expect to see the pictures and the price on Redfin’s site”, will that be the sale price or most recent listing/asking price?

  • http://www.revealrealestate.com Claudia Gonella

    Congratulations on putting more and more data into the hands of the consumer. You inspire our work in Central America. Our goal for increased transparency is the same, but we’re still just at the starting post. Each of your updates shows us just how much further we have to stretch.

  • Brad Cerenzia

    Congrats, Glenn! I am so very happy to see the new additions of sales data and images. Taking the “unknown” fear factor ammo – one of the last sneaky emotional tricks in this trade – away from unscrupulous agents will reduce the stress in buying a home.

  • Pingback: Today’s Website Outage | Redfin Corporate Blog

  • HHinLA

    Thank you very much! I’ve tried to keep track of the specs/info on recent sales, and this looks to make my life easier.

  • Pingback: Top real estate posts of the day for 11/6/2009 : Hassle Free Phoenix Area Home Search

  • ChrisM

    Yet another reason Redfin is the best real estate tool out there. Keep tearing down the walls.

  • zoomom

    Fantastic! Redfin is my favorite site, and it just got better. I used to use Sawbuck for sales data because they have photos and data on sold houses, but they’ve never had as much detail as the Redfin site. Best of luck to Redfin! I hope you spread out all over the U.S.

  • Miguel Aguilar

    GREAT JOB!!
    This will help answer many questions giving the consumer much control, love it!!

  • Andrew

    You guys are the best!! Consumers need this type of info to make more informed decisions. I always recommend your site for anyone that is looking to buy or sell a home. Thank you and your team for doing a fantastic job.

  • Pingback: A Few Good Databases… | Redfin Corporate Blog

  • http://www.500realty.net Ray Pepper

    Outstanding!

  • http://www.mbconfidential.com MBWatcher

    I love the notion of the trackbacks to blog posts (of course, it’s what I do). Are the Redfin spiders going to automatically go thru my site and pick up all the past references (in the low thousands) or should I be doing this by hand?

    And for new posts, is there a clear, clean way we can be broadcasting new posts so that we get those trackbacks listed ASAP? I do a regular feature each weekend on open houses in the neighborhood and you’ll see 3-10 new links/reviews from that story alone… It’d be great if I knew that material would be picked up for trackbacks!

  • http://www.redfin.com Jim

    Hi MBWatcher,
    We don’t have plans right now to automatically crawl the net and generate trackbacks. It’s a tough problem to solve and still deal with spam and duplicate links. We may look into doing this for a few select sites with lots of links to Redfin (such as yours) in the future.

    In the meantime, posts are automatically picked up from blogging platforms that do auto-trackbacks and/or pingbacks such as WordPress and Movable Type. Unfortunately, Blogger does not support automatic trackbacks. Your options are to click on the “Add your post to this page” link on each Redfin listing you link to and fill out that form. Since some of your posts have many links, there are a few solutions out there for sending multiple trackbacks out at once for the same page. Here is one: http://andybeard.eu/804/haloscan-how-to-send-a-trackback-with-blogger-part-1.html

    The trackback URL you should ping is always just the normal Redfin url with “/trackback” appended. Email me at jim.lamb (at) redfin if you have other questions.

  • http://epartnerusa.com Donald Teel

    This is the sort of consumer-centric value proposition often absent in traditional models.

    The packaging of property information with transparent access by the consumer is something NAR and its myriad local Associations should be pursuing and Broker-Owners demanding.

    Our profitless brokerage models could find new revenue models through both property and local information bundling.

    Nice job to the folks at Redfin.

    Donald Teel – Founder
    e-Partner
    http://www.ePartnerUSA.com

    REALonomics
    http://www.REALonomics.net
    928.777.8100

  • Pingback: redfin.com Quadruples its Data | Property Portal Watch

  • http://www.mbconfidential.com MBWatcher

    Thanks Jim, you guys are cool.

    I am still adjusting to the new world you’ve created here with showing so much more detail on solds and even pending listings. I haven’t been able to show that stuff to my readers before now, and it was an odd gap. Thanks!

  • Pingback: Redfin Posts Sales Data Within Minutes of Being Marked Sold on MLS

  • Brandon Carr

    I think this could cause security concerns for the new homeowners because it offers to much details about your property after you become the owner. Consideration should be give and an option to remove any photos! I requested my property photos to be removed but got no response back from Redfin.

  • Luis

    Very nice upgrade. Recently sold data is key when deciding what to bid on a home. One observation with Redfin’s data is that the sold price listed does not seem to adjust for seller subsidies. Why not? Is this something that Redfin plans on adding in the future?

  • Pingback: One Week After The Outage | Redfin Developers’ Blog

  • Pingback: See Recent Sales on Redfin | urbnlivn on Seattle condos

  • Pingback: November Newsletter: Markets Holdin’ Steady (Happy Thanksgiving!) | Redfin Corporate Blog

  • http://rapidshare.com/files/316306647/173518931.rar unsuraDrealay

    Info:
    An antisocial maverick doctor who specializes in diagnostic medicine does whatever it takes to solve puzzling cases that come his way using his crack team of doctors and his wits.
    Download House M.D. Season 6 Episode 10 http://rapidshare.com/files/316306647/173518931.rar S06E10

  • Pingback: And The Top Redfin Blogger For January Is… | Redfin Corporate Blog

  • Pingback: Redfin Expands to Phoenix, Launches New Listing Service | Redfin Corporate Blog

  • inhervetret

    Hi
    I am a newbie here.
    Glad to find this forum…as what I am looking for

  • http://boqueteforsale.com Boquete Real Estate

    Great blog! I wish we had some of these tools here in Panama. The real estate industry is still in its infancy here. It is frustrating sometimes, but everyday we break new ground and that adds an element of excitement to each day.

  • Pingback: redfin.com Quadruples its Data