Maui Million Dollar Home Sales ($1.0M+) – Day 4 of 10 – “Who Sold Them”?

From January 1, 2012 through September 16, 2013, a total of 231 “million dollar plus” homes sold in Maui County, generating total volume in excess of $525 million.  There are many ways that Hawaii real estate appraisers analyze sales statistics for luxury homes.  Because a proper market study for this segment would run many pages, I am posting one article per day for ten days.

Day 4 of 10 – Maui Million Dollar ($1.0M+) Single Family Homes By Agent

Consider the following graph and chart, 24 agents have sold four or more “million dollar homes” in the study period (ties sorted by first name alphabetical order):

Maui Million Dollar Home Sales By Agent

Maui Million Dollar Home Sales By Agent

Maui Million Dollar Single Family Home Sales By Agent
Sold From 1/1/2012 through 9/16/2013

Rank

Agent Name
# of
$1.0M+ Sales
1 Wendy R Peterson 11
1 William B Moffett Jr. 11
3 Robert H Dein 10
4 Mary Anne Fitch 8
5 Lori L Powers 7
5 Robert R Myers 7
5 Tom Tezak 7
8 John H Page-Papazian 6
8 Steve Blackington 6
10 Bob Hansen 5
10 Debbie Arakaki 5
10 Dennis Rush 5
10 Jeremy Stice 5
10 Martin Hauen-Limkilde 5
10 Nancy J Callahan 5
10 Vincent Palmieri 5
17 Courtney M Brown 4
17 Cynthia Warner 4
17 Dano Sayles 4
17 Diane K Pool 4
17 Jeannie Kong 4
17 Josh Jerman 4
17 Kathy Ross 4
17 Riette G Jenkins 4

Bottom Line: This is the big time.

No analysis required.  This data speaks for itself.  We’re talking about real estate professionals at the top of their game here.  They all deserve aloha and praise!

Questions or comments?  Please leave them in the comment  box below, I would be happy to clarify and/or expand.

Aloha, Chris

Maui Million Dollar Home Sales ($1.0M+) – Day 1 of 10 – “Where are the million dollar homes located?”

Since January 1, 2012, a total of 231 “million dollar plus” homes have sold in Maui County, generating a total dollar volume in excess of $525 million.

There are many ways that Hawaii real estate appraisers analyze luxury sales statistics.  Because a proper market study for this segment would run many pages, I will be posting one analysis per day for the next ten days.

Day 1 of 10 – Maui Million Dollar ($1.0M+) Single Family Homes By District

Consider the following graph and chart:

Day 1 - Maui $1.0M Sales By District

Maui Million Dollar Home Sales By District

Maui Million Dollar ($1.0M+) Single Family Homes By District
Sold From 1/1/2012 through 9/16/2013
District # of Sales % of Total
Wailea / Makena 42 18.2%
Lahaina 24 10.4%
Kaanapali 23 10.0%
Kula / Ulupalakua / Kanaio 20 8.7%
Maui Meadows 19 8.2%
Kihei 16 6.9%
Haiku 15 6.5%
Kapalua 15 6.5%
Spreckelsville / Paia / Kuau 15 6.5%
Makawao / Olinda / Haliimaile 11 4.8%
Napili / Kahana / Honokowai 11 4.8%
Wailuku 5 2.2%
Lanai 4 1.7%
Pukalani 3 1.3%
Molokai 2 0.9%
Olowalu 2 0.9%
Hana 1 0.4%
Kahakuloa 1 0.4%
Kipahulu 1 0.4%
Maalaea 1 0.4%
Total 231 100.0%

Maui’s three resort districts of Wailea / Makena, Kaanapali, and Kapalua are in bold.  As shown, almost 35 percent of Maui’s million dollar home sales since January 1, 2012 come from these three master planned communities. The second tier visitor areas of Lahaina, Kihei, and Napili/Kahana/Makawao log an additional 22 percent of the “million dollar” single family home sales on the Valley Isle.

Maui Resort and Second Tier Neighborhoods

Maui Resort and Second Tier Neighborhoods

 

Bottom line:  Location matters.

