Database of all buildings in Singapore

The database contains EVERY searchable item from the map, including HDB blocks, condominiums, landed houses, commercial, office and industrial buildings, schools, places of worship, gas stations, parks, MRT stations, and few more. Data included is building name, address, street name, postal code, latitude and longitude, X and Y coordinates of OneMap.sg, etc.

Download SAMPLE:
Singapore-Buildings-Database-SAMPLE.xlsx

Buy FULL database + FREE updates for 1 year:

Buy & download

Contact me for partial purchases (specific postal districts if you don’t need whole Singapore)

Use below map to prove level of completeness

Terms of use according https://www.onemap.sg/legal/opendatalicence.html
You can use, access, download, copy, distribute, transmit, modify and adapt the datasets, or any derived analyses or applications, whether commercially or non-commercially.

However, because took some time to code scraper and several days of running computer 24/7 to get all data, you are not allowed to distribute or resell my database. You are allowed to use it in your company. If a friend or another company wants to use same data, tell them to buy from me.

History

The database is raw data scraping from OneMap.sg and the map’s raw data does NOT indicated building type. Several people asked me for building type so I am planning to add building type column myself checking manually the map to identify building types. This job will take few dozens hours and once completed I will sell database at double price. But before investing any more effort in this database I need to secure future updates.

One of my customers who bought HDB Database and Condo Database in August 2017, made a scraping software to get buildings information from OneMap.sg and gave me the CSV data dump (141099 buildings) as “work exchange”, with permission to resell on my website. He did not gave me the scraper, but only data, gave me an update in January 2018 (120508 buildings), I suspected that he missed lots of postal codes, I emailed him to run scraper again, I emailed a week later and he replied that did not had time to run again, and after this he never replied me anymore.

I am looking for someone else who can scrap data from OneMap.sg and give me the scraper so I can update database myself in the future.

Update November 2018: an Indian helped me updating Python scraper to work with current version of OneMap, but the script don’t work at my computer for unknown reasons (in his computer it works fine, proved via TeamViewer).

Update July 2019: I found another Indian to fix and run the script, got 141754 buildings. The difference of about 20,000 buildings is because a of couple of entries share same postal code.

Database of HDB resale flat prices in Excel format

I got a database of HDB resale transactions from 1990 to present and spent over 10 hours studying them and doing data analysis in Excel.

HDB Resale Flat Prices Database
HDB resale flat prices by flat type HDB resale flat prices per sqm by flat type
HDB resale flat prices per square meter by lease year HDB resale flat prices per square meter by storey


I offer one Excel file containing the following analysis:
– Number of HDB resale transactions by year and month (1 table and 1 chart)
– Number of HDB resale transactions by year and town (1 table and 1 chart)
– HDB average resale flat prices by lease year (1 table and 1 chart)
– HDB average resale flat prices by storey (1 table and 1 chart, per sqm)
– HDB average resale flat prices by flat type (table and 2 charts, sale price and price per sqm)

Buy & download

And another Excel file containing all the above analysis, plus:
– HDB average resale flat prices by town (5 tables and 5 charts, all flat types, 3-room, 4-room, 5-room, Executive)
– HDB average resale flat prices by town and flat type (27 tables and 54 charts, sale price and price per sqm)

Buy & download

And another Excel file containing all the above analysis plus the database of resale transactions, so you can do your own analysis:

Buy & download

Free SAMPLE – Bukit Timah resale transactions + analysis

Contact me for custom packages (specific towns only) or additional analysis.

Private property resale transactions

Several people asked me if I can provide similar Excel databases for private transactions.

Private property transactions are tracked by URA and REALIS and can be consulted on URA website (consulted only, not copied – I haven’t found any working method to scrap them). REALIS provide access to Excel database only to universities, I has been showing this by students telling me that are NOT ALLOWED to share data with third parties.

Old page 2012-2016

Is anyone interested in a table containing resale transactions listings from HDB website, but compiled in Excel thus easy to analyze, and including 140.000+ flats transacted last 6+ years?

FREE sample:
HDB-Resale-Flat-Prices-SAMPLE.xls containing transactions listings for ONE town + Most expensive flats + Statistics

Buy the complete database with 26 towns:

Buy & download

Each package contains 3 files:
Original: 26 sheets, 1 flat = 2 rows (as copied from HDB website).
Enhanced: 26 sheets, 1 flat = 1 row, added colors, filter and sort macros.
Enhanced & towns merged: one sheet containing all 26 towns.

Why I made this HDB database and selling it?

On 1 April 2009, HDB improved its Resale Flat Prices e-service, now showing transactions for last 1 year instead of last 3 months, also added flat model beside floor area.

I copied the listings for 1 year (April 2008 – March 2009) in Microsoft Excel, which were displaying 20 per page. I spent about 10 days at 5 hours per day. I did this for purpose of personal analysis, for example estimate average apartment size nationwide and per town, and showing the results of analysis in HDB Statistics page.

Few months later HDB showed all transactions in a scroll-able list rather than 20 pages, allowing me to copy transactions much faster, so started to update my database once per year. I had no intention to publish or commercialize it.

I have published database on website in August 2012 because, while monitoring website traffic, I noticed 2 people searching on Google exactly the text shown on HDB Statistics page “I copied HDB Resale Transactions for one year in Microsoft Excel to make calculations”, probably they were trying to find the original Excel file, or possible other source of Statistics page (thinking that the Statistics were not mine but copied from elsewhere). The only way to get the Excel file source of statistics was to contact me.

So, some people may be interested in such database, I posted the Excel database for sale.

I am aware that the XLS table can be used by agents for a detailed analysis of HDB flat prices drop and rise, which is not possible in web version, or it can be even converted to CSV or SQL and used in websites by people who intend to make profit.

Due to the size of database, Microsoft Excel runs slowly, I am spending about 20 hours each time I update the XLS file, regardless if I update every month or once per year. Time is money! So I am selling it at a price that may be out of reach for private people. If you want just to view HDB flat prices (but only for last 1 year), you can do this for FREE on HDB website.

