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


STRUNE PROFI BLINKER WOLFRAM 30CM 15KG 20 BUC
Exclusiv online!

STRUNE PROFI BLINKER WOLFRAM 30CM 15KG 20 BUC

617b15
Livrare 48-72 ore

64,00Lei

Strune Nevis Wolfram 20cm 10kg Gri

Strune Nevis Wolfram 20cm 10kg Gri

8521-120
Livrare imediată!

5,70Lei

PLUTA CRALUSSO WOLFRAM MATCH 14g
Exclusiv online!

PLUTA CRALUSSO WOLFRAM MATCH 14g

61933214
Livrare 24-48 ore

36,50Lei

MORMISTE, JAXON, WOLFRAM, PA025, C, 0.2G, , mw-pa025c, Carlige Musca, Carlige Musca Jaxon, Jaxon
Exclusiv online!

MORMISTE, JAXON, WOLFRAM, PA025, C, 0.2G, , mw-pa025c, Carlige Musca, Carlige Musca Jaxon, Jaxon

mw-pa025c
Livrare 48-72 ore

70,00Lei

Strune Nevis Wolfram 25cm 10kg Gri

Strune Nevis Wolfram 25cm 10kg Gri

8521-125
Livrare imediată!

5,70Lei

Strune Nevis Wolfram 20cm 5kg
Exclusiv online!

Strune Nevis Wolfram 20cm 5kg

8520-020
Livrare 48-72 ore

8,79Lei

Strune Nevis Wolfram 20cm 10kg
Exclusiv online!

Strune Nevis Wolfram 20cm 10kg

8520-120
Livrare 48-72 ore

8,79Lei

Strune, Nevis, Wolfram, 15cm, 5kg, Gri, 8521-015, Strune, Strune Nevis, Nevis

Strune, Nevis, Wolfram, 15cm, 5kg, Gri, 8521-015, Strune, Strune Nevis, Nevis

8521-015
Livrare imediată!

5,70Lei

Strune Nevis Wolfram 15cm 5kg
Exclusiv online!

Strune Nevis Wolfram 15cm 5kg

8520-015
Livrare 48-72 ore

8,79Lei

Strune Nevis Wolfram 20cm 5kg Gri

Strune Nevis Wolfram 20cm 5kg Gri

8521-020
Livrare imediată!

5,70Lei

Strune, Nevis, Wolfram, 25cm, 15kg, 8520-525, Strune, Strune Nevis, Nevis
Exclusiv online!

Strune, Nevis, Wolfram, 25cm, 15kg, 8520-525, Strune, Strune Nevis, Nevis

8520-525
Livrare 48-72 ore

8,79Lei

STRUNA MUSTAD WOLFRAM 20CM/20LB 3BUC/PL

STRUNA MUSTAD WOLFRAM 20CM/20LB 3BUC/PL

a7.mwl0069
Livrare imediată!

12,38Lei

Strune, Nevis, Wolfram, 25cm, 10kg, 8520-125, Strune, Strune Nevis, Nevis
Exclusiv online!

Strune, Nevis, Wolfram, 25cm, 10kg, 8520-125, Strune, Strune Nevis, Nevis

8520-125
Livrare 48-72 ore

8,79Lei

PLUTA CRALUSSO WOLFRAM MATCH 10g

PLUTA CRALUSSO WOLFRAM MATCH 10g

61933210
Livrare imediată!

50,00Lei

Strune Wolfram Wizard Stiuca 10x15cm 10x22cm Si 10x30cm 30buc
Exclusiv online!

Strune Wolfram Wizard Stiuca 10x15cm 10x22cm Si 10x30cm 30buc

82008100
Livrare 24-48 ore

41,00Lei

Montura Wolfram EnergoTeam cu Ancora 9 9kg
Exclusiv online!

Montura Wolfram EnergoTeam cu Ancora 9 9kg

82008339
Livrare 24-48 ore

6,00Lei

Strune Wizard Wolfram 15-20-25cm 30buc
Exclusiv online!

Strune Wizard Wolfram 15-20-25cm 30buc

82008933
Livrare 24-48 ore

63,00Lei

Strune Wizard Wolfram Cu Carlige Duble 6 6kg 2buc
Exclusiv online!

Strune Wizard Wolfram Cu Carlige Duble 6 6kg 2buc

82008326
Livrare 24-48 ore

6,00Lei

Struna, L&K, Wolfram, Leader, 35cm, 10kg, 2buc, 82017135, Strune, Strune L&K, L&K
Exclusiv online!

Struna, L&K, Wolfram, Leader, 35cm, 10kg, 2buc, 82017135, Strune, Strune L&K, L&K

82017135
Livrare 24-48 ore

10,00Lei

Struna, L&K, Wolfram, Leader, 25cm, 10kg, 2buc, 82017125, Strune, Strune L&K, L&K
Exclusiv online!

Struna, L&K, Wolfram, Leader, 25cm, 10kg, 2buc, 82017125, Strune, Strune L&K, L&K

82017125
Livrare 24-48 ore

9,00Lei

Afişare 141 - 160 din 203 (11 pagini)
Queries: 5, Total time: 179.171 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = '92d8df030cf99eec8781df2d5b'
/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:427
3 (177.772)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%wolfram%") 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:698
4 (1.027)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.127)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38