Frontera Informativa

Casas / Venta

  1. Inicio
  2. Casas
  3. Venta
cPHGAYhmLXwP8nVoJu3A.PNG

Edificio en obra negra y Gris, Granjas del Márquez, Acapulco, Guerrero

Agente: Elena Del Angel
Octubre 25, 2019
6571
Las Moras o de La Granja No. 90, Fracc. Granjas del Márquez, Lote de terreno No. 4, Acapulco de Juárez, Guerrero, 39890

Edificio en obra negra y gris con 9 niveles y 1 departamento en un solo prototipopor piso, sótano con espacio para 9 cajones de estacionamiento

UBICACIÓN

C. Las Moras o de La Granja No. 90 Lote de terreno No. 4 Fracc. Granjas del Márquez, Acapulco, Guerrero a menos de 550 Mts. de la playa más cercana.

La zona de influencia es de tipo residencial plus y comercial de primer nivel, encontrándose en el llamado Acapulco Diamante.

USO DE SUELO

Habitacional. T240/80 COS 20% CUS 1.5

Cuenta catastral: 042-009-004-0000

A menos de 50 mts. Sobre los lotes número 31, 32 y 33 se están llevando acabo las construcciones de una casa habitación y un edificio de departamentos dentro del mismo fraccionamiento.

uV5xJGLQlT58JruMMwU6.png

Elena Del Angel

Informes: (899) 186-6350

Ver Facebook

oNhzkVcMLXLt9RZ9um8d.jpg

Oportunidad: Local comercial en Amplicaión Longoria

Reynosa, Tamaulipas
Marzo 23, 2023
2876
There are no log entries.
Time Query
7.12ms 
SELECT * FROM `bienes` WHERE `id` = '80' LIMIT 1
10.78ms 
SELECT * FROM `estatus` WHERE `id` IN ('0')
11.16ms 
UPDATE `bienes` SET `viewed` = '6571', `updated_at` = '2026-03-23 22:30:30' WHERE `id` = '80'
7.22ms 
SELECT *, MATCH(`name`,`summary`,`content`) AGAINST ("Edificio en obra negra y Gris, Granjas del Márquez, Acapulco, Guerrero") AS score FROM `bienes` WHERE (MATCH(`name`,`summary`,`content`) AGAINST ("Edificio en obra negra y Gris, Granjas del Márquez, Acapulco, Guerrero")) AND `published` = '1' AND `filename` != '' AND `id` != '80' AND DATE(created_at) >= CURDATE() - INTERVAL 1 MONTH ORDER BY `score` DESC LIMIT 3
11.76ms 
SELECT * FROM `agentes` WHERE `id` = '1' LIMIT 1
11.83ms 
SELECT * FROM `categories` WHERE `published` = '1' ORDER BY `order` ASC
11.02ms 
SELECT * FROM `subcategories` WHERE `category_id` IN ('2', '4', '3', '5', '8', '6') AND (`published` = '1') ORDER BY `name` ASC
13.77ms 
SELECT * FROM `website` WHERE `id` = '1' LIMIT 1
590.38ms 
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
2.74ms 
SELECT * FROM `authors` WHERE `id` IN ('5', '1')
0.45ms 
SELECT * FROM `categories` WHERE `id` IN ('6', '8', '2', '3', '1')
0.84ms 
SELECT * FROM `subcategories` WHERE `id` IN ('16', '44', '45', '39', '7', '38', '27', '25')
490.19ms 
SELECT * FROM `contents` WHERE `published` = '1' AND `filename` != '' ORDER BY `created_at` DESC LIMIT 10
0.16ms 
SELECT * FROM `authors` WHERE `id` IN ('1')
0.10ms 
SELECT * FROM `categories` WHERE `id` IN ('8', '4', '2', '3', '1')
0.14ms 
SELECT * FROM `subcategories` WHERE `id` IN ('39', '21', '30', '45', '7', '27', '38', '8')
0.18ms 
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.92ms 
SELECT * FROM `municipios` WHERE `id` = '367' LIMIT 1
0.78ms 
SELECT * FROM `estados` WHERE `id` = '12' LIMIT 1
1.69ms 
SELECT * FROM `advertising` WHERE `published` = '1' AND `filename2` != '' ORDER BY RAND() ASC LIMIT 5
5.43ms 
SELECT * FROM `bienes` WHERE `published` = '1' AND `filename` != '' ORDER BY RAND() ASC LIMIT 6
1.65ms 
SELECT * FROM `municipios` WHERE `id` IN ('2010', '965', '367')
0.44ms 
SELECT * FROM `estados` WHERE `id` IN ('12', '19', '28')
0.09ms 
SELECT * FROM `agentes` WHERE `id` IN ('1')
1.54ms 
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.