Contact us
SELECT file from gallery where cartella='P479' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Splendida
The space dedicated to conviviality as that of the living room is the focal point of a home and it tries to make it as hospitable as possible, by inserting furniture that can blend aesthetic style with comfort and utility. We present a selection of dining areas of various styles in which functionality and design blend harmoniously and to which you can be inspired to create striking environments that will leave your guests speechless.
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 <> '479'
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;
