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.

Sales market statistics (module sales_market)

Script: scripts/modules/sales_market.py (re-runnable, byte-identical output on re-run). Source: Dubai Land Department (DLD) open data via data.dubai, Dubai Open Data Licence. Inputs are the staging tables described in 00-staging.md: transactions, buildings_raw (DLD buildings register). Nothing else is used. Data run to 2026-11-05; the latest complete month is October 2026. Series start in January 2008.

Outputs

File (data/out/sales_market/) Grain Content
city_monthly month x dimension x category All DLD "Sales" transactions: count, value, average price
residential_monthly month x basis x dimension x category Residential sales by segment, bedrooms, registration
area_monthly month x DLD area x segment group Residential summary per DLD area
master_project_monthly month x master project x segment group Residential summary per master project
mix_latest dimension x segment x band (October 2026) Price-band, size-band, bedroom and registration mix
community_period level (Dubai / community) x community x type x market x window Sales count, median price, median AED/sq ft on the price-index basis, off-plan share for the last 1, 3, 6, 12 and 24 complete months and the year to date

Each file is published as .parquet and .csv. The site file site/data/sales_market.json is a compact subset (city series, enriched residential series by segment and bedrooms, latest month per area with a 12-month trend, latest-month mixes). AED values in the site file are in AED millions where the field ends in _m.

(a) City series: city_monthly

(b) Residential series: residential_monthly

Residential universe: Sales group, valid date, price >= AED 10,000, area between 100 and 2,000,000 sq ft. Hotel apartments (usage Hospitality) are not residential here.

Two bases are published side by side (column basis):

dld_reported uses the DLD fields as published: usage Residential and segment Apartment (Unit + Flat), Villa (property type Villa) or stacked townhouse. DLD does not separate villas from townhouses, so the house category is called "Villa (all houses)". Bedrooms are as reported (rooms_en); villas often have no bedroom value.

enriched (an estimate) corrects two known gaps in the DLD classification using only DLD open data:

  1. Houses sold as Land. In many villa and townhouse communities, especially off-plan, DLD registers the sale with property type Land and the plot area. Such a sale is added when its project's entry in the DLD buildings register consists of villa records (at least 80% of the project's register records have sub type Villa). Land sales with usage Industrial, Agricultural or Storage are never added. Land sales in projects with no or mixed register entries stay out (they are real land plots or cannot be told apart).
  2. Houses with a non-residential usage label. Villa sales with a usage other than Residential, Industrial, Agricultural or Storage (in practice Commercial, Multi-Use or Other) are added when the project is a villa project in the register or the sale has a master project (master-planned community). Industrial, Agricultural and Storage usages are never added. Villa sales with no master project and no villa-project match (mostly older villas on commercial plots) stay out.

Bulk plot registrations are left out (rule of 9 November 2026). Some Land records in villa projects are not house sales but many plots of one project registered on one day. A Land sale added under rule 1 is left out when it belongs to a batch of the same DLD project on the same day that has (a) at least 5 records, at least half of them with no buyer (DLD no_of_parties_role_2 = 0; in off-plan sales by developers the field is 1 or more in 99.99% of records), or (b) at least 100 records whose median plot area is more than twice the project's median villa plot in the buildings register (parcels that each hold several houses; a back-up for (a)). Batch size or project status alone is not used: ordinary launches register up to 160 house sales of one project on one day, and many projects register their first house sales before their official start date. Over January 2008 – October 2026 the rule removes 1,350 records in 10 batches: 13 in Me'Aisem First (April 2019) and 121 in Madinat Al Mataar (November 2023, December 2025, February 2026), plots at nominal prices of USD 5–28 (AED 19–103) per sq ft; 693 in Al Yelayiss 1 (January and July 2025), plots that were then sold again one by one at house prices of about USD 0.68M (AED 2.5M); and 523 in Al Rowaiyah First on 2 October 2026, parcels with a median of 480 m² against 187 m² for a house plot in the register, in a project whose houses are sold off-plan through Oqood. In 2024–2026 only five months change: January 2025 (−672 sales, −USD 276M / AED 1,012M), July 2025 (−21), December 2025 (−24), February 2026 (−18) and October 2026. The records stay in the city series (city_monthly), so DLD-reported totals do not change; they leave the enriched residential series, the area and master-project tables, the mixes and, through the restricted imputation file, the price index and community_period; the commercial land table (commercial_market.md) leaves them out too. October 2026: residential sales 10,160 instead of 10,683 (−44.8% instead of −41.9% on October 2025); value USD 6.63bn (AED 24.35bn) instead of USD 7.08bn (AED 26.00bn); off-plan share 65.0% instead of 66.7%; villa (all houses) off-plan median for the month USD 432 (AED 1,587) per sq ft of built-up area on 1,002 sales instead of USD 370 (AED 1,360) on 1,536 (community_period, l1).

