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


Momitor Delphin zinc striat cu tub 40g

Momitor Delphin zinc striat cu tub 40g

925001209
Livrare imediată!

6,00Lei

Jig Spro bila cu carlig Gamakatsu HD Jig 90 nr.6/0 40g 3buc plic
Exclusiv online!

Jig Spro bila cu carlig Gamakatsu HD Jig 90 nr.6/0 40g 3buc plic

004936-00600-00040
Livrare 48-72 ore

28,70Lei

BOILIES POP-UP CRALUSSO MINI, 12MM, 40G Usturoi

BOILIES POP-UP CRALUSSO MINI, 12MM, 40G Usturoi

98040690
Livrare imediată!

21,00Lei

METHOD FEEDER TRABUCCO AIRTEK PRO FEEDER FLATBED LARGE 40g

METHOD FEEDER TRABUCCO AIRTEK PRO FEEDER FLATBED LARGE 40g

140-70-150
Livrare imediată!

16,01Lei

Plumb Delphin tip lacrima 40g

Plumb Delphin tip lacrima 40g

830514040
Livrare imediată!

6,00Lei

Momitor Lestat Feeder Guru X-Change Cage Marime S 2buc/blister 40G Si 50G -23%

Momitor Lestat Feeder Guru X-Change Cage Marime S 2buc/blister 40G Si 50G

a.gu.gad02
Livrare imediată!

23,00Lei(-23%) 17,71Lei

Varga Lineaeffe Tele Carbo Queen Pole 6M 40g -20%
Exclusiv online!

Varga Lineaeffe Tele Carbo Queen Pole 6M 40g

l.2521360
Livrare 24-48 ore

223,08Lei(-20%) 178,46Lei

Momitor Delphin striat cu tub 40g

Momitor Delphin striat cu tub 40g

925001240
Livrare imediată!

6,00Lei

COSULET AS FEEDER BULLET FEEDER 25X31MM 40g
Exclusiv online!

COSULET AS FEEDER BULLET FEEDER 25X31MM 40g

32 25x31 40g
Livrare 48-72ore

11,31Lei

PILKER GOLDSTAR ECO 40G ALBASTRU/ARGINT

PILKER GOLDSTAR ECO 40G ALBASTRU/ARGINT

84305140
Livrare imediată!

9,00Lei

Plumb cu agrafa Delphin BARBED 40g

Plumb cu agrafa Delphin BARBED 40g

830511040
Livrare imediată!

6,00Lei

Lanseta Mivardi Reactor Spinning 2.70m, 15-40g, 2buc
Exclusiv online!

Lanseta Mivardi Reactor Spinning 2.70m, 15-40g, 2buc

miv-res270m
Livrare 48-72 ore

189,90Lei

Lanseta spinning Baracuda Sooty 2.40M 10-40g 2SEG

Lanseta spinning Baracuda Sooty 2.40M 10-40g 2SEG

sooty 240
Livrare imediată!

150,30Lei

COSULET AS FEEDER ROUND CAGE 26X31MM 40gr

COSULET AS FEEDER ROUND CAGE 26X31MM 40gr

19 5x13 40g
Livrare imediată!

5,00Lei

COSULET AS FEEDER ROUND CAGE 34X43MM 40 gr

COSULET AS FEEDER ROUND CAGE 34X43MM 40 gr

20 7x16 40g
Livrare imediată!

6,50Lei

Momitor Maver Cage Medium 40g

Momitor Maver Cage Medium 40g

k712
Livrare imediată!

12,00Lei

Set Mivardi Method Feeder Set Premium L + Matrita, 20g, 30g, 40g, 3+1buc/blister

Set Mivardi Method Feeder Set Premium L + Matrita, 20g, 30g, 40g, 3+1buc/blister

m-mfspl234
Livrare imediată!

36,99Lei

Lanseta Daiwa Sweepfire Spin 2.40M 10-40g 2SEG

Lanseta Daiwa Sweepfire Spin 2.40M 10-40g 2SEG

d.11435.240
Livrare imediată!

177,20Lei

PILKER GOLDSTAR ECO 40G NEGRU/ARGINT

PILKER GOLDSTAR ECO 40G NEGRU/ARGINT

84305240
Livrare imediată!

9,00Lei

Lanseta Mivardi Reactor Spinning 2.40m, 15-40g, 2buc
Exclusiv online!

Lanseta Mivardi Reactor Spinning 2.40m, 15-40g, 2buc

miv-res240m
Livrare 48-72 ore

177,00Lei

Afişare 341 - 360 din 815 (41 pagini)
Queries: 6, Total time: 26.747 ms [By time] [By id] [By file]
1 (0.164)
SELECT data
FROM `oc_session`
WHERE session_id = '001cbbbffa493381f1c6d9cbab'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.141)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (22.652)
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('+40g 50g' 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 (3.579)
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 340, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.103)
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.108)
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