While upcountry locales are showing strong sales figures in the million dollar and above segment, Maui’s master planned resorts of Wailea/Makena, Kaanapali, and Kapalua lead the way.

Questions or comments?  Please leave them in the comment  box below, I would be happy to clarify and/or expand.

Aloha, Chris

Kauai Industrial Properties – Building Age Survey

The island of Kauai is home to some 313 industrial buildings on 237 parcels containing more than 2.5 million square feet of gross building area.

A typical industrial warehouse in Puhi, Kauai, Hawaii

A typical industrial warehouse in Puhi, Kauai, Hawaii

As shown in the table and pie chart below, nearly 90 percent of Kauai’s industrial buildings are less than 50 years old, with the oldest surviving structures being in the 70-79 year old age group.

Kauai Industrial Buildings

Zoned Limited Industrial (IL) and General Industrial (IG)

Age in Years

Count

% of Total

0-9

37

12%

10-19

57

18%

20-29

107

34%

30-39

39

12%

40-49

38

12%

50-59

9

3%

60-69

7

2%

70-79

19

6%

Total

313

100%

Kauai Industrial Buildings By Age - Pie Chart

The graph below depicts the extent of construction that took place after Hawaii became a State in 1959 (fifty-four years ago), and the large proportion of industrial buildings that were developed in the period of 1984 through 1993 (buildings aged 20 to 29).

Kauai Industrial Buildings By Age Group - Column Chart

A pdf copy of the County of Kauai Comprehensive Zoning Ordinance (CZO) can be downloaded here.

Of particular interest to Kauai industrial developers are the descriptions of the Garden Isle’s industrial districts:

(a) There are two (2) Industrial Districts:

(1) Limited Industrial (IL)
(2) General Industrial (IG)

(b) Limited Industrial shall include uses which are generally in support of
but not necessarily compatible with permissible uses in the Commercial District.

These Districts shall normally be established within reasonable accessibility and
convenience to General Commercial Districts and where there is adequate access to
a major thoroughfare.

(c) General Industrial shall include all business, industrial processing, or
storage uses that are generally considered offensive to the senses or pose some
potential threat or hazard to health, safety and welfare.

This District shall not be located adjacent to residential or resort districts unless there is physical or geographical protection from those characteristics of the uses considered to be offensive or hazardous.

If you have any questions of comments, please leave them in the comment box below.

Aloha, Chris

Hokua Luxury Condo Tower – Where are the owners from?

The Hokua condominium, located at 1288 Ala Moana Boulevard, is arguably Honolulu’s most prestigious high-rise address.

Hokua - Image Sourse: Bing Maps

Hokua – Image Source: Bing Maps

The 40-story tower, built in 2006 as a joint development venture between the MacNaughton Group, Kobayashi Group, and A&B Properties Inc,, sits between two highly desirable shopping destinations (Ala Moana Shopping Center to the east and Ward Center to the west), and benefits from excellent ocean views over Ala Moana Beach Park.

Where are the 248 Hokua unit owners from?

When appraisers are valuing a proposed high-rise condominium project, it is often appropriate to develop a market study that analyzes where potential purchasers are likely to come from.  According to tax records as of September 2013, Hokua units are owned by individuals from the following locales:

HOKUA UNIT OWNERS BY STATE / COUNTRY
State / Country # of Units Owned % of Total
Hawaii 177 71.4%
Japan 20 8.1%
California 18 7.3%
Other U.S. 5 2.0%
China 4 1.6%
Korea 4 1.6%
Canada 3 1.2%
Nevada 3 1.2%
New York 3 1.2%
Taiwan 2 0.8%
Florida 2 0.8%
Illinois 2 0.8%
Massachusetts 2 0.8%
Washington 2 0.8%
Switzerland 1 0.4%
Total 248 100.0%

In total, 86.3 percent of current Hokua owners are US based (71.4 percent from Hawaii) and 13.7 percent are foreign (Japan leading the pack with 8.1 percent).  These figures skew more toward Hawaii than I was expecting, although 35 or so units (about 14 percent) are owned by corporations, partnerships, LLC’s, or other entities that have Hawaii addresses, but are not necessarily controlled by owners who reside primarily in the Aloha State.  But by and large, it appears that Hokua’s reputation as the premier luxury tower for wealthy Hawaii residents is deserved.