For every house in the enriched basis the script then looks up the DLD buildings register:

Agreement check (not a hold-out): for villa sales where DLD does report bedrooms, the plot-match bedroom value agrees with DLD in 94.6% of 106,840 checked sales (99.3% within one bedroom). The checked sales are not like the imputed ones (more off-plan sales, more unanimous plot matches), so the accuracy per stratum (match tier x number of matched register records x whether all matched records agree) is re-weighted to the 117,617 sales whose bedrooms are imputed by plot match: the expected accuracy on imputed sales is about 91% exact (90.6%) and 99% within one bedroom. By method: unanimous plot match 99.5% exact (73,598 imputed sales), plot-match mode 78.8% (44,019), project mode 70.5% (2,362), master-project mode 58.0% (907); over all 120,886 imputed sales about 90%. The figures are in site/data/sales_market.json (meta.imputation_check) and are recomputed on every build. Check of the villa/townhouse rule against project names: projects named "townhouses" are townhouses by rule; of house sales in projects named "villa(s)", about 60% are classed as townhouses, which is plausible because many such projects (Villanova, Warsan Village, Reportage Village) are townhouse communities. In October 2026 the enriched basis has 1,177 townhouse and 504 villa sales. The villa/townhouse split and the house built-up areas are still estimates.

Dimensions: all, segment (Apartment, Townhouse, Villa in enriched; Apartment, Villa (all houses) in dld_reported), segment_group (Apartment, Villa/Townhouse), bedrooms (Studio, 1 to 6, 7+, Unknown), segment_group_bedrooms, registration (enriched only), market and segment_group_market (enriched only; Ready, Off-plan, Not determined).

Columns:

Column Definition
n Number of sales
value_aed Sum of prices
avg_price_aed Mean price
avg_area_sqft Mean DLD procedure area (unit area for apartments, plot area for houses and house-plots)
wavg_aed_sqft Sum of prices / sum of DLD procedure area
median_aed_sqft Median of price / DLD procedure area
n_bua Sales with a built-up area (DLD unit area or register estimate between 100 and 100,000 sq ft); values 1 to 4 are shown as null and the BUA statistics are then null
avg_bua_sqft_est Mean built-up area (estimate for houses)
wavg_aed_sqft_bua_est Sum of prices / sum of built-up area, over the n_bua sales
median_aed_sqft_bua_est Median of price / built-up area, over the n_bua sales
suppressed True when n < 5; then all counts and statistics in the row are null

For houses, AED per sq ft on plot area and on built-up area differ a lot; read the column you need. The dld_reported basis has no built-up area for houses, so its BUA columns are empty.

(c) Areas and master projects: area_monthly, master_project_monthly

Enriched residential universe, per month and DLD area (area_name_en) or master project (master_project; sales without one are left out of that table). segment_group is All residential, Apartment or Villa/Townhouse. Columns: n, value_aed, avg_price_aed, median_aed_sqft (DLD procedure area), median_aed_sqft_bua_est, n_bua, n_added_by_enrichment (sales that come from the enrichment rules above), n_offplan (market Off-plan: Oqood plus plot-registered houses in unfinished projects), suppressed. Cells from fewer than 5 sales are null; n_bua, n_added_by_enrichment and n_offplan values between 1 and 4 are also shown as null (and median_aed_sqft_bua_est is null when n_bua is below 5). Master project names are DLD location labels.

(d) Latest-month mix: mix_latest

October 2026, enriched residential universe, for all residential and per segment:

Columns: n, value_aed, median_aed_sqft (DLD procedure area), share_pct of the segment's sales.

(e) Initial (developer) sale vs resale: not produced

The open transactions file has no seller type (developer or individual) and no property identifier, so a sale cannot be linked to an earlier sale of the same property, and a developer's first sale cannot be told apart from a resale. Off-plan (Oqood) is not the same as a developer sale: off-plan units are also resold before completion. We therefore publish the Title Deed / Oqood split and the per-procedure counts, and do not publish an initial/resale split.

(f) Community and period summary: community_period

The single source of the sales figures that the main website (wizipremium.com) takes over through the hand-off file (scripts/export_handoff.py, data/handoff/). One row per level x community x type x market x window.

Caveats