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 MONOFILAMENT STROFT COLOR GALBEN FLUO 028MM/6,7KG/100M

FIR MONOFILAMENT STROFT COLOR GALBEN FLUO 028MM/6,7KG/100M

st.9128y
Stoc epuizat

23,07Lei

FIR TEXTIL JAXON SUMATO FLUO 125m 0.28mm 33.00 kg
Exclusiv online!

FIR TEXTIL JAXON SUMATO FLUO 125m 0.28mm 33.00 kg

zj-raf028g
Livrare 48-72 ore

76,01Lei

FIR COLMIC HOLO SURF FLUO 300M 0.14mm -30%
Exclusiv online!

FIR COLMIC HOLO SURF FLUO 300M 0.14mm

nyho14
Livrare 48-72 ore

33,00Lei(-30%) 23,10Lei

FIR TEXTIL JAXON MONOLITH FLUO 125m 0.18mm -30%
Exclusiv online!

FIR TEXTIL JAXON MONOLITH FLUO 125m 0.18mm

zj-gof018g
Livrare 48-72 ore

103,99Lei(-30%) 72,80Lei

CAP JIG DAIWA PROREX FLEXI JIG-SYSTEM TG HEAD FLUO-PINK 7G 3BUC/PLIC

CAP JIG DAIWA PROREX FLEXI JIG-SYSTEM TG HEAD FLUO-PINK 7G 3BUC/PLIC

f2.15412.307
Stoc epuizat

26,85Lei

FIR TEXTIL JAXON SUMATO FLUO 125m 0.16mm
Exclusiv online!

FIR TEXTIL JAXON SUMATO FLUO 125m 0.16mm

zj-raf016g
Livrare 48-72 ore

76,01Lei

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 4.5lb 75m
Exclusiv online!

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 4.5lb 75m

v44075015
Livrare 48-72 ore

224,01Lei

FIR COLMIC IRIDE PT50 300M 0.22mm Orange Fluo
Exclusiv online!

FIR COLMIC IRIDE PT50 300M 0.22mm Orange Fluo

nyir022
Livrare 48-72 ore

45,01Lei

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

FIR COLMIC OMEGA PT50 300M 0.25mm Galben Fluo

nyome025
Livrare 48-72 ore

45,01Lei

Benzar Jelly Baits Maggot Fluo -20%

Benzar Jelly Baits Maggot Fluo

79475078
Stoc epuizat

13,60Lei(-20%) 10,88Lei

Fir Monofilament Carp Zoom Crap Bull-Dog Fluo, 300m, 0.28mm, 10.75kg
Exclusiv online!

Fir Monofilament Carp Zoom Crap Bull-Dog Fluo, 300m, 0.28mm, 10.75kg

cz2998
Livrare 48-72 ore

21,50Lei

FIR COLMIC IRIDE PT50 300M 0.16mm Orange Fluo
Exclusiv online!

FIR COLMIC IRIDE PT50 300M 0.16mm Orange Fluo

nyir016
Livrare 48-72 ore

32,00Lei

Fir Monofilament Carp Zoom Crap Bull-Dog Fluo, 300m, 0.25mm, 8.8kg
Exclusiv online!

Fir Monofilament Carp Zoom Crap Bull-Dog Fluo, 300m, 0.25mm, 8.8kg

cz0582
Livrare 48-72 ore

21,00Lei

Fir textil Jaxon Black Horse PE8X Fluo 0.16mm/17kg/125m
Exclusiv online!

Fir textil Jaxon Black Horse PE8X Fluo 0.16mm/17kg/125m

zj-bhf016g
Livrare 48-72 ore

118,00Lei

CAP JIG DAIWA PROREX FLEXI JIG-SYSTEM TG HEAD FLUO-PINK 4G 5BUC/PLIC

CAP JIG DAIWA PROREX FLEXI JIG-SYSTEM TG HEAD FLUO-PINK 4G 5BUC/PLIC

f2.15412.304
Stoc epuizat

29,35Lei

Fir ASSO Ultra Cast Verde Fluo 0.16mm 150m

Fir ASSO Ultra Cast Verde Fluo 0.16mm 150m

603080003
Stoc epuizat

15,37Lei

FIR TEXTIL JAXON SUMATO FLUO 125m 0.25mm
Exclusiv online!

FIR TEXTIL JAXON SUMATO FLUO 125m 0.25mm

zj-raf025g
Livrare 48-72 ore

76,01Lei

FIR MONOFILAMENT MAVER JURASSIC TOC FLUO 100M 0.165MM -30%
Exclusiv online!

FIR MONOFILAMENT MAVER JURASSIC TOC FLUO 100M 0.165MM

669165
Livrare 48-72 ore

13,30Lei(-30%) 9,31Lei

FIR MONOFILAMENT LINEAEFE TAKE XTREME FLUO 014MM/2,7KG 150M

FIR MONOFILAMENT LINEAEFE TAKE XTREME FLUO 014MM/2,7KG 150M

l.3300014
Stoc epuizat

19,41Lei

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 7lb 75m
Exclusiv online!

Fir textil Varivas Trout Area Master Limited PE Yellow Fluo 7lb 75m

v4407503
Livrare 48-72 ore

142,00Lei

Afişare 1001 - 1020 din 1271 (64 pagini)
Queries: 4, Total time: 27.353 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = '5d4534255692fb30448a168f84'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (26.973)
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('+fluo' 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.136)
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