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

Minciog Nevis Predator 1.35m 50x45cm

Minciog Nevis Predator 1.35m 50x45cm

4263-135
Livrare imediată!

134,01Lei

Minciog Telescopic Carp Expert Original Strong 2.40m
Exclusiv online!

Minciog Telescopic Carp Expert Original Strong 2.40m

71048241
Livrare 24-48 ore

87,00Lei

Minciog Savage Gear Full Frame Oval Landing Net, 2 Tronsoane, 99-150cm, 55x47x53cm

Minciog Savage Gear Full Frame Oval Landing Net, 2 Tronsoane, 99-150cm, 55x47x53cm

svs57578
Livrare imediată!

225,01Lei

Minciog Nevis Predator 2.10m 65x50cm

Minciog Nevis Predator 2.10m 65x50cm

4263-130
Livrare imediată!

146,00Lei

Minciog Prologic C3 Fulcrum Net Float Camo 1.80m 2seg

Minciog Prologic C3 Fulcrum Net Float Camo 1.80m 2seg

a2.pro.72671
Livrare imediată!

610,70Lei

Minciog Carp Zoom Zeta Cauciucat 70x70x250cm 2 Sectiun
Exclusiv online!

Minciog Carp Zoom Zeta Cauciucat 70x70x250cm 2 Sectiun

cz3450
Livrare 48-72 ore

180,00Lei

Minciog Prologic C2 Element Fs Olive Green 1.80m 2seg

Minciog Prologic C2 Element Fs Olive Green 1.80m 2seg

a2.pro.64998
Livrare imediată!

398,22Lei

Minciog Carp Expert Holiday 50x50cm 1.80m

Minciog Carp Expert Holiday 50x50cm 1.80m

71018980
Livrare imediată!

61,00Lei

Minciog Nevis Telescopic 2.10m 60x55cm
Exclusiv online!

Minciog Nevis Telescopic 2.10m 60x55cm

4245-210
Livrare 48-72 ore

146,00Lei

Minciog Carp Avademy Strong Carp 2.80m
Exclusiv online!

Minciog Carp Avademy Strong Carp 2.80m

4101-280
Livrare 48-72 ore

131,50Lei

Minciog Ron Thompson Manitoba Click N Slide 50x75cm -30%
Exclusiv online!

Minciog Ron Thompson Manitoba Click N Slide 50x75cm

a2.tho.65469
Livrare 24-48 ore

138,69Lei(-30%) 97,09Lei

Minciog Prologic C3 Ridgid Framed Camo Rubber 1seg 120cm -22%

Minciog Prologic C3 Ridgid Framed Camo Rubber 1seg 120cm

a2.pro.64999
Livrare imediată!

385,20Lei(-22%) 299,00Lei

Minciog Lineaeffe Telescopic Cap Rotund 2.60m 60cm -30%
Exclusiv online!

Minciog Lineaeffe Telescopic Cap Rotund 2.60m 60cm

a2.m6101655
Livrare 24-48 ore

122,53Lei(-30%) 85,78Lei

Minciog Prologic Commander 180m 2seg -20%

Minciog Prologic Commander 180m 2seg

a2.pro.70845
Livrare imediată!

215,74Lei(-20%) 172,59Lei

Minciog Daiwa Prorex 55x45cm
Exclusiv online!

Minciog Daiwa Prorex 55x45cm

a2.m15809.745
Livrare 24-48 ore

341,21Lei

Minciog Carp Spirit Blax X-net 42" 105cm 1.82m -29%
Exclusiv online!

Minciog Carp Spirit Blax X-net 42" 105cm 1.82m

acs490078
Livrare 48-72 ore

249,00Lei(-29%) 177,00Lei

Minciog Telescopic Sert Promo, 2.50m, 60x60cm
Exclusiv online!

Minciog Telescopic Sert Promo, 2.50m, 60x60cm

50101epst0260252
Livrare 48-72 ore

72,77Lei

Minciog Aluminiu Carp Zoom Alpha Eco 2 Sectiuni, 50x50x180cm
Exclusiv online!

Minciog Aluminiu Carp Zoom Alpha Eco 2 Sectiuni, 50x50x180cm

cz0298
Livrare 48-72 ore

71,00Lei

Minciog Telescopic Sert Promo, 2.00m, 50x50cm
Exclusiv online!

Minciog Telescopic Sert Promo, 2.00m, 50x50cm

50101epst0250202
Livrare 48-72 ore

61,56Lei

Minciog Nash X Series Landing Net 186cm

Minciog Nash X Series Landing Net 186cm

t1656
Livrare imediată!

360,00Lei

Afişare 121 - 140 din 245 (13 pagini)

Alege din gama de mincioguri complete feeder, ideale pentru pescuitul la crap, caras sau alte specii pașnice.
Aceste mincioguri feeder gata de utilizare includ cap și coadă, fiind soluția practică pentru orice pescar.
Modelele cu plasă cauciucată protejează peștele și se usucă rapid după utilizare.
Optează pentru mincioguri feeder telescopice, ușor de transportat și depozitat.
Găsești variante cu cozi din carbon și mâner ergonomic pentru manevrare confortabilă.
Minciogurile feeder cu filet universal sunt compatibile cu diverse accesorii.
Disponibile în versiuni cu 2 sau 3 tronsoane, pentru adaptabilitate maximă.
Potrivite atât pentru pescuit staționar, cât și pentru pescuit de competiție.
Construcția ușoară și rezistentă asigură durabilitate și eficiență în timp.
Alege mincioguri complete feeder pentru performanță și fiabilitate la fiecare partidă.

Queries: 16, Total time: 14.966 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '13aa137b46b522710bfd6d9ba7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'mincioguri-complete-feeder'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.388)
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 = '463' 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
5 (4.411)
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 = '463' 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
6 (0.122)
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
7 (1.160)
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 120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (0.105)
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
9 (5.247)
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 (0.387)
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.083)
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.125)
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 (2.318)
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.139)
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 '%"463"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
15 (0.129)
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 '%"463"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
16 (0.095)
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