Monday, November 27, 2023

Lies, Damned Lies, and Averages as Applied by Bots

According to the Mercury News, the average sale price of “the top seven most expensive homes” in Palo Alto during the week of Nov 13 was $1371 per sq. ft.

https://www.mercurynews.com/2023/11/23/the-top-seven-most-expensive-home-sales-in-palo-alto-reported-the-week-of-nov-13/

Offhand, this sounds like absolute bullshit. To the data!

Firstly, there is a caveat that the sales may not have occurred during the period in question, merely that the deeds were recorded recently.

Second, the lowest priced sale mentioned, is a condo on Newell Street which sold for approximately 707K. Despite the mixing of single family and condo data, which I believe is a deliberate distortion, this is a condo in East Palo Alto, not Palo Alto. This is like calling a Leaf a Tesla simply because both are electric vehicles. Data points 5 and 6 are also located in East Palo Alto, which, despite it charms, does not share the same award-winning school districts, downtown commercial district and Caltrain accessibility of the city of Palo Alto.

The average of the 3 properties sold in East Palo Alto is 921K, or $726 a sq. ft.

The average of the 2 single family homes sold in East Palo Alto is 1.001 million, or $750 a sq. ft.

The cheapest property listed in Palo Alto is a condo which sold for $1,070,000, 10K more than the most expensive home sold for in East Palo Alto.

The average of the 4 properties sold in Palo Alto is 2.805 million, $1754 a sq. ft.

The average of the 3 single family homes sold in Palo Alto was 3.383, or $1880 a sq. ft.

The benefits of blending these two distinct datasets because both contain the words Palo Alto is, to me, questionable, at best.

The good news for Mercury News, given the author is a bot, is that the value of the article is probably worth close to what they paid to generate its contents.

https://www.mercurynews.com/author/bay-area-home-report/

Tuesday, November 21, 2023

Lies, Damned Lies and the Law of Averages

One of the ardent faiths I hold in my profession is that averages in real estate are not worth much outside the context of the data analyzed, especially when it comes to single family residential in the Bay Area. Condos, by nature, are more uniform and thus more likely to trade at consistent, predictable prices. Areas like Arizona which have new neighborhoods full of uniform new homes may act similarly. Detached homes in the Bay Area, however, are far less constricted in terms of its inherent variation in value based on building quality and location.

Therefore, relying on the statistics heralded but not backed by a dataset is dicey, at best.

Consider the headline offered online in the San Francisco Chronicle barking:

“SF Values are now Lower than this East Bay city”.

https://www.sfchronicle.com/bayarea/article/home-dublin-san-francisco-18462299.php

On the surface this sounds like something Fox News would happily repost, albeit reworded thus:

“Suburb’s gains Proof of SF’s Imminent Implosion”

No data is included, so I dug up what is available on MLS using the months of August and September of this year. As close as I could get to making the above a reality was to search for detached homes in this period, eliminating any data points above 8 million dollars (there were 4 in SF during this period). Once you remove those pesky outliers and you can shave an extra quarter million off the average sales price of a single-family home, bringing the average down to 1.970 million in SF. Comparatively, all detached homes sold in Dublin for under 8 million dollars in the same period is 1.983 million.

Voila!

Except – if you are removing outliers in SF, should you also take out the lowest ones? A quick glance reveals a few properties miscategorized as detached when they are in fact TIC or HOA dependent. Should we proceed with that correction, we can expect our averages to move further from par, with the average price of an SF home creeping higher.

But assuming we let the comparison stand and say, with a grain of confidence given the dataset at hand, that the average sale price of a single-family home in Dublin exceeded that of San Francisco between August and September of 2023. What, if anything, does this reveal about said house we are purchasing for nearly 2 million?

Removing data points for homes without listed square footage (15 of 196) the average size home sold in SF was 2032 sqft, with a low of 650 and a high of 6670.

In Dublin, all 37 listings had square footage information, revealing an average of 2629 sqft, with a low of 1166 and a high of 4415.

The average price per square foot in SF during this period was $980, with a low of $303 and a high of $2,131.

The average price per square foot in Dublin during this period was $790, with a low of $545 and a high of $1187.

The average age of a home sold during the period in San Francisco (when provided) was 1931.

The average age of a home sold during the period in Dublin was 2000.

