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 Feeder

Produse ce potrivesc criteriilor de căutare


Fir textil Fanatik Feeder PE Braided Green 0.10mm 4.5kg 140m

Fir textil Fanatik Feeder PE Braided Green 0.10mm 4.5kg 140m

110813fpex414004g
Livrare imediată!

49,96Lei

Trabucco XP 3000 Grey Leam, 1Kg
Exclusiv online!

Trabucco XP 3000 Grey Leam, 1Kg

062-16-400
Livrare 48-72 ore

15,01Lei

Lanseta bolognesa Maver Easy 4m
Exclusiv online!

Lanseta bolognesa Maver Easy 4m

5764400
Livrare 48-72 ore

249,00Lei

Flotoare Avid Carp Bottle Marker Kit

Flotoare Avid Carp Bottle Marker Kit

a0640058
Livrare imediată!

94,46Lei

MANER MINCIOG TELESCOPIC TRABUCCO HYDRUS LANDING NET 4M

MANER MINCIOG TELESCOPIC TRABUCCO HYDRUS LANDING NET 4M

081-01-400
Livrare imediată!

255,01Lei

Momitor Benzar Inline Cage Feeder L 30g

Momitor Benzar Inline Cage Feeder L 30g

58400030
Livrare imediată!

11,00Lei

Fir textil Fanatik Feeder PE Braided Green 0.14mm 6.8kg 140m
Exclusiv online!

Fir textil Fanatik Feeder PE Braided Green 0.14mm 6.8kg 140m

110813fpex414008g
Livrare 48-72 ore

49,96Lei

, KITE, OPTICS, LUNETA, K6, HD, 2-12X50/IRA4I/30MM, vbo.k282400, Optica, Optica Kite Optics, Optica Kite Optics, Kite Optics
Exclusiv online!

, KITE, OPTICS, LUNETA, K6, HD, 2-12X50/IRA4I/30MM, vbo.k282400, Optica, Optica Kite Optics, Optica Kite Optics, Kite Optics

vbo.k282400
Livrare 24-48 ore

6.416,81Lei

Mulineta Daiwa Revros LT 4000

Mulineta Daiwa Revros LT 4000

d.10221.401
Livrare imediată!

410,80Lei

Tronson 01 Trabucco Attractive Mini Bolo 4M
Exclusiv online!

Tronson 01 Trabucco Attractive Mini Bolo 4M

124-82-400-r01
Livrare 48-72 ore

21,50Lei

Ciorapi termo Delphin EXTREMUS-MERINO marime 35-38 -42%

Ciorapi termo Delphin EXTREMUS-MERINO marime 35-38

740008035
Livrare imediată!

53,00Lei(-42%) 30,90Lei

Momitor Benzar Inline Cage Feeder L 50g

Momitor Benzar Inline Cage Feeder L 50g

58400050
Livrare imediată!

12,00Lei

Fir textil Fanatik Feeder PE Braided Green 0.12mm 5.4kg 140m
Exclusiv online!

Fir textil Fanatik Feeder PE Braided Green 0.12mm 5.4kg 140m

110813fpex414006g
Livrare 48-72 ore

49,96Lei

MULINETA SHIMANO FX 4000 FC -38%

MULINETA SHIMANO FX 4000 FC

fx4000fc
Livrare imediată!

130,00Lei(-38%) 81,00Lei

JACHETA Trabucco GNT-TECNIK THERMO HOODIE XXL
Exclusiv online!

JACHETA Trabucco GNT-TECNIK THERMO HOODIE XXL

049-42-400
Livrare 48-72 ore

265,00Lei

Tija plumb Avid Carp QC Bag Stems - Scurt

Tija plumb Avid Carp QC Bag Stems - Scurt

a0640073
Livrare imediată!

24,75Lei

Momitor Preston Ics In-line Banjo XR Feeder Medium 20 G

Momitor Preston Ics In-line Banjo XR Feeder Medium 20 G

p0040090
Livrare imediată!

16,87Lei

Tija plumb Avid Carp Bag Stems - Scurt

Tija plumb Avid Carp Bag Stems - Scurt

a0640067
Livrare imediată!

24,75Lei

Mulineta Okuma Scorpio FD 4000 -7%

Mulineta Okuma Scorpio FD 4000

sp4000-a
Livrare imediată!

278,10Lei(-7%) 259,00Lei

Momitor Benzar Inline Cage Feeder L 60g

Momitor Benzar Inline Cage Feeder L 60g

58400060
Livrare imediată!

12,00Lei

Afişare 81 - 100 din 2445 (123 pagini)
Queries: 13, Total time: 240.983 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = '81c9fe9ba931b348b280f31aad'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.065)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (204.997)
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 "%400%") 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
5 (0.345)
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:1547
6 (9.509)
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 ASC LIMIT 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (2.264)
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:1204
8 (0.115)
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:1223
9 (0.457)
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:982
10 (22.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:904
11 (0.113)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.108)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.113)
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