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 300 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


Mulineta DAM IMPULSE 8 4000 FEEDER
Exclusiv online!

Mulineta DAM IMPULSE 8 4000 FEEDER

dam.73070
Livrare 24-48 ore

267,31Lei

Mulineta DAM Nova FD 5000 + Fir Monofilament, 0.35mm-220m, 5.2:1, 1BB

Mulineta DAM Nova FD 5000 + Fir Monofilament, 0.35mm-220m, 5.2:1, 1BB

dam.75958
Livrare imediată!

70,29Lei

Mulineta, DAM, QUICK, FUN-TECH, 3, MK1, 2500, FD, dam.72975, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, D.A.M
Mulineta Dam Quick Panthera FD 4000s
Exclusiv online!

Mulineta Dam Quick Panthera FD 4000s

dam.73006
Livrare 24-48 ore

179,69Lei

Pungi Solubile DAM Madcat 25x10cm, 20buc/pac
Exclusiv online!

Pungi Solubile DAM Madcat 25x10cm, 20buc/pac

a.mad.70838
Livrare 24-48 ore

76,16Lei

Set 3 Avertizoare + Statie DAM Somn Madcat Topcat

Set 3 Avertizoare + Statie DAM Somn Madcat Topcat

a.mad.70764
Livrare imediată!

1.509,87Lei

Suport Spate pentru Lanseta DAM Metalic, Ajustabil, 1buc/pac
Exclusiv online!

Suport Spate pentru Lanseta DAM Metalic, Ajustabil, 1buc/pac

a6.dam.2919002
Livrare 24-48 ore

104,65Lei

Varga DAM Ensomat TRX 6.00m
Exclusiv online!

Varga DAM Ensomat TRX 6.00m

dam.2010600
Livrare 24-48 ore

266,04Lei

Avertizor electronic DAM Ontario Blue

Avertizor electronic DAM Ontario Blue

a.dam.63617
Livrare imediată!

45,52Lei

Caciula Dama Norfin Nordic L
Exclusiv online!

Caciula Dama Norfin Nordic L

305080-l
Livrare 48-72ore

230,00Lei

Camasa Dama Blaser Sergia, Dark Olive, Marime 38
Exclusiv online!

Camasa Dama Blaser Sergia, Dark Olive, Marime 38

bl.121032.087.38
Livrare 24-48 ore

372,41Lei

Cizme DAM Flex Cauciuc Neopren 3mm, Marime 42
Exclusiv online!

Cizme DAM Flex Cauciuc Neopren 3mm, Marime 42

a8.dam.8739242
Livrare 24-48 ore

358,87Lei

Fir Monofilament Damyl Spezi Line Feeder Dark Brown, 0.22mm, 4.6kg, 500m

Fir Monofilament Damyl Spezi Line Feeder Dark Brown, 0.22mm, 4.6kg, 500m

a.dam.66638
Livrare imediată!

20,83Lei

Lanseta DAM Madcat White Clonk Teaser, 2.40m, 1200-250g, 2seg
Exclusiv online!

Lanseta DAM Madcat White Clonk Teaser, 2.40m, 1200-250g, 2seg

mad.1604091
Livrare 24-48 ore

602,47Lei

Lanseta DAM Yagi Spin F, 2.59m, 12-42g, 2seg
Exclusiv online!

Lanseta DAM Yagi Spin F, 2.59m, 12-42g, 2seg

dam.60038
Livrare 24-48 ore

271,86Lei

Lanseta DAM Yagi Spin UL Jig MF, 2.25m, 3-15g, 2seg
Exclusiv online!

Lanseta DAM Yagi Spin UL Jig MF, 2.25m, 3-15g, 2seg

dam.60306
Livrare 24-48 ore

210,93Lei

Lanseta Spinning DAM Tele Nova Exped 2.70m, 20-40g, 6seg

Lanseta Spinning DAM Tele Nova Exped 2.70m, 20-40g, 6seg

dam.75555
Livrare imediată!

84,19Lei

Matrita DAM Detek Feeder Mold M
Exclusiv online!

Matrita DAM Detek Feeder Mold M

4190466026
Livrare 48-72 ore

16,90Lei

Momitor Method Feeder DAM Detek Inline, Marime M, 40g, 1buc/pac
Exclusiv online!

Momitor Method Feeder DAM Detek Inline, Marime M, 40g, 1buc/pac

a.dam.66019
Livrare 24-48 ore

14,33Lei

Momitor Method Feeder DAM Detek Inline, Marime S, 25g, 1buc/pac
Exclusiv online!

Momitor Method Feeder DAM Detek Inline, Marime S, 25g, 1buc/pac

a.dam.66017
Livrare 24-48 ore

12,73Lei

Afişare 321 - 340 din 1624 (82 pagini)
Queries: 9, Total time: 257.647 ms [By time] [By id] [By file]
1 (0.159)
SELECT data
FROM `oc_session`
WHERE session_id = '55e329f46e334400eef56f5dcb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.129)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (250.415)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%dam%") 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:698
5 (6.416)
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 320, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.158)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.092)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.080)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.077)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38