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

Lingura Oscilanta Bertilure Lucky Redtail 73mm/10gr Silver

Lingura Oscilanta Bertilure Lucky Redtail 73mm/10gr Silver

l-01-512
Livrare imediată!

19,65Lei

Lingura Oscilanta Bertilure Lucky Redtail 73mm/10gr Gold

Lingura Oscilanta Bertilure Lucky Redtail 73mm/10gr Gold

l-01-511
Livrare imediată!

19,65Lei

Lingurita, Oscilanta, Misu, Argintata, Irlandeza, 13g, F3.osc.a.ir13, Linguri Oscilante, Linguri Oscilante Misu, Misu

Lingurita, Oscilanta, Misu, Argintata, Irlandeza, 13g, F3.osc.a.ir13, Linguri Oscilante, Linguri Oscilante Misu, Misu

f3.osc.a.ir13
Livrare imediată!

18,83Lei

Lingurita, Oscilanta, Dara, Killer, Bicolora, Dolinger, Mare, 13gr, 1403160301300, Linguri Oscilante, Linguri Oscilante Dara Killer, Dara Killer

Lingurita, Oscilanta, Dara, Killer, Bicolora, Dolinger, Mare, 13gr, 1403160301300, Linguri Oscilante, Linguri Oscilante Dara Killer, Dara Killer

1403160301300
Livrare imediată!

20,00Lei

Lingurita Oscilanta Dara Killer Argintata Siluro 10gr

Lingurita Oscilanta Dara Killer Argintata Siluro 10gr

1403200101000
Livrare imediată!

19,00Lei

Lingura Oscilanta Dara Killer Galbena Tac 3d 10gr -28%

Lingura Oscilanta Dara Killer Galbena Tac 3d 10gr

1402750201000
Livrare imediată!

16,51Lei(-28%) 11,90Lei

Lingura Jaxon Alga Fir 2d 16gr -30%
Exclusiv online!

Lingura Jaxon Alga Fir 2d 16gr

bw-jaf2d
Livrare 48-72 ore

12,40Lei(-30%) 8,70Lei

Lingurita Oscilanta Rublex Orkla Nr 3 (10gr L-67mm.) Argint+cap Rosu -18%

Lingurita Oscilanta Rublex Orkla Nr 3 (10gr L-67mm.) Argint+cap Rosu

orkla3atr
Livrare imediată!

23,00Lei(-18%) 18,90Lei

Lingurita Oscilanta Dara Killer Argintata Piscot 3d 10gr

Lingurita Oscilanta Dara Killer Argintata Piscot 3d 10gr

1402220101000
Livrare imediată!

19,00Lei

Lingurita Oscilanta Dara Killer Argintata Irlandeza 1anc 11gr

Lingurita Oscilanta Dara Killer Argintata Irlandeza 1anc 11gr

1402840101100
Livrare imediată!

20,50Lei

Lingurita Oscilanta Dara Killer Argintata Frunza Mare 16gr -22%

Lingurita Oscilanta Dara Killer Argintata Frunza Mare 16gr

1402990101600
Livrare imediată!

19,00Lei(-22%) 14,90Lei

Lingurita Oscilanta Dara Killer Galbena Irlandeza 1anc 13gr

Lingurita Oscilanta Dara Killer Galbena Irlandeza 1anc 13gr

1402840201300
Livrare imediată!

16,90Lei

Lingura, Jaxon, Alga, Classic, 3c, 32gr, , Bw-jan3c, Linguri Oscilante, Linguri Oscilante Jaxon, Jaxon
Exclusiv online!

Lingura, Jaxon, Alga, Classic, 3c, 32gr, , Bw-jan3c, Linguri Oscilante, Linguri Oscilante Jaxon, Jaxon

bw-jan3c
Livrare 48-72 ore

18,00Lei

Lingurita, Oscilanta, Misu, Argintata, Dolinger, , 10g, F3.osc.a.do10, Linguri Oscilante, Linguri Oscilante Misu, Misu

Lingurita, Oscilanta, Misu, Argintata, Dolinger, , 10g, F3.osc.a.do10, Linguri Oscilante, Linguri Oscilante Misu, Misu

f3.osc.a.do10
Livrare imediată!

16,08Lei

Lingura Jaxon Alga Classic 3g 32gr
Exclusiv online!

Lingura Jaxon Alga Classic 3g 32gr

bw-jan3g
Livrare 48-72 ore

18,00Lei

Lingura, Rapala, Rattlin, Minnow, Spoon, 8cm, , 16gr, Flp, , Rmsr08 Flp, Lingurite Oscilante, Lingurite Oscilante Rapala, Rapala

Lingura, Rapala, Rattlin, Minnow, Spoon, 8cm, , 16gr, Flp, , Rmsr08 Flp, Lingurite Oscilante, Lingurite Oscilante Rapala, Rapala

rmsr08 flp
Livrare imediată!

45,01Lei

Lingura Oscilanta Rublex Eira Nr2 17g/55mm Otr -29%

Lingura Oscilanta Rublex Eira Nr2 17g/55mm Otr

rei2otr
Livrare imediată!

49,00Lei(-29%) 34,90Lei

Lingurita Oscilanta Dara Killer Delta Argintata 19gr

Lingurita Oscilanta Dara Killer Delta Argintata 19gr

1402880101900
Livrare imediată!

19,00Lei

Lingurita Oscilanta Dara Killer Argintata Siluro Cu Solzi 13gr

Lingurita Oscilanta Dara Killer Argintata Siluro Cu Solzi 13gr

1403200101307
Livrare imediată!

19,00Lei

Lingurita, Oscilanta, Colmic, Dribble, Spoon, 6gr, Gold, Arhkir05, Linguri Oscilante, Linguri Oscilante Colmic, Colmic -35%
Exclusiv online!

Lingurita, Oscilanta, Colmic, Dribble, Spoon, 6gr, Gold, Arhkir05, Linguri Oscilante, Linguri Oscilante Colmic, Colmic

arhkir05
Livrare 48-72 ore

18,00Lei(-35%) 11,70Lei

Afişare 341 - 360 din 2144 (108 pagini)

Una dintre cele mai de succes naluci pentru pescuitul la stiuca este reprezentata de linguri oscilante.Acestea au diferite forme si gramaje de la clasicele Dara Kiler la noile modele Ares.Cele mai uzuale lingurite oscilante sunt cele de la urmatorii producatori:

Lingurite oscilante de la Berti, Lingurite oscilante de la Misu, Lingurite oscilante de la Mepps,  Lingurite oscilante de la Profi Blinker ,   Lingurite oscilante de la Rapala,  Lingurite oscilante de la Rublex,  Lingurite oscilante de la  Strike Pro,  Lingurite oscilante de la  Zebco, Lingurite oscilante de la DAM

Queries: 17, Total time: 136.060 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '942df1c8d6d5e2efdccc8ddecd'
/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.136)
SELECT *
FROM oc_url_alias
WHERE keyword = 'pescuit-la-rapitor'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'naluci-artificiale'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.071)
SELECT *
FROM oc_url_alias
WHERE keyword = 'lingurite-oscilante'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
6 (0.407)
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 = '233' 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
7 (32.838)
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 = '233' 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
8 (0.311)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
9 (7.691)
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 340, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
10 (69.150)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN `oc_bf_tmp_product` AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND match_filters = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, CAST(av.value AS UNSIGNED), av.value
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1102
11 (1.368)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1209
12 (0.147)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1231
13 (0.419)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:996
14 (22.695)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
15 (0.199)
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 '%"233"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
16 (0.169)
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 '%"233"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
17 (0.120)
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