Infometrics Amidst Interesting Times –

Visitors to my website are greeted by Clifford Stoll’s wonderful saying: “Data is not information. Information is not knowledge. Knowledge is not understanding. Understanding is not wisdom.”  I get a huge kick out of working in an industry where all of these elements are constantly swirling and have found several tools exceedingly helpful in differentiating and progressing through them.  Today, a deep-dive on two pieces of graphical data that pack an enormous punch in assessing the current condition of a real estate market.

Let’s imagine that you have a nifty little ranch home built in 1990 with three bedrooms and a pair of full bathrooms comprising 1,800 square feet on a 6,000 square foot lot.  You’ve added some members to your family since buying it and just landed a better job with a longer commute, so the idea of moving has made its way to the center of your attention.  You know that real estate has become more expensive over the recent past but, beyond that, you’ve had your mind on other things.  Now, you need to get a handle on the market in order to make some informed decisions.


First, you’ll want a high-elevation look at the monthly count of available properties, closed sales, and pending transactions over the course of recent history.  The graph below establishes the subject set as Single Family Detached dwellings in Washington County in the Resale (everything but New Construction) category.  You can zoom in by shrinking the geography (MLS Area, City, Zip Code) or by specifying other measurable parameters (square feet, bedrooms, bathrooms, stories, year built, acres, etc.) but I recommend the broad view here because trends are generally consistent across counties and additional measurables will be woven in later.  Properties that were available at the end of a given month are shown as light green bars, and properties that changed hands by virtue of a sale during the month are shown as dark green bars.  Properties that were en-route from “available” to “sold” as of the end of the month are known as pending sales, shown by a red line.


This simple chart gives us a bundle of critical insights into the state of the market.

Supply:  The light green bars give us a handle on the number of sellers who are looking to move as of the end of each month.  This bar tends to ebb and flow in an annual pattern related to school year, holiday season and weather.  Experts look for fluctuations that either amplify or diminish this pattern in order to see the impact of other forces on supply.

Pace of Sale: The dark green bars show us the market’s appetite at current price levels for the type of property under consideration.  Note that this bar represents an amount accumulated over the course of a given month, while the light bar represents a fixed amount specific to the end of a given month. It stands to reason that these bars tend toward a seasonal pattern similar to the pattern for supply, as a seller is often a buyer at the same time.  An experienced observer will look at the fluctuations that are out of sync with those on the supply side in order to assess the impact of other forces on demand.

Inventory: We get this key indicator by measuring a given month’s light green bar against its dark green bar.  An economist might characterize inventory as “months to full consumption” which effectively translates as an answer to “if nothing new comes available and the current pace of sale is maintained, how long would it take to sell everything on the market?”  As a rule of thumb, the balance point between a buyer’s market and a seller’s market is 6 months of inventory.  That is to say, 6 months of inventory puts buyers and sellers on equal footing where negotiating strength is concerned.  In the context of this chart, a balanced market would feature light green bars six times the height of the corresponding dark green bars.  Because inventory has stayed well beneath the 6-month level for the entirety of the 15 months under study, we infer that sellers have been playing an extremely strong advantage and that prices will have escalated as a result.

Trajectory:  The red line enters our thinking here, as it gives us a look at the properties that are in transition from available to sold for a peek into the future.  Because most real estate transactions require 30-60 days for contingencies to be cleared, we expect the red line for pending sales to be roughly tracked by the dark green bars in the following one to two months.  That is largely the case for the period under study, with the spike in May and June predicting additional compression coming down the pipeline.

Summary:  This market segment has undergone 15 months of supply shortage.  The year-over-year comparisons of second-quarter  inventory and a look at the current spike in pending sales indicate an intensification of this imbalance with no relief on the horizon.  This serves both to explain price escalation and predict more of it.  In a nutshell, Sellers are playing an advantage of historically mighty proportions.



Now that we know the conditions of the pond in which we’re floating, we need to study our boat!

A single-story home with three bedrooms and two bathrooms comprising 1,800 square feet built in 1990 on a 6,000 square foot lot should give us a good field for comparison.

