Help and contact

Menu

0
My cart 0 article 
        SELECT
            pf.id_feature,
            fl.name AS feature_name,
            pf.id_feature_value,
            fvl.value AS feature_value
        FROM ps_product p
        INNER JOIN ps_category_product cp
            ON p.id_product = cp.id_product
        INNER JOIN ps_feature_product pf
            ON p.id_product = pf.id_product
        INNER JOIN ps_feature_lang fl
            ON pf.id_feature = fl.id_feature
            AND fl.id_lang = 5
        INNER JOIN ps_feature_value_lang fvl
            ON pf.id_feature_value = fvl.id_feature_value
            AND fvl.id_lang = 5
        WHERE
            cp.id_category = 48 
            AND p.active = 1
            AND pf.id_feature IN (99,102,103)
        ORDER BY pf.id_feature, fvl.value
  • Montre étanche
    Étanche
Ice Watch Flower Flower Power Montre Femme Small 017582

Technical specifications

Femme
Flowers
Silicone
Blanc
Blanc
Silicone
Blanc
Rond
Boucle
10 ATM
?
QUARTZ
Analogique
34 mm
2 ans
Minéral

Ice Watch Flower Flower Power Montre Femme Small 017582

Ice Watch

99,00 €

Acquistando questo prodotto puoi ricevere fino a 9 punto punti. Il tuo carrello ti offrirà 9 punti convertibili in un voucher di: 1,80 €.

Non disponibile
  • Garantie 2 ans
  • Expédié sous 24h
  • Livraison gratuite
Delivery for free
Delivery for free
from 69€ purchase
Payment secured
Payment secured
Credit card, Paypal or bank transfer
Payment from 2 to 4 times
Payment from 2 to 4 times
free of charge
Satisfied or your money back
Satisfied or your money back
within 14 days
Contact us
Contact us
06 20 43 38 42 (9am-6pm)
0