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 = 7
        INNER JOIN ps_feature_value_lang fvl
            ON pf.id_feature_value = fvl.id_feature_value
            AND fvl.id_lang = 7
        WHERE
            cp.id_category = 48 
            AND p.active = 1
            AND pf.id_feature IN (99,102,103)
        ORDER BY pf.id_feature, fvl.value
Lotus Style Collier Homme Acier Doré Maille Grain De Café LS2140-1/2

Technical specifications

Homme
Acier Doré
Acier/Silicone
Collier

Lotus Style Collier Homme Acier Doré Maille Grain De Café LS2140-1/2

Lotus Style

Lotus Style - Bracelet Homme - Cuir & Acier Noir - Ancre - LS1832-2/6

€44.00

By buying this product you can collect up to 4 point points. Your cart will total 4 points that can be converted into a voucher of €0.80.

Out-of-Stock
  • Expédié sous 24h

Read more

Lotus Style - Bracelet Homme - Cuir & Acier Noir - Ancre - LS1832-2/6

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