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 300 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


Pelete Gaurite Mivardi Rapid Classic Halibut, 12mm, 10kg
Exclusiv online!

Pelete Gaurite Mivardi Rapid Classic Halibut, 12mm, 10kg

m-rapecha10012
Livrare 48-72 ore

179,00Lei

Agrafa, Rapida, Filfishing, Fastlock, Snap,, Nr.10,, 10buc/plic, FIL6748, Agrafe si Vartejuri Rapitor, Agrafe si Vartejuri Rapitor Filfishing, Agrafe Filfishing, Vartejuri Filfishing, Rapitor Filfishing, Filfishing
Agrafa, Rapida, Owner, Cultiva, Amaz, P-155, 72815, Micro, Silent,, Nr.0,, 9.6kg,15buc/pac, 41402728150, Agrafe si Vartejuri Rapitor, Agrafe si Vartejuri Rapitor Owner, Agrafe Owner, Vartejuri Owner, Rapitor Owner, Owner
Agrafa Rapida Relax Tackle Spiral Quick Snap Nr.2, 0.6mm, 10kg, 10buc/pac

Agrafa Rapida Relax Tackle Spiral Quick Snap Nr.2, 0.6mm, 10kg, 10buc/pac

rqs-#2
Livrare imediată!

12,00Lei

Lanseta Sportex Rapid Spin 240 40g

Lanseta Sportex Rapid Spin 240 40g

rp2402
Livrare imediată!

640,01Lei

Preston ICS In-Line 360 Beads, 6buc/plic -13%

Preston ICS In-Line 360 Beads, 6buc/plic

p0030037
Livrare imediată!

16,01Lei(-13%) 13,99Lei

Set Conectori FL Rapid Magnetic Black Label 4busc/set

Set Conectori FL Rapid Magnetic Black Label 4busc/set

7572330344756
Livrare imediată!

94,90Lei

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

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

41410810311
Livrare imediată!

14,83Lei

Agrafa Rapida si Manson Fox Edges Rig Link and Tungsten Sleeve, 10buc/pac

Agrafa Rapida si Manson Fox Edges Rig Link and Tungsten Sleeve, 10buc/pac

cac880
Livrare imediată!

21,55Lei

Lanseta Sportex Rapid Spin 190 10g

Lanseta Sportex Rapid Spin 190 10g

rp1900
Livrare imediată!

500,00Lei

Lanseta Sportex Rapid Travel Spin 260 40g 4seg
Exclusiv online!

Lanseta Sportex Rapid Travel Spin 260 40g 4seg

rp2602
Livrare 48-72 ore

750,00Lei

Vartej Rapid Nevis Quick Change Swivel, Marime S, Nr.10, 10buc/pac

Vartej Rapid Nevis Quick Change Swivel, Marime S, Nr.10, 10buc/pac

5572-010
Livrare imediată!

8,29Lei

Agrafa Rapida Lucky John Power Lure Snap LJP5126 Nr.004, 60kg, 5buc/plic

Agrafa Rapida Lucky John Power Lure Snap LJP5126 Nr.004, 60kg, 5buc/plic

ljp5126-004
Livrare imediată!

8,98Lei

Agrafa Rapida Zeck 114kg Crosslock Snap 3buc

Agrafa Rapida Zeck 114kg Crosslock Snap 3buc

41405110114
Livrare imediată!

9,78Lei

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

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

t8751
Livrare 7-14 zile

27,00Lei

Lanseta Sportex Rapid Spin 210 10g

Lanseta Sportex Rapid Spin 210 10g

rp2100
Livrare imediată!

519,99Lei

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, 5564-011, Vartejuri, Vartejuri Carp Academy, Vartejuri Carp Academy, Carp Academy
Vartej, Rolling, Simplu, +, Agrafa, Rapida, Garbolino, Spirale, nr.12,, 10buc, 41405gotah0198-000, Agrafe Monturi, Agrafe Monturi Garbolino, Agrafe Garbolino, Monturi Garbolino, Garbolino
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

Afişare 441 - 460 din 616 (31 pagini)
Queries: 9, Total time: 209.238 ms [By time] [By id] [By file]
1 (0.091)
SELECT data
FROM `oc_session`
WHERE session_id = '2ebb8ebdd68dc40afc23228762'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (205.632)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%rapid%") 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:698
5 (0.170)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
6 (2.773)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 440, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.123)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.114)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.131)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38