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


Fir Asso Invisilk Pink 0.20 mm 300 m

Fir Asso Invisilk Pink 0.20 mm 300 m

602080040
Livrare imediată!

31,83Lei

FIR LINEAEFFE NOBU PRO CAST ORANGE 0.225MM/6.8KG 250M -20%
Exclusiv online!

FIR LINEAEFFE NOBU PRO CAST ORANGE 0.225MM/6.8KG 250M

l.3700722
Livrare 24-48 ore

22,73Lei(-20%) 18,18Lei

FIR MONOFILAMENT GAMAKATSU G-LINE NEO 022MM/4,5KG/150M
Exclusiv online!

FIR MONOFILAMENT GAMAKATSU G-LINE NEO 022MM/4,5KG/150M

gk.5137.022
Livrare 24-48 ore

41,10Lei

FIR COLMIC MIMETIX 50M 0.123mm
Exclusiv online!

FIR COLMIC MIMETIX 50M 0.123mm

nymi123
Livrare 48-72 ore

30,00Lei

Fir textil Jaxon Black Horse PE8X Fluo 0.20mm 22kg 125m
Exclusiv online!

Fir textil Jaxon Black Horse PE8X Fluo 0.20mm 22kg 125m

zj-bhf020g
Livrare 48-72 ore

118,00Lei

Fir fluorocarbon Climax CULT CHIMERA SOFT FLUOROCARBON HOOKLINK 20m 0.50mm 30lb
Exclusiv online!

Fir fluorocarbon Climax CULT CHIMERA SOFT FLUOROCARBON HOOKLINK 20m 0.50mm 30lb

8700-10001-050
Livrare 48-72 ore

42,99Lei

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.180MM
Exclusiv online!

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.180MM

725180
Livrare 48-72 ore

36,00Lei

Fir ENERGO TEAM Carp Hunter Feeder 150m 0.18mm 3.90kg

Fir ENERGO TEAM Carp Hunter Feeder 150m 0.18mm 3.90kg

30040118
Livrare imediată!

7,50Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.37mm 10.40kg Fluo Pink -25%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.37mm 10.40kg Fluo Pink

cz7039
Livrare imediată!

72,99Lei(-25%) 54,80Lei

Fir Quantum Salsa Rosu Transparent 0.18mm, 275m

Fir Quantum Salsa Rosu Transparent 0.18mm, 275m

2611118
Livrare imediată!

44,78Lei

Fir Carp Expert Fluorocarbon Transparent 0.30mm 50m

Fir Carp Expert Fluorocarbon Transparent 0.30mm 50m

30025030
Livrare imediată!

30,00Lei

FIR JAXON MONOLITH PREMIUM 0.30mm 150m

FIR JAXON MONOLITH PREMIUM 0.30mm 150m

zj-hop030a
Livrare imediată!

24,00Lei

FIR SPRO FLUOROCARBON LEADER 10M 0.55MM 16 KG -24%
Exclusiv online!

FIR SPRO FLUOROCARBON LEADER 10M 0.55MM 16 KG

004630-00055-00000
Livrare 48-72 ore

42,00Lei(-24%) 31,90Lei

Fir ASSO Ultra Cast Galben Fluo 0.26mm
Exclusiv online!

Fir ASSO Ultra Cast Galben Fluo 0.26mm

602080002
Livrare 48-72 ore

32,83Lei

Fir Delphin FIN FLR CARBON Fluorocarbon 20m 0.90mm 66.1lbs -40%

Fir Delphin FIN FLR CARBON Fluorocarbon 20m 0.90mm 66.1lbs

500705090
Livrare imediată!

78,50Lei(-40%) 47,01Lei

Fir Monofilament Carp Expert UV Purple 300m 0.20mm 5.40kg

Fir Monofilament Carp Expert UV Purple 300m 0.20mm 5.40kg

30121020
Livrare imediată!

20,00Lei

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 600M 0.14MM
Exclusiv online!

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 600M 0.14MM

670014
Livrare 48-72 ore

36,00Lei

Fir Textil Jaxon SUMATO PREMIUM 10m 0.16mm

Fir Textil Jaxon SUMATO PREMIUM 10m 0.16mm

zj-rap016c
Livrare imediată!

11,00Lei

Fir Textil Lazer Elite Braid 0.10MM 10M -20%

Fir Textil Lazer Elite Braid 0.10MM 10M

1025110
Livrare imediată!

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

FIR VARIVAS NEW HIGH GRADE PE 150M 13.1lb -20%

FIR VARIVAS NEW HIGH GRADE PE 150M 13.1lb

v201501
Livrare imediată!

110,00Lei(-20%) 88,00Lei

Afişare 4181 - 4200 din 9514 (476 pagini)
Queries: 5, Total time: 229.517 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '49e6c77cb616e3ba5be38c35ff'
/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 (196.252)
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 = '3' AND (MATCH(pd.tag) AGAINST('+fir' 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 (32.980)
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 4180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.138)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38