SELECT DISTINCT a.*, cs.title as property_status_name, concat(c2.title, "/", c.title) as property_category_name, cl.title as property_classification_name, ct.name as property_city_name, pt.name as property_province_name ,uc.name AS uEditor FROM `#__pm_properties` AS a LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__users AS created_by ON created_by.id = a.createdby LEFT JOIN #__users AS modified_by ON modified_by.id = a.modifiedby LEFT JOIN #__categories c on c.id = a.property_category LEFT JOIN #__categories cs on cs.id = a.property_status LEFT JOIN #__categories c2 on c2.id = c.parent_id LEFT JOIN #__categories cl on cl.id = a.property_classification LEFT JOIN #__pm_cities ct on ct.id = a.property_city LEFT JOIN #__pm_provinces pt on pt.id = a.property_province WHERE a.property_island_group = 1 AND (a.property_category = 25 OR a.property_category = 28) AND a.property_featured != 1 AND a.published = 1 ORDER BY a.id ASCArray ( [0] => stdClass Object ( [id] => 68 [property_name] => Unit #1 - 1188 sqm Warehouse for Lease in Cabuyao, Laguna [property_description] =>

Multi-Tenant Warehouse for Lease in Cabuyao, Laguna

✅ Floor Area: 1188 sqm

      ✅ Ground Floor: 840 sqm

      ✅ Mezzanine: 348 sqm

✅ Security Deposit: 3 months

✅ Advance Rental: 3 months (to be applied on the last term)

✅ Min. Lease Term: 3 years

✅ PEZA

 

[property_type] => 30 [property_category] => 25 [property_sub_category] => 0 [property_status] => 9 [property_classification] => ["106"] [property_block_num] => [property_lot_num] => [property_address] => Dr Park, Light Industries & Science Park [property_barangay] => 15 [property_city] => 28 [property_province] => 3 [property_country] => 0 [property_island_group] => 1 [property_price] => [property_room] => 0 [property_bathroom] => 0 [property_toilet] => 0 [property_toilet_bath] => 0 [property_lotarea] => 0 [property_floorarea] => 1188 [property_amenities] => [property_agent] => 0 [property_preselling] => 0 [property_developer] => 0 [property_parent] => 0 [property_latitude] => 14.23716653582579 [property_longitude] => 121.10216886106872 [property_meta_title] => Unit #1 - 1188 sqm Warehouse for Lease in Cabuyao, Laguna [property_meta_description] => Unit #1 - 1188 sqm Warehouse for Lease in Cabuyao, Laguna [property_meta_keywords] => 1188 sqm, Warehouse for Lease, Cabuyao, Laguna [created] => 2025-01-08 12:35:15 [createdby] => 714 [modified] => 2025-01-08 08:35:15 [modifiedby] => 714 [checked_out] => 0 [checked_out_time] => 0000-00-00 00:00:00 [published] => 1 [params] => [oid] => [project_id] => 0 [dist_to_airport] => 0 [dist_to_pier] => 0 [floorarea_category] => 44 [open_area] => 0 [clear_height] => 7.5 [property_featured] => 0 [property_building_age] => 2 [property_availability_date] => 0000-00-00 00:00:00 [property_lessor] => [apex_height] => 0 [floor_load_capacity] => 88 [tenancy_id] => 60 [power_supply_id] => 103 [allowable_use_id] => ["65"] [building_const_year] => 2023 [listing_source_id] => 63 [listing_id] => CAB001 [listing_id_raw] => 1 [property_status_name] => Available [property_category_name] => ROOT/PEZA [property_classification_name] => [property_city_name] => Cabuyao [property_province_name] => Laguna [uEditor] => [slug] => unit-1-1188-sqm-warehouse-for-lease-in-cabuyao-laguna ) [1] => stdClass Object ( [id] => 69 [property_name] => Unit #4 - 1449 sqm Warehouse for Lease in Cabuyao, Laguna [property_description] =>

Multi-Tenant Warehouse for Lease in Cabuyao, Laguna

✅ Floor Area: 1449 sqm

      ✅ Ground Floor: 945 sqm

      ✅ Mezzanine: 504 sqm

✅ Security Deposit: 3 months

✅ Advance Rental: 3 months (to be applied on the last term)

✅ Min. Lease Term: 3 years

✅ PEZA

 

