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


Lanseta, Spinning, Daiwa, Tatula, 732MHFS, 2.21m,, 7-28g,, 2seg, d.tat732mhfsbf, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
Lanseta Spinning Daiwa Tatula 711MHFS 2.16m, 7-28g, 1seg
Exclusiv online!

Lanseta Spinning Daiwa Tatula 711MHFS 2.16m, 7-28g, 1seg

d.tat711mhfsbf
Livrare 24-48 ore

877,07Lei

Lanseta, Daiwa, Fuego, 802, HFS, 2.44m,, 14-42g,, 2seg, d.fu802hfsaf, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Lansete Casting, Lansete Casting Daiwa, Lansete Daiwa, Casting Daiwa, Daiwa -20%
LANSETA, DAIWA, STEEZ, AGS, 671MHFS, , 2.01M, , 7, 28G, , 1SEGMENT, d.stzags671mhfsbf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Exclusiv online!

LANSETA, DAIWA, STEEZ, AGS, 671MHFS, , 2.01M, , 7, 28G, , 1SEGMENT, d.stzags671mhfsbf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.stzags671mhfsbf
Livrare 24-48 ore

1.788,17Lei

LANSETA, DAIWA, 2BUC.PROCASTER, A, 802MHFSE, BX, 2,43M/7-28G, d.pra802mhfsebx, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Exclusiv online!

LANSETA, DAIWA, 2BUC.PROCASTER, A, 802MHFSE, BX, 2,43M/7-28G, d.pra802mhfsebx, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.pra802mhfsebx
Livrare 24-48 ore

253,60Lei

Lanseta, spinning, Daiwa, Tierra, MH, 1.80m, 7-28g, 2SEGG, d.td.tr602mhfs, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Exclusiv online!

Lanseta, spinning, Daiwa, Tierra, MH, 1.80m, 7-28g, 2SEGG, d.td.tr602mhfs, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.td.tr602mhfs
Livrare 24-48 ore

377,29Lei

Lanseta, Daiwa, Steez, AGS, 711HM, HFS, SPIN, 2.16m, 10-35g, d.stzags711hmhfscf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -10%
Exclusiv online!

Lanseta, Daiwa, Steez, AGS, 711HM, HFS, SPIN, 2.16m, 10-35g, d.stzags711hmhfscf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.stzags711hmhfscf
Livrare 24-48 ore

2.379,44Lei(-10%) 2.141,50Lei

Lanseta, Daiwa, Steez, AGS, 671MHFS, 2.13m, 7-28g, d.stzags671mhfscf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Exclusiv online!

Lanseta, Daiwa, Steez, AGS, 671MHFS, 2.13m, 7-28g, d.stzags671mhfscf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.stzags671mhfscf
Livrare 24-48 ore

2.307,70Lei

LANSETA, DAIWA, , , EXCELER, 732HMHFS, 2,21M/10-35G, 2buc, d.ex732hmhfsdf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Exclusiv online!

LANSETA, DAIWA, , , EXCELER, 732HMHFS, 2,21M/10-35G, 2buc, d.ex732hmhfsdf, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.ex732hmhfsdf
Livrare 24-48 ore

514,69Lei

Lanseta, Daiwa, Procaster, 702MHFS,, 2.13m,, 7-28g, d.pra702mhfseax, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Carlige, Fudo, Chinu, FSH, (CHFS-BN),, Nr.3,, 14buc/pac, 7101-3, Carlige Crap, Carlige Crap Fudo, Carlige Fudo, Crap Fudo, Fudo
Carlige, Fudo, Chinu, FSH, (CHFS-BN),, Nr.6,, 17buc/pac, 7101-6, Carlige Crap, Carlige Crap Fudo, Carlige Fudo, Crap Fudo, Fudo
Carlige Fudo Chinu FSH (CHFS-BN), Nr.8, 18buc/pac
Exclusiv online!

Carlige Fudo Chinu FSH (CHFS-BN), Nr.8, 18buc/pac

7101-8
Livrare 48-72ore

10,00Lei

LANSETA DAIWA 1BUC STEEZ 701MHFS 2,13M/7-28G

LANSETA DAIWA 1BUC STEEZ 701MHFS 2,13M/7-28G

d.stzags701mhfscf
Stoc epuizat

2.332,55Lei

Lanseta Spinning Daiwa Procaster 702MHFS, 2.13m, 7-28g, 2seg

Lanseta Spinning Daiwa Procaster 702MHFS, 2.13m, 7-28g, 2seg

d.pra702mhfsebx
Stoc epuizat

224,07Lei

LANSETA SPINNING DAIWA 2SEG PROCASTER 702MHFS 2,13M 7-28G

LANSETA SPINNING DAIWA 2SEG PROCASTER 702MHFS 2,13M 7-28G

d.pra702mhfseax-indisponibil
Stoc epuizat

207,64Lei

Lanseta Daiwa Tournament AGS, 2.13m, 7-28g, 2buc

Lanseta Daiwa Tournament AGS, 2.13m, 7-28g, 2buc

d.tnags702mhfsbf
Stoc epuizat

1.724,17Lei

Lanseta Daiwa Exceler New 802MHFS 2.43m/7-28g -16%

Lanseta Daiwa Exceler New 802MHFS 2.43m/7-28g

d.ex802mhfscf
Stoc epuizat

442,50Lei(-16%) 371,70Lei

LANSETA DAIWA STEEZ 701MHFS 2.13M 7 28G 1SEGMENTE

LANSETA DAIWA STEEZ 701MHFS 2.13M 7 28G 1SEGMENTE

d.stzags701mhfsbf
Stoc epuizat

2.058,40Lei

LANSETA DAIWA STEEZ SPINNING AGS 701HMHFS 2.13M/10-35G 1SEG

LANSETA DAIWA STEEZ SPINNING AGS 701HMHFS 2.13M/10-35G 1SEG

d.stzags701hmhfsbf
Stoc epuizat

1.632,01Lei

Afişare 1 - 20 din 27 (2 pagini)
Queries: 15, Total time: 1,371.948 ms [By time] [By id] [By file]
1 (0.128)
SELECT data
FROM `oc_session`
WHERE session_id = '5621e831efdaa5347ce9f4d6a0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (833.387)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%hfs%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
5 (534.291)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%hfs%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.180)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.106)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.124)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1233
10 (2.625)
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_to_category` AS p2c ON (p.product_id = p2c.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 p2c.category_id = '390' AND (pd.tag LIKE "%hfs%") 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:697
11 (0.108)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066
12 (0.259)
SELECT COUNT(*) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911
13 (0.145)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.114)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
15 (0.121)
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