Seattle Bubble

News & discussion about real estate & the housing bubble in the Seattle area.

Seattle Bubble - News & discussion about real estate & the housing bubble in the Seattle area.

Entries Tagged as 'graphs'

October Seasonally-Adjusted Active Supply by Neighborhood

By The Tim on November 17th, 2009 at 12:33 PM · 15 Comments

Let’s check in on our October monthly neighborhood update to Seasonally-Adjusted Active Supply (SAAS). For an explanation of what seasonally-adjusted active supply is, please refer to this post. Also, you may view a map of the areas discussed in this post.

As usual, the sweet interactive data visualizations (new and improved!) in today’s post come to you courtesy Tableau Software.

In the charts below I have taken the calculated value for SAAS and subtracted 2, in order to better visualize the difference between a buyer’s market and a seller’s market. Using this method, negative SAAS values indicate a seller’s market, while positive values indicate a buyer’s market.

Summary

King County’s overall SAAS continued to drop below the “balanced” level, coming in at 1.59 for October (September was 1.80). 18 of 30 areas came in below 1.75 as seller’s markets (over half for the first time in recent years), Only 1 of 30 came in above 2.25 as a buyer’s market, and the remaining 11 were more or less balanced between 1.75 and 2.25.

Hit the jump for the rest of this month’s interactive charts and commentary.

[Read more →]

→ 15 CommentsCategories: Statistics
Tags: , , , , ,

Puget Sound Counties Interactive October Update

By The Tim on November 13th, 2009 at 6:00 AM · 51 Comments

Let’s take a look at October NWMLS statistics from around the sound. As usual, courtesy Tableau Software, the Around the Sound update is rocking sweet interactive data visualizations.

Feel free to download the old charts in Excel 2007 and Excel 2003 format. To get specific info about a certain point on any graph in the post below, float your mouse pointer over the data.

Before we get to the cool stuff, here’s the usual table of YOY stats for each of our seven covered counties as of October 2009.

October 2009 King Snohomish Pierce Kitsap Thurston Island Skagit Whatcom
Median Price 3.7% 12.3% 10.3% 0.4% 10.7% 7.0% 10.1% 5.0%
Listings 19.7% 23.8% 22.8% 26.1% 14.5% 7.3% 4.2% 10.1%
Closed Sales 33.3% 42.5% 24.0% 5.5% 5.7% 26.8% 9.0% 19.0%
Seasonally Adjusted Active Supply 1.6 1.8 1.7 1.6 1.6 1.7 2.0 1.8

Summary

Hit the jump for the rest of this month’s interactive charts.

[Read more →]

→ 51 CommentsCategories: Statistics
Tags: , , , , , , , , , , , , , ,

Quick Look: October 2009 in Bar Charts

By The Tim on November 10th, 2009 at 6:00 AM · 32 Comments

Here’s another installment of “quick look,” a series of posts in which I present a fresh set of charts for some recent data with minimal commentary.

Today’s theme is King County SFH October stats in bar charts compared to each October since 2000.

King Co. SFH Closed Sales: October

King Co. SFH New Listings: October

King Co. SFH End of Month Active Listings: October

Note that the definition of “Active Listings” was revised in July 2008 to exclude certain listings.

King Co. SFH MOM Price Change: October

King Co. SFH YOY Price Change: October

→ 32 CommentsCategories: Statistics
Tags: , , , , ,

Puget Sound Counties Interactive September Update

By The Tim on November 2nd, 2009 at 8:00 AM · 5 Comments

Whoops, sorry this is late. It took a little extra time to put together this month, as I finally switched the data over from months of supply to Seasonally Adjusted Active Supply. So, let’s have our September data checkup of NWMLS statistics from around the sound. As usual, courtesy Tableau Software, the Around the Sound update is rocking exclusive interactive data visualizations.

Feel free to download the old charts in Excel 2007 and Excel 2003 format. To get specific info about a certain point on any graph in the post below, float your mouse pointer over the data.

Before we get to the cool stuff, here’s the usual table of YOY stats for each of our seven covered counties as of September 2009.

September 2009 King Snohomish Pierce Kitsap Thurston Island Skagit Whatcom
Median Price 7.9% 11.1% 8.2% 4.6% 2.8% 1.8% 2.0% 8.7%
Listings 19.4% 23.6% 25.8% 25.1% 15.8% 2.0% 4.9% 9.7%
Closed Sales 14.3% 14.6% 12.4% 14.5% 1.5% 11.5% 20.9% 19.3%
Seasonally Adjusted Active Supply 2.0 2.1 1.8 2.0 1.9 2.5 3.0 1.5

Hit the jump for this month’s interactive charts.

[Read more →]

→ 5 CommentsCategories: Statistics
Tags: , , , , , , , , , , , , , ,

September Seasonally-Adjusted Active Supply by Neighborhood

