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


BOILIES DYNAMITE BAITS COMPLEX-T 1KG 18MM

BOILIES DYNAMITE BAITS COMPLEX-T 1KG 18MM

dy1082
Livrare imediată!

69,00Lei

CLIPS PENTRU PLUMB PIERDUT POLE POSITION LEAD CLIP SET WEED 5BUC/PLIC
Exclusiv online!

CLIPS PENTRU PLUMB PIERDUT POLE POSITION LEAD CLIP SET WEED 5BUC/PLIC

008035-00012-00000
Livrare 48-72 ore

36,00Lei

Gratar Campingaz pentru peste

Gratar Campingaz pentru peste

205630
Livrare imediată!

45,01Lei

Penar Rigid Jaxon pentru Riguri 25x9x5cm

Penar Rigid Jaxon pentru Riguri 25x9x5cm

rh-320
Livrare imediată!

78,00Lei

SITA NADA JAXON LUX 2x2MM 30x45CM
Exclusiv online!

SITA NADA JAXON LUX 2x2MM 30x45CM

fj-shd2x2
Livrare 48-72 ore

137,00Lei

BOILIES Tare BUCOVINA CARP BAITS The Secret150G

BOILIES Tare BUCOVINA CARP BAITS The Secret150G

2252213541773
Livrare imediată!

22,00Lei

DESCHIZATOR CARP ZOOM CU LANTERNA 3in1
Exclusiv online!

DESCHIZATOR CARP ZOOM CU LANTERNA 3in1

cz2447
Livrare 48-72 ore

24,00Lei

Micropelete SENZOR Robin Red, 2mm, 800g

Micropelete SENZOR Robin Red, 2mm, 800g

snz99763
Livrare imediată!

24,00Lei

PLUMB DROP SHOT JAXON CU VARTEJ 7GR 3BUC/PLIC
Exclusiv online!

PLUMB DROP SHOT JAXON CU VARTEJ 7GR 3BUC/PLIC

cp-ds07
Livrare 48-72 ore

10,00Lei

CLESTE CORMORAN PENTRU MONTURI RAPITOR

CLESTE CORMORAN PENTRU MONTURI RAPITOR

a.84.10100
Livrare imediată!

42,30Lei

Kit pentru Protectie Lanseta/Mulineta FOX Camolite Reel and Rod Tip Protector
Exclusiv online!

Kit pentru Protectie Lanseta/Mulineta FOX Camolite Reel and Rod Tip Protector

clu320
Livrare 7-14 zile

130,46Lei

Snag Mivardi Bar pentru Avertizoare Rod Guard, 17cm
Exclusiv online!

Snag Mivardi Bar pentru Avertizoare Rod Guard, 17cm

m-sorg
Livrare 48-72 ore

57,00Lei

SET borcane Carp Zoom CUPE PENTRU MASURAT

SET borcane Carp Zoom CUPE PENTRU MASURAT

cz2958
Livrare imediată!

6,00Lei

Snag Bars Delkim Safe-D Carbon v2 pentru Avertizori Txi-D Bite Alarm

Snag Bars Delkim Safe-D Carbon v2 pentru Avertizori Txi-D Bite Alarm

a.de.dd009
Livrare imediată!

91,80Lei

Pelete Dynamite Baits Monster Tigernut 8mm 900g
Exclusiv online!

Pelete Dynamite Baits Monster Tigernut 8mm 900g

dy1128
Livrare 48-72ore

39,00Lei

BOILIES DYNAMITE BAITS COMPLEX-T 5KG 18MM
Exclusiv online!

BOILIES DYNAMITE BAITS COMPLEX-T 5KG 18MM

dy1089
Livrare 48-72ore

249,00Lei

CUTIT VANATOARE BROWNING HOG HUNTER, LAMA 16CM

CUTIT VANATOARE BROWNING HOG HUNTER, LAMA 16CM

a8.bo.322865
Livrare imediată!

227,25Lei

Dispozitiv Mivardi Pentru Strans Noduri

Dispozitiv Mivardi Pentru Strans Noduri

m-acoknpu
Livrare imediată!

13,90Lei

Foarfeca Daiwa pentru Fir Textil
Exclusiv online!

Foarfeca Daiwa pentru Fir Textil

a.15803.070
Livrare 24-48 ore

22,40Lei

Lamele de Rezerva Biwaa pentru Spinnertail Divinator 5cm 3buc/blister Gold Premium
Exclusiv online!

Lamele de Rezerva Biwaa pentru Spinnertail Divinator 5cm 3buc/blister Gold Premium

b000018
Livrare 48-72 ore

38,00Lei

Afişare 2141 - 2160 din 5141 (258 pagini)
Queries: 7, Total time: 131.572 ms [By time] [By id] [By file]
1 (0.174)
SELECT data
FROM `oc_session`
WHERE session_id = 'c0ba266e0431d5bbf12f688cce'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (99.194)
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 = '3' AND (MATCH(pd.tag) AGAINST('+pentru' 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 (31.717)
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 2140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.157)
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.120)
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
7 (0.129)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38