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
- Universe: every transaction in DLD transaction group Sales with a valid registration date
(
q_date_ok). This includes all Sales-group procedures: Sell, Sell - Pre registration, Delayed Sell, Lease to Own Registration, Sale On Payment Plan and developer-level procedures (Development Registration, Sell Development and similar). n= number of transactions;value_aed= sum ofactual_worth;avg_price_aed= mean price of rows that pass the price check (price >= AED 10,000).- Dimensions:
all;registration(Title Deed = "Existing Properties", mostly ready property; Oqood = off-plan pre-registration). Title Deed is not the same as a completed home: DLD issues a title deed for houses it registers on their plot (type Land) while the project is still under construction. In the 12 months to October 2026, 7,366 such plot-registered house sales (inclusion = land_in_villa_projectin the enriched basis, without the bulk plot registrations described in (b)) are all Title Deed; by the linked project's register status 4,333 are ACTIVE, 618 NOT_STARTED and 2,393 FINISHED (22 have no project link in the projects register snapshot of 2026-11-01). In October 2026 all 1,221 Land sales were Title Deed. The residential series therefore also carry amarketdimension (Ready / Off-plan, below). Other dimensions:usagegrouped as Residential, Commercial, Hospitality, Other (Other = Industrial, Multi-Use, Agricultural, Storage, Residential / Commercial, Other and blanks);segment(Apartment, Villa, Land, Building, Office, Shop, Hotel Apartment, Other as defined in staging);procedure(DLD procedure name);usage_registration. - Note: a Lease to Own registration creates one row in the Sales group and a separate row in the Mortgages group; only the Sales row is counted here.
(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:
- 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).
- 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:
- Plot match. DLD records the plot area as the procedure area of a house sale. The sale is matched to villa records in the register of the same project (tier 1) or, if there is none, the same master project (tier 2), whose plot area is within 1 m² of the sale's area.
- Villa or townhouse (
segment_imputed). A project whose name says TOWNHOUSE(S) decides first: its houses are townhouses. Otherwise a register record counts as a townhouse when 2 to 20 houses share one land parcel (attached row or semi-detached houses) and its built-up area is below 3,500 sq ft (clustered detached villas also share a parcel). Where a house has its own parcel, a whole cluster sits on one master parcel (more than 20 houses), or the house is larger, a plot smaller than 3,000 sq ft counts as a townhouse and a larger plot as a villa. A sale is a townhouse when at least half of its matched register records are townhouses. Without a plot match the project's townhouse share is used if it is clear (>= 90% or <= 10%), otherwise the sale's own plot area with the 3,000 sq ft rule. DLD stacked townhouses (Unit + Stacked Townhouses) are townhouses. (The 3,500 sq ft limit and the name rule were adopted on 7 October 2026; before, the shared-parcel rule applied at any size, and 379 "townhouses" of the 12 months to September 2026 had a built-up area of 4,500 sq ft or more, among them all of Chorisia 2 Villas and Villa Amalfi. With the new rule 57 remain in the 12 months to October 2026.) - Market (
market, Ready / Off-plan). Oqood sales are Off-plan. A house registered on its plot (type Land, always Title Deed) is Ready only when its DLD project is FINISHED with a completion date on or before the sale date (DLD projects register); otherwise it is Off-plan, and so is a house in a project numbered above the highest project number in the register (launched after the register snapshot). Plot-registered houses whose project is missing from the register are "Not determined". All other Title Deed sales are Ready. In the 12 months to October 2026, of 7,366 plot-registered house sales 2,103 are Ready, 5,241 Off-plan and 22 Not determined. - Bedrooms (
bedroomsdimension, enriched basis). DLD bedrooms are kept where reported. Otherwise the most common bedroom count among the matched register records is used, then the project's most common bedroom count, then the master project's. Ties go to the smaller count. Remaining cases are "Unknown". - Built-up area (
*_bua_estcolumns). Apartments and DLD stacked townhouses use the DLD unit area. Other houses use the median built-up area of the matched register records, else the project median. Houses with no estimate are left out of the BUA columns (seen_bua).
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:
- price bands (AED): <0.5M, 0.5-1M, 1-2M, 2-3M, 3-5M, 5-10M, 10-20M, 20M+ (lower bound included);
- built-up size bands (sq ft): <500, 500-750, 750-1,000, 1,000-1,500, 1,500-2,000, 2,000-3,000, 3,000-5,000, 5,000+; houses without a built-up estimate are "Unknown";
- bedrooms (Studio, 1 to 6, 7+, Unknown), registration (Title Deed / Oqood) and market (Ready / Off-plan / Not determined).
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.
- Sale universe and community. Exactly the price index's (
price_index.build_base, seeprice_index.md): sale procedures of one home (Sell, Delayed Sell, pre-registration, lease-to-own and development sale procedures), residential apartments, villas and townhouses, house sales that DLD registers on the plot inside villa projects (without bulk plot registrations, see (b)), price per sq ft between AED 100 and 50,000 on the recorded area. The community is the price index's community name, so the names are those ofdata/out/price_index/community_map.csv.level = dubairows (communityDubai) pool all communities. - Type.
Apartment;Villa= all houses, villas and townhouses together (DLD does not separate them reliably);All= both. - Market.
Ready= title-deed sales plus plot-registered houses whose DLD project was finished by the sale date;Off-plan= Oqood sales plus plot-registered houses in projects still under construction;All= every sale, including plot-registered houses whose project is missing from the register (market not determined). - Window (complete calendar months only, from
scripts/common/period.py; every window ends with the latest complete month):l1= the latest complete month;l3,l6,l12,l24= the last 3, 6, 12 and 24 complete months;ytd= January to the latest complete month of the same year. In this build (latest complete month October 2026):l12026-10,l32026-08 to 2026-10,l62026-05 to 2026-10,ytd2026-01 to 2026-10,l122025-11 to 2026-10,l242024-11 to 2026-10.period_startandperiod_endgive the first and last month (YYYY-MM). The site's community table lets the reader choose the window; it reads the published cells of this table fromsite/data/price_index.json(periods). - Columns.
n_sales: number of sales in the cell;median_price_aed: median sale price of those sales, rounded to AED 1,000.median_aed_sqft: median price per sq ft on the price-index headline basis: apartments on the DLD unit area, villas on the estimated built-up area (the price index'sBuilt-up area (est.)basis; villa sales without a usable built-up estimate are left out of this statistic), typeAllon both. It is taken after the price index's outlier rule: sales whose log price per sq ft lies more than 1.5 interquartile ranges outside the middle half of the cell are left out.n_psfis the number of sales used. For windowl3the median andn_psfare identical to the price index's latest 3-month median (community_index_latest,median_aed_sqftandn_sales, apartments onDLD area, villas onBuilt-up area (est.); Dubai rows:dubai_index_monthly); the hand-off export checks this.offplan_share_pct: off-plan sales as a share of all sales of the same level, community, type and window (the same value on the three market rows).area_basis: the area basis ofmedian_aed_sqft.
- Thresholds. A cell with fewer than 5 sales is suppressed (
suppressed = true; count, prices and share are null). Cells with 5 to 29 sales are published and flaggedlow_sample = true; the same rule onn_psfgivespsf_low_sample(the median AED/sq ft is null below 5). The off-plan share is null when the group has fewer than 5 sales or when its off-plan sales or its other sales number 1 to 4, because the share would reveal a small count. Only cells with sales appear: a missing row means no sale in that cell. - What it is not. Medians are not quality-adjusted: a change between windows partly reflects which homes sold. The
smoothed index level and its changes are in the price index tables. No project-level sales are published here, so
the rule for projects named after a developer brand (
00-publication-compliance.md, section 4) does not apply.
Caveats
- Counts follow DLD registration dates, not contract dates. DLD may add or correct records after publication, so recent months can change slightly when data are refreshed.
- The enriched basis relies on the current buildings register, applied to the whole history. Projects that were renamed or re-registered may be matched less well in early years.
- Developer-level procedures (e.g. Development Registration) are included in all counts. They are a few percent
of residential sales in a typical month and can be seen per procedure in
city_monthly. - Only primary suppression is applied: a suppressed category can sometimes be derived by subtracting the other categories from a total.
- Prices are as registered (
actual_worth); no outlier trimming is applied, so means and weighted averages can be moved by single very large sales. Medians are more robust.