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


VARTEJ ROLLING CU CARABINA MAVER ELITE NR 6 - 30 KG -30%

VARTEJ ROLLING CU CARABINA MAVER ELITE NR 6 - 30 KG

1508006
Livrare imediată!

21,00Lei(-30%) 14,70Lei

Vartej Agrafa Owner 52459 Nr 16 Sinker Hook W Crane

Vartej Agrafa Owner 52459 Nr 16 Sinker Hook W Crane

410020012
Livrare imediată!

27,99Lei

PLUMB DROP SHOT JAXON BETISOR CU VARTEJ 15GR

PLUMB DROP SHOT JAXON BETISOR CU VARTEJ 15GR

cp-dr15
Livrare imediată!

9,00Lei

VARTEJ ROLLING CU CARABINA MAVER ELITE NR 14 - 18 KG -30%
Exclusiv online!

VARTEJ ROLLING CU CARABINA MAVER ELITE NR 14 - 18 KG

1508014
Livrare 48-72 ore

18,00Lei(-30%) 12,60Lei

Vartej Sunset ST Rolling Diamond ST-S-1003 Nr14 4kg
Exclusiv online!

Vartej Sunset ST Rolling Diamond ST-S-1003 Nr14 4kg

412013210
Livrare 48-72 ore

9,09Lei

Vartej Owner Amaz 72445 KS-11 Rolling King Stainless Swivel, Nr.6, 45kg, 15buc

Vartej Owner Amaz 72445 KS-11 Rolling King Stainless Swivel, Nr.6, 45kg, 15buc

407260005
Livrare imediată!

14,30Lei

Vartej Sunset ST Rolling Titanium ST-S-1007 Nr1 47kg -24%

Vartej Sunset ST Rolling Titanium ST-S-1007 Nr1 47kg

412011160
Livrare imediată!

7,79Lei(-24%) 5,90Lei

Vartej Sunset ST Rolling Diamond ST-S-1003 Nr12 7kg
Exclusiv online!

Vartej Sunset ST Rolling Diamond ST-S-1003 Nr12 7kg

412013206
Livrare 48-72 ore

9,09Lei

VARTEJ ROLLING CU CARABINA MAVER ELITE NR 16 - 16 KG -30%
Exclusiv online!

VARTEJ ROLLING CU CARABINA MAVER ELITE NR 16 - 16 KG

1508016
Livrare 48-72 ore

18,00Lei(-30%) 12,60Lei

AGRAFA+VARTEJ DAIWA EGG NR.4/15,0KG/10BUC/PL

AGRAFA+VARTEJ DAIWA EGG NR.4/15,0KG/10BUC/PL

a7.14905.704
Livrare imediată!

9,17Lei

Vartej Lineaeffe Culisant cu Margele 12buc/plic Marime:M

Vartej Lineaeffe Culisant cu Margele 12buc/plic Marime:M

a7.4990305
Livrare imediată!

15,73Lei

Vartej Owner Rolling Dublu W Crane 52457, No.20, 6.8kg, 12buc/plic -28%

Vartej Owner Rolling Dublu W Crane 52457, No.20, 6.8kg, 12buc/plic

410020005
Livrare imediată!

23,40Lei(-28%) 16,90Lei

VARTEJ JAXON TRIPLU NR 8

VARTEJ JAXON TRIPLU NR 8

aj-kr15008c
Livrare imediată!

7,00Lei

Strune Profi-Blinker cu vartej/agrafa Fast Lock 1x7/9kg/30cm
Exclusiv online!

Strune Profi-Blinker cu vartej/agrafa Fast Lock 1x7/9kg/30cm

716b9
Livrare 48-72 ore

50,00Lei

Vartej Carp Academy Cu Agrafa Rapida

Vartej Carp Academy Cu Agrafa Rapida

6427-004
Livrare imediată!

12,99Lei

VARTEJ CU CARABINA MAVER NR 4
Exclusiv online!

VARTEJ CU CARABINA MAVER NR 4

1501004
Livrare 48-72 ore

13,49Lei

Vartej Owner 52445 Rolling King Stainless Swivel KS-11, 81kg, Nr.4, 11buc/plic
Exclusiv online!

Vartej Owner 52445 Rolling King Stainless Swivel KS-11, 81kg, Nr.4, 11buc/plic

407020001
Livrare 48-72 ore

19,88Lei

VARTEJ SIMPLU JAXON NR 18

VARTEJ SIMPLU JAXON NR 18

aj-kr10118c
Livrare imediată!

3,00Lei

Vartej Sunset ST Rolling Swivel ST-S-1001 Nr12 9kg

Vartej Sunset ST Rolling Swivel ST-S-1001 Nr12 9kg

412011140
Livrare imediată!

9,09Lei

VARTEJ STRONG JAXON NR 12

VARTEJ STRONG JAXON NR 12

aj-kr10312c
Livrare imediată!

4,00Lei

Afişare 881 - 900 din 1798 (90 pagini)
Queries: 4, Total time: 32.901 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = '2dfad16854ee19d497665e559a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (32.504)
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('+vartej' 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.165)
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