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


Varga Kamasaki Roz cu Linie Echilibrata Kid 4.00M

Varga Kamasaki Roz cu Linie Echilibrata Kid 4.00M

11003403
Livrare imediată!

40,00Lei

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

Varga Trabucco Heaven TLS Extreme 5.00m

Varga Trabucco Heaven TLS Extreme 5.00m

134-41-050
Livrare imediată!

265,00Lei

Set Linii Nevis Complete 1.00g
Exclusiv online!

Set Linii Nevis Complete 1.00g

4120-100
Livrare 48-72 ore

10,00Lei

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

Varga Telescopica Daiwa Legalis 4m 160g

Varga Telescopica Daiwa Legalis 4m 160g

d.11761.400
Livrare imediată!

141,66Lei

FIR MONOFILAMENT LAZER TORNADO 200M 0.30MM

FIR MONOFILAMENT LAZER TORNADO 200M 0.30MM

laz-00000440
Livrare imediată!

33,80Lei

Set Linii Nevis Complete Model 3 1.00g
Exclusiv online!

Set Linii Nevis Complete Model 3 1.00g

4127-100
Livrare 48-72 ore

10,00Lei

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

Set Linii Nevis Complete Model 4 1.00g
Exclusiv online!

Set Linii Nevis Complete Model 4 1.00g

4128-100
Livrare 48-72 ore

10,00Lei

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

TRONSON VARGA TRABUCCO TITAN TLS POWER 5.00 MT
Exclusiv online!

TRONSON VARGA TRABUCCO TITAN TLS POWER 5.00 MT

lovba70007-1
Livrare 48-72 ore

53,30Lei

Afişare 1201 - 1220 din 2177 (109 pagini)
Queries: 5, Total time: 82.509 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = '3c960f88d6ea160dc0d5c20e73'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (67.158)
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('+varga' 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 (15.024)
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 1200, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.156)
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