Our objective here is to set an expectation for average value as a benchmark against which to position the subject property – A purpose for which regression analysis is heroic.  To turn it into a little picture, we distill our sample set with additional qualifiers, spread it across a scattergram and run a regression line through it.  We’ll use the current year’s activity and go with Levels (1), Lot Size (5,000 sf – 7,000 sf), and Year Built (1985-1995) as our additional qualifiers [note that we could further distill with additional parameters (such as zip-code or neighborhood) and/or tighter parameters (such as lot size from 5,500 sf – 6,500 sf or year built 1988 -1992) adding precision but reducing the comparison points].  We’ll show the success stories (sold properties) as blue dots, the competing alternatives (available properties) as green triangles and the properties in between these extremes (pending properties) as yellow diamonds.  Spilling all three over a graph with price as the vertical axis and square footage as the horizontal axis, running regression lines for the sold & pending properties and pegging the subject property’s square footage…we get this:



AHHHH…What a thing of beauty!  We can see so much within this picture –

Slope: The relationship between square footage and price is represented here by the slope of the regression lines.  The first test of validity is to be sure the line runs upward from left to right (that is, there should always be a positive correlation between square footage and price).  Steeper lines indicate value more tightly associated with dwelling size, and is often the case with condominiums, townhomes and planned unit developments where all other things are closer to equal.  Flatter lines can indicate widely disparate sample sets with ulterior considerations such as views, proximity to amenities or architecture.

Dispersion: The more widely scattered above & below the line, the less uniform the properties are likely to be.  It’s not surprising at all to see a fair measure of spread when looking at this set, whose constituents are drawn from across a full county and have had 25-35 years to grow apart in terms of condition.  At the other extreme, a newly developed neighborhood with design uniformity and little variation in terms of proximity to amenities should feature constituents placed very tightly alongside and on the line.

Trend: In a market whose big picture articulates low inventory and predicts price escalation, we expect to see signs of both in the little picture.  In this case, our sample set has only two active listings (validating our expectation for low inventory) with enough closed and pending sales to produce a really nice regression line for both.  Because the closed sales are accumulated over 6 months’ time, while the pending sales are current, we validate our expectation for price escalation by looking for the regression line for pending sales (yellow) to be nudging upwards from the regression line for closed sales (blue). Bingo!

Position: The crown-jewel of this analysis is the intersection between the subject property’s square footage and the regression line for sold properties.  In simple terms, this is the point at which we would expect a meeting of the minds on a perfectly average transaction – A perfectly average buyer and a perfectly average seller exchanging a perfectly average property under perfectly average conditions.

The artistry lies in identifying the subject’s position relative to “average” – Skillful selection and detailed evaluation of the most relevant sales, pending sales and competing alternatives allows for a frank assessment of where a seller should expect to fall along the vertical line representing the subject’s square footage.  In the case shown here, our 1,800 square foot dwelling should be matched for all its pros & cons against the five pending sales between 1,700 and 1,900 square feet (all of which are encouragingly above both regression lines), the two closed sales straddling the lines in that same range and the competing alternative tucked just beneath the $500,000 price point.  If a confident conclusion can’t be drawn from those comparisons, one simply widens the size window for additional comparables and/or reconfigures the search parameters back at the drawing board.  It’s important here to adopt the implications of the big picture (and their echo in the little picture) where price movement is concerned – An ambitious strategy is appropriate in an escalating market while restraint is required in a descending market.



Establishing expectations for value blends science and artistry, but is eminently do-able given the right data, skillset and experience. Studying the trends in the big picture and the intricacies of the little picture empowers a homeowner to work down the line from data to wisdom.  We can see from this simple example just how it’s done.

Best of all, we have some extremely interesting and historically exceptional signals to pursue as the future unfolds.  Here are just a few:

  • How sharply will the acute shortage of recent months (accentuated by a spike in pending sales) boost prices?
  • How far will prices escalate before concerns related to viral exposure are subordinated and supply expanded?
  • How long will resale properties sustain an extraordinary advantage as new construction arrives to decompress the market?

Stay tuned!

Posted on August 7, 2020 at 8:38 pm
Matt Crile | Posted in Uncategorized |

