Contact us
SELECT file from gallery where cartella='P1379' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Cucina A28
The element that makes the difference in a modern kitchen is the island. Whether used as a countertop or a cooking surface, it can radically transform the look of the room.
When you have guests over for dinner, you often have to give up chatting because you are busy at the stove. The island can create a welcoming atmosphere when you have guests.
When you have guests over for dinner, you often have to give up chatting because you are busy at the stove. The island can create a welcoming atmosphere when you have guests.
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 <> '1379'
and t1.flag4=1
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;