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 Spinning Daiwa 2seg Prorex S, 2,40m/7-21g

Lanseta Spinning Daiwa 2seg Prorex S, 2,40m/7-21g

d.11280.240
Livrare imediată!

368,80Lei

Lanseta Trabucco Achab Pro Boat 2.40m, 200g, 2seg

Lanseta Trabucco Achab Pro Boat 2.40m, 200g, 2seg

161-11-420
Livrare imediată!

170,00Lei

Lanseta Trabucco Searider Bolentino, 2.40m, 200g, 2seg

Lanseta Trabucco Searider Bolentino, 2.40m, 200g, 2seg

161-14-530
Livrare imediată!

180,00Lei

Lanseta Spinning Daiwa 2seg Caldia Jigger 2,40m/7-28g -23%

Lanseta Spinning Daiwa 2seg Caldia Jigger 2,40m/7-28g

d.11426.240
Livrare imediată!

517,51Lei(-23%) 399,00Lei

Lanseta Spinning Daiwa 2seg Caldia Spin 2,40m/10-40g -19%

Lanseta Spinning Daiwa 2seg Caldia Spin 2,40m/10-40g

d.11425.245
Livrare imediată!

617,10Lei(-19%) 499,90Lei

Lanseta Trabucco Achab Pro Boat 2.40m, 250g, 2seg
Exclusiv online!

Lanseta Trabucco Achab Pro Boat 2.40m, 250g, 2seg

161-11-520
Livrare 48-72 ore

185,00Lei

Lanseta Delphin MURENA POWER 2.40m, 125g, 2seg -30%

Lanseta Delphin MURENA POWER 2.40m, 125g, 2seg

101003141
Livrare imediată!

249,00Lei(-30%) 173,70Lei

Lanseta EnergoTeam Wizard Samurai Spin 2.40m, 15-65g, 2seg

Lanseta EnergoTeam Wizard Samurai Spin 2.40m, 15-65g, 2seg

13187242
Livrare imediată!

239,00Lei

Lanseta Sunset Tamara Power ZXR, 2.40m, 100-300g, 2seg

Lanseta Sunset Tamara Power ZXR, 2.40m, 100-300g, 2seg

20311stsrj8147240-2
Livrare imediată!

198,83Lei

Lanseta Mitchell Adventure Il Tele Spinning 2.40m, 10-35g -24%

Lanseta Mitchell Adventure Il Tele Spinning 2.40m, 10-35g

1558848
Livrare imediată!

79,96Lei(-24%) 60,90Lei

Lanseta Spinning Daiwa 2seg Airity Jigger, 2.40m/7-28g

Lanseta Spinning Daiwa 2seg Airity Jigger, 2.40m/7-28g

d.11927.240
Livrare imediată!

1.000,84Lei

Lanseta Spinning Daiwa 2seg Airity Spin, 2.40m/14-42g

Lanseta Spinning Daiwa 2seg Airity Spin, 2.40m/14-42g

d.11926.240
Livrare imediată!

1.004,03Lei

Lanseta Spinning Daiwa 2seg Triforce Target Perch Spin, 2.40m, 10-30g

Lanseta Spinning Daiwa 2seg Triforce Target Perch Spin, 2.40m, 10-30g

d.11400.245
Livrare imediată!

201,86Lei

Lanseta Sunset Tryska ZXR, 2.40m, 80-150g, 2seg

Lanseta Sunset Tryska ZXR, 2.40m, 80-150g, 2seg

20311stsrj8146240-2
Livrare imediată!

165,85Lei

Lanseta Telescopica Trabucco Scuba Xtreme Teknic Boat 2.40m, 120g, 4seg

Lanseta Telescopica Trabucco Scuba Xtreme Teknic Boat 2.40m, 120g, 4seg

162-69-020
Livrare imediată!

195,01Lei

Lanseta Trabucco Danubius Carp Pro 2.40m, 150g, 2seg
Exclusiv online!

Lanseta Trabucco Danubius Carp Pro 2.40m, 150g, 2seg

161-12-310
Livrare 48-72 ore

199,00Lei

Lanseta Zeck Evo Cat Spin, 2.40m, 100g, 2seg
Exclusiv online!

Lanseta Zeck Evo Cat Spin, 2.40m, 100g, 2seg

20305100242
Livrare 48-72 ore

1.016,56Lei

Lanseta Zeck Pro-Cat Boat, 2.40m, 300g, 2seg -26%

Lanseta Zeck Pro-Cat Boat, 2.40m, 300g, 2seg

20305100240
Livrare imediată!

866,15Lei(-26%) 641,90Lei

Lanseta Colmic Herakles Calida Ego HCE2-80MF 2.40m 10-30g
Exclusiv online!

Lanseta Colmic Herakles Calida Ego HCE2-80MF 2.40m 10-30g

cahkce05
Livrare 48-72 ore

545,00Lei

Lanseta Delphin CAPRI Tele NXT 2.40m, 60g, 5seg

Lanseta Delphin CAPRI Tele NXT 2.40m, 60g, 5seg

101003108
Livrare imediată!

125,90Lei

Afişare 301 - 320 din 629 (32 pagini)
Queries: 6, Total time: 23.422 ms [By time] [By id] [By file]
1 (0.528)
SELECT data
FROM `oc_session`
WHERE session_id = 'f362dff70cb3842579e743f4b8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.346)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.316)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (19.082)
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('+40m' 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
5 (3.017)
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 300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.133)
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