Pentru o livrare cat mai rapida va recomandam sa alegeti produse cu stoc in Magazin fizic si in Depozit Online. Produsele cu Stoc furnizor au termen de livrare mai mare si pot intarzia comanda dvs.
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

Filtreaza

Lanseta Zebco Z-cast Spin 3-15g 2,00m

Lanseta Zebco Z-cast Spin 3-15g 2,00m

14600200
Stoc epuizat

206,77Lei

Lanseta Okuma Helios Air H, 30-70g , 2.43m, 2seg

Lanseta Okuma Helios Air H, 30-70g , 2.43m, 2seg

hsa-s-802h
Stoc epuizat

749,00Lei

Lanseta Cormoran Power Creek Spin 1.80m 3-14g 2seg

Lanseta Cormoran Power Creek Spin 1.80m 3-14g 2seg

c.27.8514180
Stoc epuizat

132,67Lei

Lanseta Rapture Aerial Bottom 1.98m 0.1-4g

Lanseta Rapture Aerial Bottom 1.98m 0.1-4g

126-50-900
Stoc epuizat

549,99Lei

Lanseta Daiwa Morethan Shad Attack 2.40m 8-35g 2seg -32%

Lanseta Daiwa Morethan Shad Attack 2.40m 8-35g 2seg

d.11115.245
Stoc epuizat

1.963,81Lei(-32%) 1.341,70Lei

Lanseta Daiwa Team Daiwa 672mlxfs 2.01m 5-14g

Lanseta Daiwa Team Daiwa 672mlxfs 2.01m 5-14g

d.td672mlxfsbf
Stoc epuizat

341,07Lei

Lanseta Okuma Pch Air Spin 2.20m 1-9g 2seg

Lanseta Okuma Pch Air Spin 2.20m 1-9g 2seg

o.okr.pchas742ul
Stoc epuizat

319,60Lei

Lanseta Spinning Daiwa Tournament Ags 702mhfs 2.13m 7-28g 2seg

Lanseta Spinning Daiwa Tournament Ags 702mhfs 2.13m 7-28g 2seg

d.tnags702mhfscf
Stoc epuizat

2.068,40Lei

Lanseta Okuma Pch Air Spin 2.12m 1-9g 2seg

Lanseta Okuma Pch Air Spin 2.12m 1-9g 2seg

o.okr.pchas702ul
Stoc epuizat

233,28Lei

Lanseta Graphiteleader Finezza 19 Glfs-7112ml-t R-fast 2.41m 1-10gr

Lanseta Graphiteleader Finezza 19 Glfs-7112ml-t R-fast 2.41m 1-10gr

g08726
Stoc epuizat

1.930,00Lei

Lanseta Cormoran I-cor One Uf Spin 2,40m/10-40g/2seg

Lanseta Cormoran I-cor One Uf Spin 2,40m/10-40g/2seg

c.24.040245
Stoc epuizat

97,94Lei

Lanseta Lucky John Vanrex Baitcast 662lf 1.98m 5-21g 2seg -5%

Lanseta Lucky John Vanrex Baitcast 662lf 1.98m 5-21g 2seg

ljvb-662mlf
Stoc epuizat

220,00Lei(-5%) 210,00Lei

Lanseta Daiwa Crossfire Spin 2.70m 10-30g 2seg

Lanseta Daiwa Crossfire Spin 2.70m 10-30g 2seg

d.11428.275
Stoc epuizat

179,00Lei

Lanseta Lucky John Vanrex Jig 21 2.44m 5-21g 2seg -3%

Lanseta Lucky John Vanrex Jig 21 2.44m 5-21g 2seg

ljvj-802mlf
Stoc epuizat

190,00Lei(-3%) 185,00Lei

Lanseta Telescopica Daiwa Ninja X 2.40m 10-30g

Lanseta Telescopica Daiwa Ninja X 2.40m 10-30g

d.11636.240
Stoc epuizat

338,53Lei

Lanseta Lucky John Vanrex Twitching 28 1.98m 7-28g 2seg

Lanseta Lucky John Vanrex Twitching 28 1.98m 7-28g 2seg

ljvt-662mef
Stoc epuizat

200,00Lei

Lanseta Daiwa Ballistic X Jigger Spin 2.70m 7-28g 2seg

Lanseta Daiwa Ballistic X Jigger Spin 2.70m 7-28g 2seg

d.11511.270
Stoc epuizat

317,74Lei

Lanseta Savage Gear Sg4 Power Game 2.59m 50-110g 2seg

Lanseta Savage Gear Sg4 Power Game 2.59m 50-110g 2seg

o.sg.72213
Stoc epuizat

600,89Lei

Lanseta Sportex Styx B2 240 20gr -33%

Lanseta Sportex Styx B2 240 20gr

xb2400
Stoc epuizat

1.738,99Lei(-33%) 1.169,00Lei

Lanseta Savage Gear Sg4 Power Game 2.21m 30-70g 2seg

Lanseta Savage Gear Sg4 Power Game 2.21m 30-70g 2seg

o.sg.72210
Stoc epuizat

466,06Lei

Afişare 2961 - 2980 din 3150 (158 pagini)

In aceasta categorie veti gasi lansete speciale de spinning  pentru pescuitul pestilor rapitori .Fie ca sunteti incepator sau avansat in acest stil de pescuit cu siguranta veti gasi lanseta de care aveti nevoie fie ca este vorba de o lanseta spinning, de pescuit la stiuca sau salau sau de ce nu o lanseta spinning pentru clean sau biban,light medium sau heavy.Cele mai uzuale lansete spinning de rapitori au intre 1.80m si 2.70 m iar ca si putere de aruncare intre 1 si 35 gr

Printre producatorii de lansete de rapitori reamintin:

Lansete spinning pentru rapitori de la Daiwa,  Lansete spinning pentru rapitori de la Shimano, Lansete spinning pentru rapitori de la Major Craft,  Lansete spinning pentru rapitori de la Lamiglass,  Lansete spinning pentru rapitori de la Okuma,  Lansete spinning pentru rapitori de la Sakura, Lansete spinning pentru rapitori de la  Sportex, Lansete spinning pentru rapitori de la Spro

Queries: 15, Total time: 213.701 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '6bb1df7bab4cdb6c315bb5844e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'lansete-rapitori'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.402)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '226' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
5 (189.979)
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_to_category` AS p2c ON (p.product_id = p2c.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 p2c.category_id = '226' 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
6 (21.647)
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 DESC LIMIT 2960, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.139)
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
8 (0.111)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.103)
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
10 (0.100)
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
11 (0.107)
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
12 (0.099)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
13 (0.341)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"226"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
14 (0.203)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"226"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
15 (0.116)
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