articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Oferte speciale


Carlige Hayabusa Jig 151bn Nr 1/0 6buc -17%

Carlige Hayabusa Jig 151bn Nr 1/0 6buc

7169
Livrare imediată!

9,90Lei(-17%) 8,25Lei

Carlige Hayabusa Jig 151bn Nr 2/0 5buc -17%

Carlige Hayabusa Jig 151bn Nr 2/0 5buc

7170
Livrare imediată!

9,90Lei(-17%) 8,25Lei

Carlige Hayabusa Jig 151bn Nr 3/0 4buc -17%

Carlige Hayabusa Jig 151bn Nr 3/0 4buc

7171
Livrare imediată!

9,90Lei(-17%) 8,25Lei

Carlige Hayabusa Offset Power Stage Nr 3/0 20 Buc -25%

Carlige Hayabusa Offset Power Stage Nr 3/0 20 Buc

7316
Livrare imediată!

35,01Lei(-25%) 26,32Lei

Carlige Hayabusa P2, Nr.2, 10buc/pac -28%

Carlige Hayabusa P2, Nr.2, 10buc/pac

p-2/4
Livrare imediată!

14,00Lei(-28%) 10,06Lei

Carlige Hayabusa Sde 198bz Nr 10 15buc -16%

Carlige Hayabusa Sde 198bz Nr 10 15buc

7248
Livrare imediată!

8,09Lei(-16%) 6,80Lei

Carlige Hayabusa Umt 219go Nr.14, 15buc/pac -11%

Carlige Hayabusa Umt 219go Nr.14, 15buc/pac

7180
Livrare imediată!

7,90Lei(-11%) 7,01Lei

Carlige Hayabusa Ymm220bl Nr 16 15buc -15%

Carlige Hayabusa Ymm220bl Nr 16 15buc

7191
Livrare imediată!

8,20Lei(-15%) 7,01Lei

Carlige Jaxon Sumato Catfish, Black, Nr.8/0, 5buc/pac -20%

Carlige Jaxon Sumato Catfish, Black, Nr.8/0, 5buc/pac

hy-hka8/0
Livrare imediată!

19,00Lei(-20%) 15,13Lei

Carlige Kamasan B790 Nr 5 Auriu 8/plic -0%

Carlige Kamasan B790 Nr 5 Auriu 8/plic

bhpb790005
Livrare imediată!

6,00Lei(-0%) 5,98Lei

Carlige Korda Klor Nr.8, 10buc/pac -18%

Carlige Korda Klor Nr.8, 10buc/pac

k.klor8
Livrare imediată!

29,86Lei(-18%) 24,58Lei

Carlige Korum Quick Stops On Hair Rig Barbed, Nr.16, 8buc/pac -44%
Exclusiv online!

Carlige Korum Quick Stops On Hair Rig Barbed, Nr.16, 8buc/pac

khrqbs/16
Livrare 7-14 zile

19,75Lei(-44%) 11,07Lei

Carlige Korum Quickstops On Hair Rigs Barbed, Nr.16, 8buc/pac -34%
Exclusiv online!

Carlige Korum Quickstops On Hair Rigs Barbed, Nr.16, 8buc/pac

khrqb/16
Livrare 7-14 zile

19,75Lei(-34%) 13,06Lei

Carlige Korum Quickstops On Hair Rigs Barbless, Nr.16, 8buc/pac -34%
Exclusiv online!

Carlige Korum Quickstops On Hair Rigs Barbless, Nr.16, 8buc/pac

khhq/16
Livrare 7-14 zile

19,95Lei(-34%) 13,16Lei

Carlige Legate Browning No.6 10cm 0.12mm Braid Feeder Leader Method Push Stop -19%

Carlige Legate Browning No.6 10cm 0.12mm Braid Feeder Leader Method Push Stop

4720012
Livrare imediată!

9,70Lei(-19%) 7,89Lei

Carlige Legate Dam Detek Method Pellet Bl Nr.10, 0.25mm, 4kg, 10cm, 8buc/pac -24%
Exclusiv online!

Carlige Legate Dam Detek Method Pellet Bl Nr.10, 0.25mm, 4kg, 10cm, 8buc/pac

a.dam.70458
Livrare 24-48 ore

20,10Lei(-24%) 15,31Lei

Carlige Legate Dam Detek Method Pellet Bl Nr.8, 0.28mm, 5kg, 10cm, 8buc/pac -24%
Exclusiv online!

Carlige Legate Dam Detek Method Pellet Bl Nr.8, 0.28mm, 5kg, 10cm, 8buc/pac

a.dam.70457
Livrare 24-48 ore

20,10Lei(-24%) 15,31Lei

Carlige Legate Dam Detek Method Push Stop 8buc/plic Nr.8 -24%
Exclusiv online!

Carlige Legate Dam Detek Method Push Stop 8buc/plic Nr.8

a.dam.70442
Livrare 24-48 ore

20,10Lei(-24%) 15,31Lei

Carlige Legate Dam Detek Method Spike Rig Nr.14, 0.22mm, 3.2kg, 10cm, 8buc/plic -33%

Carlige Legate Dam Detek Method Spike Rig Nr.14, 0.22mm, 3.2kg, 10cm, 8buc/plic

a.dam.70455
Livrare imediată!

25,00Lei(-33%) 16,73Lei

Carlige Legate Dam Sumo Spezi Carp Black Nr.6 Fir 0.25mm -9%

Carlige Legate Dam Sumo Spezi Carp Black Nr.6 Fir 0.25mm

709096842006
Livrare imediată!

12,91Lei(-9%) 11,75Lei

Afişare 4121 - 4140 din 9258 (463 pagini)
Queries: 5, Total time: 769.616 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '1657f7c0acb2d20c5f82889926'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (353.553)
SELECT COUNT(1) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) AND p.quantity > '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1714
4 (415.724)
SELECT DISTINCT ps.product_id
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.quantity > '0' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 4120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.106)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37