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.

I am surprised by the 0.5% increase in 4th quarter of 2019 against logic that contradict my prediction, does fall ended and another price bubble is coming in 2020? At same time, Coronavirus death toll exceeded 1000 on 10 February 2019, killing for first time 100+ people in one day. I expected that more cities in China will enter in quarantine and country economy may collapse, but things turned much worse and Coronavirus outbreak all over the world. Death toll is not big, but prevention measures caused major economic loss and we are going to a possible bigger recession than in 1997 or 2009.

Car database

In 2003 I started making voluntarily a car encyclopedia, several lists in .DOC format and tables in .XLS format which allows you to sort and filter car models. The hobby turned into a business since 2012 when I found professionals looking for such data, I improved original European car databases and created new databases for America and Asia using web scraping, they have been purchased by hundreds companies including car parts, insurance, shipping, as well as web designers and mobile app developers.

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.

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.

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.

List of SERS sites

Between 1995 and 2007, 71 SERS sites were announced. 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.

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.

Architecture – Housing Design history

I started designing buildings in 2008, “Teoalida’s Virtual City”, originally a hobby of graphic design and 3D modeling in AutoCAD, but a fully functional housing system (virtual city – because I do not have capital to build what I design). Dozens apartment block models, constantly improved, imagining being president of a country or manager of a housing corporation, with mission to offer quality housing for at least half of population, like what does HDB in Singapore (I am fascinated especially by public housing around the world). Since 2010 I also landed housing complexes and single family homes.

The “Virtual City” has impressed many people, from random individuals dreaming to have a home, to architects and housing developers, turning my hobby into business in 2012. I started learning architecture, to make construction drawings similar with professional architects, but I never enjoyed working for customers as much I enjoyed drawing for hobby. I has been contacted by few hundreds customers, but 9 of 10 were not willing to pay my services, and the paying customers wasted me too much time for little payments. My other hobby of making databases, which also turned into business in 2012, hit my target of $1000/month in 2015, making me to retire from architecture.

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

Solar System Database

Are you looking for a database of planets and satellites in Excel format with their facts and figures, for research or to make a website? I made a database in 2014 with planets and main satellites, sourcing data from solarsystem.nasa.gov. Given by high number of people who downloaded it, in 2019 I made a larger Excel database containing EVERY celestial body listed on NASA website (1 sun, 8 planets, 5 dwarf planets, 190 satellites).

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.

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.

About me – portfolio

I am Teoalida and I love doing research, collecting information, writing articles and making databases about real estate, cars, and other fields, as well as designing own housing models. Also playing games with buildings. I made this website since 2009 to share knowledge and educational material, sell my works and promote my services, and make new (business) friends.

If you have any enquiry about AutoCAD, architecture, real estate, databases, research, data mining and analysis, or any other stuff covered by articles of this website, comments about my works, errors to report, suggestions, critics, etc, feel free to contact me via Live chat or email image