Austin Real Estate 24 - Crossland Real Estate

Does MLXChange MLS Software Calculate Price Per Square Foot Properly?

I have have been critical of our new Austin MLS System called MLXChange since it was first placed into production in Austin in November 2007. It produces what I believe to be incorrect data. I was contacted yesterday by a product manager from MLXChange because they saw my last blog article showcasing some of the bad data. In that article, I mentioned that the price per square foot is not calculated correctly by the system.

The product manager was very nice and I enjoyed our conversation. She wanted to explain to me how the average price per square foot numbers are calculated and that, in fact, the numbers are calculated correctly. She is right on a certain level. That is, if one understands and follows the formula being used by MLXChange, it can be argued that their number is a mathematically correct.

But I maintain that the method being used by MLXChange to calculate average price per square foot is not the correct formula. I’m not smart enough to articulate it in a scientific or mathematical argument, but my intuition and instinct tells me I’m right. I’ll do my best to explain below and I hope a smart reader can chime in and offer a mathematical or statistical point of view and explanation of why two different methods, each of which seems correct independently on face value, produce different results.

So let’s look at an example that illustrates the MLXChange formula versus the method I believe most of us would use, and the method I believe makes the most sense. I’ve created a small sample set of data, shown in the chart below.

Price Per Square Foot Calculation Method
Example
	Square Feet	Sold Price	Sold $ per SQFT
House 1	1200	$150,000	$125.00
House 2	1300	$110,000	$84.62
House 3	1400	$95,000	$67.86
House 4	1500	$120,000	$80.00
House 5	1600	$85,000	$53.13
MLXChange Avg	1400	$112,000	$82.12
My Average	1400	$112,000	$80.00

What is the average sold price per square foot of the 5 homes shown above?

MLXChange computes the Average Price per Square Foot by adding together all of the individual price per square foot numbers (the five psf numbers in the far right column) and dividing by the number of sales (five). This produces a result of $82.12 per square foot as the average price per square foot of the sold homes in our sample set.

I compute the average price per square foot by taking the average sqft size of all homes (1400) and dividing it into the average sold price of all homes ($112,000). My result is $80 per square foot. That’s what you would see on a stats chart that I manually produce and post regularly on this blog.

The two methods, in this particular example, produce results that are 2.65% different. 2.65% is not an insignificant amount when pricing a home. It’s a bigger gap than the List/Sold price difference on most sold homes in Austin. It’s a $5,300 difference on a 2500 sqft home at our example psf rates. Would you like to sell your home for $5,300 too little? Would you like to pay $5,300 too much, based on your Realtor’s CMA, produced by MLXChange?

Let’s dig deeper into why I think the MLXChange method is flawed.

Responding to Unsolicited Offers to Buy Your Home

by Steve Crossland

I received a call recently from an Austin homeowner looking for a place to rent. After further questioning I learned of her situation. The neighbors have offered to buy her home, and she is willing to consider selling it. The neighbors have outgrown their smaller home and would love to move up to her larger home while remaining on the same street. The homeowner is now exploring rental options in case she were to sell.

“Have they indicated a price they’re willing to pay?”, I asked? No.
“Have they provided a pre-approval letter indicating their financial ability to buy?”, I asked. No.

“Well”, I said, “you’re out looking for a place to rent but you haven’t first established that your prospective buyers are legitimately interested. How do you know you’re not wasting your time? Do you really want to spend time looking for a home to rent before knowing that your neighbors aren’t just daydreaming about your house, and that they might turn out to be flakes?”

“No”, she said. “I guess not. What should I do?”

When you, as a home owner, are approached about selling your home, and your home is not on the market for sale, there are a couple of up front requirements you should request before you spend even 3 seconds thinking about it. Assuming you are open to the possibility of selling and you wouldn’t simply say “no thanks” immediately, you would tell the prospective buyer the following:

Austin Property Tax Appraisal Map 2008

by Steve Crossland

The Austin Statesman published this map today of the property value increases around Austin, broken down by School District area, for 2008. There is a link to the full story below.

This is a good time to once again draw the distinction between the Appraised Value of a home for property tax purposes, as set by the County in which the home is located, versus Market Value of a home, which is determined of course by supply and demand.

The County does in fact attempt to value your home at market value, but they do not have the resources to perform an individual market analysis for each property. Instead, they paint with a broad brush across neighborhoods and areas.

The majority of appraised values around Austin are below market value, but there are plenty that are above. Also, just because the Appraised Value of a home increased 12% from last year, that doesn’t mean the Market Value of your home (what you could actually sell it for compared to last year) increased by that amount. The appraised value was probably low to start with, so the amount of the appraised value increase may or may not have any correlation with true market value.

Yesterday a home owner contacted me asking for a CMA on his home. The County appraised value is over $200K. The CMA I ran showed the market value, as of Jan 1st of this year, at about $180K. That owner will need to file a protest, gather data, and attend a protest hearing to have the price lowered. Otherwise, he’ll be paying too much in property taxes to Travis County. So don’t assume your value is low. It may be located in one of the neighborhoods or price ranges where the broad brush of the county over-estimates the value.

Huttoparke Problems Continue, Values Suffer

by Steve Crossland

It is with great fascination that I first saw last year Huttoparke home owners made sure that everyone knew how poorly their homes were built. They may have had no choice but to bring public attention to the problems they were having. The homeowners felt that Lennar was unresponsive to their complaints about poor construction quality. Lennar Homes did have some major problems with sheetrock cracking, foundation movement, and crumbling driveways as Huttoparke is built upon the clay farmland soil prevalent east of IH35 in Austin, and these homes were apparently not built with sufficient consideration given to the implications of expansive soil.

