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 ME 22
    60/100 - 17 M/C 33L

    46,36 € 27,35 €
    METZELER ME 22 <br>60/100 - 17 M/C 33L
    Dodaj
    v košarico
  • METZELER SPORTEC STREET
    90/90 - 14 M/C 46S TL

    54,90 € 27,45 €
    METZELER SPORTEC STREET <br>90/90 - 14 M/C 46S TL
    Dodaj
    v košarico
  • METZELER SPORTEC STREET
    90/90 - 14 M/C 46S TL

    54,90 € 27,45 €
    METZELER SPORTEC STREET <br>90/90 - 14 M/C 46S TL
    Dodaj
    v košarico
  • METZELER ME 1
    90/90 - 10 50J TL

    54,90 € 27,45 €
    METZELER ME 1 <br>90/90 - 10 50J TL
    Dodaj
    v košarico
  • METZELER ME 22
    2.50 - 17 M/C 43P Reinf

    48,19 € 28,44 €
    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

    48,19 € 28,44 €
    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

    48,19 € 28,44 €
    METZELER ME 22 <br>90/90 - 18 M/C 57P Reinf
    Dodaj
    v košarico
  • METZELER ME 5
    100/90 - 10 61J TL Reinf

    57,34 € 28,67 €
    METZELER ME 5 <br>100/90 - 10 61J TL Reinf
    Dodaj
    v košarico
  • METZELER ME 1
    3.50 - 10 59J TL Reinf

    58,56 € 29,28 €
    METZELER ME 1 <br>3.50 - 10 59J TL Reinf
    Dodaj
    v košarico