SELECT file from gallery where cartella='P928' and attivo=1 order by posizione,file
Shipments with dedicated courier: Discover more
Possibility of fast delivery
Nature living room
The aesthetics, design, shapes and functionality of the environment are all elements based on the principle of research and innovation. Many mistakenly think that contemporary and modern is the same thing; in reality, the contemporary style is a unique and particular style, which should not be confused with the modern one. Contemporary style is in fact a style that seeks a union between present and past, between tradition and innovation. It’s a style that seeks to meet the technological innovations, changes in life habits, times and way of living in the family, but trying to keep the warmth and the harmony typical of the home of the past.
Precisely for this reason, what characterizes the most contemporary furniture are the light and bright colors, clean geometric lines and the use of precious materials in solid wood but also innovative and modern as ash, paying particular attention to the harmonious and coherent introduction of the latest generation of technologies into the environment.
Precisely for this reason, what characterizes the most contemporary furniture are the light and bright colors, clean geometric lines and the use of precious materials in solid wood but also innovative and modern as ash, paying particular attention to the harmonious and coherent introduction of the latest generation of technologies into the environment.
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 <> '928'
and t1.flag4=1
AND t1.attivo = 1
ORDER BY RAND()
LIMIT 8;