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 90g

Plumb Delphin tip lacrima 90g

830514090
Livrare imediată!

9,00Lei

CARLIGE FUDO CHINU RING TEFLONATE NR 6 13BUC -20%
Exclusiv online!

CARLIGE FUDO CHINU RING TEFLONATE NR 6 13BUC

1107-6
Livrare 48-72ore

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

Fir Carp Expert UV 150m 0.25mm

Fir Carp Expert UV 150m 0.25mm

30118025
Livrare imediată!

12,00Lei

Fir Textil Jaxon SUMATO PREMIUM 10m 0.10mm

Fir Textil Jaxon SUMATO PREMIUM 10m 0.10mm

zj-rap010c
Livrare imediată!

11,00Lei

Carlige Fudo Maruseigo with Ring (MSGR-BN) nr.10 BN - Black Nickel 13 buc/plic -20%

Carlige Fudo Maruseigo with Ring (MSGR-BN) nr.10 BN - Black Nickel 13 buc/plic

3201-10
Livrare imediată!

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

Carlige Maruto 9624-BN Nr 6 10buc/plic
Exclusiv online!

Carlige Maruto 9624-BN Nr 6 10buc/plic

43452006
Livrare 24-48 ore

9,50Lei

CARLIGE MAVER KATANA SERIA CRAP 0.4B NR 10 BARBLESS
Exclusiv online!

CARLIGE MAVER KATANA SERIA CRAP 0.4B NR 10 BARBLESS

04bkca10
Livrare 48-72 ore

13,99Lei

FIR PROLOGIC LEADER MIMICRY GREEN HELO 0.50MM/15.6KG/100M

FIR PROLOGIC LEADER MIMICRY GREEN HELO 0.50MM/15.6KG/100M

a.pro.57091
Livrare imediată!

57,45Lei

Fir ASSO Ultra Molecular Shield White 0.26mm 150m

Fir ASSO Ultra Molecular Shield White 0.26mm 150m

604080053
Livrare imediată!

23,94Lei

Rig Strategy Position KD Gamakatasu Rig Nr.4 -27%

Rig Strategy Position KD Gamakatasu Rig Nr.4

008541-00404-00000
Livrare imediată!

13,49Lei(-27%) 9,90Lei

SCUFUNDATOR ENERGOTEAM FIR 50g
Exclusiv online!

SCUFUNDATOR ENERGOTEAM FIR 50g

79007450
Livrare 24-48 ore

6,50Lei

Tuburi Carp Zoom Rig Aligner F-Shape 10buc/plic Marimea S

Tuburi Carp Zoom Rig Aligner F-Shape 10buc/plic Marimea S

cz9576
Livrare imediată!

19,00Lei

Carlige Select Baits Curve Shank Hooks Nr.6

Carlige Select Baits Curve Shank Hooks Nr.6

sel-218021
Livrare imediată!

29,00Lei

Carlige Owner Izu Mezina 50673 Negru nr 3 - 15buc/plic

Carlige Owner Izu Mezina 50673 Negru nr 3 - 15buc/plic

5067304
Livrare imediată!

12,55Lei

Carlige VMC 7026 Mystic Carp Long Curve Shank Nr.4 -27%

Carlige VMC 7026 Mystic Carp Long Curve Shank Nr.4

7026 nt4
Livrare imediată!

23,00Lei(-27%) 16,90Lei

Fir Asso Ultra Cast Orange 0.20mm 1000m
Exclusiv online!

Fir Asso Ultra Cast Orange 0.20mm 1000m

110108100020
Livrare 48-72 ore

52,62Lei

Fir Textil Nevis Technology Dyneema 10m 0.14mm

Fir Textil Nevis Technology Dyneema 10m 0.14mm

5304-014
Livrare imediată!

8,40Lei

Fir textil CPK Silky Natural Feeder Hooklink Brown 0.16mm/8kg/15m

Fir textil CPK Silky Natural Feeder Hooklink Brown 0.16mm/8kg/15m

999961
Livrare imediată!

29,00Lei

Rig Fox Edges Wide Gape Beaked PVA Bag 2buc/plic Nr.6 20lbs

Rig Fox Edges Wide Gape Beaked PVA Bag 2buc/plic Nr.6 20lbs

ccr173
Livrare imediată!

21,56Lei

Carlig Owner C-5X Nr.10 Carp Iseama X With Eye 13buc/plic

Carlig Owner C-5X Nr.10 Carp Iseama X With Eye 13buc/plic

5326910
Livrare imediată!

14,88Lei

Afişare 4961 - 4980 din 10418 (521 pagini)
Queries: 6, Total time: 300.140 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '70d0959b5a5d02b747a19ac086'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (258.313)
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 (41.254)
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 4960, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.184)
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.179)
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