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


Fir Textil Trakko Dyneema Kevlar 25m 0.11mm 6.5kg

Fir Textil Trakko Dyneema Kevlar 25m 0.11mm 6.5kg

gv010dac
Livrare imediată!

18,00Lei

STRUNA MUSTAD WOLFRAM 20CM/20LB 3BUC/PL

STRUNA MUSTAD WOLFRAM 20CM/20LB 3BUC/PL

a7.mwl0069
Livrare imediată!

12,38Lei

Inaintas L&k Fluorocarbon 9kg 20cm 2Buc/plic
Exclusiv online!

Inaintas L&k Fluorocarbon 9kg 20cm 2Buc/plic

82012920
Livrare 24-48 ore

15,01Lei

Strune Nevis Wolfram 25cm 10kg
Exclusiv online!

Strune Nevis Wolfram 25cm 10kg

8520-125
Livrare 48-72 ore

8,79Lei

BRIDE DUBLE DAIWA PREMIUM 1.3MM/30BUC/PL

BRIDE DUBLE DAIWA PREMIUM 1.3MM/30BUC/PL

d.15408.301
Livrare imediată!

11,52Lei

STRUNA Climax ULTRA PREDATOR TITANIUM 1x7 50cm 8kg

STRUNA Climax ULTRA PREDATOR TITANIUM 1x7 50cm 8kg

8610-20005-008
Livrare imediată!

64,00Lei

Bride Savage Gear Wire Crimps L 1.4mm

Bride Savage Gear Wire Crimps L 1.4mm

a.sg.54902
Livrare imediată!

20,83Lei

Inaintas L&k Fluorocarbon 11kg 20cm 2Buc/plic
Exclusiv online!

Inaintas L&k Fluorocarbon 11kg 20cm 2Buc/plic

82012120
Livrare 24-48 ore

16,01Lei

BRIDE DUBLE DAIWA PREMIUM 1.0MM/30BUC/PL
Exclusiv online!

BRIDE DUBLE DAIWA PREMIUM 1.0MM/30BUC/PL

d.15408.300
Livrare 24-48 ore

10,61Lei

Fir fluorocarbon Sufix Invisiline W/Socket 0.21mm 3.70kg 20m Clear
Exclusiv online!

Fir fluorocarbon Sufix Invisiline W/Socket 0.21mm 3.70kg 20m Clear

sil21c20h
Livrare 48-72ore

41,00Lei

STRUNE ENERGOTEAM WIZARD TITANIUM, 22CM 16KG 2BUC/PLIC

STRUNE ENERGOTEAM WIZARD TITANIUM, 22CM 16KG 2BUC/PLIC

82022216
Livrare imediată!

16,30Lei

Struna Dragon Classic Surflon Leader 1x19 A.F.W Light 30cm - 8kg -15%

Struna Dragon Classic Surflon Leader 1x19 A.F.W Light 30cm - 8kg

pdf5220830
Livrare imediată!

14,30Lei(-15%) 12,16Lei

Strune Wolfram Wizard Stiuca 10x15cm 10x22cm Si 10x30cm 30buc
Exclusiv online!

Strune Wolfram Wizard Stiuca 10x15cm 10x22cm Si 10x30cm 30buc

82008100
Livrare 24-48 ore

41,00Lei

Fir Struna Savage Gear RAW 49 Uncoated Brown 10m 0.54mm 23kg
Exclusiv online!

Fir Struna Savage Gear RAW 49 Uncoated Brown 10m 0.54mm 23kg

a.sg.54894
Livrare 24-48 ore

77,72Lei

STRUNE ENERGOTEAM WIZARD TITANIUM, 22CM 9KG 2BUC/PLIC
Exclusiv online!

STRUNE ENERGOTEAM WIZARD TITANIUM, 22CM 9KG 2BUC/PLIC

82022209
Livrare 24-48 ore

16,30Lei

Strune Wizard Wolfram 15-20-25cm 30buc
Exclusiv online!

Strune Wizard Wolfram 15-20-25cm 30buc

82008933
Livrare 24-48 ore

63,00Lei

Struna Cormoran Titanium Leader 30cm 2buc/plic 12kg
Exclusiv online!

Struna Cormoran Titanium Leader 30cm 2buc/plic 12kg

a7.75.84412
Livrare 24-48 ore

19,66Lei

Bride Savage Gear 100buc/plic 1.6mm
Exclusiv online!

Bride Savage Gear 100buc/plic 1.6mm

a.sg.54903
Livrare 24-48 ore

20,83Lei

Strune Wizard Wolfram Cu Carlige Duble 6 6kg 2buc
Exclusiv online!

Strune Wizard Wolfram Cu Carlige Duble 6 6kg 2buc

82008326
Livrare 24-48 ore

6,00Lei

Struna Savage Gear Black7 Trace 40cm 0.60mm 25kg 3buc/plic

Struna Savage Gear Black7 Trace 40cm 0.60mm 25kg 3buc/plic

a7.sg.54864
Livrare imediată!

17,89Lei

Afişare 361 - 380 din 718 (36 pagini)
Queries: 5, Total time: 14.120 ms [By time] [By id] [By file]
1 (0.175)
SELECT data
FROM `oc_session`
WHERE session_id = '0bd5cdd54dd9fabd27139ee236'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (13.615)
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('+strune' 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 (0.129)
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
5 (0.111)
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