Properties Table Structure
| Field | Type | Null | Key | Default |
|---|
| id | int(11) | NO | PRI | NULL |
| landlord_id | int(11) | NO | MUL | NULL |
| title | varchar(255) | NO | | NULL |
| description | text | YES | | NULL |
| address | text | NO | | NULL |
| city | varchar(100) | NO | | NULL |
| state | varchar(100) | YES | | NULL |
| postal_code | varchar(20) | YES | | NULL |
| country | varchar(100) | NO | | Ghana |
| property_type | enum('apartment','house','hostel','commercial','land','villa','townhouse','farmland') | NO | | NULL |
| total_rooms | int(11) | NO | | 0 |
| available_rooms | int(11) | NO | | 0 |
| latitude | decimal(10,8) | YES | | NULL |
| longitude | decimal(11,8) | YES | | NULL |
| status | enum('active','inactive','pending','suspended') | NO | | pending |
| verified | tinyint(1) | NO | | 0 |
| featured | tinyint(4) | NO | | 0 |
| verified_by | int(11) | YES | MUL | NULL |
| verified_at | timestamp | YES | | NULL |
| created_at | timestamp | NO | | current_timestamp() |
| updated_at | timestamp | NO | | current_timestamp() |
| land_size | decimal(10,2) | YES | | NULL |
| boundary_type | varchar(50) | YES | | NULL |
| zoning | varchar(100) | YES | | NULL |
| legal_status | varchar(100) | YES | | NULL |
Sample Property Data
Array
(
[0] => Array
(
[id] => 2
[landlord_id] => 3
[title] => Frankie Housing 1
[description] => Hello it my house
[address] => Sunyani Berlin Top
[city] => Sunyani
[state] => Bono Region
[postal_code] => 00233
[country] => Ghana
[property_type] => house
[total_rooms] => 5
[available_rooms] => 5
[latitude] => 7.33803270
[longitude] => -2.35489490
[status] => active
[verified] => 1
[featured] => 1
[verified_by] => 1
[verified_at] => 2025-05-20 10:36:55
[created_at] => 2025-05-19 21:39:24
[updated_at] => 2025-10-09 11:35:47
[land_size] =>
[boundary_type] =>
[zoning] =>
[legal_status] =>
)
[1] => Array
(
[id] => 4
[landlord_id] => 1
[title] => Waxtron Estates
[description] =>
[address] => Sunyani Berlin Top
[city] => Sunyani
[state] => Bono Region
[postal_code] => 00233
[country] => Ghana
[property_type] => apartment
[total_rooms] => 3
[available_rooms] => 3
[latitude] => 7.33803270
[longitude] => -2.35489490
[status] => active
[verified] => 0
[featured] => 1
[verified_by] =>
[verified_at] =>
[created_at] => 2025-05-20 23:12:59
[updated_at] => 2025-11-26 13:50:59
[land_size] =>
[boundary_type] =>
[zoning] =>
[legal_status] =>
)
[2] => Array
(
[id] => 13
[landlord_id] => 11
[title] => Peter K Properties
[description] => House selling at Sunyani Mantukwa
[address] => Mantukwa, Sunyani, Ghana
[city] => Mantukwa
[state] => Bono Region
[postal_code] =>
[country] => Ghana
[property_type] => house
[total_rooms] => 1
[available_rooms] => 0
[latitude] => 7.39257490
[longitude] => -2.37770370
[status] => active
[verified] => 0
[featured] => 0
[verified_by] =>
[verified_at] =>
[created_at] => 2026-01-07 21:21:22
[updated_at] => 2026-01-14 18:35:03
[land_size] =>
[boundary_type] =>
[zoning] =>
[legal_status] =>
)
)