Contact us
SELECT file from gallery where cartella='P497' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Sorriso
Simplicity and class come together to create elegant and classic windows. Thanks to the choice of wood, colors and shapes today we are able to materialize authentic works of art, capable of giving strong sensations and great visual impact. There are several proposals that surprise for the harmony of shapes and the refined study of design, as well as for the exemplary workmanship to which they are subjected. Each of our creations is still built with old standards that have always distinguished Italian furniture. The finishing is done with care using natural products such as wax and shellac.
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 <> '497'
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;
