Showing posts with label Zillow. Show all posts
Showing posts with label Zillow. Show all posts

Friday, August 17, 2007

The Real Deal on 2nd Quarter Charlotte Home Prices

The Ratcliffe, Charlotte Condominium
Yes I know, Charlotte Home prices are up-- up 7% says the Charlotte Observer today. National real estate powerhouse Zillow , ranked Charlotte third best in the country with prices up 9%--so is that it? Well no, not exactly... not wanting to rain on anybody's parade-- how is Charlotte real estate really doing?

The Observer just asks what the average sales price of a home was-- with no comparison by size, area distribution, or type. (single family, townhouse or condo) I think it is impossible to say how much property has appreciated in 2007 from those numbers. And Zillow? Check their last post on my site, Response from Zillow, to see if you can figure out how they compute their Zestimates, both regionally and nationally. I don't think I get it yet.

So how did I figure the 2nd quarter results you see below? Easy, I computed average square foot price of homes in the area, over the three months of April through June 30, and compared it to the same area, in the same three months in 2006. Its simple division, and the Average Square Foot price of Sold homes increased 4.73% on 7.58% fewer sales.

Here then are the 2nd quarter numbers:

Charlotte Metro Area, 2nd Quareter 2007

2006 2007 Inc/Dec %
Solds



Units Sold 14084 13017 -7.58
Average Cost Per SF 110.77 116.01 4.73





Average Days on Market 83 77 -7.23
Expired Listings 1922 2439 26.90

The obvious is that the average cost per sq foot rose 4.73% in the 2nd quarter of 2007 compared to the same period in 2006. But the number of units fell 7.6%, and look at the "Expireds"-- expired listings, those that didn't sell and expired, are up more than 25%.

So then if the number of sales is off less than 8% , but the prices are up 4.73%, that's good, isn't it? In today's market, across the country it is good. While Zillow and I disagree about how good Charlotte is doing, we are in agreement that Charlotte is making it through the national housing decline very well.

There you have the three different methodologies, no prize for guessing which I favor. I like mine because it is based on actual sales, totally objective numbers, that when taken in the aggregate, and averaged based on the heated square feet of a home, should be a representative sample and the leading indicator of how well Charlotte is appreciating. Also, they are easily verified by anyone with access to the MLS.

In the past I've done market reports by zip code, but I'm changing that and I'm working on a list of "bell weather" neighborhoods to keep you posted on-- and taken together, they will provide a unique "value index" not unlike the Dow Jones.

So why can't I just shut up and be happy with Zillows 9% or the Observer's 7%? Isn't that great?As a Realtor, wouldn't I want those numbers to be true? Yes I would and we are doing well, just not that well, and next week I may be sitting in your house, trying to estimate the value of your home to put it on the market. I'm sure you will have seen some of these headlines... and I want your home to sell at the best price, in the shortest time. One thing is certain, transparent real estate is here to stay and only the homes priced right will sell.

I'll post further on these 2nd quarter results as time allows.

tm

Wednesday, August 15, 2007

A Response From Zillow

Update- Zillow announced yesterday that Charlotte MSA prices were up 9% over last year, 3rd best in the nation... which would be great if true, however my research, easily done with our MLS, indicates otherwise.

Zillow responded in another forum to my question on how these numbers were created:

Hi, it's David from Zillow;

Terry -

Zillow is a database of all homes not just those that are currently on the market and so we calculate Zestimate values for all of the homes in our database. With this database we can report the value trends of all homes not just those that recently sold. The beauty of this approach is that it is not skewed by a change in the mix of homes that are selling - a common problem for the traditional approach of reporting value trends using only an analysis of recent sales

I think I understand that David, but I have two questions:
Your national and local MSA numbers are then the addition of all of your Zestimates, which were created from the extrapolations from actual comparable property sales, correct? Essentially additions of estimates based on comparable sales, right? Then if I took ALL the sales over a longer period of time, and compared them to the same time and place last year, our numbers should be similar shouldn't they? Well they aren't, they are way off.

Your President has stated that as much as 38% of your Zestimates are more than 10% off, why isn't your margin of error compounded in a fast moving market where prices could be going up or down relatively quickly. I'm not a statistician, but it seems that margin of error must go up in these conditons.

While our numbers and yours do correspond in some regards- for example our more expensive homes have taken the hardest hit- your data indicated the medium to large home have taken a harder hit, a pretty similar picture, there is still a huge variance in our actual results from the MLS which while not 100% complete is a good representative sample of non-builder sales.

I've recently done research on two of the top three leading zips, with appreciation based on average square foot prices from the MLS, reports showing them for the 3 month period ending July 31. In one zip code, there was price appreciation 50% below yours, and in the other? Double digit depreciation! The zip codes in question, 28277 appreciated 4.5%, and 28278 depreciated 11.97%--over May, June and July- quite a difference to Zillow's +9%, the actual reports are below for your review.

Why is this important? Because I am sure one of our local papers will pick up the Zillow press release and report it, probably uncritically, and I'll have to face a seller next week who thinks his property has gone up 9% when it might have fallen 10% from last year.

David, I'd like to be able to use your numbers--really I would if I had a sense they were atleast roughly accurate. They are impressive by their sheer volume and I know that a lot of big-time crunching has been done, but I just can't not explain the difference between our methods or why your addition of estimates would be a better measure of my market than the actual data, as long as there are sufficient transactions to be meaningful statistically. Here are my zip code Market Reports
Market Report 28277- July 2007
Market Report 28278- July 2007

Don't get me wrong, I know Charlotte has fared much much better than most of the country, but the headlines need to be right. Your comments are appreciated. terry



Post Options