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

Căutare - spreader

Produse ce potrivesc criteriilor de căutare


MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 10GR -30%

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 10GR

179110
Stoc epuizat

12,00Lei(-30%) 8,40Lei

Plasa minciog Select Baits Landing Net Mesh 42 Inch

Plasa minciog Select Baits Landing Net Mesh 42 Inch

smr42
Stoc epuizat

115,00Lei

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 20GR -30%

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 20GR

179120
Stoc epuizat

13,49Lei(-30%) 9,40Lei

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 40GR -30%

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 40GR

179140
Stoc epuizat

14,70Lei(-30%) 10,31Lei

MINCIOG JAXON SOFT MESH SILICON 35X45CM

MINCIOG JAXON SOFT MESH SILICON 35X45CM

pl-trx101
Stoc epuizat

138,00Lei

REZERVA PLASA MINCIOG FOX Camo Landing Net Mesh 42

REZERVA PLASA MINCIOG FOX Camo Landing Net Mesh 42

cln053
Stoc epuizat

143,10Lei

MINCIOG JAXON SOFT MESH 60CM

MINCIOG JAXON SOFT MESH 60CM

pl-tru60
Stoc epuizat

122,00Lei

SAPCA DAIWA MATELASSE MESH BLACK WHITE

SAPCA DAIWA MATELASSE MESH BLACK WHITE

d.ca402415
Stoc epuizat

50,73Lei

MINCIOG JAXON SOFT MESH 55CM

MINCIOG JAXON SOFT MESH 55CM

pl-tru55
Stoc epuizat

112,00Lei

Kit Plasa Carp Expert Solubila PVA Micro Mesh Slow + Tija Compresie 7m 35mm
Rezerva Plasa Solubila Carp Expert Refill Rapid Micro Mesh Fast 7m 25mm

Rezerva Plasa Solubila Carp Expert Refill Rapid Micro Mesh Fast 7m 25mm

30141125
Stoc epuizat

26,00Lei

MINCIOG SAVAGE TELE RUBBER X-LARGE MESH 65X50CM

MINCIOG SAVAGE TELE RUBBER X-LARGE MESH 65X50CM

a2.sg.69757
Stoc epuizat

385,83Lei

REZERVA PLASA MINCIOG FOX Camo Landing Net Mesh 46

REZERVA PLASA MINCIOG FOX Camo Landing Net Mesh 46

cln054
Stoc epuizat

179,96Lei

MINCIOG SAVAGE TELE RUBBER X-LARGE MESH XL 70X85CM

MINCIOG SAVAGE TELE RUBBER X-LARGE MESH XL 70X85CM

a2.sg.69758
Stoc epuizat

431,20Lei

SAPCA DAIWA CLASSIQUE MESH BLACK

SAPCA DAIWA CLASSIQUE MESH BLACK

d.ca402446
Stoc epuizat

50,73Lei

Juvelnic DAM O.T.T. Keepnet Micro Mesh 3.00m 50x40cm 2mm

Juvelnic DAM O.T.T. Keepnet Micro Mesh 3.00m 50x40cm 2mm

5050974993
Stoc epuizat

253,71Lei

CAP MINCIOG TRABUCCO PRO NET TX PVC MESH 50X45X40CM

CAP MINCIOG TRABUCCO PRO NET TX PVC MESH 50X45X40CM

083-66-840
Stoc epuizat

39,00Lei

Minciog DAM Manitoba Rubber Mesh Click-N-Slide 50x75x45cm 66-104cm

Minciog DAM Manitoba Rubber Mesh Click-N-Slide 50x75x45cm 66-104cm

5010965469
Stoc epuizat

200,90Lei

COSULET FEEDER MAVER JURASSIC BULLET MESH 25X25MM 60g

COSULET FEEDER MAVER JURASSIC BULLET MESH 25X25MM 60g

00423060
Stoc epuizat

21,00Lei

COSULET FEEDER MAVER JURASSIC BULLET MESH 25X25MM 30g

COSULET FEEDER MAVER JURASSIC BULLET MESH 25X25MM 30g

00423030
Stoc epuizat

21,00Lei

Afişare 141 - 160 din 193 (10 pagini)
Queries: 9, Total time: 12.263 ms [By time] [By id] [By file]
1 (0.465)
SELECT data
FROM `oc_session`
WHERE session_id = '576fc014b8faad04ab1daace06'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.249)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.302)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (8.313)
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_description` AS pd ON (pd.product_id = p.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 (MATCH(pd.tag) AGAINST('+mesh' IN BOOLEAN MODE)) 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:737
5 (0.152)
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:1561
6 (0.841)
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 ASC LIMIT 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.138)
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:1035
8 (1.677)
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:949
9 (0.126)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38