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


Ancora Dubla Mikado Sensual, Nr.8, 10buc/pac
Exclusiv online!

Ancora Dubla Mikado Sensual, Nr.8, 10buc/pac

hs11040-8b
Livrare 48-72 ore

17,01Lei

Ancora Tripla Mikado Sensual Round, Nr.2, 5buc/pac
Exclusiv online!

Ancora Tripla Mikado Sensual Round, Nr.2, 5buc/pac

hs11030-2b
Livrare 48-72 ore

18,00Lei

Ancora Tripla Mustad Red Tinse, Nr.6, 2buc/pac
Exclusiv online!

Ancora Tripla Mustad Red Tinse, Nr.6, 2buc/pac

m.itg76f.rt.6
Livrare 24-48 ore

35,91Lei

Ancore BKK Spear EWG-71 SS, Nr.4, 7buc/pac
Exclusiv online!

Ancore BKK Spear EWG-71 SS, Nr.4, 7buc/pac

6974190007931
Livrare 48-72 ore

34,00Lei

Ancore BKK Viper-41, Nr.4/0, 5buc/pac
Exclusiv online!

Ancore BKK Viper-41, Nr.4/0, 5buc/pac

6939067087157
Livrare 48-72 ore

59,00Lei

BRIDE PRO FL CRIMP 0.7MM 50buc/pac

BRIDE PRO FL CRIMP 0.7MM 50buc/pac

64-65726
Livrare imediată!

9,90Lei

Carlige BKK Carp Hook Hand Ground Nr.8, 8buc/pac

Carlige BKK Carp Hook Hand Ground Nr.8, 8buc/pac

6939067097347
Livrare imediată!

15,51Lei

Carlige BKK Chinu-R Hand Ground Nr.6, 8buc/pac

Carlige BKK Chinu-R Hand Ground Nr.6, 8buc/pac

6970595287930
Livrare imediată!

15,01Lei

Carlige BKK Octopus Beak, Nr.8/0, 7buc/pac
Exclusiv online!

Carlige BKK Octopus Beak, Nr.8/0, 7buc/pac

6939067018007
Livrare 48-72 ore

22,00Lei

Carlige C&B C6 Extra Sharp, Nr.16, 10buc/pac

Carlige C&B C6 Extra Sharp, Nr.16, 10buc/pac

6427416145769
Livrare imediată!

9,00Lei

Carlige DAM Madcat A-Static Teaser Nr.7/0, 4buc/pac
Exclusiv online!

Carlige DAM Madcat A-Static Teaser Nr.7/0, 4buc/pac

a.mad.56839
Livrare 24-48 ore

33,53Lei

Carlige Gamakatsu Coars PRO-C Powercarp Eyed, Nr.12, 10buc/pac
Exclusiv online!

Carlige Gamakatsu Coars PRO-C Powercarp Eyed, Nr.12, 10buc/pac

gk.185245.12
Livrare 24-48 ore

18,06Lei

Carlige Gamakatsu Coars PRO-C XS Commercial Spade Nr.16, 10buc/pac
Exclusiv online!

Carlige Gamakatsu Coars PRO-C XS Commercial Spade Nr.16, 10buc/pac

gk.185242.16
Livrare 24-48 ore

18,06Lei

Carlige Gamakatsu LS-3614F, Nr.10, 25buc/pac
Exclusiv online!

Carlige Gamakatsu LS-3614F, Nr.10, 25buc/pac

ls-3614f-010
Livrare 48-72 ore

26,30Lei

Carlige KORDA Long Shank Beaked, Micro Barbed, Nr.6, 10buc/pac
Exclusiv online!

Carlige KORDA Long Shank Beaked, Micro Barbed, Nr.6, 10buc/pac

k.klsb6
Livrare 24-48 ore

32,38Lei

Carlige KORDA Long Shank Beaked, Micro Barbed, Nr.8, 10buc/pac
Exclusiv online!

Carlige KORDA Long Shank Beaked, Micro Barbed, Nr.8, 10buc/pac

k.klsb8
Livrare 24-48 ore

32,38Lei

Carlige Legate Carp Academy Basic Special, nr.2, 25lb, 2buc/pac

Carlige Legate Carp Academy Basic Special, nr.2, 25lb, 2buc/pac

8106-402
Livrare imediată!

7,50Lei

Carlige Somn Zeck Classic Cat Hook M, 4buc/pac
Exclusiv online!

Carlige Somn Zeck Classic Cat Hook M, 4buc/pac

120405110221
Livrare 48-72 ore

40,67Lei

Carlige Trakker Clinga SP Hooks Micro Barbed, Nr.4, 10buc/pac

Carlige Trakker Clinga SP Hooks Micro Barbed, Nr.4, 10buc/pac

227208
Livrare imediată!

26,45Lei

Cicada Siliconica Dreamlures Seadreamer G, 8.5cm, 19g, 1buc/pac
Exclusiv online!

Cicada Siliconica Dreamlures Seadreamer G, 8.5cm, 19g, 1buc/pac

dream-sd19-g
Livrare 48-72ore

27,00Lei

Afişare 1481 - 1500 din 6254 (313 pagini)
Queries: 6, Total time: 648.062 ms [By time] [By id] [By file]
1 (0.168)
SELECT data
FROM `oc_session`
WHERE session_id = '3b172aa04924799af49f2f27ab'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.147)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (623.796)
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 (pd.tag LIKE "%buc/pac%") 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 (23.709)
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 1480, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.133)
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
6 (0.109)
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