-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
-10,00%
Ψαροσακούλα μονή.
Διαστάσεις: 30x40cm.
Με δίχτυ μπροστά και μικρή εσωτερική τσέπη με φερμουάρ.
7,50 €6,75 €
-10,00%
Ψαροσακούλα Διπλή.
Διαστάσεις: 41x42cm.
Δύο θήκες , η εσωτερική με φερμουάρ.
Δίχτυ μαύρο μπροστά.
Τσέπη μικρή εσωτερικά ...
10,00 €9,00 €
-10,00%
ΨΑΡΟΣΑΚΟΥΛΕΣΜΟΝΗ ΜΕΓΑΛΗΜε ανθεκτικό δίχτυ εξαιρετικής ποιότητας
Ύφασμα 600D/PVC
Ιμάντες 4cm με πλαστική πόρπη
Εσωτερική ...
6,70 €6,03 €
-10,00%
Η Ελληνική εταιρεία
TIXΙ µπαίνοντας δυναμικά στο χώρο του υποβρύχιου κυνηγιού, κατασκεύασε και
παρουσιάζει τα λαστιχοβόλ...
45,00 €40,50 €
-10,00%
Το λαστιχοβόλο
ψαροντούφεκο Triton διαθέτει λαβή από εξαιρετικής ανθεκτικότητας πλαστικό
(λευκή, μαύρη ή χακί) με αντιολ...
72,00 €64,80 €
-10,00%
Το Yuma είναι ένα
ψαροντούφεκο σχεδιασμένο και κατασκευασμένο για γρήγορο ψάρεμα. Χάρη στο
ανοιχτό ρύγχος του για διπλά ...
140,00 €126,00 €
-10,00%
RAYO XACT
Tο
νέο RAYO XACT έχει ανασχεδιασμένο μηχανισμό σκανδάλης για μεγαλύτερη
ευαισθησία, ενισχυμένη κάννη και μη...
149,00 €134,10 €
-10,00%
-10,00%
RAYO CARBON Η
φήμη του RAYO είναι χτισμένη στην αποδεδειγμένα κορυφαία ευθυβολία του, την δύναμη του, την αξιοπιστία του...
228,00 €205,20 €
-10,00%
Το νέο HAWK ALU είναι λαστιχοβόλο μειωμένων τριβών με
εξαιρετική σκοπευτική εικόνα, μειωμένη αντίσταση μετακίνησης και...
106,00 €95,40 €
-10,00%
Αεροβόλο ψαροντούφεκο από τη Mares.
Το πρώτο Sten δημιουργήθηκε το 1967.
Έκτοτε έχει γίνει ο καλύτερος φίλος εκείνων που...
230,00 €207,00 €
-10,00%
Το αεροβόλο ψαροντούφεκο Mares Jet είναι αποτέλεσμα της πολύχρονης εμπειρίας της εταιρείας Mares.Η σειρά Jet διαθέτει
μο...
165,00 €148,50 €
SELECT DISTINCT p.id,[markaID],[retail_store_price],[Categories] FROM [products] AS p CROSS APPLY (SELECT TOP 1 [filepath] FROM [photos] WHERE [photos].object_Type='Product' AND [photos].object_ID=p.id AND [photos].filepath<>'' AND [photos].filepath IS NOT NULL) AS ph WHERE ('220' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ( ('221' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('222' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('244' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('246' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('247' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('255' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('257' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('262' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('267' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('273' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('274' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('285' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('306' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('311' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('312' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('472' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('475' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('853' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('854' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('860' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('881' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('882' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('885' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('886' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('899' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('225' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('279' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('888' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('892' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('871' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('872' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('873' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('874' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('893' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('331' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('865' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('866' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('867' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('890' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('895' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('868' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('869' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('870' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) ) | pagerTotal=332 | filtering=False | catID=220 | kz.count=25 | title DESC | title | SELECT DISTINCT [id] FROM (SELECT Row_Number() OVER ( ORDER BY p.title DESC) AS RowIndex,p.id FROM [products] AS p CROSS APPLY (SELECT TOP 1 [filepath] FROM [photos] WHERE [photos].object_Type='Product' AND [photos].object_ID=p.id AND [photos].filepath<>'' AND [photos].filepath IS NOT NULL) AS ph WHERE ('220' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ( ('221' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('222' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('244' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('246' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('247' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('255' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('257' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('262' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('267' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('273' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('274' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('285' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('306' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('311' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('312' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('472' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('475' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('853' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('854' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('860' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('881' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('882' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('885' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('886' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('899' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('225' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('279' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('888' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('892' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('871' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('872' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('873' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('874' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('893' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('331' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('865' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('866' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('867' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('890' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('895' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('868' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('869' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) OR ('870' IN (SELECT value FROM STRING_SPLIT(p.categories, ','))) )) AS Sub WHERE Sub.RowIndex >= 1 AND Sub.RowIndex <= 12;
,221,222,244,246,247,255,257,262,267,273,274,285,306,311,312,472,475,853,854,860,881,882,885,886,899,225,279,888,892,871,872,873,874,893,331,865,866,867,890,895,868,869,870