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


Agrafa Vartej Sunset ST Rolling Offset Snap ST-S-3007 Nr10 7kg
Exclusiv online!

Agrafa Vartej Sunset ST Rolling Offset Snap ST-S-3007 Nr10 7kg

412015411
Livrare 48-72 ore

9,09Lei

EXTRA CARP VARTEJ CU AGRAFA HOOK Nr 12/17Kg/10Buc/Plic

EXTRA CARP VARTEJ CU AGRAFA HOOK Nr 12/17Kg/10Buc/Plic

ec2949
Livrare imediată!

6,00Lei

Portofel pentru Monturi Spro 10 Plicuri cu Fermoar
Exclusiv online!

Portofel pentru Monturi Spro 10 Plicuri cu Fermoar

006100-00005-00000
Livrare 48-72 ore

89,00Lei

Montura Savage Gear Titan Corkscrew, 2 Ancore, Nr.1/0

Montura Savage Gear Titan Corkscrew, 2 Ancore, Nr.1/0

a.sg.61774
Livrare imediată!

43,14Lei

VARTEJ SPRO CILINDRIC CU AGRAFA DE SIGURANTA NR 4 28 KG 10 BUC

VARTEJ SPRO CILINDRIC CU AGRAFA DE SIGURANTA NR 4 28 KG 10 BUC

004553-00104-00000
Livrare imediată!

8,90Lei

PB HIT RUN TAILRUBBERS LEAD CLIPS SILT

PB HIT RUN TAILRUBBERS LEAD CLIPS SILT

pb22141
Livrare imediată!

16,01Lei

Buffer Beads CARP ZOOM TIP GLONT 12 MM VERDE

Buffer Beads CARP ZOOM TIP GLONT 12 MM VERDE

cz1755
Livrare imediată!

9,00Lei

Fir Textil Benzar Braided Method Hooklink 10M, 0.12mm, 7.65kg

Fir Textil Benzar Braided Method Hooklink 10M, 0.12mm, 7.65kg

30598012
Livrare imediată!

13,99Lei

Kit Montura Plumb Pierdut si Agrafa Prologic Mimicry 10 buc/plic

Kit Montura Plumb Pierdut si Agrafa Prologic Mimicry 10 buc/plic

a.pro.54405
Livrare imediată!

35,51Lei

Agrafa Spro Rapida Nr 4 Cu Vartej Cilindric 10 Buc 30 Kg
Exclusiv online!

Agrafa Spro Rapida Nr 4 Cu Vartej Cilindric 10 Buc 30 Kg

004553-00404-00000
Livrare 48-72 ore

9,90Lei

Fir Multifilament Nevis S Braid 15m 0.16mm

Fir Multifilament Nevis S Braid 15m 0.16mm

3227-016
Livrare imediată!

13,99Lei

MONTURA CORMORAN CLASIC RIG T4 NR.4/2BUC
Exclusiv online!

MONTURA CORMORAN CLASIC RIG T4 NR.4/2BUC

a.11.02303.4
Livrare 24-48 ore

21,87Lei

SET CARP SPIRIT 3BUC ANTI TANGLE LEAD CLIP CAMFUSION -21%

SET CARP SPIRIT 3BUC ANTI TANGLE LEAD CLIP CAMFUSION

acs010226
Livrare imediată!

42,99Lei(-21%) 33,90Lei

KIT FOX RAGE STRUNA CU ANCORA 10CM 12KG NR 4 2BUC
Exclusiv online!

KIT FOX RAGE STRUNA CU ANCORA 10CM 12KG NR 4 2BUC

nsh035
Livrare 7-14 zile

22,46Lei

FIR COLMIC FLUOROCARBON WIND 50M 0.409mm
Exclusiv online!

FIR COLMIC FLUOROCARBON WIND 50M 0.409mm

nywin40
Livrare 48-72 ore

79,00Lei

Fir Carp Expert Neutral Buoyancy 15lbs Pitch Black
Exclusiv online!

Fir Carp Expert Neutral Buoyancy 15lbs Pitch Black

31554154
Livrare 24-48 ore

12,99Lei

Vartej Spro Butoias Cu Agrafa Interlock Nr 14 10 Buc 9 Kg

Vartej Spro Butoias Cu Agrafa Interlock Nr 14 10 Buc 9 Kg

004551-00114-00000
Livrare imediată!

6,00Lei

MONTURA CORMORAN LINE ALIGNER RIG T3 NR.4/2BUC
Exclusiv online!

MONTURA CORMORAN LINE ALIGNER RIG T3 NR.4/2BUC

a.11.02301.4
Livrare 24-48 ore

22,40Lei

EXTRA CARP VARTEJ CU AGRAFA HOOK Nr 8 /22Kg/10Buc/Plic

EXTRA CARP VARTEJ CU AGRAFA HOOK Nr 8 /22Kg/10Buc/Plic

ec2925
Livrare imediată!

7,00Lei

Kit Montura Jaxon Plumb Pierdut

Kit Montura Jaxon Plumb Pierdut

ac-356411
Livrare imediată!

4,50Lei

Afişare 1721 - 1740 din 4580 (229 pagini)
Queries: 4, Total time: 91.481 ms [By time] [By id] [By file]
1 (0.156)
SELECT data
FROM `oc_session`
WHERE session_id = '74f64aefeb548f440e67fa6c6b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (91.022)
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('+monturi' 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.216)
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