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


SET METHOD FEEDER CORMORAN 2 BUC/SET 50G

SET METHOD FEEDER CORMORAN 2 BUC/SET 50G

a.49.67050
Livrare imediată!

25,59Lei

SUPORT Carp Zoom MONTURI HAIR METHOD FEEDER

SUPORT Carp Zoom MONTURI HAIR METHOD FEEDER

cz5133
Livrare imediată!

12,00Lei

Momitor Nevis Method Feeder la Distanta L 40gr

Momitor Nevis Method Feeder la Distanta L 40gr

8100-941
Livrare imediată!

9,70Lei

PELETE CARLIG BENZAR MIX BICOLOR METHOD PELLET - Cocos-vanilie

PELETE CARLIG BENZAR MIX BICOLOR METHOD PELLET - Cocos-vanilie

98088712
Livrare imediată!

15,00Lei

Method Long Cast Feeder Extra Carp in line 25gr

Method Long Cast Feeder Extra Carp in line 25gr

ec4119
Livrare imediată!

7,90Lei

SET METHOD FEEDER + MATRITA TRABUCCO AIRTEK PRO FEEDER LARGE 40G

SET METHOD FEEDER + MATRITA TRABUCCO AIRTEK PRO FEEDER LARGE 40G

140-70-020
Livrare imediată!

26,00Lei

FIR MONOFILAMENT JAXON METHOD FEEDER 150M 0.18MM

FIR MONOFILAMENT JAXON METHOD FEEDER 150M 0.18MM

zj-mef018a
Livrare imediată!

18,00Lei

Method Long Cast Feeder Extra Carp in line 50gr

Method Long Cast Feeder Extra Carp in line 50gr

ec4157
Livrare imediată!

9,40Lei

Fir Textil Benzar Method Braid 200m 0.20mm
Exclusiv online!

Fir Textil Benzar Method Braid 200m 0.20mm

30595020
Livrare 24-48 ore

89,00Lei

MONTURA METHOD FEEDER FL NR 12 0.20mm 30cm 8/plic

MONTURA METHOD FEEDER FL NR 12 0.20mm 30cm 8/plic

hy-mfl12
Livrare imediată!

11,00Lei

Set Momitor Method Team Feeder Vario 2 Plus 1 55gr

Set Momitor Method Team Feeder Vario 2 Plus 1 55gr

7341-255
Livrare imediată!

57,00Lei

PELETE CARLIG BENZAR MIX BICOLOR METHOD PELLET - Capsuni-miere

PELETE CARLIG BENZAR MIX BICOLOR METHOD PELLET - Capsuni-miere

98088716
Livrare imediată!

15,00Lei

Cap Minciog Carp Expert Method Feeder Cauciucat Giant 60x50x55cm
Exclusiv online!

Cap Minciog Carp Expert Method Feeder Cauciucat Giant 60x50x55cm

71026550
Livrare 24-48 ore

67,00Lei

MOMITOR CRESTA EASY FEEDER 35 GR

MOMITOR CRESTA EASY FEEDER 35 GR

004722-00133-00000
Livrare imediată!

16,90Lei

Method Feeder Inline AS Feeder 37 Small 45g

Method Feeder Inline AS Feeder 37 Small 45g

37 45g
Livrare imediată!

9,90Lei

Fir monofilament Jaxon Method Feeder Dark Brown 0.30mm 18kg 150m

Fir monofilament Jaxon Method Feeder Dark Brown 0.30mm 18kg 150m

zj-mef030a
Livrare imediată!

24,00Lei

FIR ENERGO TEAM POWER METHOD FEEDER 200m 0.22mm
Exclusiv online!

FIR ENERGO TEAM POWER METHOD FEEDER 200m 0.22mm

33515022
Livrare 24-48 ore

9,50Lei

Varf Rezerva Carpexpert METHOD FEEDER 3.60 Fibra Galben
Exclusiv online!

Varf Rezerva Carpexpert METHOD FEEDER 3.60 Fibra Galben

12330368
Livrare 24-48 ore

21,00Lei

Momitor Nevis Method Feeder L 30gr

Momitor Nevis Method Feeder L 30gr

8100-930
Livrare imediată!

7,00Lei

Method Mould DAM Sumo Method Feeder Mould Medium

Method Mould DAM Sumo Method Feeder Mould Medium

403098009000
Livrare imediată!

14,70Lei

Afişare 1021 - 1040 din 2514 (126 pagini)
Queries: 5, Total time: 58.224 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '155574a92cf5b30f37e21dfa67'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (48.261)
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('+method' 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 (9.643)
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 1020, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.099)
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