Contact us
SELECT file from gallery where cartella='P913' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Living room Mirabella
Present in every living room, the wall system is a furniture that fits with simplicity in any type of style and environment. The wall systems have blind compartments and open spaces for a double function of containment and exposure while remaining aesthetically very elegant and harmonious as well as functional. The solid wood closing doors can be made important thanks to the use of decorations of various kinds customizable, as well as all the furniture of a composition can be made unique, choosing different types of wood and finishes, only with protective varnish or white varnish.
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 <> '913'
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;
