Envio

Envío gratis a partir de 49€

Fibra de escape 2/ 4 tiempos ACOUSTA-FIL 500gr - motoscamaralweb.com
search

Fibra de escape 2/ 4 tiempos ACOUSTA-FIL 500gr

24,60 €
Impuestos incluidos Envío de 3 a 5 dias.
Cantidad

  Envio

Envío gratis a partir de 49€

Acousta-fil is a product stemming from the last evolutions of insulations phoniques and thermic.

  • Competition muffler packing
  • For 2 strokes and 4 strokes engines
  • Resists up to 850°

VI1063480
) AS subset_products INNER JOIN `prstshp_product` p ON p.`id_product` = subset_products.id_product INNER JOIN `prstshp_product_shop` product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `prstshp_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `prstshp_stock_available` stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0) LEFT JOIN `prstshp_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1) LEFT JOIN `prstshp_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1) LEFT JOIN `prstshp_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `prstshp_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `prstshp_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`;