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 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

Filtreaza

Lingurita Oscilanta Bertilure Taifun Nr.1 Culoare Gold Lungime 53 Mm. 5 Grame

Lingurita Oscilanta Bertilure Taifun Nr.1 Culoare Gold Lungime 53 Mm. 5 Grame

t-01-401
Livrare imediată!

14,30Lei

Lingurita Oscilanta Jaxon Hs Alga Tor 2ga 16gr
Exclusiv online!

Lingurita Oscilanta Jaxon Hs Alga Tor 2ga 16gr

bw-jar2ga
Livrare 48-72 ore

19,50Lei

Lingurita Oscilanta Misu Nichelata Eira 6g Mica
Exclusiv online!

Lingurita Oscilanta Misu Nichelata Eira 6g Mica

f3.osc.n.ei06
Livrare 24-48 ore

16,39Lei

Lingurita Oscilanta Jaxon Hr Atlas 1f 10gr
Exclusiv online!

Lingurita Oscilanta Jaxon Hr Atlas 1f 10gr

bw-hnx1f
Livrare 48-72 ore

7,00Lei

Lingura Oscilanta 6gr 32mm Dam Effzett Twin Silver-silver

Lingura Oscilanta 6gr 32mm Dam Effzett Twin Silver-silver

svs5018006
Livrare imediată!

17,01Lei

Lingura Jaxon Karas F 1e 16gr -20%

Lingura Jaxon Karas F 1e 16gr

bw-jkf1e
Livrare imediată!

12,50Lei(-20%) 10,00Lei

Lingurita Oscilanta Bertilure Tzack Nr.1 Culoare Gold Lungime 54 Mm. 6,5 Grame

Lingurita Oscilanta Bertilure Tzack Nr.1 Culoare Gold Lungime 54 Mm. 6,5 Grame

t-01-421
Livrare imediată!

14,30Lei

Lingura Jaxon Kola Raster 2hb 22gr
Exclusiv online!

Lingura Jaxon Kola Raster 2hb 22gr

bw-jlr2hb
Livrare 48-72 ore

19,00Lei

Lingurita Oscilanta Dara Killer Argintata Atom 9 Gr -22%

Lingurita Oscilanta Dara Killer Argintata Atom 9 Gr

1403100100900
Livrare imediată!

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

Lingura Jaxon Karas Micro 1gf 2gr
Exclusiv online!

Lingura Jaxon Karas Micro 1gf 2gr

bw-jki1gf
Livrare 48-72 ore

15,01Lei

Oscilanta Cormoran Cora-z 35mm/6g Gold/gold -40%
Exclusiv online!

Oscilanta Cormoran Cora-z 35mm/6g Gold/gold

f.50.860406
Livrare 24-48 ore

9,69Lei(-40%) 5,81Lei

Lingurita Oscilanta Rublex Orkla Nr.1, Ama, 5.6cm, 8g
Exclusiv online!

Lingurita Oscilanta Rublex Orkla Nr.1, Ama, 5.6cm, 8g

ror1ama
Livrare 48-72 ore

28,00Lei

Lingurita Oscilanta Rublex Eira Otr Nr.3 7.6cm 15g

Lingurita Oscilanta Rublex Eira Otr Nr.3 7.6cm 15g

rei3cotr
Livrare imediată!

56,00Lei

Lingurita Oscilanta Jaxon Hs Karas Micro 2cb 8gr
Exclusiv online!

Lingurita Oscilanta Jaxon Hs Karas Micro 2cb 8gr

bw-jki2cb
Livrare 48-72 ore

20,00Lei

Lingura Jaxon Ukla Micro 0s 6gr
Exclusiv online!

Lingura Jaxon Ukla Micro 0s 6gr

bw-jud0s
Livrare 48-72 ore

15,01Lei

Lingurita Oscilanta Bertilure Semiluna Nr.1 Lungime 61 Mm, Culoare Silver 8 Grame -27%

Lingurita Oscilanta Bertilure Semiluna Nr.1 Lungime 61 Mm, Culoare Silver 8 Grame

s-01-542
Livrare imediată!

17,01Lei(-27%) 12,50Lei

Lingurita Oscilanta Bertilure Banana Nr.4 Culoare Gold Lungime 80 Mm. 8.5 Gr.

Lingurita Oscilanta Bertilure Banana Nr.4 Culoare Gold Lungime 80 Mm. 8.5 Gr.

b-01-071
Livrare imediată!

17,85Lei

Lingurita Oscilanta Abu Garcia Atom Green Flash 7.5cm 20g
Exclusiv online!

Lingurita Oscilanta Abu Garcia Atom Green Flash 7.5cm 20g

1312813
Livrare 7-14 zile

28,00Lei

Lingurita Oscilanta Misu Nichelata Eira 8g Mica
Exclusiv online!

Lingurita Oscilanta Misu Nichelata Eira 8g Mica

f3.osc.n.ei08
Livrare 24-48 ore

16,39Lei

Lingura Oscilanta Colmic Herakles Sbam 1.3g Electric Orange
Exclusiv online!

Lingura Oscilanta Colmic Herakles Sbam 1.3g Electric Orange

arhksba41
Livrare 48-72 ore

21,00Lei

Afişare 1401 - 1420 din 2398 (120 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: 16, Total time: 256.665 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '4a10fb95a8cccde25664714ccf'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.118)
SELECT *
FROM oc_url_alias
WHERE keyword = 'naluci-artificiale'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'lingurite-oscilante'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.439)
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 = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
6 (67.817)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) ENGINE=InnoDB 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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' 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:857
7 (0.767)
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:1593
8 (16.542)
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 1400, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
9 (143.147)
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:1286
10 (1.573)
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:1393
11 (0.117)
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:1415
12 (0.630)
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:1180
13 (24.719)
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:1094
14 (0.205)
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
15 (0.173)
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
16 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37