SELECT file from gallery where cartella='P657' and attivo=1 order by posizione,file
Spedizioni con corriere dedicato: Scopri di più
Possibilità di consegna rapida
Leggio
Arredi dallo stile classico si inseriscono con armonia all'interno di ambienti moderni, è il caso di questo leggio dalle linee e forme semplici che nonostante la linearità della struttura risulta un arredo elegante e di spicco. Gli elementi decorativi come i leggii sono unici e particolari, oltre alla loro presenza scenica questi arredi hanno diversi impieghi utili e funzionali. Inoltre sono realizzabili anche su misura e con una vasta scelta di colori ed essenze di legno.
Classic furnishings fit in harmoniously with modern environments, it is the case of this lectern with simple lines and shapes that despite the linearity of the structure is an elegant and prominent furniture. The decorative elements such as the lectern are unique and particular, in addition to their scenic presence these furnishings have several useful and functional uses. They can also be made to measure and with a wide choice of colors and wood essences.
Classic furnishings fit in harmoniously with modern environments, it is the case of this lectern with simple lines and shapes that despite the linearity of the structure is an elegant and prominent furniture. The decorative elements such as the lectern are unique and particular, in addition to their scenic presence these furnishings have several useful and functional uses. They can also be made to measure and with a wide choice of colors and wood essences.
Prodotti correlati
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 <> '657'
and t1.flag4=1
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;