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


Ancore Fudo FT-02T Middle Class Nickel Nr.10, 7buc/pac
Exclusiv online!

Ancore Fudo FT-02T Middle Class Nickel Nr.10, 7buc/pac

2248-10
Livrare 48-72ore

22,00Lei

Carlig Legat DAM Spezi Crap Nr.10, 0.22mm, 70cm, 10buc/pac
Exclusiv online!

Carlig Legat DAM Spezi Crap Nr.10, 0.22mm, 70cm, 10buc/pac

a.dam.66469
Livrare 24-48 ore

9,84Lei

CARLIG MUSTAD BRONZ FORJAT PT. MUSCA NR.10
Exclusiv online!

CARLIG MUSTAD BRONZ FORJAT PT. MUSCA NR.10

m.r50.94840.10
Livrare 24-48 ore

18,14Lei

Carlige Fudo Iseama Ring Nr.10, 1000buc/bulk
Exclusiv online!

Carlige Fudo Iseama Ring Nr.10, 1000buc/bulk

3007-10-bulk
Livrare 48-72ore

345,00Lei

Carlige Gamakatsu LS-3620N, Nr.10, 25buc/pac
Exclusiv online!

Carlige Gamakatsu LS-3620N, Nr.10, 25buc/pac

ls-3620n-010
Livrare 48-72 ore

19,00Lei

Carlige Legate Attack Method Feeder Rig Barbed Hook with Spike, Nr.10, 10cm, 20lbs, 8buc/pac

Carlige Legate Attack Method Feeder Rig Barbed Hook with Spike, Nr.10, 10cm, 20lbs, 8buc/pac

att-kc6000110
Livrare imediată!

15,90Lei

Carlige legate Germina Chinta, Nr.10, 0.14mm, 10buc/plic

Carlige legate Germina Chinta, Nr.10, 0.14mm, 10buc/plic

hchn-10-g
Livrare imediată!

7,90Lei

Carlige Legate Guru Bayonets QM1, Carlig Nr.10, 0.22mm, 10cm, 8buc/pac

Carlige Legate Guru Bayonets QM1, Carlig Nr.10, 0.22mm, 10cm, 8buc/pac

a.gu.grr138
Livrare imediată!

24,50Lei

Carlige Legate Guru Bayonets QM1, Carlig Nr.10, 0.22mm, 38cm, 8buc/pac
Exclusiv online!

Carlige Legate Guru Bayonets QM1, Carlig Nr.10, 0.22mm, 38cm, 8buc/pac

a.gu.grr144
Livrare 24-48 ore

27,75Lei

Carlige Legate Method Steg cu Spin 10cm, Nr.10, 2buc/pac

Carlige Legate Method Steg cu Spin 10cm, Nr.10, 2buc/pac

8107-510
Livrare imediată!

7,10Lei

Carlige Orange Method Bronze Coated Premium Series 6, Nr.10, 8buc/pac

Carlige Orange Method Bronze Coated Premium Series 6, Nr.10, 8buc/pac

121441hm0610
Livrare imediată!

10,44Lei

Carlige Orange Method Bronze Coated Premium Series 7 Nr.10, 8buc/pac

Carlige Orange Method Bronze Coated Premium Series 7 Nr.10, 8buc/pac

121441hm0710
Livrare imediată!

10,44Lei

Agrafa cu Vartej DAM D-Lock Nr.10, 12kg, 10buc/pac
Exclusiv online!

Agrafa cu Vartej DAM D-Lock Nr.10, 12kg, 10buc/pac

a7.dam.56439
Livrare 24-48 ore

11,94Lei

Ancore Fudo FT-01C Fine Class Rainbow Nr.10, 5buc/pac
Exclusiv online!

Ancore Fudo FT-01C Fine Class Rainbow Nr.10, 5buc/pac

2239-10
Livrare 48-72ore

22,00Lei

Ancore Fudo Treble Hooks (FDTR-UV) nr.10 2000buc
Exclusiv online!

Ancore Fudo Treble Hooks (FDTR-UV) nr.10 2000buc

2209-10-b2000
Livrare 48-72ore

2.120,00Lei

Carlige Gamakatsu LS-5330R, Nr.10, 25buc/pac
Exclusiv online!

Carlige Gamakatsu LS-5330R, Nr.10, 25buc/pac

ls-5330r-010
Livrare 48-72 ore

26,30Lei

Carlige Nash Pinpoint Flota Claw Barbless, Nr.10, 10buc/plic
Exclusiv online!

Carlige Nash Pinpoint Flota Claw Barbless, Nr.10, 10buc/plic

t6183
Livrare 7-14 zile

28,99Lei

Inel Sic FishUp UKTLSG Nr.10

Inel Sic FishUp UKTLSG Nr.10

81042100
Livrare imediată!

6,50Lei

Carlige Legate Attack Feeder Rig Pellet Band Braid Line, 15lbs, Nr.10, 3buc/plic

Carlige Legate Attack Feeder Rig Pellet Band Braid Line, 15lbs, Nr.10, 3buc/plic

5017ms
Livrare imediată!

13,49Lei

Carlige Legate Kamatsu Chinu Rig Method Feeder Cu Inel Silicon, 10cm, Nr.10, 0.22mm, 5buc/pac
Exclusiv online!

Carlige Legate Kamatsu Chinu Rig Method Feeder Cu Inel Silicon, 10cm, Nr.10, 0.22mm, 5buc/pac

120306504026310
Livrare 48-72 ore

9,69Lei

Afişare 501 - 520 din 711 (36 pagini)
Queries: 9, Total time: 566.400 ms [By time] [By id] [By file]
1 (0.076)
SELECT data
FROM `oc_session`
WHERE session_id = '8321c5d53c46c97046695d1402'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (562.126)
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 "%nr.10%") 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 (3.482)
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 500, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.139)
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.125)
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.117)
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.104)
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.133)
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