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


Cutie Impermeabila Plano Guide Series 3400 -21%
Exclusiv online!

Cutie Impermeabila Plano Guide Series 3400

pmc144900
Livrare 48-72ore

80,96Lei(-21%) 63,90Lei

Cutie Momeala Preston Bait Tubs 2PT, Blue Black

Cutie Momeala Preston Bait Tubs 2PT, Blue Black

p0260010
Livrare imediată!

15,71Lei

Cutie Muste Rapture LMF Dry & Lure Box, Transparent, 12.8x8.8x1.5cm

Cutie Muste Rapture LMF Dry & Lure Box, Transparent, 12.8x8.8x1.5cm

113-19-050
Livrare imediată!

29,00Lei

Cutie Muste Rapture LMF Dry & Nymph Box, Transparent, 12.8x8.8x1.5cm
Exclusiv online!

Cutie Muste Rapture LMF Dry & Nymph Box, Transparent, 12.8x8.8x1.5cm

113-19-040
Livrare 48-72 ore

29,00Lei

Cutie pentru Carlige Korda
Exclusiv online!

Cutie pentru Carlige Korda

a4.kbox18
Livrare 24-48 ore

58,02Lei

Cutie Plano Edge Utility Box 3700 Standard -30%

Cutie Plano Edge Utility Box 3700 Standard

plase370
Livrare imediată!

135,01Lei(-30%) 95,00Lei

Cutie Plano Guide Series Magnum Satchel

Cutie Plano Guide Series Magnum Satchel

pmc144402
Livrare imediată!

449,50Lei

Cutie Preston Accessory Box - 8 Compartment Shallow

Cutie Preston Accessory Box - 8 Compartment Shallow

p0220128
Livrare imediată!

38,25Lei

Cutie RidgeMonkey Armoury Lite Tackle Box 330x190x50mm -23%

Cutie RidgeMonkey Armoury Lite Tackle Box 330x190x50mm

rm497
Livrare imediată!

195,98Lei(-23%) 150,90Lei

Cleste pentru Sertizat Pole Position Crimp Tool + 2 Cutii cu Bride Duble

Cleste pentru Sertizat Pole Position Crimp Tool + 2 Cutii cu Bride Duble

008036-00301-00000
Livrare imediată!

79,50Lei

Cutie Accesorii Shakespeare Tackle Box System Medium
Exclusiv online!

Cutie Accesorii Shakespeare Tackle Box System Medium

1247786
Livrare 7-14 zile

118,96Lei

Cutie Dubla Filex Pentru Voblere 27,5x15x5 cm

Cutie Dubla Filex Pentru Voblere 27,5x15x5 cm

fil0494
Livrare imediată!

42,99Lei

Cutie Dubla Trabucco GNT Tackle Case Feeder 39x27x13cm
Exclusiv online!

Cutie Dubla Trabucco GNT Tackle Case Feeder 39x27x13cm

112-10-010
Livrare 48-72 ore

175,00Lei

Cutie Greys Momeala Vie Klip Lok Bait Box, 1870ml

Cutie Greys Momeala Vie Klip Lok Bait Box, 1870ml

1600408
Livrare imediată!

31,46Lei

Cutie Meiho Fly Case L

Cutie Meiho Fly Case L

mho-fly-l
Livrare imediată!

21,50Lei

Cutie Meiho Versus VS-820NDB Multi Clear

Cutie Meiho Versus VS-820NDB Multi Clear

mho-vs820ndmc
Livrare imediată!

33,00Lei

Cutie Momeala Preston Bait Tubs 3PT, Blue Black

Cutie Momeala Preston Bait Tubs 3PT, Blue Black

p0260011
Livrare imediată!

17,85Lei

Cutie Momeala TF By Dome 15x15x8cm
Exclusiv online!

Cutie Momeala TF By Dome 15x15x8cm

4507-001
Livrare 48-72 ore

28,00Lei

Cutie Muste Greys Slim Waterproof Fly Boxes

Cutie Muste Greys Slim Waterproof Fly Boxes

1593917
Livrare imediată!

46,71Lei

Cutie Muste Rapture LMF Dry & Nymph Fly Box WP, Transparent, 18.8x10.8x1.5cm
Exclusiv online!

Cutie Muste Rapture LMF Dry & Nymph Fly Box WP, Transparent, 18.8x10.8x1.5cm

113-19-060
Livrare 48-72 ore

54,00Lei

Afişare 601 - 620 din 1124 (57 pagini)
Queries: 6, Total time: 29.911 ms [By time] [By id] [By file]
1 (0.068)
SELECT data
FROM `oc_session`
WHERE session_id = '6cec06915084df8df1030f7459'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (24.914)
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('+cutii' 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 (4.634)
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 600, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.130)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PURE FISHING INDISPONIBIL2(IULIA)"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.093)
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