Hokua owners by state and country

Source: Honolulu Tax Office records and Chris Ponsar, MAI

Future articles will analyze other luxury properties to see how other prestigious developments in Honolulu compare.

Questions, comments?  Please leave them in the comment box, I would be happy to clarify and/or expand.

Aloha, Chris

Is that thing a “fixer upper” or a “tear down”?

Today a friend asked me how real estate appraisers value properties that are in “below average” condition.  He wanted to know if we valued them in their “as is” condition, and whether or not repair costs were factored in.

In essence, how do you know if a property is a “fixer upper” or a “tear down”?

In a nutshell:

  1. If a property is in poor condition, an appraiser considers whether or not the value of the real estate, in its “as is” condition, exceeds the value of the underlying land.
  2. An appraiser determines this by analyzing the cost to repair the building to typical/average condition, and comparing the net value against the value of the underlying land, less demolition costs.

In detail:

It’s a relatively simple process, the appraisal buzzwords associated with this valuation method are “highest and best use” and “cost to cure”.

To demonstrate the analysis, I went on the Honolulu MLS and found a commercial property built in 1959, the same year Hawaii became a State.

Here, in all of its glory, is the poor condition (according to MLS)  office / retail property known as “1339 North School Street”:

1339 North School Street

1339 North School Street, Honolulu, Hawaii

A bunch of appraiser math/mumbo-jumbo below, skip to the chart at the end to see the answer.

For our purposes, the asking price is irrelevant, especially because the listing includes additional land parcels.  The figures used below are part of a simplistic appraisal demonstration only.

Let’s assume an appraiser determines that vacant land in the subject neighborhood is worth $100 per square foot.  Similarly, let’s assume average/typical commercial buildings are selling for $300 per square foot of building area.  The values would compare as shown below.

HYPOTHETICAL APPRAISED VALUES – 1339 N. School St.
Item Area in Square Feet Value Per Square Foot Total Value
Vacant Land 20,000 $100 $2,000,000
Less: Demolition Costs     -$100,000
Equals: Property Value   $1,900,000
       
Average Condition Building 7,500 $300 $2,250,000
    Difference $350,000

Since the value of an average condition building “as improved” is worth more than the property “assuming demolition”, we proceed to the next step: determining the value of the building in poor condition (its “as is” condition).

HYPOTHETICAL APPRAISED PROPERTY VALUE – COST TO CURE
Item Building Area
in Square Feet
Building Value
Per Square Foot
Total Value
Average Condition Building 7,500 $300 $2,250,000
Less: Cost to repair to average condition   -$500,000
Equals: Poor Condition Property Value   $1,750,000

Let’s assume a reputable contractor estimated the construction/repair cost necessary to renovate the subject building to “average” condition to be $500,000.  This amount is deducted from the “if in average condition” building value to arrive at the value of the overall property in poor condition of $1.75 million.

So, where are we at?

How does land value (assuming demolition) compare to property value (assuming renovation)?

HYPOTHETICAL APPRAISED VALUES – HIGHEST AND BEST USE
Item Total Value
Land Value Assuming Demolition $1,900,000
   
Poor Condition Property Value $1,750,000
Yep, it's a tear down.

Yep, it’s a tear down.

In this hypothetical scenario, the value of the underlying land, even after deducting demolition costs, exceeds the value of the poor condition property “as is”.  Therefore, the highest and best use of the property is demolition of the built-in-1959 (54 year old) improvements to make way for new development.

Questions, comments?  Please leave them in the comment box, I would be happy to clarify and/or expand.

Aloha, Chris

Hawaii Four Seasons Hotels – A resort real estate appraiser’s friend when data is tough.

Imagine you’re an appraiser in Hawaii, and you’re given the enviable task of appraising an oceanfront homesite in the Manele Resort on Larry Ellison’s island of Lanai.

