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 = 'METZELER' ORDER BY cena LIMIT 9,9
  • METZELER SPORTEC STREET
    70/90 - 14 M/C 34S TL

    41,48 € 24,89 €
    METZELER SPORTEC STREET<br>70/90 - 14 M/C 34S TL
    Dodaj
    v košarico
  • METZELER ME 22
    2.75 - 18 M/C.42P

    42,09 € 25,25 €
    METZELER ME 22<br>2.75 - 18 M/C.42P
    Dodaj
    v košarico
  • METZELER ME 22
    2.75 - 18 M/C 42P

    42,09 € 25,25 €
    METZELER ME 22<br>2.75 - 18 M/C 42P
    Dodaj
    v košarico
  • METZELER ME 22
    2.75 - 18 M/C 42P TL

    42,09 € 25,25 €
    METZELER ME 22<br>2.75 - 18 M/C 42P TL
    Dodaj
    v košarico
  • METZELER ME 1
    90/90 - 10 50J TL

    51,24 € 25,62 €
    METZELER ME 1<br>90/90 - 10 50J TL
    Dodaj
    v košarico
  • METZELER ME 22
    2.50 - 17 43P Reinf

    42,70 € 25,62 €
    METZELER ME 22<br>2.50 - 17 43P Reinf
    Dodaj
    v košarico
  • METZELER ME 22
    2.50 - 17 M/C 43P Reinf

    42,70 € 25,62 €
    METZELER ME 22<br>2.50 - 17 M/C 43P Reinf
    Dodaj
    v košarico
  • METZELER ME 22
    2.75 - 18 M/C 48P TL Reinf

    42,70 € 25,62 €
    METZELER ME 22<br>2.75 - 18 M/C 48P TL Reinf
    Dodaj
    v košarico
  • METZELER ME 22
    90/90 - 18 M/C 57P Reinf

    42,70 € 25,62 €
    METZELER ME 22<br>90/90 - 18 M/C 57P Reinf
    Dodaj
    v košarico