Stone look ceramic tiles
Stone-effect porcelain tiles and wall tiles
Achieve the desired result with our selection of ceramic stones. A wide range of designs and sizes inspired by this most beautiful material. Thanks to the most innovative techniques, VIVES recreates the most realistic graphics, textures, and reliefs born from natural inspiration.
SELECT s.id id, s.nom nom, f.nom_cm formato, s.tipomaterial tipid, s.subtipomaterial subid, tm.tipomaterial_en tipnom, sm.subtipo_en subnom, LOWER(t.nom_en) tipol FROM vives_db.series s LEFT JOIN vives_db.serie_has_tipologia AS st ON st.id_serie = s.id LEFT JOIN vives_db.tipologia AS t ON st.id_tipologia = t.idtipologia LEFT JOIN vives_db.formatos f ON f.id = s.formato LEFT JOIN vives_db.subtipomaterial sm ON sm.idsubtipomaterial = s.subtipomaterial LEFT JOIN vives_db.tipomaterial tm ON s.tipomaterial = tm.idtipomaterial WHERE 1 = 1 AND s.id IN (SELECT MIN(s.id) id FROM vives_db.series s LEFT JOIN vives_db.serie_has_tipologia AS st ON st.id_serie = s.id WHERE 1 = 1 AND s.vigente = 1 AND st.id_tipologia = 3 GROUP BY nom ORDER BY s.nom);
Array ( [0] => Array ( [id] => 2 [nom] => ANCILES [formato] => 29,3X59,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [1] => Array ( [id] => 561 [nom] => NARPES [formato] => 40X60 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [2] => Array ( [id] => 582 [nom] => MURO [formato] => 19,4X59,3 [tipid] => 2 [subid] => 6 [tipnom] => wall tiles [subnom] => porcelain [tipol] => stone ) [3] => Array ( [id] => 588 [nom] => GREYSTONE [formato] => 59,3X59,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [4] => Array ( [id] => 632 [nom] => WORLD FLYSCH [formato] => 30X60 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [5] => Array ( [id] => 638 [nom] => ALPHA [formato] => 30X60 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [6] => Array ( [id] => 655 [nom] => CEPPO DI GRE [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [7] => Array ( [id] => 663 [nom] => BETA [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [8] => Array ( [id] => 672 [nom] => ASTON [formato] => 80X80 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [9] => Array ( [id] => 727 [nom] => LAMBDA [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [10] => Array ( [id] => 726 [nom] => RHO [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => stone ) [11] => Array ( [id] => 708 [nom] => DELTA [formato] => 60X60 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [12] => Array ( [id] => 710 [nom] => OMICRON [formato] => 25X75 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => stone ) [13] => Array ( [id] => 754 [nom] => SEINE [formato] => 80X180 [tipid] => 3 [subid] => 7 [tipnom] => floor tiles [subnom] => coloured body porcelain [tipol] => stone ) [14] => Array ( [id] => 769 [nom] => YONNE [formato] => 45X120 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => stone ) [15] => Array ( [id] => 770 [nom] => OISE [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => stone ) [16] => Array ( [id] => 790 [nom] => DOHA [formato] => 32X99 [tipid] => 2 [subid] => 2 [tipnom] => wall tiles [subnom] => white body [tipol] => stone ) [17] => Array ( [id] => 791 [nom] => TOKIO [formato] => 60X120 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) [18] => Array ( [id] => 804 [nom] => PANGEA [formato] => 120X120 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => stone ) )
