Comenzi telefonice: 0722.490.300    

SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(2109,1531,1533,613,616,614,823,664,435,1028,449,880,445,682,545,1027,178), 1, 0)) as flag FROM zen_products_attributes p2a  JOIN zen_products_options po ON p2a.options_id = po.products_options_id AND po.language_id=2 JOIN zen_products_options_values pov ON p2a.options_values_id = pov.products_options_values_id AND pov.language_id=2 WHERE p2a.products_id IN (682,545,178,1027,445,880,449,2109,1028,435,664,823,614,616,613,1533,1531) AND p2a.options_id IN (2,1,3,8) AND p2a.options_id NOT IN (4,5,6,7) GROUP BY po.products_options_name, pov.products_options_values_name ORDER BY po.products_options_sort_order, pov.products_options_values_sort_order
Filtrare rezultate

Dupa Categorie:


Dupa Latime:


Dupa Inaltime:


Dupa Diametru:

14.00-38 8PR BKT TR135 TT
14.00-38 8PR BKT TR135 TT
1,590.00Lei  1,290.00Lei
Reducere   19%
Facebook

Promotii


10-16.5 8PR 134 A2 MRL ML-2455 TL
10-16.5 8PR 134 A2 MRL ML-2455 TL
490.00Lei 450.00Lei
Reducere 8%
Adauga In Cos
440/80-24 168 A8 MICHELIN POWER CL TL
440/80-24 168 A8 MICHELIN POWER CL TL
3,450.00Lei 3,360.00Lei
Reducere 3%
Adauga In Cos
440/80-28 156 A8 MICHELIN POWER CL TL
440/80-28 156 A8 MICHELIN POWER CL TL
3,750.00Lei 3,550.00Lei
Reducere 5%
Adauga In Cos

7.50-20 6PR MITAS TF-05 TT
7.50-20 6PR MITAS TF-05 TT
410.00Lei 390.00Lei
Reducere 5%
Adauga In Cos
7.50-20 6PR MITAS TF-03 TT
7.50-20 6PR MITAS TF-03 TT
470.00Lei 430.00Lei
Reducere 9%
Adauga In Cos
7.50-20 6PR MITAS TF-01 TT
7.50-20 6PR MITAS TF-01 TT
430.00Lei 410.00Lei
Reducere 5%
Adauga In Cos

12.5/80-18 14PR MITAS BIG-BOY TL
12.5/80-18 14PR MITAS BIG-BOY TL
1,500.00Lei 1,350.00Lei
Reducere 10%
Adauga In Cos
13.6-28 8PR PETLAS TA-60 TT
13.6-28 8PR PETLAS TA-60 TT
1,240.00Lei 1,145.00Lei
Reducere 8%
Adauga In Cos
14.9-28 8PR PETLAS TA-60 TT
14.9-28 8PR PETLAS TA-60 TT
1,370.00Lei 1,295.00Lei
Reducere 5%
Adauga In Cos

14.00-38 12PR BKT TR135 TT
14.00-38 12PR BKT TR135 TT
1,850.00Lei 1,550.00Lei
Reducere 16%
Adauga In Cos
14.00-38 10PR PETLAS TA-60 TT
14.00-38 10PR PETLAS TA-60 TT
1,860.00Lei 1,284.00Lei
Reducere 31%
Adauga In Cos
14.9-28 8PR CULTOR AS AGRI-19 TT
14.9-28 8PR CULTOR AS AGRI-19 TT
1,365.00Lei 1,200.00Lei
Reducere 12%
Adauga In Cos

14.00-38 8PR PETLAS TA-60 TT
14.00-38 8PR PETLAS TA-60 TT
1,590.00Lei 1,260.00Lei
Reducere 21%
Adauga In Cos
7.50-20 6PR MITAS TS-04 TT
7.50-20 6PR MITAS TS-04 TT
485.00Lei 455.00Lei
Reducere 6%
Adauga In Cos
13.6-28 8PR CULTOR AS-AGRI 19 TT
13.6-28 8PR CULTOR AS-AGRI 19 TT
1,275.00Lei 1,210.00Lei
Reducere 5%
Adauga In Cos


Inapoi