Author: Tim Ellis


Tim Ellis has been analyzing the real estate market since 2005, and has been with Redfin since July 2010, currently as a Real Estate Analyst (or Real Estate Scientist, when he's feeling more punchy). He combines an engineering background with a strong consumer-minded interest in real estate to provide a unique perspective on the real estate market. He has also run the independently-operated Seattle-area real estate website Seattle Bubble since 2005, which is the region's most popular real estate news website.



Recent posts



April 16, 2012

Case-Shiller: A Mild Winter for Home Prices

It’s time (a bit past time, actually) for our monthly check-in of the S&P/Case-Shiller Home Price Indices (HPI). The Case-Shiller data is generally considered to be the most reliable measure of overall home price changes for a region, since they only consider repeat sales of homes when calculating their index, instead of looking at all the homes that sold in a given month.

For the full source data behind this post, hit the S&P/Case-Shiller website. For a more detailed explanation of how the Case-Shiller Home Price Index is calculated, check out their methodology pdf. Also remember that the data released on the last Tuesday of a given month is for the period two months prior (i.e. – December data is released in February).

Here are the basic Case-Shiller stats for the Washington area* as of January:

January 2012
Month to Month: Up 0.7%
Year to Year: Down 0.6%
Prices at this level in: April 2004
Peak month: May 2006
Change from Peak: Down 28.2% in 68 months
Low Tier: Under $268,882
Mid Tier: $268,882 to $442,466
Hi Tier: Over $442,466

Sixteen of the twenty metro areas tracked by Case-Shiller saw a decrease in their HPI between December and January (one less than between November and December): Washington DC joined Phoenix and Miami with an increase. No data was available for Charlotte in January. Oddly, San Francisco had the largest drop at 2.5%.

Here’s a look at the latest local tiered data, back through 2000:

DC Case Shiller Tiers 2012 01 Case Shiller:  A Mild Winter for Home Prices

And here’s a closer look at the recent changes, with the vertical and horizontal axes zoomed in to show just the last year:

DC-Case-Shiller-Tiers_2012-01

All three of DC’s tiers rose in January. Month to month, the low tier was up 1.9%, the middle tier rose 0.9%, and the high tier increased 0.3%.

In this next chart, I’ve visualized the month to month trends of all twenty Case-Shiller-tracked cities. Green and above the horizontal axis if they were increasing in the month charted, red and below the axis if they were decreasing. I’ve excluded 2000 through 2004 since they looked largely the same as 2005 (mostly green).

Case Shiller MoM Gains Losses 2012 01 Case Shiller:  A Mild Winter for Home Prices

Another gain here, with the best January showing since 2006, when 11 markets were increasing.

Read the rest of this entry »


March 2, 2012

Case-Shiller: Washington’s High Tier Took the Biggest Hit in December

It’s time (a bit past time, actually) for our monthly check-in of the S&P/Case-Shiller Home Price Indices (HPI). The Case-Shiller data is generally considered to be the most reliable measure of overall home price changes for a region, since they only consider repeat sales of homes when calculating their index, instead of looking at all the homes that sold in a given month.

For the full source data behind this post, hit the S&P/Case-Shiller website. For a more detailed explanation of how the Case-Shiller Home Price Index is calculated, check out their methodology pdf. Also remember that the data released on the last Tuesday of a given month is for the period two months prior (i.e. – December data is released in February).

Here are the basic Case-Shiller stats for the Washington area* as of December:

December 2011
Month to Month: Down 1.2%
Year to Year: Down 1.6%
Prices at this level in: April 2004
Peak month: May 2006
Change from Peak: Down 28.4% in 67 months
Low Tier: Under $269,692
Mid Tier: $269,692 to $444,098
Hi Tier: Over $444,098

Eighteen of the twenty metro areas tracked by Case-Shiller saw a decrease in their HPI between November and December (one less than between October and November): Only Phoenix (for the third month in a row) and Miami saw an increase. This month Detrioit beat out Chicago and Atlanta for the bottom spot, falling 3.8% in a single month.

Here’s a look at the latest local tiered data, back through 2000:

DC Case Shiller Tiers 2011 12 Case Shiller: Washingtons High Tier Took the Biggest Hit in December

And here’s a closer look at the recent changes, with the vertical and horizontal axes zoomed in to show just the last year:

DC-Case-Shiller-Tiers_2011-12

All three of Washington’s tiers fell in December. Month to month, the low tier was down 0.8%, the middle tier fell 1.0%, and the high tier decreased 1.4%.

In this next chart, I’ve visualized the month to month trends of all twenty Case-Shiller-tracked cities. Green and above the horizontal axis if they were increasing in the month charted, red and below the axis if they were decreasing. I’ve excluded 2000 through 2004 since they looked largely the same as 2005 (mostly green).

Case Shiller MoM Gains Losses 2011 12 Case Shiller: Washingtons High Tier Took the Biggest Hit in December

Tiny improvement, better than a year ago, but worse than December 2009, when 5 cities saw an increase.

Read the rest of this entry »


February 13, 2012

Case-Shiller: Another Winter for Home Prices

It’s time for our monthly check-in of the S&P/Case-Shiller Home Price Indices (HPI). The Case-Shiller data is generally considered to be the most reliable measure of overall home price changes for a region, since they only consider repeat sales of homes when calculating their index, instead of looking at all the homes that sold in a given month.

For the full source data behind this post, hit the S&P/Case-Shiller website. For a more detailed explanation of how the Case-Shiller Home Price Index is calculated, check out their methodology pdf. Also remember that the data released on the last Tuesday of a given month is for the period two months prior (i.e. – November data is released in January).

Here are the basic Case-Shiller stats for the Washington area* as of November:

November 2011
Month to Month: Down 1.1%
Year to Year: Up 0.5%
Prices at this level in: May 2004
Peak month: May 2006
Change from Peak: Down 26.4% in 66 months
Low Tier: Under $282,287
Mid Tier: $282,287 to $458,606
Hi Tier: Over $458,606

Nineteen of the twenty metro areas tracked by Case-Shiller saw a decrease in their HPI between October and November (the same as between September and October): Only Phoenix saw an increase, for the second month in a row. This month Chicago bumped Atlanta out of the bottom spot, falling 3.4% in a single month.

Here’s a look at the latest local tiered data, back through 2000:

DC Case Shiller Tiers 2011 11 Case Shiller: Another Winter for Home Prices

And here’s a closer look at the recent changes, with the vertical and horizontal axes zoomed in to show just the last year:

DC-Case-Shiller-Tiers_2011-11

All three of Washington’s tiers fell in November. Month to month, the low tier was down 3.5%, the middle tier fell 0.7%, and the high tier decreased 0.4%.

In this next chart, I’ve visualized the month to month trends of all twenty Case-Shiller-tracked cities. Green and above the horizontal axis if they were increasing in the month charted, red and below the axis if they were decreasing. I’ve excluded 2000 through 2004 since they looked largely the same as 2005 (mostly green).

Case Shiller MoM Gains Losses 2011 11 Case Shiller: Another Winter for Home Prices

Just five months ago, all twenty cities saw month to month gains. Now just one is not the red.

Read the rest of this entry »


December 29, 2011

Case-Shiller: Seasonal Slide in Home Prices Begins in DC

It’s time for our monthly check-in of the S&P/Case-Shiller Home Price Indices (HPI). The Case-Shiller data is generally considered to be the most reliable measure of overall home price changes for a region, since they only consider repeat sales of homes when calculating their index, instead of looking at all the homes that sold in a given month.

For the full source data behind this post, hit the S&P/Case-Shiller website. For a more detailed explanation of how the Case-Shiller Home Price Index is calculated, check out their methodology pdf. Also remember that the data released on the last Tuesday of a given month is for the period two months prior (i.e. – October data is released in December).

Here are the basic Case-Shiller stats for the Washington area* as of October:

October 2011
Month to Month: Down 0.3%
Year to Year: Up 1.3%
Prices at this level in: May 2004
Peak month: May 2006
Change from Peak: Down 25.4% in 65 months
Low Tier: Under $283,371
Mid Tier: $283,371 to $463,916
Hi Tier: Over $463,916

Nineteen of the twenty metro areas tracked by Case-Shiller saw a decrease in their HPI between September and October (vs. eighteen from August to September): Only Phoenix saw an increase. Wait, Phoenix? Yup, Phoenix. Atlanta fell the most in October (again), falling a whopping 5.0% in a single month.

Here’s a look at the latest local tiered data, back through 2000:

DC Case Shiller Tiers 2011 10 Case Shiller: Seasonal Slide in Home Prices Begins in DC

And here’s a closer look at the recent changes, with the vertical and horizontal axes zoomed in to show just the last year:

DC-Case-Shiller-Tiers_2011-10

Washington’s middle and high tiers fell in October, but the low tier continued to gain. Month to month, the low tier was up 1.1%, the middle tier fell 0.2%, and the high tier decreased 0.5%.

In this next chart, I’ve visualized the month to month trends of all twenty Case-Shiller-tracked cities. Green and above the horizontal axis if they were increasing in the month charted, red and below the axis if they were decreasing. I’ve excluded 2000 through 2004 since they looked largely the same as 2005 (mostly green).

Case Shiller MoM Gains Losses 2011 10 Case Shiller: Seasonal Slide in Home Prices Begins in DC

Just four months ago, all twenty cities saw month to month gains. Now just one is not the red.

Read the rest of this entry »


December 6, 2011

Should I Wait Until Spring to List My Home? – Washington Edition

Over on the national blog, we just posted another big analysis of hundreds of thousands of listings and sales. Here are the numbers for Washington (plus Arlington & Fairfax), where winter is still a winning time to list your home for a quick sale, a better chance of selling, and a better price:

What season should I list my home?


November 30, 2011

Case-Shiller: DC Home Prices Continue to Buck National Trend

It’s time for our monthly check-in of the S&P/Case-Shiller Home Price Indices (HPI). The Case-Shiller data is generally considered to be the most reliable measure of overall home price changes for a region, since they only consider repeat sales of homes when calculating their index, instead of looking at all the homes that sold in a given month.

For the full source data behind this post, hit the S&P/Case-Shiller website. For a more detailed explanation of how the Case-Shiller Home Price Index is calculated, check out their methodology pdf. Also remember that the data released on the last Tuesday of a given month is for the period two months prior (i.e. – September data is released in November).

Here are the basic Case-Shiller stats for the Washington area* as of September:

September 2011
Month to Month: Up 1.2%
Year to Year: Up 1.0%
Prices at this level in: June 2004
Peak month: May 2006
Change from Peak: Down 25.1% in 64 months
Low Tier: Under $278,855
Mid Tier: $278,855 to $460,944
Hi Tier: Over $460,944

Seventeen of the twenty metro areas tracked by Case-Shiller saw a decrease in their HPI between August and September (vs. eleven from July to August): Only Washington DC, New York, and Portland rose. Atlanta fell the most in September, falling a whopping 5.9% in a single month.

Here’s a look at the latest local tiered data, back through 2000:

DC Case Shiller Tiers 2011 09 Case Shiller: DC Home Prices Continue to Buck National Trend

And here’s a closer look at the recent changes, with the vertical and horizontal axes zoomed in to show just the last year:

DC-Case-Shiller-Tiers_2011-09

All three of Washington’s tiers rose in September, but the low tier definitely got the biggest gain. Month to month, the low tier was up 4.7%, the middle tier rose 1.5%, and the high tier increased 0.4%.

In this next chart, I’ve visualized the month to month trends of all twenty Case-Shiller-tracked cities. Green and above the horizontal axis if they were increasing in the month charted, red and below the axis if they were decreasing. I’ve excluded 2000 through 2004 since they looked largely the same as 2005 (mostly green).

Case Shiller MoM Gains Losses 2011 09 Case Shiller: DC Home Prices Continue to Buck National Trend

Just three months ago, all twenty cities saw month to month gains. Now only three have avoided falling into the red.

Read the rest of this entry »


October 25, 2011

Case-Shiller: Summer Continues for Washington-Area Home Prices

It’s time for our monthly check-in of the S&P/Case-Shiller Home Price Indices (HPI). The Case-Shiller data is generally considered to be the most reliable measure of overall home price changes for a region, since they only consider repeat sales of homes when calculating their index, instead of looking at all the homes that sold in a given month.

For the full source data behind this post, hit the S&P/Case-Shiller website. For a more detailed explanation of how the Case-Shiller Home Price Index is calculated, check out their methodology pdf. Also remember that the data released on the last Tuesday of a given month is for the period two months prior (i.e. – August data is released in October).

Here are the basic Case-Shiller stats for the Washington area* as of August:

August 2011
Month to Month: Up 1.6%
Year to Year: Up 0.3%
Prices at this level in: May 2004
Peak month: May 2006
Change from Peak: Down 25.3% in 63 months
Low Tier: Under $275,703
Mid Tier: $275,703 to $454,112
Hi Tier: Over $454,112

Ten of the twenty metro areas tracked by Case-Shiller saw a decrease in their HPI between July and August (vs. two from June to July): Phoenix and Las Vegas. Washington DC. saw the biggest increase this month, followed closely behind by Detroit and Chicago.

Here’s a look at the latest local tiered data, back through 2000:

DC Case Shiller Tiers 2011 08 Case Shiller: Summer Continues for Washington Area Home Prices

And here’s a closer look at the recent changes, with the vertical and horizontal axes zoomed in to show just the last year:

DC-Case-Shiller-Tiers_2011-08

All three of Washington’s tiers rose again in August. Month to month, the low tier was up 3.9%, the middle tier rose 2.5%, and the high tier increased 0.5%.

Here’s a new chart for you. In this one, I’ve visualized the month to month trends of all twenty Case-Shiller-tracked cities. Green and above the horizontal axis if they were increasing in the month charted, red and below the axis if they were decreasing. I’ve excluded 2000 through 2004 since they looked largely the same as 2005 (mostly green).

Case Shiller MoM Gains Losses 2011 08 Case Shiller: Summer Continues for Washington Area Home Prices

The effects of 2009′s homebuyer tax credit are dramatically visible in this chart, as is the fairly strong spring we had this year, hitting 20 cities increasing for the first time since July 2005. However, the sudden drop-off of month-over-month gains in August’s data is interesting, since during a “normal” year we wouldn’t expect to see this many cities in the red until December or January. I think this indicates that there is still quite a bit of weakness in home prices.

Read the rest of this entry »


October 21, 2011

September Insider Report: Washington Sizzles, Baltimore Slips

Greetings, Redfinnians!

Redfin National Heat IndexThis month we rolled out a new and improved version of our monthly insider report. “But where is it,” you ask. Ahh, well this new report is available via email-only, and was sent out to a group of registered users who have saved searches or favorites in select neighborhoods.

We’ll be expanding the report to include more neighborhoods every month, so if you want to make sure you get it when it comes to your ‘hood, just make sure you’re signed up for our newsletters (check the “Redfin Announcements” box in your Account Settings), and save a favorite home or a search. That’s it, you’re signed up!

Here on the blog we will continue posting the “lite” version of our monthly report, including our Redfin Heat Index, the heat map, and the hottest / coldest neighborhoods for the foreseeable future. So, let’s get into it.

First up is our national Redfin Heat Index* ranking table at right. Washington maintained its position at the top of the list, while Baltimore fell from #2 in August all the way down to #12 in September. Dang.

Meanwhile, Long Island is still pulling up the rear with falling prices and a dramatic 11.1 months of supply. Yikes!

Next up, let’s have a look at an update to our interactive Redfin Heat Index map broken down by zip code, based on September data. Note that we only calculate the Redfin Heat Index for zip codes with at least 20 sales in September 2011 and September 2010, and as we head into the winter that means more and more zip codes will be grey with “not enough data,” but you can still click them to see sale and listing stats for each zip code. If a zip code is missing from the map, there weren’t even five sales in that zip code in the month.

Heat Map Color Legend

All righty, that’s it for this month. Stay tuned as our new and improved local Insider Report makes its way to your neighborhood.

As usual, you can download our comprehensive spreadsheets for Washington and Baltimore and dig into the data for yourself. Inside you’ll find county, city, and neighborhood information galore. You can also liven up the place by posting a comment below.

*Methodology
The Redfin Heat Index (Beta) uses listings, sales, and price changes to determine the relative “heat” of a given real estate market. We set a baseline Heat Index of 75.0 at 6.0 months of supply and +5 % price change year-over-year.
Every percentage point increase in prices above the 5% baseline will increase the heat index by two points, every percentage point decrease in prices below the 5% baseline will decrease the heat index by two points.
Every one month of supply increase above the 6.0 baseline will decrease the heat index by seven points, every one month of supply decrease below the 6.0 baseline will increase the heat index by seven points.
Here’s the formula:
  • MOS = Months of Supply: End of Month Inventory / Closed Sales in the Month
  • $YOY = Year-over-year change in the median price per square foot.
  • Heat Index = ((MOS – 6.0) * 7) + (($YOY – 5%) * 2) + 75

September 27, 2011

Case-Shiller: Summer is Kind to Washington Home Prices

Before we get going with this month’s Case-Shiller post, I’d like to apologize for the lack of an update last month. Long story short, this particular duty slipped through the cracks while I was out on leave. We heard from a number of readers who were lamenting the missing post. Rest assured, we have heard you and it will not happen again!

It’s time for our monthly check-in of the S&P/Case-Shiller Home Price Indices (HPI). The Case-Shiller data is generally considered to be the most reliable measure of overall home price changes for a region, since they only consider repeat sales of homes when calculating their index, instead of looking at all the homes that sold in a given month.

For the full source data behind this post, hit the S&P/Case-Shiller website. For a more detailed explanation of how the Case-Shiller Home Price Index is calculated, check out their methodology pdf. Also remember that the data released on the last Tuesday of a given month is for the period two months prior (i.e. – July data is released in September).

Here are the basic Case-Shiller stats for the Washington area* as of July:

July 2011
Month to Month: Up 2.4%
Year to Year: Up 0.3%
Prices at this level in: May 2004
Peak month: May 2006
Change from Peak: Down 25.2% in 62 months
Low Tier: Under $279,534
Mid Tier: $279,534 to $459,066
Hi Tier: Over $459,066

Only two of the twenty metro areas tracked by Case-Shiller saw a decrease in their HPI between June and July (vs. none from May to June): Phoenix and Las Vegas. Weirdly, Detroit saw the biggest increase, followed by Minneapolis.

Here’s a look at the latest local tiered data, back through 2000:

DC Case Shiller Tiers 2011 07 Case Shiller: Summer is Kind to Washington Home Prices

And here’s a closer look at the recent changes, with the vertical and horizontal axes zoomed in to show just the last year:

DC-Case-Shiller-Tiers_2011-07

All three of Washington’s tiers saw a sizeable boost in July, with the low tier leading the pack. Month to month, the low tier was up 5.3%, the middle tier rose 2.9%, and the high tier increased 1.2%.

Read the rest of this entry »


July 29, 2011

Case-Shiller: Spring Continues for Washington Home Prices

It’s time for our monthly check-in of the S&P/Case-Shiller Home Price Indices (HPI). The Case-Shiller data is generally considered to be the most reliable measure of overall home price changes for a region, since they only consider repeat sales of homes when calculating their index, instead of looking at all the homes that sold in a given month.

For the full source data behind this post, hit the S&P/Case-Shiller website. For a more detailed explanation of how the Case-Shiller Home Price Index is calculated, check out their methodology pdf. Also remember that the data released on the last Tuesday of a given month is for the period two months prior (i.e. – May data is released in July).

Here are the basic Case-Shiller stats for the Washington area* as of May:

May 2011
Month to Month: Up 2.4%
Year to Year: Up 1.3%
Prices at this level in: May 2004
Peak month: May 2006
Change from Peak: Down 26.4% in 60 months
Low Tier: Under $282,907
Mid Tier: $282,907 to $457,994
Hi Tier: Over $457,994

Only three of the twenty metro areas tracked by Case-Shiller saw a decrease in their HPI between April and May (down from 7 in April and 18 in March). Boston ousted DC for the biggest increase, gaining 2.7% on the month. Only Tampa, Las Vegas, and Detroit continued to fall.

Here’s a look at the latest local tiered data, back through 2000:

DC Case Shiller Tiers 2011 05 Case Shiller: Spring Continues for Washington Home Prices

And here’s a closer look at the recent changes, with the vertical and horizontal axes zoomed in to show just the last year:

DC-Case-Shiller-Tiers_2011-05

The middle tier got the biggest boost in May, while the low and high tier were roughly evenly matched. Month to month, the low tier was up 1.7%, the middle tier rose 2.5%, and the high tier increased 1.8%.

Read the rest of this entry »


close