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 300 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 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Tije Plumbi si Momitoare Inline, 3x200mm, 30buc/pac

Tije Plumbi si Momitoare Inline, 3x200mm, 30buc/pac

clm239747
Livrare imediată!

8,90Lei

Boilies Solubil de Carlig MAINLINE Shelf Life, Cell, 20mm, 1kg
Exclusiv online!

Boilies Solubil de Carlig MAINLINE Shelf Life, Cell, 20mm, 1kg

a0.m.m41003
Livrare 24-48 ore

74,98Lei

Boilies Solubil de Carlig MAINLINE Shelf Life, Link, 20mm, 1kg
Exclusiv online!

Boilies Solubil de Carlig MAINLINE Shelf Life, Link, 20mm, 1kg

a0.m.m41006
Livrare 24-48 ore

74,98Lei

Boilies Solubil de Carlig MAINLINE Shelf Life, Essential Cell, 20mm, 1kg
Exclusiv online!

Boilies Solubil de Carlig MAINLINE Shelf Life, Essential Cell, 20mm, 1kg

a0.m.m41004
Livrare 24-48 ore

74,98Lei

Momitor ZHEN LEADS MV2 50 GR

Momitor ZHEN LEADS MV2 50 GR

clm65220055
Livrare imediată!

4,32Lei

Momitor ZHEN LEADS MV2 Rotund Scurt 55 GR

Momitor ZHEN LEADS MV2 Rotund Scurt 55 GR

clm66220055
Livrare imediată!

5,36Lei

MONTURA ARROW PT.CRAP MOMITOR INLINE SOFT RIG 40G/NR4

MONTURA ARROW PT.CRAP MOMITOR INLINE SOFT RIG 40G/NR4

a.mpf23.40
Livrare imediată!

27,66Lei

CAMO FOX TADPOLE INLINE INSERTS

CAMO FOX TADPOLE INLINE INSERTS

cac771
Livrare imediată!

24,60Lei

Fir Asso Mainline Abrasion Red 0.28mm 1000m

Fir Asso Mainline Abrasion Red 0.28mm 1000m

110108fnasdi276bm1000310280
Livrare imediată!

63,09Lei

Fir, Asso, Mainline, Abrasion, Red, 0.35mm, 1000m, 110108fnasdi276bm1000310350, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Exclusiv online!

Fir, Asso, Mainline, Abrasion, Red, 0.35mm, 1000m, 110108fnasdi276bm1000310350, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso

110108fnasdi276bm1000310350
Livrare 48-72 ore

66,29Lei

Pop, Up, Mainline, Critic, Echilibrat, High, Impact, Balanced, Wafters, Ananas, 15mm, 60buc/borcan, a0.m.m23070, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Mainline, Mainline
Fir, Asso, Mainline, Abrasion, Red, 0.40mm, 1000m, 110108fnasdi276bm1000310400, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Exclusiv online!

Fir, Asso, Mainline, Abrasion, Red, 0.40mm, 1000m, 110108fnasdi276bm1000310400, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso

110108fnasdi276bm1000310400
Livrare 48-72 ore

78,69Lei

MOMITOR JAXON INLINE 50GR 100X30mm 10buc/set -30%

MOMITOR JAXON INLINE 50GR 100X30mm 10buc/set

av-sp150
Livrare imediată!

117,00Lei(-30%) 81,90Lei

PLUMB JAXON CRAP DIAMOND INLINE G VERDE 110GR -30%

PLUMB JAXON CRAP DIAMOND INLINE G VERDE 110GR

cp-0031110g
Livrare imediată!

11,00Lei(-30%) 7,70Lei

Fir Asso Mainline Pro Brown 0.28mm 1000m
Exclusiv online!

Fir Asso Mainline Pro Brown 0.28mm 1000m

110108fnasdi272bm1000870280
Livrare 48-72 ore

73,70Lei

Fir, Asso, Mainline, Abrasion, Multicolor, 0.30mm, 1000m, 110108fnasdi276bm1000a60300, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, Asso, Mainline, Abrasion, Red, 0.30mm, 1000m, 110108fnasdi276bm1000310300, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Exclusiv online!

Fir, Asso, Mainline, Abrasion, Red, 0.30mm, 1000m, 110108fnasdi276bm1000310300, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso

110108fnasdi276bm1000310300
Livrare 48-72 ore

64,58Lei

CAMO FOX DROP OFF INLINE LEAD KIT
Exclusiv online!

CAMO FOX DROP OFF INLINE LEAD KIT

cac782
Livrare 7-14 zile

33,71Lei

Fir, Asso, Mainline, Green, 0.30mm, 1000m, 110108fnasdi273bm10006o0300, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso

Fir, Asso, Mainline, Green, 0.30mm, 1000m, 110108fnasdi273bm10006o0300, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso

110108fnasdi273bm10006o0300
Livrare imediată!

59,42Lei

FIR Carp Zoom SKINLINE X4 20lb 15m Matt Brown
Exclusiv online!

FIR Carp Zoom SKINLINE X4 20lb 15m Matt Brown

cz3726
Livrare 48-72 ore

84,00Lei

Afişare 1 - 20 din 726 (37 pagini)
Queries: 9, Total time: 837.022 ms [By time] [By id] [By file]
1 (0.165)
SELECT data
FROM `oc_session`
WHERE session_id = '72bfbf538bfaf28a3c5398b95e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (384.248)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%inline%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.170)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%inline%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1014
6 (451.824)
SELECT COUNT(*) AS val, filter_group, filter_id
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%inline%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' AND f.filter_group NOT LIKE 'a%' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:923
7 (0.183)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.105)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.124)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38