Frontera Informativa

Casas / Venta

  1. Inicio
  2. Casas
  3. Venta
6QaFZm12c0BbXUyPDw8M.PNG

Lotes de Terreno Xochihuacan, Epazoyuca, Hidalgo

Agente: Elena Del Angel
Octubre 23, 2019
6316
Fraccionamiento Xochihuacán S/N, Fraccionamiento Xochihuacán, entre el Km 12 y 13, Carretera Pachuca-ciudad Sahagún, Epazoyucan, Hidalgo, 43580

112 Lotes De Terreno, 106 Con Construcción en Obra Negra Y 6 sin Construcción, en las manzanas 45, 46, 47 Y 48.

UBICACIÓN:

Fraccionamiento Xochihuacán S/N, entre el Km 12 y 13, Carretera Pachuca-Ciudad Sahagún, Epazoyucan, Hidalgo.

DETALLES ADICIONALES:

Los terrenos van desde los 90 M² (en su mayoría) hasta 175 M², las construcciones son Viviendas de 40.70 M² con avances de obra desde un 5%.

DETALLES:

Los lotes se encuentran dentro de la zona metropolitana de la Ciudad de Pachuca, se cuentan con licencias y factibilidades vencidas, la gran mayoría de los lotes tienen avance de obra mayor al 80%

LICENCIAS Y FACTIBILIDADES:

  • Licencia de construcción número 53, para 173 viviendas con 41.44 M2 de construcción (Tramitar Renovación)
  • Factibilidad de Agua Potable y Alcantarillado (Tramitar Renovación)
  • Precio Inicial $12,500,000.00 MN
uV5xJGLQlT58JruMMwU6.png

Elena Del Angel

Informes: (899) 186-6350

Ver Facebook

WcfsmzSDWSsdzG9AzQrx.jpeg

Rancho en venta, 23 hectáreas, cerca de la salidad a Monterrey

Reynosa, Tamaulipas
Septiembre 26, 2024
2242
There are no log entries.
Time Query
0.75ms 
SELECT * FROM `bienes` WHERE `id` = '74' LIMIT 1
0.15ms 
SELECT * FROM `estatus` WHERE `id` IN ('0')
8.34ms 
UPDATE `bienes` SET `viewed` = '6316', `updated_at` = '2026-03-23 20:57:12' WHERE `id` = '74'
17.77ms 
SELECT *, MATCH(`name`,`summary`,`content`) AGAINST ("Lotes de Terreno Xochihuacan, Epazoyuca, Hidalgo") AS score FROM `bienes` WHERE (MATCH(`name`,`summary`,`content`) AGAINST ("Lotes de Terreno Xochihuacan, Epazoyuca, Hidalgo")) AND `published` = '1' AND `filename` != '' AND `id` != '74' AND DATE(created_at) >= CURDATE() - INTERVAL 1 MONTH ORDER BY `score` DESC LIMIT 3
9.38ms 
SELECT * FROM `agentes` WHERE `id` = '1' LIMIT 1
1.00ms 
SELECT * FROM `categories` WHERE `published` = '1' ORDER BY `order` ASC
1.58ms 
SELECT * FROM `subcategories` WHERE `category_id` IN ('2', '4', '3', '5', '8', '6') AND (`published` = '1') ORDER BY `name` ASC
6.73ms 
SELECT * FROM `website` WHERE `id` = '1' LIMIT 1
467.98ms 
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
0.14ms 
SELECT * FROM `authors` WHERE `id` IN ('5', '1')
0.14ms 
SELECT * FROM `categories` WHERE `id` IN ('6', '8', '2', '3', '1')
0.13ms 
SELECT * FROM `subcategories` WHERE `id` IN ('16', '44', '45', '39', '7', '38', '27', '25')
0.26ms 
SELECT * FROM `contents` WHERE `published` = '1' AND `filename` != '' ORDER BY `created_at` DESC LIMIT 10
0.12ms 
SELECT * FROM `authors` WHERE `id` IN ('3', '1')
0.11ms 
SELECT * FROM `categories` WHERE `id` IN ('5', '8', '3', '1')
0.12ms 
SELECT * FROM `subcategories` WHERE `id` IN ('12', '22', '39', '63', '27', '9')
0.15ms 
SELECT * FROM `website` WHERE `id` = '1' LIMIT 1
0.11ms 
SELECT * FROM `categorias` WHERE `id` = '1' LIMIT 1
0.10ms 
SELECT * FROM `tipos` WHERE `id` = '2' LIMIT 1
0.45ms 
SELECT * FROM `municipios` WHERE `id` = '469' LIMIT 1
0.64ms 
SELECT * FROM `estados` WHERE `id` = '13' LIMIT 1
1.86ms 
SELECT * FROM `advertising` WHERE `published` = '1' AND `filename2` != '' ORDER BY RAND() ASC LIMIT 5
6.17ms 
SELECT * FROM `bienes` WHERE `published` = '1' AND `filename` != '' ORDER BY RAND() ASC LIMIT 6
0.12ms 
SELECT * FROM `municipios` WHERE `id` IN ('2010', '965')
0.14ms 
SELECT * FROM `estados` WHERE `id` IN ('19', '28')
0.09ms 
SELECT * FROM `agentes` WHERE `id` IN ('1')
1.90ms 
SELECT * FROM `advertising` WHERE `published` = '1' AND `filename1` != '' ORDER BY RAND() ASC LIMIT 1
0.11ms 
SELECT * FROM `photosizes` WHERE `id` = '3' LIMIT 1
There have been no checkpoints set.