SELECT p.*
    FROM view_produtos_usa p
    WHERE p.mestre IS NULL 
     AND p.ativo_usa = 'true' AND p.ativo_usa_local = 'true'
    AND p.rodape <> 'true' 
    AND p.nome NOT LIKE '% rs%' 
    AND p.nome NOT LIKE '% rodape%' 
    AND p.colecao = 'CRAFT'
    AND p.area = (
        SELECT MAX(inner_p.area)
        FROM view_produtos_usa inner_p
        WHERE inner_p.cor_produto = p.cor_produto
            AND inner_p.mestre IS NULL 
             AND inner_p.ativo_usa = 'true' AND inner_p.ativo_usa_local = 'true'
            AND inner_p.rodape <> 'true' 
            AND inner_p.nome NOT LIKE '% rs%' 
            AND inner_p.nome NOT LIKE '% rodape%' 
            AND inner_p.colecao = 'CRAFT'
    )
    GROUP BY p.cor_produto;
CRAFT

CRAFT

USA COLLECTIONS

Sizes

  • 10x10 cm | 4”x4”

Colors

ALL PRODUCTS

CRAFT

Discover the charm of imperfection with our 4x4” glossy ceramic tile collection, inspired by traditional zellige craftsmanship. Each tile features rich shade variation and a hand-finished look that brings warmth, depth, and character to any space. The high-gloss surface enhances the organic texture and irregular edges, capturing the essence of artisanal tilework while embracing a modern design sensibility. Ideal for backsplashes, accent walls, and statement surfaces, this collection blends old-world soul with contemporary elegance.

Opening Report...
CRAFT