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


Lanseta Okuma Jaw Spin UL, 7-21g , 2.44m, 2seg
Exclusiv online!

Lanseta Okuma Jaw Spin UL, 7-21g , 2.44m, 2seg

jaw-s-802ul
Livrare 48-72ore

199,00Lei

Lanseta Cast Airrus Ultra X 2.13m 7-21g 1Seg
Exclusiv online!

Lanseta Cast Airrus Ultra X 2.13m 7-21g 1Seg

ux701mhmf-c
Livrare 48-72 ore

755,00Lei

Lanseta Colmic Herakles Calida Pro Evolution Cast 2.13m 7-21g
Exclusiv online!

Lanseta Colmic Herakles Calida Pro Evolution Cast 2.13m 7-21g

cahkcp52
Livrare 48-72 ore

292,00Lei

LANSETA DAIWA 1BUC STEEZ AGS 701MFBBF 7-21G -20%
Exclusiv online!

LANSETA DAIWA 1BUC STEEZ AGS 701MFBBF 7-21G

d.stzags701mfbbf
Livrare 24-48 ore

1.467,57Lei(-20%) 1.174,05Lei

Lanseta Daiwa Fuego Baitcast 661MFB, 1.98m, 7-21g, 1buc -30%
Exclusiv online!

Lanseta Daiwa Fuego Baitcast 661MFB, 1.98m, 7-21g, 1buc

d.fu661mfbaf
Livrare 24-48 ore

475,67Lei(-30%) 332,96Lei

Lanseta Colmic Herakles Youth Spin 2.13m 7-21g

Lanseta Colmic Herakles Youth Spin 2.13m 7-21g

cahkyo02
Livrare imediată!

162,99Lei

Lanseta Colmic Herakles Black Weapon Revenge Cast 2.05m 7-21g 1Seg
Exclusiv online!

Lanseta Colmic Herakles Black Weapon Revenge Cast 2.05m 7-21g 1Seg

cahkbwr52
Livrare 48-72 ore

1.000,00Lei

Lanseta Daiwa Tatula 662MB Baitcast 1.98M 7-21g 2SEG -20%
Exclusiv online!

Lanseta Daiwa Tatula 662MB Baitcast 1.98M 7-21g 2SEG

d.tat662mhfbaf
Livrare 24-48 ore

740,95Lei(-20%) 592,76Lei

Lanseta spinning Baracuda Zander Fest II 2.20m 7-21g 2seg

Lanseta spinning Baracuda Zander Fest II 2.20m 7-21g 2seg

zander fest
Livrare imediată!

231,50Lei

Lanseta Daiwa Tatula Baitcast 701MRBAF 2.13M 7-21g 1SEG -20%
Exclusiv online!

Lanseta Daiwa Tatula Baitcast 701MRBAF 2.13M 7-21g 1SEG

d.tat701mrbaf
Livrare 24-48 ore

726,96Lei(-20%) 581,64Lei

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 Savage Gear SG2 Vertical Specialist 1.98m 7-21g 2seg -30%
Exclusiv online!

Lanseta Savage Gear SG2 Vertical Specialist 1.98m 7-21g 2seg

o.sg.72180
Livrare 24-48 ore

262,84Lei(-30%) 183,99Lei

Lanseta Daiwa Prorex XR Spinning 2.40M 7-21g 2SEG
Exclusiv online!

Lanseta Daiwa Prorex XR Spinning 2.40M 7-21g 2SEG

d.11331.240
Livrare 24-48 ore

760,99Lei

Lanseta Airrus Stargate Spinning MH 2.40m 7-21g 2seg
Exclusiv online!

Lanseta Airrus Stargate Spinning MH 2.40m 7-21g 2seg

asg802mhmf-s
Livrare 48-72 ore

1.370,00Lei

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 T/C FINEZZE SPEC. 2,13M/7-21G
Exclusiv online!

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 T/C FINEZZE SPEC. 2,13M/7-21G

o.sg.75789
Livrare 24-48 ore

489,61Lei

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 Spinning Daiwa 2seg Ballistic Ltd Spin, 2.10m/7-21g

Lanseta Spinning Daiwa 2seg Ballistic Ltd Spin, 2.10m/7-21g

d.11220.215
Livrare imediată!

571,80Lei

Lanseta Spinning Daiwa Airity Spin, 2.10m, 7-21g, 2seg

Lanseta Spinning Daiwa Airity Spin, 2.10m, 7-21g, 2seg

d.11926.210
Livrare imediată!

946,48Lei

Lanseta Spinning Daiwa 2seg Caldia Spin 2,10m/7-21g -22%

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

d.11425.210
Livrare imediată!

499,03Lei(-22%) 389,90Lei

Lanseta Colmic Herakles Calida Ego HCE2-70MH 2.13m 7-21g
Exclusiv online!

Lanseta Colmic Herakles Calida Ego HCE2-70MH 2.13m 7-21g

cahkce03
Livrare 48-72 ore

485,00Lei

Afişare 21 - 40 din 64 (4 pagini)
Queries: 5, Total time: 571.497 ms [By time] [By id] [By file]
1 (0.152)
SELECT data
FROM `oc_session`
WHERE session_id = 'cd57774e25ce1dd4463e13bbdc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (570.947)
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 (pd.tag LIKE "%7-21g%") 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.162)
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.131)
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