There are only eleven oceanfront lots currently developed in the resort (as shown roughly in the aerial below) and only one lot has sold in the last decade (Lot 130, for $3,612,500 in May 2011):

Lanai Oceanfront with Parcel Shapes

Manele Resort – Eleven Oceanfront Homesites
Photo Source: Bing Maps

The sale of Lot 130 is a godsend, but other than that, what is an appraiser to do for comps?

We can’t very well do a one comparable appraisal: We’ve got to go off island.

Two resort areas of the State of Hawaii that are similar to Manele Bay in terms of climate and resort appeal are Wailea (Maui) and Hualalai (Big Island).  All three neighborhoods have oceanfront homesites that could potentially provide sale comparables, and all three master planned communities are home to a prestigious Four Seasons resort!

Four Seasons Manele Bay

Four Seasons Manele Bay

Four Seasons Hualalai

Four Seasons Hualalai

Four Seasons Wailea

Four Seasons Wailea

What gives? Being (arguably I’m sure) the most prestigious hotel operator (“flag”) in the State of Hawaii, Four Seasons resort properties must meet certain strict criteria in order to qualify as a potential member of the brand.  Each of the three resorts on Lanai (Manele), Maui (Wailea), and the Big Island (Hualalai) are world class hotels that were constructed between 1989 and 1996, and have been well maintained in the interim.   As such, the physical plant of each resort should have reasonably similar cost/value attributes. (The Hualalai resort is a newer “bungalow-style” design that likely has more market appeal)

Under the assumption that each of the three properties benefit from first class or better improvements, differences in room rates likely capture a good portion of the market’s preference for a specific location/resort.  For an appraiser starved for data in a highly-unique sub-market like Manele Bay/Lanai, hotel room rates can provide much needed market support for potential location adjustments.

Consider the following:

FOUR SEASONS – HAWAII OCEANFRONT RESORTS 
Best Available Room Rate – August 19, 2013
Island Resort Hotel Name Year Built Room Rate
Big Island Hualalai Four Seasons Resort
Hualalai at Historic Kaupulehu
1996 $920
Maui Wailea Four Seasons Resort
Maui at Wailea
1989 $595
Lanai Manele Four Seasons Resort
Lana’i at Manele Bay
1989 $459

That’s right, the best available room rate at the Four Seasons Hualalai is DOUBLE the same at Manele Bay!

The following chart shows the relationship of each hotel to its Manele cousin, and the indicated adjustment to equate each room rate to Manele:

Downward appraisal adjustments of 23 percent (Wailea) are serious business, never mind 50 percent allowances (Hualalai).  But for the appraiser who is digging deep for market support for a location adjustment, comparative hotel room rates are an interesting value indicator to consider.  In a future article I’ll examine the three neighbor island resorts in greater detail and see if these price relationships hold.

Questions, comments?  Please leave them in the comment box, I would be honored to clarify and/or expand.

Aloha, Chris

Proposed Honolulu Condo Towers – The List of 12

These days in Hawaii, one of the most common topics real estate appraisers are confronted with is: “Have you heard about that new tower they announced in Kakaako?”

Very often, I’m asked for specifics about a new high rise condominium development in Honolulu.  I decided to compile a concise list.

There is an enormous amount of development activity happening in Hawaii right now, especially in urban Honolulu.  Major developers, lenders, and landowners are involved, including: Alexander and Baldwin (A&B), Howard Hughes Corporation, The MacNaughton Group, Kobayashi Group, OliverMcMillan, Tradewind Capital, Kamehameha Schools, Stanford Carr, American Savings Bank, Bank of Hawaii, Central Pacific Bank, Wells Fargo, and First Hawaiian Bank.

As I started to put this list together, I quickly realized that the variety of residential projects being planned was staggering: High-rise condos, student housing, timeshare, hotel, high-rise apartments, low-rise condominiums, senior housing, and even affordable housing for artists!

Here are the parameters for inclusion in this article:

  • High-Rise Construction
  • Fee Simple Condominiums
  • Whole Ownership (No Timeshare)
  • An active development plan on track for approvals, financing, and construction.

