SELECT SUM(IF(A.land_size IS NULL, 0 , A.land_size)) existencia, COUNT(*) existenciaC, SUM(IF(A.land_size IS NULL, 0 , IF(A.land_condition = 'Fully Developed' OR A.land_condition = 'Fully Developer', A.land_size, 0))) f_deleveloped, SUM(IF(A.land_size IS NULL, 0 , IF(A.land_condition = 'Fully Developed' OR A.land_condition = 'Fully Developer', 1, 0))) f_delevelopedC, SUM(IF(A.land_size IS NULL, 0 , IF(A.land_condition = 'Undeveloped', A.land_size, 0))) undeveloped, SUM(IF(A.land_size IS NULL, 0 , IF(A.land_condition = 'Undeveloped', 1, 0))) undevelopedC FROM proy_land_available A LEFT JOIN proy_industrial_park E ON A.industrial_park = E.id LEFT JOIN proy_developer G ON A.owner = G.id LEFT JOIN proy_developer H ON A.developer = H.id LEFT JOIN proy_categoria B ON A.market = B.id LEFT JOIN proy_categoria C ON A.sub_market = C.id LEFT JOIN proy_catalogo_detalle D ON A.region = D.id WHERE 1=1

AVAILABLE LAND 2025

445

Exisiting land site 34,522 HA

106

Land fully developed 9,145 HA

241

Land undeveloped 14,696 HA

RECENT PROPERTIES

Tijuana
Libramiento

Banderas II

1st Generation
 
62,130 (SF)
Class A
Reynosa
West

RE05A

2nd Generation
 
74,000 (SF)
Class A
Monterrey
Santa Catarina

GA 04

1st Generation
 
192,231 (SF)
Class A
Tijuana
Florido

Hines B2

1st Generation
 
234,513 (SF)
Class A
Tijuana
Libramiento

VPA 07

2nd Generation
 
35,376 (SF)
Class B
Tijuana
Libramiento

Cuesta Blanca I

2nd Generation
 
31,317 (SF)
Class C
Juarez
East

Finsa II

1st Generation
 
234,650 (SF)
Class A
Tijuana
Otay

Alliuz Alamar A

1st Generation
 
199,584 (SF)
Class A