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

Produse ce potrivesc criteriilor de căutare


Shad Mustad Mezashi Tail Minnow, Blue Dot Sardine, 8.8cm, 6buc/pac -20%
Exclusiv online!

Shad Mustad Mezashi Tail Minnow, Blue Dot Sardine, 8.8cm, 6buc/pac

f1.mktm.bds.3.5
Livrare 24-48 ore

24,26Lei(-20%) 19,42Lei

Shad Savage Gear Cannibal, Flou Yellow Glow, 8cm, 5g, 5buc/pac
Exclusiv online!

Shad Savage Gear Cannibal, Flou Yellow Glow, 8cm, 5g, 5buc/pac

f1.sg.77138
Livrare 24-48 ore

22,03Lei

Shad Savage Gear Cannibal, Green Pearl Yellow, 6.8cm, 3g, 5buc/pac

Shad Savage Gear Cannibal, Green Pearl Yellow, 6.8cm, 3g, 5buc/pac

f1.sg.77123
Livrare imediată!

17,14Lei

Shad Savage Gear Cannibal, Purple Glitter Bomb, 6.8cm, 3g, 5buc/pac

Shad Savage Gear Cannibal, Purple Glitter Bomb, 6.8cm, 3g, 5buc/pac

f1.sg.77130
Livrare imediată!

17,14Lei

Swimbait Live Target Goby, Natural / Bronze, 8cm, 14g, 3buc/pac
Exclusiv online!

Swimbait Live Target Goby, Natural / Bronze, 8cm, 14g, 3buc/pac

f1.lt.gob80pt601
Livrare 24-48 ore

42,88Lei

Vobler Berkley Pulse Biggie, Frog, 8cm, 30g

Vobler Berkley Pulse Biggie, Frog, 8cm, 30g

1577411
Livrare imediată!

36,08Lei

Vobler Berkley Pulse Biggie, Perch, 8cm, 30g

Vobler Berkley Pulse Biggie, Perch, 8cm, 30g

1577405
Livrare imediată!

36,08Lei

Vobler Berkley Pulse Fry Shallow, Goldie, 3.8cm, 4.5g -21%

Vobler Berkley Pulse Fry Shallow, Goldie, 3.8cm, 4.5g

1571661
Livrare imediată!

31,46Lei(-21%) 24,89Lei

VOBLER FL FLOATING BUG 0.5-1M 3.8CM 4.1G CULOARE 002

VOBLER FL FLOATING BUG 0.5-1M 3.8CM 4.1G CULOARE 002

64-3311x
Livrare imediată!

11,90Lei

VOBLER FL FLOATING BUG 0.5-1M 3.8CM 4.1G CULOARE 005

VOBLER FL FLOATING BUG 0.5-1M 3.8CM 4.1G CULOARE 005

64-3314
Livrare imediată!

11,90Lei

Vobler Jackall TN38 Trigon, 7.3g, 3.8cm, Lime Luminous
Exclusiv online!

Vobler Jackall TN38 Trigon, 7.3g, 3.8cm, Lime Luminous

ja.807247640
Livrare 24-48 ore

98,46Lei

Vobler Jackall TN38 Trigon, 7.3g, 3.8cm, Noike Gill
Exclusiv online!

Vobler Jackall TN38 Trigon, 7.3g, 3.8cm, Noike Gill

ja.807247589
Livrare 24-48 ore

98,46Lei

Vobler Mustad BLF Mid Runner, Ghost Gill, 5.8cm, 17g
Exclusiv online!

Vobler Mustad BLF Mid Runner, Ghost Gill, 5.8cm, 17g

f3.blcb58mr.ghg
Livrare 24-48 ore

48,39Lei

Vobler Rapture Bayliner DR SF, SFY, 10.6g, 7.8cm

Vobler Rapture Bayliner DR SF, SFY, 10.6g, 7.8cm

180-45-347
Livrare imediată!

38,00Lei

Vobler Salmo Fatso Floating, Bleeding Golden Bait, 8cm, 52g

Vobler Salmo Fatso Floating, Bleeding Golden Bait, 8cm, 52g

qfa112
Livrare imediată!

58,46Lei

Cicada Raid Japan Level VIB Boost, 001 Shimanashi Tiger, 3.8cm, 7g

Cicada Raid Japan Level VIB Boost, 001 Shimanashi Tiger, 3.8cm, 7g

raid32059
Livrare imediată!

66,00Lei

Cicada Raid Japan Level VIB Boost, 007 Chi Gill, 3.8cm, 5g

Cicada Raid Japan Level VIB Boost, 007 Chi Gill, 3.8cm, 5g

raid32035
Livrare imediată!

66,00Lei

Grub Hide Up Stagger Wide 1.5" Salt, S-07 Glow White, 3.8cm, 8buc/pac

Grub Hide Up Stagger Wide 1.5" Salt, S-07 Glow White, 3.8cm, 8buc/pac

hide80309
Livrare imediată!

28,00Lei

Naluca Mikado Fish Fry 8Cm / 359 - 5Buc
Exclusiv online!

Naluca Mikado Fish Fry 8Cm / 359 - 5Buc

pmfy-8-359
Livrare 48-72 ore

13,99Lei

Shad Fast Strike Roach, RGR Roach Gold Red, 8cm, 5g, 10buc/pac

Shad Fast Strike Roach, RGR Roach Gold Red, 8cm, 5g, 10buc/pac

5941944263708
Livrare imediată!

8,50Lei

Afişare 161 - 180 din 1802 (91 pagini)
Queries: 5, Total time: 69.681 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = '106316b2c7347bb907c976b148'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (58.522)
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 = '3' AND (MATCH(pd.tag) AGAINST('+8cm' 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
4 (10.853)
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 160, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.109)
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