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 Delphin FIN Method SPIN 300m Gri 0.16mm -50%
Exclusiv online!

Fir Delphin FIN Method SPIN 300m Gri 0.16mm

500660416
Livrare 48-72ore

22,00Lei(-50%) 10,90Lei

Fir Inaintas Cralusso Monofilament Brutal 50m 0.10mm 1.65kg
Exclusiv online!

Fir Inaintas Cralusso Monofilament Brutal 50m 0.10mm 1.65kg

33902100
Livrare 24-48 ore

25,00Lei

FIR LAZER PRO 30M 0.20 10BUC/SET -20%
Exclusiv online!

FIR LAZER PRO 30M 0.20 10BUC/SET

5056
Livrare 48-72 ore

9,20Lei(-20%) 7,35Lei

Fir Delphin FIN Method SPIN 300m Gri 0.12mm

Fir Delphin FIN Method SPIN 300m Gri 0.12mm

500660412
Livrare imediată!

22,00Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 014MM 1.3KG 50M

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 014MM 1.3KG 50M

d.12940.014
Livrare imediată!

32,34Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.18MM 2.30KG 50M -8%
Exclusiv online!

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.18MM 2.30KG 50M

d.12940.018
Livrare 24-48 ore

35,27Lei(-8%) 32,34Lei

Fir monofilament Climax FIR HYPER SPINNING FLUO ICE 150m 0.28mm -25%

Fir monofilament Climax FIR HYPER SPINNING FLUO ICE 150m 0.28mm

8562-10150-028
Livrare imediată!

27,00Lei(-25%) 20,30Lei

Fir Inaintas Cralusso Monofilament Brutal 50m 0.12mm 2.42kg

Fir Inaintas Cralusso Monofilament Brutal 50m 0.12mm 2.42kg

33902120
Livrare imediată!

25,00Lei

Fir Elastic Daiwa N Zon Power Gum 1.0mm 8kg 10m

Fir Elastic Daiwa N Zon Power Gum 1.0mm 8kg 10m

d.13306.001
Livrare imediată!

20,43Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.33MM 7.40KG 50M -15%

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.33MM 7.40KG 50M

d.12940.033
Livrare imediată!

40,56Lei(-15%) 34,41Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.16MM 1.9KG 50M
Exclusiv online!

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.16MM 1.9KG 50M

d.12940.016
Livrare 24-48 ore

32,34Lei

Fir Inaintas Cralusso Monofilament Brutal 50m 0.14mm 3.18kg

Fir Inaintas Cralusso Monofilament Brutal 50m 0.14mm 3.18kg

33902140
Livrare imediată!

24,00Lei

FIR MONOFILAMENT LAZER TORNADO 200M 0.30MM

FIR MONOFILAMENT LAZER TORNADO 200M 0.30MM

laz-00000440
Livrare imediată!

33,80Lei

Fir fluorocarbon Climax FIR CLIMAX FLUOROCARBON 50m 0.14mm 1.7kg

Fir fluorocarbon Climax FIR CLIMAX FLUOROCARBON 50m 0.14mm 1.7kg

8100-10050-014
Livrare imediată!

20,00Lei

FIR LAZER PRO 30M 0.16 10BUC/SET -20%
Exclusiv online!

FIR LAZER PRO 30M 0.16 10BUC/SET

5054
Livrare 48-72 ore

6,60Lei(-20%) 5,28Lei

Fir monofilament Climax FIR MAX MONO CLEAR 100m 0.10mm -24%

Fir monofilament Climax FIR MAX MONO CLEAR 100m 0.10mm

8721-10100-010
Livrare imediată!

22,50Lei(-24%) 17,01Lei

Fir Inaintas Cralusso Monofilament Brutal 50m 0.20mm 5.93kg
Exclusiv online!

Fir Inaintas Cralusso Monofilament Brutal 50m 0.20mm 5.93kg

33902200
Livrare 24-48 ore

20,80Lei

FIR LINEAEFFE FLUOROCARBON COATED HIKARU ULTRA 0,14MM/3KG/150M
Exclusiv online!

FIR LINEAEFFE FLUOROCARBON COATED HIKARU ULTRA 0,14MM/3KG/150M

l.3400014
Livrare 24-48 ore

20,33Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.35MM 8.100KG 50M -8%

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.35MM 8.100KG 50M

d.12940.035
Livrare imediată!

42,52Lei(-8%) 39,00Lei

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.23MM 4.30KG 50M -8%

FIR MONOFILAMENT DAIWA TOURNAMENT FC LEADER 0.23MM 4.30KG 50M

d.12940.023
Livrare imediată!

35,27Lei(-8%) 32,34Lei

Afişare 701 - 720 din 1428 (72 pagini)
Queries: 6, Total time: 52.254 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = '12d41b1f39d81c61b39e64280f'
/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 (46.066)
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('+fire +varga +bolo' 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 (5.674)
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 700, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.139)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"MOSS INDISPONIBIL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.137)
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