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


Lansete Daiwa Megaforce BF 292XH 2.90m, 100-300g, 2seg
Exclusiv online!

Lansete Daiwa Megaforce BF 292XH 2.90m, 100-300g, 2seg

d.mfbf292xhcf
Livrare 24-48 ore

412,48Lei

Lanseta BOLOGNEZA PRO FL STRONGER BOLO 120G 6MT

Lanseta BOLOGNEZA PRO FL STRONGER BOLO 120G 6MT

64-4060
Livrare imediată!

267,90Lei

Benzi Prindere Lansete Garbolino Neoprene 2.40x3.00x0.4cm
Exclusiv online!

Benzi Prindere Lansete Garbolino Neoprene 2.40x3.00x0.4cm

90530braneo
Livrare 48-72 ore

41,19Lei

Bolognesa Trabucco Atomic XR Power Plus BLS 5.00m

Bolognesa Trabucco Atomic XR Power Plus BLS 5.00m

122-48-450
Livrare imediată!

695,00Lei

Kit Ulei + Vaselina Penn pentru Mulinete

Kit Ulei + Vaselina Penn pentru Mulinete

1238744
Livrare imediată!

67,96Lei

Lanseta Abu Garcia Iaconelli Signatura Rod 741ML, 5-21g, 2.23m, 2seg -56%

Lanseta Abu Garcia Iaconelli Signatura Rod 741ML, 5-21g, 2.23m, 2seg

1519216
Livrare imediată!

773,00Lei(-56%) 343,90Lei

Lanseta Abu Garcia ORRA Predator Spinning Rod 802 ML, 5-21g, 2.44m, 2seg

Lanseta Abu Garcia ORRA Predator Spinning Rod 802 ML, 5-21g, 2.44m, 2seg

1580846
Livrare imediată!

292,45Lei

Lanseta Abu Garcia Rod Tormentor Spin 9, 2.74m, 7-28g, 2seg

Lanseta Abu Garcia Rod Tormentor Spin 9, 2.74m, 7-28g, 2seg

1521001
Livrare imediată!

216,71Lei

Lanseta Abu Garcia Svartzonker Jawbreaker Motoroil Cast Rod H, 30-140g, 2.16m, 2seg

Lanseta Abu Garcia Svartzonker Jawbreaker Motoroil Cast Rod H, 30-140g, 2.16m, 2seg

1539791
Livrare imediată!

719,96Lei

Lanseta Abu Garcia Vendetta V3 Casting Rod MH, 15-40g, 2.13m, 2seg

Lanseta Abu Garcia Vendetta V3 Casting Rod MH, 15-40g, 2.13m, 2seg

1544526
Livrare imediată!

427,46Lei

Lanseta Abu Garcia Venerate Spin V2-E 702ML, 2.13m, 5-20g, 2seg -23%

Lanseta Abu Garcia Venerate Spin V2-E 702ML, 2.13m, 5-20g, 2seg

1539824
Livrare imediată!

233,70Lei(-23%) 179,90Lei

Lanseta Cormoran Seacor Bat Pilk 2.70m, 50-150g, 2seg
Exclusiv online!

Lanseta Cormoran Seacor Bat Pilk 2.70m, 50-150g, 2seg

c.29.851527
Livrare 24-48 ore

230,55Lei

Lanseta Daiwa Ballistic X Jig 2.20m, 7-28g, 2seg
Exclusiv online!

Lanseta Daiwa Ballistic X Jig 2.20m, 7-28g, 2seg

d.11526.220
Livrare 24-48 ore

549,43Lei

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

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

d.11165.360
Livrare imediată!

574,51Lei

Lanseta Daiwa Saltiga Slow Jig 1.85m, 250-400g, 1seg
Exclusiv online!

Lanseta Daiwa Saltiga Slow Jig 1.85m, 250-400g, 1seg

d.sgsl61b5
Livrare 24-48 ore

2.001,69Lei

Lanseta EnergoFish Wizard Active Spin, 2.00m, 10-30g, 2seg
Exclusiv online!

Lanseta EnergoFish Wizard Active Spin, 2.00m, 10-30g, 2seg

12063200
Livrare 24-48 ore

109,68Lei

Lanseta Feeder Guru A Class Distance Method Feeder 3.66m, 1-80g, 2+2seg

Lanseta Feeder Guru A Class Distance Method Feeder 3.66m, 1-80g, 2+2seg

gu.gac006
Livrare imediată!

324,14Lei

Lanseta FL Aqua Feeder 3.90M Tele

Lanseta FL Aqua Feeder 3.90M Tele

7157163521422
Livrare imediată!

172,60Lei

Lanseta Garbolino Zombie Max Carp Feeder 3S, 3.60m, 50-150g, 3seg

Lanseta Garbolino Zombie Max Carp Feeder 3S, 3.60m, 50-150g, 3seg

20505gofrl8227360-3
Livrare imediată!

455,89Lei

Lanseta Harrison Aviator Marker 3.80m 3.50lbs 2 seg
Exclusiv online!

Lanseta Harrison Aviator Marker 3.80m 3.50lbs 2 seg

av126mar
Livrare 30-60 zile

2.508,00Lei

Afişare 1081 - 1100 din 8889 (445 pagini)
Queries: 4, Total time: 226.707 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = 'ce22a6db31d5eff3b6d8cdf0df'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (226.273)
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('+lansete' 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.221)
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