By The Tim on October 29th, 2009 at 6:00 AM · 5 Comments

Let’s check in again on our regular monthly neighborhood update to Seasonally-Adjusted Active Supply (SAAS). For an explanation of what seasonally-adjusted active supply is, please refer to this post. Also, you may view a map of the areas discussed in this post.

As usual, the sweet interactive data visualizations (new and improved!) in today’s post come to you courtesy Tableau Software.

In the charts below I have taken the calculated value for SAAS and subtracted 2, in order to better visualize the difference between a buyer’s market and a seller’s market. Using this method, negative SAAS values indicate a seller’s market, while positive values indicate a buyer’s market.

Summary

King County’s overall SAAS dropped further below the “balanced” level, coming in at 1.80 for September (August was 1.88). 11 of 30 areas came in below 1.75 as seller’s markets, 5 of 30 came in above 2.25 as buyer’s markets, and the remaining 14 were more or less balanced between 1.75 and 2.25.

Hit the jump for the rest of this month’s interactive charts and commentary.

[Read more →]

→ 5 CommentsCategories: Statistics
Tags: , , , , ,

Case-Shiller: Seattle Still Being Left Out of the Summer Party

By The Tim on October 27th, 2009 at 7:01 AM · 97 Comments

It’s that fun time of the month once again. That’s right, time for the latest data from the Case-Shiller Home Price Index. According to August data,

Up 0.1% July to August.
Down 0.2% July to August (seasonally adjusted)
Down 14.7% YOY.
Down 22.2% from the July 2007 peak

Last year prices fell 0.7% from July to August (not seasonally adjusted) and year-over-year prices were down 8.8%.

Once again, here’s a little dose of sanity to contrast with what is no doubt set to be a day full of crowing and hoopla over the month-to-month increases seen in most of the 20 cities tracked by the Case-Shiller index.

Case-Shiller HPI: Month to Month Change

It still looks as though Seattle is being somewhat left out of this party.

Here’s our offset graph, with L.A. & San Diego time-shifted from Seattle & Portland by 17 months. Look at SoCal’s year-over-year skyrocketing back up to zero. Portland came in at -12.5%, and now both Los Angeles at -12.0%, and San Diego at -8.9% came in better than Seattle.

Case-Shiller HPI: West Coast

Note: This graph is not intended to be predictive. It is for entertainment purposes only.

Here’s the graph of all twenty Case-Shiller-tracked cities:

Case-Shiller HPI: All Cities

In July, fourteen of the twenty Case-Shiller-tracked cities experienced smaller year-over-year drops than Seattle (vs. twelve last month). Dallas at -1.2%, Denver at -1.9%, Cleveland at -2.8%, Boston at -4.2%, Washington, DC at -7.9%, Charlotte at -8.6%, San Diego at -8.9%, New York at -9.6%, Atlanta at -10.6%, Los Angeles at -12.0%, Portland at -12.5%, San Fancisco at -12.5, Chicago at -12.7%, and Minneapolis at -13.7%. Vegas took the #1 spot again for the largest year-over-year drop, with prices still falling over 30% in a single year down there—stimulus? What stimulus?

Here’s an update to the peak-decline graph, inspired by a graph created by reader CrystalBall. This chart takes the twelve cities whose peak index was greater than 175, and tracks how far they have fallen so far from their peak. The horizontal axis shows the total number of months since each individual city peaked.

Case-Shiller HPI: Decline From Peak

In the two years and a month since the price peak in Seattle prices have declined 22.2%. Definitely seems to be stuck moving sideways.

Here’s a complimentary chart to that last one. This one shows the

Case-Shiller HPI: Bounce Since March 2009

With just a 0.3% increase since March, the summer of stimulus seems to be having little effect on Seattle home prices. But hey, at least we’re not as immune to stimulus as Vegas apparently is. Down 9% in just the last five months. Ouch!

The following chart takes the post-bubble years of 2007, 2008, and 2009 and indexes each January’s Case-Shiller HPI to 100 so we can get a picture of how this year’s declines compare to last year:

Post-Bubble Seattle Case-Shiller HPI by Year

Thanks to the tax credits, abnormally / artificially low interest rates, and lots of hype about a so-called recovery, it would seem that we have pulled 2009 into slightly better territory than 2008.

Lastly, here’s an update to the Case-Shiller vs. NWMLS median chart. The following chart shows Seattle-area 2009 home prices, indexed to January = 100, as reported by the NWMLS (using a 3-month rolling average) and by Case-Shiller.

Seattle Case-Shiller HPI and NWMLS SFH Median

Check back tomorrow for a post on the Case-Shiller data for Seattle’s price tiers.

(Home Price Indices, Standard & Poor’s, 10.27.2009)

→ 97 CommentsCategories: Statistics
Tags: , , , ,