Contact us
SELECT file from gallery where cartella='P519' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Madiastrana
The cupboard collection combines the antique style of the furniture tradition with the modern aesthetic and marked taste of a luxury piece of furniture. The quality of Made in Italy has always been a characteristic of renowned quality both in the materials, both in the finishes and in the composition of the furniture. The peculiarity of the decorations of these sideboards makes them an original and distinctive piece of furniture, thanks also to the use of different finishes, the sideboard fits perfectly in every room.
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 <> '519'
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;
