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 Daiwa Prorex UL Finesse Braid Chartreuse 135m 1.80kg

Fir Textil Daiwa Prorex UL Finesse Braid Chartreuse 135m 1.80kg

d.12996.002
Livrare imediată!

96,66Lei

Lanseta Daiwa N Zone Distance Feeder 3.66m 150g 3+2seg

Lanseta Daiwa N Zone Distance Feeder 3.66m 150g 3+2seg

d.11332.366
Livrare imediată!

433,76Lei

Agrafe cu Vartej Daiwa Tournament D-SNAP, 7buc/plic Nr. 5 / 20kg -27%

Agrafe cu Vartej Daiwa Tournament D-SNAP, 7buc/plic Nr. 5 / 20kg

a7.16513.001
Livrare imediată!

27,11Lei(-27%) 19,90Lei

Saltea Primire Daiwa Black Widow 106x64cm -20%
Exclusiv online!

Saltea Primire Daiwa Black Widow 106x64cm

a.18705.100
Livrare 24-48 ore

126,45Lei(-20%) 101,16Lei

MULINETA DAIWA LAGUNA LT 2000 3RUL/120M/0,18MM/5,2:1 -8%

MULINETA DAIWA LAGUNA LT 2000 3RUL/120M/0,18MM/5,2:1

d.10414.205
Livrare imediată!

250,67Lei(-8%) 231,40Lei

Lanseta Daiwa Prorex AGS Spin 2.25m 3-12g 2seg
Exclusiv online!

Lanseta Daiwa Prorex AGS Spin 2.25m 3-12g 2seg

d.11211.225
Livrare 24-48 ore

1.123,55Lei

VOBLER DAIWA TN KP FLATT CRANK, LIME BLACK CHART, 3.3CM, 1.8G
Exclusiv online!

VOBLER DAIWA TN KP FLATT CRANK, LIME BLACK CHART, 3.3CM, 1.8G

f3.d16709.051
Livrare 24-48 ore

65,00Lei

Lanseta Daiwa Tatula Spinning 1.95M 7-21g 2SEG
Exclusiv online!

Lanseta Daiwa Tatula Spinning 1.95M 7-21g 2SEG

d.11461.195
Livrare 24-48 ore

708,48Lei

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

SHAD DAIWA DUCKFIN 12.5CM/PEARL/5BUC/PL
Exclusiv online!

SHAD DAIWA DUCKFIN 12.5CM/PEARL/5BUC/PL

d.16500.412
Livrare 24-48 ore

45,24Lei

MULINETA DAIWA LAGUNA LT 2500 3RUL/230M/0,16MM/5,3:1 -8%

MULINETA DAIWA LAGUNA LT 2500 3RUL/230M/0,16MM/5,3:1

d.10414.255
Livrare imediată!

259,48Lei(-8%) 239,52Lei

AGRAFA EGG DAIWA NR.8/7,0KG/10BUC/PL
Exclusiv online!

AGRAFA EGG DAIWA NR.8/7,0KG/10BUC/PL

a7.14905.608
Livrare 24-48 ore

5,91Lei

HUSA DAIWA BLACK WIDOW HOLDALL 3 LANSETE PLUS 3 MULINETE 200X40CM
Exclusiv online!

HUSA DAIWA BLACK WIDOW HOLDALL 3 LANSETE PLUS 3 MULINETE 200X40CM

d.18705.012
Livrare 24-48 ore

388,07Lei

Husa Daiwa pentru Lanseta + Mulineta, 145cm
Exclusiv online!

Husa Daiwa pentru Lanseta + Mulineta, 145cm

d.15809.325
Livrare 24-48 ore

444,39Lei

SHAD DAIWA DUCKFIN 12.5CM/CHARTREUSE/5BUC/PL
Exclusiv online!

SHAD DAIWA DUCKFIN 12.5CM/CHARTREUSE/5BUC/PL

d.16500.312
Livrare 24-48 ore

45,24Lei

Lanseta Daiwa Tatula 6101 MXS 2.08M 5-21g 1SEG -20%
Exclusiv online!

Lanseta Daiwa Tatula 6101 MXS 2.08M 5-21g 1SEG

d.tat6101mxsaf
Livrare 24-48 ore

768,55Lei(-20%) 614,84Lei

FIR TEXTIL DAIWA J-BRAID X4 0.19MM 10.2KG 135MT VERDE

FIR TEXTIL DAIWA J-BRAID X4 0.19MM 10.2KG 135MT VERDE

d.12741.019
Livrare imediată!

44,30Lei

Lanseta Daiwa Ballistic X Jiggerspin 2.40M 7-28g 2SEG -30%

Lanseta Daiwa Ballistic X Jiggerspin 2.40M 7-28g 2SEG

d.11511.240
Livrare imediată!

520,33Lei(-30%) 364,24Lei

PILKER DAIWA PROREX 4MM/7G LAZER GREEN

PILKER DAIWA PROREX 4MM/7G LAZER GREEN

f.d15308.840
Livrare imediată!

18,00Lei

Pop Up Daiwa Advantage Hookbaits Yellow 8-10mm 30g -5%

Pop Up Daiwa Advantage Hookbaits Yellow 8-10mm 30g

a0.13300.105
Livrare imediată!

36,99Lei(-5%) 35,09Lei

Afişare 861 - 880 din 1984 (100 pagini)
Queries: 4, Total time: 51.202 ms [By time] [By id] [By file]
1 (0.181)
SELECT data
FROM `oc_session`
WHERE session_id = '3295bf6d79b30c5c90053c0dc7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (50.751)
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('+daiwa' 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.170)
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