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

Saltillo
Ramos Arizpe

M23

1st Generation
 
202,891 (SF)
Class A
Queretaro
North

Nave H

1st Generation
 
475,506 (SF)
Class A
Monterrey
Last Mile

Los Angeles

2nd Generation
 
94,938 (SF)
Class C
Juarez
Central

Gema I

2nd Generation
 
93,831 (SF)
Class B
Aguascalientes
West

VPAI 03

2nd Generation
 
50,397 (SF)
Class A
Guanajuato
Silao

EVRI

1st Generation
 
90,775 (SF)
Class A
Guadalajara
El Salto

Aliah A

1st Generation
 
211,012 (SF)
Class A
Mexico City
Huehuetoca

Prologis I

2nd Generation
 
126,389 (SF)
Class A