Today, yet another Huttoparke story in the Austin Statesman brings attention to the construction quality problems of the neighborhood, and reminds me why I don’t sell homes in these types of subdivisions in the first place. Never have, never will. We refer buyers who want those homes to other Realtors, mainly because I don’t want to sell poor product.

If you’ve followed my blog or read our investment page, you know that Sylvia and I believe, for most buyers, especially those seeking stability and appreciation, a home in an established neighborhood is a safer real estate purchase than venturing out to buy a new starter home on the edge of sprawl.

The reason is that you never know for sure what you’re getting into when you buy in these fast growing new starter home subdivisions. In this case, in Huttoparke, you would be living/owning a home in a neighborhood where the home owners have resorted to picketing the builder, putting signs in their yard to let everyone know how poorly built the homes are, plastering their vehicles with anti-builder messages, setting up websites to warn other buyers not to buy there, and in general driving their property values into the ground.

Let’s see what property values have done in Huttoparke the past few years:

Austin MLXChange MLS Software Still Falls Short

by Steve Crossland

Marketlinx MLXChange Software

I just finished running my stats for my Austin Rental Market update. This month I only had to report three listings to the Austin Board of Realtors which had bogus and incorrect data. Check the screen shot above to see the sort of thing Austin Realtors deal with on a regular basis.

Hopefully if you have an agent running a Market Analysis for you, he or she is keenly aware that the data from MLXChange cannot be trusted. It needs to be double checked before you rely on it. How would you like to go into an important math test with a calculator that spits out bad answers? Well, imagine trying to be an effective Realtor with an MLS System that spits out bad data.

As agents, we really have to pay attention to the MLS data from MLXChange. I always have a calculator at my side when crunching numbers because the MarketLinx MLXChange MLS system for Austin cranks out unreliable results. I could make 10 screenshots like the one above with other examples of miscaluculated data, the most frustrating of which is incorrect price per square foot calculations.

Those price per sqaure foot amounts you see above?… they are incorrect. I should have circled those in red also for the screen shot. Divide the average square foot Sold/Leased price by the average square foot amount from the colums to the left and the number is way off. They’ve had 6 months to fix this and it still produces incorrect values.

Austin Rental Market Update – March 2008 and YTD

by Steve Crossland

Homes in Austin are renting for 8% more than last year, on average. Average rent price for homes across the Austin Metro area was $1401 per month for March 2008 compared to $1295/mo the year before. The Median leased price remained about the same at $1200. Homes are renting fast this March. The average days on market was down to 37 days from 42 last year. The Median days on market was 26 compared to 28 days last year, which means half of the rental homes in Austin that leased through the Austin MLS rented in 26 days or less, and half took more than 26 days to rent.

The average rental price per sqaure foot is up almost 6% to $0.73 compared to $0.69 last year. The average size rental home in Austin was 1915 sqft and the median size was 1794 square feet.

The number of homes rented was down about 10%. More renters are renewing leases as fewer can qualify for home purchases than in the past several years. This is good for landlords. Note that our average rental rate of $1401/mo for March 2008 is still lower that the average of $1497/mo that renters paid in the year 2000 and the $1524/mo renters paid in 2001 before Austin rents tumbled for four years and bottomed out at $1235/mo in 2005. So we’re still trying to climb back to where we were 6 or 7 years ago.

Below is the data chart for March Rentals in Austin. Further below is a year to date chart, breakdown by city, and a historical graph of rental rates in Austin from 1999 through the end of March 2008. As usual, comments and questions are welcome.




    Austin Rental Market Stats March 2008

    Previous Month and Year Comparison 

  All MLS Areas - Houses Only

  

 


Feb 2008




Mar 2008




Mar 2007



Yr % Change 



# Leased 
563
594
659
-9.86%


Avg List Price 
$1,370
$1,412
$1,305
8.20%


Median List Price 
$1,200
$1,250
$1,200
4.17%


Avg Leased Price 
$1,362
$1,401
$1,295
8.19%


Med Leased Price 
$1,200
$1,200
$1,195
0.42%


Avg Size SQFT 
1901
1915
1874
2.19%


Median SQFT 
1755
1794
1769
1.41%


Avg $ per SQFT 
$0.72
$0.73
$0.69
5.87%


Avg Days on Mkt 
39
37
42
-11.90%


Median Days on Mkt 
27
26
28
-7.14%

Austin Rental Market Stats March 2008
Previous Month and Year Comparison
All MLS Areas - Houses Only
	Feb 2008	Mar 2008	Mar 2007	Yr % Change
# Leased	563	594	659	-9.86%
Avg List Price	$1,370	$1,412	$1,305	8.20%
Median List Price	$1,200	$1,250	$1,200	4.17%
Avg Leased Price	$1,362	$1,401	$1,295	8.19%
Med Leased Price	$1,200	$1,200	$1,195	0.42%
Avg Size SQFT	1901	1915	1874	2.19%
Median SQFT	1755	1794	1769	1.41%
Avg $ per SQFT	$0.72	$0.73	$0.69	5.87%
Avg Days on Mkt	39	37	42	-11.90%
Median Days on Mkt	27	26	28	-7.14%

Below is the Year to Date Comparison chart.

Does MLXChange MLS Software Calculate Price Per Square Foot Properly?

Responding to Unsolicited Offers to Buy Your Home

Austin Property Tax Appraisal Map 2008

Huttoparke Problems Continue, Values Suffer

Austin MLXChange MLS Software Still Falls Short

Austin Rental Market Update – March 2008 and YTD

SPEAK TO AN AGENT NOW

CALL 512-327-3900

Find out what your neighbor’s home sold for!