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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


LINGURITA OSCILANTA BERTILURE C.TROUT NR.1 LUNGIME 28MM. CULOARE WHITE GAMMARUS 2 GRAME

LINGURITA OSCILANTA BERTILURE C.TROUT NR.1 LUNGIME 28MM. CULOARE WHITE GAMMARUS 2 GRAME

c-01-602
Livrare imediată!

13,40Lei

LINGURITA OSCILANTA BERTILURE P. KILLER NR.1 LUNGIME 3 CM. CULOARE NICKEL 4,5 GRAME

LINGURITA OSCILANTA BERTILURE P. KILLER NR.1 LUNGIME 3 CM. CULOARE NICKEL 4,5 GRAME

p-01-352
Livrare imediată!

15,20Lei

L and K MICRO JIG 2316 NR.1 2g 4buc/plic

L and K MICRO JIG 2316 NR.1 2g 4buc/plic

59102012
Livrare imediată!

11,00Lei

Ancore VMC 7545 Black Nickel Nr.10 5buc/plic
Exclusiv online!

Ancore VMC 7545 Black Nickel Nr.10 5buc/plic

7545 bn10
Livrare 48-72ore

29,00Lei

Carlig Mustad Feeder MU11, Nickel, 10buc/plic Nr.12

Carlig Mustad Feeder MU11, Nickel, 10buc/plic Nr.12

m.60332n.12
Livrare imediată!

6,44Lei

Carlige Crap Maruto Barbless Fara Spin 8714BL BN nr.12 10buc

Carlige Crap Maruto Barbless Fara Spin 8714BL BN nr.12 10buc

43011012
Livrare imediată!

8,90Lei

Carlig Mustad Match Maggot, Tija Lunga, BLN, 10buc/plic Nr.16
Exclusiv online!

Carlig Mustad Match Maggot, Tija Lunga, BLN, 10buc/plic Nr.16

m.90339bln.16
Livrare 24-48 ore

6,44Lei

Vartej Nevis Cu Agrafa Nr.12 Sand

Vartej Nevis Cu Agrafa Nr.12 Sand

5523-012
Livrare imediată!

5,70Lei

Carlige Carp Spirit Razor Point V-Curve XS Nr.1 -26%

Carlige Carp Spirit Razor Point V-Curve XS Nr.1

acs350093
Livrare imediată!

27,00Lei(-26%) 19,90Lei

CARLIGE FUDO CHIKA RING BN NR.16 -20%

CARLIGE FUDO CHIKA RING BN NR.16

4501-16
Livrare imediată!

10,00Lei(-20%) 8,00Lei

Carlige Gamakatsu Forjate LS-3310F Nr.1.5 25buc/plic

Carlige Gamakatsu Forjate LS-3310F Nr.1.5 25buc/plic

gk.146575.1.5
Livrare imediată!

29,11Lei

LINGURITA OSCILANTA BERTILURE POLLO NR.1 LUNGIME 54 MM. CULOARE NICKEL 8 GRAME

LINGURITA OSCILANTA BERTILURE POLLO NR.1 LUNGIME 54 MM. CULOARE NICKEL 8 GRAME

p-01-374
Livrare imediată!

15,20Lei

Carlige Legate Excalibur Bolo Gold Nr.14 10Buc/Plic
Exclusiv online!

Carlige Legate Excalibur Bolo Gold Nr.14 10Buc/Plic

47039014
Livrare 24-48 ore

9,00Lei

Carlige Legate Owner RL560 53811 Nr.14 Fir 0.12mm

Carlige Legate Owner RL560 53811 Nr.14 Fir 0.12mm

5381114
Livrare imediată!

18,17Lei

Carlige Method Guru Super XS Barbless Nr.14 10buc

Carlige Method Guru Super XS Barbless Nr.14 10buc

gu.gxse14
Livrare imediată!

13,90Lei

Carlige Mivardi M-725, 10buc/plic Nr.18
Exclusiv online!

Carlige Mivardi M-725, 10buc/plic Nr.18

m-hm72518
Livrare 48-72 ore

8,00Lei

VARTEJ RAPID DAIWA N ZON + VARTEJ NR.14

VARTEJ RAPID DAIWA N ZON + VARTEJ NR.14

a7.13316.014
Livrare imediată!

17,15Lei

LINGURITA OSCILANTA BERTILURE PISCOT NR.1 LUNGIME 55 MM. CULOARE NICKEL 13 GRAME

LINGURITA OSCILANTA BERTILURE PISCOT NR.1 LUNGIME 55 MM. CULOARE NICKEL 13 GRAME

p-01-316
Livrare imediată!

15,20Lei

LINGURITA OSCILANTA BERTILURE LUCKY RT NR.1 LUNGIME 60 MM. CULOARE NICKEL 7 GRAME

LINGURITA OSCILANTA BERTILURE LUCKY RT NR.1 LUNGIME 60 MM. CULOARE NICKEL 7 GRAME

l-01-553
Livrare imediată!

19,65Lei

Carlig Owner 50571 Nr.11 Hera Buna BL -51%

Carlig Owner 50571 Nr.11 Hera Buna BL

5057111
Livrare imediată!

9,40Lei(-51%) 4,59Lei

Afişare 1661 - 1680 din 3087 (155 pagini)
Queries: 7, Total time: 671.960 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = 'a84ff236b375073ee6e6b1832c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.091)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (659.037)
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.1%") 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
5 (12.385)
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 1660, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.152)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.103)
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