I offer updates at price of $50 per update. You decide if you want to pay $50 once per month, once per few months or once per year. As 2015, the database was purchased by 3 people and all them needing data one-time only and not interested in updates.

Note: HDB changed its e-service on 10 March 2014, now showing Resale Registration Date instead of Resale Approval Date, causing flats to jump from one month to another, some prices are different, also the storey is shown in ranges of 3 floors instead of 5. This cause some incompatibilities with previous database. So I decided to sell the database April 2008 – December 2013 (149930 records) and start a new database 2013-present, overlapping 1 year (23476 records as July 2014). Feel free to combine them if you want to have a messy database.

List of DBSS projects

City View DBSSDesign, Build and Sell Scheme was introduced in 2005, giving private developers freedom to build and sell public housing in the way they sell condos. Since private developers are hungry for profit, DBSS flats have smaller rooms and abnormal high prices compared with BTO flats despite of same income ceiling ($8.000 per month, $10.000 per month after 2011).

Do not confuse DBSS with Design & Build scheme introduced 1991 which involve private architects but flats are sold by HDB at regulated prices.

DBSS land sales were suspended in 2011.

Town name Project name Launch
date
Completion
date
Number of flats
2-rm 3-rm 4-rm 5-rm Total
2006-2009 6 DBSS projects – 3951 flats
Estimated average flat size: 103.16 sqm
Tampines The Premiere Oct 2006 Jan 2009 4 36 576 616
Kallang City View Jan 2008 Apr 2011 72 168 474 714
Ang Mo Kio Park Central Oct 2008 Oct 2011 172 406 578
Bishan Natura Loft Nov 2008 Feb 2012 160 320 480
Simei Parc Lumiere Apr 2009 Jul 2011 120 240 360
Toa Payoh The Peak Apr 2009 Jul 2012 95 306 802 1203
2011-2012 7 DBSS projects – 4698 flats
Estimated average flat size: 89.77 sqm
Yishun Adora Green Feb 2011 Q4 2013 168 510 128 806
Tampines Centrale 8 Jun 2011 ? 182 348 178 708
Bedok Belvia Oct 2011 2014 102 209 177 488
Hougang Parkland Residences Jan 2012 ? 136 272 272 680
Jurong West Lake Vista Oct 2011 2015 145 279 258 682
Clementi Trivelis Oct 2011 2015 222 518 148 888
Pasir Ris Pasir Ris One Apr 2012 ? 103 237 107 447
Total 13 launches 4 1225 3335 4086 8650

Source for launch / completion date: Wikipedia… it do not provide some info for certain DBSS.

Note: I estimated average flat size using standard BTO sizes of 45, 65, 90, 110 square meters. In reality, DBSS developers have freedom to decide the size of flats, and all 2009-2012 DBSS are under BTO standard size. For example ThePeak have 5-room up to 120 sqm while Parkland Residences have 2 types of 5-room, 105 and 108 sqm. I do not have brochures for all DBSS projects to check exact size. Note that these sizes include the oversized balconies and A/C ledge, so internal rooms are significantly smaller than BTO flats.

Note for Natura Loft: Wikipedia says 160 4-rm and 400 5-rm, this is wrong, there are 160 and 320 units, thanks to a report from a website visitor.

Note for The Peak: Wikipedia says 42 3-rm, 306 4-rm, 830 5-rm, total 1178 units, this is WRONG, may be the initial proposal. The actual project have a total of 1203 units.

Note for Lake Vista: most sources specify a total of 682 units, but detailed info says 145 of 3-rm, 266 of 4-rm, 426 of 5-rm, totaling 837 units. Corrected: 145 + 279 + 258 = 682 units.

BIG note: Pinnacle @ Duxton is a Premium BTO but is commonly mistaken as DBSS. Probably because of its high-end design for public housing, but it was launched in 2004, while DBSS scheme appeared in 2006.

DBSS suspended

DBSS land sales were suspended on 4 July 2011 after the Sim Lian Group, developer of Centrale 8, set outrageous prices up to $880.000 for 5-rm in the project launched on 16 June, also the project was badly designed, blocks packed like sardines and flats smaller than HDB standard of 90/110 sqm, HDB asked developer to review of prices, which were reduced to $778,000. Sadly, the remaining 5 DBSS sites sold, were launched up to 2012, at similar 700k prices for 5-rm. In total 13 DBSS projects were built, containing 8650 flats.

A 14th DBSS site in Sengkang has been launched on 7 June but withdrawn next day at MND request due to Centrale 8 scandal, a 15th site was planned at Bendemeer Road (source: AsiaOne).

Another scandal broke in March 2012 when Clementi Ridges BTO has launched near Trivelis DBSS, being 20-25% cheaper and having bigger flats. DBSS buyers got angry because were not aware that a cheaper BTO will be launch in a mature town, they wasted money by applying for that Trivelis. read more.

New scandals appeared since 2012 when DBSS projects got completed and people complained about too low quality for the prices they paid for.

DBSS usually feature glass rail balconies and bay windows which give them a condo-look, but without condo facilities (swimming pool, guard house), they are still public housing, having no real advantage over Premium BTO flats. I agree with scheme suspension. We do not need DBSS flats, BTO flats and Executive Condominiums are enough.

I do not understand why people keep buying this kind of public housing which is priced almost like EC? I am curious what will be the resale price difference between DBSS and nearby BTOs. Do you think that a Trivelis 5-room DBSS (105 sqm, 88 sqm internal + 12 sqm balcony + 5 sqm A/C ledge) can be sold at higher price than a 5-room BTO (Clementi Ridges, 110 sqm internal, no balcony)? I guess that NOT!

First resale DBSS flats from The Premiere @ Tampines came on resale market in March 2014, being sold at prices only 10% higher than normal HDB flats. So I assume that, if the price index will be constant, owners of Centrale 8 and subsequent DBSS will earn less at reselling than the initial purchase price, as they were about 30-50% higher priced than nearby resale prices.

Several DBSS review by me

