Moon Box Tebe

Moon Box Tebe 
1294
1296,1297,1307
SELECT p.id_product
            FROM ps_product p
            JOIN ps_category_product cp1 ON (p.id_product = cp1.id_product AND cp1.id_category = 10)
            JOIN ps_category_product cp2 ON (p.id_product = cp2.id_product AND cp2.id_category = 111)
            WHERE active = 1 and p.id_product in (1296,1297,1307)
10
111
Array
(
    [0] => ProductNode Object
        (
            [id] => 1297
            [name] => Array
                (
                    [1] => Moon Box TEBE 101.5°
                    [3] => Moon Box TEBE 101.5°
                    [5] => Moon Box TEBE 101.5°
                )

            [tag] => Moon Box TEBE
            [cover] => www.vandermoon.com/eng/17300/moon-box-tebe-109.jpg
        )

)
Select type
Select a vehicle




Obecnie brak na stanie
€0.00
Tax excluded pcs.


The price has not changed in the last 30 days.


Realization

Each product is handmade and manufactured to individual order.
The average lead time is 12 business days + shipping.
In the event of increased interest, lead times may be extended.

Product Details

Reviews (0)

No reviews
Product added to wishlist