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 Tripla Mikado Sensual Round, Nr.4, 8buc/pac
Exclusiv online!

Ancora Tripla Mikado Sensual Round, Nr.4, 8buc/pac

hs11030-4b
Livrare 48-72 ore

18,00Lei

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

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

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

35,91Lei

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

Ancore BKK Spear EWG-71 SS, Nr.2, 6buc/pac

6974190007948
Livrare 48-72 ore

34,00Lei

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

Ancore BKK Spear EWG-71 SS, Nr.6, 8buc/pac

6974190007924
Livrare 48-72 ore

34,00Lei

Bile Tungsten Fox Edges Essentials Tungsten Beads 5mm, 15buc/pac

Bile Tungsten Fox Edges Essentials Tungsten Beads 5mm, 15buc/pac

cac865
Livrare imediată!

21,56Lei

Bilute Cauciuc Fox Edges Naturals Tapered Bore Beads 4mm, 30buc/pac

Bilute Cauciuc Fox Edges Naturals Tapered Bore Beads 4mm, 30buc/pac

cac836
Livrare imediată!

17,96Lei

Bilute Cauciuc Fox Edges Naturals Tapered Bore Beads 6mm, 30buc/pac

Bilute Cauciuc Fox Edges Naturals Tapered Bore Beads 6mm, 30buc/pac

cac837
Livrare imediată!

17,96Lei

Bride Duble PB Products Double Crimps 0.6mm, 50buc/pac

Bride Duble PB Products Double Crimps 0.6mm, 50buc/pac

pb27200
Livrare imediată!

23,00Lei

Carlige BKK Live Baiter SS, Nr.4/0, 5buc/pac
Exclusiv online!

Carlige BKK Live Baiter SS, Nr.4/0, 5buc/pac

6941780920277
Livrare 48-72 ore

22,00Lei

Carlige BKK Octopus Beak Straight Eye, Nr.3/0, 8buc/pac
Exclusiv online!

Carlige BKK Octopus Beak Straight Eye, Nr.3/0, 8buc/pac

6941780920376
Livrare 48-72 ore

22,00Lei

Carlige C&B C5 Extra Sharp, Nr.12, 10buc/pac

Carlige C&B C5 Extra Sharp, Nr.12, 10buc/pac

6427416145691
Livrare imediată!

9,00Lei

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

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

6427416145783
Livrare imediată!

9,00Lei

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

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

a.mad.56837
Livrare imediată!

30,86Lei

Carlige Gamakatsu LS-1053B Nr.12, 10buc/pac
Exclusiv online!

Carlige Gamakatsu LS-1053B Nr.12, 10buc/pac

147921-012
Livrare 48-72 ore

13,49Lei

Carlige Gamakatsu LS-1053B Nr.8, 10buc/pac
Exclusiv online!

Carlige Gamakatsu LS-1053B Nr.8, 10buc/pac

147921-008
Livrare 48-72 ore

13,49Lei

Carlige Gamakatsu LS-1090N Nr.14, 25buc/pac
Exclusiv online!

Carlige Gamakatsu LS-1090N Nr.14, 25buc/pac

ls-1090n-014
Livrare 48-72 ore

19,30Lei

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

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

ls-3614f-006
Livrare 48-72 ore

26,30Lei

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

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

ls-3614f-008
Livrare 48-72 ore

26,30Lei

Carlige Gamakatsu Worm-34 Nr.1/0, 6buc/pac
Exclusiv online!

Carlige Gamakatsu Worm-34 Nr.1/0, 6buc/pac

worm-34-100
Livrare 48-72 ore

17,01Lei

Carlige Jackall E-Hook, Nr.6, 15buc/pac
Exclusiv online!

Carlige Jackall E-Hook, Nr.6, 15buc/pac

ja.212118147
Livrare 24-48 ore

32,15Lei

Afişare 801 - 820 din 6363 (319 pagini)
Queries: 4, Total time: 575.803 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = '61d72292a1ff52dc03790d2aed'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.129)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (575.437)
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 (0.105)
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