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


Plumb Crap Cu Vartej Jaxon G Verde 130gr 1buc/plic -21%

Plumb Crap Cu Vartej Jaxon G Verde 130gr 1buc/plic

cp-0030130g
Livrare imediată!

12,00Lei(-21%) 9,53Lei

Plumb Crap Cu Vartej Jaxon Maro 110gr -20%

Plumb Crap Cu Vartej Jaxon Maro 110gr

cp-0030110
Livrare imediată!

11,50Lei(-20%) 9,24Lei

Plumb Crap Cu Vartej Jaxon Maro 130gr -21%
Exclusiv online!

Plumb Crap Cu Vartej Jaxon Maro 130gr

cp-0030130
Livrare 48-72 ore

12,00Lei(-21%) 9,53Lei

Plumb Crap Cu Vartej Jaxon Maro 90gr -18%

Plumb Crap Cu Vartej Jaxon Maro 90gr

cp-003090
Livrare imediată!

9,50Lei(-18%) 7,80Lei

Plumb Crap Diamond Jaxon Inline Maro 130gr -21%

Plumb Crap Diamond Jaxon Inline Maro 130gr

cp-0031130
Livrare imediată!

12,00Lei(-21%) 9,53Lei

Plumb Delphin Tip Lacrima Cu Tub 80g -22%

Plumb Delphin Tip Lacrima Cu Tub 80g

830512080
Livrare imediată!

9,00Lei(-22%) 7,01Lei

Plumb Dropshot Delphin Bomb, 3.5gr, 5buc/pac -36%

Plumb Dropshot Delphin Bomb, 3.5gr, 5buc/pac

965925003
Livrare imediată!

11,00Lei(-36%) 7,01Lei

Plumb Fox Paste Bomb Cu Vartej 2.5oz 71gr -22%

Plumb Fox Paste Bomb Cu Vartej 2.5oz 71gr

cld182
Livrare imediată!

13,67Lei(-22%) 10,73Lei

Plumb Fox Paste Bomb Cu Vartej 3.5oz 99gr -16%

Plumb Fox Paste Bomb Cu Vartej 3.5oz 99gr

cld183
Livrare imediată!

15,14Lei(-16%) 12,69Lei

Plumb Fox Paste Bomb Inline 3.5oz -11%

Plumb Fox Paste Bomb Inline 3.5oz

cld186
Livrare imediată!

13,62Lei(-11%) 12,08Lei

Plumb Grippa Cu Vartej Advance Boats 160gr Culoare Verde Camo -33%
Exclusiv online!

Plumb Grippa Cu Vartej Advance Boats 160gr Culoare Verde Camo

clm64250160
Stoc epuizat

5,51Lei(-33%) 3,70Lei

Plumb Jaxon Monturi Catfish 200gr, 1buc -14%

Plumb Jaxon Monturi Catfish 200gr, 1buc

ck-ac200
Livrare imediată!

26,00Lei(-14%) 22,25Lei

Plumb Jigging Jaxon 25gr 2buc/plic -8%

Plumb Jigging Jaxon 25gr 2buc/plic

ce-ab25
Livrare imediată!

4,60Lei(-8%) 4,25Lei

Plumb Korda Cubic Cu Vartej 113g -11%

Plumb Korda Cubic Cu Vartej 113g

a3.ksqp4
Livrare imediată!

9,79Lei(-11%) 8,68Lei

Plumb Korda Cubic Cu Vartej 99g -11%

Plumb Korda Cubic Cu Vartej 99g

a3.ksqp35
Livrare imediată!

9,35Lei(-11%) 8,32Lei

Plumb Korum Bait Gripper Lead 30g -42%
Exclusiv online!

Plumb Korum Bait Gripper Lead 30g

k0310145
Livrare 7-14 zile

13,99Lei(-42%) 8,11Lei

Plumb Longcast Jaxon Cu Vartej Maro 90gr -17%
Exclusiv online!

Plumb Longcast Jaxon Cu Vartej Maro 90gr

cp-003290
Livrare 48-72 ore

8,70Lei(-17%) 7,20Lei

Plumb Longcast Jaxon Cu Vartej Verde 90gr -17%
Exclusiv online!

Plumb Longcast Jaxon Cu Vartej Verde 90gr

cp-003290g
Livrare 48-72 ore

8,70Lei(-17%) 7,20Lei

Plumb Longcast Jaxon Inline Maro 130gr -21%
Exclusiv online!

Plumb Longcast Jaxon Inline Maro 130gr

cp-0033130
Livrare 48-72 ore

12,00Lei(-21%) 9,53Lei

Plumb Longcast Jaxon Inline Maro 70gr -16%

Plumb Longcast Jaxon Inline Maro 70gr

cp-003370
Livrare imediată!

8,00Lei(-16%) 6,69Lei

Afişare 7221 - 7240 din 9296 (465 pagini)
Queries: 5, Total time: 623.965 ms [By time] [By id] [By file]
1 (0.151)
SELECT data
FROM `oc_session`
WHERE session_id = '9ac764e7c3d82e810b05d6ae24'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (284.448)
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 (339.140)
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 7220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.121)
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