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 PROLOGIC C1 AVENGER OLD SKOOL 3.60M 3.00LBS 2SEG
Exclusiv online!

LANSETA PROLOGIC C1 AVENGER OLD SKOOL 3.60M 3.00LBS 2SEG

o.pro.72717
Livrare 24-48 ore

349,49Lei

LANSETA SAVAGE GEAR SG4 LIGHT GAME 2.15M 5-18G 4SEG
Exclusiv online!

LANSETA SAVAGE GEAR SG4 LIGHT GAME 2.15M 5-18G 4SEG

o.sg.72196
Livrare 24-48 ore

518,20Lei

LANSETA BOLOGNEZA COLMIC ZEPHIR MASTER 4.00M 12GR
Exclusiv online!

LANSETA BOLOGNEZA COLMIC ZEPHIR MASTER 4.00M 12GR

caze51a
Livrare 48-72 ore

281,99Lei

LANSETA SPINNING Maver IT AREA SPOON 6 2 1.90M 0.3-5GR
Exclusiv online!

LANSETA SPINNING Maver IT AREA SPOON 6 2 1.90M 0.3-5GR

5769002
Livrare 48-72 ore

360,00Lei

LANSETA OKUMA CEYMAR FEEDER 3.60m 40-80g 3 SEGMENTE
Exclusiv online!

LANSETA OKUMA CEYMAR FEEDER 3.60m 40-80g 3 SEGMENTE

c-f-1203mh
Livrare 48-72ore

350,10Lei

LANSETA SPRO GOVERNOR CARP 3.60M 3.25 LBS 2SEG

LANSETA SPRO GOVERNOR CARP 3.60M 3.25 LBS 2SEG

002968-00362-00000
Livrare imediată!

236,00Lei

Lanseta Feeder Cormoran Sportline 3.30m 50-150g 3+3SEG

Lanseta Feeder Cormoran Sportline 3.30m 50-150g 3+3SEG

c.24.0150335
Livrare imediată!

169,87Lei

Lanseta Sert Fish Instinct FW20 2.10m 10-30gr 2seg

Lanseta Sert Fish Instinct FW20 2.10m 10-30gr 2seg

20401seprh8019210-2
Livrare imediată!

75,43Lei

INEL FUJI COLMIC TITANIUM TORZITE T LRVTG NR 6
Exclusiv online!

INEL FUJI COLMIC TITANIUM TORZITE T LRVTG NR 6

mtlrvtg6
Livrare 48-72 ore

50,00Lei

LANSETA SPINNING DAIWA SET LANS. 3BUC TOURT FLY 905 3 AF 2,74M + DJ56
Exclusiv online!

LANSETA SPINNING DAIWA SET LANS. 3BUC TOURT FLY 905 3 AF 2,74M + DJ56

d.setmouche01
Livrare 24-48 ore

316,89Lei

LANSETA TRABUCCO SONIC POWER BOAT 2.30m 200g 4SEG

LANSETA TRABUCCO SONIC POWER BOAT 2.30m 200g 4SEG

168-21-123
Livrare imediată!

129,00Lei

Lanseta Team Feeder By Dome Master 3.95m, 50-170g, 3+3seg

Lanseta Team Feeder By Dome Master 3.95m, 50-170g, 3+3seg

1870-392
Livrare imediată!

698,99Lei

Cap Suport Lanseta Prologic Negru S 3BUC/PLIC -40%
Exclusiv online!

Cap Suport Lanseta Prologic Negru S 3BUC/PLIC

a6.pro.72696
Livrare 24-48 ore

34,36Lei(-40%) 20,61Lei

Lanseta Avid Amplify Carp Spod 3.60m 5lbs 2seg -53%

Lanseta Avid Amplify Carp Spod 3.60m 5lbs 2seg

a0460026
Livrare imediată!

885,56Lei(-53%) 413,19Lei

Lanseta Browning Xenos Advance Feeder MH, 3.90m, 100g, 3+3buc -10%

Lanseta Browning Xenos Advance Feeder MH, 3.90m, 100g, 3+3buc

12218391
Livrare imediată!

854,78Lei(-10%) 769,30Lei

Lanseta Cormoran Cross Water Spoon T.2,05M/1-7G
Exclusiv online!

Lanseta Cormoran Cross Water Spoon T.2,05M/1-7G

c.27.4007205
Livrare 24-48 ore

186,90Lei

Combo Rapitor Mitchell Tanager Camo Lanseta Tanager Camo 2.10m 7-20g 2buc + Mulineta Tanager Camo 3000FD -10%

Combo Rapitor Mitchell Tanager Camo Lanseta Tanager Camo 2.10m 7-20g 2buc + Mulineta Tanager Camo 3000FD

1446408
Livrare imediată!

184,50Lei(-10%) 166,05Lei

Lanseta Okuma Tomcat Vertical 1.83m, 150g, 2seg
Exclusiv online!

Lanseta Okuma Tomcat Vertical 1.83m, 150g, 2seg

tmc-s-601mh
Livrare 48-72ore

368,10Lei

Lanseta Sunset Girelle ZXR 2.10m 60-120gr

Lanseta Sunset Girelle ZXR 2.10m 60-120gr

20311stsrj8149210-2
Livrare imediată!

139,48Lei

LANSETA DAIWA SEAHUNTER X PILK 2.40M 100-200G 2seg

LANSETA DAIWA SEAHUNTER X PILK 2.40M 100-200G 2seg

d.11534.245
Livrare imediată!

216,08Lei

Afişare 4681 - 4700 din 8575 (429 pagini)
Queries: 6, Total time: 251.046 ms [By time] [By id] [By file]
1 (0.205)
SELECT data
FROM `oc_session`
WHERE session_id = '675d801a5e68706369166538e7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (250.238)
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('+lanseta' 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.190)
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.125)
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.187)
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