Bubble Talk

Here's an excerpt from an interesting article that came down the pipeline from our friends at "Keeping Current Matters" today:

Last week, the National Association of Realtors (NAR) released their Existing Home Sales Report. The report announced that the median existing-home price in June was $236,400. That value surpasses the peak median sales price set in July 2006 ($230,400). This revelation created many headlines exclaiming that home prices had hit a “new record”:
Wall Street Journal: Existing-Home Prices Hit Record

USA Today: Existing home sales surge, prices hit record

Though the headlines are accurate, we want to take a closer look at the story. We do not want people to believe that this information is evidence that a new “price bubble” is forming in housing. NAR reports the median home price. That means that 50% of the homes sold above that number and 50% sold below that number. With fewer distressed properties (lower valued) now selling, the median price will rise. The median value does not reflect that each individual property is increasing in value. Below are the comments from Bill McBride, the author of the esteemed economic blog Calculated Risk. McBride talks about the challenges with using the median price and also explains that in “real” prices (taking into consideration inflation) we are nowhere close to a record.
“In general I'd ignore the median sales price because it is impacted by the mix of homes sold (more useful are the repeat sales indexes like Case-Shiller or CoreLogic). NAR reported the median sales price was $236,400 in June, above the median peak of $230,400 in July 2006. That is 9 years ago, so in real terms, median prices are close to 20% below the previous peak. Not close.”
Earlier this week, the Wall Street Journal covered this issue in detail. In this story, Nick Timiraos explained that this rise in median prices is nothing to be concerned about:
“Does this mean we have another problem on our hands? Not really…There may be other reasons to worry about housing affordability by comparing prices with incomes or prices with rents for a given market. But crude comparisons of nominal home prices with their 2006 and 2007 levels shouldn’t be used to make cavalier claims about a new bubble.”
Bottom Line

Home values are appreciating. However, they are not increasing at a rate that we should have fears of a new housing bubble around the corner.

Thanks again to the team at KCM for a thoughtful piece and an interesting insight. 

All the best,


Posted on July 30, 2015 at 6:32 pm
Matt Crile | Posted in Uncategorized |

Interest Rate Upticks – Navigating Choppy Waters

I've been asked a number of times over the past several weeks to predict the short-term future with regard to interest rates.  Thankfully, I've become rather adept at reminding folks that I abandoned prognostication years ago.  These are, however, intriguing times, with sellers playing offense and upward twitching interest rates heightening apprehension that a long-awaited steady climb may be next.  There is reason to believe it, but no reason to panic – Yes, every upward movement in interest rates undermines purchasing power, but a moderate climb to more sustainable rates would likely be accompanied by expanding inventory.  A bit less monetary strength but a bit more to choose from – certainly no crisis.  Above all, buyers should remember that any interest rate below 7% is, from a historical perspective, remarkably low.  There's a lot of distance between today's 4.125% and that benchmark, so be advised: For buyers and sellers alike, these are the good old days.

Posted on July 1, 2013 at 11:34 pm
Matt Crile | Posted in Uncategorized |

Zip Code: Nine-Seven-One-Two-Fire

I spent some time with an Orenco Station client today studying the past 15 months' market trends in zip code 97124.  We looked specifically at single family detached resale properties sold straight, and I figured others might want to see it as well.


Posted on June 11, 2013 at 1:14 am
Matt Crile | Posted in Uncategorized |

The Silver Tsunami

A great post today from John Downey on the Keeping Current Matters blog points us to the fact that 10,000 people turn 65 each day in the United States.  The implications for the real estate market are profound – It is my opinion that there is not nearly enough standing inventory designed to meet the specific demands of an aging population.  To be precise, single level dwellings with footprints that focus on space efficiency are hard to find in a world where developers are focused on maximizing livable square footage.  Builders tend to maximize their return on lot investment (a noble objective, to be sure) by adding second, and sometimes third, floors to their product.  The whipsaw effect of too strict an adherence to that model, however, is that the product becomes obsolete as knees, ankles and balance wear down with age.  Thankfully, population growth should allow for second and third generation homeowners to move up into these properties, but it is disturbing to think that our elders will have very little choice as they contemplate where to go.

