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


Teaser BKK Ancora cu Pene Naturale, Spear 21 SS, White, Nr.4, 3buc/pac
Exclusiv online!

Teaser BKK Ancora cu Pene Naturale, Spear 21 SS, White, Nr.4, 3buc/pac

6939067048059
Livrare 48-72 ore

32,00Lei

Vartej Helicopter Prowess nr.4, 10buc
Exclusiv online!

Vartej Helicopter Prowess nr.4, 10buc

41433prcah1010-t4
Livrare 48-72 ore

12,22Lei

Carlig Owner Amaz 11655 Cut SSW Straight-Eye Nr.4/0, 6buc/pac

Carlig Owner Amaz 11655 Cut SSW Straight-Eye Nr.4/0, 6buc/pac

1210025180-141
Livrare imediată!

18,80Lei

Carlige Fudo Carp STG2, Teflonat, Nr.4, 5buc/pac

Carlige Fudo Carp STG2, Teflonat, Nr.4, 5buc/pac

2427-4
Livrare imediată!

10,00Lei

Carlige Legate Carp Academy Snowman Rig, 21cm, Nr.4, 25lbs, 2buc/plic
Exclusiv online!

Carlige Legate Carp Academy Snowman Rig, 21cm, Nr.4, 25lbs, 2buc/plic

8106-604
Livrare 48-72 ore

9,90Lei

Carlige Legate Prowess W-Rigs Fluorocarbon D-Rig Nr.4, 2buc
Exclusiv online!

Carlige Legate Prowess W-Rigs Fluorocarbon D-Rig Nr.4, 2buc

120233prcam0510t4-15b
Livrare 48-72 ore

18,86Lei

Carlige Mustad Ultrapoint Ochet Offset Nr.4, 10buc/pac

Carlige Mustad Ultrapoint Ochet Offset Nr.4, 10buc/pac

m.37177npbn.4
Livrare imediată!

14,68Lei

Carlige Offset Gamakatsu Worm-314 MB Nr.4/0, 6buc/pac
Exclusiv online!

Carlige Offset Gamakatsu Worm-314 MB Nr.4/0, 6buc/pac

147396-004
Livrare 48-72 ore

20,40Lei

Jig BKK Round Elite-Classic Bait Keeper, 10g, Nr.4/0, 3buc/blister
Exclusiv online!

Jig BKK Round Elite-Classic Bait Keeper, 10g, Nr.4/0, 3buc/blister

6974190006743
Livrare 48-72 ore

13,99Lei

Jig BKK Round Elite-Classic Bait Keeper, 15g, Nr.4/0, 3buc/blister
Exclusiv online!

Jig BKK Round Elite-Classic Bait Keeper, 15g, Nr.4/0, 3buc/blister

6974190006781
Livrare 48-72 ore

13,99Lei

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

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

6939067018151
Livrare 48-72 ore

115,00Lei

Jig BKK Round Elite-Classic Bait Keeper, 20g, Nr.4/0, 3buc/blister
Exclusiv online!

Jig BKK Round Elite-Classic Bait Keeper, 20g, Nr.4/0, 3buc/blister

6974190006828
Livrare 48-72 ore

19,00Lei

Jig Mustad Carlig Nr.4, 5g, 6buc/pac -20%

Jig Mustad Carlig Nr.4, 5g, 6buc/pac

f2.m.bjh4.5.6
Livrare imediată!

18,78Lei(-20%) 15,02Lei

Jig Mustad F2 Nr.4, 3g, 6buc/pac -20%

Jig Mustad F2 Nr.4, 3g, 6buc/pac

f2.m.bjh4.3.6
Livrare imediată!

16,76Lei(-20%) 13,41Lei

Montura Crap Orange Method Boat 40g, Nr.4

Montura Crap Orange Method Boat 40g, Nr.4

40141mf4340
Livrare imediată!

20,71Lei

Montura Rig Crap Orange Carlig Running Lead, Nr.4, 71g, 1buc
Exclusiv online!

Montura Rig Crap Orange Carlig Running Lead, Nr.4, 71g, 1buc

40541mf4571
Livrare 48-72 ore

20,71Lei

Montura Rig Crap Orange Carp Lead Clip, Nr.4, 1buc/plic

Montura Rig Crap Orange Carp Lead Clip, Nr.4, 1buc/plic

40541mf15
Livrare imediată!

12,44Lei

Montura Rig Crap Orange Carp Power Lead Clip, Nr.4, 1buc/plic
Exclusiv online!

Montura Rig Crap Orange Carp Power Lead Clip, Nr.4, 1buc/plic

40541mf11
Livrare 48-72 ore

12,92Lei

Ancora BKK Spear-21 UVO, Nr.4/0, 4buc/pac
Exclusiv online!

Ancora BKK Spear-21 UVO, Nr.4/0, 4buc/pac

6974190007818
Livrare 48-72 ore

39,00Lei

Ancora Mustad Tripla Inline Steel, Nr.4, 6buc/plic
Exclusiv online!

Ancora Mustad Tripla Inline Steel, Nr.4, 6buc/plic

m.itg76ap.ts.4
Livrare 24-48 ore

31,43Lei

Afişare 741 - 760 din 1173 (59 pagini)
Queries: 5, Total time: 526.485 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = '756f7b040f0f1d5dfed9cdb477'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (520.201)
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 (pd.tag LIKE "%nr.4%") 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.860)
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 740, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.160)
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