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 Fox Paste Bomb Cu Vartej 2.5oz 71gr -22%
Exclusiv online!

Plumb Fox Paste Bomb Cu Vartej 2.5oz 71gr

cld182
Stoc epuizat

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%

Plumb Korum Bait Gripper Lead 30g

k0310145
Livrare imediată!

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%
Exclusiv online!

Plumb Longcast Jaxon Inline Maro 70gr

cp-003370
Livrare 48-72 ore

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

Plumb Longcast Jaxon Inline Verde 110gr 1buc/plic -20%

Plumb Longcast Jaxon Inline Verde 110gr 1buc/plic

cp-0033110g
Livrare imediată!

11,00Lei(-20%) 8,83Lei

Plumb Longcast Jaxon Inline Verde 90gr 1buc/plic -18%

Plumb Longcast Jaxon Inline Verde 90gr 1buc/plic

cp-003390g
Livrare imediată!

9,00Lei(-18%) 7,41Lei

Plumb Prologic Flying Back 14g 2buc/pl -54%
Exclusiv online!

Plumb Prologic Flying Back 14g 2buc/pl

a3.pro.57138
Livrare 24-48 ore

18,59Lei(-54%) 8,55Lei

Plumb Prologic Flying Back 7g 2buc/pl -53%
Exclusiv online!

Plumb Prologic Flying Back 7g 2buc/pl

a3.pro.57139
Livrare 24-48 ore

16,83Lei(-53%) 7,85Lei

Plumb Tip Betisor Delphin Drop Shot Bomb 5buc Plic 14gr -26%

Plumb Tip Betisor Delphin Drop Shot Bomb 5buc Plic 14gr

965926014
Livrare imediată!

15,00Lei(-26%) 11,07Lei

Plumb Tip Betisor Delphin Drop Shot Bomb 5buc Plic 18gr -39%

Plumb Tip Betisor Delphin Drop Shot Bomb 5buc Plic 18gr

965926018
Livrare imediată!

18,00Lei(-39%) 11,07Lei

Plumbi Colmic Oliveta Jaz 9.00gr -19%

Plumbi Colmic Oliveta Jaz 9.00gr

toj0900
Livrare imediată!

17,00Lei(-19%) 13,71Lei

Afişare 7161 - 7180 din 9196 (460 pagini)
Queries: 5, Total time: 768.950 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '91a83ff312dfecff21bcd511e4'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.132)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (373.421)
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 = '0' 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 (395.163)
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 = '0' 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 7160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.112)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37