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 SL 26
    100/80 - 10 53J TL

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

    45,75 € 27,00 €
    PIRELLI MT 75 <br>100/80 - 17 M/C 52P TL
    Dodaj
    v košarico
  • PIRELLI MANDRAKE MT 15
    110/80 - 14 M/C 59J TL Reinf

    45,75 € 27,00 €
    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

    46,36 € 27,35 €
    PIRELLI CITY DEMON <br>2.75 - 18 M/C 42P TL
    Dodaj
    v košarico
  • PIRELLI SL 26
    3.50 - 10 59J TL Reinf

    54,90 € 27,45 €
    PIRELLI SL 26 <br>3.50 - 10 59J TL Reinf
    Dodaj
    v košarico
  • PIRELLI SL 38 UNICO
    100/80 - 10 53L TL

    54,90 € 27,45 €
    PIRELLI SL 38 UNICO <br>100/80 - 10 53L TL
    Dodaj
    v košarico
  • PIRELLI SCORPION MX32 MID SOFT
    60/100 - 12 NHS 36M

    46,97 € 27,72 €
    PIRELLI SCORPION MX32 MID SOFT <br>60/100 - 12 NHS 36M
    Dodaj
    v košarico
  • PIRELLI SCORPION MX EXTRA J
    70/100 - 17 NHS 40M

    46,97 € 27,72 €
    PIRELLI SCORPION MX EXTRA J <br>70/100 - 17 NHS 40M
    Dodaj
    v košarico
  • PIRELLI MT 75
    100/80 - 16 M/C 50T TL

    47,58 € 28,07 €
    PIRELLI MT 75 <br>100/80 - 16 M/C 50T TL
    Dodaj
    v košarico