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 Pentru Scaun Modular Preston Inception Seatbox Cover
Exclusiv online!

Husa Pentru Scaun Modular Preston Inception Seatbox Cover

p0890026
Livrare 7-14 zile

103,46Lei

Husa Pat Trakker Nxg Bedchair Bag Wide, 115x100x25cm
Exclusiv online!

Husa Pat Trakker Nxg Bedchair Bag Wide, 115x100x25cm

204959
Livrare 7-14 zile

349,96Lei

Husa Pat Trakker Nxg Bedchair Bag Standard, 115x85x25cm

Husa Pat Trakker Nxg Bedchair Bag Standard, 115x85x25cm

204958
Livrare imediată!

324,95Lei

Husa Pat Jrc Defender Ii Bedchair Bag Standard, 77x80x30cm

Husa Pat Jrc Defender Ii Bedchair Bag Standard, 77x80x30cm

1598178
Livrare imediată!

204,00Lei

Husa Pat Jrc Defender Ii Bedchair Bag Wide, 90x80x33cm

Husa Pat Jrc Defender Ii Bedchair Bag Wide, 90x80x33cm

1598219
Livrare imediată!

225,01Lei

Husa Scaun Preston Supera X Chair Bag
Exclusiv online!

Husa Scaun Preston Supera X Chair Bag

p0130159
Livrare 7-14 zile

404,96Lei

Husa Pat Ngt Deluxe Xl, 100x95x25cm

Husa Pat Ngt Deluxe Xl, 100x95x25cm

fla-bedbag-xl-589
Livrare imediată!

197,60Lei

Husa Pat Fox Voyager Bedchair Bag, Large, 95x95x30cm

Husa Pat Fox Voyager Bedchair Bag, Large, 95x95x30cm

clu573
Livrare imediată!

314,96Lei

Husa Pat Fox Voyager Bedchair Bag, 86x85x25cm

Husa Pat Fox Voyager Bedchair Bag, 86x85x25cm

clu572
Livrare imediată!

269,96Lei

Husa Pat Fox Camolite Bedchair Carrybag, Large, 95x117x33cm

Husa Pat Fox Camolite Bedchair Carrybag, Large, 95x117x33cm

clu527
Livrare imediată!

382,45Lei

Husa Pat Fox Camolite Bedchair Carrybag, 95x80x22cm

Husa Pat Fox Camolite Bedchair Carrybag, 95x80x22cm

clu526
Livrare imediată!

314,96Lei

Husa Transport Scaun Confort Quatro Mivardi

Husa Transport Scaun Confort Quatro Mivardi

m-tbc
Livrare imediată!

135,01Lei

Ngt Husa Pt Pat Deluxe 80 X 86 X 22 Cm

Ngt Husa Pt Pat Deluxe 80 X 86 X 22 Cm

ngt-fla-bedbag-598
Livrare imediată!

155,00Lei

Husa Transport Mivardi Pat Professional 8 Picioare 83x75x22cm

Husa Transport Mivardi Pat Professional 8 Picioare 83x75x22cm

m-tbbchpro8
Livrare imediată!

155,00Lei

Husa Carp Zoom Pentru Pat Waterproof 86x215x21cm
Exclusiv online!

Husa Carp Zoom Pentru Pat Waterproof 86x215x21cm

cz0177
Livrare 48-72 ore

95,00Lei

Husa Scaun Fox Waterproof Chair Cover Xl

Husa Scaun Fox Waterproof Chair Cover Xl

cbc064
Livrare imediată!

76,46Lei

Geanta Baracuda Hyl009eco Pentru Pat Sau Scaun 98x95cm

Geanta Baracuda Hyl009eco Pentru Pat Sau Scaun 98x95cm

geanta universala pt. transport pat scaun pliant hyl009eco
Livrare imediată!

135,95Lei

Geanta Baracuda Hyl008 Pentru Transport Pat/scaun Premium 95x95cm

Geanta Baracuda Hyl008 Pentru Transport Pat/scaun Premium 95x95cm

geanta premium pt. transport pat pliant
Livrare imediată!

135,90Lei

Husa Scaun Carpzoom Cz Avix 80x65x18cm

Husa Scaun Carpzoom Cz Avix 80x65x18cm

cz6222
Livrare imediată!

119,00Lei

Husa Savage Gear Pentru Scaun Masina -30%

Husa Savage Gear Pentru Scaun Masina

a8.sg.74162
Livrare imediată!

258,06Lei(-30%) 180,64Lei

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

Descoperă gama noastră de huse scaune și paturi pescuit, ideale pentru protecția și transportul echipamentului tău.
Fabricate din materiale impermeabile și rezistente, aceste huse asigură durabilitate și protecție maximă.
Designul ergonomic permite o depozitare eficientă și un transport facil în orice condiții.
Husele pentru scaune pescuit protejează împotriva umezelii, prafului și uzurii în timpul utilizării.
Husele pentru paturi pescuit oferă confort și siguranță, prelungind durata de viață a echipamentului.
Modelele sunt ușor de curățat, menținând aspectul și funcționalitatea optimă.
Materialele premium și finisajele de calitate asigură o protecție superioară.
Aceste huse sunt potrivite atât pentru pescuitul sportiv, cât și pentru pescarii profesioniști.
Soluțiile inovatoare optimizează organizarea și protecția echipamentelor de pescuit.
Alege huse scaune și paturi pescuit pentru o experiență confortabilă și bine organizată.

Queries: 17, Total time: 6.437 ms [By time] [By id] [By file]
1 (0.191)
SELECT data
FROM `oc_session`
WHERE session_id = 'e68c9a6d733ef9a5624c240fb9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.149)
SELECT *
FROM oc_url_alias
WHERE keyword = 'bagajerie'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.070)
SELECT *
FROM oc_url_alias
WHERE keyword = 'huse'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.063)
SELECT *
FROM oc_url_alias
WHERE keyword = 'huse-scaune-si-paturi'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
6 (0.415)
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 = '397' 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 (1.434)
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 = '397' 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.090)
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 (0.477)
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
10 (1.951)
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.233)
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.080)
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.072)
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 (0.655)
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.172)
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 '%"397"%' 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 '%"397"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
17 (0.108)
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