Η Ελληνική εταιρεία
TIXΙ µπαίνοντας δυναμικά στο χώρο του υποβρύχιου κυνηγιού, κατασκεύασε και
παρουσιάζει τα λαστιχοβόλ...
45,00 €40,50 €
Το λαστιχοβόλο
ψαροντούφεκο Triton διαθέτει λαβή από εξαιρετικής ανθεκτικότητας πλαστικό
(λευκή, μαύρη ή χακί) με αντιολ...
72,00 €64,80 €
Το Yuma είναι ένα
ψαροντούφεκο σχεδιασμένο και κατασκευασμένο για γρήγορο ψάρεμα. Χάρη στο
ανοιχτό ρύγχος του για διπλά ...
140,00 €
RAYO XACT
Tο
νέο RAYO XACT έχει ανασχεδιασμένο μηχανισμό σκανδάλης για μεγαλύτερη
ευαισθησία, ενισχυμένη κάννη και μη...
155,00 €139,50 €
Pathos Pro
Designed both for entry level and experienced spearos, the Pathos Pro is a
lightweight and powerful railgun. ...
140,00 €126,00 €
Pathos Open
Carbon Designed for experienced spearos, the Pathos Open Carbon is a
lightweight and powerful railgun. It’s ...
241,00 €216,90 €
Laser Carbon Competition The Laser Carbon Competition is a lightweight and powerful railgun designed for demanding spear...
277,00 €249,30 €
The Pathos Laser EVO Speargun is the next generation of the well-known model Laser open and has been designed both for e...
212,50 €191,25 €
Designed for both entry level
and advanced freedivers, the Pathos Alma Standard is mostly suitable for
hunting around th...
112,50 €101,25 €
The Yuma Fast is Cressi's new rubber diving weapon
designed for fast reactions and fast fishing that will impress with i...
159,99 €143,99 €
The Cressi
Cherokee Exo rubber speargun is being produced from anticorodal black frame
barrel, with integrated spear gui...
169,99 €152,99 €
SELECT DISTINCT p.id,p.[markaID],p.[retail_store_price],p.[Categories] FROM [products] AS p WHERE (CHARINDEX(',221,', p.categories)>0 OR p.categories='221') OR ( (CHARINDEX(',225,', p.categories)>0 OR p.categories='225') OR (CHARINDEX(',279,', p.categories)>0 OR p.categories='279') OR (CHARINDEX(',888,', p.categories)>0 OR p.categories='888') OR (CHARINDEX(',892,', p.categories)>0 OR p.categories='892')) | Timer 0: 1 ms | Timer 1: 55 ms | Timer 2: 5 ms | pagerTotal=39 | filtering=False | Timer 3: 3479 ms | catID=221 | kz.count=4 | title DESC | title | Timer 4: 7 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(3289,3392,5464,6690,7265,7266,7268,7391,7572,7696,7697,7783,8944,8945,11547,11551,11552,12129,12141,12156,12758,12760,12761,12762,12763,12764,12765,12766,12767,12768,12770,15080,16476,16477,16554,16555,16556,16557,16820)) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;
,225,279,888,892