Skip to content

Singapore condo database

If you need 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.

PropertyGuru database cost more because is difficult to extract data from, it detect our scraping bots and display a CAPTCHA.


PropertyGuru database

Free SAMPLE:
PropertyGuru Condo Directory

Buy full database + 1 year of FREE updates:

Data fields included: Project Name 100.00%, Address 100.00%, Postal code 100.00%, District 100.00%, Project Type 99.97%, Developer 74.26%, Tenure 99.97%, Price 64.24%, PSF Price 63.50%, Completion Year 91.24%, # Of Floors 34.87%, Total Units 79.03%, Description 97.63%, Facilities & Amenities 70.48%, Nearest MRT Stations 99.29%, Nearest Schools 99.42%, Image URLs 65.74%, GPS coordinates 100.00%.

Updates done with help from a Pakistan VB.NET programmer:
Jul 2016 – 3176 properties
Jan 2017 – 3195 properties
Jun 2017 – 3195 properties
Jan 2018 – 3214 properties

Updates done by an Indian company using an Excel VBA macro and human power to solve captcha: (I paid $300 for this update, they did not gave me scraper so I had to pay them for each update, which I could not afford due to poor sales)
Dec 2018 – 3252 properties

Updates done using Python script from an Egypt programmer:
Feb 2021 – 3328 properties (about 500 duplicates, probably same number of missing properties)
June 2021 – 3341 properties (2781 unique properties and 561 duplicates)

Updates done myself using browser scraper:
Dec 2021 – 2853 properties after removing duplicates. Browser scraper wasn’t detected by anti-scraping features to display CAPTCHA.
28 Oct 2022 – 3326 properties but could not extract their details because of CAPTCHA.
In 2023 I didn’t tried to scrap anymore, being convinced that is no longer possible, and the only solution is to pay $5/hour to a data entry guy.
26 March 2024 – 3561 properties (3541 unique), I found a data entry guy and I tried scraping for one last time to investigate duplicates, surprisingly no CAPTCHA appeared.


SingaporeExpats database

Free SAMPLE:
SingaporeExpats Condo Directory

Buy full database + 1 year of FREE updates:

Data fields included: Condo name 100%, Condo address 100%, Property type 100%, District 100%, Developer 72.40%, Tenure 80.33%, Estimated TOP 74.65%, Number of units 71.56%, Description 98.43%, Facilities 61.31%, Nearest MRT 100%, Nearest schools 100%

Updates done myself:
Oct 2015 – 2809 properties
Nov 2015 – 2810 properties
May 2016 – 3112 properties
April 2017 – 3112 properties, added 3 extra columns

Scraper takes just 1 hour to extract data from SingaporeExpats, but their website is not updated on regular basis, as 2020 I found 3114 condos (they added only 2 new condos in 3 years)


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 same 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 in Excel VBA + using their 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.

Due to CAPTCHA I would needed to pay them each time I want them to run scraper and update all condos, alternatively I could add new launched condos manually without updating older records. But sales of Excel database dropped in 2019 and updates were no longer viable.

In December 2020 a programmer from Egypt joined my team, he made a script in Python that avoid CAPTCHA, gave me the script which I can run in my computer anytime someone wants update (it takes just 30 minutes to extract data of 3300+ condos from PropertyGuru).

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.


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 condo blocks that looked fat and bulky when viewed on map, to find biggest regular 3/4-bedroom apartment sizes. Condos having one huge penthouse all other apartments small are not included. You could click below links to see unit types until 2015 when SingaporeExpats stopped showing unit types and their floor areas in condo directory.

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

27 comments

  1. Hi,
    First of all I would like to say a big “thank you” for so many amazing work been done here. and it did provide very useful information and vision to me in the real estate.
    I am also a BIG FAN at Real Estate and data analysis as well and thinking to do something similar, for example, some visionary/graphic display of data analysis. I wonder whether there is chance we can collaborate together in certain ways & aspects, to make this website better?

    You may contact me by my email. Look forward to hearing from you.

    Regards,
    Scaning

    1. If you have any suggestion for website theme, colors, or content, feel free to speak! Or we can collaborate in making new research.
      Why did you posted this in Condo List? are you particularly interested in condos? I am HDB fan!

  2. Teo can’t give any answer due to his happy marriage to a Romanian boy. He also a total gay give a great blow job job but by appointment only

    1. YES… I can update the database (re-scrap SingaporeExpats or PropertyGuru) anytime you need an update. But we will see the update frequency of the source website.

  3. I feel SAD that some people don’t go into purchase

    Chat started on Monday, January 15, 2018 12:55:01 PM

    (12:55:01 PM) *** Visitor 52940710 has joined the chat ***
    (12:55:03 PM) Teoalida (site owner): Hi there… are you looking for a specific database? you are welcome for a chat!
    (12:55:12 PM) Visitor 52940710: hi
    (12:55:25 PM) *** Teoalida has joined the chat ***
    (12:55:31 PM) Teoalida: What’s up
    (12:55:44 PM) Visitor 52940710: is your data valid
    (12:56:21 PM) Teoalida: how do you call valid?
    (12:56:34 PM) Visitor 52940710: email ids don’t bounce…
    (12:56:42 PM) Visitor 52940710: phone numbers haven’t change
    (12:56:51 PM) Visitor 52940710: or they are the latest ones
    (12:57:30 PM) Teoalida: I do not have emails, I have phone number of managing agent and I update regularly by re-scraping https://www.bca.gov.sg/plan_enquiry/mcst_usersearch.aspx
    (1:00:19 PM) Teoalida: how often do you need updates?
    (1:04:24 PM) Visitor 52940710: so only way to contact these condos is through phone
    (1:04:34 PM) Teoalida: sadly yes
    (1:04:56 PM) Teoalida: if you ever find a website dispalying managing agent email, tell me and I create a scraping script
    (1:19:56 PM) Teoalida: Do you find anything interesting on the other pages of my website?
    (1:20:00 PM) *** Visitor 52940710 has left ***

  4. I just bought your Managing Agent database. I know you simply queried the BCA database. A problem with the BCA database is that “Development Name” either states the actual name, eg, “MANDALAY COURT” or the MCST, “MANAGEMENT CORPORATION STRATA TITLE PLAN NO. 0012”. I was hoping that you would correct that. Otherwise your dataset is essentially the same as that which I downloaded from BCA earlier today.

  5. Technical education plays an important role in the socio-economic development of the country in general, emancipation and empowerment of poor and disadvantaged groups / population in particular. It provides varied type of manpower. To become a world class centre in providing globally relevant higher education in the field of enginering, technology and applied science embedded with human values.

    plz
    call me
    9198429494 shanu pritee Allahabad
    plz call me.

Leave a comment

Your email address will not be published. Required fields are marked *