Enterprise data catalog & exploration
properties_master| Field Name | Type | Nullable | Description |
|---|---|---|---|
| property_id | VARCHAR(36) | NO | Unique UUID for each property listing |
| title_deed_no | VARCHAR(20) | NO | DLD title deed reference number |
| property_type | ENUM | NO | Apartment | Villa | Office | Retail | Warehouse |
| community | VARCHAR(100) | NO | Community / development name (e.g. Marina) |
| district | VARCHAR(50) | YES | Sub-district or zone |
| price_aed | DECIMAL(12,2) | NO | Listed price in UAE Dirhams |
| floor_area_sqft | DECIMAL(8,2) | NO | Total floor area in square feet |
| bedrooms | TINYINT | YES | Number of bedrooms (null for commercial) |
| ai_valuation_score | DECIMAL(5,2) | YES | PropIQ AI-generated valuation confidence score |
| created_at | TIMESTAMP | NO | Record creation timestamp (UTC) |
| ID | Address | Price | Beds | Area |
|---|---|---|---|---|
| PRO-00184 | 14A Marina Walk, Dubai Marina | AED 2,850,000 | 2 | 1,240 sqft |
| PRO-00219 | 32 Business Bay Blvd | AED 1,650,000 | 1 | 790 sqft |
| PRO-00312 | Palm Jumeirah, Frond K | AED 18,500,000 | 5 | 6,800 sqft |
| PRO-00445 | DIFC Gate Tower 3, Floor 22 | AED 4,200,000 | 3 | 2,100 sqft |
| PRO-00521 | Downtown, Burj Crown, Unit 1804 | AED 3,100,000 | 2 | 1,320 sqft |