Total Available Market - 2, 3, and 4 units

[Chris Martin]

This post is specific to the Raleigh area, but the methodology is applicable to many other cities and counties in NC. 

In the Raleigh area many people, especially from out of state moving into the Raleigh area, post about wanting to by a quad, a 4 unit building. Often the posts refer to wanting a 'small multifamily' which, over time I have learned, translates for them to property financed as a traditionally underwritten 1-4 Family, owner occupied dwelling. 

The concept is sound: live in one unit and rent the rest. It's a great idea, assuming you can find a 2-4 unit that makes financial sense. 

The purpose of this post is to identify the Total Available Market (TAM) for all these asset classes, where the current owners are located, what year the units were built, and to see if it is possible to glean any market dynamics from the data. Data sources can be any or multiple of these: MLS (work with a broker), Zillow data services, realtyTrac, your local AHJ (Authority Having Jurisdiction) or county records group, a title company with in-house county property records, companies like coreLogic, eStated, trustee records, etc. Disclaimer: I haven't worked with many of these data sources for over 5 years now but many of them had similar data sets and several had APIs that were reasonable. Some were reasonably priced, some free(see note *), some expensive. I suspect most people will use MLS queries and you will (should) get the same results as in this post. For me, though, I use the low tech, no amenities interfaces from county data dumps because I am old school. To each his own. 

When you get your TAM report from your broker or via your data search, you should see something similar to one of these graphs: 

My graphs are based on public records, not MLS or Zdata, so there may be some discrepancy in your graphs. The takeaway here is that there are almost no new build quads or tris in the last 30 years, and there are a few dozen (at most) duplexes built in the past 30 years. So that's your TAM. Using simple ratios of 2-4 units relative to all Residential property, here's the result:

Type			% of Residential
Single Family			97.2
Duplex			0.74
Tri			0.13
Quad			0.15
Other			the rest

The Wake county Quad market consists of 95% in Raleigh, 5% not in Raleigh. The Owners of these quads consist of 91.5% owner of record addresses in NC, 2.5% in CA, 1.9% in NY. The Wake county duplex market consists of 71.5% in Raleigh, 8.7% in Cary, 4.0% in Wake Forest, 3.5% in Zebulon, 3.4% in Garner, other cities the rest. Owners of duplexes, like quads, are mostly NC at 93.7%, with CA and GA (1.8%, 0.7% respectively) followed by smaller percentages in other states. 

One significant item to note is that the "Other" category will include apartments (garden, rooming house, etc.) that will have one entry as far as the count, but the property record will have multiple cards that represent the individual units. So it is not the case that less than 2% of Residential units are apartments, in fact the count is higher. Quads (and duplexes and tris) are classified so that each unit is, basically, single carded as a unique real estate ID, so my counts don't need to consider separate cards. When you undertake analysis in other markets, keep this in mind because not all counties handle records the same way (hence, you need to normalize the data.)  

I had hoped to cover counts of 'transfers', units sold by type, but the data I'm seeing doesn't make sense to me at the moment. I will post when I have confidence the sales data reflect reality. In a nut shell, the numbers look too high. I looked at a couple of them and they were not arms-length transfers, so I need to get the 'real' sales. More later....

Methodology: TAM built only on Residential Land Classification with Type and Use of Two, Three, or Four Family. Searches consist of TAM counts, Year Built field annualized, Owner address (which state) in public record, location based on Physical City field. Queries are based on 6/1/19 datasets, so some results (e.g. ownership state) will change over time. 

Notes (*): The bigger counties (Mecklenburg , New Hanover, Wake, others) provide raw data and for some smaller counties you can download the data, indirectly, from the GIS user interface. In Columbus county, for instance, this is the case and there is a download button from the parcel GIS viewer.