Photo by John T.
HDB Flats: Prices, Bubbles, and Policy
Introduction
Transforming Singapore into a ‘Smart Nation’ has been a key aspiration of the Singapore government since it was rolled out as an initiative in 2014. Harnessing technology to enhance citizens’ lives and to promote opportunities for growth has already borne fruit in several sectors such as transportation (Parking.sg) and mobile banking (PayNow), with many other schemes still in the pipeline.
One underlooked aspect of this initiative is the public release of some government datasets as part of a movement towards open data. Datasets from various ministries and agencies are made available on a consolidated repository, Data.gov.sg, which makes it easier for the public to access and download such data. Many cities around the world have adopted a similar approach, with New York, London, and Berlin being prime examples.
Beyond transparency and accountability, another compelling reason to make more data open to the public is that it promotes civic engagement on issues that matter to all Singaporeans. Having access to rich datasets on important topics, be it housing, healthcare, or transportation, would encourage more citizens to explore the data themselves and become genuine partners in the policymaking process.
In that spirit, this post explores the HDB resale flat prices dataset, released by HDB and available online here. For reproducibility reasons, the R code used to process the data is available on my GitHub page here, and all Tableau charts are available on my Tableau Public page.
Unfortunately, due to the Tableau dashboards and tables presented here (and my lack of HTML skills), this post is not mobile-friendly and is best viewed on a computer instead.
Exploring the data
The HDB resale flat prices dataset provides data on every HDB resale flat transaction since 1990, along with details such as the resale price, the flat type, flat size, and neighbourhood. The main processing step I took was to adjust prices for inflation, using 2014 prices as the benchmark. Data on the yearly Consumer Price Index was obtained from SingStat. I also removed all transactions of flats in Lim Chu Kang, since there were less than 50 entries and all occurring before 2000. It’s also helpful to note that some transactions may refer to flats that no longer exist (quite a few of them actually!) so you may not be able to find all the addresses on Google Maps anymore.
Neighbourhoods
The first question that popped into mind was: which are the hottest neighbourhoods for HDB resale flats nowadays? Most of us already know this to some extent (Bukit Merah, Bishan, Toa Payoh etc), but it would be interesting to see how much of a difference there is between neighbourhoods located centrally and those further out.
In the Tableau dashboard below, I visualise the HDB resale flat transactions data in two ways. The map aggregates the transactions data on a neighbourhood level, with each region coloured by how high the average resale price is. The scatter plot shows the relationship between the average resale price and the number of transactions for every neighbourhood. The grey (linear regression) line through the scatter plot gives us a generalisation of the correlation between the average resale prices and the number of transactions.
Clicking on any of the neighbourhoods in the dashboard will highlight the relevant data points to that neighbourhood throughout both charts. Also, by default, the dashboard looks at transactions from 2014 to 2018 and for only 4 room HDB flats, but you can change these settings using the slider and dropdown box at the top of the dashboard. Feel free to play around with the dashboard for a bit before reading on.
One problem with calculating the average price from all transactions is that it will be understated for neighbourhoods with more 1 and 2 room flats, since these are much cheaper than 5 room and executive flats. For the analysis below, I filter for only 4 room flats, the most common flat type in the dataset, to compare the neighbourhoods on a fairer basis.
It is no surprise that Bukit Timah and the central area (mostly Chinatown and Little India) have one of the highest average resale flat prices over the past five years, with Bukit Merah and Queenstown making it into the top four. The northern and western regions have the cheapest 4 room flats, with Woodlands and Choa Chu Kang having the lowest prices.
None of this is news, but what’s interesting is when you move the date range to the early 2000s (January 2000 to December 2004). The most expensive neighbourhood then was Queenstown, far ahead of Bukit Timah and the central area, with Bishan, Toa Payoh, and Marine Parade coming in much closer than they did in recent years. Tampines and Pasir Ris were slightly more expensive than their adjacent neighbourhoods (Bedok, Hougang, and Sengkang), and Yishun and Bukit Panjang were the cheapest neighbourhoods to purchase a resale flat in. Scroll the date range all the way back to January 1990 and you’ll see that Pasir Ris was the most expensive neighbourhood and Queeenstown one of the more affordable ones, which serves as an interesting foil to what we’re seeing today.
HDB Flats
Instead of aggregating the data on a neighbourhood level, why not do it on a building level? Doing this would show how many flats there are contributing to the neighbourhood-level calculation. Bukit Timah has very few flats in contrast to Sengkang, for example. Doing this required some geocoding (converting the addresses to longitude and latitude coordinates), which I did in R before joining it to the resale flats dataset.
The dashboard below averages the resale prices for each unique HDB building in the dataset, and visualises each HDB building as a point in the map. The colour corresponds to how high the average price for units within that HDB building is compared to other HDB buildings. As before, you can filter the data using the date range and the flat type. This time, you can also select which neighbourhoods you want to focus on by checking or unchecking the neighbourhood from the list on the right.
Caveat: One thing you might notice is that the neighbourhoods don’t exactly line up with where they are marked on the Tableau map. The main reason for this is because Tableau uses URA’s Planning Areas to geocode the neighbourhoods, but these have changed over the past three decades (URA’s Master Plans are revised every 5 years) and as such may not correspond to the latest neighbourhoods as they are defined today.
Unlike the earlier dashboard which aggregated the data on a neighbourhood level, seeing it on a building-level helps us to appreciate other reasons for the higher prices in places like Toa Payoh and Bishan - there are just fewer HDB flats in these neighbourhoods than in the adjacent areas like Ang Mo Kio. The premium for staying close to the MRT is also immediately visible: the cluster of flats near Serangoon MRT are considerably more expensive than those slightly further out. In the heartland areas like Tampines, Jurong West, and Woodland, prices are more similar throughout the entire neighbourhood (the prices have a smaller variance).
Units
Another interesting thing to do with large datasets is to look at the extremes. In the case of HDB flats, some natural measures include the flat size, the period between transactions, and the resale prices. Unfortunately it was a bit tedious to do this on Tableau, so I used R instead to filter the data accordingly. The first thing I did was to look at flat sizes, which are provided in the dataset.
Address | Flat Type | Flat Model | Storey Range | Lease Start | Transaction Date | Real Resale Price | Floor Area |
---|---|---|---|---|---|---|---|
52 Jln Bahagia | 3 Room | Terrace | 01 to 03 | 1972 | Aug 1997 | $896507 | 307 sq m |
58 Jln Ma’mor | 3 Room | Terrace | 01 to 03 | 1972 | May 1994 | $476326 | 297 sq m |
53 Jln Ma’mor | 3 Room | Terrace | 01 to 03 | 1972 | Sep 1998 | $677534 | 280 sq m |
65 Jln Ma’mor | 3 Room | Terrace | 01 to 03 | 1972 | Sep 2000 | $735206 | 266 sq m |
43 Jln Bahagia | 3 Room | Terrace | 01 to 03 | 1972 | Jun 1992 | $307388 | 261 sq m |
54 Jln Ma’mor | 3 Room | Terrace | 01 to 03 | 1972 | Feb 1996 | $668689 | 261 sq m |
57 Jln Ma’mor | 3 Room | Terrace | 01 to 03 | 1972 | Sep 2000 | $688420 | 259 sq m |
42 Jln Bahagia | 3 Room | Terrace | 01 to 03 | 1972 | Oct 1993 | $351808 | 250 sq m |
65 Jln Ma’mor | 3 Room | Terrace | 01 to 03 | 1972 | Dec 2008 | $733946 | 249 sq m |
64 Jln Ma’mor | 3 Room | Terrace | 01 to 03 | 1972 | Jul 1992 | $262404 | 246 sq m |
The largest flats in Singapore are all located near each other, just southwest of the intersection between the PIE and CTE. The designation of “Terrace” as the flat type was particularly intriguing, since we are more accustomed to seeing HDB flats as part of tall buildings. If you look at the Street View on Google Maps for these addresses, you’ll see that it looks more similar to terraced houses in private estates than to the conventional HDB flats.
The next thing I looked at was the period between transactions, which I took to be the gap between any two transactions for the same HDB flat in the dataset. The idea here is to see what the maximum occupancy period has been for flats that have been sold on the resale market.
One problem here is that the dataset doesn’t identify a unique HDB flat - it only provides information on the address, flat type, flat model, and storey range for each flat that was transacted. Using this data should help us uniquely identify some flats in the dataset, but of course there is a good chance that two flats belonging to the same floor got sold within a 28 year period. As such, the period between transactions calculated here will, in some cases, understate the true length of time.
Address | Flat Type | Flat Model | Storey Range | Lease Start | Transaction Date | Real Resale Price | Duration |
---|---|---|---|---|---|---|---|
248 Hougang Ave 3 | 4 Room | New Generation | 10 to 12 | 1984 | Nov 2018 | $320199 | 6879 days |
868 Woodlands St 83 | Executive | Maisonette | 01 to 03 | 1996 | Nov 2018 | $575357 | 6819 days |
432 Jurong West St 42 | 4 Room | Model A | 04 to 06 | 1984 | Nov 2018 | $389129 | 6788 days |
362 Tampines St 34 | 5 Room | Improved | 01 to 03 | 1996 | Aug 2018 | $435270 | 6756 days |
857 Jurong West St 81 | 5 Room | Improved | 01 to 03 | 1996 | Jul 2018 | $360223 | 6725 days |
112 Clementi St 13 | Executive | Maisonette | 01 to 03 | 1984 | Jun 2018 | $833517 | 6666 days |
113 Tampines St 11 | 4 Room | Model A | 04 to 06 | 1982 | Oct 2018 | $455282 | 6666 days |
105 Towner Rd | 3 Room | Model A | 04 to 06 | 1984 | Nov 2018 | $447778 | 6666 days |
427 Tampines St 41 | Executive | Maisonette | 01 to 03 | 1986 | Apr 2018 | $600372 | 6665 days |
151 Pasir Ris St 13 | 4 Room | Model A | 01 to 03 | 1995 | Jul 2018 | $408253 | 6665 days |
The longest period between transactions for the same HDB flat in the dataset is over 18 years, which also happens to be true for the top 10 highlighted in the table above. All the transactions also happened last year, and if we take the 18 years to be accurate, then the none of the sellers should be the original occupants of the HDB flats (based purely on the starting date of the lease).
Finally, the most exciting thing to look at: prices. Let’s look at the top 10 prices within the whole dataset.
Address | Neighbourhood | Flat Type | Flat Model | Storey Range | Lease Start | Transaction Date | Real Resale Price |
---|---|---|---|---|---|---|---|
102 Bishan St 12 | Bishan | Executive | Maisonette | 22 to 24 | 1987 | Nov 1996 | $1240866 |
652 Yishun Ave 4 | Yishun | Executive | Apartment | 01 to 03 | 1992 | Jun 1996 | $1217427 |
117 Bishan St 12 | Bishan | Executive | Maisonette | 22 to 24 | 1987 | Aug 1996 | $1199504 |
285 Bishan St 22 | Bishan | Executive | Maisonette | 19 to 21 | 1992 | Oct 1996 | $1196746 |
273b Bishan St 24 | Bishan | 5 Room | Dbss | 40 to 42 | 2011 | Feb 2017 | $1185906 |
41 Jln Bahagia | Kallang/Whampoa | 3 Room | Terrace | 01 to 03 | 1972 | Sep 2018 | $1185735 |
1d Cantonment Rd | Central Area | 5 Room | Type S2 | 40 to 42 | 2011 | Oct 2018 | $1168725 |
148 Mei Ling St | Queenstown | Executive | Apartment | 19 to 21 | 1995 | Jul 2017 | $1165806 |
57 Jln Ma’mor | Kallang/Whampoa | 3 Room | Terrace | 01 to 03 | 1972 | Dec 2016 | $1162415 |
139a Lor 1a Toa Payoh | Toa Payoh | 5 Room | Dbss | 40 to 42 | 2012 | Aug 2018 | $1161608 |
Surprisingly, the top spots are taken up by transactions which occurred way back in late 1996. The remainder of the top ten spots were sold within the past three years, and were located in neighbourhoods near the CBD. All of these flats were sold at a real price of over $1.1 million, which is incredible when you realise that this is nearly three times the average cost of a 4 room HDB flat in some parts of Singapore. These flats are also large - 5 room, executive, and terraced flats have the largest floor sizes of HDB flats.
So what exactly happened in 1996? Why were housing prices so high then? I pulled up the transactions involving only these flats in the top 10, and here is the transaction history for the maisonette at Block 102 Bishan Street 12 (with the highest real resale price).
Address | Neighbourhood | Flat Type | Flat Model | Storey Range | Lease Start | Transaction Date | Real Resale Price |
---|---|---|---|---|---|---|---|
102 Bishan St 12 | Bishan | Executive | Maisonette | 22 to 24 | 1987 | Sep 1991 | $459932 |
102 Bishan St 12 | Bishan | Executive | Maisonette | 22 to 24 | 1987 | Apr 1993 | $530644 |
102 Bishan St 12 | Bishan | Executive | Maisonette | 22 to 24 | 1987 | Mar 1994 | $618513 |
102 Bishan St 12 | Bishan | Executive | Maisonette | 22 to 24 | 1987 | Nov 1996 | $1240866 |
102 Bishan St 12 | Bishan | Executive | Maisonette | 22 to 24 | 1987 | Dec 1998 | $898411 |
And here it is for Block 652 Yishun Avenue 4, with the second highest real resale price.
Address | Neighbourhood | Flat Type | Flat Model | Storey Range | Lease Start | Transaction Date | Real Resale Price |
---|---|---|---|---|---|---|---|
652 Yishun Ave 4 | Yishun | Executive | Apartment | 01 to 03 | 1992 | Jun 1996 | $1217427 |
652 Yishun Ave 4 | Yishun | Executive | Apartment | 01 to 03 | 1992 | Jul 1997 | $837872 |
Notice how the resale prices for both HDB flats essentially crashed after hitting their peaks in 1996 - the flat owners who bought them in late 1996 lost nearly $400,000 in the span of one or two years. Most people will know of the 1997 Asian Financial Crisis, but that doesn’t explain how the top 4 prices for HDB resale flats since 1990 comprise transactions that occurred in the mid-1990s. To really understand what happened, we have to dig a bit deeper into the data and into the recent history of Singapore’s housing policy.
Looking back to the mid-1990s
The line graph below provides an overview of how HDB resale flat prices have changed since the 1990s, differentiated by flat type. Recall again that prices are adjusted to correct for inflation, which are indexed at 2014 prices – this gives us a more accurate comparison across time.
The most immediate observation here is the two peaks in the graph: one around 1996 Q3 and another around 2012 Q4. There is a trough in the middle, caused by a consistent slide or stabilisation in resale flat prices for 7 full years (from 2000 to 2006). In contrast to the relative volatility in the earlier two decades, prices have remained reasonably stable over the past 5 years.
Admittedly, I was quite surprised to see a housing price bubble in the mid-1990s. The post-recession rise in housing prices was a hot-button issue in the 2011 General Elections, but there was little talk about the earlier housing bubble just fifteen years ago. Resale flat prices nearly tripled between 1993 and 1996 across all flat types, a rate not nearly matched by the 2007 to 2011 increase in housing prices.
After a Google search and a quick browse through some papers, I found a section from this paper (Phang & Kim, 2013) particularly illuminating:
In his memoirs, Mr Lee Kuan Yew (who remained in the Cabinet as Minister Mentor to Goh’s government) recalled this as an event in which the government yielded to popular pressure: “I should have known that it does not pay to yield to popular pressure beyond our capacity to deliver. Yet I was party to a similar mistake in the early 1990s. As property prices rose, everybody wanted to make a profit on the sale of their old flat and then upgrade to a new one, the biggest they could afford. Instead of choking off demand by charging a levy to reduce their windfall profits, I agreed that we accommodate the voters by increasing the number of flats built. That aggravated the real estate bubble and made it more painful when the currency crisis struck in 1997. Had we choked off the demand earlier, in 1995, we would have been immensely better off (Lee, 2000, p. 121).”
With this in mind, I revised the original graph to include some additional information. In the graph below, the blue shaded regions represent periods of time when the government introduced property cooling measures (information obtained from the same paper above) while the red shaded regions are the quarters when Singapore experienced a negative GDP growth rate. Singapore’s real GDP growth across time is also visualised in the chart below.
Cooling measures were first introduced on 15 May 1996 and had a nearly immediate effect in containing the spike in resale flat prices that had been rising rapidly since 1995 Q1. By the end of 1996, the prices plateaued for all flat types and began falling for the more expensive flat types, suggesting that the cooling measures had worked in deflating the housing bubble.
Unfortunately, the first waves of the 1997 Asian financial crisis hit Thailand and Indonesia on May and July 1997 respectively, and we can observe a one-quarter lagged impact on Singapore’s real GDP growth rate in 1997 Q4 and 1998 Q1. This caused housing prices to fall even further as Singapore slipped into a recession for almost a year. Despite the subsequent recovery in prices in 1999, prices slid continually for seven years for 5 room and executive HDB flats and rose only slightly for 3 and 4 room HDB flats. The Dotcom bubble in 2001 and the SARS crisis in 2003 did not help much in that respect.
With the benefit of hindsight, Lee Kuan Yew makes a fair point about the timing of the cooling measures. If they were implemented in early 1995 instead, the housing market may have been stabilised before the 1997 Asian financial crisis, preventing the extended freefall of resale flat prices from 1996 Q4 to 1999 Q1. Perhaps this lesson motivated the government’s decision to begin implementing cooling measures in 2009, even though the economy had just begun recovering from the country’s longest recession in two decades.
The late 2000s
All of the above focused very keenly on the mid-1990s housing bubble, but there are also some interesting questions to ask about the more recent increases in resale flat prices. For one, why were the cooling measures from 2009 to 2012 unable to stabilise prices more rapidly?
To answer this, we have to look a bit further back to the early 2000s. In his collection of commentaries, ‘Reflections on Housing a Nation’ (available online here), former Minister of National Development Mah Bow Tan writes:
At the height of the property boom in the mid-90s, there were as many as 150,000 buyers in the queue, and the wait for a flat was as long as seven years. However, when the Asian Financial Crisis struck in 1997, the queue vanished, virtually overnight. HDB ended up with 31,000 unsold flats, which took more than five years to clear.
Data on the number of HDB flats built every year is available online as well, so here is a graph which makes essentially the same point.
The number of HDB flats built yearly hit a peak in 1998, two years after the peak in HDB resale flat prices and right in the middle of Singapore’s first recession in the decade. The subsequent drop in flats built every year is a sensible response to the immense surplus of flats, especially since these HDB flats were viewed as retirement nest eggs and the government could not afford for these prices to spiral downwards further. Another paper (Lum, 2011) points out that government sales of confirmed land sites were suspended from late 2001 to early 2007 – mainly to offload the huge surplus of HDB flats and to revive the housing market. This tracks what is being depicted in the graph above, with the grey region highlighting the government’s efforts at curbing the oversupply.
While public housing supply was significantly reduced from 2001 to 2007, the demand for HDB flats had begun to rise from 2005 onwards. Measures to promote market demand, such as reducing stamp duty rates and lowering the minimum occupation period to one year, coincided with a strengthening global economy from 2005 to 2007. Moreover, a rise in foreign capital flows into Singapore kept domestic interest rates low, making the speculative flipping of resale flats a highly profitable endeavour.
Yet, if this was the full story, then prices ought to have fallen when the Global Financial Crisis began to hit in 2008 Q2. Singapore was hit with a GDP contraction of -8.36% in 2009 Q1, but resale flat prices only dropped slightly or remained stable during that period. In contrast, Singapore’s worst quarter during the Asian Financial Crisis saw a -5.29% change in real GDP, and prices fell across all flat types.
We have to look elsewhere for the answer: Singapore’s population growth.
While the government suspended land sales and the construction of HDB flats, population growth continued apace except for the brief interruption in 2003 caused by the SARS crisis. In the ten years between 1999 to 2008, the residential population grew by over 400,000 amidst the lowest construction rates for HDB flats since the 1990s. What is missing from the visualisation is the fact that non-resident population growth also surged during those years (also identified by Lum, 2011), adding further to the strain on the supply of public housing by encouraging existing flat owners to rent rather than sell their flats.
As such, resale prices did not drop much during the recession and picked up immediately again once Singapore started to recover in 2009 Q2 and Q3. There was simply overwhelming demand for a limited supply of HDB flats, which was enough to keep resale prices from crashing even after the 2009 Global Financial Crisis recession and the cooling measures. In contrast, prices fell nearly immediately and kept spiralling downwards immediately after the cooling measures and the 1997 Asian Financial Crisis.
To the government’s credit, they identified this fairly early and started implementing cooling measures within a year of the country’s recovery from the recession. Unfortunately, HDB flats take time to build. Lum (2011) also points out that the government restarted land sales as early as 2007, but the effects can only be seen two to three years later with the uptick in housing units constructed in 2009 and 2010. The pent-up demand meant that prices continued to increase in the interim period while more units were being built, and they only stabilised after a bumper crop of over 27,000 units were built in 2014.
Conclusions
Singapore’s public housing model is often praised for providing high-quality housing at affordable prices and at such a large scale, and rightfully so. In countries like the United Kingdom or the United States, public housing has a bad reputation for shoddy construction and poor maintenance, and in some cases have even cost lives. To many, it is inconceivable that public housing could house a majority of the country and even rival private properties in terms of quality.
One of the main challenges in discussing public housing issues in Singapore is how intertwined HDB flats are to various aspects of our lives - housing, retirement, integration, and mobility are some that come to mind. Housing policy is also affected by a confluence of many factors, such as economic development, population policy, infrastructural needs, and environmental concerns. The squeeze in resale prices in the late 2000s was partly due to a lack of synchronisation across these different areas, with population and economic growth continually marching ahead while infrastructure development slid behind. Understanding the complexity behind the issue of public housing is necessary to having more constructive discussions about how it should look like as Singapore continues to grow and develop.
Finally, if LinkedIn is any indication, data analytics and data science is rapidly growing in prominence in Singapore. As it does, more students will be looking for rich datasets to work with for their projects to demonstrate their capabilities. To my knowledge, HDB’s resale flat prices dataset is one of the few publicly available datasets which are fine-grained enough for more complex analyses, and I have learnt so much over the past few weeks while working on this article. It would be a great idea to release more datasets on other issues that matter to everyone. What better way is there to encourage more civic engagement with tough public policy issues than to allow Singaporeans to analyse Singapore’s data themselves and to contribute constructively to our national discourse?