12 Oahu towers made the cut, a total of 4,166 proposed units–web links and a brief summary of each project is included below:

2013 PROPOSED / COMPLETED HIGH RISE CONDOMINIUM TOWERS
Oahu, Honolulu, Hawaii
# Tower Name (click name) Stories Units Status / Timing
1 Holomua 23 176 Completed: Early 2013 
2 Waihonua at Kewalo 43 341 Under Construction
Completion: 2014 of 2015
3 ONE Ala Moana 23 210 Under Construction
Completion: Late 2014
4 Symphony Honolulu 45 388 Groundbreaking: Late 2013
Completion: 2015
5 801 South Street 46 635 Groundbreaking: “Mid-2013”
6 Ritz-Carlton Residences,
Waikiki Beach
36 309 Groundbreaking: Late 2013
Completion: 2016
7 The Collection
(3 buildings, 1 high rise)
43 460 Groundbreaking: Mid to Late 2014
Completion: Late 2016 to 2017
8 404 Ward Ave 38 424 Groundbreaking: Early 2014
Completion: 2016
9 Keauhou Lane in Kakaako 40 600 Groundbreaking: Mid to Late 2014
10 Aloha Kai 39 128 Completion: 2016
11 “Fishnet Tower” 38 177 Proposed
12 “Wave Tower” 38 318 Proposed
Compiled by: Chris Ponsar, MAI   4,166 Total Units

The map below shows the location of each project in urban Honolulu:

Oahu Condo Project Map - Chris Ponsar, MAI

Click HERE to view details in Bing Maps

This link: http://binged.it/13RCPpX takes you to an interactive Bing Map that shows photos and details of each project.  As shown, most of the activity is in Kakaako.

Want more details?

Here you go:

Proposed Honolulu Condo Towers - Detail

CLICK CHART TO ENLARGE

Comments and/or Questions?  Please leave them in the comments section below–I’d be happy to clarify or expand.

Aloha, Chris

Interest Rates and Hawaii Residential Prices–Are They Really Connected?

I posted an article a few days ago that examined the theoretical relationship between interest rates and purchasing power.  The calculations beg the question “are interest rates and Hawaii home prices actually connected?”

Logic says “of course!”, the data suggests “not so much!”

Let’s assume a 20 percent down payment, market loan fees (points), and monthly payments of 35 percent of a household’s gross income.

The following chart shows State of Hawaii median income, condominium median prices, single family median prices, and national average interest rates for 30-year mortgages from 1987 through 2011 (the latest year for which all data points are available).

Sources: U.S. Census Bureau, Freddie Mac, Hawaii State Data Book, and Chris Ponsar, MAI

Based upon the income and interest rates shown, the median Hawaii family could afford a monthly payment of $1,021 in 1987, and $1,722 in 2011.  These payments equate to affordable home prices of $114,370 in 1987, and $341,898 in 2011. (A pretty hefty increase in purchasing power, driven largely by lower interest rates)

Lets see how the figures track with historic price fluctuations in the Hawaii residential real estate market.

Hawaii Home Affordability vs Median Prices

The red and green trendlines track single family and condominium prices in the study period–as shown, condos and single family home prices track pretty well.

How about affordability (the purple trendline) based on interest rates ?

The long term trend is clearly positive for all variables, with affordable price, condo price, and single family price all being about 3x higher in 2011 than they were in 1987.

But that’s not the question most folks are asking.  The market participants I talk to are generally trying to answer the question “If interest rates go up (this year, or next year), will prices go down (this year, or next year)?”  Is it a causal relationship?

What do you think?  Personally, beyond long term growth, I don’t see a strong relationship in the data, and neither is a solid correlation revealed in geeky statistical analyses.

Why isn’t the correlation better?

Higher interest rates do equate to lower affordability for a particular household, but why doesn’t that relationship translate well into median prices?

