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 2026

445

Exisiting land site 34,522 HA

106

Land fully developed 9,145 HA

241

Land undeveloped 14,696 HA

RECENT PROPERTIES

Tijuana
La Mesa

VPRU 02

2nd Generation
 
46,174 (SF)
Class B
Reynosa
West

REX01

2nd Generation
 
36,505 (SF)
Class B
Mexicali
North

MXL 004

2nd Generation
 
32,572 (SF)
Class B
Monterrey
Apodaca

AP11

1st Generation
 
146,579 (SF)
Class A
Tijuana
Florido

Aliah Encinos

1st Generation
 
381,196 (SF)
Class A
Tijuana
Florido

Poza de Encino

2nd Generation
 
75,347 (SF)
Class A
Tijuana
Florido

Encino Spec I

1st Generation
 
222,422 (SF)
Class A
Hermosillo
East

Lanix

2nd Generation
 
137,500 (SF)
Class B