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 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Filtreaza

Husa Lansete Cu Mulineta Jaxon X-team, 3 Compartimente, 100cm -21%

Husa Lansete Cu Mulineta Jaxon X-team, 3 Compartimente, 100cm

uj-xau100
Stoc epuizat

99,00Lei(-21%) 78,54Lei

Husa Delphin Feeder Elita 135cm -59%

Husa Delphin Feeder Elita 135cm

430409135
Stoc epuizat

153,00Lei(-59%) 62,69Lei

Husa Rigida Lansete Cu Mulineta Carp Expert 2 Compartimente, 190cm -26%

Husa Rigida Lansete Cu Mulineta Carp Expert 2 Compartimente, 190cm

73154190
Stoc epuizat

274,21Lei(-26%) 203,94Lei

Husa Lansete Jaxon X-team Camou, 3 Compartimente, 150cm -22%

Husa Lansete Jaxon X-team Camou, 3 Compartimente, 150cm

uj-xdc150
Stoc epuizat

168,00Lei(-22%) 130,90Lei

Husa Lansete Jaxon X-team Camou, 3 Compartimente, 140cm -21%

Husa Lansete Jaxon X-team Camou, 3 Compartimente, 140cm

uj-xdc140
Stoc epuizat

150,00Lei(-21%) 117,81Lei

Husa Lansete Jaxon Rigida Dubla X-team Camou, 150cm -22%

Husa Lansete Jaxon Rigida Dubla X-team Camou, 150cm

uj-xda150
Stoc epuizat

209,00Lei(-22%) 163,03Lei

Husa Rigida Mikado 1 Lanseta + 1 Mulineta 135x13.4cm -20%

Husa Rigida Mikado 1 Lanseta + 1 Mulineta 135x13.4cm

uwd-mf21-135
Stoc epuizat

154,00Lei(-20%) 122,76Lei

Husa Rigida Lansete Cu Mulineta Carp Expert 2 Compartimente, 145cm -33%

Husa Rigida Lansete Cu Mulineta Carp Expert 2 Compartimente, 145cm

73154145
Stoc epuizat

277,00Lei(-33%) 184,45Lei

Husa Mikado Surfcasting 3 Compartimente 150 Cm -21%

Husa Mikado Surfcasting 3 Compartimente 150 Cm

uwd-su02-3-150
Stoc epuizat

411,00Lei(-21%) 326,48Lei

Husa Lanseta Cu Mulineta Daiwa Widow, 3 Posturi, 12ft/202x35x15cm -23%

Husa Lanseta Cu Mulineta Daiwa Widow, 3 Posturi, 12ft/202x35x15cm

a8.18705.312
Stoc epuizat

360,18Lei(-23%) 277,06Lei

Husa Lanseta Cormoran 5097, 3 Posturi, 155cm -39%

Husa Lanseta Cormoran 5097, 3 Posturi, 155cm

a8.65.09755
Stoc epuizat

291,47Lei(-39%) 177,12Lei

Husa Fox Camolite, 10ft Rod Case 2+2, 166x25x21cm -27%

Husa Fox Camolite, 10ft Rod Case 2+2, 166x25x21cm

clu401
Stoc epuizat

593,95Lei(-27%) 436,29Lei

Husa Dam Intenze Pentru 3 Lansete Cu Mulineta, 130x31x29cm -23%

Husa Dam Intenze Pentru 3 Lansete Cu Mulineta, 130x31x29cm

a8.dam.60358
Stoc epuizat

280,05Lei(-23%) 215,43Lei

Husa Mikado Rigida Stand Up 3 Lansete + 3 Mulinete 150cm -36%

Husa Mikado Rigida Stand Up 3 Lansete + 3 Mulinete 150cm

uwd-06-150-3-gy
Stoc epuizat

429,00Lei(-36%) 274,05Lei

Husa Laneste Jrc Defender Holdall 12ft, 3+3 Rod Sleeve -21%

Husa Laneste Jrc Defender Holdall 12ft, 3+3 Rod Sleeve

1445860
Stoc epuizat

292,45Lei(-21%) 230,09Lei

Husa Semirigida Mikado 1 Lanseta + 1 Mulineta 150cm -40%

Husa Semirigida Mikado 1 Lanseta + 1 Mulineta 150cm

uwd-13001g-150
Stoc epuizat

211,00Lei(-40%) 127,08Lei

Husa Rigida Lansete Cu Mulineta Mivardi Feeder Tmx Xtra Safe, 3 Compartimente, 141x15cm -29%

Husa Rigida Lansete Cu Mulineta Mivardi Feeder Tmx Xtra Safe, 3 Compartimente, 141x15cm

m-tmxrhxs
Stoc epuizat

295,00Lei(-29%) 210,71Lei

Husa Nash Subterfuge Soft Protect 3 Rod Skin, 13ft/3.90m

Husa Nash Subterfuge Soft Protect 3 Rod Skin, 13ft/3.90m

t3356
Stoc epuizat

689,99Lei

Husa Nash Subterfuge Soft Protect 3 Rod Skin, 12ft/3.60m

Husa Nash Subterfuge Soft Protect 3 Rod Skin, 12ft/3.60m

t3350
Stoc epuizat

639,99Lei

Husa Nash Subterfuge Soft Protect 3 Rod Skin, 10ft/3.00m

Husa Nash Subterfuge Soft Protect 3 Rod Skin, 10ft/3.00m

t3344
Stoc epuizat

589,99Lei

Afişare 601 - 620 din 637 (32 pagini)

Descoperă gama noastră de huse lansete echipate cu mulinete, soluția ideală pentru protejarea echipamentului de pescuit.
Aceste huse sunt fabricate din materiale impermeabile și rezistente, garantând durabilitate în orice condiții.
Designul ergonomic al huselor optimizează organizarea și asigură un acces rapid la toate accesoriile esențiale.
Fiecare husă dispune de compartimente specializate pentru depozitarea sigură a mulinetelor și lansetelor.
Modelele moderne combină tehnologia avansată cu finisaje premium pentru un aspect atrăgător.
Huse lansete cu mulinete sunt ideale pentru pescuitul sportiv și profesionist, oferind protecție sporită.
Soluțiile inovatoare asigură transportul eficient al echipamentelor în orice expediție.
Husele sunt ușor de curățat și întreținut, menținând performanța ridicată pe termen lung.
Alege huse lansete echipate cu mulinete pentru o experiență de pescuit sigură și de succes.

Queries: 17, Total time: 39.819 ms [By time] [By id] [By file]
1 (0.178)
SELECT data
FROM `oc_session`
WHERE session_id = '7f660cbc62d8152b4407af1ea7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.140)
SELECT *
FROM oc_url_alias
WHERE keyword = 'bagajerie'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'huse'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.071)
SELECT *
FROM oc_url_alias
WHERE keyword = 'huse-lansete-cu-mulinete'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
6 (0.405)
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 = '587' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
7 (10.544)
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, "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_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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND p2c.category_id = '587' 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
8 (0.205)
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
9 (2.701)
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 600, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
10 (18.973)
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
11 (0.640)
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
12 (0.072)
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
13 (0.198)
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
14 (5.069)
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:1094
15 (0.136)
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 '%"587"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
16 (0.162)
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 '%"587"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
17 (0.097)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37