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

Crank Sakura Scb Micro 39mm 4.10gr M06 Mat Tiger
Exclusiv online!

Crank Sakura Scb Micro 39mm 4.10gr M06 Mat Tiger

131234saplg501539-m06
Livrare 48-72 ore

48,18Lei

Crank, Sakura, Scb, 100, F, 53mm, 10.70gr, Rl05, Real, Life, Gardon, 131234saple500353-rl05, Voblere Suspending, Voblere Suspending Sakura, Sakura
Exclusiv online!

Crank, Sakura, Scb, 100, F, 53mm, 10.70gr, Rl05, Real, Life, Gardon, 131234saple500353-rl05, Voblere Suspending, Voblere Suspending Sakura, Sakura

131234saple500353-rl05
Livrare 48-72 ore

49,83Lei

Crank, Sakura, Scb, 100, F, 53mm, 10.70gr, Rl10, Real, Life, Sunfish, 131234saple500353-rl10, Voblere Suspending, Voblere Suspending Sakura, Sakura
Exclusiv online!

Crank, Sakura, Scb, 100, F, 53mm, 10.70gr, Rl10, Real, Life, Sunfish, 131234saple500353-rl10, Voblere Suspending, Voblere Suspending Sakura, Sakura

131234saple500353-rl10
Livrare 48-72 ore

49,83Lei

Crank, Sakura, Scb, 100, F, 53mm, 10.70gr, Ssp, Alburno, Spain, Special, 131234saple500353-ssp, Voblere Suspending, Voblere Suspending Sakura, Sakura
Exclusiv online!

Crank, Sakura, Scb, 100, F, 53mm, 10.70gr, Ssp, Alburno, Spain, Special, 131234saple500353-ssp, Voblere Suspending, Voblere Suspending Sakura, Sakura

131234saple500353-ssp
Livrare 48-72 ore

49,83Lei

Crank Sakura Scb 100 F 53mm 10.70gr M06 Mat Tiger
Exclusiv online!

Crank Sakura Scb 100 F 53mm 10.70gr M06 Mat Tiger

131234saple500353-m06
Livrare 48-72 ore

49,83Lei

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6gr Rl07 Real Life Vairon
Exclusiv online!

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6gr Rl07 Real Life Vairon

80434saplc505540-rl07
Livrare 48-72 ore

48,18Lei

Crank Sakura Scb Micro 39mm 4.10gr Ssp Spain Special
Exclusiv online!

Crank Sakura Scb Micro 39mm 4.10gr Ssp Spain Special

131234saplg501539-ssp
Livrare 48-72 ore

46,52Lei

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6gr T02 Hi Viz Chart Trout
Exclusiv online!

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6gr T02 Hi Viz Chart Trout

80434saplc505540-t02
Livrare 48-72 ore

48,18Lei

Crank Sakura Scb 100 F 53mm 10.70gr A06 Aurora Minnow
Exclusiv online!

Crank Sakura Scb 100 F 53mm 10.70gr A06 Aurora Minnow

131234saple500353-a06
Livrare 48-72 ore

49,83Lei

Crank, Sakura, Scb, Micro, 39mm, 4.10gr, P06, Pearl, White, 131234saplg501539-p06, Voblere Suspending, Voblere Suspending Sakura, Sakura

Crank, Sakura, Scb, Micro, 39mm, 4.10gr, P06, Pearl, White, 131234saplg501539-p06, Voblere Suspending, Voblere Suspending Sakura, Sakura

131234saplg501539-p06
Livrare imediată!

43,46Lei

Crank Sakura Scb Micro 39mm 4.10gr 016 Bronze Perch

Crank Sakura Scb Micro 39mm 4.10gr 016 Bronze Perch

131234saplg501539-016
Livrare imediată!

48,18Lei

Vobler Sakura Chopsy Minnow 50 Sp 50mm 4.50gr Rl07 Real Life Vairon
Exclusiv online!

