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

Mulineta Delphin Chimera Nxt 6t 6000 -21%

Mulineta Delphin Chimera Nxt 6t 6000

101001220
Stoc epuizat

212,80Lei(-21%) 167,12Lei

Mulineta Okuma Pulzar 6000 -16%

Mulineta Okuma Pulzar 6000

pzb-6000
Stoc epuizat

319,00Lei(-16%) 266,56Lei

Mulineta Lineaeffe Vigor Xtm Free 4000 3rul/485mx040mm/5,2:1 -30%

Mulineta Lineaeffe Vigor Xtm Free 4000 3rul/485mx040mm/5,2:1

l.1289304
Stoc epuizat

105,98Lei(-30%) 74,18Lei

Mulineta Lineaeffe Vigor Carp New 6000 1rul/140mx045mm/5,2:1 -23%

Mulineta Lineaeffe Vigor Carp New 6000 1rul/140mx045mm/5,2:1

l.1287360
Stoc epuizat

72,44Lei(-23%) 55,73Lei

Mulineta Avid Carp Av8000 -27%

Mulineta Avid Carp Av8000

a0470003
Stoc epuizat

449,96Lei(-27%) 330,52Lei

Mulineta Nevis Monster Lcs 7000 3+1 Rulmenti -24%

Mulineta Nevis Monster Lcs 7000 3+1 Rulmenti

2527-470
Stoc epuizat

315,00Lei(-24%) 238,00Lei

Mulineta Lineaeffe Vigor Cache Fs 6000 4rul/240mx020mm/5,2:1 -23%

Mulineta Lineaeffe Vigor Cache Fs 6000 4rul/240mx020mm/5,2:1

l.1289460
Stoc epuizat

125,74Lei(-23%) 96,72Lei

Mulineta Okuma Pulzar 4000 -16%

Mulineta Okuma Pulzar 4000

pzb-4000
Stoc epuizat

299,00Lei(-16%) 249,90Lei

Mulineta Nash Dwarf Big Pit Compact 6500

Mulineta Nash Dwarf Big Pit Compact 6500

t4672
Stoc epuizat

375,99Lei

Mulineta Nash Dwarf Freespool Reel 6000

Mulineta Nash Dwarf Freespool Reel 6000

t4671
Stoc epuizat

345,99Lei

Mulineta Fox Xc Reel 14000 -34%

Mulineta Fox Xc Reel 14000

crl089
Stoc epuizat

1.169,96Lei(-34%) 769,94Lei

Mulineta Pescamania Cu Fir 4500 12 Rulmenti -40%

Mulineta Pescamania Cu Fir 4500 12 Rulmenti

y-c210d
Stoc epuizat

62,00Lei(-40%) 36,89Lei

Mulineta Nash Lr 10000 Fast Drag

Mulineta Nash Lr 10000 Fast Drag

t2053
Stoc epuizat

815,99Lei

Mulineta Nash Lr 8000 Fast Drag

Mulineta Nash Lr 8000 Fast Drag

t2052
Stoc epuizat

729,99Lei

Mulineta Lineaeffe Shizuka Sk14 5000, 2rul, 1gra+fir, 0.35mm/195m, 5.0:1 -23%

Mulineta Lineaeffe Shizuka Sk14 5000, 2rul, 1gra+fir, 0.35mm/195m, 5.0:1

l.s1001450
Stoc epuizat

75,66Lei(-23%) 58,20Lei

Mulineta Cormoran Veycor Br 4pif 6000 -23%

Mulineta Cormoran Veycor Br 4pif 6000

c.19.46600
Stoc epuizat

190,67Lei(-23%) 146,67Lei

Kit 4 Mulinete Prowess Nightfall Debrayable 8005 Hrs -42%

Kit 4 Mulinete Prowess Nightfall Debrayable 8005 Hrs

995020028
Stoc epuizat

1.784,29Lei(-42%) 1.042,02Lei

Mulineta Mitchell Avocast Fs Black Edition 8000 -23%

Mulineta Mitchell Avocast Fs Black Edition 8000

1446182
Stoc epuizat

467,46Lei(-23%) 359,18Lei

Mulineta Mitchell Avocast 8000 Black Edition -23%

Mulineta Mitchell Avocast 8000 Black Edition

1446181
Stoc epuizat

467,46Lei(-23%) 359,18Lei

Mulineta Mitchell Avocast Black Edition, 7000 -62%

Mulineta Mitchell Avocast Black Edition, 7000

1433016
Stoc epuizat

499,95Lei(-62%) 190,98Lei

Afişare 681 - 700 din 723 (37 pagini)

Una din cele mai importante componente ale echipamentului pescarului de crap este mulineta .Mulinetele sunt de mai multe tipuri iar alegerea mulinetei optime pentru tipul de pescuit pe care il practica pescarul este de multe ori dificila.De exemplu cea mai intalita greseala este alegerea gresita a mulinetei pentru nadit.De multe ori pescarul opteaza pentru o mulineta destinata pescuitului si nu naditului iar aceasta isi scurteaza dramatic viata.Pentru a evita astfel de greseli echipa Claumar Pescar va sta la dispozitie atat online cat si in magazinul fizic.

Printre producatorii de mulinete destinate pescuitului la crap putem enumera:

Mulinete crap de la Daiwa,Mulinete crap de la Okuma,Mulinete crap de la Shimano, Mulinete crap de la Lineaeffe,Mulinete crap de la Spro,Mulinete crap de la K-Karp,Mulinete crap de la DAM,Mulinete crap de la Delphin,Mulinete crap de la FL,Mulinete crap de la Jaxon,Mulinete crap de la Carp Zoom,Mulinete crap de la Strategy ,Mulinete crap de la Prowess etc

Queries: 18, Total time: 101.646 ms [By time] [By id] [By file]
1 (0.076)
SELECT data
FROM `oc_session`
WHERE session_id = '9779a9b4801cdabebaa9fef503'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'pescuit-la-crap'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.076)
SELECT *
FROM oc_url_alias
WHERE keyword = 'mulinete-crap-222'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.368)
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 = '222' AND cd.language_id = '2' AND c2s.store_id = '2' 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 (17.720)
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 = '2' AND p2c.category_id = '222' 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.219)
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 (3.356)
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 680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
9 (0.130)
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
10 (0.120)
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
11 (66.948)
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
12 (0.860)
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
13 (0.156)
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
14 (0.265)
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
15 (10.687)
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
16 (0.202)
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 '%"222"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
17 (0.189)
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 '%"222"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
18 (0.103)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37