The Peak offers biggest DBSS apartments, 5-room is 120 sqm, while Trivelis 5-room is only 105 sq m of which 17 sq m is balcony and A/C ledge. They specify balcony size: 12 sq m, so by comparison living room should be around 3 x 5 meters and common bedrooms around 3 x 2.5 meters (see floor plan, it’s shocking!). When the project was completed in 2013 it generated scandals about quality, read more on statestimesreview.com.

Belvia offers one type of 5-room with 3 toilets.

Adora Green was advertised having “unique 5-Room layout with 4 bedrooms”, but the 4th bedroom is 2 x 2 meters.

Parkland Residences is a slightly better DBSS, being the single DBSS offering some 4-bedroom units rather than 3 bedroom plus a tiny 2×2 m study, but overall all bedrooms are small. You can see that Type C1 apartment have 20 sqm wasted in balconies.

Lake Vista is a good DBSS in terms of room proportions, bigger bedrooms and small livingroom for 4-Room but they offer 5-Room for the people who love big living room!

Pasir Ris One, last one DBSS has been launched on 27 April 2012. Since launch I realized that it is the worst DBSS. Too expensive for its location at end of MRT line, and designed worse than Trivelis, not only tiny rooms but also in the 5-Room flat, the two common bedrooms are facing to internal courtyard, viewing into neighbor unit, while master bathroom have better view. When the project was completed in 2015, it generated a lot of complaints about small rooms and poor workmanship. Read more in allsingaporestuff.com and themiddleground.sg. The single good news about Pasir Ris One is that it is the LAST DBSS, thanks government we got rid of this shit!

BTO vs DBSS floor plan & flat size comparison

No DBSS develoer published floor plan with dimensions at initial launch brochure (DBSS floor plans with measurements can be found in HDB Sale of Balance Flats only if HDB repurchase flats), but you can estimate room dimensions based by door size, each bedroom in BTO is about double in terms of square footage compared with DBSS.

Pasir Ris One DBSS (105 sqm including balconies and A/C ledge)
Yishun Greenwalk BTO (110 sqm without balconies and A/C ledge).

Pasir Ris One DBSS 5-Room Yishun Greenwalk BTO 5-Room

If you need DBSS floor plans, just do a search by DBSS name on Google Images Search. Do not ask me to give you or post more floor plans on my website.Being built by private developers, each DBSS have dozens floor plans variations, and agents selling them add their contact info on images, making hundreds of possible floor plan images with no standard format like in case of floor plans provided by HDB website, so I am not going to overload my website with more images.

List of HUDC estates

Looking to buy a former HUDC flat and hope for en-bloc? Contact my partner agent
William Chui

Braddell View HUDCHousing and Urban Development Company built 22 estates for middle-income people, of which 3 are not managed as public housing and one (Anthony Garden) was demolished in 1990s, leaving 18 HUDC estates that appear on official lists.

HDB took over JTC and HUDC in 1982. Phase III and IV are HUDC flats built by HDB, last HUDC was completed in 1987. HUDC was replaced by Executive HBD flats built since 1984. See also HUDC and the story of housing windfalls.

Estate name Location (town) Number of units Built year Privatization Current status
Phase I
Farrer Court Bukit Timah 618 ? 15 Nov 2002 Demolished 2009
for D’Leedon
Lakeview Estate Bishan 240 1977 1 Aug 2003 Standing
Laguna Park Marine Parade 516 flats + 11 shops 1977 16 Jul 2007 Standing
Phase II
Amberville Marine Parade 168 1978
or 1980
16 Dec 2002 Demolished 2008
for Silversea
Anthony Garden
(source: Straits Times 1989)
Central Area 196 ? never Demolished 1995-1996
for Orchard Scotts
Braddell View Toa Payoh 918 1981 17 Mar 2017 Standing
Chancery Court Novena 136 or 144
136 flats, 5 shops
1981 24 May 2014 Standing
Phase III
Gillman Heights Bukit Merah 608 1984 1 Nov 1996 Demolished 2010
for The Interlace
Ivory Heights Jurong East 654 (Annual Report) 1986 1 Jun 1998 Standing
Minton Rise Hougang 342 (Annual Report) ? 1 Feb 2001 Demolished 2010
for The Minton
Pine Grove Bukit Timah 660 1984 1 Nov 1996 Standing
Waterfront View Bedok 583 (Annual Report) ? 1 Feb 2002 Demolished
unknown year
Phase IV
Eunosville Geylang 330 (Annual Report),
318 (counted)
? 1 Jun 2011 Standing
Hougang N3 Hougang 286 (Annual Report
+ counted)
140 (demolished 1995)
1986 8 May 2014 Demolished 2018?
for Riverfront Residences
Hougang N7
renamed Florence Regency
Hougang 336 (Annual Report
+ counted)
286 (privatization news)
? 13 June 2014 Standing
Potong Pasir Toa Payoh 175 (Annual Report
+ counted)
? 1 Jul 2014 Demolished 2018
for The Tre Ver
Serangoon North Serangoon 244 (Annual Report
+ counted)
? 8 May 2014 Standing
Shunfu Ville Bishan 358 (Asiaone.com),
360 (counted)
1985 28 Mar 2013 Demolished 2018
for Jadescape
Tampines Court Tampines 560 (Annual Report) 1985 1 Apr 2002 To be demolished
for Treasure at Tampines
The 3 additional HUDC estates not included in official lists
Lagoon View
(Ministry of Finance)
Marine Parade 480 1977 Announced Standing
Neptune Court
(Ministry of Finance)
Marine Parade 752 1975 Announced Standing
Normanton Park
(Singapore Armed Forces)
Queenstown 488 1977 unknown Standing
Privately-built housing purchased by HUDC
Pasir Ris landed houses
(source: Straits Times 1977)
Pasir Ris 98 (Annual Report) not yet Standing
Pearl Bank
38 of the 280 units takeover
(source: New Nation 1978)
Central 38 (Annual Report) not yet Standing


Total: 22 HUDC estates, 9776-9798 units.

I made the above list myself in 2011, because I was not able to find any official list of Housing and Urban Development Company estates. That times, a single source said that HUDC built 19 estates totaling 7750 units without listing individual estates, but personally I identified 21 estates. In 2012 I found ST Property saying 18 HUDC estates totaling 7731 units, but there are 3 more estates which a real estate agent replied in PropertyGuru that they are HUDC estates too undergoing privatization, they being managed by other government boards, thus HDB Annual Reports never counted them as public housing.

