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 300 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 Fox Rage Warrior Medium Spin, 240cm, 15-40gr

Lanseta Fox Rage Warrior Medium Spin, 240cm, 15-40gr

nrd346
Livrare imediată!

292,45Lei

Lanseta spinning EnergoTeam BOKOR PRO SPIN 2.40m 10-30/15-40g 1Seg Plus 2 tronsoane

Lanseta spinning EnergoTeam BOKOR PRO SPIN 2.40m 10-30/15-40g 1Seg Plus 2 tronsoane

13175240
Livrare imediată!

286,00Lei

Lanseta Cormoran Cross Water Spinning 2.70M 15-40g 2SEG -20%
Exclusiv online!

Lanseta Cormoran Cross Water Spinning 2.70M 15-40g 2SEG

c.27.4040270
Livrare 24-48 ore

273,24Lei(-20%) 218,58Lei

Lanseta Cormoran Cross Water Spinning 2.40M 15-40g 2SEG -30%
Exclusiv online!

Lanseta Cormoran Cross Water Spinning 2.40M 15-40g 2SEG

c.27.4040240
Livrare 24-48 ore

243,56Lei(-30%) 170,49Lei

Lanseta feeder Team Feeder by Dome Gold Series 3.30m 15-40g 3+3SEG
Exclusiv online!

Lanseta feeder Team Feeder by Dome Gold Series 3.30m 15-40g 3+3SEG

1861-330
Livrare 48-72 ore

1.037,00Lei

Lanseta Berkley Cherrywood Original 2.40m 15-40g -28%

Lanseta Berkley Cherrywood Original 2.40m 15-40g

1531538
Livrare imediată!

191,20Lei(-28%) 138,00Lei

Lanseta Spro Ridge Classix Spin 2.40m/15-40g

Lanseta Spro Ridge Classix Spin 2.40m/15-40g

002870-00243-00000
Livrare imediată!

280,99Lei

Lanseta Spro Ridge Classix Spin 2.10m/15-40g

Lanseta Spro Ridge Classix Spin 2.10m/15-40g

002870-00213-00000
Livrare imediată!

250,00Lei

LANSETA SPINNING OKUMA ALTERA SPIN 2.13m 15-40g

LANSETA SPINNING OKUMA ALTERA SPIN 2.13m 15-40g

alt-s-702mh
Livrare imediată!

224,10Lei

LANSETA SPINNING OKUMA ALTERA SPIN 2.74m 15-40g 2buc
Exclusiv online!

LANSETA SPINNING OKUMA ALTERA SPIN 2.74m 15-40g 2buc

alt-s-902m
Livrare 48-72ore

269,09Lei

Lanseta OKUMA Fuel Spin 244cm 15-40g -23%

Lanseta OKUMA Fuel Spin 244cm 15-40g

fsp-s-802m
Livrare imediată!

159,00Lei(-23%) 122,90Lei

Lanseta DAM Quadra Safar II Spin 2.40m 15-40g
Exclusiv online!

Lanseta DAM Quadra Safar II Spin 2.40m 15-40g

2040970288
Livrare 48-72 ore

277,01Lei

LANSETA SPINNING OKUMA ARIA SPIN 2.44m 15-40g 2buc
Exclusiv online!

LANSETA SPINNING OKUMA ARIA SPIN 2.44m 15-40g 2buc

ara-802m
Livrare 48-72ore

179,10Lei

Combo Spinning Abu Garcia Pro Max Spinning MH, 15-40g, 2.28m, 2seg

Combo Spinning Abu Garcia Pro Max Spinning MH, 15-40g, 2.28m, 2seg

1531506
Livrare imediată!

494,96Lei

Combo Spinning Abu Garcia Pro Max Spinning MH, 15-40g, 2.74m, 2seg
Exclusiv online!

Combo Spinning Abu Garcia Pro Max Spinning MH, 15-40g, 2.74m, 2seg

1531509
Livrare 7-14 zile

539,96Lei

Lanseta Abu Garcia Vendetta V3 Casting Rod MH, 15-40g, 2.74m, 2seg
Exclusiv online!

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

1544529
Livrare 7-14 zile

472,46Lei

Lanseta Abu Garcia Vendetta V3 Spinning Rod 902MH, 15-40g, 2.74m, 2seg
Exclusiv online!

Lanseta Abu Garcia Vendetta V3 Spinning Rod 902MH, 15-40g, 2.74m, 2seg

1544433
Livrare 7-14 zile

404,96Lei

Lanseta Abu Garcia Venerate Spinning EVA Rod MH, 15-40g, 2.44m, 2seg
Exclusiv online!

Lanseta Abu Garcia Venerate Spinning EVA Rod MH, 15-40g, 2.44m, 2seg

1539828
Livrare 7-14 zile

293,21Lei

Combo Abu Garcia Max X Red Spinning 902MH, 15-40g, 2.74m, 2seg
Exclusiv online!

Combo Abu Garcia Max X Red Spinning 902MH, 15-40g, 2.74m, 2seg

1531496
Livrare 7-14 zile

494,96Lei

Lanseta Abu Garcia SOLV AG3 Spinning Rod AG3 MH, 15-40g, 3.00m, 2seg
Exclusiv online!

Lanseta Abu Garcia SOLV AG3 Spinning Rod AG3 MH, 15-40g, 3.00m, 2seg

1539121
Livrare 7-14 zile

832,46Lei

Afişare 1 - 20 din 88 (5 pagini)
Queries: 9, Total time: 198.587 ms [By time] [By id] [By file]
1 (0.148)
SELECT data
FROM `oc_session`
WHERE session_id = 'd5b0db0171b99581e6f2cf5cd2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (197.627)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%15-40g%") 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:698
5 (0.147)
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.124)
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.114)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.117)
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