Click for more products.
No products were found.
Favoritos es pt fr de

Complementos señora BIENVE l-0311 burdeos

22,23 €
Ref:
9654000
Medida: 33 x 37 x 17 cm
  • UN
Otros colores
Últimas unidades en stock
Detalles del producto
9654000

Ficha técnica

Color
BURDEOS
Familia
Mujer
Línea
Complementos
Tono color
Rojos
Estilo
De colgar normal
Material
Sintetico o tejido
Altura
Bolso
Modelo
L-0311
Líneas
Sport
Medida
33 x 37 x 17 cm
Comentarios
SELECT DISTINCT 
            p.id_product, 
            p.id_manufacturer, 
            p.id_category_default, 
            p.price, 
            p.reference, 
            product_shop.active
        FROM ps_product p
         INNER JOIN ps_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
        WHERE 1 
        AND product_shop.active = 1
        LIMIT 0,17