Contact us
SELECT file from gallery where cartella='P318' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Poltrona Patch Bicolor
Armchair upholstered in Patchwork style fabric with a resistant base in solid dark wood. Able to give color and liveliness to your home, this armchair is considered a separate piece for this well suited to any environment and style. Playful with refined shapes, eccentric but elegant, the Patch armchair is perfect for those who want to animate their living space. It is ergonomic and the shape of the chair welcomes the person giving a feeling of comfort and well-being.
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 <> '318'
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;
