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 Nevis X-Strong, Nr.12, 10buc/pac

Vartej Nevis X-Strong, Nr.12, 10buc/pac

5575-012
Livrare imediată!

4,30Lei

Vartej Rapid cu Anou Carp Academy, Marime M, Nr.8, 10buc/pac
Exclusiv online!

Vartej Rapid cu Anou Carp Academy, Marime M, Nr.8, 10buc/pac

5564-008
Livrare 48-72 ore

10,20Lei

Vartej Rapid cu Anou Carp Academy, Marime S, Nr.11, 10buc/pac
Exclusiv online!

Vartej Rapid cu Anou Carp Academy, Marime S, Nr.11, 10buc/pac

5564-011
Livrare 48-72 ore

10,20Lei

Vartej Rolling Simplu + Agrafa Rapida Garbolino Spirale nr.12, 10buc
Exclusiv online!

Vartej Rolling Simplu + Agrafa Rapida Garbolino Spirale nr.12, 10buc

41405gotah0198-000
Livrare 48-72 ore

15,26Lei

Vartej Rolling Sunset ST-S-1001 Nr.14, 4kg, 20buc/pac

Vartej Rolling Sunset ST-S-1001 Nr.14, 4kg, 20buc/pac

41411stsab1034n144kg
Livrare imediată!

9,09Lei

Agrafa Berkley McMahon Ball Bearing Swivels + Vartej cu Rulment, Inox Nr.4, 2buc/plic
Exclusiv online!

Agrafa Berkley McMahon Ball Bearing Swivels + Vartej cu Rulment, Inox Nr.4, 2buc/plic

1280539
Livrare 7-14 zile

21,34Lei

Agrafa cu Vartej DAM D-Lock Nr.6, 21kg, 10buc/pac
Exclusiv online!

Agrafa cu Vartej DAM D-Lock Nr.6, 21kg, 10buc/pac

a7.dam.56441
Livrare 24-48 ore

11,94Lei

Agrafa cu Vartej Lucky John Duolock Nr.008, 18kg, 10buc/plic

Agrafa cu Vartej Lucky John Duolock Nr.008, 18kg, 10buc/plic

ljp5101-008
Livrare imediată!

10,00Lei

Agrafa cu Vartej Lucky John Duolock Nr.012, 9kg, 10buc/plic

Agrafa cu Vartej Lucky John Duolock Nr.012, 9kg, 10buc/plic

ljp5101-012
Livrare imediată!

10,00Lei

Agrafa Filex + Vartej cu Rulment BB Swivel & Castlock Snap, Nr.5, 55kg, 5buc/plic
Exclusiv online!

Agrafa Filex + Vartej cu Rulment BB Swivel & Castlock Snap, Nr.5, 55kg, 5buc/plic

fil2373
Livrare 48-72 ore

15,01Lei

Clips Plumb Piedut Nash Speed Ezi Drop Lead Clip Silt + Vartej cu Agrafa Rapida, 8buc/pac
Exclusiv online!

Clips Plumb Piedut Nash Speed Ezi Drop Lead Clip Silt + Vartej cu Agrafa Rapida, 8buc/pac

t8761
Livrare 7-14 zile

29,99Lei

Momitor Inchis cu Vartej Lineaeffe Feeder Scoop Square 35g
Exclusiv online!

Momitor Inchis cu Vartej Lineaeffe Feeder Scoop Square 35g

a.4922840
Livrare 24-48 ore

15,73Lei

Plumb Bead Orange cu Vartej, 142g

Plumb Bead Orange cu Vartej, 142g

40341lb2142
Livrare imediată!

9,94Lei

Plumb cu Vartej Delphin Cyber BARBED, 80g -21%

Plumb cu Vartej Delphin Cyber BARBED, 80g

101003708
Livrare imediată!

8,00Lei(-21%) 6,30Lei

Plumb Distance Orange cu Vartej, 113g
Exclusiv online!

Plumb Distance Orange cu Vartej, 113g

40341ld2113
Livrare 48-72 ore

10,91Lei

Plumb Feed Orange cu Vartej, 85g

Plumb Feed Orange cu Vartej, 85g

40341lf285
Livrare imediată!

7,12Lei

Plumb Lacrimă cu Vartej Delphin AeroTEAR, 60g

Plumb Lacrimă cu Vartej Delphin AeroTEAR, 60g

101003713
Livrare imediată!

7,00Lei

Vartej cu Margea Culisanta Filfishing Moving Head Swivel M, 5buc/pac

Vartej cu Margea Culisanta Filfishing Moving Head Swivel M, 5buc/pac

fil2054-m
Livrare imediată!

6,00Lei

Vartej Nevis X-Strong, Nr.18, 10buc/pac

Vartej Nevis X-Strong, Nr.18, 10buc/pac

5575-018
Livrare imediată!

4,30Lei

Vartej Rapid Rive Quick Connect Rolling Nr.12, 6buc/pac

Vartej Rapid Rive Quick Connect Rolling Nr.12, 6buc/pac

41410810310
Livrare imediată!

14,83Lei

Afişare 1141 - 1160 din 1797 (90 pagini)
Queries: 4, Total time: 35.014 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = 'c63566f3e5bddb431c072be79c'
/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 (34.622)
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.153)
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