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

Produse ce potrivesc criteriilor de căutare


Mulineta Feeder Trabucco Inspiron 5500, 4.6:1, 0.22mm/150m, 6rul

Mulineta Feeder Trabucco Inspiron 5500, 4.6:1, 0.22mm/150m, 6rul

034-81-155
Livrare imediată!

380,00Lei

Mulineta Filfishing Sonic 3000
Exclusiv online!

Mulineta Filfishing Sonic 3000

fil5987
Livrare 48-72 ore

159,00Lei

Mulineta Fly Greys Fin Fly Reel 7/8
Exclusiv online!

Mulineta Fly Greys Fin Fly Reel 7/8

1546671
Livrare 7-14 zile

424,96Lei

Mulineta Fly Greys Fin Fly Reel 9/10
Exclusiv online!

Mulineta Fly Greys Fin Fly Reel 9/10

1546672
Livrare 7-14 zile

488,71Lei

Mulineta Lucky John Vanrex SPIN 2000, 5.1:1, 0.23mm/171m, 6rul
Exclusiv online!

Mulineta Lucky John Vanrex SPIN 2000, 5.1:1, 0.23mm/171m, 6rul

ljvs06-30fd
Livrare 48-72ore

280,00Lei

Mulineta Mikado Black Crystal 3005 FD
Exclusiv online!

Mulineta Mikado Black Crystal 3005 FD

kda140-3005fd
Livrare 48-72 ore

440,00Lei

Mulineta Mikado Carp Range 12008
Exclusiv online!

Mulineta Mikado Carp Range 12008

kda155-12008
Livrare 48-72 ore

292,00Lei

Mulineta Mikado Noctis 2009 FD
Exclusiv online!

Mulineta Mikado Noctis 2009 FD

kda135-2009fd
Livrare 48-72 ore

426,00Lei

Mulineta Mitchell MX1 FS5500

Mulineta Mitchell MX1 FS5500

1544509
Livrare imediată!

119,96Lei

Mulineta Mitchell MX1 FS5500 Pre Spooled -21%

Mulineta Mitchell MX1 FS5500 Pre Spooled

1544512
Livrare imediată!

159,96Lei(-21%) 125,90Lei

Mulineta Nash Scope Reel GT Gold Edition 4000
Exclusiv online!

Mulineta Nash Scope Reel GT Gold Edition 4000

t2030
Livrare 7-14 zile

783,95Lei

Mulineta Nash Scope Reel GT Gold Edition 6000
Exclusiv online!

Mulineta Nash Scope Reel GT Gold Edition 6000

t2031
Livrare 7-14 zile

881,94Lei

Mulineta Nevis Black Match 4000 4+1 Rulmenti

Mulineta Nevis Black Match 4000 4+1 Rulmenti

2257-540
Livrare imediată!

159,00Lei

Mulineta Nytro Impax 4000

Mulineta Nytro Impax 4000

20100006
Livrare imediată!

258,96Lei

Mulineta Nytro Marvelist Power Feeder 4000
Exclusiv online!

Mulineta Nytro Marvelist Power Feeder 4000

20100047
Livrare 48-72 ore

650,70Lei

Mulineta Okuma Ceymar HD 2500A

Mulineta Okuma Ceymar HD 2500A

chd-2500a
Livrare imediată!

369,00Lei

Mulineta Okuma Gold 2500 7+1rul -21%

Mulineta Okuma Gold 2500 7+1rul

g-2500
Livrare imediată!

251,10Lei(-21%) 199,00Lei

Mulineta Penn Authority Spinning 8500
Exclusiv online!

Mulineta Penn Authority Spinning 8500

1563165
Livrare 7-14 zile

2.609,96Lei

Mulineta Penn Fierce IV Spinning FRCIV 1000 Reel Box

Mulineta Penn Fierce IV Spinning FRCIV 1000 Reel Box

1558701
Livrare imediată!

339,96Lei

Mulineta Penn Rival Level Wind 30LWLCLH Right Hand Reel Box
Exclusiv online!

Mulineta Penn Rival Level Wind 30LWLCLH Right Hand Reel Box

1404004
Livrare 7-14 zile

472,47Lei

Afişare 821 - 840 din 3511 (176 pagini)
Queries: 6, Total time: 109.389 ms [By time] [By id] [By file]
1 (0.128)
SELECT data
FROM `oc_session`
WHERE session_id = '9a770b301c7b24a97b51ae5698'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (95.210)
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 = '2' AND (MATCH(pd.tag) AGAINST('+mulineta' 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 (13.678)
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 820, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.143)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.127)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38