Source: Dubai Land Department open data via data.dubai, Dubai Open Data Licence (licence text). Independent analysis by WIZI Premium, not affiliated with or endorsed by the Dubai Land Department, any government entity, developer, management company or data provider.

Mortgages and gifts (module mortgages_gifts)

Script: scripts/modules/mortgages_gifts.py (run from the project root; a few seconds). Source: Dubai Land Department (DLD) open data via data.dubai (Dubai Open Data Licence): the transactions file (dataset 470061), staged in data/staging.duckdb (see 00-staging.md). Nothing else is used. Data run to 2026-11-05; the latest complete month is October 2026.

What is counted

The DLD transactions file has three transaction groups: Sales, Mortgages and Gifts. The sales statistics of the site use the Sales group only. This module publishes the other two:

A record is counted in the month of its registration date. The amount is the value DLD records with the procedure (actual_worth): for a mortgage the amount registered with the mortgage (the loan or facility amount), for a gift the value declared for the gifted property. It is not a sale price. Amounts are used only when they pass the staging price check (at least AED 10,000).

The open data has no lender, borrower, donor or recipient, no interest rate or term, and no identifier that links a mortgage to the sale it finances, so loan-to-value ratios and the share of sales bought with a mortgage cannot be computed.

Procedure groups

Mortgage procedures are grouped by the words in their DLD names (first match wins; the full assignment is published in procedure_groups):

Group Procedures
Portfolio mortgage names containing "Portfolio" (one mortgage over several properties; amounts are large)
Lease to own / lease finance names containing "Lease" (lease-to-own and lease-finance registrations, modifications and transfers)
Development mortgage names containing "Development" (mortgages registered during development, including their modifications)
Mortgage modification names containing "Modif" (Modify Mortgage, Modify Delayed Mortgage and pre-registration forms)
Mortgage transfer names containing "Transfer"
New mortgage everything else: Mortgage Registration, Mortgage Pre-Registration (off-plan) and Delayed Mortgage

"New mortgage" is the headline series: a new mortgage over a property. Modifications and transfers change an existing mortgage (for example a refinance with another bank or a changed amount) and are shown separately.

A lease-to-own registration creates two records in the transactions file: one in the Sales group (counted in the sales statistics) and one in the Mortgages group (counted here, in the lease-to-own group). The two layers are never added up on the site.

Property segment

From the DLD property type of the record: Apartment (unit, flat), Villa / townhouse (villa, stacked townhouse), Land, and Other property (office, shop, hotel apartment, whole building, other). Mortgages over a whole building or a plot can cover many homes.

Published tables (data/out/mortgages_gifts/, each as .parquet and .csv)

File Grain Content
city_monthly month x layer x dimension x category n, value_aed (sum of amounts), median_amount_aed; dimensions all, procedure_group, segment (all procedures) and segment_new (new mortgages and gifts only)
community_latest community x layer (New mortgages, Gifts) x segment records in the last 12 complete months (n_12m) and the 12 months before (n_prev_12m), change_12m_pct, median_amount_aed
procedure_groups DLD procedure the group each procedure is assigned to and its all-time record count

site/data/mortgages_gifts.json holds the monthly series from January 2013, the community table and the procedure groups.

Community names come from the same resolver as the price index (price_index.md, community_map.csv), applied to the DLD area, master project, project and building of each record.

Suppression and changes

Caveats