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
Southeast

Prosperity Spec I

1st Generation
 
252,402 (SF)
Class A
Queretaro
North

SMA 07

2nd Generation
 
185,466 (SF)
Class A
Monterrey
Santa Catarina

SC 03

2nd Generation
 
193,798 (SF)
Class A
Mexico City
Toluca

Nave D

1st Generation
 
370,763 (SF)
Class A
Monterrey
Guadalupe

KG17 S3

2nd Generation
 
56,597 (SF)
Class A
Mexico City
Toluca

PPT III N3

1st Generation
 
291,198 (SF)
Class A
Mexico City
Last Mile

OD Vallejo E4

2nd Generation
 
76,801 (SF)
Class C
Nogales
East

Alamos

2nd Generation
 
18,566 (SF)
Class B