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

Reynosa
Pharr Bridge

RE09

1st Generation
 
88,005 (SF)
Class A
Monterrey
Escobedo

Escobedo B1

1st Generation
 
218,003 (SF)
Class A
Merida
East

Cima L138-141

1st Generation
 
86,111 (SF)
Class B
Tijuana
Otay

Logotek

2nd Generation
 
60,248 (SF)
Class C
Reynosa
Pharr Bridge

REY 029

2nd Generation
 
67,502 (SF)
Class B
Mexico City
Cuautitlan

Puente Mexico 6

2nd Generation
 
131,665 (SF)
Class A
Tijuana
Rosarito

Aqua

1st Generation
 
44,996 (SF)
Class A
Queretaro
North

PIQ Spec IV

2nd Generation
 
49,439 (SF)
Class A