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

Căutare - Mulinete Crap

Produse ce potrivesc criteriilor de căutare


VARGA LINEAEFFE ARTISTIC POLE 5.00M 25G
Exclusiv online!

VARGA LINEAEFFE ARTISTIC POLE 5.00M 25G

l.2517705
Livrare 24-48 ore

262,37Lei

MULINETA LINEAEFE ALL BLACK 6000

MULINETA LINEAEFE ALL BLACK 6000

l.1209160
Livrare imediată!

123,39Lei

Spuma flotanta Lineaeffe EVA Foam Bait 0.8/1cm

Spuma flotanta Lineaeffe EVA Foam Bait 0.8/1cm

a.4945015
Livrare imediată!

14,61Lei

LANSETA LINEAEFFE COMBO 2BUC EXTREME SPINNING 1,80M+MUL.S 20
Exclusiv online!

LANSETA LINEAEFFE COMBO 2BUC EXTREME SPINNING 1,80M+MUL.S 20

l.2015370
Livrare 24-48 ore

130,61Lei

MULINETA, LINEAEFFE, TS, HEAVY, SPECIMEN, 5000, l.1285250, Mulinete Crap, Mulinete Crap Lineaeffe, Mulinete Feeder, Mulinete Feeder Lineaeffe, Lineaeffe -20%
Exclusiv online!

MULINETA, LINEAEFFE, TS, HEAVY, SPECIMEN, 5000, l.1285250, Mulinete Crap, Mulinete Crap Lineaeffe, Mulinete Feeder, Mulinete Feeder Lineaeffe, Lineaeffe

l.1285250
Livrare 24-48 ore

227,21Lei(-20%) 181,77Lei

Mulineta Lineaeffe Nomura Hiro Alu 3000
Exclusiv online!

Mulineta Lineaeffe Nomura Hiro Alu 3000

nm.10311130
Livrare 24-48 ore

293,26Lei

MINCIOG LINEAEFFE SPECIMEN CARP 1,80M/100X100CM -40%

MINCIOG LINEAEFFE SPECIMEN CARP 1,80M/100X100CM

a2.m6101870
Livrare imediată!

183,14Lei(-40%) 109,88Lei

FIR LINEAEFFE FLUOROCARBON AKASHI 020MM/8KG/50M

FIR LINEAEFFE FLUOROCARBON AKASHI 020MM/8KG/50M

l.3042120
Livrare imediată!

18,35Lei

Lanseta Lineaeffe Tele GMX 4.20m, 200g

Lanseta Lineaeffe Tele GMX 4.20m, 200g

l.2283444
Livrare imediată!

281,68Lei

TAPARINA LINEAEFE PANA ALBA CARLIG NR 2 5 BUCATI

TAPARINA LINEAEFE PANA ALBA CARLIG NR 2 5 BUCATI

a.5642402
Livrare imediată!

9,56Lei

CROSETA NEAGRA /GRI BOILIES LINEAEFFE

CROSETA NEAGRA /GRI BOILIES LINEAEFFE

a.4990221
Livrare imediată!

11,25Lei

JUVELNIC LINEAEFFE PLASA D=35CM/L=1,20M
Exclusiv online!

JUVELNIC LINEAEFFE PLASA D=35CM/L=1,20M

a2.j6201435
Livrare 24-48 ore

34,96Lei

Fir, monofilament, Lineaeffe, Carp, Top, Smoke, Green, 0.30MM/7.9KG, 800M, l.3001410, Fire Monofilament Crap, Fire Monofilament Crap Lineaeffe, Lineaeffe
FIR LINEAEFFE BASS TOP GALBEN 0,22MM/5,0KG 1200M

FIR LINEAEFFE BASS TOP GALBEN 0,22MM/5,0KG 1200M

l.3001206
Livrare imediată!

20,83Lei

TAPARINA LINEAEFE RAIMBOW NR 4 10 BUCATI

TAPARINA LINEAEFE RAIMBOW NR 4 10 BUCATI

a.5640304
Livrare imediată!

11,80Lei

COMBO LINEAEFFE LANSETA EXTREME SNAKE HEAD 2.40M MULINETA S20
Exclusiv online!

COMBO LINEAEFFE LANSETA EXTREME SNAKE HEAD 2.40M MULINETA S20

l.2015382
Livrare 24-48 ore

107,81Lei

VARTEJ, CU, RULMENT, LINEAEFFE, NR.5/5BUC/PL., a7.8001205b, Vartejuri, Vartejuri Lineaeffe, Vartejuri Lineaeffe, Lineaeffe
Exclusiv online!

VARTEJ, CU, RULMENT, LINEAEFFE, NR.5/5BUC/PL., a7.8001205b, Vartejuri, Vartejuri Lineaeffe, Vartejuri Lineaeffe, Lineaeffe

a7.8001205b
Livrare 24-48 ore

23,45Lei

LANSETA, SPINNING, LINEAEFFE, NOMURA, 2SEG, HARU, DROPSHOT, 2.00M/3-15G, nm.20211520, Lansete Rapitori, Lansete Rapitori Lineaeffe, Lineaeffe
LANSETA BOLOGNESE LINEAEFFE STANDARD MASTER CARBON 5.00M 5-25G
Exclusiv online!

LANSETA BOLOGNESE LINEAEFFE STANDARD MASTER CARBON 5.00M 5-25G

l.2518215
Livrare 24-48 ore

146,11Lei

Suport, U, flexibil, Lineaeffe, fosforescent, a6.6313074, Capete Suport Spate, Capete Suport Spate Lineaeffe, Lineaeffe
Afişare 181 - 200 din 738 (37 pagini)
Queries: 10, Total time: 550.936 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = 'b931979d5c36d79db5623c2dfc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.122)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (361.456)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%lineaeffe%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (182.100)
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_description` AS pd ON (pd.product_id = p.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 = '0' AND (pd.tag LIKE "%lineaeffe%") 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:697
6 (0.250)
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:1066
7 (6.404)
SELECT COUNT(*) 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:911
8 (0.143)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.103)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.112)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38