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


Carlig Delphin HKD FLATER NR.14 -36%

Carlig Delphin HKD FLATER NR.14

622030014
Livrare imediată!

11,00Lei(-36%) 7,00Lei

Carlige Korda Krank Barbless Nr. 8
Exclusiv online!

Carlige Korda Krank Barbless Nr. 8

k.kkrb8
Livrare 24-48 ore

30,15Lei

Carlige Maruto 9354 BN-BN Nr2 10buc/plic

Carlige Maruto 9354 BN-BN Nr2 10buc/plic

43852002
Livrare imediată!

9,50Lei

CARLIG OWNER CPS 5106 Nr.2 Negru Rotund Anou -27%

CARLIG OWNER CPS 5106 Nr.2 Negru Rotund Anou

5106003
Livrare imediată!

15,96Lei(-27%) 11,65Lei

Carlige Fudo Beak (FDBK-BN) nr.6 BN - Black Nickel 15 buc/plic

Carlige Fudo Beak (FDBK-BN) nr.6 BN - Black Nickel 15 buc/plic

6301-6
Livrare imediată!

10,00Lei

CARLIG MUSTAD CRAP XV2 CURVE BL.MAT Nr.2
Exclusiv online!

CARLIG MUSTAD CRAP XV2 CURVE BL.MAT Nr.2

m.60545npbm.2
Livrare 24-48 ore

12,39Lei

HAYABUSA CARLIGE BEK562BN NR. 2

HAYABUSA CARLIGE BEK562BN NR. 2

7155
Livrare imediată!

7,90Lei

Carlig Owner C-3 Carp Tsuyoshi Nr.6

Carlig Owner C-3 Carp Tsuyoshi Nr.6

5000026
Livrare imediată!

13,54Lei

Carlig Owner Crap Iseama CT-5 nr 4 - 10buc/plic

Carlig Owner Crap Iseama CT-5 nr 4 - 10buc/plic

5000042
Livrare imediată!

18,17Lei

Carlige Owner K-Chinu 50098, Nr.4, 10buc/plic -23%

Carlige Owner K-Chinu 50098, Nr.4, 10buc/plic

5009806
Livrare imediată!

10,25Lei(-23%) 7,90Lei

KICKER KORDA RIG ALIGNER MARO 10BUC/PL MARIMEA S
Exclusiv online!

KICKER KORDA RIG ALIGNER MARO 10BUC/PL MARIMEA S

a.kick04
Livrare 24-48 ore

26,91Lei

Carlige Owner Cut Chinu 50339 Negru nr 5 - 15buc/plic

Carlige Owner Cut Chinu 50339 Negru nr 5 - 15buc/plic

5033908
Livrare imediată!

12,88Lei

CARLIGE FOX CURVE SHANK X NR.2

CARLIGE FOX CURVE SHANK X NR.2

chk222
Livrare imediată!

26,97Lei

CARLIG OWNER CRAP TEFLONAT CT1 No.6 CARP FLYLINER CROM -26%

CARLIG OWNER CRAP TEFLONAT CT1 No.6 CARP FLYLINER CROM

5000031
Livrare imediată!

17,34Lei(-26%) 12,90Lei

Carlige Carp Spirit Razor Point V-Curve Nr.10

Carlige Carp Spirit Razor Point V-Curve Nr.10

acs350086
Livrare imediată!

27,00Lei

Carlige Energo Team Excalibur D-killer Ns Nr 6 10buc/plic

Carlige Energo Team Excalibur D-killer Ns Nr 6 10buc/plic

47055006
Livrare imediată!

8,00Lei

Carlig Owner 50116 Kaizu nr.7

Carlig Owner 50116 Kaizu nr.7

5011613
Livrare imediată!

11,89Lei

MAGGOT CLIPS JAXON M

MAGGOT CLIPS JAXON M

ac-pcu0m
Livrare imediată!

7,00Lei

CARLIGE HAYABUSA UMT 209 BN NR 11 15 BUCATI

CARLIGE HAYABUSA UMT 209 BN NR 11 15 BUCATI

7176
Livrare imediată!

8,60Lei

HAYABUSA CARLIGE UMT 209BN NR. 6

HAYABUSA CARLIGE UMT 209BN NR. 6

7178
Livrare imediată!

8,60Lei

Afişare 1301 - 1320 din 3179 (159 pagini)
Queries: 5, Total time: 94.777 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = 'f7a27b8a14528671933a51ffc8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (80.468)
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 = '3' AND (MATCH(pd.tag) AGAINST('+carlige +crap' IN BOOLEAN MODE)) 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 (13.961)
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 1300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.135)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38