Wood look ceramic and porcelain tiles
Wood-effect porcelain tiles and wall tiles
Find the best selection of Ceramic Wood like flooring in our catalogue. Tiles that look like real wood planks, porcelain tiles that imitates parquet, Nordic style, vintage look or pickled, burned or distressed wood and even OSB boards. Enjoy the warmth and naturalness of wood with the advantages of ceramic floor tiles.
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 = 5 GROUP BY nom ORDER BY s.nom) ORDER BY id desc;
Array ( [0] => Array ( [id] => 800 [nom] => OTTAWA [formato] => 19,4X120 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [1] => Array ( [id] => 799 [nom] => NIVALA [formato] => 19,4X120 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [2] => Array ( [id] => 798 [nom] => KOKKOLA [formato] => 19,4X120 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [3] => Array ( [id] => 796 [nom] => BOWDEN [formato] => 26X180 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [4] => Array ( [id] => 730 [nom] => BELICE [formato] => 26X180 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [5] => Array ( [id] => 685 [nom] => MONTGOMERY [formato] => 19,2X119,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [6] => Array ( [id] => 665 [nom] => GAMMA [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [7] => Array ( [id] => 658 [nom] => STRAND [formato] => 59,3X59,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [8] => Array ( [id] => 629 [nom] => WORLD WOODS [formato] => 19,2X119,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [9] => Array ( [id] => 610 [nom] => NORA [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [10] => Array ( [id] => 579 [nom] => FARO [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [11] => Array ( [id] => 518 [nom] => ORSA BASIC [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [12] => Array ( [id] => 74 [nom] => ARHUS [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [13] => Array ( [id] => 71 [nom] => ORSA [formato] => 14,4X89,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) [14] => Array ( [id] => 65 [nom] => POLINESIA [formato] => 14,3X119,3 [tipid] => 3 [subid] => 3 [tipnom] => floor tiles [subnom] => porcelain [tipol] => wood ) )
