Excel database

Download FREE sample:
List HDB projects SAMPLE .xlsx (BTO, DBSS, HS, CRC)

Buy full database + FREE updates:

Excel table include all HDB projects built after 1991: 185 projects with centralized refuse chute (completed 1991-1998), 181 projects with household shelter (completed 1997-2004 including SERS), 406 BTO projects (launched 2001-present), 13 DBSS projects (launched 2006-2012) 35 SERS projects (launched 2004-present), 10 projects sold exclusively via Sale of Balance Flats.

Basic info: data freely viewable in this page: town, project name, launch date, estimated completion date, total number of units, links to brochures (since 2009).

Flat details: all of the above plus block numbers, contract type (standard / premium flats), number of units breakdown by flat type, selling prices of flats (BTO & DBSS only), also statistics to calculate number of flats launched by year.

For even more details, see the big HDB Database detailed to block level (1 row per block and 66 columns of data), including all blocks ever built since 1930s, even the demolished ones. See also other databases made by me.

History of BTO flats

The Registration for Flat (queue selling system) was suspended in 2002 due to unsold flats. Walk In Selection introduced in March 2002 allowing people to book unsold flats anytime. It ended in February 2007 and was replaced by balloting exercises named Quarter-Yearly Sale of 2/3-Room flats and Half-Yearly Sale of 4-Room and bigger flats, which in 2010 were combined in Sale of Balance Flats, which sell leftover flats from past BTO and SERS projects, plus old flats repurchased by HDB. Because some flats are completed and you can collect keys immediately after balloting, so many people apply for SBF and in towns with low number of flats 100+ people battle for one flat.

Build-To-Order was introduced in April 2001 to become main supply of HDB flats. Flats are offered for sale before being built. Tender for construction is called only if at least 70% of units have been booked (50% since 2011), otherwise the project is canceled and may be re-launched when will be more demand, with a different name and sometimes different design. The first projects enjoyed low interest, 5 of them being cancelled, but once Walk in Selection ended, BTO projects became oversubscribed, and since 2008 HDB launch 2 BTO projects every month. Since 2015 BTO flats are launched for sale in February, May, August, November. Due to Coronavirus circuit breaker, May 2020 BTO been deferred and on 29 May HDB press release said that will be combined with August BTO.

HDB publish a press release in December each year, announcing supply for next year, based on past year application rates. The supply can be adjusted in mid-year too and it reached a peak of 27,000+ flats in 2012. But since HDB does not forecast demand, there is always a lag between supply and demand, since Walk-in Selection ended in 2007 people who are eligible for new flats but do not accept the 3-4 year waiting time of BTO system, or fail at balloting, go to resale market, consequently resale flat prices doubled from 2007 to 2012 and the prices of new flats grew according to resale prices.

HDB claimed that cleared supply backlog and decided to move to a steady supply, announcing in December 2016 a supply of 17000 BTO flats for year 2017, a dangerous strategy that I was expecting to cause undersupply and another price bubble during 2020s. It also contradict a 2013 report announcing a supply of 700000 new homes by 2030.

Some people thinks that Registration for Flat system was better because everyone was getting a flat based on queue order, not based on luck like at BTO balloting. Registration for Flat had a disadvantage: you did not knew location or time you were getting the keys. BTO show you location and estimated completion date, and the priority schemes give people in urgent need for a home higher chances at balloting so BTO is better was better IF the flat supply matched demand, otherwise BTO is a lottery rather than a reliable housing scheme.

Among people visiting my website and talking with me, some informed me that applied for BTO 5+ times without success, then bought a resale flat, or went directly to resale market (despite of being eligible for BTO) to avoid wasting time in BTO lottery where only 1 of 4.4 first timers and only 1 of 18 second timers win a prize with 4 years delivery time (this is average application rate for BTO launches between Feb 2019 to May 2021).

Since 2018 HDB launched few BTO projects with shorter waiting time (2.5 years) because construction started before sale launch, but in my opinion at least half, if not all BTO must have construction started in advance so the waiting time will be 2 years, to reduce demand for resale flats by turning buyers towards BTO (how many people like waiting 4 years for BTO to be built?). Inevitably some flats will remain unsold, but they can be always re-offered via Sale of Balance Flats during construction or after completion, to people who are in immediate need of a flat.

