Shimano Genpu XT 200PGΤο
μοντέλο 200PG(Right-δεξί) 201PG(Left-αριστερό) στο οποίο έρχεται στην
χώρα μας χαρακτηρίζεται...
155,00 €139,50 €
Ο μικρός, ελαφρύς, δυνατός και
γρήγορος μηχανισμός της BANAX. Ιδανικός για tai rubber και καθετή.
- Σε δεξιά έκδοση.
- ...
176,00 €158,40 €
The Tranx is a large baitcasting reel designed with one purpose, to deliver power, and plenty of it. For the large lure ...
390,00 €351,00 €
The
all-new Grappler BB 150HG Baitcasting reel from Shimano will
cover a wide range of vertical fishing methods from the...
220,00 €198,00 €
SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',50,', p.categories)>0 OR p.categories='50') | Timer 0: 1 ms | Timer 1: 17 ms | Timer 2: 0 ms | pagerTotal=7 | filtering=False | Timer 3: 922 ms | catID=50 | kz.count=0 | title DESC | title | Timer 4: 3 ms | SELECT DISTINCT [id] FROM (SELECT Row_Number() OVER ( ORDER BY p.title DESC) AS RowIndex, p.id FROM [products] AS p WHERE p.id IN(8413,10163,10174,12201,12541,14985,16685)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;