Beside the 22 estates built by HUDC (or by HDB after takeover as HUDC flats), under HDB management there are also 38 HUDC units in Central Area (within 280-unit Pearl Bank Apartment) and 98 HUDC units in Pasir Ris Avenue / Terrace / Heights (terraced and semi-detached housing), built by private developers and takeover by HUDC to be sold as public housing. I was able to prove their location using HDB Map Service.

Starting from Annual Report 2015, HDB no longer include HUDC units under HDB management. All HUDC estates were privatized, except the 38 units in Pearl Bank and 98 units in Pasir Ris which their status is unknown but were removed from Annual Reports causing the total number of units in Central Area to drop by 38.

Source of info: the HDB Annual Reports, old press releases on archive.org, and various blogs with news about HUDC privatization, this is why there are so many empty cells, question marks and some values may be not accurate.

Note: Amberville is written in HDB Press Releases as Phase I/II, Braddell View is not written, while Chancery Court is written as Phase II.

HDB launched HUDC privatization scheme in 1995. The privatization process is complex and takes about 1 year to complete. The estate is converted in strata-tiled and apartment owners became legal owners of the land under them.

After privatization, owners may decide to sell their estate in a collective sale (en-bloc) to a private developer. Most HUDC estates are built with large spaces between blocks, so if it is demolished, a private developer can maximize the plot area and built 2-4 times more apartments than the original estate.

The reason for which HUDC flats are transacted on resale market at prices over $1 million, much higher that HDB Executive flats, is exactly the en-bloc potential, if a developer buy the estate for redevelopment, may compensate each flat owner with $2 million.

Initially I guessed privatisation date using Annual Reports (dwelling units under management) and see in which years the number changed, oldest HDB Annual report found was from 1994, found via archive.org, showing 5411 HUDC units under management, none of them in towns plenty of HUDC estates such as Marine Parade, giving impression that they were already privatized before 1995. This because Phase I/II estates were under self-management thus not included in units under HDB management.

I added official privatization date in 2014, sourced from hudcsingapore.com, by this way I also organized the table by phases.

Few HUDC blocks were demolished before HDB launched privatization scheme: Anthony Garden (196 units) and blocks 342-343 from Hougang N7 (140 units).

List of HUDC in Excel format

Similar with above table

HUDC flats

Biggest HUDC apartments are in Chancery Court, with maisonettes in 180-210 sqm range.

I have never saw HUDC floor plans, but based on the interior photos available on real estate websites, I can tell that Phase III and IV HUDC floor plans have similar layouts like HDB Executive Apartments / Maisonettes built in 1980s, but are a little bigger (usually 150-165 sqm).

HDB interesting facts and records

Did you know? HDB blocks vary in size from 4 to 570 flats
(block 308 Choa Chu Kang Ave 4 vs block 37 Circuit Road)
Smallest HDB block: 308 Choa Chu Kang Ave 4 Biggest HDB block: 37 Circuit Road

What other HDB facts would you like to see on this page? Leave a comment!

Biggest HDB town (by number of units)

Current town boundaries were introduced in Annual Report 1990. Bedok was the biggest town, overtaken by Tampines in 1996 then by Jurong West in 2000. We expected Sengkang to take the lead, but due to announcement of Tampines North area, based on the number of flats under construction in Annual Report 2018 we can say that Tampines will re-take the lead in 2021.

Biggest HDB block ever built

Blk 30 Jalan Membina (built 1960s, demolished mid-1990s), 605 units of 2-Room (source: Straits Times).

Biggest HDB block (standing)

Blk 52 Cassia Crescent (built 2016), 588 units of 1/2/3-Room flats, 17 storey.
Blk 37 Circuit Road (built 1965), 570 units of 2/3-Room Standard flats, 16-storey, 3 wings, 38 units per floor.
Blk 195 Kim Keat Avenue (built 1973), 550 units of 3-room Improved flats, 12-storey, 50 units per floor.
Blk 3 Jalan Bukit Merah (built 1974) and blk 79 Indus Road (built 1971), 520 units of 1-Room Improved flats, 14-storey, 40 units per floor. (source: personal research)
For comparison, the 40-storey blocks 88, 89, 90 at Tanglin Halt house only 331-379 units, Pinnacle @ Duxton house only 264 units per block.

Smallest HDB block

Blk 539, 542, 545 in Pasir Ris (4 units Executive Maisonette); blk 308 in Choa Chu Kang (2 units 4-Room and 2 units 5-Room); many 2-storey shophouses have 3 residential units at second floor if at first floor there is an eating house or other facility, other shophouses have 0 residential units because all are classified as commercial properties (shop at ground floor and living quarters at second floor).

Longest HDB block

Blk 195 Kim Keat Avenue, 4 segments, 370 meters long on corridor side, 12 floors, 50 3I units per floor, 550 units in total.
Blk 34 Whampoa West, 1 curved segment, 320 meters long on corridor side, 12 floors, 46 3I units per floor, 487 units in total.

Longest relatively-straight HDB block

Blk 79 in Toa Payoh, 1 slightly curved segment, 300 meters long, 10 floors, 44 3I units per floor, demolished in 2003.

Most segmented HDB

Blk 612 in Ang Mo Kio, 220 meters long, 12 staircases with two 4NG flats per floor, during LUP 10 new lifts had to be built to serve all units with lifts stopping at every floor (source: personal research).

Biggest HDB flats

Biggest regular Executive flats are around 150-160 sqm, special flats on non-90° corners may be bigger. Only 0.5% of total HDB flats built are over 160 sqm.
Biggest HDB flats ever built are the ones popularly called penthouses, Maisonette units at topmost floor of some 1990s precincts in Bishan (52 units), Choa Chu Kang (12 units), Queenstown-Strathmore (4 units), also Hougang and Pasir Ris (source), they are up to 215 sqm, plus a roof terrace. Note: The Jumbo Apartments, found in Woodlands, Yishun and Jurong East, can reach 192 sqm too.

