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


PLUMB BETISOR JAXON CU VARTEJ 5GR 2BUC/PLIC

PLUMB BETISOR JAXON CU VARTEJ 5GR 2BUC/PLIC

ck-aa05
Livrare imediată!

7,00Lei

PLUMB EXTRA CARP GRIPPA CU VARTEJ NEGRU 120Gr

PLUMB EXTRA CARP GRIPPA CU VARTEJ NEGRU 120Gr

ec4912
Livrare imediată!

8,50Lei

Plumb Sondare Carp Spirit Marker Lead 140g

Plumb Sondare Carp Spirit Marker Lead 140g

acs550102
Livrare imediată!

21,00Lei

Plumb cu agrafa Delphin BARBED 120g -30%

Plumb cu agrafa Delphin BARBED 120g

830511120
Livrare imediată!

10,00Lei(-30%) 7,00Lei

PLUMB IN LINE EXTRA CARP PLAT PEAR 100 gr

PLUMB IN LINE EXTRA CARP PLAT PEAR 100 gr

ec3908-100
Livrare imediată!

7,00Lei

PLUMB KORDA CUBIC CU VARTEJ 113G
Exclusiv online!

PLUMB KORDA CUBIC CU VARTEJ 113G

a3.ksqp4
Livrare 24-48 ore

9,79Lei

Momitor Delphin plumb cu tub 50g -33%

Momitor Delphin plumb cu tub 50g

925001045
Livrare imediată!

6,00Lei(-33%) 4,00Lei

Plumb Culisant Arrow Hexagon, 50g

Plumb Culisant Arrow Hexagon, 50g

a3.p50
Livrare imediată!

3,52Lei

PLUMB JIGGING JAXON 30GR 2BUC/PLIC -30%

PLUMB JIGGING JAXON 30GR 2BUC/PLIC

ce-ab30
Livrare imediată!

5,70Lei(-30%) 4,00Lei

PLUMB ENERGOTEAM DROP SHOT CU URECHE 25G

PLUMB ENERGOTEAM DROP SHOT CU URECHE 25G

59217025
Livrare imediată!

3,00Lei

KIT MONTURA PLUMB PIERDUT CARP EXPERT LEAD CLIP CLASSIC 6 BUC/PLIC

KIT MONTURA PLUMB PIERDUT CARP EXPERT LEAD CLIP CLASSIC 6 BUC/PLIC

79032030
Livrare imediată!

7,20Lei

PLUMB LONGCAST JAXON INLINE VERDE 110GR 1BUC/PLIC -30%

PLUMB LONGCAST JAXON INLINE VERDE 110GR 1BUC/PLIC

cp-0033110g
Livrare imediată!

11,00Lei(-30%) 7,70Lei

PLUMB CRAP CU VARTEJ JAXON G VERDE 130GR 1BUC/PLIC -30%

PLUMB CRAP CU VARTEJ JAXON G VERDE 130GR 1BUC/PLIC

cp-0030130g
Livrare imediată!

12,00Lei(-30%) 8,40Lei

Kit Montura Prologic Plumb Pierdut Heavy Duty Long Leadclip w-Pins & Tailrubber, 10 buc/plic

Kit Montura Prologic Plumb Pierdut Heavy Duty Long Leadclip w-Pins & Tailrubber, 10 buc/plic

a.pro.49889
Livrare imediată!

33,62Lei

PLUMB CRAP CU VARTEJ JAXON MARO 110GR -30%

PLUMB CRAP CU VARTEJ JAXON MARO 110GR

cp-0030110
Livrare imediată!

11,50Lei(-30%) 8,10Lei

MOMITOR CU PLUMB JAXON INT 40GR 6.5cm

MOMITOR CU PLUMB JAXON INT 40GR 6.5cm

aj-045m
Livrare imediată!

16,51Lei

Plumb Extra Carp FlatPear cu vartej 100g

Plumb Extra Carp FlatPear cu vartej 100g

ec4868-100
Livrare imediată!

7,50Lei

Momitor Delphin plumb cu tub 40g -20%

Momitor Delphin plumb cu tub 40g

925001040
Livrare imediată!

5,00Lei(-20%) 4,00Lei

PLUMB TORPILA MAVER CULISANTI 1.75GR -20%

PLUMB TORPILA MAVER CULISANTI 1.75GR

129175
Livrare imediată!

13,49Lei(-20%) 10,81Lei

PLUMB LONGCAST JAXON CU ANTITANGLE MARO 80GR

PLUMB LONGCAST JAXON CU ANTITANGLE MARO 80GR

cp-000580
Livrare imediată!

9,70Lei

Afişare 481 - 500 din 1368 (69 pagini)
Queries: 4, Total time: 29.305 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '76b52d5aa58d344026ccea8301'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (29.031)
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('+plumb' 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 (0.118)
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