List of BTO brochures

I starting collecting the PDF brochures of BTO projects in December 2009. Saved every brochure in my computer and uploaded them here because HDB do not keep them available for more than 2-3 years and many people are needing brochures of older projects, especially when applying via Sale of Balance Flats.

HDB Executive Apartment floor plan

HDB history and floor plan evolution 1930s – 2020s

This page shows floor plans of ~100 most common HDB flat types and most representative layouts. Many other layouts exists, unique layouts with slanted rooms, as well as variations of the standard layouts, these usually have larger sizes.

Ang Mo Kio, Bedok, Bishan, Bukit Batok, Bukit Merah, Bukit Panjang, Bukit Timah, Central Area, Choa Chu Kang, Clementi, Geylang, Hougang, Jurong East, Jurong West, Kallang/Whampoa, Marine Parade, Pasir Ris, Punggol, Queenstown, Sembawang, Sengkang, Serangoon, Tampines, Tengah, Toa Payoh, Woodlands, Yishun.

HDB Resale Price Index

HDB price trends

HDB Resale Price Index DOUBLED from 2007 to 2013, dropped slightly to 2015 then stabilized. However, due to high supply of flats completed in 2014-2017 that enter on resale market since 2019, prices are likely to drop more in the coming years.

The 0.5% increase in 4Q 2019 contradict my prediction, does fall ended and another price bubble is coming in 2020? At same time, Coronavirus lockdown and circuit breaker may cause a bigger world recession than in 1997 or 2009 that will greatly affect Singapore private property market, and at smaller extent may affect public housing market too.

List of BTO projects

List of BTO projects

Build-To-Order was introduced in April 2001, currently new BTO flats are launched for sale in February, May, August, November. Future BTO locations are announced 6 months in advance, but exact day of launch is not known. This sable shows BTO names, town, launch date, estimated completion date, number of units breakdown by flat type, plus statistics such as average apartment size.

Car Models Engines All Details Database

Car database in Excel

List of car makes, models, trims, engine versions, specifications and features. All automobiles sold in Europe, America, Middle East, India, Japan, Australia, etc. I started this project voluntarily in 2003 and since 2012 the hobby turned into a business, databases been purchased by companies including car parts, dealers, tuning, classifieds, shipping services, insurance companies, web designers and mobile app developers. I am planning to offer in the future also API SaaS web service beside Excel download.

House design

House models designed by me

50+ house floor plans and 3D models designed by me from personal interest (artistic hobby / training) as well as for various customers. A mix of architectural design styles inspired from Singapore, Malaysia, Philippines, India, Europe, America and many others. I keep my past works here to offer ideas for students. View for free, pay and download AutoCAD DWG files.

HDB flat types and their sizes

Flat types guide: 1E, 2E, 1STD, 2STD, 3STD, 4STD, 5STD, 1I, 2I, 3I, 4I, 5I, 3NG, 4NG, 3S, 4S, 3A, 4A, 5A, EA, EM, MG, HUDC… Studio Apartment, 2-Room Flexi, 3-Room, 4-Room, 5-Room, Emergency, Standard, Improved, New Generation, Simplified, Model A, Executive Apartment / Maisonette, Multi-Generation, Standard vs Premium apartment.

HDB dwelling units per town and flat type

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-2019, table and chart
– Number of dwelling units by flat type and year 1990-2019, table and chart
– Statistics for calculation of the average flat size along history
– HDB achievements since 1960
– Resale market statistics

Index of databases made by me

Here is the list of 100+ databases I made during my life. I made them public for everyone, from students practicing data analysis, to multi-national companies in real estate and automobile industry.

Most projects I made from personal interest to distribute freely or sell for professional use. Some projects I made at request and published on website to allow other customers to purchase if interested.

I offer web scraping services in VB.NET and Python, making custom databases according your requirements. I work in Word and Excel, other file formats available: CSV, SQL, XML, JSON.

Braddell View HUDC

List of HUDC estates

Housing 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.

Singapore HDB Database

Database of HDB blocks in Excel format

HDB Database is an original compilation “Made by Teoalida” which took over 500 hours of work. Collecting data from multiple sources, I manually entered data in one Excel table for all HDB blocks ever built in Singapore, indicating 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, as well as many people who did not told me what business field they are in.

Apartment design

Apartment models designed by me

50+ apartment floor plans and 3D models designed by me from personal interest (artistic hobby / training) as well as for various customers. Even if I retired from this business and no longer serve new customers, I keep my past works here to offer ideas for students. View for free, pay and download AutoCAD DWG files.