Longest HDB flats

The 5-room corner units in 1991-1992 blocks, 18 meters long, kids sleeping in common bedrooms have a long way to go toilet! floor plan (source: personal research).

Best HDB town

(my favorite in terms of planning): Woodlands because is built along MRT line over 3 stations instead of mostly in one side of MRT line like Jurong or around one MRT station like Woodlands, thus about 90% of population live within 1 km range from MRT. Also its road network is less-prone to traffic jams compared with other towns of similar size.

Curiosities about HDB block numerology

– Toa Payoh built since 1965, is the only HDB New Town where block number is continuous over 100 blocks, starting from 1 and ending at 235 in 1976 (blk 236-260 added in 1986-1989). This numerology starting from 1 is used also for smaller estates too, up to Teck Whye in 1980s.
– All New Towns built since 1970s use 3-digit numbering system, starting from 101 for neighborhood 1, 201 for neighborhood 2, etc. Numbers are not always continuous, some being reserved for possible future use, For example Jurong West neighborhoods 7xx, 8xx, 9xx were built since 1986 despite that 6xx wasn’t started until 1996.
– Digit-letter numbers were used first time in late 1980s in Tampines 8xx neighborhood which had more than 99 blocks.
– Digit-letter numbers were used often in 1990s for in-fill developments such as carparks.
– New Towns and extensions of existing towns built since ~2000 HDB use digit-only numbers for carparks and pavilions and digit-letter numbers for residential buildings.

Curiosities about HDB unit numbering

