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.

Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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

Retur simplu in 14 zile.

Vezi mai multe detalii

Cutii

Filtreaza

Sortare după:

Exclusiv online!

Set Cutii Trakko Crapist Standard

4303

Livrare 48-72 ore

49,00Lei

Exclusiv online!

Cutie, Dubla, Spro, Accesorii, L, 160x95x47mm, 006518-01300-00000, Cutii, Cutii Spro, Spro

006518-01300-00000

Livrare 48-72 ore

139,00Lei

Exclusiv online!

Cutie, Spro, Ptr, Accesorii, 8x12, -8, Compartimente, 006516-00000-000007, Cutii, Cutii Spro, Spro

006516-00000-000007

Livrare 48-72 ore

9,60Lei

Cutie, Meiho, Reversible, 140, Clear, Rev140c, Cutii, Cutii Meiho, Meiho

rev140c

Livrare imediată!

64,00Lei

Exclusiv online!

Set Cutii Colmic Masura Oficiala

sc02

Livrare 48-72 ore

117,00Lei

Exclusiv online!

Cutie, Momeala, Jaxon, 15x10cm, Rh-225, Cutii, Cutii Jaxon, Jaxon

rh-225

Livrare 48-72 ore

21,00Lei

Exclusiv online!

Cutie, Guru, Fusion, 400, Pentru, Momeala, S, A4.gu.glg01, Cutii, Cutii Guru, Guru

a4.gu.glg01

Livrare 24-48 ore

88,24Lei

Exclusiv online!

Cutie Daiwa Prorex Pentru Naluci Sau Accesorii Xl 36x22.5x8.5cm

a4.15809.451

Livrare 24-48 ore

81,32Lei

Cutie, Meiho, Reversible, 85, Clear, Rev85c, Cutii, Cutii Meiho, Meiho

rev85c

Livrare imediată!

32,00Lei

-35%

Cutie Modulara Ridgemonkey Bucked Spare Tray Xl

rm 035

Livrare imediată!

67,00Lei(-35%) 43,55Lei

Exclusiv online!

Cutie, Panaro, Goala, 387x105x40mm, 200/l, Cutii, Cutii Panaro, Cutii Panaro, Panaro

200/l

Livrare 48-72 ore

13,99Lei

Cutie, Accesorii, Korda, Mini, Compartment, Boxes, 16, Compartimente, A4.kbox10, Cutii, Cutii Korda, Korda

a4.kbox10

Livrare imediată!

53,40Lei

Cutie, Plastic, Panaro, F3, , 295x70x35, Mm, Ecpp-f3, Cutii, Cutii Panaro, Panaro

ecpp-f3

Livrare imediată!

10,00Lei

-27%

Cutie, Meiho, Reversible, 165, Clear, Rev165c, Cutii, Cutii Meiho, Meiho

rev165c

Livrare imediată!

85,00Lei(-27%) 62,00Lei

Cutie Momeala Matrix Bait Boxes Greylime 0.65l

gbt013

Livrare imediată!

13,46Lei

Cutie, Dubla, Spro, Accesorii, 112x75x32mm, 006518-01100-00000, Cutii, Cutii Spro, Spro

006518-01100-00000

Livrare imediată!

73,99Lei

Cutie Momeala Matrix Bait Boxes Greylime 1.80l

gbt015

Livrare imediată!

18,86Lei

-27%

Cutie, Rigida, Spro, Freestyle, Rigged, Boxes, M, 19x12x4cm, 006515-03200-00000, Cutii, Cutii Spro, Spro

006515-03200-00000

Livrare imediată!

81,00Lei(-27%) 58,91Lei

Cutie, Meiho, Reversible, F-86, Navy, Revf86, Cutii, Cutii Meiho, Meiho

revf86

Livrare imediată!

33,00Lei

Afişare 261 - 280 din 1027 (52 pagini)

Cutiile destinate pescuitului sunt in principiu din material plastic, dar exista si cutii fabricate din materiale speciale cu garantii speciale. Cutiile de pescuit pot fi compartimentate pentru o buna organizare a oricarui pescar amator sau profesionist sau pot fi cutii goale pe dinauntru pentru depozitarea lucrurilor grele sau voluminoase. In cutiile de pescuit pot fi organizate articolele de pescuit de orice fel cum ar fi pescuitul stationar, pescuit la crap, pescuit la rapitori sau pescuit marin.

Queries: 10, Total time: 22.078 ms [By time] [By id] [By file]

1 (0.142)

SELECT data
FROM `oc_session`
WHERE session_id = '5f1809fc42f8bb0f0730e06daa'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.129)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:427

3 (0.132)

SELECT *
FROM oc_url_alias
WHERE keyword = 'cutii'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.481)

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 = '109' AND cd.language_id = '2' AND c2s.store_id = '3' 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 (15.629)

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_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 = '3' AND p2c.category_id = '109' 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

6 (4.414)

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 260, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

7 (0.622)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '9063' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51

8 (0.236)

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 '%"109"%' LIMIT 0, 1000

/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106

9 (0.172)

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 '%"109"%' LIMIT 0, 1000

/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106

10 (0.121)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Cutii

Cutii