Contact us
SELECT file from gallery where cartella='P333' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Poltroncina Perseo
With its soft and natural design, this armchair in baroque style gives life to warm and welcoming environments inspired by the sweet harmonies of tradition. With meticulously carved legs and sinuous and elegant shapes, the Perseo armchair is a real gem for the home. The armchair is upholstered and upholstered with a fabric of two different colors between seat and back, it is possible to cover with other colors of fabrics on request in addition to Green and Sugar Paper.
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 <> '333'
and t1.flag4=1
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;