Contact us
SELECT file from gallery where cartella='P926' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Living room enchanted woods
Modular living rooms provide a practical solution to the housing needs of anyone because they are designed to meet the lifestyle of today. Thanks to their modular structure, they adapt to every context and need: their versatility allows in fact to optimize the spaces improving their livability. To furnish the living area means to prefer the attention for the clean lines and for the symmetry of the spaces joining the practical needs with the aesthetic ones giving life to unique creations.
Related products
SELECT
t1.*,
t2.url_rw AS urlSC,
t2.url_rw_i AS urlSC_i,
t3.url_rw AS urlC,
t3.url_rw_i AS urlC_i
FROM prodotti AS t1
LEFT JOIN articoli AS t2 ON t2.id_art = t1.id_prec
LEFT JOIN articoli AS t3 ON t3.id_art = t2.id_prec
WHERE t1.tipo = '108'
AND t1.id_art <> '926'
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;
