Pentru o livrare cat mai rapida va recomandam sa alegeti produse cu stoc in Magazin fizic si in Depozit Online. Produsele cu Stoc furnizor au termen de livrare mai mare si pot intarzia comanda dvs.
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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Filtreaza

Suport Riguri Jaxon Pluta 16cm

Suport Riguri Jaxon Pluta 16cm

ak-kl002
Livrare imediată!

8,12Lei

Suport Riguri Jaxon Cu Arc Jaxon 28cm

Suport Riguri Jaxon Cu Arc Jaxon 28cm

ak-dr002
Livrare imediată!

33,54Lei

Penar Jaxon Inaintas Lux 24cm
Exclusiv online!

Penar Jaxon Inaintas Lux 24cm

ak-dr901
Livrare 48-72 ore

56,92Lei

Penar Jaxon Inaintas Lux 34cm
Exclusiv online!

Penar Jaxon Inaintas Lux 34cm

ak-dr902
Livrare 48-72 ore

60,98Lei

Suport Inaintas Jaxon Eva 10cm

Suport Inaintas Jaxon Eva 10cm

ac-4637
Livrare imediată!

14,22Lei

Suport Inaintas Jaxon Cu Pluta 15cm
Exclusiv online!

Suport Inaintas Jaxon Cu Pluta 15cm

ac-4638
Livrare 48-72 ore

17,27Lei

Penar Jaxon Inaintas 26cm
Exclusiv online!

Penar Jaxon Inaintas 26cm

ac-8888b
Livrare 48-72 ore

62,01Lei

Suport Inaintas Jaxon Cu Pluta 10cm
Exclusiv online!

Suport Inaintas Jaxon Cu Pluta 10cm

ac-4639
Livrare 48-72 ore

14,73Lei

Portofel Jaxon Inaintas 45cm
Exclusiv online!

Portofel Jaxon Inaintas 45cm

ak-dr006
Livrare 48-72 ore

44,72Lei

Penar Jaxon Inaintas 40cm
Exclusiv online!

Penar Jaxon Inaintas 40cm

ac-8888a
Livrare 48-72 ore

62,01Lei

Penar Rigid Jaxon Pentru Riguri 35x11x7cm

Penar Rigid Jaxon Pentru Riguri 35x11x7cm

rh-321
Livrare imediată!

97,60Lei

Penar Jaxon Riguri Fishing Team 14x36.5x3cm
Exclusiv online!

Penar Jaxon Riguri Fishing Team 14x36.5x3cm

uj-xca04
Livrare 48-72 ore

107,76Lei

Portofel Inaintas Jaxon Method Feeder 15cm
Exclusiv online!

Portofel Inaintas Jaxon Method Feeder 15cm

ak-dr900
Livrare 48-72 ore

56,92Lei

Portofel Jaxon Leaders 35cm
Exclusiv online!

Portofel Jaxon Leaders 35cm

ak-dr911
Livrare 48-72 ore

67,09Lei

Portofel Jaxon Leaders 40cm
Exclusiv online!

Portofel Jaxon Leaders 40cm

ak-dr912
Livrare 48-72 ore

73,19Lei

Penar Pentru Riguri Jaxon, 35x11x4cm
Exclusiv online!

Penar Pentru Riguri Jaxon, 35x11x4cm

uj-xca09b
Livrare 48-72 ore

91,50Lei

Penar Pentru Riguri Jaxon, 24x11x4cm
Exclusiv online!

Penar Pentru Riguri Jaxon, 24x11x4cm

uj-xca09a
Livrare 48-72 ore

87,43Lei

Portofel Jaxon Spinning X-team 16x14x2cm 6 Compartimente -24%

Portofel Jaxon Spinning X-team 16x14x2cm 6 Compartimente

uj-xtg02
Stoc epuizat

58,96Lei(-24%) 44,77Lei

Penar Rigid Jaxon Pentru Riguri 25x9x5cm -23%

Penar Rigid Jaxon Pentru Riguri 25x9x5cm

rh-320
Stoc epuizat

75,23Lei(-23%) 58,08Lei

Portofel Jaxon Leaders 25cm -23%

Portofel Jaxon Leaders 25cm

ak-dr910
Stoc epuizat

59,97Lei(-23%) 45,98Lei

Afişare 1 - 20 din 20 (1 pagini)

Descoperă gama noastră de penare pentru cârlige legate, ideale pentru organizarea și protecția echipamentului tău de pescuit.
Aceste penare sunt fabricate din materiale rezistente și impermeabile, oferind protecție maximă împotriva umezelii și deteriorării.
Designul compact și compartimentarea inteligentă permit depozitarea ordonată a cârligelor legate.
Penarele pentru cârlige legate sunt esențiale pentru pescarii sportivi și profesioniști, asigurând acces rapid la echipament.
Materialele durabile și finisajele premium asigură o utilizare îndelungată și siguranță maximă.
Modelele sunt ușor de curățat, menținând echipamentul în stare perfectă pentru fiecare partidă de pescuit.
Soluțiile inovatoare optimizează depozitarea și protecția cârligelor împotriva uzurii.
Produsele sunt testate pentru rezistență la intemperii și durabilitate în orice condiții de pescuit.
Aceste penare sunt ideale pentru transport sigur și organizare eficientă.
Alege penare pentru cârlige legate pentru un pescuit organizat și de succes.

Queries: 16, Total time: 5.568 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = 'd54c7b07201b6350c90eac215a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.106)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Jaxon'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.484)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '113' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
5 (1.855)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) ENGINE=InnoDB SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, if (SUM(if((f.filter_group = "m0" AND filter_id IN (42)), 1, 0)) > 0, 1, 0) 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_to_category` AS p2c ON (p.product_id = p2c.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 p2c.category_id = '113' AND p.manufacturer_id = '42' 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:857
6 (0.116)
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:1593
7 (0.263)
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 DESC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (1.338)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN `oc_bf_tmp_product` AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND match_filters = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, CAST(av.value AS UNSIGNED), av.value
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1286
9 (0.149)
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:1393
10 (0.081)
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:1415
11 (0.070)
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:1180
12 (0.312)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1094
13 (0.112)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1134
14 (0.198)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"113"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
15 (0.150)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"113"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
16 (0.117)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37