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

Căutare

Produse ce potrivesc criteriilor de căutare


Geanta TRAKKER NXG Cookware Bag, 34x24x24cm, 20ltr
Exclusiv online!

Geanta TRAKKER NXG Cookware Bag, 34x24x24cm, 20ltr

204182
Livrare 7-14 zile

178,89Lei

Valigeta Energo Team 44x24x20cm
Exclusiv online!

Valigeta Energo Team 44x24x20cm

75001100
Livrare 24-48 ore

142,24Lei

Geanta Korda Compact Utility Camo, 24x24x20cm
Exclusiv online!

Geanta Korda Compact Utility Camo, 24x24x20cm

klug135
Livrare 7-14 zile

133,18Lei

Geanta Matrix Ethos Feeder Case 39x24x25cm
Exclusiv online!

Geanta Matrix Ethos Feeder Case 39x24x25cm

glu148
Livrare 7-14 zile

276,41Lei

Valigeta Jaxon S-Line Tackle Box, 43x24x28cm
Exclusiv online!

Valigeta Jaxon S-Line Tackle Box, 43x24x28cm

rm-120b
Livrare 48-72 ore

290,79Lei

Galeata Solar Sp Pliabila Water Bucket, 10L, 24x24x26cm -7%
Exclusiv online!

Galeata Solar Sp Pliabila Water Bucket, 10L, 24x24x26cm

um06
Livrare 48-72ore

83,30Lei(-7%) 77,23Lei

GEANTA WIZARD PREDATOR MAX SPINNING BAG 43x24x24cm
Exclusiv online!

GEANTA WIZARD PREDATOR MAX SPINNING BAG 43x24x24cm

72137100
Livrare 24-48 ore

154,44Lei

Geanta Mulinete Sunset RS Compartimente Ajustabile, 34x24x18cm

Geanta Mulinete Sunset RS Compartimente Ajustabile, 34x24x18cm

90411stslj3855
Livrare imediată!

160,58Lei

Tava Grill Cattara Din Otel Inoxidabil, 34x24x2.5cm
Exclusiv online!

Tava Grill Cattara Din Otel Inoxidabil, 34x24x2.5cm

tt13072
Livrare 24-48 ore

47,67Lei

Valigeta Jaxon S-Line Tackle Box Grey, 43x24x28cm
Exclusiv online!

Valigeta Jaxon S-Line Tackle Box Grey, 43x24x28cm

rm-120a
Livrare 48-72 ore

290,79Lei

Geanta Termo MADCAT Cooler Bag 18L, 35x24x21cm
Exclusiv online!

Geanta Termo MADCAT Cooler Bag 18L, 35x24x21cm

1623069
Livrare 7-14 zile

208,43Lei

GEANTA PRESTON COMPETITION BAIT BAG 39X26X24CM

GEANTA PRESTON COMPETITION BAIT BAG 39X26X24CM

p0130091
Livrare imediată!

252,62Lei

CUTIE PLASTIC PRO FL CU SERTARE SI INCHIDERE 44X24X20CM

CUTIE PLASTIC PRO FL CU SERTARE SI INCHIDERE 44X24X20CM

64-37006
Livrare imediată!

122,92Lei

Geanta Berkley Mini Ranger 34x20x23cm

Geanta Berkley Mini Ranger 34x20x23cm

1265745
Livrare imediată!

280,62Lei

Geanta Accesorii Nytro Starkx EVA Tackle Bits Carryall 36x24x25cm

Geanta Accesorii Nytro Starkx EVA Tackle Bits Carryall 36x24x25cm

22400019
Livrare imediată!

204,34Lei

Geanta Zfish Fish Tank Momeala Vie 18L, 36x24x25cm

Geanta Zfish Fish Tank Momeala Vie 18L, 36x24x25cm

zf-8453
Livrare imediată!

81,84Lei

Geanta Termoizolanta Daiwa Black Widow Cool Bait 36x29x24cm
Exclusiv online!

Geanta Termoizolanta Daiwa Black Widow Cool Bait 36x29x24cm

d.18705.300
Livrare 24-48 ore

208,89Lei

Geanta Sunset Monturi RS Competition 40 Role, 34x24x9cm

Geanta Sunset Monturi RS Competition 40 Role, 34x24x9cm

90411stslj3859
Livrare imediată!

241,59Lei

Geanta KORDA Compac Utility Bag, Olive, 24x24x20cm
Exclusiv online!

Geanta KORDA Compac Utility Bag, Olive, 24x24x20cm

klug92
Livrare 7-14 zile

128,05Lei

Geanta Termoizolanta NGT Insulated Bait Carryall, Verde, 43x24x21cm

Geanta Termoizolanta NGT Insulated Bait Carryall, Verde, 43x24x21cm

ngt-fla-baitcarryall-881
Livrare imediată!

162,67Lei

Afişare 1 - 20 din 26 (2 pagini)
Queries: 12, Total time: 1.674 ms [By time] [By id] [By file]
1 (0.124)
SELECT data
FROM `oc_session`
WHERE session_id = 'ce24959a6b6204609c013bdc09'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.113)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.111)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("250000", "1", "1000", "476", "1", "147.840000000000", "1"),("62573", "2", "1000", "24", "1", "117.550000000000", "2"),("180927", "1", "1000", "73", "1", "110.070000000000", "3"),("185039", "1", "1000", "368", "1", "228.440000000000", "4"),("229746", "2", "1000", "42", "1", "240.320000000000", "5"),("219394", "2", "1000", "173", "1", "63.830000000000", "6"),("118427", "2", "1000", "401", "1", "127.640000000000", "7"),("199341", "1", "1001", "389", "1", "132.710000000000", "8"),("223564", "-100", "1000", "768", "1", "39.400000000000", "9"),("229747", "2", "1000", "42", "1", "240.320000000000", "10"),("233616", "2", "1000", "492", "1", "172.260000000000", "11"),("164856", "2", "1001", "360", "1", "208.780000000000", "12"),("181487", "1", "1001", "13", "1", "101.590000000000", "13"),("151407", "1", "1001", "54", "1", "231.920000000000", "14"),("194467", "1", "1001", "727", "1", "168.880000000000", "15"),("217913", "2", "1001", "370", "1", "67.640000000000", "16"),("177627", "2", "1000", "11", "1", "172.640000000000", "17"),("199343", "2", "1001", "389", "1", "199.660000000000", "18"),("244243", "1", "1000", "73", "1", "105.830000000000", "19"),("170732", "1", "1", "287", "1", "134.440000000000", "20"),("244119", "1", "1000", "73", "1", "80.620000000000", "21"),("151067", "2", "1000", "122", "1", "231.920000000000", "22"),("149499", "2", "1001", "54", "1", "231.920000000000", "23"),("208135", "1", "0", "389", "1", "165.810000000000", "24"),("110391", "2", "0", "11", "1", "203.500000000000", "25"),("244090", "1", "0", "73", "1", "84.820000000000", "26")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.099)
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
6 (0.183)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.116)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CARP INTELLIGENCE LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.211)
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
9 (0.078)
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
10 (0.063)
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
11 (0.376)
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
12 (0.112)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37