A few suggestions:

  1. Median prices are not the best way to measure market trends–overall dollar volume and the raw number of sales may provide more insight (and material for a future article)
  2. Hawaii’s population continues to grow faster than new housing units are developed–fundamental demand grows incrementally in both good times and bad. (Which explains the overall upward trend in prices, but not the ups and downs in particular years)
  3. When monthly payments go up, families still need shelter.  For those families contemplating a home purchase, spending on discretionary items will likely suffer first (say vacations or luxury items)–these spending habit adjustments allow families to absorb a certain amount of extra monthly payment caused by increased interest rates.
  4. When prices start to decline, sellers may opt not to put their home on the market.  Financially stable homeowners can afford to “hold out” for their desired price, which restricts supply, and in turn has a stabilizing effect on prices.

Frankly, when I began researching the data for this article, I expected to see a pretty reasonable relationship between affordability and median prices–instead, we see that from the perspective of a current homeowner, prices appear not to fluctuate on a “dollar for dollar” basis with interest rates. From an appraiser/appraisal perspective, it is imperative to observe how the market reacts to the rising rates that are currently anticipated, not just automatically assume lower prices if interest rates rise.

Comments and/or Questions?  Please leave them in the comments section below–I’d be happy to clarify or expand.

Aloha, Chris

Rising Interest Rates = Decreasing Purchasing Power?

bernanke_ben

Fed Chairman Ben Bernanke

As early as March 1 of this year, the Fed began to hint at increasing interest rates.  Now, financial markets globally are pondering the same.

What would an increase in interest rates do to home purchasing power in Hawaii?  Consider the following graph:

Rising Interest Rate Declining Purchasing Power

Graph Credit: Nate Alexander

As of June 2013, the median single family home price on Oahu was $677,250.  The chart above assumes the median home in the City and County of Honolulu is affordable at a 30-year interest rate of 4.00 percent (30-year fixed, 80% LTV, 33% debt service to income ratio).  Rate increases at intervals of 25 basis points (0.25%) are shown.

The impact of just a one percent increase in interest rates is staggering: The same family making the same income can suddenly only afford only a $602k home–approximately 11 percent less.

The graph below presents the data in terms of percent:

Graph Credit: Nate Alexander

Graph Credit: Nate Alexander

What if interest rates rose two percent?  The effective purchasing power of the same household would decrease more than 20 percent!  Bear in mind that 30-year interest rates of 6.00 percent are not historically uncommon–when my wife and I purchased our first home in 2005, our rate was 5.625 percent.

Ok.  Shock and Awe.  What’s the point?  Are we going down the tubes?

The point of this article is to show how an increase in interest rates can affect the purchasing power of a particular household, not to predict the impact of rate increases on median prices (or the price of your home).  In other words, if you can afford a $675k house at 4.0% interest, you’ll only be able to buy a $600k home if rates increase just one percentage point–all other factors being equal.

In a future post, I’ll talk about how historic interest rates track (or don’t track) with historic median prices, and how interest rates relate to sales volume (demand).

Comments and/or Questions?  Please leave them in the comments section below–I’d be happy to clarify or expand.

Aloha, Chris

Kapahulu – Diamond Head: Unscathed by the Great Recession?

I was at lunch with a friend this week, and he suggested the idea that home prices in his neighborhood (near Diamond Head) may have escaped the Great Recession altogether and, in fact, appreciated a bit along the way.

While it is common knowledge that the worldwide financial crisis did great damage to real estate prices in much of the United States, Hawaii was impacted less, and it is certainly possible that a desirable sub-market (like the Diamond Head area) could have emerged unscathed.

I decided to check it out.

MLS Local Market Statistics – Kapahulu – Diamond Head

The graph and data table below shows MLS sales statistics for the Kapahulu – Diamond Head area from 2002 through June 2013:

Source: Honolulu Board of REALTORS® and Chris Ponsar, MAI

Source: Honolulu Board of REALTORS® and Chris Ponsar, MAI

The graph clearly shows the amazing run up in prices experienced in the subprime era (pre-2008), with median price peaking at over $800,000 in 2007 (number of sales topped out at 319 in 2004).

A closer look reveals the supply/demand relationship: As the median price continued to climb after 2004, fewer and fewer buyers were pulling the trigger.  Conversely, when median prices bottomed out in 2009, demand began to increase.

