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

Guadalajara
El Salto

Advance Spec I

2nd Generation
 
22,862 (SF)
Class B
Monterrey
Cienega de Flores

MT02 Norte

1st Generation
 
137,500 (SF)
Class A
Tijuana
Otay

DMI Spec I

1st Generation
 
150,469 (SF)
Class A
Monterrey
Apodaca

AE 33 B

2nd Generation
 
16,964 (SF)
Class A
Tijuana
Florido

Musa 1

1st Generation
 
198,582 (SF)
Class A
La Laguna
Gomez Palacio

Viesca

2nd Generation
 
80,729 (SF)
Class B
Guanajuato
Silao

VGPI I Spec II

2nd Generation
 
44,442 (SF)
Class A
Mexicali
North

Sahuaro

2nd Generation
 
31,095 (SF)
Class B