[property_type] => 30 [property_category] => 25 [property_sub_category] => 0 [property_status] => 9 [property_classification] => ["106"] [property_block_num] => [property_lot_num] => [property_address] => Dr Park, Light Industries & Science Park [property_barangay] => 15 [property_city] => 28 [property_province] => 3 [property_country] => 0 [property_island_group] => 1 [property_price] => [property_room] => 0 [property_bathroom] => 0 [property_toilet] => 0 [property_toilet_bath] => 0 [property_lotarea] => 0 [property_floorarea] => 1449 [property_amenities] => [property_agent] => 0 [property_preselling] => 0 [property_developer] => 0 [property_parent] => 0 [property_latitude] => 14.2403799 [property_longitude] => 121.1078015 [property_meta_title] => Unit #4 - 1449 sqm Warehouse for Lease in Cabuyao, Laguna [property_meta_description] => Unit #4 - 1449 sqm Warehouse for Lease in Cabuyao, Laguna [property_meta_keywords] => 1449 sqm, Warehouse for Lease, Cabuyao, Laguna [created] => 2025-01-08 12:35:15 [createdby] => 714 [modified] => 2025-01-11 07:08:04 [modifiedby] => 714 [checked_out] => 0 [checked_out_time] => 0000-00-00 00:00:00 [published] => 1 [params] => [oid] => [project_id] => 0 [dist_to_airport] => 0 [dist_to_pier] => 0 [floorarea_category] => 44 [open_area] => 0 [clear_height] => 7.5 [property_featured] => 0 [property_building_age] => 2 [property_availability_date] => 0000-00-00 00:00:00 [property_lessor] => 2 [apex_height] => 0 [floor_load_capacity] => 88 [tenancy_id] => 60 [power_supply_id] => 103 [allowable_use_id] => ["65"] [building_const_year] => 2023 [listing_source_id] => 63 [listing_id] => CAB002 [listing_id_raw] => 2 [property_status_name] => Available [property_category_name] => ROOT/PEZA [property_classification_name] => [property_city_name] => Cabuyao [property_province_name] => Laguna [uEditor] => [slug] => unit-4-1449-sqm-warehouse-for-lease-in-cabuyao-laguna ) [2] => stdClass Object ( [id] => 70 [property_name] => Unit #6 - 1260 sqm Warehouse for Lease in Cabuyao, Laguna [property_description] =>

Multi-Tenant Warehouse for Lease in Cabuyao, Laguna

✅ Floor Area: 1260 sqm

      ✅ Ground Floor: 836 sqm

      ✅ Mezzanine: 374 sqm

✅ Security Deposit: 3 months

✅ Advance Rental: 3 months (to be applied on the last term)

✅ Min. Lease Term: 3 years

✅ PEZA

 

[property_type] => 30 [property_category] => 25 [property_sub_category] => 0 [property_status] => 9 [property_classification] => ["106"] [property_block_num] => [property_lot_num] => [property_address] => Dr Park, Light Industries & Science Park [property_barangay] => 15 [property_city] => 28 [property_province] => 3 [property_country] => 0 [property_island_group] => 1 [property_price] => [property_room] => 0 [property_bathroom] => 0 [property_toilet] => 0 [property_toilet_bath] => 0 [property_lotarea] => 0 [property_floorarea] => 1260 [property_amenities] => [property_agent] => 0 [property_preselling] => 0 [property_developer] => 0 [property_parent] => 0 [property_latitude] => 14.2403799 [property_longitude] => 121.1078015 [property_meta_title] => Unit #6 - 1260 sqm Warehouse for Lease in Cabuyao, Laguna [property_meta_description] => Unit #4 - 1260 sqm Warehouse for Lease in Cabuyao, Laguna [property_meta_keywords] => 1260 sqm, Warehouse for Lease, Cabuyao, Laguna [created] => 2025-01-08 12:35:15 [createdby] => 714 [modified] => 2025-01-11 07:11:11 [modifiedby] => 714 [checked_out] => 0 [checked_out_time] => 0000-00-00 00:00:00 [published] => 1 [params] => [oid] => [project_id] => 0 [dist_to_airport] => 0 [dist_to_pier] => 0 [floorarea_category] => 44 [open_area] => 0 [clear_height] => 7.5 [property_featured] => 0 [property_building_age] => 2 [property_availability_date] => 0000-00-00 00:00:00 [property_lessor] => 2 [apex_height] => 0 [floor_load_capacity] => 88 [tenancy_id] => 60 [power_supply_id] => 103 [allowable_use_id] => ["65"] [building_const_year] => 2023 [listing_source_id] => 63 [listing_id] => CAB003 [listing_id_raw] => 3 [property_status_name] => Available [property_category_name] => ROOT/PEZA [property_classification_name] => [property_city_name] => Cabuyao [property_province_name] => Laguna [uEditor] => [slug] => unit-6-1260-sqm-warehouse-for-lease-in-cabuyao-laguna ) )