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
Otay

MIS B002

2nd Generation
 
164,504 (SF)
Class B
Chihuahua
East

Casona Chihuahua

2nd Generation
 
43,163 (SF)
Class B
Reynosa
West

Finsa I VF

1st Generation
 
80,245 (SF)
Class A
Reynosa
West

REY 027

2nd Generation
 
31,161 (SF)
Class B
Monterrey
Apodaca

Finsa II Spec I

1st Generation
 
202,985 (SF)
Class A
Monterrey
Apodaca

Aros Apodaca 2

1st Generation
 
278,163 (SF)
Class A
Guadalajara
El Salto

PI B1

1st Generation
 
183,397 (SF)
Class A
Tijuana
Central

Leisner

2nd Generation
 
50,000 (SF)
Class C