Mid-February Market Snapshot Map

Time for another sweet market status Tableau map.

This time I’ve taken all the active listings as of February 17th and all the closed sales between January 1st 2010 and February 17th 2011, and slapped them all onto the same map. Crazy!

Click any zip code’s circle to update all the pies and bars below the map to show you the specific stats breakdown for that zip code. I’ve broken down the ratios of bank-owned, short sale, and non-distressed listings and sales as well as the median price and days on market for each bucket as well.

The circles are color-coded based on how “distressed” the listings and sales in the given zip code are. Zip codes that are less than 10% distressed are shades of blue, while over 10% is darker and darker red. Not a lot of blue out there.

Interestingly, the zip codes with the most activity also seem to be the ones where the largest percentages of homes being sold are bank owned. The basic story seems to be that it’s hard to move the non-distressed inventory.

Please be patient. This viz is pretty big, so it may take a few seconds to load and to react to your click when you select a zip code.

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.


  1. 1

    Why Pay Full Price at Restaurants During This Great Recession Weekend

    When you can use a BOGO coupon for a lion’s share of restaurants anyway, even Dennys now.

    Same thing with houses, cars, boats, planes, etc….if you’re paying retail you either have money to flush down the toilet or you buy anything the salesmen tell you is a good deal.

  2. 2
    doug says:

    We finally had our short sale go through… It was an ordeal, but we got the house we wanted for the price we wanted when all was said and done.

  3. 3
    jlb says:


    Edit: I take it back. The duplicates have disappeared after I resorted the data. I imported the data into google docs, which I assume is the problem…never had that problem before.

    I downloaded the raw data and I see a number of duplicate entries (at least based on the listing id and/or the property id). Are these actually duplicates? Is that reflected in your data, or is it an artifact of how I got the data somehow?

  4. 4
    The Tim says:

    RE: jlb @ 3 – Must be something with how you downloaded it. My source spreadsheet doesn’t have any duplicate ids.

  5. 5
    jlb says:

    RE: The Tim @ 4

    I edited the original post–you’re right. I think google docs was misbehaving. Sorry for the confusion.

  6. 6
    Devmud says:

    Tim, The posting is highly informative and helps a lot for the people to understand the market. Thanks:)

  7. 7

    […] distressed properties are affecting things, that’s nothing new here either. Go drop by the market snapshot explorer I posted a couple weeks ago and see for yourself how much cheaper the bank-owned and short sale […]

  8. 8

    […] are we looking at something that could be explained by short sales and bank-owned homes making up an increasingly larger percentage of sales?Posted in Counties, Statistics | Tagged list-price, sale-price, sale-to-list Posted by: The Tim Tim […]

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.