New Market Analysis Tools from Redfin

Redfin rolled out some great new statistical features today that are definitely worth mentioning.

New Redfin StatisticsAutomated market statistics broken down by city, neighborhood, or zip code, with charts showing inventory, price per square foot, and price reduction trends over the last year.

CEO Glenn Kelman announces the new features in a blog post today:

Redfin released a big, beautiful new version of its website last night. For the first time in years, there’s a whole new web page on the site — not just a map and a web page for each property on the map — but a set of graphs, pictures, charts, numbers showing all the pricing trends for each of the 9,000 neighborhoods, postal codes and cities Redfin covers. This is the good stuff, drawn straight from the MLS databases real estate agents use to list properties and the tax rolls that counties use to record sales.

It’s a big deal, because consumers have never had access to reliable real estate data down to the neighborhood level.

Now you can see what’s really going on with your neighborhood’s prices, right now: dollars per square foot, numbers of homes for sale, days on market, price reductions. We split out condos and houses because they’re priced so differently. The pricing graphs show listings and past sales separately, so you get a view of what sellers expect and what they really got.

He also takes the time to go through a few other new features they have rolled out for home shoppers, so definitely go check out his whole post.

To access the spiffy new statistics, just type in a city, zip code, or neighborhood into the Redfin search field, wait for it to populate the map, then click “View [the area you typed] Inventory & Pricing Trends” in the upper-left corner of the map.

These tools are a great resource for figuring out what’s going on in the “hyper local” real estate markets that interest you. Kudos to Redfin for coming out with such great resources for home buyers and sellers to track what’s going on in their own back yard.

0.00 avg. rating (0% score) - 0 votes

About The Tim

