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


Banda Fixare si Protectie Lansete Nevis, Marime M
Exclusiv online!

Banda Fixare si Protectie Lansete Nevis, Marime M

5109-005
Livrare 48-72 ore

28,60Lei

Protectie Lansete Trakker NXG Elasticated Tip Protectors, 1buc
Exclusiv online!

Protectie Lansete Trakker NXG Elasticated Tip Protectors, 1buc

204926
Livrare 7-14 zile

69,95Lei

Curea Reglabia Benzar Protectie Lansete, 1buc/pac

Curea Reglabia Benzar Protectie Lansete, 1buc/pac

71031050
Livrare imediată!

30,00Lei

Benzi Prindere Lansete Garbolino Neoprene 2.40x3.00x0.4cm
Exclusiv online!

Benzi Prindere Lansete Garbolino Neoprene 2.40x3.00x0.4cm

90530braneo
Livrare 48-72 ore

41,19Lei

Banda Antialunecare Pentru Undita 2.5x180cm

Banda Antialunecare Pentru Undita 2.5x180cm

4962393612771
Livrare imediată!

17,90Lei

Husa Nash Scope Ops 9ft Lightweight Skin
Exclusiv online!

Husa Nash Scope Ops 9ft Lightweight Skin

t3792
Livrare 7-14 zile

251,28Lei

Banda Fixare si Protectie Lansete Nevis, Marime L

Banda Fixare si Protectie Lansete Nevis, Marime L

5109-004
Livrare imediată!

31,50Lei

Banda Prindere Lanseta Mikado, 10buc/pac, 22.5x2.4x1.4cm
Exclusiv online!

Banda Prindere Lanseta Mikado, 10buc/pac, 22.5x2.4x1.4cm

amr07-225
Livrare 48-72 ore

25,00Lei

Dispozitiv Mikado pentru Transport si Protectie Lansete 130-200cm
Exclusiv online!

Dispozitiv Mikado pentru Transport si Protectie Lansete 130-200cm

uwd-mini-130
Livrare 48-72 ore

42,00Lei

Set Huse Protectie Inele Reiva, 18cm, 2buc
Exclusiv online!

Set Huse Protectie Inele Reiva, 18cm, 2buc

5223-001
Livrare 48-72 ore

32,50Lei

Banda Prindere Lanseta Mikado, 10buc/pac, 14.5x2x1.3cm
Exclusiv online!

Banda Prindere Lanseta Mikado, 10buc/pac, 14.5x2x1.3cm

amr07-145
Livrare 48-72 ore

20,00Lei

Banda Prindere Lanseta Mikado, 10buc/pac, 27.5x3x1.9cm
Exclusiv online!

Banda Prindere Lanseta Mikado, 10buc/pac, 27.5x3x1.9cm

amr07-275
Livrare 48-72 ore

35,00Lei

Husa Preston Supera X Tip & Butt Protector 1 Rod

Husa Preston Supera X Tip & Butt Protector 1 Rod

p0130124
Livrare imediată!

58,46Lei

Adaptor Filfishing Protectie Lansete L, 1buc/pac
Exclusiv online!

Adaptor Filfishing Protectie Lansete L, 1buc/pac

fil6694
Livrare 48-72 ore

22,00Lei

Husa Protectie Golden Catch Flexible FRP-02N Grey
Exclusiv online!

Husa Protectie Golden Catch Flexible FRP-02N Grey

gcz-7020306
Livrare 48-72ore

67,50Lei

APARATOARE INELE LANSETE JAXON 7C
Exclusiv online!

APARATOARE INELE LANSETE JAXON 7C

ak-kt007c
Livrare 48-72 ore

54,00Lei

BANDA FIXARE LANSETE JAXON NEGRU 20-15CM
Exclusiv online!

BANDA FIXARE LANSETE JAXON NEGRU 20-15CM

uy-rb03a
Livrare 48-72 ore

27,00Lei

BANDA, FIXARE, LANSETE, JAXON, ALBASTRU, 20-15CM, uy-rb03c, Benzi Fixare / Protectii Lansete, Benzi Fixare / Protectii Lansete Jaxon, Jaxon
APARATOR PROTECTIE NGT PENTRU LANSETE 2BUC/SET

APARATOR PROTECTIE NGT PENTRU LANSETE 2BUC/SET

ngt-fla-tipbutt-184
Livrare imediată!

36,00Lei

BANDA, FIXARE, LANSETE, JAXON, ORANGE, 20-15CM, uy-rb03b, Benzi Fixare / Protectii Lansete, Benzi Fixare / Protectii Lansete Jaxon, Jaxon
Afişare 21 - 40 din 156 (8 pagini)
Queries: 14, Total time: 196.426 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = '0eb6a720ef9637e587ef60c1ff'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (192.745)
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 = '2' AND (pd.tag LIKE "%benzi%") 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:697
5 (0.126)
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:1547
6 (0.922)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.349)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1200
9 (0.113)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1222
10 (0.120)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:987
11 (1.267)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:905
12 (0.113)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.104)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.112)
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