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


KIT PROLOGIC BAIT BALANCING M 7MM

KIT PROLOGIC BAIT BALANCING M 7MM

a.pro.57135
Livrare imediată!

31,99Lei

Set Mivardi Method Feeder Set Premium L + Matrita, 30g, 40g, 50g, 3+1buc/blister

Set Mivardi Method Feeder Set Premium L + Matrita, 30g, 40g, 50g, 3+1buc/blister

m-mfspl345
Livrare imediată!

36,99Lei

SUPORT MATRIX 3D-R EXTENDING 8 KIT TULIP ROOST -50%
Exclusiv online!

SUPORT MATRIX 3D-R EXTENDING 8 KIT TULIP ROOST

gba053
Livrare 7-14 zile

269,95Lei(-50%) 134,98Lei

Set Momitoare Carp Hunter Method Feeder 4 + Matrita

Set Momitoare Carp Hunter Method Feeder 4 + Matrita

79661998
Livrare imediată!

23,50Lei

Kit Coghlans reparatie bete de cort

Kit Coghlans reparatie bete de cort

c0194
Livrare imediată!

28,00Lei

SET METHOD FEEDER + MATRITA TRABUCCO AIRTEK PRO FEEDER SMALL 30G

SET METHOD FEEDER + MATRITA TRABUCCO AIRTEK PRO FEEDER SMALL 30G

140-70-010
Livrare imediată!

25,00Lei

Kit pentru Protectie Lanseta/Mulineta FOX Camolite Reel and Rod Tip Protector
Exclusiv online!

Kit pentru Protectie Lanseta/Mulineta FOX Camolite Reel and Rod Tip Protector

clu320
Livrare 7-14 zile

130,46Lei

SET METHOD FEEDER JAXON E2 CU MATRITA SI CONECTOR 40GR

SET METHOD FEEDER JAXON E2 CU MATRITA SI CONECTOR 40GR

af-e240x
Livrare imediată!

50,00Lei

Kit Cormoran Pro Carp Chod Rig Set Mud -40%

Kit Cormoran Pro Carp Chod Rig Set Mud

a.11.00221
Livrare imediată!

21,90Lei(-40%) 13,14Lei

SET METHOD JAXON FEEDER ER2 CU MATRITA SI 5 CONECTORI 40GR
Exclusiv online!

SET METHOD JAXON FEEDER ER2 CU MATRITA SI 5 CONECTORI 40GR

af-er240x
Livrare 48-72 ore

57,00Lei

Tija Preston ICS Elasticated Stem Kit Long/Heavy

Tija Preston ICS Elasticated Stem Kit Long/Heavy

p0030004
Livrare imediată!

16,87Lei

Kit Korda Plumb Culisant Flying Back Leads 5buc/blister + 5 Rubber Beads 3g
Exclusiv online!

Kit Korda Plumb Culisant Flying Back Leads 5buc/blister + 5 Rubber Beads 3g

a3.kfb1
Livrare 24-48 ore

39,45Lei

KIT SAVAGE SPINNER ROTEX -20%
Exclusiv online!

KIT SAVAGE SPINNER ROTEX

sg.50722
Livrare 24-48 ore

128,25Lei(-20%) 102,60Lei

Kit de Rezerva Pentru Nalucile Savage Gear 3D Rad 20cm WHITE -50%
Exclusiv online!

Kit de Rezerva Pentru Nalucile Savage Gear 3D Rad 20cm WHITE

a.sg.55183
Livrare 24-48 ore

32,80Lei(-50%) 16,40Lei

Connector Pluta Match Extra Carp Waggler 4buc/pac

Connector Pluta Match Extra Carp Waggler 4buc/pac

ec9159
Livrare imediată!

8,00Lei

Kit Cormoran Running Rig Mud 5buc/plic -40%
Exclusiv online!

Kit Cormoran Running Rig Mud 5buc/plic

a.11.00217
Livrare 24-48 ore

27,52Lei(-40%) 16,52Lei

Set Mivardi Method Feeder Set Premium XL + Matrita, 50g, 60g, 2+1buc/blister

Set Mivardi Method Feeder Set Premium XL + Matrita, 50g, 60g, 2+1buc/blister

m-mfspxl56
Livrare imediată!

36,99Lei

SET METHOD FEEDER JAXON E2 CU MATRITA SI CONECTOR 20GR -20%

SET METHOD FEEDER JAXON E2 CU MATRITA SI CONECTOR 20GR

af-e220x
Livrare imediată!

45,01Lei(-20%) 35,90Lei

Kit Coghlans Reparatie Stalpi Cort

Kit Coghlans Reparatie Stalpi Cort

c1490
Livrare imediată!

57,00Lei

Set Mivardi Method Feeder Set Premium L + Matrita, 20g, 30g, 40g, 3+1buc/blister

Set Mivardi Method Feeder Set Premium L + Matrita, 20g, 30g, 40g, 3+1buc/blister

m-mfspl234
Livrare imediată!

36,99Lei

Afişare 241 - 260 din 664 (34 pagini)
Queries: 5, Total time: 16.934 ms [By time] [By id] [By file]
1 (0.144)
SELECT data
FROM `oc_session`
WHERE session_id = 'a6a9a60b9f7382b4acadad08a2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (13.714)
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('+kit' 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 (2.853)
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 240, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.114)
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