Skip to content

Teoalida

Singapore Improvement Trust

SIT history: 1930s to 1950s

Singapore Improvement Trust set up in 1927 and focused on infrastructure, it also built small scale public housing, such as Tiong Bahru (started in 1936) and Queenstown (started in 1952 and completed by HDB in 1960s). In 32 years, SIT built only 23,000 flats, housing 8.8% of Singapore population in 1959.

HDB Resale Price Index

HDB price trends

HDB Resale Price Index DOUBLED from 2007 to 2013, dropped 10% to 2015 then stabilized until 2020 when COVID-19 pandemic triggered another bubble.

The charts show price evolution for each town. Click towns on right side to highlight lines.

Condo map

Map of private properties

An original project “Made by Teoalida” displaying data from PropertyGuru on an interactive map. Click condo pins on map to see details about each property such as address, completion year, tenure, number of units, developer, etc. You can also apply filters to display on map only HDB blocks that meet certain criteria.

HDB statistics, facts & figures

– Number of dwelling units by town and flat type, table and chart
– Number of dwelling units by town and year 1990-present, table and chart
– Number of dwelling units by flat type and year 1990-present, table and chart
– Statistics for calculation of the average flat size along history
– HDB achievements since 1960
– Resale market statistics

HDB Database

HDB blocks database

Collecting data from multiple sources, I spent 500+ hours entering data in one Excel table: block number, street address, postal code, GPS coordinates, construction year, lease commence date, number of floors, number of units breakdown by flat type, upgrading programmes, brochures and floor plans.

The database has been purchased by several companies, including home insurance, telecommunication, door-to-door services, real estate portals, flyer distributors, etc. Season parking.

HDB Resale Flat Prices Database

HDB resale flat prices database

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.

Condo Database Management Corporations

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.

Postal codes

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.