Dld Search Transactions
dld_search_transactionsDubai property transactions (sales, mortgages and gifts) registered with the Dubai Land Department, with transaction value, procedure, area/district, project, property type, room count and nearest metro/mall/landmark. Coverage is the current calendar year — earlier years come back empty. A date range is required.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | Sort as "<COLUMN>_ASC" or "<COLUMN>_DESC" using a column name from the rows, e.g. "TRANS_VALUE_DESC". Omit for the upstream default order. | |
| limit | No | Rows to return, 1-200 (default 25) | |
| usage | No | Property usage: "1" Residential, "2" Commercial, "3" Other. Omit for all. | |
| offset | No | Rows to skip, for paging through `total` (default 0) | |
| to_date | Yes | End of the range, ISO date e.g. "2026-09-06" | |
| off_plan | No | "1" off-plan only, "0" ready only | |
| free_hold | No | "1" freehold only, "0" non-freehold only | |
| from_date | Yes | Start of the range, ISO date e.g. "2026-09-01" | |
| include_arabic | No | Keep the Arabic (`*_AR`) twin of each bilingual column. Default false. | |
| property_type_id | No | Upstream property-type id, as seen in PROPERTY_TYPE_ID | |
| transaction_type | No | Group: "1" Sales, "2" Mortgages, "3" Gifts. Omit for all. |