The current unit numbering system (example #12-101) meaning floor + unit number was introduced in 1983. Before this, the ground floor flats had just number 101 while the second floor unit was 101A, third floor 101B, and so on until 25th floor 101Z (letters I an O were omitted). This may be a possible explanation why HDB choose to limit block height to 25 floors from 1970 to mid-1990s.

HDB unit numbering

Curious HDB facts that most people do not know about them

– Jurong West is the ONLY town built over all 5 decades of HDB: Taman Jurong in 1960s, Boon Lay Gardens in 1970s, main Jurong Town in 1980s (block 3xx, 4xx, 5xx), Nanyang (blocks 7xx, 8xx, 9xx) in 1988-1998, Pioneer (blocks 6xx) in 1998-2003, plus few BTOs under construction today.
– The block 23A Queen’s Close is the only HDB block segmented with two 3-room units per floor (such segmented block design is common for 4-room and 5-room blocks). Segmented blocks with 2 units of 2/3-room per floor were more common during SIT era (Redhill, Tiong Bahru, etc).
– The block 259 in Ang Mo Kio is an unique cloverleaf-shaped block.
– The 5-Room flats built by JTC are the only type of public housing with 2 entrance doors, similar with condos (one in living-room, one in kitchen).
– HDB has sold flats with 3 full bathrooms: Multi-Generation flats built in 1987, “Jumbo” Executive flats converted in 1992-1996 from 3A and 4A flats, and 3gen flats launched in 2013 via BTO scheme (Executive Maisonettes built after 1988 also offer 2 bathrooms and 1 WC).
– While most HDB flats do not have balcony at all, HDB has sold a couple of flats with 3 balconies during 1990s (one at living room, one at master bedroom, plus service balcony at kitchen).
– Belvia DBSS offer 3 bathrooms in 5-room flats (109 sqm).

Blocks with multiple street address

– The U-shaped block 78 in pre-war Tiong Bahru is the ONLY building in Singapore with 3 street addresses (78 Moh Guan Terrace, 78 Yong Siak Street, 78 Guan Chuan Street), source: Tiong Bahru blog.
– Two L-shaped blocks have 2 street addresses: 17 Seng Poh Road / Tiong Bahru Road and 28 Jalan Bukit Merah / Hoy Fatt Road
– One multi-storey carpark expanded with a new segment became the only carpark with 2 street addresses. Searching 337 Kang Ching Road and 337 Tah Ching Road on OneMap returns both results.

Private HDB blocks

Spottiswoode Park was originally a private apartment built in 1973-1977 by Port Authority for PSA staff, using HDB designs of 4-Room Improved and 5-Room Standard point blocks, and one of the first residential developments that included a multi-storey car park. Many flats remained empty so were transferred to HDB which leased them to people waiting for public housing in 1979 (Source: Straits Times 1978 and Straits Times 1980).

While all 9 blocks are under HDB management, 5 blocks contains public housing and other 4 private apartments that are not subject to HDB regulations, foreigners can buy, so are transacted at prices 30% higher than public flats despite of sharing same architecture and facilities. Top floor contains 18 penthouse units, classified as private apartments even if flats just below them are public, sold at record prices: 230 sqm, $1.8 million.

There are few more blocks with HDB design that are not public housing, for example 2 point blocks with 5-Room Improved flats built for Polytechnic staff, and 11 blocks model 1996-1998 with 4-Room Model A / 5-Room Improved flats, built for Mount Vernon Camp.

Mysterious abandoned HDB block

Block 852 Woodlands Street 53, was built in 1980s as 3/4-Room Simplified block, and for unknown reason became abandoned in early 2000s. Read more http://forums.keeptouch.net/showthread.php?t=7654 (discussion from 2003). In late 2000s when demand for rental flats was rising, it was converted to 1/2-room fiats and got populated again. The biggest question is when and why it was abandoned and where the previous owners went away, or was rental block?

There are various stories, structural problems (and people though that will be demolished), or used as SARS quarantine homes, as well as haunted stories regarding 2009 murder case in a 2-room flat (but it was abandoned 6 years earlier at least!).

Cheapest HDB towns

Woodlands, Yishun, Bukit Panjang, Pasir Ris, Punggol, are changing their places from year to year.
Woodlands is the cheapest town in terms of price per sqm, it have bigger flats than average.
Yishun is the cheapest town for average of 4-room because they are mostly 4S type (84 sqm) while Woodlands is dominated by 4A flats (104, 100, 90 sqm). Yishun may lose this title, being selected for Remaking our Heartland in 2007.
Bukit Panjang and Woodlands may rise due to upcoming Downtown and Thomson MRT lines. Choa Chu Kang and Pasir Ris may take the lead for having the cheapest HDB flats.
Punggol was the cheapest town during 2000s.
Woodlands is also the town where the HDB flats change owners most often (the town represent 6.6% of total number of HDB flats but 9% of total number of flats transacted. Source: personal analysis of HDB Resale Transactions Database (see Statistics sheet inside Excel file). How does this explain?

Most expensive HDB town

Marine Parade (average price of Queenstown’s 4-rm units is slightly higher than Marine Parade, but original Queenstown built in 1950s-1960s had very few 4-rm, thus most of the 4-rm transacted are built after 1990s, being 90-105 sqm, while the Marine Parade is entirely built in 1970s and the 4-rm are only 87 sqm), so higher psf. Marine Parade 5-rm units with sea view can rival prices of Executive units in Queenstown.
Toa Payoh and Bishan are also expensive, we all know why. Mysteriously, Bukit Timah have high prices, despite of lack of MRT. Any explanation?

Most expensive HDB flats transacted on resale market

Jul 2010 – $890,000 – 192 sqm Executive Maisonette in blk 81 Strathmore Ave (Queenstown)
Aug 2011 – $898,000 – 120 sqm 5-Room Flat in blk 2 Marine Terrace (sea view!)
Mar 2012 – $900,000 – 157 sqm Executive Apartment in blk 148 Mei Ling St (Queenstown)
May 2012 – $910,000 – 142 sqm Executive Apartment in blk 99A Lor 2 Toa Payoh
Sep 2012 – $980,000 – 163 sqm Executive Maisonette in blk 190 Bishan St 13
Sep 2012 – $1,000,000 – 150 sqm Executive Apartment in blk 149 Mei Ling St (Queenstown)
Jan 2013 – $1,010,000 – 163 sqm Executive Maisonette in blk 194 Bishan St 13
Jul 2013 – $1,000,000 – 146 sqm Executive Maisonette in blk 3 Toh Yi Drive (Bukit Timah)
Dec 2013 – $1,050,000 – 150 sqm Executive Maisonette in blk 190 Bishan Street 13
Oct 2014 – $1,088,000 – 150 sqm Executive Maisonette in blk 194 Bishan Street 13
Jan 2015 – $1,028,000 – 107 sqm 5-Room Flat in blk 1A Pinnacle @ Duxton

[email protected] is likely to set the next record of most expensive apartments, at least in terms of price per sq meter, which will be not be beaten for years, especially as the prices started to fall in 2013. The residents fulfill their Minimum Occupation Period at end of 2014 so they will be able to sell their flats.

HUDC units, even non-privatised ones, have even bigger prices.

What is Lease Commence Date

Properties in Singapore are by two types: freehold and leasehold. Leasehold in case of private residential buildings is 999 years, 99 years (or 103 years with 4 years construction time), or in rare cases, 60 years. Other types of buildings can have shorter leases. All HDB flats except Studio Apartments are leased on 99 years.

There is also Temporary Occupation Permit (TOP) or a Certificate of Statutory Completion (CSC), Private properties lease commence date is when land was sold, while when they are listed for sale, TOP year is indicated. When HDB launch a BTO project it indicate CSC date. Read more: https://www.propertyguru.com.sg/singapore-property-resources/property-tips/what-is-a-temporary-occupation-permit-top-9316

For HDB blocks, the 99-year lease starts usually after up to 1 year from when construction is finished, I do not know if lease commence date is identical with CSC date, and this rule does not apply for pre-1973 blocks, in which lease commence date is the date at which HDB decided to sell / allowed tenants to buy their flats.

Construction time lasted 2-3 years in 1990s and 3-4 years in 2000s and today. Household shelter appeared in HDB Annual Report 1996 and first blocks have leases from 1998.

Home Ownership Scheme was introduced in 1964, but oldest HDB leases are from 1967. HOS was piloted in Tiong Bahru pre-war blocks in 1965-1967 and people could use CPF to purchase their flats, they are also the only SIT/HDB flats transacted as private properties (source: tiongbahruestate.blogspot.com). So, in 1967 they realized how to implement HOS without privatization?

Lease commence date reflects building date, with some exceptions. Actually building date do not have so much importance like lease commence date. Most blocks built during 1960s were leased to owners in stages from 1967 to 1973. Tiong Bahru blocks built in 1948-1954 blocks have leases from 1973. Redhill blocks built in 1955 have leases from 1983. Some 1970s 2-Room blocks were reserved for rental until 1986 when HDB starting leasing them to owners. Other 2/3-Room blocks remained rental blocks forever, for example Dakota Crescent blocks, scheduled for demolition in 2017. The 1970s and 1980s blocks converted during 1990s into Jumbo flats have leases from the year of conversion.

What happen when 99-year lease expire

Nobody knows. Lorong 3 Geylang houses are the first leases to end in 2020 (private, 60-year lease). Let’s wait and we will see what happens! There are no other private residential leases on 60 years. Fuyong Estate is the next one to have its 99-year lease expiring, in 2047.

Once time ago I saw a funny guy saying in a forum that Freehold property remains yours forever while a Leasehold means that you will be kicked out at end of lease, and another guy correcting him: Government can take over both leasehold and freehold properties, but only freehold owners are rewarded at full value. Also owners can apply for lease extension.

Oldest HDB leases are from 1 Jan 1967 so they will expire at end of 2065, I suggest you to not care too much about reaching end of lease. Some paranoid people thinks that if you purchase a flat with less than 60 years old of lease, you cannot resell it. The only reason for which old flats are hard to sell, is the increasing number of such paranoid people. Is rumored that when remaining lease is 50%, property value is 70% of its value as new. Value is expected to drop significantly only when lease goes less than 30 years.

During 1990s, the old estates built in 1960s and 1970s suffered from dilapidated buildings, aging population and businesses moving out. On resale market Queenstown and Ang Mo Kio were cheaper than Pasir Ris, one of the cheapest towns today (source: Resale flat prices database). To counter this, HDB launched Main Upgrading Programme in 1990, Interim Upgrading Programme in 1993 and Selective En-bloc Redevelopment Scheme in 1995.

Between 1995 and 2007, 71 SERS sites were announced. This created widespread rumors among population that any 1960s and 1970s block can get SERS, increasing demand for old flats, people buying 1960s and 1970s flats on purpose to have their block demolished and receive a new flat at subsidized price. Currently, blocks leased in 1966-1980 are priced higher per sqm than blocks leased in 1981-2000. Due to this reason, is no longer viable for HDB to redevelop old blocks, number of new SERS sites announced dropped dramatically.

Between 2008 and 2018, only 10 SERS sites were announced, total 7883 flats. At this rate, 306 years are required to replace all 241343 flats built between 1971 and 1980.

I believed that HDB is waiting for the old flats to get closer to their end of lease when their market value will drop significantly, then increase number of SERS sites.

On 19 August 2018 HDB announced that only 5% of total sold flats are eligible for SERS, of which 4% have been selected already. For all other flats there will be VERS (Voluntary En-bloc Redevelopment Scheme) that will start in approximately 20 years from now (near 2036 when first leases reach 70 years old). Polls will be made in each precint and they require 75% of owners to vote to go VERS or keep living in their flats until leases run out.

Due to rapid and short development of towns like Ang Mo Kio (1976-1982), Bedok (1974-1986), Marine Parade (1975-1978), HDB cannot VERS all blocks once they are 70 years old, so they will be redeveloped stages when they are between 70 and 90 years old. Details such as selection criteria, compensation offered, etc, and how VERS will be financed, are not yet decided, leading to speculation. Think that in 20 years many things can change!

99-year leasehold properties usually have 60% value of freehold ones when remained lease is 30 years, and 40% when remained lease is 15 years, according https://www.clc.gov.sg/docs/default-source/commentaries/balas-table.pdf

Use CPF for property purchase with less than 60 years of lease

  • No CPF can be used if the remaining lease of a property is less than 30 years.
  • A property owner is eligible to use his CPF for the property if his age plus the remaining lease of the property is at least 80 years
  • The maximum amount of OA savings you can use is capped at a percentage of the property purchase price or the value of property, whichever is lower.

The above applies to all Housing & Development Board flats bought on or after 1 July 2013. The maximum amount of CPF savings that can be used for such property is set at a level that covers the estimated depreciated value of the property when the youngest eligible owner using his/her CPF savings for the property reaches 55 years old. This is to ensure prudent use of a member’s CPF savings when buying properties with shorter remaining lease.

You may refer to our brochure (PDF, 1.3MB) for more information or use our Property with Less Than 60 Years Lease Calculator to decide your eligibility and the maximum amount of CPF savings that you can use.

Part of this article is copied from https://www.cpf.gov.sg/Members/FAQ/schemes/housing/housing-scheme#faq2185500

List of SBF launches

Sale of Balance Flats, comprising unsold leftover flats from past BTO launches, surplus flats from SERS projects, old repurchased flats (including flats from some divorced or fiance couples), are done “when HDB accumulate sufficient flats“, usually twice per year, but this is NOT A RULE. Since 2010 the SBF exercise is done same day with a BTO launch.

Sale Launch date Studio 2-rm 3-rm 4-rm 5-rm Exec+MG 3gen Total
Half-Yearly Sale Of 3-Room Premium,
4-Room And Bigger Flats
10 Oct 2008 33 491 78 81 683
Half-Yearly Sale Of 3-Room Premium,
4-Room And Bigger Flats
13 Apr 2009 10 313 80 35 438
Sale of Balance Flats 01 Oct 2009 121 58 345 1261 315 32 2132
Sale of Balance Flats 31 Aug 2010 55 61 1081 338 89 1624
Sale of Balance Flats 22 Sep 2011 86 497 431 1536 297 2847
Sale of Balance Flats 28 Mar 2012 216 1058 627 1348 467 109 3825
Sale of Balance Flats 27 Sep 2012 818 697 302 1016 471 24 3328
Sale of Balance Flats 30 May 2013 602 219 396 1381 478 24 3100
Sale of Balance Flats 26 Nov 2013 502 405 818 1644 595 10 3974
Sale of Balance Flats 22 May 2014 887 95 476 1241 674 10 3383
Sale of Balance Flats 25 Nov 2014 298 412 690 1206 632 6 47 3291
Sale of Balance Flats 27 May 2015 227 272 1892 2091 862 11 32 5387
Sale of Balance Flats 17 Nov 2015 1218 1064 2062 959 11 36 5350
Sale of Balance Flats 24 May 2016 900 1070 1942 1168 13 77 5170
Sale of Balance Flats 22 Nov 2016 635 1266 2233 837 13+1 23 5008
Sale of Balance Flats 18 May 2017 693 938 1305 967 17 26 3946
Re-Offer of Balance Flats 01 Aug 2017 110 384 624 260 9 7 1394
Sale of Balance Flats 14 Nov 2017 759 692 1407 460 7 76 3401
Re-Offer of Balance Flats  06 Feb 2018 50 217 109 331 7 3 717
Sale of Balance Flats 22 May 2018 754 655 1143 305 8 157 3022
Re-Offer of Balance Flats 28 Aug 2018
Sale of Balance Flats 13 Nov 2018

In May 2015 HDB announced that have 9,000 unsold flats that will be offered in two SBF exercises concurrent with May and August BTO launches, but in press release of 1 July 2015 HDB announced that the exercise was delayed to September, then the BTO launch was cancelled and mixed up with November BTO launch, and SBF was done at same time. Reason: HDB needed extra time to implement the new schemes of 2-Room Flexi and grants.

Fiance-fiancee couples who break up and do not get married within 6 months after receiving keys, as well as other people who for whatever reason need to sell the flat back to HDB during minimum occupation period, need to pay a penalty of 5% of market value of the flat, but more severely, they lose the first-timer status, and the flat is sold again via Sale of Balance Flats.

List of pre-BTO-era projects

My list of BTO launches got a record number of “thank you“, several visitors asked me if I can make a similar list for pre-BTO projects. YES I can make, BUT…

Below are the precints from Ang Mo Kio only, simplified version of database of HDB blocks.

Town name BTO name Built date Lease date Type 1-rm 2-rm 3-rm 4-rm 5-rm Exec Total flats
Ang Mo Kio Block 314 1994 Estate filling 7 84 91
Ang Mo Kio Block 104A-104B 1996 Estate filling 88 60 148
Ang Mo Kio Block 253-253A 1996 Estate filling 159 159
Ang Mo Kio Block 613-619 1996 Standard 80 173 214 467
Ang Mo Kio Blocks 700-700D 2003 possible SERS 216 192 408
Ang Mo Kio Block 309, 315, 316 2006 SERS 385 270 655
Ang Mo Kio Teck Ghee Vista
(Blocks 307, 308, 310)
2010 SERS 40 96 313 598 174 1221
Ang Mo Kio Park Central @ AMK
(Blocks 596A-596D)
2011 DBSS 351 216 567

 

The list of BTO launches was copied from Wikipedia, and HDB issue brochures at every launch, containing number of units, so making the table did not costed me much time.

The pre-BTO projects does not have name, launch or completion date, and there are NO brochures issued from them. A list like the above one can only be made MANUALLY, counting units would take hours.

Also they were built in batches and sold through Registration for Flat, I am not fully understand how RFS worked, but probably people could not choose which flat they want. Construction batches have no importance for buyers.

Can you give me a solid reason to spend time making a nationwide list of pre-BTO projects?

Database of landed housing

During 2016 2 people impressed by HDB and Condo databases created by me, asked me if I can create one more database of landed houses (street address, street number and postal code). So I created one for Woodgrove Estate in April 2017:

Landed Housing Database SAMPLE .xls

Housing database, directory of buildings in Singapore

If the Condo Database is made using web scraping software (automatically), the landed houses database can only be made manually like in the way I made the HDB Database, putting onemap.sg on side of screen and Excel on other side, writing street names and create array of street numbers, carefully to include all houses and not include non-existing houses. Given by the number of houses (more houses than HDB blocks) such database will probably take too much time and effort to complete it, I would need to sell at high price, and may never reach sufficient sale volume to cover my effort.

I run a scraping script on streetdirectory.com to input addresses and get postal code automatically. For unknown reasons I can’t get postal code for some buildings, so they will require to be added manually.

Also, while the HDB database can be easily kept up-to-date because HDB announce new BTO launches every 3 months, nobody announce where new houses are built or when a bungalow is demolished and rebuilt as semi-detached, keeping landed house database up-to-date will be difficult.

In January 2017 been contacted by someone looking for database of landed, offices, industrial. Would be better to make a database of all buildings in Singapore and not database dedicated to landed houses? What columns do you need for non-residential buildings?

In August 2017 One of my customers who bought HDB Database and Condo Database, made a scraping software to get information of all buildings from OneMap.sg and gave me the database as “work exchange”, with permission to resell it on my website. You can buy ALL buildings database. Probably now is no longer necessary to make myself, manually, a landed houses database.

Note: if you have a list of postal codes, you can give them to me, I run the script on streetdirectory.com and give you back the list with building name and address added!

HDB Annual Reports 1927-present

KZ, one of the biggest fans of my website and hobbyist regarding HDB history, went 4 times to National Library and photoed all annual reports of SIT and HDB as well as other publications about HDB. He gave me the photos (just for me), the photo collection being a mess, I spent a great amount of time sorting them. I personally did not wanted to publish his low-quality photos on my high quality website, but several people asked me to do so, and we agreed to sell them on my website and split the money 50-50%.

I transcribed the tables in Annual Reports 1990-2017 into Excel (New Towns under development and Dwelling units under management by town and flat type). I can go further and do the same for 1960-1989 tables, also transcribe in Word all the Annual Reports if there is sufficient demand.

Buy & download

HDB Annual Report 2017

The photos are not taken professionally (I told him to keep his damn phone parallel with table and photo entire page, but he didn’t) but are enough to read them at your home for references and cite annual report as source in case you need to write a dissertation for your university. See few photo samples:

SIT Annual Report 1958: floor plans, statistics, and preliminary plan of Toa Payoh (what SIT was going to build if was not replaced by HDB: a lot of low-rise blocks)

SIT Annual Report 1958 SIT Annual Report 1958 SIT Annual Report 1958

HDB Annual Report 1970: breakdown cost of each flat type, units under management.

HDB Annual Report 1970 HDB Annual Report 1970

HDB Annual Report 1990: layout plans of neighborhoods and a text article regarding revision of income ceiling, allowing permanent residents to purchase resale flats, etc.

HDB Annual Report 1990 HDB Annual Report 1990

What we have photoed:

SIT Annual Report 1927-1947 (1 book) and SIT Annual Report 1948-1959 (12 books), 1365 images, 1.37 GB
HDB Annual Reports 1960-2007 (46 books), 8473 images, 8.25 GB
JTC Annual Reports 1969-1978 (1 book), 92 images, 169 MB
Note: newer HDB Annual Reports (2008-present) can be found on HDB InfoWEB

Other books (3388 images, 4.09 GB):
Building on Productivity and Quality (1992)
Comparison of improvements on finishes fixtures fittings
Designed for living (1985)
HUDC brochures Phase 3&4
Our home magazine
Planning and Design of Public Housing Estates in Hong Kong (1983)
Public housing design handbook (1995)
Public housing in Singapore – A multi-disciplinary study – Edited by Stephen H.K.Yeh (1974)
Residents handbook
Study of HDB (1983)
Study of HDB (1985)
Surbana book

Buy complete collection of photos

Buy & download

Contact me if you want only a specific book or specific year of annual report.

I will send the files via WeTransfer.com, they are too big to be stored on server to download automatically.

News: a website visitor informed me that NLB website added HDB annual reports, for example:
http://eresources.nlb.gov.sg/printheritage/detail/fa19605d-936b-460f-b0b2-dbb3cf53256c.aspx
http://eresources.nlb.gov.sg/printheritage/detail/fa34007b-06ad-48fe-90f4-3602506e5b6a.aspx
If anyone else find more please inform me.