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 LS-6K Feeder 360cm 40-80g MLG/LG -17%

Lanseta Okuma LS-6K Feeder 360cm 40-80g MLG/LG

6k-f-1203mh
Livrare imediată!

422,10Lei(-17%) 350,00Lei

Suport Lansete Pentru Perete Berkley Space Saver 13 Posturi

Suport Lansete Pentru Perete Berkley Space Saver 13 Posturi

1546013
Livrare imediată!

254,96Lei

LANSETA SPORTEX KEV NITRO 270cm 24-74g

LANSETA SPORTEX KEV NITRO 270cm 24-74g

sp2703
Livrare imediată!

1.150,00Lei

Lanseta Berkley Cherrywood Original 2.10m 2-10g

Lanseta Berkley Cherrywood Original 2.10m 2-10g

1531530
Livrare imediată!

148,71Lei

Lanseta DAM New Yagi Light Jig 2.70m 5-26g
Exclusiv online!

Lanseta DAM New Yagi Light Jig 2.70m 5-26g

2040960312
Livrare 48-72 ore

274,79Lei

Lanseta Feeder Matrix Ethos XRF 11ft 3.30m Feeder 45g 2.8mm 2+2seg -14%
Exclusiv online!

Lanseta Feeder Matrix Ethos XRF 11ft 3.30m Feeder 45g 2.8mm 2+2seg

grd200
Livrare 7-14 zile

854,96Lei(-14%) 734,80Lei

Lanseta Sportex Black Arrow G-3 210cm 20gr
Exclusiv online!

Lanseta Sportex Black Arrow G-3 210cm 20gr

ba2132
Livrare 48-72 ore

940,00Lei

LANSETA SPORTEX KEV NITRO 270cm 34-97g

LANSETA SPORTEX KEV NITRO 270cm 34-97g

sp2714
Livrare imediată!

1.210,00Lei

HUSA PENTRU TREI LANSETE MIVARDI ROD HOLDALL MULTI CAMO 160 CM
Exclusiv online!

HUSA PENTRU TREI LANSETE MIVARDI ROD HOLDALL MULTI CAMO 160 CM

m-rhmc160
Livrare 48-72 ore

299,00Lei

Husa lansete Feeder Concept Rod Tube 1 compartiment
Exclusiv online!

Husa lansete Feeder Concept Rod Tube 1 compartiment

fc120b
Livrare 48-72ore

281,99Lei

Lanseta Feeder Matrix Ethos XRS 11.6ft 3.5m Light Feeder 35g 2.2mm 2+2seg -14%

Lanseta Feeder Matrix Ethos XRS 11.6ft 3.5m Light Feeder 35g 2.2mm 2+2seg

grd196
Livrare imediată!

854,96Lei(-14%) 734,80Lei

Lanseta Matrix Ethos XRW 11ft 3.30M Waggler 30g -14%
Exclusiv online!

Lanseta Matrix Ethos XRW 11ft 3.30M Waggler 30g

grd192
Livrare 7-14 zile

701,95Lei(-14%) 603,28Lei

Lanseta Okuma LS-6K Feeder 300cm 30g MLG/LG
Exclusiv online!

Lanseta Okuma LS-6K Feeder 300cm 30g MLG/LG

6k-f-1002m
Livrare 48-72ore

368,10Lei

Lanseta 13Fishing Defy Black, 1.83m, 3-15g, 2buc
Exclusiv online!

Lanseta 13Fishing Defy Black, 1.83m, 3-15g, 2buc

defbs60l2
Livrare 48-72ore

329,00Lei

LANSETA DAIWA 1BUC STEEZ 701MHFS 2,13M/7-28G
Exclusiv online!

LANSETA DAIWA 1BUC STEEZ 701MHFS 2,13M/7-28G

d.stzags701mhfscf
Livrare 24-48 ore

2.332,55Lei

Lanseta OKUMA Wave Power Spin 6'0" 183cm 2-10g L 2sec

Lanseta OKUMA Wave Power Spin 6'0" 183cm 2-10g L 2sec

wp-s-602l
Livrare imediată!

134,10Lei

LANSETA SPINNING DAIWA 2BUC. PROREX LTD 2,25M/3-14G -22%

LANSETA SPINNING DAIWA 2BUC. PROREX LTD 2,25M/3-14G

d.11200.220
Livrare imediată!

818,40Lei(-22%) 639,90Lei

Lanseta Berkley Cherrywood Original 2.00m 5-15g

Lanseta Berkley Cherrywood Original 2.00m 5-15g

1531527
Livrare imediată!

135,96Lei

Lanseta Fox Horizon X5-s Full shrink 3.60M Spod / Marker -30%
Exclusiv online!

Lanseta Fox Horizon X5-s Full shrink 3.60M Spod / Marker

crd341
Livrare 7-14 zile

1.552,46Lei(-30%) 1.086,72Lei

Lanseta DAM Salt-X SW Spin 2.20m 7-30gr -29%

Lanseta DAM Salt-X SW Spin 2.20m 7-30gr

2040965742
Livrare imediată!

275,73Lei(-29%) 195,77Lei

Afişare 341 - 360 din 8887 (445 pagini)
Queries: 7, Total time: 254.919 ms [By time] [By id] [By file]
1 (0.160)
SELECT data
FROM `oc_session`
WHERE session_id = '62fb660fbddcba13511e137d4a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (254.071)
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.205)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.127)
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
6 (0.120)
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
7 (0.134)
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