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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Lanseta Daiwa Ninja X Feeder 3.60m, 120g, 3+3seg -10%

Lanseta Daiwa Ninja X Feeder 3.60m, 120g, 3+3seg

d.11608.360
Livrare imediată!

356,16Lei(-10%) 319,00Lei

Lanseta Spinning Daiwa Tatula 701MFS 2.13m, 7-21g, 1seg

Lanseta Spinning Daiwa Tatula 701MFS 2.13m, 7-21g, 1seg

d.tat701mfsbf
Livrare imediată!

877,07Lei

Mulineta Daiwa DF2000A

Mulineta Daiwa DF2000A

d.df2000a
Livrare imediată!

102,14Lei

Mulineta Daiwa Emblem BR 10000 25A 0.32mm/320m, 5.3:1, 6rul -26%
Exclusiv online!

Mulineta Daiwa Emblem BR 10000 25A 0.32mm/320m, 5.3:1, 6rul

d.10158.100
Livrare 24-48 ore

1.232,63Lei(-26%) 912,59Lei

Mulineta Daiwa Emblem Surf 45 SCW QD 4500, 0.30mm/300m, 4.9:1, 6rul

Mulineta Daiwa Emblem Surf 45 SCW QD 4500, 0.30mm/300m, 4.9:1, 6rul

d.10711.450
Livrare imediată!

1.306,00Lei

Mulineta Daiwa Fuego LT3000-C, 0.23mm/150m, 5.3:1, 6rul

Mulineta Daiwa Fuego LT3000-C, 0.23mm/150m, 5.3:1, 6rul

d.10333.300
Livrare imediată!

602,98Lei

Mulineta Daiwa Legalis LT4000-C(U), 0.28mm/150m, 5.2:1, 5rul
Exclusiv online!

Mulineta Daiwa Legalis LT4000-C(U), 0.28mm/150m, 5.2:1, 5rul

d.10435.400
Livrare 24-48 ore

517,50Lei

Lanseta Daiwa Black Widow XT Bait 3.60m, 50-125g, 3seg

Lanseta Daiwa Black Widow XT Bait 3.60m, 50-125g, 3seg

d.11554.362
Livrare imediată!

314,21Lei

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.96m, 240g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.96m, 240g, 3+2seg

d.11165.390
Livrare imediată!

610,66Lei

Lanseta Daiwa N'Zon Distance Special Feeder 3.90m, 120g, 3+3seg

Lanseta Daiwa N'Zon Distance Special Feeder 3.90m, 120g, 3+3seg

d.11171.390
Livrare imediată!

1.348,64Lei

Lanseta Daiwa Ninja X Carp 3.90m, 3.5lbs, 3seg
Exclusiv online!

Lanseta Daiwa Ninja X Carp 3.90m, 3.5lbs, 3seg

d.11596.396
Livrare 24-48 ore

430,03Lei

Lanseta Spinning Daiwa Crossfire 270H 2.40m, 14-42g, 2seg
Exclusiv online!

Lanseta Spinning Daiwa Crossfire 270H 2.40m, 14-42g, 2seg

d.cf270haf
Livrare 24-48 ore

231,04Lei

Lanseta Spinning Daiwa Ninja X Kids Blue, 160m, 10-30g
Exclusiv online!

Lanseta Spinning Daiwa Ninja X Kids Blue, 160m, 10-30g

d.11208.160
Livrare 24-48 ore

138,87Lei

Mulineta Daiwa Crosscast Surf Type - R 35 SCW QD 3+1rul

Mulineta Daiwa Crosscast Surf Type - R 35 SCW QD 3+1rul

d.ccs2235scw5000qdr
Livrare imediată!

797,10Lei

Mulineta Daiwa MATCHMAN 3000, 0.28mm/200m, 5.3:1, 3rul
Exclusiv online!

Mulineta Daiwa MATCHMAN 3000, 0.28mm/200m, 5.3:1, 3rul

d.10113.300
Livrare 24-48 ore

286,73Lei

Rod Pod Barca Daiwa, 3 Posturi

Rod Pod Barca Daiwa, 3 Posturi

d.18800.901
Livrare imediată!

1.314,45Lei

Lanseta Daiwa BASIA X45X CARP 3.60m, 3.75lbs, 2seg
Exclusiv online!

Lanseta Daiwa BASIA X45X CARP 3.60m, 3.75lbs, 2seg

d.11995.366
Livrare 24-48 ore

3.964,28Lei

Lanseta Daiwa N Zon Super Slim Power Feeder 3.66m, 150g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Feeder 3.66m, 150g, 3+2seg

d.11161.360
Livrare imediată!

562,14Lei

Lanseta Daiwa N Zon Super Slim Power Feeder 3.96m, 150g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Feeder 3.96m, 150g, 3+2seg

d.11161.390
Livrare imediată!

598,65Lei

Lanseta Daiwa Tatula 702MHFB Baitcast 2.13m, 7-28g, 2seg
Exclusiv online!

Lanseta Daiwa Tatula 702MHFB Baitcast 2.13m, 7-28g, 2seg

d.tat702mhfbbf
Livrare 24-48 ore

865,67Lei

Afişare 261 - 280 din 1988 (100 pagini)
Queries: 4, Total time: 52.998 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = 'a775f466c2f022b3ae447b3535'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (52.623)
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.158)
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