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


PLUMBI COLMIC OLIVETA JAZ 1.00gr
Exclusiv online!

PLUMBI COLMIC OLIVETA JAZ 1.00gr

toj0100
Livrare 48-72 ore

21,00Lei

Kit Plumb Pierdut Carp Expert Cu Vartej si Con 6buc/plic

Kit Plumb Pierdut Carp Expert Cu Vartej si Con 6buc/plic

79610140
Livrare imediată!

17,01Lei

Momitor Carp Zoom Spirala Tija Lunga Cu Plumb 40gr

Momitor Carp Zoom Spirala Tija Lunga Cu Plumb 40gr

cz9587
Livrare imediată!

8,50Lei

CUTIE PLUMBI MAVER ALICE SUPERCALIBRATI NR 5/0 4/0 0 2 5 150GR
Exclusiv online!

CUTIE PLUMBI MAVER ALICE SUPERCALIBRATI NR 5/0 4/0 0 2 5 150GR

84002
Livrare 48-72 ore

42,00Lei

CUTIE PLUMBI COLMIC 1 ALICE 6 COMPARTIMENTE 90gr
Exclusiv online!

CUTIE PLUMBI COLMIC 1 ALICE 6 COMPARTIMENTE 90gr

pomap1
Livrare 48-72 ore

32,00Lei

PLUMBI COLMIC OLIVETA JAZ 10gr
Exclusiv online!

PLUMBI COLMIC OLIVETA JAZ 10gr

toj1000
Livrare 48-72 ore

34,00Lei

PLUMBI COLMIC OLIVETA JAZ 0.30gr
Exclusiv online!

PLUMBI COLMIC OLIVETA JAZ 0.30gr

toj0030
Livrare 48-72 ore

21,00Lei

Momitor Delphin plumb cu tub 20g

Momitor Delphin plumb cu tub 20g

925001020
Livrare imediată!

4,00Lei

PLUMB PICATURA CARP ZOOM CU VARTEJ 20gr

PLUMB PICATURA CARP ZOOM CU VARTEJ 20gr

cz9655
Livrare imediată!

4,50Lei

Momitor Carp Zoom Spirala Tija Lunga Cu Plumb 30gr

Momitor Carp Zoom Spirala Tija Lunga Cu Plumb 30gr

cz9570
Livrare imediată!

7,50Lei

PLUMB BOMB INLINE CU INVELIS PLUTA MAVER 170GR -35%
Exclusiv online!

PLUMB BOMB INLINE CU INVELIS PLUTA MAVER 170GR

75023170
Livrare 48-72 ore

19,50Lei(-35%) 12,70Lei

MONTURA LEADCORE PLUMB PIERDUT KORDA HYBRID LEAD CLIP, 3BUC/BLISTER
Exclusiv online!

MONTURA LEADCORE PLUMB PIERDUT KORDA HYBRID LEAD CLIP, 3BUC/BLISTER

a.llhcg
Livrare 24-48 ore

41,78Lei

CAP PLUMB JAXON PENTRU ROTATIVE 5GR
Exclusiv online!

CAP PLUMB JAXON PENTRU ROTATIVE 5GR

cj-c05
Livrare 48-72 ore

41,00Lei

SET KORDA 5 MONTURI PLUMB PIERDUT
Exclusiv online!

SET KORDA 5 MONTURI PLUMB PIERDUT

a.klcaps
Livrare 24-48 ore

37,98Lei

Alice Plumb DAM Bleischrot Grob 70gr

Alice Plumb DAM Bleischrot Grob 70gr

414098001070
Livrare imediată!

13,84Lei

JIG SAVAGE CORK SCREW HEADS 10G, 3BUC/PAC -24%

JIG SAVAGE CORK SCREW HEADS 10G, 3BUC/PAC

f2.sg.50357
Livrare imediată!

18,22Lei(-24%) 13,90Lei

PLUMB CARP ZOOM FANATIC FLAT PEAR INLINE 60GR
Exclusiv online!

PLUMB CARP ZOOM FANATIC FLAT PEAR INLINE 60GR

cz1251
Livrare 48-72 ore

9,50Lei

PLUMBI MAVER TORPILA SFERA 0.50GR -40%

PLUMBI MAVER TORPILA SFERA 0.50GR

107050
Livrare imediată!

13,99Lei(-40%) 8,40Lei

Lestaj plumb jig Jaxon Cheburaska 15GR 10/PLIC
Exclusiv online!

Lestaj plumb jig Jaxon Cheburaska 15GR 10/PLIC

gj-xd15
Livrare 48-72 ore

38,00Lei

CUTIE PLUMBI COLMIC ALICE SOFT 30gr Nr.0 0.347gr
Exclusiv online!

CUTIE PLUMBI COLMIC ALICE SOFT 30gr Nr.0 0.347gr

pobb100
Livrare 48-72 ore

12,99Lei

Afişare 661 - 680 din 2254 (113 pagini)
Queries: 5, Total time: 5,775.907 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '85245c32024869d39b4dd53700'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.141)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (5,746.458)
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 "%plumb%") 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:725
4 (28.981)
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 660, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.180)
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