SELECT p.*, pl.link_rewrite, pl.name, pl.description_short, (image_shop.id_image) id_image FROM ps_product p LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product AND pl.id_lang = 1 LEFT JOIN ps_image_shop image_shop ON (image_shop.id_product = p.id_product AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN ps_image_lang il ON (image_shop.id_image = il.id_image AND il.id_lang = 1) WHERE p.active = 1 AND pl.name != "Piso en Barrio Salamanca" AND id_category_default = 116 AND image_shop.id_image IS NOT NULL ORDER by rand() LIMIT 3
Piso en barrio salamanca | BATAVIA

Piso en Barrio Salamanca

Proyecto de arquitectura e interiorismo: Estudio Lucas y Hernández-Gil

Mobiliario: BATAVIA

Fotografías: Adriana Merlo / BATAVIA

PIDA INFORMACIÓN

+ 34 91 594 2233