The following table analyzes the data a little differently:

Kapahulu - Diamond Head - Year over Year

From the peak of the market in 2007, the Kapahulu – Diamond Head submarket declined four and nine percent in 2008 and 2009, respectively, and about 13 percent overall, before recovering a bit in 2010.

Considering these figures, it looks like my friend’s neighborhood took a moderate price hit after the collapse of Lehman Brothers….but our work isn’t done.

Wait a minute.  Kapahulu – Diamond Head, that’s kind of a mixed bag, isn’t it?

It is.  And as it turns out, much more mixed than I originally thought.

The Honolulu Board of REALTORS®  defines the Kapahulu – Diamond Head Local Market Area as including sections (1) 3-1 through (1) 3-4.  The map below approximates the boundaries of this area.

Sources: Bing Maps, City and County of Honolulu DPP, and Chris Ponsar, MAI

Sources: Bing Maps, City and County of Honolulu DPP, and Chris Ponsar, MAI

As you can see, the following neighborhoods are included in this statistical area:

  • Kapahulu
  • Diamond Head
  • Kaimuki
  • Wilhelmina Rise
  • St. Louis Heights
  • Palolo

If you’re familiar with Honolulu, you’ll quickly realize that is quite a diverse spread of neighborhoods!  Great aloha to be had everywhere, but buyers looking to purchase around Diamond Head might not consider the other areas to be substitutable options.

Could my friend be right?  Is it possible that his neighborhood (Diamond Head) is a micro-market that survived the Great Recession better than the other areas in his MLS Local Market?  It makes logical sense that a desireable location like Diamond Head could have bucked the trend–let’s dig deeper.

Time to bring out the big guns – Paired Sales Analysis

My friend lives in Section (1) 3-1, which is shown on the maps below:

City and County of Honolulu, Department of Planning & Permitting

City and County of Honolulu, Department of Planning & Permitting

City and County of Honolulu Tax Map - First Division, Zone 3, Section 1

City and County of Honolulu Tax Map – First Division, Zone 3, Section 1

Commonly referred to as “Paired Sales” in Hawaii appraisal circles, “Paired Data Analysis” is defined as:

paired data analysis

A quantitative technique used to identify and measure adjustments to the sale prices or rents of comparable properties; to apply this technique, sales or rental data on nearly identical properties is analyzed to isolate and estimate a single characteristic’s effect on value or rent. Often referred to as paired sales analysis.

Source: Appraisal Institute, The Dictionary of Real Estate Appraisal, 5th ed. (Chicago: Appraisal Institute, 2010).

In order to accomplish this, I researched sales activity in Section (1) 3-1 (my friend’s general neighborhood) from 2004 through 2010, focusing on sales of single family homes that were listed by the selling agent as being in “average” or better condition.

My research found 22 “pairings”, single family homes in (1) 3-1 that sold in late 2004, 2005, 2006, or 2007 (the peak of the market), and later resold from September 15, 2008 (Lehman Brothers)  through the end of 2010.  Of these 22 pairings, 10 were substantially remodeled in the interim, and thus not considered.

(1) 3-1 Paired Sales Pie Chart

After the 10 remodeled pairings were removed, 12 “pure” pairings remained–resales of homes that were substantially similar in the time frame being studied.  These 12 sales are analyzed in the chart below:

Diamond Head Paired Sales

Click To Enlarge

As you can see, 10 of the 12 paired sales show price declines in the study period, ranging from negative 0.6 percent to negative 25.6 percent.  The two positive indicators showed upward figures of 1.4 and 0.6 percent.  The overall average price change for the 12 “pure” pairings (not remodeled) in Section (1) 3-1 was negative 8.3 percent.

Conclusion: Still looks like a price drop after Lehman Brothers, but not a huge one.

In the end, even though the Kapahulu-Diamond Head MLS statistical zone includes a diverse range of neighborhoods, it appears that the immediate Diamond Head area, like much of the United States, did indeed suffer a setback (negative 8.3 percent according to this analysis) in the early portion of the worldwide financial crisis.