Tim Ellis is the founder of Seattle Bubble. His background in engineering and computer / internet technology, a fondness of data-based analysis of problems, and an addiction to spreadsheets all influence his perspective on the Seattle-area real estate market. Tim also hosts the weekly improv comedy sci-fi podcast Dispatches from the Multiverse.


  1. 1
    EconE says:

    One still needs to dig through the sales to see exactly what sold.

    I look at condos and see one sale listed as 3 separate sales at the same price. One for the unit, one for the parking space and one for the storage. I have seen parking/storage spaces that have a $psf listing that uses the square footage of the space but the price of the unit. It tends to skew the $psf average up.

    Redfin also lists commercial sales as condo sales.

    Can’s say who’s fault it is that the data is misleading…but never the less…it’s misleading. Don’t just go off the numbers and charts. Look at the Redfins data and compare it to county records.

  2. 2
    Matt Goyer says:

    Past sale data is a tricky beast. If you see examples of bad sales data please email us the URL for the past sale at and we’ll filter it out.

  3. 3
    deejayoh says:

    someone peed on EconE’s cheerios…

  4. 4
    EconE says:

    lol DJ…

    hey…wait…is that supposed to be “antagonistic”?


  5. 5
    Garth says:

    Why is it for every neighborhood I could think of the listed price per square foot is higher than the sold price per square foot?

  6. 6
    Garth says:

    It actually was the reverse I saw.

  7. 7
    jon says:

    Garth, I’m looking at Seattle overall, and for houses sold price is higher but for condo list price is higher. I was also surprised at how much higher the $/sq ft a condo is than a house.

    Anyway, RAL was right, the bottom of the $/sq ft for houses in Seattle was in March.

  8. 8
    EconE says:

    Here are a few examples for you DJ

    purchase of two adjoining units counted as two separate $1.175mm sales. One sale listed as two.

    another purchase of two adjoining units plus two garage spots listed as four individual sales.


    parking spots…

    $4273 psf for those parking spots. Nope…that doesn’t skew anything. ;o)

    more double units…

    another ???

    unit + garage…

    unit + parking + storage…

    don’t know what this one is…but it’s not a condo.

    another head scratcher…

    Lord only knows what this one is…

    double unit…

    unit + two garage spots…

    more head scratchers…

    another unit + a $7773/psf parking spot

    a $2,345,586 1970’s 722 sf 1BR…

    Not blaming Redfin or Matt Goyer in any way FWIW.

  9. 9
    EconE says:


    There are some nice examples in your spam bucket…my last post didn’t go through.

    feel free to fact check them.

  10. 10
    Richie says:

    The MLS database is extremely misleading. I have seen many homes were re-listed, but the days on the markets re-set to zero. It is a clever-way to cook the book and paint a much brighter ambiance to uninformed buyers. Almost every house in MLS mingles the basement square footage, finished or unfinished as total square footage. Some houses include garage, loft of finished attics as square footage. There are no universal standards for counting the square-footage or days on the market. Worse, a significant number of houses were eventually de-listed (I say more than 70% of the outstanding listed properties nowadays; they improved the final statistics of liquidity.

    Beware of silent dogs and still water.

  11. 11
    The Tim says:

    EconE @ 9,

    Thanks, recovered and restored @ 8.

  12. 12
    deejayoh says:

    I was JK EconE. I know there are a ton of data glitches in the tax records, but I commend the Redfin crew for putting this together. For those who are not inclined to pull records themselves it is a real asset.

    And for the questions about why sold $/Sqft is higher than asking – it’s because so many sales are not going through at the low end (according to Ardell’s comments over at RCG)

    cr@p. thats 2x today I’ve referred to her posts…

  13. 13
    crispy&cole says:

    Rental story coming to a city near you:

    The Arizona Republic. “With more affordable homes entering the rental market, apartment complexes are struggling to sign leases. Between the first quarter of 2007 and the first quarter of 2008, median rents in metro Phoenix’s median rent dropped 9.3 percent to $939, according to apartment-research firm Investment Instruments Corp. It was the steepest decline reported in the 12 largest U.S. metro areas.”

    “‘The single-family rentals are impacting our ability to rent apartments because they are directly competitive,’ said Mike Clow, senior VP for property management at Gray Clow Residential, which owns luxury apartment complexes in Phoenix and Tempe.”

    “Nicholas Ingle, director of capital markets for Phoenix-based Hendricks and Partners, the nation’s largest apartment-sales and research firm, estimates that nearly 9,000 homes are currently in the rental market, far higher than the usual 1,000-2,000.”

    “‘So many of those owners are just desperate to rent them for whatever rent they can get,’ Ingle said. ‘Those homes should be renting for so much more money.’”

    “Compounding that rental situation is the influx of condominium conversions back into the rental market. ‘We still have an oversupply of failed and broken condo conversions and most of the condo conversion units are rentals,’ said Pete TeKampe, VP, investments for Marcus& Millichap. ‘North Scottsdale actually has experienced very high vacancy rates because of the oversupply of condo-conversion units.’”

  14. 14
    biliruben says:

    Great work, Redfin! Sure, there are errors, but kudos for trying, and I’m sure you’ll fine-tune. With EconE’s help of course!

    Hey Matt – can we expect CDOM any time soon?

  15. 15
    Matt Goyer says:

    We are working on a CDOM feature. We hope to show you both the CDOM as well as a complete listing history for the home since its last sale.

  16. 16
    softwarengineer says:


    Home selling innovation with more growth?

    Or today’s conundrum of wage deterioration [come on, I’m on Econ’s side, be fair and take out the top 10% Seattle household incomes and average wages are clearly plummetting] and simultaneous growth with subsequent subprime mess.

    First time home buyers in their 20s and 30s are Seattle dinosaurs? I’d assume the top 10% of Seattle’s household incomes with the wage increases aren’t in the housing market any way [they bought in many years or several decades ago], so eliminate this erroneous moot point data.

  17. 17
    biliruben says:

    Great, Matt! I look forward to it.

  18. 18
    Steve Tytler says:

    While it’s interesting to look at sites like Redfin and Zillow, it’s important to remember that unlike commercial office space, residential real estate is NOT sold on a price-per-square-foot basis.

    There are MANY other factors that affect the value of a house, such as views, waterfront, location on a busy street, etc. etc.

    So take the stats with a HUGE grain of salt.

    Steve Tytler
    Real Estate Columnist
    Everett Herald
    Everett Herald

  19. 19
    Civil Servant says:

    Incidentally, do we know what the figure is or approx. is for the top decile of household income? I would be grateful if anyone could point me towards a breakout of this data. Preferably in-city but per MSA would be informative too.

  20. 20
    EconE says:

    While it’s interesting to look at sites like Redfin and Zillow, it’s important to remember that unlike commercial office space, residential real estate is NOT sold on a price-per-square-foot basis.

    There are MANY other factors that affect the value of a house, such as views, waterfront, location on a busy street, etc. etc.

    So take the stats with a HUGE grain of salt.

    What would be the difference?

    Should I Ignore the fact that some condo’s downtown are wishing for $700+ psf when comps are selling for $600?

    Doesn’t location affect Commercial RE?

    Try picking up an office over at Carillon Point rather than Everett. More expensive no?

    So are the houses and condos….in $’s PSF.

  21. 21
    biliruben says:

    Civil Servant – I did a post on the forums looking at the Census’s Community Survey:

    Both MSA and Seattle specific (and Bellevue).

    To answer your question, 10% of households make 150K or greater in Seattle, or they did in 2005. I think there is more up-to-date info if you follow the link.

  22. 22
    Civil Servant says:

    Sweet! Thanks so much, Bili.

  23. 23
    david losh says:

    I’d just like to mention that this fudfon stuff is a direct result of work Tim’s done here.
    This site has become extremely relevant in the world of Real Estate and in my opinion changed the way people view properties in general.
    The fact other people copy the work is a compliment.
    A further fact is that this site attracts people in an open way, even if they get slammed in the process. I’m kind of missing that openness.

  24. 24
    patient says:

    The power of the internet is slamming down on the real estate industry in full force. About time. Way to go Redfin! ( and Seattlebubble of course ). The Kodak moment ( film or digital ) is here, the ones that do not underastand, accept it and embrace it will struggle.

  25. 25
    being patient says:

    I have to agree that this site has pulled me into reading it. It is interesting to read all the different opinions on this site as well as on other blogs and sites.


    Do you think that these sites make a big difference to people trying to buy or sell real estate? What I am asking is will MOST people take the time to read these blogs before making their decisions?

    For example there are a few different views on this site. However the majority of the views appear to be similiar.

    What do you think?

  26. 26
    patient says:

    What I think? I think Redfin and groundbreaking sites like it will increase their market share rapidly in the next couple of years. Blogs like SeattleBubble can play a role by giving feedback from interrested consumers towards the internet brokers, that what I think. What do you think?

  27. 27
    david losh says:

    After leaving the last comment it seems to me that most people would miss the concept of rodfon. There have always been discount brokerages. The difference is, in the past, the commission was paid after the transaction was done. What Kelman and others did was convince Congress to allow the commission to be disbursed at closing. The rebate can now be paid to the buyer or seller as a portion of costs to be included in the transaction.
    In the process the over all commission system was villified. What everyone had been trying to avoid up to that point was transactions going to the lowest bidder. Paying some one to do business with you works on a volume basis.
    When large Real Estate companies tried to do this many years ago smaller companies cried foul. The term was the “Wal Marts of Real Estate.”
    So the concept of radfon has always been around, Ray is correct it will change the face of Real Estate, not for the better, and now they have new charts and graphs, the concept developed by Tim.

  28. 28
    patient says:

    David, I think it’s the internet that changes the face of Real Estate not discount brokers per say. It’s the power of the internet coupled with alternative business models to the old agent formula. And yes, I think it’s for the better. A lot better

  29. 29
    david losh says:

    It depends on what better means. People complain about the services they receive for 6% commissions. I agree that is a high number for getting nothing. It may be better to pay less for getting nothing.
    The problem is the service people get. The consumer still gets nothing, but pays less for it. The standard then becomes nothing.
    Transparency to me means informed choices. When I look at properties people go with me. I get advice, I use agents in some cases. When I pay an agent I expect value. When I pay I want something of value. When I pay for a second set of eyes I want an eyes on value. I want knowledge, wisdom, experience, and negotiable value.
    Otherwise it’s just colored lights on a computer screen.

  30. 30

    I find myself agreeing with David Losh more and more. Does that mean there’s something’s wrong with me?
    I don’t think it’s the internet per se that’s resulting in the successes of places like Redfin or operation’s like 500 Realty…I think it’s more of a response to the fact that many people were dissatisfied getting nothing for their 6%.
    Believe it or not, there are some lazy and dishonest realtors out there, and that created the opening for a Redfin. People thought ” This guy did nothing for me for my 6%, and he’s a lying weasel to boot.”, and figured they’ve got as much brains and ability to do research as many realtors.
    That said, there are some real estate agents out there willing to do the legwork and the research , have the negotiating skill and know the ropes, and those people are continuing to do well because they’ve earned people’s trust.

  31. 31

    […] new neighborhoods release inspired all sorts of reactions. Many, like The Tim on SeattleBubbleBlog, lauded the new release as “a great resource for figuring out what’s going on in the hyper […]

  32. 32
    RickB says:

    Is comment #18 in violation of the comment policy?

    Also, from now on, no commercial links may be left in the body of the comment. If you want to fill in your business link in the comment form where it says “website,” feel free to do that, and it will be linked to your name. But posts with links to a business in the body of the comment will be edited or deleted. If you want to advertise your business on Seattle Bubble, you need to pay just like everyone else.

Leave a Reply

Use your email address to sign up with Gravatar for a custom avatar.
Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please read the rules before posting a comment.