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 JAXON METHOD FEEDER READY BREAM BELGE 2mm 500g
Exclusiv online!

PELETE JAXON METHOD FEEDER READY BREAM BELGE 2mm 500g

fm-pr03
Livrare 48-72 ore

29,00Lei

Carlig Delphin HKD Feeder HALFER NR.10 -64%

Carlig Delphin HKD Feeder HALFER NR.10

622045010
Livrare imediată!

11,00Lei(-64%) 4,00Lei

Momitor Carp Expert Method Feeder Pro Method Flat XXL 30g

Momitor Carp Expert Method Feeder Pro Method Flat XXL 30g

58040030
Livrare imediată!

9,50Lei

Fir Textil Garbolino Super G Feeder Braid 0.08mm 150m
Exclusiv online!

Fir Textil Garbolino Super G Feeder Braid 0.08mm 150m

110830goflh4165fe-08
Livrare 48-72 ore

104,97Lei

Minciog Baracuda BH-60 aluminiu 2.45M

Minciog Baracuda BH-60 aluminiu 2.45M

minciog bh-60
Livrare imediată!

109,90Lei

Fir Monofilament Benzar Mono Feeder Hooklink Transparent 50m 0.22mm 7.5kg

Fir Monofilament Benzar Mono Feeder Hooklink Transparent 50m 0.22mm 7.5kg

30593122
Livrare imediată!

12,99Lei

Momitor Guru Maggot Feeder Large 70g
Exclusiv online!

Momitor Guru Maggot Feeder Large 70g

a.gu.gmf08
Livrare 24-48 ore

18,54Lei

Monofilament Nevis F line Feeder 150m 0.28mm
Exclusiv online!

Monofilament Nevis F line Feeder 150m 0.28mm

3240-028
Livrare 48-72 ore

12,99Lei

Sistem antitangle Daiwa N Zon 4cm 3buc/plic
Exclusiv online!

Sistem antitangle Daiwa N Zon 4cm 3buc/plic

a.13307.004
Livrare 24-48 ore

26,85Lei

Carlige Fanatik FF-22 No.7 Feeder 9buc/plic -33%

Carlige Fanatik FF-22 No.7 Feeder 9buc/plic

120113ff227
Livrare imediată!

5,50Lei(-33%) 3,67Lei

CARLIGE TRABUCCO XPS 710XB nr 16 25 BUC/PLIC

CARLIGE TRABUCCO XPS 710XB nr 16 25 BUC/PLIC

021-70-160
Livrare imediată!

16,01Lei

Momitor Carp Expert Method Feeder Flat 40g
Exclusiv online!

Momitor Carp Expert Method Feeder Flat 40g

58050040
Livrare 24-48 ore

8,50Lei

Cutie Kamasaki Feeder Accesorii Monturi Diverse 12x6x3cm

Cutie Kamasaki Feeder Accesorii Monturi Diverse 12x6x3cm

12044504
Livrare imediată!

24,00Lei

Fir Team Feeder Master Carp 300m 0.22mm

Fir Team Feeder Master Carp 300m 0.22mm

3251-322
Livrare imediată!

28,50Lei

Fir fluorocarbon Quantum Fluoro Carbon Predator 0.35mm 25m

Fir fluorocarbon Quantum Fluoro Carbon Predator 0.35mm 25m

2625035
Livrare imediată!

35,78Lei

Fir Textil Feeder WFT Gliss Sinking Black 0.10mm 150m 5kg
Exclusiv online!

Fir Textil Feeder WFT Gliss Sinking Black 0.10mm 150m 5kg

30474010
Livrare 24-48 ore

80,00Lei

MULINETA SPRO ELEMENT X 4000 5 Plus 1 RULMENTI TAMBUR REZERVA GRAFIT
Exclusiv online!

MULINETA SPRO ELEMENT X 4000 5 Plus 1 RULMENTI TAMBUR REZERVA GRAFIT

001321-00401-00000
Livrare 48-72 ore

215,00Lei

Spray Benzar Mix Method Feeder 50ml Miere Capsuni

Spray Benzar Mix Method Feeder 50ml Miere Capsuni

98015056
Livrare imediată!

12,00Lei

CARLIGE TRABUCCO XPS 710XB nr 10 25 BUC/PLIC
Exclusiv online!

CARLIGE TRABUCCO XPS 710XB nr 10 25 BUC/PLIC

021-70-100
Livrare 48-72 ore

16,01Lei

Momitor Feeder Carp Expert Bullet 25x26mm 60g

Momitor Feeder Carp Expert Bullet 25x26mm 60g

58078060
Livrare imediată!

13,60Lei

Afişare 7401 - 7420 din 12482 (625 pagini)
Queries: 5, Total time: 317.183 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = '7b6ed8ea002f5829ebd5f8070f'
/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 (265.600)
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('+feeder' 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 (51.282)
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 7400, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.126)
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