Author: Tim Ellis


Tim Ellis has been analyzing the real estate market since 2005, and has been a Product Manager for Statistics and Trends at Redfin since July 2010. 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 run the Seattle-area real estate website Seattle Bubble since 2005, which is the region's most popular real estate news website. He also publishes Sound Housing Quarterly, a quarterly journal of the Seattle-area housing market.



Recent posts



December 29, 2011

Case-Shiller: Seasonal Slide in Home Prices Continues

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 Seattle area* as of October:

October 2011
Month to Month: Down 1.0%
Year to Year: Down 6.2%
Prices at this level in: August 2004
Peak month: July 2007
Change from Peak: Down 30.2% in 51 months
Low Tier: Under $238,273
Mid Tier: $238,273 to $385,378
Hi Tier: Over $385,378

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:

Sea Case Shiller Tiers 2011 10 Case Shiller: Seasonal Slide in Home Prices Continues

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

Sea-Case-Shiller-Tiers_2011-10

All three of Seattle’s tiers fell in October, with the middle tier taking the biggest hit. Month to month, the low tier was down 0.8%, the middle tier fell 1.3%, and the high tier decreased 0.7%.

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 Continues

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? – Seattle 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 Seattle, 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: Get Ready for a Long 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. – September data is released in November).

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

September 2011
Month to Month: Down 1.1%
Year to Year: Down 6.5%
Prices at this level in: September 2004
Peak month: July 2007
Change from Peak: Down 29.5% in 50 months
Low Tier: Under $241,598
Mid Tier: $241,598 to $389,532
Hi Tier: Over $389,532

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:

Sea Case Shiller Tiers 2011 09 Case Shiller: Get Ready for a Long 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:

Sea-Case-Shiller-Tiers_2011-09

All three of Seattle’s tiers fell in September, but the middle tier took the biggest hit. Month to month, the low tier was down 0.9%, the middle tier fell 2.1%, and the high tier decreased 0.7%.

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: Get Ready for a Long Winter for Home Prices

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 Ends Early for Seattle 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 Seattle area* as of August:

August 2011
Month to Month: Down 0.3%
Year to Year: Down 6.1%
Prices at this level in: October 2004
Peak month: July 2007
Change from Peak: Down 28.7% in 49 months
Low Tier: Under $245,416
Mid Tier: $245,416 to $392,755
Hi Tier: Over $392,755

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:

Sea Case Shiller Tiers 2011 08 Case Shiller: Summer Ends Early for Seattle 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:

Sea-Case-Shiller-Tiers_2011-08

Seattle’s low tier did increase a tiny bit in August, but the middle and high tiers both dipped. Month to month, the low tier was up 0.04%, the middle tier fell 0.1%, and the high tier decreased 0.6%.

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 Ends Early for Seattle 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 18, 2011

September Insider Report: Seattle Cooling Slower than Other Cities

Redfin National Heat IndexGreetings, Redfinnians!

As promised, this 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 the Ballard area.

If you’d like to receive next month’s report, 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 in Ballard. 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. As you can see, not much change for Seattle. Despite prices being down and months of supply up slightly from last month, pushing Seattle’s Redfin Heat Index down four points, Seattle moved up one spot on the national ranking, from #12 in August to #11 in September, as other areas fell even further.

Washington DC continues to be the hottest market in the nation, while 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.”

Heat Map Color Legend

Next, let’s have a look at the hottest and coldest Seattle-area neighborhoods in September.

King County’s 5 Hottest Neighborhoods in September

Rank Neighborhood Price Months of Supply Heat
1 Ravenna -2.8% 1.6 90.4
2 Lake City -0.9% 3.0 83.8
3 Delridge +1.2% 4.6 77.2
4 West Seattle -1.1% 4.0 76.7
5 Magnolia -6.3% 3.3 71.5

Delridge making a repeat appearance in the top five, while Magnolia muscles out its neighbor Queen Anne.

King County’s 5 Coldest Neighborhoods in September

Rank Neighborhood Price Months of Supply Heat
1 Rainier Valley -20.9% 4.7 32.2
2 Northwest Seattle -10.0% 5.0 52.0
3 Beacon Hill -6.0% 4.7 62.4
4 Snoqualmie Ridge -7.2% 3.7 67.1
5 Northeast Seattle -10.7% 2.3 69.8

