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


Jig 90 Spro Cu Carlig Gamakatsu Nr.6/0 18g 3buc/plic
Exclusiv online!

Jig 90 Spro Cu Carlig Gamakatsu Nr.6/0 18g 3buc/plic

4931-600-018
Livrare 48-72 ore

18,10Lei

Jig Head Mustad Finesse Nr.6, 2.5g, 4buc/pac

Jig Head Mustad Finesse Nr.6, 2.5g, 4buc/pac

f2.m.jgr.2.5
Livrare imediată!

21,75Lei

Jig Mustad F2 Nr.6/0, 15g, 25buc/pac -20%
Exclusiv online!

Jig Mustad F2 Nr.6/0, 15g, 25buc/pac

f2.m.bjh60.15.25
Livrare 24-48 ore

117,12Lei(-20%) 93,70Lei

Jig Mustad F2 Nr.6/0, 30g, 25buc/pac -20%
Exclusiv online!

Jig Mustad F2 Nr.6/0, 30g, 25buc/pac

f2.m.bjh60.30.25
Livrare 24-48 ore

161,16Lei(-20%) 128,92Lei

Jig Nevis Nr.6/0, 21g, 3buc/pac
Exclusiv online!

Jig Nevis Nr.6/0, 21g, 3buc/pac

4932-600-021
Livrare 48-72 ore

12,99Lei

Montura Orange cu Momitor Arcuit 40g si 2 Carlige Nr.6 Carp Leadcore Rocker Arm

Montura Orange cu Momitor Arcuit 40g si 2 Carlige Nr.6 Carp Leadcore Rocker Arm

40541mf2740
Livrare imediată!

18,06Lei

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

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

2248-6
Livrare 48-72ore

22,00Lei

Carlig Legat DAM Spezi Worms Nr.6, 0.22mm, 60cm, 10buc/pac
Exclusiv online!

Carlig Legat DAM Spezi Worms Nr.6, 0.22mm, 60cm, 10buc/pac

a.dam.66507
Livrare 24-48 ore

9,53Lei

Carlig Owner Amaz 11493 Aki Hook Nr.6/0, 6buc/pac

Carlig Owner Amaz 11493 Aki Hook Nr.6/0, 6buc/pac

1210025170-161
Livrare imediată!

22,48Lei

Carlig Owner Amaz 11655 Cut SSW Straight-Eye Nr.6/0, 6buc/pac

Carlig Owner Amaz 11655 Cut SSW Straight-Eye Nr.6/0, 6buc/pac

1210025180-161
Livrare imediată!

28,94Lei

Carlig Owner Amaz 55174 Tournament Mutu 2X-Strong Circle Nr.6/0, 5buc/pac

Carlig Owner Amaz 55174 Tournament Mutu 2X-Strong Circle Nr.6/0, 5buc/pac

1210025174-161
Livrare imediată!

25,88Lei

Carlige Fudo Ringed Chinu X RCHX-BN Nr.6, 1000buc/bulk
Exclusiv online!

Carlige Fudo Ringed Chinu X RCHX-BN Nr.6, 1000buc/bulk

6501-6-bulk
Livrare 48-72ore

477,00Lei

Carlige Gamakatsu LS-1040R, Nr.6, 14buc/pac
Exclusiv online!

Carlige Gamakatsu LS-1040R, Nr.6, 14buc/pac

147983-006
Livrare 48-72 ore

12,50Lei

Carlige Gamakatsu LS-3310F, Black, nr.6, 25buc/plic
Exclusiv online!

Carlige Gamakatsu LS-3310F, Black, nr.6, 25buc/plic

ls-3310f-006
Livrare 48-72 ore

18,50Lei

Carlige Hayabusa CHN122BN, Nr.6, 15buc/plic

Carlige Hayabusa CHN122BN, Nr.6, 15buc/plic

eb12271-6
Livrare imediată!

8,50Lei

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

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

8107-506
Livrare imediată!

7,10Lei

Carlige Legate Nash Ring Blow Back Rig Barbed, 20lbs, nr.6, 1buc/plic

Carlige Legate Nash Ring Blow Back Rig Barbed, 20lbs, nr.6, 1buc/plic

t6430
Livrare imediată!

16,12Lei

Carlige Mikado Golden Point Iseama W/R, Nr.6, 10Buc/plic
Exclusiv online!

Carlige Mikado Golden Point Iseama W/R, Nr.6, 10Buc/plic

hs10071-6-gb
Livrare 48-72 ore

16,01Lei

Carlige Mustad Notorious Momeala Vie, Nr.6/0, 5buc/plic
Exclusiv online!

Carlige Mustad Notorious Momeala Vie, Nr.6/0, 5buc/plic

m.10024ap.ts.06
Livrare 24-48 ore

32,64Lei

Carlige Solar Stronghold Long Shank Hook, Nr.6, 10buc/plic -34%

Carlige Solar Stronghold Long Shank Hook, Nr.6, 10buc/plic

lsc6
Livrare imediată!

37,49Lei(-34%) 24,89Lei

Afişare 681 - 700 din 1008 (51 pagini)
Queries: 7, Total time: 595.526 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = '67ba1b93a676d077f408632876'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (590.599)
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.6%") 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 (4.378)
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 680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.132)
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.123)
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.095)
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