Contact us
SELECT file from gallery where cartella='P623' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Composition 6
"Imagine the perfect laundry room: practical, functional, and with your style. With CORDEL, turning this dream into reality is simple. Explore our modular solutions and smart accessories, designed to make the most of every corner and create efficient work zones. With CORDEL, you can even utilize niches to create your laundry area. Cordel offers everything you need to furnish your laundry room or bathroom-laundry in a creative and functional way, integrating harmoniously with the rest of your home. A world of inspiration awaits your laundry 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 <> '623'
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;