Apples and oranges, or harbinger of the inexorable damnation of the America’s number one liberal freehold?

While the latter sells would presumably sell more papers, I’m willing to throw my two cents in for the former.

“Large New Suburban Home Sells at Same Price as Charming 100-Year-Old Two Bedroom in City Center”

While accurate, the Doomsday punch is lacking. 

https://www.realtor.com/realestateandhomes-detail/M1296275069

https://www.realtor.com/realestateandhomes-detail/M2257248813


 

 

 

 

Saturday, March 4, 2023

One Home, Many Prices

When it comes to real estate, it is often easier to speak in generalizations as opposed to specifics. Sales of the same house rarely correspond with the market’s ups and downs. The trade volume of most single family residences (SFR) is simply too low. Therefore, the value of a particular house becomes a matter of speculation rather than fact. Further, even in a case where data exists, a single property’s ability to act as the perfect comp relative to the market is limited by changes to the neighborhood and/or home which occurred during the period in question. Despite the limitations, I recently discovered a SFR in San Mateo which has transaction data corresponding with several key moments in the local market’s uneven trajectory since the turn of the century.

In June of 2001, after the tech bubble had burst and the local market was less rather gridlocked, an unremarkable 2/1, built in 1937 on an otherwise commercial block, sold for 385K. It was a quick sale, going pending in a week, for 60K over ask. The comments note the seller was in default. 

Less than five years later, in April of 2006, as the sub-prime lending industry exuberantly marched the global economy towards a cliff, a new buyer secured financing for the place to a tune of 690K, or a nearly 80% more with nary a major renovation to account for the increase. One year later, the owners put it back up for sale – for 839K, a jump of over 20%. The market, for reasons of caution, or lack of demand, or dearth of available financing, did not respond.  The property was withdrawn that fall. 

Two years later, in May of 2009, it was brought back to market. Despite the addition of a bathroom, it sold in October 2009 for 532K, a loss in value, before costs, of 20%. Per the Case Shiller Index, late fall 2009 through early 2012 saw the lowest SFR housing prices post Great Recession, before they trudged back up. Indeed, subsequently, many folks would happily go into contract for a SFR in San Mateo for such a price.

After a remedial facelift, the home was listed again in April of 2013. Listed as a 3/2, it showed more like a duplex with a 1/1 downstairs and a 2/1 upstairs. While it remained a challenging location and floorplan for most families, its proximity to downtown was desirable, and it still had the potential for improvement. Listed at 599K, the low side for SFR in San Mateo at that point, it was one of the homes I looked at that spring before purchasing my first home later that year. The sale closed at 720K.

What is it worth today? 

Less than 1.65, which is what the owner was requesting before it was withdrawn from market in February 2023, after being listed for 4 months. The pictures showed nice interior upgrades, backyard improvements, and a vast roof deck, but buyers did not accept the upgrades warranted an increase in value of 130% in ten years. The sellers agreed to disagree.

 The home is currently listed for rent at $5,250 a month. Assuming the owners had traditional financing with 20% down in 2013 and the sense to refinance at the market’s record low interest rates, it is unlikely they owe more than 500K, unless they took additional equity out of the home. If this is the case, the current mortgage payment could be expected to remain under 2K a month, leaving a decent cushion to cover tax, insurance and basic maintenance if the target rental price is attained. When the potential sale price of the property decreases and rents remain stable, the owner’s potential yield increases, incentivizing removing it from the sale market. 

Thus defines a distinct portion of the market right now – buyers who don’t want to buy at the prices sellers feel entitled to receiving, and sellers in a solid enough financial position to avoid having to accept less than they feel they deserve. In San Mateo, the number of withdrawn homes since the first of the year has increased by a factor of three since last year. Thus, it is a standoff of sorts, with only the most motivated buyers and sellers participating in trades.

Can a market crash when there is little compulsion for owners to sell? It makes sense for a buyer who spent 690K with nothing down to sell at a “loss” when their teaser rate evaporated amidst a lending freeze. Today, a total profit of over a hundred percent wasn’t incentive enough to impel a potential seller to part with their property due to the plain and simple fact they had other options. The age-old motivations for sale, death and divorce, shall persist, but overall, at the moment, unless a property is either highly desirable and/or fairly priced, no one side is budging: buyers wait while sellers withdraw.