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 FEEDER COLMIC PRO AT70 250M 0.188MM
Exclusiv online!

FIR FEEDER COLMIC PRO AT70 250M 0.188MM

nyfep0188
Livrare 48-72 ore

42,00Lei

Fir monofilament Lineaeffe Carp Top Smoke Green 0.22mm/5.0kg/1200m

Fir monofilament Lineaeffe Carp Top Smoke Green 0.22mm/5.0kg/1200m

l.3001406
Livrare imediată!

20,83Lei

FIR MONOFILAMENT MAVER ZERO G3 SMART 1000M 0.205MM -50%
Exclusiv online!

FIR MONOFILAMENT MAVER ZERO G3 SMART 1000M 0.205MM

640205
Livrare 48-72 ore

101,00Lei(-50%) 50,50Lei

FIR MONOFILAMENT SUFIX ULTRA KNOT Yellow Orange 0.305MM 1195M

FIR MONOFILAMENT SUFIX ULTRA KNOT Yellow Orange 0.305MM 1195M

ds1uk0300sapbp
Livrare imediată!

99,00Lei

Fir monofilament Trabucco T-Force Pro Carp 0.30mm/11.95kg/300m

Fir monofilament Trabucco T-Force Pro Carp 0.30mm/11.95kg/300m

053-15-300
Livrare imediată!

42,00Lei

FIR MONOFILAMENT MIVARDI CARBON CARP 0.285mm/600m/9.40kg

FIR MONOFILAMENT MIVARDI CARBON CARP 0.285mm/600m/9.40kg

miv-lcc6028
Livrare imediată!

79,99Lei

FIR COLMIC HERAKLES XS SPINNING NX50 150M 0.230mm
Exclusiv online!

FIR COLMIC HERAKLES XS SPINNING NX50 150M 0.230mm

nyhkxs023
Livrare 48-72 ore

32,00Lei

FIR HALDORADO LONG CAST TEAM FEEDER 300M 0.25MM

FIR HALDORADO LONG CAST TEAM FEEDER 300M 0.25MM

3252-325
Livrare imediată!

30,20Lei

FIR JAXON CARAT CRAP 600M 0.25mm
Exclusiv online!

FIR JAXON CARAT CRAP 600M 0.25mm

zj-kac025d
Livrare 48-72 ore

50,00Lei

Fir ASSO Ultra Molecular Shield Dark Green 0.28mm 300m
Exclusiv online!

Fir ASSO Ultra Molecular Shield Dark Green 0.28mm 300m

602080012
Livrare 48-72 ore

41,72Lei

FIR JAXON CROCODILE CARP 300m 0.32mm

FIR JAXON CROCODILE CARP 300m 0.32mm

zj-crc032b
Livrare imediată!

27,00Lei

FIR MONOFILAMENT TRABUCCO MAX PLUS LINE CARP 1000MT 0.30MM

FIR MONOFILAMENT TRABUCCO MAX PLUS LINE CARP 1000MT 0.30MM

057-18-300
Livrare imediată!

62,00Lei

FIR JAXON ETERNUM CRAP 600m 0.32mm -30%

FIR JAXON ETERNUM CRAP 600m 0.32mm

zj-etc032d
Livrare imediată!

48,00Lei(-30%) 33,61Lei

FIR JAXON CARAT CRAP 300M 0.25mm
Exclusiv online!

FIR JAXON CARAT CRAP 300M 0.25mm

zj-kac025b
Livrare 48-72 ore

30,00Lei

Fir Monofilament Jaxon Satori Spinning 150m, 0.30mm, 18kg -22%

Fir Monofilament Jaxon Satori Spinning 150m, 0.30mm, 18kg

zj-sar030a
Livrare imediată!

23,00Lei(-22%) 17,90Lei

Fir monofilament Trabucco T-Force Pro Carp 0.25mm/8.36kg/300m

Fir monofilament Trabucco T-Force Pro Carp 0.25mm/8.36kg/300m

053-15-250
Livrare imediată!

42,00Lei

FIR COLMIC ATOMIC 500M 0.22mm
Exclusiv online!

FIR COLMIC ATOMIC 500M 0.22mm

nyat622
Livrare 48-72 ore

24,00Lei

FIR MONOFILAMENT VARIVAS DEAD OR ALIVE FLUOROCARBON 150M 0.148MM 3LB -22%

FIR MONOFILAMENT VARIVAS DEAD OR ALIVE FLUOROCARBON 150M 0.148MM 3LB

v3815003
Livrare imediată!

93,00Lei(-22%) 72,59Lei

Fir Asso Invisilk Pink 0.22 mm 300 m

Fir Asso Invisilk Pink 0.22 mm 300 m

602080041
Livrare imediată!

32,69Lei

FIR MONOFILAMENT VARIVAS DEAD OR ALIVE BROWN 150M 0.405MM 20LB -30%
Exclusiv online!

FIR MONOFILAMENT VARIVAS DEAD OR ALIVE BROWN 150M 0.405MM 20LB

v3715020
Livrare 48-72 ore

49,00Lei(-30%) 34,30Lei

Afişare 1321 - 1340 din 4625 (232 pagini)
Queries: 4, Total time: 109.227 ms [By time] [By id] [By file]
1 (0.205)
SELECT data
FROM `oc_session`
WHERE session_id = '592af8ba0411d699c401e965ec'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (108.755)
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('+monofilament' 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 (0.158)
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