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 textil Jaxon Black Horse PE8X Premium 0.12mm/10kg/125m

Fir textil Jaxon Black Horse PE8X Premium 0.12mm/10kg/125m

zj-bhp012g
Stoc epuizat

127,00Lei

PENAR JAXON INAINTAS 26CM

PENAR JAXON INAINTAS 26CM

ac-8888b
Stoc epuizat

60,00Lei

INAINTAS MUSCA JAXON CONIC 270CM 0.182-0.53MM

INAINTAS MUSCA JAXON CONIC 270CM 0.182-0.53MM

nm-19ft4x
Stoc epuizat

12,00Lei

Fir textil Jaxon Black Horse PE8X Premium 0.22mm/25kg/125m

Fir textil Jaxon Black Horse PE8X Premium 0.22mm/25kg/125m

zj-bhp022g
Stoc epuizat

107,00Lei

FIR JAXON TEXTIL SUMATO PREMIUM 200m 0.28mm 33.00 kg

FIR JAXON TEXTIL SUMATO PREMIUM 200m 0.28mm 33.00 kg

zj-rap028b
Stoc epuizat

115,00Lei

FIR JAXON TEXTIL SUMATO PREMIUM 200m 0.16mm

FIR JAXON TEXTIL SUMATO PREMIUM 200m 0.16mm

zj-rap016b
Stoc epuizat

115,00Lei

FIR STRATEGY SNAG AND SHOCK LEADER 80M 0.55 MM 19 KG

FIR STRATEGY SNAG AND SHOCK LEADER 80M 0.55 MM 19 KG

005820-00106-00000
Stoc epuizat

44,80Lei

Fir textil Jaxon Black Horse PE8X Premium 0.25mm/28kg/125m

Fir textil Jaxon Black Horse PE8X Premium 0.25mm/28kg/125m

zj-bhp025g
Stoc epuizat

107,00Lei

FIR STRATEGY SNAG AND SHOCK LEADER 80M 0.47 MM 14 KG

FIR STRATEGY SNAG AND SHOCK LEADER 80M 0.47 MM 14 KG

005820-00105-00000
Stoc epuizat

44,80Lei

Fir Daiwa Monofilament TN SW Shock Leader, 0.80mm 40.30kg 50m

Fir Daiwa Monofilament TN SW Shock Leader, 0.80mm 40.30kg 50m

d.12957.080
Stoc epuizat

43,20Lei

Fir Inaintas Conic P-Line Konico 0.23mm-0.57mm, 5x15m/75m

Fir Inaintas Conic P-Line Konico 0.23mm-0.57mm, 5x15m/75m

750187453
Stoc epuizat

48,00Lei

FIR JAXON TEXTIL SUMATO PREMIUM 200m 0.22mm

FIR JAXON TEXTIL SUMATO PREMIUM 200m 0.22mm

zj-rap022b
Stoc epuizat

115,00Lei

FIR JAXON TEXTIL SUMATO PREMIUM 200m 0.32mm

FIR JAXON TEXTIL SUMATO PREMIUM 200m 0.32mm

zj-rap032b
Stoc epuizat

115,00Lei

Fir Textil Momoi Ryujin PE Braided, Moss Green, 34kg, 0.22mm, 130m

Fir Textil Momoi Ryujin PE Braided, Moss Green, 34kg, 0.22mm, 130m

ryu022mg
Stoc epuizat

110,00Lei

Fluocarbon FOX Edges Illusion Leader 50m 0.50mm 13.64 kg

Fluocarbon FOX Edges Illusion Leader 50m 0.50mm 13.64 kg

cac604
Stoc epuizat

94,46Lei

FIR TEXTIL JAXON BLACK HORSE PE 8X PREMIUM 125m 0.08mm 5kg

FIR TEXTIL JAXON BLACK HORSE PE 8X PREMIUM 125m 0.08mm 5kg

zj-bhp008g
Stoc epuizat

127,00Lei

Fir textil P-Line XTCB Braid 8 0.23MM

Fir textil P-Line XTCB Braid 8 0.23MM

750190023
Stoc epuizat

121,00Lei

FIR TEXTIL Delphin HotSPOD 8 portocaliu 0.14mm 9.60kg 300m -21%

FIR TEXTIL Delphin HotSPOD 8 portocaliu 0.14mm 9.60kg 300m

101001634
Stoc epuizat

96,00Lei(-21%) 76,10Lei

Fluocarbon FOX Edges Illusion Leader 50m 0.40mm 9.1 kg

Fluocarbon FOX Edges Illusion Leader 50m 0.40mm 9.1 kg

cac603
Livrare imediată!

94,46Lei

Fir Inaintas P-LINE CXX LEADER MATERIAL 50 M 0.188 MM CRYSTAL CLEAR

Fir Inaintas P-LINE CXX LEADER MATERIAL 50 M 0.188 MM CRYSTAL CLEAR

750186290
Stoc epuizat

12,00Lei

Afişare 661 - 680 din 738 (37 pagini)
Queries: 6, Total time: 19.243 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '3917fc9e56d6cece7a7d1fc465'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (18.580)
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('+inaintas' 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.181)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"P-LINE EUROPE S.R.L"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.125)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"P-LINE EUROPE S.R.L"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.140)
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