Singapore

HDB resale flat prices database

Lists and databases

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.

MCST database

Looking for Management Corporation Strata Title (MCST) phone numbers for telemarketing? I made this database for you sourcing data from BCA website > MCST enquiry, and update it on request basis. Sorry for people looking for email marketing but BCA do not provide MCST agent email addresses.

Database of all buildings in Singapore with postal codes

The database contains EVERY searchable item in Singapore 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.

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.

List of Executive Condos

Executive Condominium (EC) is a form of subsidized housing built by private developers, having same eligibility restrictions like HDB (family nucleus, citizens and permanent residents), you should dispose any other property 30 months before applying, minimum occupation period of 5 years before you can sell to citizens and PR, even single PR. After 10 years since TOP date, all restrictions are lifted and even single foreigners can buy. I made an interactive map with TOP dates.

List of MRT and LRT stations

Lists and databases

If you are looking for a database of Singapore MRT and LRT stations in Excel format, I created an Excel database for you in November 2019, copy-pasted from Wikipedia and visually enhanced in Excel to match the style of my other spreadsheets “Made by Teoalida”. In January 2020 I expanded database adding postal codes and GPS coordinates (sourced from OneMap.sg) for all stations that are opened or under construction.

What is Lease Commence Date & property depreciation

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.

HDB Application Rate

HDB InfoWeb Appliation Status page does provide the application rate for last BTO project and SBF, breakdown by flat type. I compiled an Excel table with a summary of application rate for every BTO and SBF launch from 2010 to present and offer it for free download together with HTML pages.

HDB Annual Reports 1927-present

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.

Map of HDB blocks colored by height

Map of HDB blocks colored by construction year is one of most popular projects I made on this website, but some people asked me to recolor map by number of floors.