Dubai Land Department - Residential Market Analysis¶
This notebook explores transaction and rental contract data from the Dubai Land Department (DLD) to estimate rental yield and cumulative property value growth across major residential projects and master communities.
Datasets used:
Transactions.csv- property sales records (DLD open data)Rent_Contracts.csv- Ejari rental contract records (DLD open data)
Scope of analysis:
- Property type: Flat, existing properties only
- Room types: 2 B/R and 3 B/R
- Area range: 70 to 160 sqm
- Period: January 2014 to July 2024
- Projects with fewer than 10 recorded transactions are excluded
1. Sales Data¶
We load the full transactions file, parse dates, and apply filters to focus on a comparable segment: existing flat sales in the 2 B/R and 3 B/R range between 70 and 160 sqm.
Transactions loaded: 52,341 Date range: 2014-01-02 to 2024-07-17 Unique projects: 500 Master communities: 52
| trans_group_en | procedure_name_en | property_type_en | property_sub_type_en | property_usage_en | reg_type_en | area_name_en | building_name_en | project_name_en | master_project_en | rooms_en | procedure_area | actual_worth | meter_sale_price | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| date | |||||||||||||||
| 2014-01-02 | Mortgages | Mortgage Registration | Unit | Flat | Residential | Existing Properties | Al Hebiah Fifth | AL THAMAM 53 | REMRAAM | Remraam | 2 B/R | 106.750 | 1134000.000 | 10622.950 | 1 |
| 2014-01-02 | Sales | Sell | Unit | Flat | Residential | Existing Properties | Burj Khalifa | BD Standpoint A | DD STAND POINT | Burj Khalifa | 2 B/R | 112.320 | 3650000.000 | 32496.440 | 1 |
| 2014-01-02 | Sales | Sell | Unit | Flat | Residential | Existing Properties | Marsa Dubai | CAYAN TOWER | CAYAN TOWER | Dubai Marina | 2 B/R | 127.500 | 1900000.000 | 14901.960 | 1 |
| 2014-01-02 | Sales | Sell | Unit | Flat | Residential | Existing Properties | Burj Khalifa | BD Standpoint B | DD STAND POINT | Burj Khalifa | 2 B/R | 108.450 | 2500000.000 | 23052.100 | 1 |
| 2014-01-02 | Sales | Sell | Unit | Flat | Residential | Existing Properties | Marsa Dubai | Torch Tower | TORCH TOWER | Dubai Marina | 2 B/R | 116.910 | 1700000.000 | 14541.100 | 1 |
1.1 Area Distribution¶
After filtering to the 70 to 160 sqm range, the distribution below shows the most common unit sizes in the sales data. The peak around 115 to 125 sqm reflects the typical 2 B/R flat footprint in Dubai's established residential projects.
1.2 Annual Transaction Volume¶
Transaction volume by year reveals market cycles. The COVID-related dip in 2020 and the strong recovery from 2021 onward are both clearly visible.
1.3 Median Price per Sqm Over Time¶
The median meter sale price (AED/sqm) across all projects shows the broad market price trend over the analysis period.
2. Rental Data¶
We load the Ejari rental contracts, applying matching filters to ensure comparability with the sales segment: new contracts only, residential flats, 2 or 3 bedrooms, 70 to 160 sqm.
Rental contracts loaded: 102,363 Date range: 2014-01-01 to 2024-07-31 Unique projects: 591
| contract_reg_type_en | contract_amount | annual_amount | contract_end_date | line_number | is_free_hold | ejari_bus_property_type_en | ejari_property_type_en | ejari_property_sub_type_en | property_usage_en | project_name_en | master_project_en | area_name_en | tenant_type_en | actual_area | count | annual_rent_m2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| date | |||||||||||||||||
| 2014-01-01 | New | 100000 | 100000 | 31-12-2014 | 1 | 1 | Unit | Flat | 3 bed rooms+hall | Residential | MARINA PINNACLE | Dubai Marina | Marsa Dubai | NaN | 146.000 | 1 | 684.932 |
| 2014-01-01 | New | 51700 | 51700 | 31-12-2014 | 1 | 1 | Unit | Flat | 2 bed rooms+hall | Residential | THE CRESCENT | International Media Production Zone | Me'Aisem First | NaN | 123.000 | 1 | 420.325 |
| 2014-01-01 | New | 120000 | 120000 | 31-12-2014 | 1 | 1 | Unit | Flat | 2 bed rooms+hall | Residential | V3 | Jumeirah Lakes Towers | Al Thanyah Fifth | Person | 151.000 | 1 | 794.702 |
| 2014-01-01 | New | 51000 | 51000 | 31-12-2014 | 1 | 1 | Unit | Flat | 2 bed rooms+hall | Residential | SKY COURTS | Residential Complex | Wadi Al Safa 5 | NaN | 101.000 | 1 | 504.950 |
| 2014-01-01 | New | 50000 | 50000 | 31-12-2014 | 1 | 1 | Unit | Flat | 2 bed rooms+hall | Residential | SKY COURTS | Residential Complex | Wadi Al Safa 5 | NaN | 117.000 | 1 | 427.350 |
2.1 Rental Area Distribution¶
2.2 Annual Rent per Sqm Over Time¶
The sharp post-2021 rise in median rent per sqm reflects both demand recovery and the broader price cycle observed in the sales data.
3. Rental Yield by Project¶
Rental yield is computed as the ratio of annual rent per sqm to sale price per sqm, aggregated at the yearly level per project. Only projects appearing in both the sales and rental datasets are included. Yield observations below 2% or above 20% are removed as they typically reflect data sparsity rather than true market conditions.
Projects with yield data: 473 Years covered: 11
3.1 Yield Uncertainty via Error Propagation¶
Since both rent and sale price carry variability, we propagate their uncertainty into a yield standard error estimate using the standard ratio error formula: sigma_roi / roi = sqrt( (sigma_rent/rent)^2 + (sigma_price/price)^2 ).
3.2 Project Yield Summary (2020 to 2024)¶
Summary statistics per project over the 2020 to 2024 window, sorted by median yield. The 2023 and 2024 columns show the most recent annual yield observations.
| N years | Mean % | Std % | P25 % | Median % | P75 % | 2023 % | 2024 % | |
|---|---|---|---|---|---|---|---|---|
| project_name_en | ||||||||
| UNIESTATE SPORTS TOWER | 500.000 | 12.200 | 1.320 | 10.760 | 13.170 | 13.170 | 10.760 | 10.760 |
| ZENITH TOWER A2 | 500.000 | 12.000 | 2.380 | 11.480 | 11.960 | 12.810 | 11.960 | 11.480 |
| HANOVER SQUARE | 500.000 | 10.400 | 2.020 | 9.630 | 11.280 | 11.690 | 12.190 | 11.280 |
| HDS SUNSTAR 1 | 500.000 | 10.240 | 1.440 | 9.410 | 11.240 | 11.240 | 8.090 | 9.410 |
| DIAMOND VIEWS 2 | 500.000 | 13.160 | 3.170 | 10.990 | 10.990 | 16.620 | 10.990 | 10.990 |
| PALACE TOWER | 500.000 | 10.760 | 0.880 | 10.850 | 10.950 | 11.200 | 10.850 | 11.200 |
| LINCOLN PARK | 500.000 | 10.200 | 1.080 | 9.600 | 10.870 | 10.870 | 11.080 | 9.600 |
| EATON PLACE | 500.000 | 10.800 | 3.470 | 8.650 | 10.620 | 10.810 | 8.650 | 10.810 |
| Rigel | 400.000 | 10.480 | 1.090 | 9.900 | 10.600 | 11.190 | 10.160 | 11.050 |
| QPOINT LIWAN-PLOT R092 | 500.000 | 10.190 | 1.340 | 10.190 | 10.590 | 10.600 | 10.590 | 11.570 |
| EDMONTON ELM | 300.000 | 11.360 | 1.960 | 10.240 | 10.560 | 12.080 | 9.930 | 13.600 |
| BADRA PHASE 1 | 500.000 | 10.350 | 0.510 | 10.090 | 10.520 | 10.520 | 10.090 | 10.520 |
| OLYMPIC PARK 1 | 500.000 | 9.690 | 1.390 | 9.150 | 10.440 | 10.670 | 10.670 | 10.440 |
| SHERENA RESIDENCE | 500.000 | 9.960 | 1.950 | 8.070 | 10.380 | 11.780 | 7.770 | 8.070 |
| DIAMOND VIEWS 3 | 500.000 | 9.580 | 1.180 | 9.200 | 10.290 | 10.290 | 10.290 | 10.290 |
| CHAMPIONS TOWER1 | 500.000 | 9.980 | 0.880 | 9.120 | 10.270 | 10.770 | 10.770 | 10.770 |
| SAPPHIRE RESIDENCE | 500.000 | 10.060 | 1.130 | 10.010 | 10.110 | 10.990 | 10.110 | 10.010 |
| ZENITH TOWER A1 | 500.000 | 10.130 | 1.400 | 9.280 | 10.110 | 10.220 | 10.110 | 12.380 |
| IMPERIAL RESIDENCE | 500.000 | 9.210 | 1.340 | 7.800 | 10.020 | 10.060 | 10.020 | 10.450 |
| DANA TOWER | 500.000 | 9.680 | 0.690 | 9.480 | 9.950 | 10.000 | 10.000 | 9.480 |
3.3 Top 20 Projects by Median Yield¶
Error bars represent the adjusted yield uncertainty: propagated standard error is used when it is small and the observed standard deviation is used as a fallback when propagated error is large, which typically occurs in projects with sparse data.
4. Rental Yield by Master Community¶
Aggregating yields to the master project level gives a regional view for comparing broad investment zones.
| Avg Yield % | Std % | 2024 % | 2023 % | Adj Std % | |
|---|---|---|---|---|---|
| master_project_en | |||||
| Badra | 10.350 | 0.510 | 10.520 | 10.090 | 3.890 |
| Majan | 9.960 | 1.950 | 8.070 | 7.770 | 2.570 |
| Dubai Studio City | 9.430 | 1.240 | 9.640 | 9.360 | 2.490 |
| Jumeirah Village Triangle | 9.150 | 1.480 | 9.640 | 9.510 | 2.880 |
| Jumeirah Islands | 9.140 | 0.720 | 9.000 | 10.050 | 3.140 |
| Dubai Sports City | 9.050 | 1.280 | 9.850 | 9.520 | 2.990 |
| Jumeirah Village Circle | 8.880 | 1.130 | 9.340 | 9.120 | 2.400 |
| Silicon Oasis | 8.800 | 1.250 | 9.070 | 9.590 | 2.500 |
| Liwan | 8.780 | 1.230 | 10.150 | 9.230 | 2.650 |
| Dubai Health Care City Phase 2 | 8.720 | 0.870 | 9.520 | 8.810 | 2.240 |
| Dubai Investment Park Second | 8.700 | 1.510 | 9.910 | 9.470 | 2.850 |
| Mohammed Bin Rashid AL Maktoum District 11 | 8.500 | 1.660 | 7.320 | 9.150 | 2.080 |
| Living Legends | 8.450 | 0.760 | 8.070 | 8.240 | 1.350 |
| Jumeirah Lakes Towers | 8.400 | 1.120 | 8.930 | 9.130 | 2.370 |
| Arjan | 8.370 | 1.080 | 9.180 | 9.030 | 2.120 |
| International City Phase 1 | 8.350 | 0.840 | 8.300 | 8.370 | 2.260 |
| Remraam | 8.320 | 0.820 | 9.020 | 8.230 | 2.020 |
| International Media Production Zone | 8.280 | 1.490 | 9.550 | 8.590 | 2.650 |
| Jumeirah Golf Estates | 8.240 | 1.100 | 8.780 | 9.510 | 3.040 |
| International City Phase 3 | 8.190 | 0.500 | 8.290 | 8.800 | 2.140 |
| Wasl Gate | 8.170 | 1.130 | 9.480 | 7.520 | 0.880 |
| TECOM Site C | 8.070 | 1.170 | 7.870 | 9.250 | 2.280 |
| Al Furjan | 8.040 | 1.170 | 8.260 | 8.190 | 2.000 |
| Residential Complex | 7.990 | 1.520 | 8.550 | 9.340 | 2.630 |
| The Greens | 7.980 | 0.750 | 8.020 | 8.380 | 1.820 |
| Down Town Jabal Ali | 7.870 | 1.440 | 7.690 | 7.820 | 3.000 |
| TOWN SQUARE | 7.870 | 1.430 | 9.470 | 8.770 | 2.350 |
| DAMAC HILLS | 7.800 | 1.310 | 8.960 | 9.050 | 1.940 |
| Dubiotech | 7.770 | 0.850 | 8.430 | 7.940 | 2.000 |
| Dubai South Residential District | 7.620 | 1.760 | 8.970 | 7.640 | 2.170 |
| DUBAI HILLS | 7.460 | 1.110 | 7.550 | 8.250 | 2.560 |
| TECOM Site B | 7.340 | 1.130 | 8.180 | 8.230 | 2.190 |
| Dubai Marina | 7.300 | 0.820 | 7.370 | 7.720 | 2.100 |
| DAMAC HILLS 2 | 7.280 | 1.750 | 8.630 | 7.920 | 2.260 |
| Business Bay | 7.270 | 1.170 | 7.660 | 7.690 | 2.110 |
| DUBAI HILLS - PARK | 7.250 | 0.750 | 7.090 | 7.970 | 3.000 |
| Meydan | 7.150 | 0.790 | 7.920 | 6.960 | 2.420 |
| Dubai Maritime City | 6.960 | 2.140 | 9.410 | 5.470 | 1.620 |
| SOBHA HARTLAND | 6.810 | 1.110 | 7.400 | 7.500 | 1.700 |
| Motor City | 6.800 | 0.540 | 7.340 | 7.380 | 1.250 |
| City Walk | 6.520 | 1.130 | 6.550 | 7.340 | 2.040 |
| Jumeriah Beach Residence - JBR | 6.500 | 1.240 | 5.000 | 5.990 | 2.230 |
| Burj Khalifa | 6.470 | 0.730 | 6.720 | 6.870 | 2.160 |
| Culture Village | 6.450 | 1.110 | 6.320 | 6.430 | 1.730 |
| Palm Jumeirah | 6.350 | 0.940 | 7.200 | 6.440 | 2.210 |
| LA MER | 6.240 | 0.530 | 5.970 | 6.430 | 0.640 |
| Wasl 1 | 6.160 | 0.370 | 6.250 | 6.390 | 1.060 |
| Dubai World Central | 6.120 | 1.310 | 7.610 | 5.980 | 2.410 |
| Uptown Mirdif | 5.800 | 0.780 | 6.800 | 5.130 | 2.120 |
| The Lagoons | 5.700 | 0.640 | 5.980 | 6.090 | 1.280 |
| Mudon | 5.620 | 1.350 | 7.510 | 6.260 | 1.410 |
5. Historical Property Value Growth by Region¶
Using the sales data, we estimate annual percentage change in median price per sqm for each master community. The chart shows the average recent return over the last 4 years with historical standard deviation as error bars. Year-on-year changes above 40% are treated as outliers and removed, as they usually reflect thin transaction coverage in a given year.
6. 10-Year Cumulative Return Projection¶
Using the recent 4-year average regional price appreciation as a starting point, we project cumulative returns over a 10-year horizon. The model assumes a gradual mean-reversion toward a long-run equilibrium return of approximately 3.1% per year, composed of 1.5% real estate real return and 1.6% inflation, reached by year 5.
Two reference lines are shown for context:
- Inflation baseline - cumulative CPI-based erosion of purchasing power
- RE market estimate - baseline nominal return (inflation + long-run real return)
Projection built. Rows = years (0 to 10), columns = regions.
| master_project_en | year | Al Furjan | Arjan | Badra | Burj Khalifa | Business Bay | City Walk | Culture Village | DAMAC HILLS | DUBAI HILLS | DUBAI HILLS - PARK | Down Town Jabal Ali | Dubai Investment Park Second | Dubai Marina | Dubai South Residential District | Dubai Sports City | Dubai Studio City | Dubai World Central | Dubiotech | International City Phase 1 | International City Phase 3 | International Media Production Zone | Jumeirah Golf Estates | Jumeirah Heights | Jumeirah Islands | Jumeirah Lakes Towers | Jumeirah Village Circle | Jumeirah Village Triangle | Living Legends | Liwan | Majan | Meydan | Motor City | Mudon | Palm Jumeirah | Remraam | Residential Complex | SOBHA HARTLAND | Silicon Oasis | TECOM Site B | TECOM Site C | TOWN SQUARE | The Greens | The Lagoons | Uptown Mirdif |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | year_0 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
| 1 | year_1 | 1.068 | 1.022 | 1.098 | 1.216 | 1.119 | 1.106 | 1.090 | 1.056 | 1.177 | 1.245 | 1.125 | 1.063 | 1.131 | 1.008 | 1.079 | 1.095 | 1.116 | 0.959 | 1.031 | 1.165 | 0.933 | 1.081 | 0.983 | 1.082 | 1.150 | 1.150 | 0.951 | 1.062 | 1.085 | 1.051 | 1.126 | 1.030 | 1.005 | 1.107 | 1.000 | 1.068 | 1.051 | 1.105 | 1.009 | 1.089 | 1.055 | 1.152 | 1.099 | 1.019 |
| 2 | year_2 | 1.134 | 1.047 | 1.192 | 1.434 | 1.232 | 1.206 | 1.176 | 1.111 | 1.351 | 1.496 | 1.245 | 1.124 | 1.257 | 1.020 | 1.154 | 1.185 | 1.226 | 0.934 | 1.063 | 1.327 | 0.888 | 1.158 | 0.975 | 1.160 | 1.295 | 1.296 | 0.920 | 1.121 | 1.166 | 1.100 | 1.247 | 1.060 | 1.016 | 1.209 | 1.005 | 1.133 | 1.100 | 1.205 | 1.022 | 1.174 | 1.107 | 1.298 | 1.192 | 1.040 |
| 3 | year_3 | 1.194 | 1.074 | 1.277 | 1.637 | 1.335 | 1.298 | 1.254 | 1.162 | 1.511 | 1.734 | 1.354 | 1.180 | 1.371 | 1.037 | 1.223 | 1.267 | 1.327 | 0.923 | 1.097 | 1.475 | 0.863 | 1.229 | 0.977 | 1.231 | 1.428 | 1.428 | 0.904 | 1.176 | 1.240 | 1.147 | 1.357 | 1.092 | 1.032 | 1.301 | 1.018 | 1.194 | 1.147 | 1.296 | 1.040 | 1.252 | 1.157 | 1.432 | 1.277 | 1.065 |
| 4 | year_4 | 1.249 | 1.104 | 1.351 | 1.809 | 1.423 | 1.377 | 1.322 | 1.210 | 1.646 | 1.936 | 1.447 | 1.232 | 1.468 | 1.059 | 1.285 | 1.339 | 1.413 | 0.925 | 1.131 | 1.600 | 0.856 | 1.292 | 0.988 | 1.295 | 1.540 | 1.541 | 0.903 | 1.227 | 1.305 | 1.192 | 1.450 | 1.126 | 1.053 | 1.381 | 1.036 | 1.249 | 1.191 | 1.375 | 1.063 | 1.320 | 1.204 | 1.546 | 1.352 | 1.093 |
6.1 End-of-Term Distribution¶
The histogram below shows the spread of projected 10-year cumulative returns across all regions under the mean-reversion model.
Mean: 1.571x Median: 1.569x Std: 0.296 Min: 1.008x Max: 2.421x P25: 1.356x P75: 1.729x
7. Illustrative Mortgage Cost Model¶
A simplified cost model for a representative 1.8M AED flat purchase, illustrating total cost of ownership over a 10-year holding period. This is for reference only and does not account for individual tax situations, service charges above the estimate, or rental income offsets.
Assumptions:
- Property price: AED 1,800,000
- Down payment: 20%
- Loan fees and DLD transfer: approximately 7.7% of property value
- Loan term: 5 years at 4.5% annual interest
- Annual running cost (service charge, maintenance): AED 30,000
- Holding period: 10 years
Down payment + fees: AED 498,600 Loan amount: AED 1,440,000 Monthly repayment: AED 26,846 Total repaid (5 yr loan): AED 1,610,757 Total interest paid: AED 170,757 Total running costs: AED 300,000 Total cost of ownership: AED 969,357
Notes:
- All yields are gross rental yields estimated from Ejari new contracts and DLD sales transactions.
- Net yields would be lower after service charges, management fees, and vacancy periods.
- The 10-year projection uses a mean-reversion assumption and should be treated as illustrative.
- Data covers the period January 2014 to July 2024.