All righty, that’s it for this month. Stay tuned next month for our new and improved Insider Report!

As usual, you can download our comprehensive spreadsheet 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: Only Seattle’s High Tier Gets a Summer Gain

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 Seattle area* as of July:

July 2011
Month to Month: Up 0.1%
Year to Year: Down 6.4%
Prices at this level in: November 2004
Peak month: July 2007
Change from Peak: Down 28.5% in 48 months
Low Tier: Under $247,918
Mid Tier: $247,918 to $395,019
Hi Tier: Over $395,019

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:

Sea Case Shiller Tiers 2011 07 Case Shiller: Only Seattles High Tier Gets a Summer Gain

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

Sea-Case-Shiller-Tiers_2011-07

Only Seattle’s high tier was up in July, and then only slightly. Month to month, the low tier was down 0.7%, the middle tier fell 0.1%, and the high tier increased 0.1%.

Read the rest of this entry »


September 26, 2011

August Insider Report: Seattle-Area Real Estate Market Still Chilled

Redfin National Heat IndexGreetings, Redfinnians!

We’re working on some new changes to our monthly Insider Reports that will bring together the expertise of our local agents with the unique market insights that we dig out of our vast array of real estate data every month.

In the mean time, rather than skipping out on August’s data entirely, here’s a “lite” version of our monthly report, including our Redfin Heat Index, the heat map, and the hottest / coldest neighborhoods.

First up is our national Redfin Heat Index* ranking table at right. As you can see, not much change for Seattle. With prices down eight percent balanced out by a slightly tight 4.2 months of supply, we’re still on the cool end of the scale, but not dramatically lower than most of the other cities Redfin serves.

Washington DC continues to be the hottest market in the nation, while 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 August data. Note that we only calculate the Redfin Heat Index for zip codes with at least 20 sales in August 2011 and August 2010.

Heat Map Color Legend

Next, let’s have a look at the hottest and coldest Seattle-area neighborhoods in August.

King County’s 5 Hottest Neighborhoods in August

Rank Neighborhood Price Months of Supply Heat
1 Capitol Hill +14.0% 2.0 120.7
2 Wallingford +12.6% 1.7 120.5
3 Somerset +4.2% 1.7 103.3
4 Delridge +12.6% 5.5 93.7
5 Queen Anne +1.4% 2.9 89.8

The only real surprise in that hottest list is Delridge. Perhaps homes in Delridge have gotten cheap enough to drive some heat back into that area?

King County’s 5 Coldest Neighborhoods in August

Rank Neighborhood Price Months of Supply Heat
1 Rainier Valley -14.8% 4.9 42.9
2 Beacon Hill -15.0% 4.2 47.8
3 Admiral -9.1% 4.3 59.0
4 Magnolia -13.9% 2.8 59.6
5 Snoqualmie Ridge -8.7% 4.0 61.7

All righty, that’s it for this month. Stay tuned next month for our new and improved Insider Report!

As usual, you can download our comprehensive spreadsheet 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

July 29, 2011

Case-Shiller: Spring Continues for Seattle 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 Seattle area* as of May:

May 2011
Month to Month: Up 1.1%
Year to Year: Down 7.0%
Prices at this level in: October 2004
Peak month: July 2007
Change from Peak: Down 29.0% in 46 months
Low Tier: Under $248,198
Mid Tier: $248,198 to $392,387
Hi Tier: Over $392,387

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:

Sea Case Shiller Tiers 2011 05 Case Shiller: Spring Continues for Seattle 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:

Sea-Case-Shiller-Tiers_2011-05

Seattle’s middle and high tiers had a strong showing in May, but the low tier actually lost some ground. Month to month, the low tier was down 1.0%, the middle tier fell 1.9%, and the high tier increased 1.1%.

Read the rest of this entry »


July 21, 2011

Real Estate Re-Runs (June Insider Report)

Redfin National Heat IndexSo far this summer the real estate market in Seattle is about as exciting as a Matlock Marathon at the High School Prom.