My message to the investor clients with whom I work is very consistent.  Grab yourself a ranch-style home built with good bones in an established neighborhood.  Doesn't have to be flashy, and it doesn't have to be new – Rent it out and bide your time until the Silver Tsunami of demand brings the market to you…

Posted on June 5, 2013 at 9:08 pm
Matt Crile | Posted in Uncategorized |

Let’s Hear It For The Windermere Search App

It was great to learn that the long-awaited Windermere search app has been released to the public.  This is a long-awaited development, and a real point of pride for the technnology team at Windermere.  Head for the AppStore on your device and give it a whirl  – The search functions are very precise and the technology underlying the database provides for great depth of detail.  We've become familiar and very comfortable with with the apps from Zillow and other third-party purveyors of listing information, so it's fun to recognize and appreciate a unique viewpoint as seen through the lens of the West's finest brokerage.

Posted on June 3, 2013 at 5:50 pm
Matt Crile | Posted in Uncategorized |

Stoked About Community Service Day

It was a kick this morning to announce Windermere West's Community Service Day project for 2013.

Each year, we join our colleagues from througout the Windermere network in devoting a day to meet a community need.  This year, we'll meet at Barnes Elementary on Friday, June 21st to provide maintenance for the school's community garden, paint interior and exterior features, and assist in general repair needs throughout the campus.

Neighbors and clients are always invited to join us, and they often do – It's a great tradition and a lot of fun too!  If you're interested, please contact our front desk staff at 503-349-4884.

Posted on May 29, 2013 at 4:23 pm
Matt Crile | Posted in Uncategorized |

The Gardener Report Shows A Rising Tide

As a Windermere broker, I look forward each quarter to the release of the Gardner report so that I can keep a careful eye on regional trends for the housing market and the economy at large.  Matthew Gardner is a renowned land use economist and is considered one of the foremost real estate analysts in the Pacific Northwest.

While the full content of the report for Q1 2013 can be found here:

I found these notes to be the most intriguing:

  1. Oregon's employment gains of 1.5% over the past year matched the average for the US.
  2. Washington County's employment gains of 1.3% over the past year was equal to Multnomah County's.
  3. Washington County's unemployment rate is now 7.1%, while Multnomah County's is 7.8%.
  4. The net non-agricultural employment gain over the past year for Washington County was 3100 jobs.
  5. YTD closed sales of exisiting residential units is up 3% in Washington County and 11% in Mulnomah County.
  6. Washington County homes registered a 16.1% year over year price increase, to an average of $295,000.

Great stuff – The market is on the move!


Posted on May 28, 2013 at 6:58 pm
Matt Crile | Posted in Uncategorized |

An Honor And A Privilege

Just a quick post to thank the gracious leaders at the Hillsboro Chamber of Commerce and particularly the members of their Awards Committee for blessing me with the Outstanding Professional Award at last night's ceremony.  Above all, I wanted to reiterate what I said, somewhat clumsily, upon receiving the honor. 

Hillsboro is a spectacular community, beautifully represented by those at the celebration – From the elected leaders to the drivers of industry & commerce to the educators to the police & fire professionals to the tireless workers for charitable causes to the students who put such inspiring talent on display. 

Association with the Chamber of Commerce itself is a special delight, as that body works under extraordinary leadership to support Washington County as Oregon's economic engine – To be included among its honorees was a stunning and profoundly humbling surprise. 

The loyalty and encouragement of my colleagues at Windermere provided the fuel to thrive, and only standing on their shoulders could I have been recognized.  My beloved wife Kerry and my wonderful kids Roger, Kincaid and Grete play a critical role in each day's efforts – I would be lost without them.

It has been an unmitigated luxury to work with and alongside my Hillsboro neighbors & friends for nearly 12 years, and it is impossible to imagine having been more warmly welcomed or strongly supported.  I am deeply grateful and know for certain that Hillsboro has done more for me than I could ever hope to do for her.

Here's to a great city with a magnificent future – Cheers!

Posted on May 24, 2013 at 8:32 pm
Matt Crile | Posted in Uncategorized |