PRODUCTS
CHAIR / Velvet / Black
Theme - Amethyst
ID: 641
Category: Furniture
Material: Textile
Production: Industrial
Measures:
Description:
RELATED PRODUCT
- 13->SELECT `articulos`.`ART_ID` AS `ART_ID`, `articulos`.`ART_TEMA` AS `ART_TEMA`, `articulos`.`ART_CATEGORIA` AS `ART_CATEGORIA`, `articulos`.`ART_COLOR` AS `ART_COLOR`, `articulos`.`ART_TITULO` AS `ART_TITULO`, `articulos`.`ART_IMAGENSM` AS `ART_IMAGENSM`, `tema`.`TMA_NOMBRE` AS `TMA_NOMBRE` FROM (`articulos` join `tema`) WHERE `articulos`.`ART_PUBLICATION` = 2 AND `articulos`.`ART_TEMA` = `tema`.`TMA_ID` AND `tema`.`TMA_PUBLICATION` = 2 AND ART_TEMA!=1 AND ART_CATEGORIA=3
Address
Margarita Maza de Juárez No.1322-1
Col Centro. San José del Cabo, B.C.S. México.
Cabo Rental Decor © 2018