Very few quality, well-priced new listings are coming on the market, and when one finally does, it’s the same story every time as the few buyers that are out there all descend at once and end up bidding against each other.

In lieu of our usual tables full of data on listings, sales, and price, we decided to mix things up a bit this month with a sneak peek at the Redfin Heat Index (Beta)*.

For starters, we developed the table at right, which includes our heat ranking for every market where Redfin has real-time sales data.

That’s interesting (although more so for Washington DC and Long Island than for Seattle), but knowing that the entire Seattle area (King County) is lukewarm probably isn’t a surprise to anyone, and isn’t particularly insightful for those of us that are interested in what’s going on in our own specific neighborhood.

Fortunately, we didn’t stop there. We crunched the numbers for the entire Seattle area and produced an interactive Redfin Heat Index map broken down by zip code:

Heat Map Color Legend

Prices are still falling across most of the Seattle area, and although buyers are scarce, listings are even more rare, which is why you’re seeing some warmth in the map above.

“We’ve felt the effects of low inventory since last year. Everyone is waiting for the next great property to come up for sale, no matter the neighborhood,” explained Redfin Northeast Seattle and Mercer Island Agent Febe Cude. “Buyers are starting to get used to the multiple offer playing field. They understand that when a reasonably priced, turn-key home that fits their needs hits the market, they need to bring their A game.”

We ran the Redfin Heat Index at the neighborhood level and sure enough, Northeast Seattle—Febe’s area of expertise—topped the list of King County’s Top Five Hottest Neighborhoods in June:

King County’s 5 Hottest Neighborhoods in June

Rank Neighborhood Price Months of Supply Heat
1 Northeast Seattle +4.1% 2.0 101.0
2 Lake Union +0.3% 1.9 94.2
3 Wallingford -0.9% 1.6 93.6
4 Northwest Seattle -1.5% 2.7 90.8
5 Queen Anne +5.6% 4.0 90.2

On the other end of the spectrum, here are King County’s Top Five Coldest Neighborhoods in June:

King County’s 5 Coldest Neighborhoods in June

Rank Neighborhood Price Months of Supply Heat
1 Snoqualmie Ridge -13.0% 6.3 36.9
2 Delridge -18.8% 4.1 40.7
3 West Seattle -19.8% 3.6 42.4
4 Cougar Mountain -18.1% 3.6 47.6
5 Northgate -15.7% 4.0 47.6

Of course, in a market like this, comparing relative heats is almost like watching a race between a sloth and a snail, but I digress…

“New listings are slow to hit the market, and buyers are getting frustrated with the inventory,” said Redfin Redmond/Bothell Agent Kurt Pepin. “Buyers are anxious to buy, but are also being very smart about their purchases. The pure emotional buy is gone, while crunching every number possible has become the new norm.”

Speaking of crunching numbers, if you miss the tables of data, don’t fret! You can still download our comprehensive spreadsheet 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

June 29, 2011

Case-Shiller: Spring Arrives in Seattle as Home Prices Rise 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. – April data is released in June).

Here are the basic Case-Shiller stats for the Seattle area* as of April:

April 2011
Month to Month: Up 1.6%
Year to Year: Down 6.9%
Prices at this level in: August 2004
Peak month: July 2007
Change from Peak: Down 29.7% in 45 months
Low Tier: Under $245,631
Mid Tier: $245,631 to $387,144
Hi Tier: Over $387,144

Only seven of the twenty metro areas tracked by Case-Shiller saw a decrease in their HPI between March and April (down from eighteen the previous month). The biggest increase was in Washington DC again with a solid 3.0% gain. Other markets that saw increases above 1% were San Francisco (+1.7%), Atlanta (+1.6%), Seattle (+1.6%), Denver (+1.5%), and Cleveland (+1.2%).

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

Sea Case Shiller Tiers 2011 04 Case Shiller: Spring Arrives in Seattle as Home Prices Rise Again

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

Sea-Case-Shiller-Tiers_2011-04

Seattle’s high tier saw the biggest gain again, while the low tier continued to fall behind. Month to month, the low tier was up 0.5%, the middle tier rose 1.3%, and the high tier increased 1.7%.

Read the rest of this entry »


close