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

Căutare - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Mulineta Carp Expert Score, 6500
Exclusiv online!

Mulineta Carp Expert Score, 6500

20211650
Livrare 24-48 ore

233,04Lei

Mulineta Korum Axis 2 Reel, 3000
Exclusiv online!

Mulineta Korum Axis 2 Reel, 3000

k0340031
Livrare 7-14 zile

215,96Lei

Mulineta Korum Axis 2 Reel, 4000
Exclusiv online!

Mulineta Korum Axis 2 Reel, 4000

k0340032
Livrare 7-14 zile

247,46Lei

Mulineta Mikado Mx-5 Fr 5008
Exclusiv online!

Mulineta Mikado Mx-5 Fr 5008

kda160-5008
Livrare 48-72 ore

488,99Lei

Mulineta Mikado Toxy Mf 5006
Exclusiv online!

Mulineta Mikado Toxy Mf 5006

kda159-5006
Livrare 48-72 ore

292,00Lei

Mulineta Nytro Impax 4000

Mulineta Nytro Impax 4000

20100007
Livrare imediată!

258,96Lei

Mulineta Nytro NTR MK2 4002 FD
Exclusiv online!

Mulineta Nytro NTR MK2 4002 FD

20100030
Livrare 48-72 ore

169,92Lei

Mulineta Nytro NTR MK2 5002 FD
Exclusiv online!

Mulineta Nytro NTR MK2 5002 FD

20100031
Livrare 48-72 ore

180,32Lei

Mulineta Preston Centris SD Reels 320
Exclusiv online!

Mulineta Preston Centris SD Reels 320

p0010034
Livrare 7-14 zile

854,96Lei

Mulineta Preston Centris SD Reels 420
Exclusiv online!

Mulineta Preston Centris SD Reels 420

p0010035
Livrare 7-14 zile

877,46Lei

Mulineta Preston Centris SD Reels 520
Exclusiv online!

Mulineta Preston Centris SD Reels 520

p0010036
Livrare 7-14 zile

899,96Lei

Mulineta Sert Cu Fir AKA Efi 401FD
Exclusiv online!

Mulineta Sert Cu Fir AKA Efi 401FD

30101seprl7708401fd
Livrare 48-72 ore

76,96Lei

Mulineta Zfish Real Rider, 5000
Exclusiv online!

Mulineta Zfish Real Rider, 5000

ZF-7005
Livrare 48-72ore

189,07Lei

Mulineta Zfish Real Rider, 6000
Exclusiv online!

Mulineta Zfish Real Rider, 6000

ZF-7006
Livrare 48-72ore

195,06Lei

Mulineta Zfish Real Rider, 7000
Exclusiv online!

Mulineta Zfish Real Rider, 7000

ZF-7007
Livrare 48-72ore

199,05Lei

TAMBUR DE REZERVA MULINETA PRESTON EXTREMITY FEEDER 6000
Exclusiv online!

TAMBUR DE REZERVA MULINETA PRESTON EXTREMITY FEEDER 6000

p0010013
Livrare 7-14 zile

112,46Lei

Tambur Rezerva Mulineta Team Feeder By Dome Master Carp LCS Pro 5000
Exclusiv online!

Tambur Rezerva Mulineta Team Feeder By Dome Master Carp LCS Pro 5000

2511-650-01
Livrare 48-72 ore

55,00Lei

Tambur Rezerva Mulineta Team Feeder By Dome Master Carp LCS Pro 6000

Tambur Rezerva Mulineta Team Feeder By Dome Master Carp LCS Pro 6000

2511-660-01
Livrare imediată!

59,00Lei

MULINETA CRAP Okuma Long Bow LB60 -10%

MULINETA CRAP Okuma Long Bow LB60

lb-660
Livrare imediată!

349,00Lei(-10%) 314,01Lei

MULINETA OKUMA CUSTOM BLACK 6000 -7%

MULINETA OKUMA CUSTOM BLACK 6000

cb-60
Livrare imediată!

332,11Lei(-7%) 309,00Lei

Afişare 441 - 460 din 1584 (80 pagini)
Queries: 8, Total time: 61.398 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = '99c28c1ce21d967592bbdd26cf'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (54.058)
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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (MATCH(pd.tag) AGAINST('+mulinete +feeder' IN BOOLEAN MODE)) 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:737
4 (6.587)
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 440, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.148)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.129)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.129)
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