Possible upcoming / future BTO locations

In 2001-2005 BTO projects were offered only in Punggol, Sembawang and Sengkang (the most recent 3 towns, started after 1997), but over years BTO projects were launched all over island on any available land, including mature towns. Try spotting empty land parcels on Interactive map of HDB blocks (we cannot know how soon a land parcel will be developed as BTO, some parcels end being sold to private developers instead). On same map you can click each block to view launch date, estimated completion date, number of floors, number of units, links to download HDB brochures and typical unit floor plans, etc.

HDB announced on 29 August 2013 the Public Exhibition on New Housing Areas: Bidadari (estate within Toa Payoh town, first BTO early 2015), Tampines North (first BTO late 2014), Punggol Matilda (first BTO Sep 2013). Tengah New Town was announced in 2016 and got first BTO launch in 2018. 3 more areas were announced in 2021: Ulu Pandan, Mount Pleasant, and Keppel Club. Due to high demand for public housing and current towns getting full, new towns like Seletar and Simpang are likely to be announced during 2020s, and the closure of Paya Lebar airbase in 2030s will make space for another HDB town.

BTO flat size

BTO flats follow internal area standards introduced for blocks completed in 2000: Studio and 2-Room comes in 2 sizes (35 / 45 sqm), 3-Room (65 sqm), 4-Room (90 sqm), 5-Room (110 sqm), 3gen (115 sqm), with few exceptions: Pinnacle @ Duxton, SkyVille and SkyTerrace @ Dawson were smaller, Punggol Sapphire, Treelodge and Bayview had bigger 5-room. Total area shown in HDB Resale Transactions include also A/C ledge (2-3 sqm) and balcony (3-4 sqm) where it is present.

Many people asked me if I have a table indicating which BTO have balcony. The Excel prices table does answer: if BTO project have (some) 4-room flats with balcony, it will show 92-95 or 93-96 sqm, if no flat have balcony, it will show 92 or 93 sqm. Same for other flat types.

How to get PDF brochures

In early 2010 I got idea to save BTO brochures from HDB InfoWeb in my computer and later I uploaded them on my website, because we need them and HDB is deleting them once BTO is completed.

HDB provided downloadable PDF brochures at the day of BTO launch until March 2014. Since July 2014, during the application week you can see 3D model, site plan, and floor plans of individual flats, once application perioe ends, info is deleted from HDB InfoWeb, and detailed PDF brochures (including plans for whole block) are published in MyHDB page only for invited applicants when selection starts 2-3 months later (1 month later since 2020).

Once a visitor who applied for BTO gave me the URL to one brochure, I was able to guess URL for others, example: http://www.hdb.gov.sg/fi10/fi10321p.nsf/w/BuyingNewFlatBrochure201407PG?OpenDocument, replace the year-month numbers and 2-letter town code to get brochures for other towns. By this way I found detailed brochures back to September 2012. HDB redesigned their website in 2015 and deleted earlier brochures.

URL pattern from 2015 to 2017: http://esales.hdb.gov.sg/hdbvsf/eap001.nsf/0/16FEBBTO_pdf_selection_2402 (replace 16FEB and 2402 with the number in URL at initial BTO launch).

URL pattern from 2017 to Feb 2023: http://www20.hdb.gov.sg/hdbvsf/eap001.nsf/0/23FEBBTO_pdf_selection/

Not being able to find May 2023 brochures using above pattern, in July 2023 I put a message on top of page hoping that applicants will give us new URL pattern, and after a month (in mid-August) someone gave me URL:
https://assets.hdb.gov.sg/residential/buying-a-flat/finding-a-flat/sales-brochure/23MAYBTO_pdf_selection/bedok_south_blossoms.pdf
(I don’t know whenever does exist an index page with all brochures for each launch, or at future launches we need to guess / type manually name of each BTO to get brochure)

Note about completion date

Many people asked me if a BTO can be completed earlier. YES, the estimated completion acts like a deadline, in most cases residents collect keys up to 3-6 months earlier. Note that Pinnacle @ Duxton residents collected keys and moved in Dec 2009, but work continued at skybridges until May 2010 scheduled completion date.

Wikipedia showed completion date same month 4 years ahead, and I kept adding 4 years of the projects not listed in Wikipedia, but HDB decided in 2010 to speed up BTO production, affecting the already-launched projects, and most 2009-2010 BTO are completed in 3-3.5 years (6-12 months faster) because. In 2011 I added “Estimated completion date” from launch brochures for projects after 2009.