List of SERS sites

Selective En-bloc Redevelopment Scheme was introduced in 1995, 71 SERS sites were announced by 2007. 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. It is obvious that SERS is highly selective and only a small amount of these flats will be selected for redevelopment. This page shows list of announced SERS sites and (personal prediction) future SERS sites.

Singapore Condo Database

Database of Condos

If you need to download a list of condos in Excel format to organize your work, I made some databases for you, extracting data from SingaporeExpats and PropertyGuru, plus the database of MCST Enquiry from BCA for people doing phone SMS marketing to condo management corporations. Sorry for people looking for email marketing but I do NOT have MCST email addresses.

HDB flats size over years

HDB flats size 1960-2010 analysis: are the flats shrinking?

Ministry of National Development, Khaw Boon Wan, said in 2012 that HDB flats have been the same size for last 15 years and are not shrinking. This article has been copied on numerous blogs.

As you can see in the following chat, the 4-room flats leased in 2000 were 90 sqm and 4-room flats launched in 2012 (TOP 2016) are the same 90 sqm, so he is not lying, instead he is masking the shrinking that occurred 15-20 years ago, also he does not take in consideration that the 4-room flat was the smallest flat type in 2000, while today it is the average flat type.

“Teoalida’s Virtual City” – my career as architectural designer

I started self-studying architecture in 2008 and designed “Teoalida’s Virtual City”, originally a hobby of graphic design and 3D modeling in AutoCAD, but a fully functional housing system.

Impressed by my works, many people contacted me for architectural design services, turning my hobby into business in 2012. But simply answering chats and emails, discuss project requirements to quote a price, was a horrible experience when 90% wanted free consultation and drawings, only 10% paid me and they wasted too much time. I lost interest for architecture around 2015 and now I am focusing to IT industry.

Having a collaboration with an established architecture company could have turned my life into a different direction, but did not had such chance until it was… TOO LATE.

Mobile phones database

Mobile phones database

If you want to download a database of mobile phones specifications in Excel format to create a website, use in a GSM shop or anything similar, I created an Excel database for you, including smartphones, old featured phones, tablets and smartwatches. I offer FREE monthly updates and weekly updates for $100/year.

Executive Condominium developer sales

List of Executive Condos

Table and map with Executive Condos and their TOP dates: Park Central Residences, Ola, Parc Canberra, Piermont Grand, Rivercove, Hundred Palms Residences, iNz Residence, Northwave, Treasure Crest, The Visionaire, Sol Acres, Parc Life, Wandervale, The Criterion, The Brownstone, Westwood Residences, Signature At Yishun, The Terrace, Bellewaters, The Vales, Bellewoods, Lake Life, The Amore, Sea Horizon, Ecopolitan, SkyPark Residences, Lush Acres, Forestville, The Topiary, Twin Fountains, [email protected], Waterbay, Waterwoods, Heron Bay, 1 Canberra, Twin Waterfalls, The Rainforest, The Tampines Trilliant, WaterColours, Blossom Residences, Arc at Tampines, RiverParc Residence, Belysa, Austville Residences, The Canopy, Esparina Residences, Privé, La Casa, The Quintet, The Esparis, Whitewater, Park Green, Nuovo, Lilydale, Bishan Loft, The Dew, The Eden, The Floravale, Woodsvale, Northoaks, The Florida, The Rivervale, Summerdale, Yew Mei Green, Pinevale, Chestervale, Windermere, Simei Green, Westmere, Eastvale.

World cities database

World cities database

Worldwide cities database organized by country, state and province, with city population indicated. This is a handmade database that I started in 2003, currently having over 8000+ cities, with possibility of expansion in the future, based on demand from customers.

Architectural drawing

Architectural design services – procedure and pricing

Update: I (Teoalida) will NOT make any more architectural designs. I have partner architects in India, Nigeria, Philippines, Romania and United States. They have diploma in architecture (I don’t have) and offered to work for me if I am too busy but seeing their high experience and cheap prices I decided to pass them ALL architectural projects, to free my time and focus on IT / data providing industry.

Web scraping services

I offer data mining and web scraping services. “Scraping” usually means coding a bot that visit a list of given pages, copy specific data from each page and put it in an Excel / CSV file automatically, at rate of few pages per second. Watch the video!

If you are building a website, a mobile app, or just require specific data but cannot find in usable format, just give me link to a website having required data, I will make a scraper and turn website into an Excel database, for you and for future customers.

Excel, XLS, XLSX, CSV, SQL, XML, JSON