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
6568
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

QRk9uJzPdxACw0vzVRUz.jpg

12.2 ha en venta en Monterrey, Nuevo León

García, Nuevo León
Abril 25, 2024
2206
There are no log entries.
Time Query
0.58ms 
SELECT * FROM `bienes` WHERE `id` = '80' LIMIT 1
3.02ms 
SELECT * FROM `estatus` WHERE `id` IN ('0')
10.79ms 
UPDATE `bienes` SET `viewed` = '6568', `updated_at` = '2026-03-23 20:55:10' WHERE `id` = '80'
2.44ms 
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
0.16ms 
SELECT * FROM `agentes` WHERE `id` = '1' LIMIT 1
0.16ms 
SELECT * FROM `categories` WHERE `published` = '1' ORDER BY `order` ASC
0.20ms 
SELECT * FROM `subcategories` WHERE `category_id` IN ('2', '4', '3', '5', '8', '6') AND (`published` = '1') ORDER BY `name` ASC
0.15ms 
SELECT * FROM `website` WHERE `id` = '1' LIMIT 1
598.48ms 
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
5.21ms 
SELECT * FROM `authors` WHERE `id` IN ('5', '1')
0.76ms 
SELECT * FROM `categories` WHERE `id` IN ('6', '8', '2', '3', '1')
11.16ms 
SELECT * FROM `subcategories` WHERE `id` IN ('16', '44', '45', '39', '7', '38', '27', '25')
517.55ms 
SELECT * FROM `contents` WHERE `published` = '1' AND `filename` != '' ORDER BY `created_at` DESC LIMIT 10
6.09ms 
SELECT * FROM `authors` WHERE `id` IN ('3', '1')
1.04ms 
SELECT * FROM `categories` WHERE `id` IN ('5', '8', '3', '1')
15.20ms 
SELECT * FROM `subcategories` WHERE `id` IN ('12', '22', '39', '63', '27', '9')
9.17ms 
SELECT * FROM `website` WHERE `id` = '1' LIMIT 1
11.12ms 
SELECT * FROM `categorias` WHERE `id` = '1' LIMIT 1
5.92ms 
SELECT * FROM `tipos` WHERE `id` = '2' LIMIT 1
10.93ms 
SELECT * FROM `municipios` WHERE `id` = '367' LIMIT 1
10.64ms 
SELECT * FROM `estados` WHERE `id` = '12' LIMIT 1
3.98ms 
SELECT * FROM `advertising` WHERE `published` = '1' AND `filename2` != '' ORDER BY RAND() ASC LIMIT 5
7.38ms 
SELECT * FROM `bienes` WHERE `published` = '1' AND `filename` != '' ORDER BY RAND() ASC LIMIT 6
2.41ms 
SELECT * FROM `municipios` WHERE `id` IN ('965', '1807', '2010')
0.73ms 
SELECT * FROM `estados` WHERE `id` IN ('19', '23', '28')
0.42ms 
SELECT * FROM `agentes` WHERE `id` IN ('1')
4.30ms 
SELECT * FROM `advertising` WHERE `published` = '1' AND `filename1` != '' ORDER BY RAND() ASC LIMIT 1
1.21ms 
SELECT * FROM `photosizes` WHERE `id` = '3' LIMIT 1
There have been no checkpoints set.