When unsold flats are re-launched in SBF, HDB may show an updated completion date, different than the one estimated at launch, but since not all BTO have unsold flats, and to prevent being blamed for providing WRONG completion date by people looking in original BTO brochures, I choose to show the only original estimated completion date.

Due to COVID-19 pandemic and global trade disruptions, some contractors faced with shortage of manpower, rising material prices and cost overruns, causing several BTO to be delayed with few months, for one BTO (Waterway Sunrise II) the delay exceeded 1 year. Source: channelnewsasia.com.

Delivery possession date / Lease commence date is set to start about 1 year after estimated completion date. Minimum occupation period is 5 years starting from key collection date, which vary from flat to flat. If you want to estimate when first flats from certain BTO will be available in resale market, you should add 4½ years to estimated completion date from above table. To check key collection date for YOUR flat, go to www.hdb.gov.sg/myhdbpage > My Flat > Application Status > New Flat > Reg.No. I am not aware of any way to see key collection date of other BTO flats.

Non-BTO projects

Several people reported “BTO project missing from my list” thinking that each named precint of HDB blocks is a BTO. WRONG!

When BTO scheme was introduced in 2001, HDB started naming all blocks (upgrading programmes also add precint names for older blocks). BTO define a selling scheme and NOT the building. My list is complete for projects sold via BTO scheme, but there are other schemes:

List of DBSS projects, built and sold by private developers, but managed afterwards by HDB like public housing.

List of SERS sites, replacement blocks built for blocks selected for redevelopment, their surplus flats are sold via SBF in same manner with unsold flats from BTO projects. Sri Geylang Serai and Ping Yi Greens were built for SERS affected residents, then remained flats were re-offered for sale via BTO.

Projects offered only via SBF when they were near completion: Buangkok Court, Fernvale Lodge, Golden Peony (Tampines), Jurong East Court, Jurong East Vista, Marsiling Heights, Tampines Lodge, Tampines Ria. Tell me if you know any more!

By this way, “resale BTO flats” is an incorrect term. You can buy new flats (BTO, DBSS, SERS, SBF) and resale flats.

About & updates

Build to Order page on Wikipedia included flat details for each BTO project (including contractor name, not available anywhere else on internet) but too many BTO projects been launched and in 2010 Wikipedia editors decided that such sales catalogue does not belong to Wikipedia. That moment I compiled my own list in Excel (town, project name, launch date, completion date, number of units breakdown by flat type).

I collected BTO brochures since December 2009, while for 2001-2009 BTO projects I sourced data from Wikipedia. I published on my website List of BTO & DBSS projects in HTML format in March 2011 with a link to download table in Excel format.

My visitors reported errors (which I corrected): River Edge 2001 shown on Wikipedia as built, does not exist in real life, Spring Lodge 2003 shown on Wikipedia as cancelled (block 465) was actually built as block 466 (probably launched in 2001), could be River Edge? Does anyone know which BTO has been cancelled in 2003?

In 2014 I created a separate page List of BTO brochures containing just link to PDF files (no other information like completion date or number of units). In 2016 I spent about 10 hours compiling selling price ranges of all BTO flats in one Excel database. I offered List of BTO projects for free and List of BTO prices for $30 (10 cents/BTO).

In 2021 I done a major update for all Singapore-related pages, and in November 2021 I combined 3 pages/Excel databases (list of BTO projects, list of BTO brochures and list of BTO prices) into a single page.

I spend 30 minutes every 3 months to update list of BTO projects (this page + Excel including indicative price ranges).

Suggestions received:

• Similar list for older HDB projects or projects sold via other schemes: I made a page List of pre-BTO projects for Ang Mo Kio in 2013 but too few people visited it so I did not proceed to other towns until 2021.
• Add block numbers: done in November 2021 in paid version of Excel, when I also expanded Excel with 1997-2005 projects, and with 1991-1997 projects in 2022.
• Prices by each individual unit rather than ranges: such detailed table would take ~10 hours per BTO, too much effort for the value of data I can obtain, also HDB units prices are available on HDB InfoWeb only for a short period since booking starts, and once unit is booked, prices are no longer showing.