January 31, 2008

A Safari into Freakish Depth

A gorgeous new version of Redfin.com just went online. The premise of the release is Freakish Depth: to update our website with up-to-the-minute data on every new listing and to provide more information about each listing and its neighborhood than any other website. We still have a long ways to go.Redfin.com Screenshot

But look how far we’ve come! Some of the big changes aren’t easy to see. The first order of business in this release was to increase the frequency with which we draw data from ten Multiple Listing Services (MLSs) in San Francisco, Los Angeles, Orange County and San Diego (we have always had high-frequency updates in markets like Washington DC and Seattle), so that we now check as often as every fifteen minutes for new listings. It took us months to sort through all the feeds.

Just as importantly, we increased the amount of information we display about each listing. Beyond all the MLS-provided details and photos of the property, the county tax records and the Zestimate, we now add:

–> a set of similar listings and recently sold properties,
–> a complete history of any price changes since the listing became active,
–> a second market value estimate from eppraisal.com,
–> local Redfin blog and message board conversations,
–> a detailed overhead image of the lot outline, and
–> photographic bird’s-eye views of the property.

And our favorite feature may be the neighborhood outlines that now set the boundaries of map-based searches. This allows you to analyze the median price, square footage and days on market for your neighborhood, and now too you can download that data to Excel, where you can really go hogwild with formulas and charts. This is an idea we took from one of our user groups.

There are a bunch of little things too, like showing condo icons, and favorites on the map, and unit numbers, and actually making address search work. And because we finished swapping out MySQL in favor of Postgres, which features geospatial indexing, the whole site is screaming fast. What all this means for the true real estate freak is one of the deepest, fastest, most addictive highs on the Internet.

AND DID I MENTION THAT, AT LONG LAST, WE SUPPORT THE SAFARI BROWSER! Or, as a matter of interest, that Safari 3.0 is by a wide margin the browser that renders our site most quickly?

Hats off to Shahaf, Jamie, Arthur, Sasha, Matt, Jane, Dan, Navtej, Michael, Leo, Jeff, Llewellyn, Mose, Bryan, Mike and the rest of the Redfin team for all their awesome work, and to all the customers who helped us too! And even though we complain a lot, we’re grateful too to the Microsoft Virtual Earth team that worked with us on Safari support.

If you have any thoughts on the new site, or suggestions for what we should do next, please just leave a comment!

See the TechCrunch post on Redfin’s new release.


  • If stockmarkte investorstockmraket gameshorting stock markethisstory f the stock anrket if 260/c a karacih etockexhcannge masrket this per 2846/c-816 12. how to read the stock market :
    1728 konh stock markte newsz , learn stock market game. Look at www foreign exchange rates com in metatrader.
    a foreign exchange management act :) :( metatrader tester

    The world stock market value metatrader pivot point http://bohiviteruce.freehostia... metatrader tester, metatrader icusotm.
  • Mike
    The download link might be a little... understated. I only just discovered it, and I'm the guy who walked into the user group talking about parsing nightly email updates into CSV files :).
  • Well I have not heard from anyone at Redfin.....CNBC
    seem to pushing my business flatraterealestate.com- evrything that they mention about the housing market points to "Flat Rate" listings.....
  • Glenn, I would like to talk to you about flatraterealestate.com

    Craig Davidenko
  • kristi
    great new features!
  • Reena
    Thanks for finally supporting Safari and we love the new features, keep them coming!
  • It's a good thing.

    I use Firefox with my Mac at Redfin and that continues to work well. Safari compatibility must have been a lot of work, and it goes to show that Redfin is reaching out to all. While Safari/Mac users may be a minority, Redfin understands that among real estate buyers they are the smart ones who also appreciate the Redfin way.
  • Sean, great feedback! We agree that the better implementation of the feature is to track properties that relisted at a lower price; particularly since re-listing the property also re-sets days on market.

    Look for some of the features you've described in your note later in the year, so far as MLS rules permit.
  • I love the listing price history feature. However, due to the way listings are sometimes manipulated, it's not as useful as it could be. I wish you'd track listing prices even when a home has been off the market for some period of time. I've repeatedly seen a pattern where a house will be listed, then taken off the market for a while, then put back on the market (all without a sale). I believe that with your current system, the listing prices for the earlier listing periods would be lost. From a technical perspective that is probably correct, but from the viewpoint of a potential buyer, it's not really what I want to know -- I want to see what prices the house has been listed at ever since they started trying to sell it. I'm not sure if agents are delisting houses for the purpose of making them not look like they've been on the market as long as they have been, or if there's something else going on (I'm sure that in at least some cases there is), but it certainly makes it harder for buyers to tell what's going on.

    Maybe you could do something like show the history from previous listing periods if there was less than three months between times it was listed. Or, if it was taken off the market without selling during the previous listing (though I've seen one or two cases where the house appears to have been sold for the listing price, then sold back to the previous owner for exactly the same price within a day or less -- not sure what that's about). It seems like you must have that data available (though I don't know if your agreements with the MLSes allow you to show it in this way).

    What I'd really love to see is a history of every time a property has been listed, with every price change, and the outcome of each of those listings. But I suppose that's asking for too much...
  • @Jaime: I agree we need to do a better job about making our icons understandable. We're working on it. I have two answers:

    1) Under the "Change View" menu, there's a map legend that shows you what the various icons mean.

    2) The heart means that the listing is one of your favorites. If you'd like to remove it as a favorite, click on the listing and then click "Remove from Favorites" in the sidepane on the right.
  • Jaime
    Very, very cool new features, but I've spent way too much time trying to find out what the red hearts mean on some properties. It would be nice if there were a quick way to have tracked this down rather than having to find a blog to post to and then have to keep checking this blog again to see if there's an answer...seems like too much work.
  • Rabbid
    This is very good work! Love all aspect of it. Excellent web team!!
  • laxtosnoco
    I love the new updates! My favorite is the neighborhood 'outline' feature.
  • @Firefox User: what are you seeing in Firefox specifically? All of our developers (including me) use Firefox as our primary browser while making the site, so Firefox rendering is pretty important to us.

    That being said, we always make mistakes, and it could be that there's something happening on your machine we've overlooked. If you could forward any more detail about what you're seeing to techsupport@redfin.com, we'd be very grateful. Information such as the exact web address in your browser or a screen shot would also help tremendously.
  • Firefox User
    Your changes are terrible. The pages for individual listings do not render properly at all in Firefox. I've tried them on 3 different computers, and all of them look the same. Really Nasty.
  • Glenn,

    This is an amazing new featureset. I logged in this morning and after playing around for an hour or two last night, I am astounded at how wonderful this shift is.

    Please pass regards and appreciation to the team.

    XOXO,
    Selly
  • Nice new features.
  • Agreed. Nice new features. Good work.
blog comments powered by Disqus
close