SELECT SQL_CALC_FOUND_ROWS ident, CONCAT(znamka,' ',komercialno_ime,'
',naziv) as naziv, slika_1 as slika , cena * 1.22 AS cena_z_ddv, cena_pred_akcijo * 1.22 as cena_pred_akcijo, znamka FROM _produkti_moto_gume WHERE znamka = 'PIRELLI' ORDER BY cena LIMIT 9,9
  • PIRELLI SC 30
    3.50 - 10 51J

    47,58 € 23,79 €
    PIRELLI SC 30<br>3.50 - 10 51J
    Dodaj
    v košarico
  • PIRELLI MANDRAKE MT 15
    110/80 - 14 M/C 59J TL Reinf

    40,26 € 24,16 €
    PIRELLI MANDRAKE MT 15<br>110/80 - 14 M/C 59J TL Reinf
    Dodaj
    v košarico
  • PIRELLI CITY DEMON
    2.75 - 18 M/C 42P TL

    40,87 € 24,52 €
    PIRELLI CITY DEMON<br>2.75 - 18 M/C 42P TL
    Dodaj
    v košarico
  • PIRELLI SL 26
    100/80 - 10 53J TL

    50,02 € 25,01 €
    PIRELLI SL 26<br>100/80 - 10 53J TL
    Dodaj
    v košarico
  • PIRELLI MT 75
    100/80 - 17 M/C 52P TL

    42,70 € 25,62 €
    PIRELLI MT 75<br>100/80 - 17 M/C 52P TL
    Dodaj
    v košarico
  • PIRELLI SL 26
    3.50 - 10 59J TL Reinf

    51,24 € 25,62 €
    PIRELLI SL 26<br>3.50 - 10 59J TL Reinf
    Dodaj
    v košarico
  • PIRELLI SL 38 UNICO
    100/80 - 10 53L TL

    51,24 € 25,62 €
    PIRELLI SL 38 UNICO<br>100/80 - 10 53L TL
    Dodaj
    v košarico
  • PIRELLI SCORPION MX EXTRA J
    70/100 - 17 NHS 40M

    43,92 € 26,35 €
    PIRELLI SCORPION MX EXTRA J<br>70/100 - 17 NHS 40M
    Dodaj
    v košarico
  • PIRELLI SCORPION MX32 MID SOFT
    60/100 - 12 NHS 36M

    43,92 € 26,35 €
    PIRELLI SCORPION MX32 MID SOFT<br>60/100 - 12 NHS 36M
    Dodaj
    v košarico