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

Juarez
South

JUA 045

1st Generation
 
266,826 (SF)
Class A
Tijuana
Otay

Uno Poniente

2nd Generation
 
61,409 (SF)
Class C
San Luis Potosi
Tres Naciones

PTN 10054

2nd Generation
 
90,761 (SF)
Class B
Saltillo
Derramadero

Derramadero V

1st Generation
 
115,140 (SF)
Class A
Monterrey
Apodaca

VAIP F

1st Generation
 
125,058 (SF)
Class A
Monterrey
Cienega de Flores

VNIP Spec A

1st Generation
 
361,562 (SF)
Class A
Saltillo
Ramos Arizpe

Kerr Industries

2nd Generation
 
36,516 (SF)
Class A
Saltillo
Ramos Arizpe

M24

1st Generation
 
202,891 (SF)
Class A