IMPORTANT! Pentru a îmbunătăţi relaţia cu tine acest site foloseşte cookie-uri (eng. cookies).
Pentru mai multe detalii apasă aici. Dacă esti de acord cu acest lucru atunci poti [x] închide acest avertisment.

Filtre

Producător

FK Automotive (4)

SCHROTH Racing (4)

Listă produse

Centuri

KIT ROLL CAGE EXOSKELETON PT. 07-18 JEEP WRANGLER UNLIMITED JKU - SMITTYBILT

[SB76840]

KIT ROLL CAGE EXOSKELETON PT. 07-18 JEEP WRANGLER UNLIMITED JKU - SMITTYBILT

KIT Roll Cage exoskeleton pt. 07-18 JEEP WRANGLER Unlimited JKu - Smittybilt Roll Cage Kit Smittybilt XRC EXOSKELETON for Jeep Wrangler JK 2007-2017 sMounts directly onto vehicle body 1.75" diameter 0.120-wall steel tubing Windshield crossbar for roof access B-pillar fixing point to reduce swaying14 touch points to improve rigidityFour crossbars for rack/tent mounting. Removab[...]

10207,51 lei

livrare 5-7 zile

KIT ROLL CAGE pt. 97-06 JEEP WRANGLER TJ / LJ - SMITTYBILT

[SB76900]

KIT ROLL CAGE pt. 97-06 JEEP WRANGLER TJ / LJ - SMITTYBILT

KIT ROLL CAGE pt. 97-06 JEEP WRANGLER TJ / LJ - SMITTYBILT Increase your safety with the Smittybilt cage The reinforced cage kits come with everything you'll need to strengthen your factory roll bar into a solid foundation if a roll over takes place. Manufactured from 1020 .120 Wall DOM tubing which is one of the strongest materials available. Each kit includes th[...]

6650,52 lei

livrare 5-7 zile

SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=262 )

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=263 )

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=192 )

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=238 )

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=192 ) AND ( nou=1)

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=192 ) AND ( promotional=1)

; 
	
	
	SELECT
		COUNT(DISTINCT p.cod) AS listaProduse
	FROM mv_produse p

LEFT JOIN mv_specificatii_produse sp ON (sp.cod_produs=p.cod AND sp.activ=1 AND sp.sters=0)

WHERE p.vizibil=1 AND FIND_IN_SET("451", REPLACE(p.cod_categorie,'|',','))>0

AND (  p.cod_producator=192 ) AND ( lichidare_stoc=1)

;