Contattaci
SELECT file from gallery where cartella='P861' and attivo=1 order by posizione,file
Spedizioni con corriere dedicato: Scopri di più
Possibilità di consegna rapida
Consolle Vintage
Consolle in stile moderno nel col. Bianco Consumato allungabile fino a 295 cm (con 5 allunghe da 50 cm) realizzato in Frassino, disponibile in diverse varianti di colore. Dalle linee e forme semplici le consolle Basic si inseriscono con armonia in ogni ambiente anche grazie al poco ingombro. Trasformabili in tavoli funzionali possono accogliere molti ospiti in comodità grazie alle varie allunghe da tenere separatamente.
Modern style console col. Worn-out White extending up to 295 cm (with 5 extensions of 50 cm) made of Ash, available in different color variations. With simple lines and shapes, the Basic consoles fit harmoniously into any environment thanks to their small footprint. Convertible into functional tables can accommodate many guests in comfort thanks to the various extensions to be kept separately.
Modern style console col. Worn-out White extending up to 295 cm (with 5 extensions of 50 cm) made of Ash, available in different color variations. With simple lines and shapes, the Basic consoles fit harmoniously into any environment thanks to their small footprint. Convertible into functional tables can accommodate many guests in comfort thanks to the various extensions to be kept separately.
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 <> '861'
and t1.flag4=1
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;