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


Pelete Sonubaits Robin Red Feed 2mm, 900g
Exclusiv online!

Pelete Sonubaits Robin Red Feed 2mm, 900g

s1800015
Livrare 7-14 zile

35,96Lei

Plumb Feed Orange cu Vartej, 85g

Plumb Feed Orange cu Vartej, 85g

40341lf285
Livrare imediată!

7,12Lei

Pelete Sonubaits Fin Perfect Feed 2mm, 650g -20%
Exclusiv online!

Pelete Sonubaits Fin Perfect Feed 2mm, 650g

s1790002
Livrare 7-14 zile

26,96Lei(-20%) 21,57Lei

Pelete Sonubaits Pro Feed 2mm, 1kg
Exclusiv online!

Pelete Sonubaits Pro Feed 2mm, 1kg

s1790008
Livrare 7-14 zile

31,46Lei

Plumb Feed Orange cu Vartej, 71g
Exclusiv online!

Plumb Feed Orange cu Vartej, 71g

40341lf271
Livrare 48-72 ore

8,43Lei

Plumb Orange Plumb Feed Inline Bulk, 71g, 1buc/plic
Exclusiv online!

Plumb Orange Plumb Feed Inline Bulk, 71g, 1buc/plic

40341lf171
Livrare 48-72 ore

8,00Lei

Pelete Sonubaits Krill Feed 4mm, 900g -20%
Exclusiv online!

Pelete Sonubaits Krill Feed 4mm, 900g

s1800008
Livrare 7-14 zile

35,96Lei(-20%) 28,77Lei

Plumb Feed Orange cu Vartej,142g
Exclusiv online!

Plumb Feed Orange cu Vartej,142g

40341lf2142
Livrare 48-72 ore

13,30Lei

Pelete Sonubaits Robin Red Feed 4mm, 900g -20%
Exclusiv online!

Pelete Sonubaits Robin Red Feed 4mm, 900g

s1800016
Livrare 7-14 zile

35,96Lei(-20%) 28,77Lei

MATRITA FEEDER MATRIX SQUEEZE FEED L

MATRITA FEEDER MATRIX SQUEEZE FEED L

gfr061
Livrare imediată!

24,70Lei

Geantă Delphin Atoma Feed Case 30x20x10cm -52%

Geantă Delphin Atoma Feed Case 30x20x10cm

101001511
Stoc epuizat

146,00Lei(-52%) 70,00Lei

Rig Crap Orange Lead Clip Lead Feed 71g, VMC No.4, Leadcore 70cm, 45lb

Rig Crap Orange Lead Clip Lead Feed 71g, VMC No.4, Leadcore 70cm, 45lb

120241c06071
Stoc epuizat

17,40Lei

Pelete Haldorado Fluo Micro Method Feed - Devil Buster

Pelete Haldorado Fluo Micro Method Feed - Devil Buster

hfmmfp-db
Stoc epuizat

29,00Lei

GROUNDBAIT DYNAMITE BAITS BIG FISH FEED Explosive Caster Feeder Formula 1.8KG
Pelete Sonubaits Feed Pellet 6mm Bloodworm Fishmeal

Pelete Sonubaits Feed Pellet 6mm Bloodworm Fishmeal

s1800003
Stoc epuizat

35,96Lei

Pelete Sonubaits Feed 2mm F1

Pelete Sonubaits Feed 2mm F1

s1800010
Stoc epuizat

35,96Lei

Fir Delphin FIN Method FEED 150m Maro 0.20mm

Fir Delphin FIN Method FEED 150m Maro 0.20mm

500650220
Stoc epuizat

19,00Lei

Fir Delphin FIN Method FEED 150m Maro 0.18mm

Fir Delphin FIN Method FEED 150m Maro 0.18mm

500650218
Stoc epuizat

19,00Lei

Fir Delphin FIN Method FEED 300m Maro 0.16mm

Fir Delphin FIN Method FEED 300m Maro 0.16mm

500650416
Stoc epuizat

22,00Lei

Fir Delphin FIN Method FEED 200m Maro 0.16mm

Fir Delphin FIN Method FEED 200m Maro 0.16mm

500650316
Stoc epuizat

21,00Lei

Afişare 41 - 60 din 109 (6 pagini)
Queries: 6, Total time: 3.716 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = 'ecb61e3371f0183a757e6d7ff8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (3.120)
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('+feed' 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 (0.139)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"MILLE MAISTRO SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.121)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.127)
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