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.
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.

Big News: Ignore all that fine print, tear through all that red tape — Redfin.com supports Safari at last! | BloodhoundBlog: Real estate marketing and technology blog | Realtors and real estate, mortgages, lending, investments said:
[…] Elsewhere: Michael Arrington, Glenn Kelman. […]
January 31, 2008 7:14 AM
What’s Hot and What’s Not | Redfin San Francisco Sweet Digs said:
[…] we get to today’s post, let me point out that Redfin rolled out its new version today. New fonts, new layout, much larger map, the addition of eAppraisal.com, as well as nearby similar […]
January 31, 2008 9:07 AM
Galen said:
Nice new features.
January 31, 2008 10:50 AM
agentgenius.com- national real estate opinion column » Blog Archive » GenY & Why Redfin Works said:
[…] challenge kids are having as they enter the workforce- why am I not the boss, I deserve it?!?With the recent Redfin press release, several blogs have picked up on particular points of interest that add to my argument that Redfin […]
January 31, 2008 12:47 PM
Selly said:
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
January 31, 2008 12:54 PM
Comp Homes from your Mac Baby said:
[…] Redfin today launched version 4.4 of the website. Many of my friends and colleagues worked incredibly hard on making this release happen. After it launched this morning, I received an email from one of my co-workers which said “Wow! I feel like an idiot for only thinking this was a *big* release. This is a *huge* release.” And huge it was. Here is a synopsis: […]
January 31, 2008 4:15 PM
Firefox User said:
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.
January 31, 2008 7:20 PM
Sasha said:
@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.
January 31, 2008 10:00 PM
laxtosnoco said:
I love the new updates! My favorite is the neighborhood ‘outline’ feature.
January 31, 2008 10:49 PM
Free (or Price Reduced) Ballard | Redfin Seattle Sweet Digs said:
[…] you can be advised of new homes and price reductions in your neighborhood of choice. Check out the freakish depth of the new and improved Redfin at the Corporate […]
February 1, 2008 12:32 AM
Rabbid said:
This is very good work! Love all aspect of it. Excellent web team!!
February 1, 2008 8:01 AM
Seeking “An Active Urban Lifestyle Within A Small Footprint? Rush to Rockride | Redfin San Francisco Sweet Digs said:
[…] live if she didn’t live in the bigger, buzzier Islington, London). (Thank you Redfin for your new search-by-neighborhood facility which makes producing maps like the one below so […]
February 1, 2008 9:57 AM
Jaime said:
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.
February 2, 2008 7:39 AM
Sasha said:
@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.
February 2, 2008 5:52 PM
Sean said:
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…
February 2, 2008 11:37 PM
Glenn Kelman said:
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.
February 3, 2008 9:44 AM
The 1st & 2nd Moments of Consumer Delight | Redfin Corporate Blog said:
[…] Washington, D.C. « A Safari into Freakish Depth […]
February 3, 2008 3:18 PM
Some Cool New Redfin Site Features | Redfin Los Angeles Sweet Digs said:
[…] the whole list of new features, here’s the post on the Redfin corporate blog from the president of […]
February 3, 2008 10:03 PM
Dumb and Dumber | Redfin San Diego Sweet Digs said:
[…] I want all potential home buyers to know that everything they need to make an educated decision is right there at their fingertips. Information is so readily available on most properties, that you can literally do an analysis […]
February 4, 2008 8:17 AM
Tom Swell said:
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.
February 4, 2008 12:34 PM
Reena said:
Thanks for finally supporting Safari and we love the new features, keep them coming!
February 5, 2008 1:29 PM
DiscoverSD Travel Blog » Blog Archive » Dumb and Dumber said:
[…] I want all potential home buyers to know that everything they need to make an educated decision is right there at their fingertips. Information is so readily available on most properties, that you can literally do an analysis […]
February 6, 2008 12:31 AM
Love and War in the Modern Age | Redfin San Diego Sweet Digs said:
[…] week we launched a new version of our website. With each new innovation comes more interest in our smart and simple approach to buying and […]
February 6, 2008 6:28 AM
kristi said:
great new features!
February 6, 2008 4:52 PM
Redfin Supports Safari! Um, kinda… | Redfin Developers’ Blog said:
[…] As of January 31, 2008, Redfin supports Safari 3 without any of this trickery. We’ll leave the post here for the curious, but in the […]
February 7, 2008 6:14 PM
Craig Davidenko said:
Glenn, I would like to talk to you about flatraterealestate.com
Craig Davidenko
March 3, 2008 9:01 AM
The Little Website That Could | Redfin Corporate Blog said:
[…] we will soon. the whole idea behind our strategy of Freakish Depth is that doing deals can give us market insights to share with everyone. As Redfin CTO Michael Young […]
March 4, 2008 7:27 PM
Craig Davidenko said:
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…..
April 24, 2008 7:57 AM
All the Homes for Sale (Well, Nearly All) | Redfin Corporate Blog said:
[…] this all add up to? As our press release explains, the new version takes us deeper and deeper into Freakish Depth, which is our strategy to build the best real estate site by getting the best data. Because we’re […]
April 30, 2008 12:39 PM
I Want My… I Want My… I Want My Comaprable Market Analysis | Redfin Corporate Blog said:
[…] few months back, we released a new version of the site that let our customers download listing stats and past sales data to a spreadsheet. Then last […]
May 16, 2008 12:27 PM