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 300 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 - K-Karp

Produse ce potrivesc criteriilor de căutare


Carlige Mustad Alpha Allround Titan Nr.10, 20buc/pac

Carlige Mustad Alpha Allround Titan Nr.10, 20buc/pac

m.496ap.tx.10
Stoc epuizat

20,55Lei

Carlige Sensas 3050 Bronze, Nr.20, 15buc/pac

Carlige Sensas 3050 Bronze, Nr.20, 15buc/pac

a.s54211
Stoc epuizat

18,75Lei

Ascutitor Carlige Zfish Diamond Hook Sharpener, 10x1.2cm

Ascutitor Carlige Zfish Diamond Hook Sharpener, 10x1.2cm

ZF-3382
Stoc epuizat

25,72Lei

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

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

ls-1112n-014
Stoc epuizat

16,70Lei

Carlige Mikado Sensual Catfish BN, Nr.6/0, 2buc/plic

Carlige Mikado Sensual Catfish BN, Nr.6/0, 2buc/plic

hs11026-6/0b
Stoc epuizat

9,00Lei

Carlige Mustad Cristal Nichel, Revers 221C, 10buc/plic Nr.2

Carlige Mustad Cristal Nichel, Revers 221C, 10buc/plic Nr.2

m.221c.2
Stoc epuizat

6,30Lei

Carlige PB Products Wide Circle PTFE Hooks, Nr.2, 10buc/pac

Carlige PB Products Wide Circle PTFE Hooks, Nr.2, 10buc/pac

pb24210
Stoc epuizat

35,00Lei

Carlige Sensas 3012 Red, Nr.18, 15buc/pac

Carlige Sensas 3012 Red, Nr.18, 15buc/pac

a.s54041
Stoc epuizat

18,75Lei

Cutie Dubla Magnetica pentru Carlige STONFO 259S, 12x8x1.9cm

Cutie Dubla Magnetica pentru Carlige STONFO 259S, 12x8x1.9cm

8028651008543
Stoc epuizat

79,00Lei

Dispozitiv pt. Legat Riguri STONFO Feeder Calibrone Small, pt. Carlige Nr.28 - Nr.10
Expozitor Carlige Zfish Board On Hooks, 80x48cm

Expozitor Carlige Zfish Board On Hooks, 80x48cm

ZF-8871
Stoc epuizat

35,85Lei

Fir Par pt. Viermusi STONFO Multimaggot, Nr.1, 6buc/pac

Fir Par pt. Viermusi STONFO Multimaggot, Nr.1, 6buc/pac

8028651015329
Stoc epuizat

20,50Lei

Spin Pentru Momeala Konger Method Feeder Boilies Wafters, 8mm, 10buc/plic

Spin Pentru Momeala Konger Method Feeder Boilies Wafters, 8mm, 10buc/plic

41606966000003
Stoc epuizat

8,97Lei

Taparie Scrumbie Hayabusa Sabiki Fish Skin, Real Minnow, Nr.7, 6 Carlige, 1buc/pac
Taparie Scrumbie Hayabusa Sabiki Fish Skin, UV Mackerel, Nr.8, 6 Carlige, 1buc/pac
Carlige Gamakatsu Team Feeder Circle Power A1 Nr. 6 10bucati/plic

Carlige Gamakatsu Team Feeder Circle Power A1 Nr. 6 10bucati/plic

gk.185107.6
Stoc epuizat

11,21Lei

GURU CARLIGE QM1 NR.16

GURU CARLIGE QM1 NR.16

5060196180172
Stoc epuizat

12,11Lei

Carlig Delphin THE END Carp C-SHANK NR.8 -53%

Carlig Delphin THE END Carp C-SHANK NR.8

623003008
Stoc epuizat

19,00Lei(-53%) 9,00Lei

Carlige Korda Long Shank X Nr.6

Carlige Korda Long Shank X Nr.6

klsx6
Stoc epuizat

25,07Lei

Afişare 9521 - 9539 din 9539 (477 pagini)
Queries: 7, Total time: 330.417 ms [By time] [By id] [By file]
1 (0.065)
SELECT data
FROM `oc_session`
WHERE session_id = 'dbdbfdad6f4ddebccd347aac61'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.092)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (329.778)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%carlige%") 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:698
5 (0.138)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.130)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38