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 - cahkbr54

Produse ce potrivesc criteriilor de căutare


Spinnertail Profi Blinker Spinner Jig Fish, Fluo Fire Tiger, 10g -20%

Spinnertail Profi Blinker Spinner Jig Fish, Fluo Fire Tiger, 10g

125f10
Livrare imediată!

26,50Lei(-20%) 21,21Lei

Fir Fluorocarbon Spro Reload Freestyle 0.26mm/4.25kg/15m -29%

Fir Fluorocarbon Spro Reload Freestyle 0.26mm/4.25kg/15m

005143-00026-00000
Livrare imediată!

25,20Lei(-29%) 17,99Lei

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

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 600M 0.20MM

670020
Livrare 48-72 ore

42,99Lei

FIR JAXON CROCODILE SPINNING 150m 0.35mm

FIR JAXON CROCODILE SPINNING 150m 0.35mm

zj-crs035a
Livrare imediată!

15,51Lei

FIR COLMIC BLADE SINKING AT70 150M 0.148MM -18%

FIR COLMIC BLADE SINKING AT70 150M 0.148MM

nybl0148
Livrare imediată!

28,00Lei(-18%) 22,90Lei

FIR MONOFILAMENT MAVER SMART GENESIS 1000M 0.14MM -50%
Exclusiv online!

FIR MONOFILAMENT MAVER SMART GENESIS 1000M 0.14MM

681014
Livrare 48-72 ore

70,00Lei(-50%) 35,00Lei

LINGURA JAXON ALGA FIR 2D 16GR -30%
Exclusiv online!

LINGURA JAXON ALGA FIR 2D 16GR

bw-jaf2d
Livrare 48-72 ore

12,40Lei(-30%) 8,70Lei

FIR MONOFILAMENT TRABUCCO MAX PLUS LINE ALLROUND /150mt 0,45MM -27%

FIR MONOFILAMENT TRABUCCO MAX PLUS LINE ALLROUND /150mt 0,45MM

057-00-450
Livrare imediată!

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

FIR MAVER ZERO FLUOROCARBON 50M 0.386MM
Exclusiv online!

FIR MAVER ZERO FLUOROCARBON 50M 0.386MM

732386
Livrare 48-72 ore

66,00Lei

FIR COLMIC OMEGA PT50 300M 0.18mm Galben Fluo
Exclusiv online!

FIR COLMIC OMEGA PT50 300M 0.18mm Galben Fluo

nyome018
Livrare 48-72 ore

34,00Lei

FIR MONOFILAMENT MAVER ELIT LUMINEX 100M 0.225MM -50%
Exclusiv online!

FIR MONOFILAMENT MAVER ELIT LUMINEX 100M 0.225MM

726225
Livrare 48-72 ore

58,50Lei(-50%) 29,20Lei

FIR MONOFILAMENT PROLOGIC XLNT HP CAMO 025MM/4,8KG/1000M -23%

FIR MONOFILAMENT PROLOGIC XLNT HP CAMO 025MM/4,8KG/1000M

a.pro.44690
Livrare imediată!

53,36Lei(-23%) 40,90Lei

PILKER SPRO CAST X FIRETIGER 40GR

PILKER SPRO CAST X FIRETIGER 40GR

004500-00505-00000
Livrare imediată!

17,90Lei

Fir textil Jaxon Black Horse PE8X Premium 0.14mm/15kg/125m
Exclusiv online!

Fir textil Jaxon Black Horse PE8X Premium 0.14mm/15kg/125m

zj-bhp014g
Livrare 48-72 ore

118,00Lei

FIR JAXON CARAT SPINNING 150m 0.40mm
Exclusiv online!

FIR JAXON CARAT SPINNING 150m 0.40mm

zj-kas040a
Livrare 48-72 ore

21,50Lei

Fir Monofilament Carp Zoom Crap Bull-Dog Dark Green, 1000m, 0.25mm, 8.8kg

Fir Monofilament Carp Zoom Crap Bull-Dog Dark Green, 1000m, 0.25mm, 8.8kg

cz3483
Livrare imediată!

47,01Lei

FIR TEXTIL FAVORITE SMART PE4X 1.2/0.19 150M VERDE -26%

FIR TEXTIL FAVORITE SMART PE4X 1.2/0.19 150M VERDE

16931026
Livrare imediată!

85,00Lei(-26%) 62,90Lei

FIR MONOFILAMENT ASSO SINKING 3X FEEDER - Brown 0.176mm 150m 2.6Kg
Exclusiv online!

FIR MONOFILAMENT ASSO SINKING 3X FEEDER - Brown 0.176mm 150m 2.6Kg

604080033
Livrare 48-72 ore

43,30Lei

FIR COLMIC PROJECT 360 NX30 100M 0.35mm
Exclusiv online!

FIR COLMIC PROJECT 360 NX30 100M 0.35mm

nypr10035
Livrare 48-72 ore

20,00Lei

FIR TEXTIL TRABUCCO DYNA TEX TEKNO SUPER BRAID DG 135M 0.128MM 12LB

FIR TEXTIL TRABUCCO DYNA TEX TEKNO SUPER BRAID DG 135M 0.128MM 12LB

054-21-120
Livrare imediată!

42,00Lei

Afişare 3581 - 3600 din 10732 (537 pagini)
Queries: 6, Total time: 1,100.364 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = 'dd46d4a6bb681071a4b257467d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.106)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (1,028.013)
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 (pd.tag LIKE "%fir%") 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:724
5 (71.912)
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 3580, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.151)
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