If you need a list of condos in Excel format to organize your work, I made some databases for you extracting data from SingaporeExpats, PropertyGuru, and also BCA MCST search for people doing phone SMS marketing. Feel free to contact me for other web scraping projects!
Fields completion percentage
Fields completion percentage
|Managing agent database
Fields completion percentage
More than 1 month passed since last update? ASK for a new update! For best results please ask for update few days BEFORE the day you intend to do telemarketing
While the HDB Database is an original product “Made by Teoalida”, manually compiling data from multiple sources plus personal research, the Condo Database data belongs to SingaporeExpats and PropertyGuru websites, I do not recommend using this database in making websites. Feel free to use it for research and analysis purposes. I am NOT responsible for any copyright troubles you may face if you use their data commercially, making own website, etc. Please consider the price a fee for data scraping service from website rather than author of data.
See also my Terms and conditions.
Detailed data does exist for all major condos. Most old and small private apartments do not have number of units, TOP year, etc. There may be also small developments (less than 10 units) not included at all in both SingaporeExpats and PropertyGuru condo directories.
Description – Singapore Expats & Property Guru condo database
In 2009 I started making a database of all buildings in Singapore, for my personal research, sourcing condo name from map then digging various websites for details such as number of units (imagine how much time would take!). I abandoned the work in 2011 because it required too much effort to be done voluntarily.
In 2012 I published on website a sample of that database of all buildings and also a list of major condos, waiting for feedback to see does worth continuing the project, as paid service for professional use. Took 2 years to get feedback and realize what kind of data people are looking for, I revived the database in 2014 into a database of HDB buildings only, planning to start a separate database for condos, I posted a message in List of major condos page inviting people who are interested in a complete condo directory to contact me.
The first customer to contact me for condo database came only in September 2015, he purchased the HDB Database previously. Incidentally, in August 2015 I found tools that extract data from websites automatically, so I offered him 3 options: automatic data scraping from SingaporeExpats for $150 (2809 condos), automatic data scraping from PropertyGuru for $300 (3148 condos, a bit more details for each condo, such as postal code and number of floors), or manual data building, write condo names from onemap.sg then fill up details from above websites, for $1000 (this way would make most complete database). He said that is necessary to be very complete database, agreed with automatic scraping way, even told me specifically to scrap data from PropertyGuru, but this turned impossible because website display a CAPTCHA after every 10 pages accessed by scraping application. I ended in scraping SingaporeExpats.
SingaporeExpats is not a newsy website but a simple condo directory and it is lagging in terms of updates with latest condo launches, customer complained, and one of my friends (programmer) told me that can make in Visual Basic a custom scraping application for PropertyGuru, so I made him an offer. Programmer spend 2 weeks until he found a way to deal with CAPTCHA but charged me $300 for this, customer did not replied, after a month and multiple email he said that do not want to pay extra fee (despite that he asked initially to scrap PropertyGuru).
I posted a message inviting people interested in PropertyGuru to contact me and pay 50% fee in advance. Someone paid in July 2016 and programmer made a new scraping application. I get a CAPTCHA page every 10-50 pages which I solve myself in order for scraper to continue.
PropertyGuru website was redesigned in June 2018 making scraper obsolete, I asked my programmer to make a new scraper, but this time he was getting CAPTCHA on every single page so gave up. I contacted an Indian company who provide data mining services and they made a new scraper for PropertyGuru, using in-house human power to solve captchas, and gave me data only. I told them to include every possible data from website, including condo description, nearest MRT an schools, GPS coordinates, etc, increasing Excel file size from 2.4 to 10 MB.
I will update myself database manually adding new launched condos every few months (depending by sales frequency), and once per year, ask Indian company to run scrap again all condos.
Description – Management corporation database
In August 2016 someone asked me for MCST and managing agent contact number, this info is available for FREE on www.bca.gov.sg/bcadata/MCST.xls, however he said that this Excel file is not updated and told me to scrap www.bca.gov.sg/plan_enquiry/mcst_usersearch.aspx, to get latest data, but he did not paid me. A second customer asked me to scrap same website in January 2017. Having 2 requests, i believe that more people will come so I made a scraper for BCA website.
Scraping all MCST numbers from 0001 to 5000 takes about 10 hours and it can be done anytime you need. Because most people buy this database for one-time use in telemarketing, database need to be updated at the time you are using it. Because few people asked me to update database promising to buy afterwards, but never bought it, if you request update you need to pay first and I will provide you the updated database next day!
Smallest condo apartments
Smallest apartment in Singapore is 24 sqm (258 sq ft), 4 units in Suites @ Guillemard. All other studio apartments are 35+ sqm and have separate bed area. This because of URA which regulate minimum apartment size. However we need regulations of minimum apartment size for each number of rooms, to prevent extremely crowded condos like in the following examples:
Alexis Condo, 1-bedroom 36 sqm, 1-bedroom+study 47 sqm, 2-bedroom 56 sqm, very crowded layout, some apartments have no view.
Tree Scape @ Telok Kurau (site dead), 1-bedroom+study 40 sqm , 2-bedroom 49 sqm, 3-bedroom 56-65 sqm, 4-bedroom 84 sqm.
Natura @ Hillview (site dead), 1-bedroom 42 sqm, 2-bedroom 48-50 sqm, 3-bedroom 59-61 sqm, bedrooms sized like in Hong Kong (2×2 m).
High Park Residences is one of the FEW condos that include dimensions in floor plan. You can see that largest apartment type (5-bedroom) is 129 sqm, approximately the size of a 5-room 3-bedroom HDB from 1980s. Common bedrooms are just 2.5 x 2.5 meters.
Biggest condo apartments
I compiled this list in 2013, checking fat condo blocks viewed on map to find biggest regular 3/4-bedroom apartment sizes. Condos having one huge penthouse all other apartments small are not included. Since 2015 SingaporeExpats no longer show unit types and their floor areas… sadly.
Arcadia Garden (1983): 3 bedrooms 322 – 347 sq m, 4 bedrooms 345 – 434 sq m, Maisonette 610 sq m, Penthouse 697 sq m.
Fontana Heights (1985): 4 bedrooms 321 – 442 sq m, Penthouse 1102 sq m.
The Claymore (1985): 3 bedrooms 249 sq m, 4 bedrooms 311 sq m, Penthouse 457 sq m.
Astrid Meadows (1990): 3 bedrooms 180 – 240 sq m, 4 bedrooms 247 – 354 sq m, Penthouse 622 sq m.
Ardmore Park (2001): 4 bedrooms 268 sq m, Penthouse 812 sq m.
Grange Residences (2004) 4+1 bedrooms 2600 – 2853 sq ft.
Dairy Farm Estate (1989): 3 bedrooms: 181 – 205 sq m, Maisonette: 148 – 217 sq m.
Hillcrest Arcadia (1980): 3 bedrooms 132 – 183 sq m, Maisonette 255 – 269 sq m, Penthouse 213 – 235 sq m.
Also: Cairnhill Crest supposedly having 7 bedroom maisonettes… while all others apartments of Singapore have max 4-5 bedrooms. I would like to see an actual floor plan…
Looking for Singapore condo floor plans and sale brochures? Visit sgfloorplans.com