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

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Plumb Delphin tip lacrima cu tub 90g -20%

Plumb Delphin tip lacrima cu tub 90g

830512090
Livrare imediată!

9,00Lei(-20%) 7,20Lei

Fir Monofilament Cralusso Fluo Line Galben Fluorescent 150m 0.25mm 8.60kg

Fir Monofilament Cralusso Fluo Line Galben Fluorescent 150m 0.25mm 8.60kg

33906025
Livrare imediată!

28,00Lei

Plumb Culisant EnergoTeam Oval 115g
Exclusiv online!

Plumb Culisant EnergoTeam Oval 115g

59202115
Livrare 24-48 ore

7,00Lei

CARLIGE FUDO KOAJI ROUND NK NR.18 -18%

CARLIGE FUDO KOAJI ROUND NK NR.18

3600-18
Livrare imediată!

8,50Lei(-18%) 7,00Lei

Fir Fluorocarbon Guru Pure Fluorocarbon, 0,20MM/2,3KG/50M

Fir Fluorocarbon Guru Pure Fluorocarbon, 0,20MM/2,3KG/50M

a.gu.gfc20
Livrare imediată!

46,42Lei

Fir monofilament Climax CULT CRAP DEEP PURPLE 300m 0.32mm 7.70kg
Exclusiv online!

Fir monofilament Climax CULT CRAP DEEP PURPLE 300m 0.32mm 7.70kg

8701-10300-032
Livrare 48-72 ore

49,00Lei

Carlige Cralusso Carp Power TF 12buc 2470 nr 12
Exclusiv online!

Carlige Cralusso Carp Power TF 12buc 2470 nr 12

46610012
Livrare 24-48 ore

10,00Lei

MONTURA ARROW LEADCORE PB GRIPPA INLINE SOFT RIG NR4

MONTURA ARROW LEADCORE PB GRIPPA INLINE SOFT RIG NR4

a.mpdg06.100
Livrare imediată!

22,26Lei

Carlige Delphin HKD KEIRU NR.10

Carlige Delphin HKD KEIRU NR.10

622025010
Livrare imediată!

11,00Lei

Carlige Cralusso Anti Snag TF 8buc 2465 nr 4
Exclusiv online!

Carlige Cralusso Anti Snag TF 8buc 2465 nr 4

46609404
Livrare 24-48 ore

11,00Lei

Carlige Maruto Barbed 8356-BD BN Nr.4

Carlige Maruto Barbed 8356-BD BN Nr.4

43205004
Livrare imediată!

8,90Lei

CARLIGE FUDO CHIKA RING BN NR.17 -20%

CARLIGE FUDO CHIKA RING BN NR.17

4501-17
Livrare imediată!

10,00Lei(-20%) 8,00Lei

Carlig Teflonat Mivardi MTC Turn Down, 10buc/plic Nr.2
Exclusiv online!

Carlig Teflonat Mivardi MTC Turn Down, 10buc/plic Nr.2

m-acmtctd2
Livrare 48-72 ore

11,00Lei

CARLIGE FUDO MARUKAIZU SHORT BN NR.4 -20%

CARLIGE FUDO MARUKAIZU SHORT BN NR.4

3701-4
Livrare imediată!

10,00Lei(-20%) 8,00Lei

Minciog Nevis Predator 1.35m 50x45cm
Exclusiv online!

Minciog Nevis Predator 1.35m 50x45cm

4263-135
Livrare 48-72 ore

134,01Lei

MULINETA DAIWA WHISKER 25QDA 7RUL -30%

MULINETA DAIWA WHISKER 25QDA 7RUL

d.10930.025
Livrare imediată!

2.330,16Lei(-30%) 1.635,44Lei

Carlige Cralusso Carp Power TF 12buc 2470 nr 10
Exclusiv online!

Carlige Cralusso Carp Power TF 12buc 2470 nr 10

46610010
Livrare 24-48 ore

10,00Lei

CARLIGE FUDO CARP STG2 NR.10

CARLIGE FUDO CARP STG2 NR.10

2421-10
Livrare imediată!

10,00Lei

Carlige Fudo Marusode with Ring (MRSD-BN) nr.2 BN - Black Nickel 14 buc/plic -20%
Exclusiv online!

Carlige Fudo Marusode with Ring (MRSD-BN) nr.2 BN - Black Nickel 14 buc/plic

4401-2
Livrare 48-72ore

10,00Lei(-20%) 8,00Lei

Fir monofilament Climax CULT CRAP DEEP PURPLE 300m 0.30mm 7.10kg
Exclusiv online!

Fir monofilament Climax CULT CRAP DEEP PURPLE 300m 0.30mm 7.10kg

8701-10300-030
Livrare 48-72 ore

49,00Lei

Afişare 6241 - 6260 din 10421 (522 pagini)
Queries: 6, Total time: 281.822 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = '5ee718dd777cde9ec9f1273ce6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.068)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (240.613)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
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)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+crap' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
4 (40.690)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
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 match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 6240, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.177)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.189)
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