Vobler Sakura Chopsy Minnow 50 Sp 50mm 4.50gr Rl07 Real Life Vairon

130234saplh500950-rl07
Livrare 48-72 ore

52,00Lei

Vobler Sakura Chopsy Minnow 50 Sp 50mm 4.50gr T07 Ghost Natural Trout
Exclusiv online!

Vobler Sakura Chopsy Minnow 50 Sp 50mm 4.50gr T07 Ghost Natural Trout

130234saplh500950-t07
Livrare 48-72 ore

52,00Lei

Vobler Sakura Chopsy Minnow 50 Sp 50mm 4.50gr T12 Iwana Trout
Exclusiv online!

Vobler Sakura Chopsy Minnow 50 Sp 50mm 4.50gr T12 Iwana Trout

130234saplh500950-t12
Livrare 48-72 ore

52,00Lei

Vobler Sakura Chopsy Minnow 50 Sp 50mm 4.50gr T05 Natural Trout
Exclusiv online!

Vobler Sakura Chopsy Minnow 50 Sp 50mm 4.50gr T05 Natural Trout

130234saplh500950-t05
Livrare 48-72 ore

52,00Lei

Vobler Sakura Chopsy Minnow 50 Sp 50mm 4.50gr T01 Golden Trout
Exclusiv online!

Vobler Sakura Chopsy Minnow 50 Sp 50mm 4.50gr T01 Golden Trout

130234saplh500950-t01
Livrare 48-72 ore

52,00Lei

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6 G T08 Black Fury Trout
Exclusiv online!

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6 G T08 Black Fury Trout

80434saplc505540-t08
Livrare 48-72 ore

48,18Lei

Vobler Sakura Swimy Bug Crank C2026 2.8cm 2.00gr
Exclusiv online!

Vobler Sakura Swimy Bug Crank C2026 2.8cm 2.00gr

130235swplg500528-c2026
Livrare 48-72 ore

29,95Lei

Vobler Sakura Swimy Bug Crank C2025 2.8cm 2.00gr -24%

Vobler Sakura Swimy Bug Crank C2025 2.8cm 2.00gr

130235swplg500528-c2025
Livrare imediată!

29,95Lei(-24%) 22,90Lei

Vobler Sakura Swimy Bug Crank C2027 2.8cm 2.00gr
Exclusiv online!

Vobler Sakura Swimy Bug Crank C2027 2.8cm 2.00gr

130235swplg500528-c2027
Livrare 48-72 ore

29,95Lei

Afişare 1 - 20 din 30 (2 pagini)

Una dintre cele mai de succes naluci de spinning pentru pescuitul rapitorilor este Voblerul acesta este de obicei confectionat din lemn de balsa sau chiar si materiale compozite si plastic.Voblerele au intre 1 si 3 ancore si o marime ce pleaca de la 2 cm si se poate opri la cateva zeci de cm in functie de pestele vizat.Cele mai folosite voblere in pescuitul salaului de exemplu sunt cele de la:Strike Pro,Daiwa,Rapala, etc

Queries: 16, Total time: 8.783 ms [By time] [By id] [By file]
1 (0.071)
SELECT data
FROM `oc_session`
WHERE session_id = '8732f87d20ca13ca58ebf9026d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.142)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sakura'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.414)
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 = '414' 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 (4.358)
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, if (SUM(if((f.filter_group = "m0" AND filter_id IN (123)), 1, 0)) > 0, 1, 0) 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 = '414' AND p.manufacturer_id = '123' 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 (0.080)
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
7 (0.292)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (1.773)
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
9 (0.189)
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
10 (0.123)
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
11 (0.106)
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
12 (0.518)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
13 (0.146)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS tp
INNER JOIN `oc_bf_filter` AS f ON (f.product_id = tp.product_id)
WHERE f.language_id = '2' AND tp.match_filters < 1 AND f.filter_group IN ('m0') GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:950
14 (0.190)
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 '%"414"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
15 (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 '%"414"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
16 (0.123)
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