Of all the homes bought and sold in San Francisco in 2011:
- How many had Golden Gate, Bay Bridge, downtown or ocean views?
- How many were Victorian, Edwardian, Art Deco, Spanish Mediterranean or brand spanking new?
- How many had elevators or pools, wine cellars, doorpersons or in-law apartments?
- How many were probate sales, bank sales or short sales?
- And what were the biggest sales in the Sunset, Noe Valley, SoMa and Pacific Heights?
We data-mined all of 2011′s MLS sales to answer these questions and more. We hope you find the details as interesting as we did.
All data herein is from sources deemed (at least somewhat) reliable – i.e. the information input by listing agents regarding their own listings — but may contain errors and omissions, and is subject to revision. These charts do not include sales unreported to MLS.
It seems to be part of the human condition that financial and real estate markets go in cycles. What’s interesting is that when the cycle is on the upswing or a bubble is inflating, how vociferous the opinions are that the upswing will never end; and how after the crash, how many then insist, often with great virulence, that the markets will never improve again in our lifetimes. We see variations of this forecasting certitude constantly from those emotionally or financially invested in a certain viewpoint, not to mention bloggers and media with infinite white space to fill – and, of course, real estate agents often do this as well. However, most of the time, one must simply wait and see how the cycles turn in their own time and circumstances, and turning points are best perceived in retrospect.
All this leads to our point: absent some new natural or economic disaster – which is certainly possible – it appears that San Francisco real estate began turning the corner on the latest down cycle in 2011. Two and a half years following the financial markets crash, the dynamics in the city started to change early last year: prices seemed to have bottomed out and stabilized, Bay Area and city economic conditions started to markedly improve, distress home listings began to decrease, interest rates hit new lows, SF rents increased, vacancy rates dwindled, builders started moving forward on new projects, general optimism grew (most dramatically in the last quarter) – and optimism plays a huge role in turnarounds – and the financials of home buying made more sense than they had in many years.
Indeed in 2011, the biggest story regarding the SF homes market was the drastic lack of inventory – typically 35-45% below the previous year – which was inadequate to satisfy surging buyer demand. Historically, according to the laws of supply and demand, this begins to put upward pressure on prices – which is what we’ve been beginning to see in some of our neighborhoods.
It should be noted that San Francisco often behaves differently than other markets and recovers more quickly, and also that within the city itself, the markets in different neighborhoods can move at different speeds or even, for periods of time, in different directions. There is a link at the bottom of the newsletter to far more detailed analyses of the SF market by neighborhood, property type and bedroom count. There are also definitions and caveats regarding the statistics used below.
Statistics are generalities that may fluctuate for a number of reasons. All data herein is from sources deemed reliable but may contain errors and omissions and is subject to revision. These charts do not include sales not reported to MLS, such as occur in some new-development projects. How any statistic relates to the value of any specific property is unknown without further analysis.
2011 Unit Sales
The number of sales as reported to MLS climbed about 7% in 2011 from 2010, bouncing back from the trough of 2009, though still far below the peak years. All SF property types saw increases in sales. However, if inventory had not been so drastically low all year long, the increase in unit sales would certainly have been much greater.
S&P Case-Shiller Home Price Index
If Case-Shiller did an Index just for the city of San Francisco itself, instead of the 5-county “Metro Area,” we believe it would indicate a significantly greater recovery than indicated in this chart. San Francisco is strongly outperforming the markets in the other counties included in their local Index. (And SF itself only makes up a small percentage of that Index.) For a more detailed explanation of the S&P Case-Shiller Index:
Average Dollar per Square Foot Values
Looking at the last 6 quarters, we see a very gradual increase from mid- 2010 of average-dollar-per-square-foot values for SF houses of $750,000 and above, except for the hiccup which occurred during the 3rd quarter of 2011 when the European debt crisis and the U.S. debt limit boondoggle greatly increased financial anxieties. The latest quarter saw the highest value, by a tad, since 2008. This chart also shows how the market is divided between the lower-priced housing segment (for SF) hard hit by distress sales and the mid-to-high priced segment which has been little affected by distress sales. Remember that quarterly fluctuations of average and median figures are not particularly meaningful – what are important are consistent longer term trends.
Percentage of Listings Accepting Offers
The main 3 residential property types in the city have been hitting their highest percentages in recent memory for listings going into contract (accepting offers). This is a very clear graphic of the dynamic of very strong buyer demand meeting a very low inventory of homes available to purchase. The dip in the third quarter was, as mentioned, probably due to the burst of financial markets anxieties that occurred over the summer.
Sales Price to Original List Price
This chart shows the enormous difference that proper pricing, preparation and marketing make in achieving the highest sales price in the lowest amount of time. Most of the homes that do sell actually accept offers relatively quickly at very close to, or even a little over, the list price. About half as many sell after price reductions, with big discounts on list price and large delays in closing the sale. And then, even in a market of strong buyer demand, about a third of listings expire or are withdrawn without selling, typically due to being perceived as overpriced.
Months Supply of Inventory (MSI)
MSI measures how long it would take to sell the entire inventory of homes currently for sale, at existing market-activity rates. The lower the MSI, the stronger the demand as compared to supply: We don’t recall ever seeing overall MSI rates this low. As a comparison, the MSI in the United States as a whole right now is 7 months. In certain SF market segments, the MSI is down to 1.5 months or lower. In the 4th quarter, there was a story of one listing, admitted egregiously underpriced, receiving 26 offers – which gives an idea of the level of unsatisfied demand in some neighborhoods.
Number of Homes for Sale
This chart tracks the number of homes listed as available on MLS on the last day of each month. It is true that inventory always plunges during the holidays and then starts to recover in January, but throughout 2011 the number of homes available to purchase in any given month has been far below the levels of previous years. And if one factors in the huge decline over the last few years in new-development condos on the market, it looks even worse. Inadequate to buyer demand, this has led to an increase in multiple offers and buyer stress — and increasing values in some of the city’s neighborhoods.
SF Luxury Home Sales in 2011
Homes selling for $1,500,000 and above make up about 10% of San Francisco’s sales and this is a snapshot of where they occurred by neighborhood and property type. For houses, the biggest prices still come in the Pacific/ Presidio Heights area, where one mansion on Broadway sold for $29,500,000. For condos, the highest dollar-per-square-foot figures are found in Russian Hill and South Beach for luxury units with astounding views: a penthouse in the St. Regis in South Beach/ Yerba Buena sold for $28,000,000. But in number of sales, the central Noe Valley/ Castro/ Cole Valley district has grown immensely over the past 10 years and is now firmly established for a particular type of affluent buyer, many of whom want easier access to Silicon Valley.
SF Distress Home Sales
As a percentage of sales, distress home sales peaked in January 2011; overall, they made up about 20% of total unit sales last year, but were largely clustered in certain neighborhoods, often in the less affluent areas of the city, and in the lower price ranges. To a large degree, they have not impacted values in many of the city’s more affluent central and northern districts. As seen here, the number of such listings has been markedly declining in 2011. Compared to other areas of the Bay Area, state and country, SF has been relatively unaffected by foreclosures, and so far the much dreaded “shadow inventory” of foreclosed-upon home listings has never arrived in the city.
SF Home Sales by Price Range
The largest percentage of SF home sales occurs in the $500,000 to $750,000 range. One of the biggest changes over the past few years has been the enormous growth in unit sales in the under-$500,000 price segment, much of which has been driven by distress sales. Even from 2010 to 2011, the lower end price segment has increased as a percentage of sales – and this continues to impact overall median sales price, which is simply that price at which half the homes sold for more and half for less.
Average Days on Market (DOM)
This chart shows the large difference in how long it takes to sell distress homes as compared to regular homes (about a month longer); the effect that pricing, preparing and marketing the home correctly can make in days on market (over two months); and the different speeds of sale for the 3 main residential property types. (Distress sales are not broken out for TICs, because they have been relatively unaffected by foreclosures.) General appeal homes that are effectively priced, presented and marketed often receive offers within 2-3 weeks of coming on market.
How Buyers Find the Homes They Purchase
A simple graphic of how things have changed in real estate buying and marketing in the past 10 years. An effective marketing plan has to include very comprehensive components of high-quality online marketing and broker-to-broker marketing – this is what reaches by far the most buyers. Professionally taken real estate photos are now an absolute necessity since they are how most buyers and agents will first see and evaluate your home. (All Paragon listings are photographed by professional real estate photographers.) Effective neighborhood marketing and open houses come next. The value of print advertising in newspapers and real estate magazines has become negligible.
Mortgage Interest Rates
Between the decline in prices since 2007-2008 and the decline in interest rates, the monthly cost of owning the same home has generally declined 30-40% in San Francisco over the past 4-5 years. (Chart below is from Bankrate.com.) Conversely, SF apartment rents have been increasing lately (especially due to the growth of high-tech employment). One of the standard ways economists evaluate whether a real estate market is correctly priced or not is by comparing the cost of renting vs. the cost of owning the same home. This equation has gone through a huge change since 2008.
“There are three kinds of lies: lies, damned lies and statistics.”
Statistics without informed context are usually worthless, easily manipulated and often misleading.
One can make virtually any case — positive or negative — by choosing a single average or median statistic relating to a short period of time and a small data set, and then cherry picking what you’re comparing today’s data to (last month, last year, or the peak of the market). Conversely, too large a data set may be misleading: the overall national trend may misrepresent California’s, and the state’s can be different from the Bay Area’s, the Bay Area’s from the city’s, and within San Francisco itself, distinct neighborhoods are often different markets going in significantly different directions.
In particular, absent some huge economic event, such as the September 2008 financial markets meltdown, monthly fluctuations in median home sales prices are usually meaningless. Median prices often fluctuate up and down within a 5 to 10% range from one month to the next, even in stable markets.
One can only be sure market values are trending up or down if that trend is consistent over the longer term, minimally 4 to 6 months. Any definitive trend in prices and values should also be reflected in other market statistics such as average dollar per square foot, days on market, months’ supply of inventory, percentage of listings accepting offers, percentage of distress sales, and so on.
When assessing market changes calculated by computerized algorithms using very general data sets – such as Case Shiller’s or Zillow’s — one should be clear on the details. For example, the Case Shiller Index for “San Francisco” reflects an analysis of a “metro area” comprising 5 counties with wildly varying markets (Pinole to Pacific Heights). And for the city of San Francisco, one should look at the Case-Shiller “High Tier” price Index, not the general Index. It also makes sense to assume a sensible margin in error. As an egregious example, Zillow’s property valuations usually build in a 10-25% margin of error on either side of their “Zestimate” of value. A 1-3% value change indicated by the Case Shiller overall home Index for the SF metro area, then applied by a commentator to condo values in SOMA or house values in the Marina, should be taken with a grain of salt.
Always look for consistent, longer term trends across a wide range of market quantifying statistics.
MEDIAN SALES PRICE is that price at which half the sales occur for more and half for less. It can be, and often is, affected by other factors besides changes in market values, such as short-term or seasonal changes in inventory or buying trends. The median sales price for homes (in all their infinite variety) is not like the price for a share of stock (all the same), and monthly fluctuations in median price are generally meaningless. If market values are truly changing, the median price will consistently rise or sink over a longer term than just 2 or 3 months, and also be supported by other supply and demand statistical trends.
AVERAGE SALES PRICE is calculated by adding up all the sales prices and dividing by the number of sales. It is different from median sales price, but like medians, averages can be affected by other factors besides changes in value, such as fluctuations in average unit size. Averages may also be distorted by a few sales that are abnormally high or low, especially when the number of sales is low. Average sales prices are usually higher than median sales prices.
DAYS ON MARKET (DOM) are the number of days between a listing going on market and accepting an offer. The lower the average days on market figure, typically the stronger the buyer demand and the hotter the market. Note that this statistic is distorted by distress sales, which often have a very high DOM, by that minority percentage of listings that sell after multiple price reductions, and by deals that fall through after offer acceptance (the listings come back on market, but the DOM clock keeping ticking). Appealing, well-priced new listings often accept offers within 7 to 14 days of coming on market.
MONTHS SUPPLY OF INVENTORY (MSI) reflects the number of months it would take to sell the existing inventory of homes for sale at current market conditions. The lower the MSI, the stronger the demand as compared to the supply and the hotter the market. Typically, below 3-4 months of inventory is considered a “Seller’s market”, 4-6 months a relatively balanced market, and above 6 months, a “Buyer’s market.”
DOLLAR PER SQUARE FOOT ($/sqft) is based upon the home’s interior living space and does not include garages, unfinished attics and basements, rooms built without permit, lot size, or patios and decks — though all these can still add value to a home. These figures are usually derived from appraisals or tax records, but are sometimes unreliable or unreported altogether. Generally speaking, about 60-80% of listings report square footage and dollar per square foot averages are calculated on these listings alone. All things being equal, a house will sell for a higher dollar per square foot than a condo (due to land value), a condo higher than a TIC (quality of title), and a TIC higher than a multi-unit building (quality of use). Everything being equal, a smaller home will sell for a higher $/sqft than a larger one. (However, things are rarely equal in real estate.) There are often surprisingly wide variations of value within neighborhoods and averages may be distorted by one or two sales substantially higher or lower than the norm, especially when the total number of sales is small. Location, condition, amenities, parking, views, lot size & outdoor space all affect $/sqft home values. Typically, the highest dollar per square foot figures in San Francisco are achieved by penthouse condos with utterly spectacular views in prestige buildings.
SAN FRANCISCO REALTOR DISTRICTS
District 1: Sea Cliff, Lake Street, Richmond (Inner, Central, Outer), Jordan Park/Laurel Heights, Lone Mountain
District 2: Sunset & Parkside (Inner, Central, Outer), Golden Gate Heights
District 3: Lake Shore, Lakeside, Merced Manor, Merced Heights, Ingleside, Ingleside Heights, Oceanview
District 4: St. Francis Wood, Forest Hill, West Portal, Forest Knolls, Diamond Heights, Midtown Terrace, Miraloma Park, Sunnyside, Balboa Terrace, Ingleside Terrace, Mt. Davidson Manor, Sherwood Forest, Monterey Heights, Westwood Highlands
District 5: Noe Valley, Eureka Valley (Castro, Liberty Hill), Cole Valley, Glen Park, Corona Heights, Clarendon Heights, Ashbury Heights, Buena Vista Park, Haight Ashbury, Duboce Triangle, Twin Peaks, Mission Dolores, Parnassus Heights
District 6: Hayes Valley, North of Panhandle (NOPA), Alamo Square, Western Addition, Anza Vista, Lower Pacific Heights
District 7: Pacific Heights, Presidio Heights, Cow Hollow, Marina
District 8: Russian Hill, Nob Hill, Telegraph Hill, North Beach, Financial District, North Waterfront, Downtown, Van Ness/ Civic Center, Tenderloin
District 9: SoMa, South Beach, Mission Bay, Potrero Hill, Dogpatch, Bernal Heights, Inner Mission, Yerba Buena
District 10: Bayview, Bayview Heights, Excelsior, Portola, Visitacion Valley, Silver Terrace, Mission Terrace, Crocker Amazon, Outer Mission
Some Realtor districts contain neighborhoods that are relatively homogeneous in general home values, such as districts 5 and 7, and others contain neighborhoods of wildly different values, such as district 8 which includes both Russian Hill and the Tenderloin.
Note that when they refer to “San Francisco” they mean a multi-county metro area.
The S&P Case-Shiller Index report for April 2011 (released 6/28/11) indicated the first increase in home prices for the San Francisco Metropolitan Statistical Area (MSA) in 8 months. This is based upon the Case-Shiller analysis of home sales data for the 5 counties of San Francisco, Marin, Contra Costa, Alameda and San Mateo. The statistics quoted by the media are almost always for the overall aggregate San Francisco MSA Index. And, excepting the mildly positive April report, the news has mostly been of continuing declines.
Unfortunately, the Case-Shiller overall aggregate Index is the wrong Case-Shiller Index to use when assessing market trends in the city and county of San Francisco itself (as opposed to the 5-county San Francisco MSA):
- First of all, it should be noted that the C-S Home Price Index tracks price trends for houses only (single family dwellings or SFDs) — not condos, co-ops, TICs or multi-unit buildings. And, as with all general statistics, what’s important are not the monthly fluctuations up and down, but consistent longer term trends: home values don’t actually fluctuate like stock prices. It should also be noted that there is typically a 4-8 week time lag between offer-acceptance and closed sales: thus April’s Index mostly reflects market activity in February and March.
- Furthermore, Case-Shiller tracks not only overall aggregate house prices, but house price trends broken into 3 price tiers: low, middle and high — dividing the total number of sales into thirds.
- The “High Tier” price range was defined by C-S in April 2011 as those homes selling for over $580,000 (the exact number changes monthly). In the city of San Francisco, over the past 17 months, roughly 70% of all our house (SFD) sales were over $580,000. If we exclude the two least affluent, southern Realtor districts running from Bayview to Oceanview (hit hardest by foreclosures and distress sales), and look only at the 8 central and northern Realtor districts, then over 90% of our house sales were in the “High Tier.” (Just for the record, the majority of our condo sales is also above $580,000.)
- Nationally, as well as in the state, Bay Area and the city of San Francisco itself, the lower the price segment, the harder hit it has been by distress sales (bank-owned property and short sales). The greater the percentage of distress sales in a price segment and its associated neighborhoods, the larger the decline in value over the past 3 to 5 years.
- The 5-county, SF Metro Area SFD housing stock — in all price tiers — in year 2000 was approximately 948,000 SFD units. The city of San Francisco contains about 114,000 SFD units — or only 12% of the metro area total. Thus the overall Index is heavily skewed toward the markets of the other 4 counties. However, the city’s percentage of SFD units in the higher price ranges would be significantly greater, though still a minority of total sales.
It’s obvious that the Case-Shiller High-Tier Price Index for the San Francisco MSA is the one most applicable to the real estate market of the city and county of San Francisco.
For the record, the SF MSA High Tier Index increased in both March and April 2011, but, as mentioned, monthly changes are only meaningful if consistent over the longer term.
Which brings us to the charts below:
Looking at the top chart of C-S Index “High Tier” price points in January of each year since the year 2000, we see the massive appreciation from year 2000 to peak values in 2006 – 2008 (different neighborhoods of the Bay Area and the city peaked at different times within that time period); then, after the September 2008 financial markets crash, an 18% – 22% decline to January 2009. That seems correct as an overall average for the price adjustment that generally occurred in San Francisco’s 8 central and northern districts.
The scale of the differences in impact on the respective price segments and on their associated areas of the Bay Area is enormous. Price declines from January 2006 to January 2009 for the “Low Tier” price segment (under $325k) was a staggering 57%; for the “Middle Tier” ($325k to $580k), it was a still huge 37%. The overall aggregate decline was 42%. Compare that to the “High Tier” decline of a very significant, but much lesser 22%, most applicable to SF’s 8 more affluent districts. (The 2 southern SF districts, dominated by sales in the upper-low and mid price tiers and hard hit by distress sales, saw declines typically running from 30% to 45%.)
(The second chart indicates the TOTAL declines in house prices from January 2006 to April 2011 for the 3 price-tier indexes and the aggregate Index.)
Post market meltdown, January 2009 to April 2011, over a period of 27 months, the C-S Index for “High Tier” priced homes shows a further 1.3% decline. Even if one refuses to consider a reasonable margin of error in the calculation (or that most of San Francisco houses should actually be in an “Upper High Tier” category), a price adjustment of 1.3% comes very close to what we’ve concluded for quite some time: generally speaking, San Francisco has experienced a basically stable home price market over the past 2 years, especially in the 80% of our Realtor districts where the median house sales price is typically above $850,000.
As noted above, though not shown on the charts, the Case-Shiller Index recorded small upticks in High Tier home values in both March and April 2011 for the SF MSA. (The Overall Aggregate Index for the SF MSA also ticked up in April for the first time in 8 months.) Based upon what we’re seeing in the city market, both statistically and in the hurly burly of deal-making — i.e. a significant tightening in the supply and demand dynamic within SF — we believe there is a good chance the Index will indicate further upticks in High Tier home prices in coming months as well.
If that occurs in a sustained manner, it might be yet another indication that San Francisco home prices did indeed hit bottom in 2009-2010 and are now starting to recover. Time will tell.
Further information on the data points and methodology of the S&P Case-Shiller Home Price Index is publicly available on their website.
Statistics are generalities, subject to fluctuation due to a variety of reasons. All information herein is derived from sources deemed reliable, but may contain errors and omissions, and is not warranted.