PropertyGuru Property Listing Scraper And Rental-Installment BreakEven Analysis
Interactive Dashboard
Condo Property Price in KL (updated monthly): https://datastudio.google.com/s/iDD1161H8RQ
Column Description
- Mean: Mean Price for Sale/Rent
- CV: Coefficient of Variation of Sale/Rent Price
- Median: Mean Price for Sale/Rent
Color Legend
- Red: Sale list summary
- Blue: Rental list summary
- Green: Percentage breakeven (%)
Rental-Installment BreakEven Formula and Assumptions
- The degree of high-balling are assumed to be the same for both selling and renting prices scraped.
- Only those properties with both sale and rental listed will be selected.
- Default analysis will remove NaN entries and calculate break-even % as in (2) based on median prices.
- Gross Rental-Installment Break-even Rate are pre-calculated as:
RM404 monthly installment /RM100k selling price (90% loan, 3.5% IR, 30yrs)
Property List Scraper
- A python scraper to scrape property price listed for sale or rent in Malaysia from PropertyGuru.com.
- Currently supports state and property type filters only (ping me if you need more precise/personalized filters)
- Strictly for educational purposes only.
- Any suggestions/collabs are very much welcomed!
- Property price datasets (sampled every first day of the month)
How to scrape myself?
- Download data-scraper-v2alpha.py (right-click and download).
- Install python and dependencies.
- Run the script with your parameters. (check -h for documentation)
- Enjoyy! P/S: Refer section below for the keywords
Query selection keywords (select one for each category):
| Category | Keywords |
|---|---|
| MARKET | residential, commercial (not tested) |
| PROPERTY_TYPE | all, bungalow (Bungalow / Villa), condo (Apartment / Condo / Service Residence), semid (Semi-Detached House), terrace (Terrace / Link House), land (Residential Land) |
| STATE | johor, kedah, kelantan, melaka, ns, pahang, penang, perak, perlis, selangor, terengganu, sabah, sarawak, kl, labuan, putrajaya, other |
Output Data Description
| Column | Type | Remarks |
|---|---|---|
| PropertyName | str | |
| Type | str | Sale/Rent |
| Price | float | |
| Bedrooms | str | int or str (eg. Studio) |
| Bathrooms | str | int or str (eg. Studio) |
| Sqft | int | Lot size |
| Author | str | Person who uploaded the listing |