Frontera Informativa

Terrenos / Venta

  1. Inicio
  2. Terrenos
  3. Venta
xYHkTNtOIdmcjSx2tCVm.png

TERRENOS FRACC. ROMANZA, NOGALES, SONORA

Agente: Elena Del Angel
Octubre 30, 2019
5539
Puerta de Anza, Puerta de Anza, Puerta de Anza, Nogales, Sonora,

Dos lotes de terreno en breña de forma regular, la superficie total de ambos lotes es 209,835.78 m2.

UBICACIÓN

Terrenos ubicados en Puerta de Anza, Nogales, Sonora que forman parte de un DUI con el mismo nombre.

USO DE SUELO

Habitacional, de alta densidad.

ADICIONALES

• Los inmuebles se encuentran dentro del plan DUI que se autorizó para la Ciudadde Nogales, cuenta con factibilidades vencidas de agua y CFE.

• Cuentas Catastrales: 5300B3120178 y 5300B3120484

• Localización Google Earth: https://earth.google.com/web/@31.31820004,-110.88643771,1248.3605909a,10711.54200694d,35y,0h,0t,0r

uV5xJGLQlT58JruMMwU6.png

Elena Del Angel

Informes: (899) 186-6350

Ver Facebook

kY9HKRb3PJZDasK1BGx1.jpg

Terreno en Venta Col Lampasitos ideal para inversión

Reynosa, Tamaulipas
Agosto 15, 2024
2585
There are no log entries.
Time Query
13.26ms 
SELECT * FROM `bienes` WHERE `id` = '87' LIMIT 1
8.03ms 
SELECT * FROM `estatus` WHERE `id` IN ('0')
1.29ms 
UPDATE `bienes` SET `viewed` = '5539', `updated_at` = '2026-03-23 22:30:43' WHERE `id` = '87'
3.64ms 
SELECT *, MATCH(`name`,`summary`,`content`) AGAINST ("TERRENOS FRACC. ROMANZA, NOGALES, SONORA") AS score FROM `bienes` WHERE (MATCH(`name`,`summary`,`content`) AGAINST ("TERRENOS FRACC. ROMANZA, NOGALES, SONORA")) AND `published` = '1' AND `filename` != '' AND `id` != '87' AND DATE(created_at) >= CURDATE() - INTERVAL 1 MONTH ORDER BY `score` DESC LIMIT 3
4.04ms 
SELECT * FROM `agentes` WHERE `id` = '1' LIMIT 1
4.09ms 
SELECT * FROM `categories` WHERE `published` = '1' ORDER BY `order` ASC
1.89ms 
SELECT * FROM `subcategories` WHERE `category_id` IN ('2', '4', '3', '5', '8', '6') AND (`published` = '1') ORDER BY `name` ASC
2.20ms 
SELECT * FROM `website` WHERE `id` = '1' LIMIT 1
981.28ms 
SELECT * FROM `contents` WHERE `published` = '1' AND `filename` != '' AND DATE(created_at) >= CURDATE() - INTERVAL 7 DAY ORDER BY `viewed` DESC, `created_at` DESC LIMIT 10
31.70ms 
SELECT * FROM `authors` WHERE `id` IN ('5', '1')
7.90ms 
SELECT * FROM `categories` WHERE `id` IN ('6', '8', '2', '3', '1')
5.86ms 
SELECT * FROM `subcategories` WHERE `id` IN ('16', '44', '45', '39', '7', '38', '27', '25')
700.65ms 
SELECT * FROM `contents` WHERE `published` = '1' AND `filename` != '' ORDER BY `created_at` DESC LIMIT 10
8.80ms 
SELECT * FROM `authors` WHERE `id` IN ('1')
4.06ms 
SELECT * FROM `categories` WHERE `id` IN ('8', '4', '2', '3', '1')
14.61ms 
SELECT * FROM `subcategories` WHERE `id` IN ('39', '21', '30', '45', '7', '27', '38', '8')
3.21ms 
SELECT * FROM `website` WHERE `id` = '1' LIMIT 1
10.50ms 
SELECT * FROM `categorias` WHERE `id` = '5' LIMIT 1
15.45ms 
SELECT * FROM `tipos` WHERE `id` = '2' LIMIT 1
5.81ms 
SELECT * FROM `municipios` WHERE `id` = '1932' LIMIT 1
1.15ms 
SELECT * FROM `estados` WHERE `id` = '26' LIMIT 1
2.53ms 
SELECT * FROM `advertising` WHERE `published` = '1' AND `filename2` != '' ORDER BY RAND() ASC LIMIT 5
14.05ms 
SELECT * FROM `bienes` WHERE `published` = '1' AND `filename` != '' ORDER BY RAND() ASC LIMIT 6
35.93ms 
SELECT * FROM `municipios` WHERE `id` IN ('2010', '1907', '1993', '2008')
29.06ms 
SELECT * FROM `estados` WHERE `id` IN ('26', '28')
3.45ms 
SELECT * FROM `agentes` WHERE `id` IN ('1')
2.83ms 
SELECT * FROM `advertising` WHERE `published` = '1' AND `filename1` != '' ORDER BY RAND() ASC LIMIT 1
11.05ms 
SELECT * FROM `photosizes` WHERE `id` = '3' LIMIT 1
There have been no checkpoints set.