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


SET MOMITOARE GENLOG WING SVL 20/30 GR 34 MM
Exclusiv online!

SET MOMITOARE GENLOG WING SVL 20/30 GR 34 MM

fmc-sifws-20/30
Livrare 48-72 ore

20,50Lei

SET PLUMBI JAXON OLIVETA NR 4 480GR 3/5/7/10/15/20GR -24%

SET PLUMBI JAXON OLIVETA NR 4 480GR 3/5/7/10/15/20GR

cc-z004
Livrare imediată!

78,00Lei(-24%) 59,50Lei

SET CUTII JAXON RIGURI ACCESORII CRAP 35x19x6cm -20%

SET CUTII JAXON RIGURI ACCESORII CRAP 35x19x6cm

rh-322
Livrare imediată!

169,00Lei(-20%) 135,90Lei

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

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

af-er230x
Livrare imediată!

55,00Lei

SET PLUMBI EXTRA CARP 6 COMPARTIMENTE 0.15-1gr

SET PLUMBI EXTRA CARP 6 COMPARTIMENTE 0.15-1gr

ec5681
Livrare imediată!

12,99Lei

Set inele varf Kamasaki OSEG 5-25 55 BUC

Set inele varf Kamasaki OSEG 5-25 55 BUC

82970010
Livrare imediată!

70,00Lei

Set plumbi Jaxon AA006 100gr

Set plumbi Jaxon AA006 100gr

cj-aa006
Livrare imediată!

19,00Lei

Set hangere Baracuda cu iluminare 4buc/set

Set hangere Baracuda cu iluminare 4buc/set

set 4 hanger cu iluminare, 4 culori diferite 4 blister
Livrare imediată!

107,67Lei

Set Plumbi Filfishing Despicati 5 Compartimente 0.70-3.00g

Set Plumbi Filfishing Despicati 5 Compartimente 0.70-3.00g

fil1928
Livrare imediată!

11,00Lei

SET CROSETE BOILIES CARP EXPERT
Exclusiv online!

SET CROSETE BOILIES CARP EXPERT

80203065
Livrare 24-48 ore

20,40Lei

MOMITOR JAXON FEEDER PATRAT Z 30GR 25X30X44mm 10 buc/set -20%

MOMITOR JAXON FEEDER PATRAT Z 30GR 25X30X44mm 10 buc/set

aw-kb030-bucxxx
Livrare imediată!

10,00Lei(-20%) 8,00Lei

Set Inele SiC Sea Guide plus Mandrina nr. 6 ALPS Trabucco Assembly Set 7

Set Inele SiC Sea Guide plus Mandrina nr. 6 ALPS Trabucco Assembly Set 7

121-15-007
Livrare imediată!

158,00Lei

Set method feeder Filfishing filex 3+1buc/set 20g 30g 40g

Set method feeder Filfishing filex 3+1buc/set 20g 30g 40g

fil4422
Livrare imediată!

26,50Lei

Set Linii Nevis Complete Model 10 0.50g

Set Linii Nevis Complete Model 10 0.50g

4135-050
Livrare imediată!

15,01Lei

Set varfuri Delphin LYCAN TeleFEEDER UL+L+M CarbonGLASS

Set varfuri Delphin LYCAN TeleFEEDER UL+L+M CarbonGLASS

101001303
Livrare imediată!

101,00Lei

Set Linii Nevis Complete Model 2 0.50g
Exclusiv online!

Set Linii Nevis Complete Model 2 0.50g

4121-050
Livrare 48-72 ore

10,00Lei

Set Varnis FALCON Silicone Tube Mix 4cm, 0.3-0.5-0.8-1.0-1.2mm

Set Varnis FALCON Silicone Tube Mix 4cm, 0.3-0.5-0.8-1.0-1.2mm

f9197
Livrare imediată!

19,50Lei

Set Swinger Baracuda SW-015C 4buc/set

Set Swinger Baracuda SW-015C 4buc/set

set 4 swinger sw-015c
Livrare imediată!

253,90Lei

Set method feeder Filfishing filex 3+1buc/set 40g 50g 60g

Set method feeder Filfishing filex 3+1buc/set 40g 50g 60g

fil4439
Livrare imediată!

28,50Lei

SET MONTURI PLUMB PIERDUT 3BUC PL KORDA
Exclusiv online!

SET MONTURI PLUMB PIERDUT 3BUC PL KORDA

a.llhcw
Livrare 24-48 ore

41,78Lei

Afişare 601 - 620 din 1643 (83 pagini)
Queries: 4, Total time: 43.205 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = '37f803e73cbfc1c7464669770c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (42.787)
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 (MATCH(pd.tag) AGAINST('+set' 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.194)
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