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 Plano 4-By Rack System 3600 -25%

Cutie Plano 4-By Rack System 3600

pmc136400
Livrare imediată!

405,00Lei(-25%) 303,00Lei

Cutie Plano Edge Utility Box 3700 Deep
Exclusiv online!

Cutie Plano Edge Utility Box 3700 Deep

plase373
Livrare 7-14 zile

179,96Lei

Kit Spinning Shad + Jig + Cutie Savage Gear Cannibal, Mixed Colors, 5.5cm/6.8cm, Model S, 36buc accesorii/cutie
Exclusiv online!

Kit Spinning Shad + Jig + Cutie Savage Gear Cannibal, Mixed Colors, 5.5cm/6.8cm, Model S, 36buc accesorii/cutie

f1.sg.82336
Livrare 24-48 ore

86,57Lei

Cutie Accesorii Plano Marine Plam4520B -46%

Cutie Accesorii Plano Marine Plam4520B

plam4520b
Livrare imediată!

199,50Lei(-46%) 107,99Lei

Cutie Accesorii Zeck Stinger Box Pro 20x11.5x5cm
Exclusiv online!

Cutie Accesorii Zeck Stinger Box Pro 20x11.5x5cm

42505260038
Livrare 48-72 ore

101,22Lei

Cutie Arma Blaser Case ABS Tip B Pt.R8/R93 80x35x9cm
Exclusiv online!

Cutie Arma Blaser Case ABS Tip B Pt.R8/R93 80x35x9cm

a8.bl.80412248
Livrare 24-48 ore

2.192,04Lei

Cutie Arma Plano Pro-Max Double Scoped Rifle Case
Exclusiv online!

Cutie Arma Plano Pro-Max Double Scoped Rifle Case

pmc153200
Livrare 7-14 zile

899,96Lei

Cutie Arma Plano Pro-Max Long Gun Case

Cutie Arma Plano Pro-Max Long Gun Case

pmc151101
Livrare imediată!

292,45Lei

Cutie cu Accesorii Crap Orange Carp Lead Clip 85, 101 Accesorii

Cutie cu Accesorii Crap Orange Carp Lead Clip 85, 101 Accesorii

40441sc004
Livrare imediată!

245,38Lei

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

Jig BKK Round Elite-Classic Bait Keeper, 10g, Nr.1/0, 20buc/cutie
Exclusiv online!

Jig BKK Round Elite-Classic Bait Keeper, 10g, Nr.1/0, 20buc/cutie

6974190008426
Livrare 48-72 ore

95,00Lei

Jig BKK Round Elite-Classic Bait Keeper, 7g, Nr.1/0, 20buc/cutie
Exclusiv online!

Jig BKK Round Elite-Classic Bait Keeper, 7g, Nr.1/0, 20buc/cutie

6974190008372
Livrare 48-72 ore

89,00Lei

Afişare 701 - 720 din 1441 (73 pagini)
Queries: 6, Total time: 35.556 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = 'dced3efb1f66b3dcdcf6aa4601'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (29.371)
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('+cutie' 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 (5.772)
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 700, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.114)
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.104)
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