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 Mitchell MX2SW Spinning Reel, 4000

Mulineta Mitchell MX2SW Spinning Reel, 4000

1580063
Stoc epuizat

219,96Lei

Mulineta Mitchell MX2SW Spinning Reel, 6000

Mulineta Mitchell MX2SW Spinning Reel, 6000

1580064
Livrare imediată!

259,96Lei

Mulineta Mitchell MX3 FS Reel, 3000

Mulineta Mitchell MX3 FS Reel, 3000

1544502
Stoc epuizat

259,96Lei

Mulineta Mitchell MX3LE Spinning Reel, 1000FD

Mulineta Mitchell MX3LE Spinning Reel, 1000FD

1530825
Stoc epuizat

239,96Lei

Mulineta Mitchell MX3LE Spinning Reel, 3000 FD

Mulineta Mitchell MX3LE Spinning Reel, 3000 FD

1530827
Stoc epuizat

279,96Lei

Mulineta Mitchell MX6 LITE Spinning Reel, 4000 HS

Mulineta Mitchell MX6 LITE Spinning Reel, 4000 HS

1551710
Stoc epuizat

607,46Lei

Mulineta Mitchell MX7 LITE Spinning Reel, 3000 HS

Mulineta Mitchell MX7 LITE Spinning Reel, 3000 HS

1551705
Stoc epuizat

664,95Lei

Mulineta Nevis Torrent Match 4000

Mulineta Nevis Torrent Match 4000

2531-640
Livrare imediată!

179,00Lei

Mulineta Okuma ITX CB Spinning 2500H
Exclusiv online!

Mulineta Okuma ITX CB Spinning 2500H

icb-2500ha
Livrare 48-72ore

789,01Lei

Mulineta Penn Fierce IV Spinning FRCIV 4000 Reel Box

Mulineta Penn Fierce IV Spinning FRCIV 4000 Reel Box

1558708
Stoc epuizat

424,96Lei

Mulineta Penn Slammer IV Spinning Reel Box, 3500

Mulineta Penn Slammer IV Spinning Reel Box, 3500

1545761
Livrare imediată!

1.079,96Lei

Mulineta Penn Spinfisher Vll Spinning Reel 6500, 5.6:1, 6rul

Mulineta Penn Spinfisher Vll Spinning Reel 6500, 5.6:1, 6rul

1612616
Livrare imediată!

854,96Lei

Mulineta Penn Tidal Long Cast 8000, 4.3:1, 8rul

Mulineta Penn Tidal Long Cast 8000, 4.3:1, 8rul

1594963
Livrare imediată!

854,96Lei

Mulineta Penn Warfare Level Wind Right Hand 15 Level Wind LC Reel Box

Mulineta Penn Warfare Level Wind Right Hand 15 Level Wind LC Reel Box

1366188
Stoc epuizat

494,96Lei

Mulineta Prologic Avenger 3000 BF SST Graph Spare Spool, 0.25mm-280,. 5.1:1, 3+1BB

Mulineta Prologic Avenger 3000 BF SST Graph Spare Spool, 0.25mm-280,. 5.1:1, 3+1BB

o.pro.76022
Livrare imediată!

203,05Lei

Mulineta Reiva Sabalo 7000, 4.6:1, 0.40mm/320m, 5+1rul
Exclusiv online!

Mulineta Reiva Sabalo 7000, 4.6:1, 0.40mm/320m, 5+1rul

2537-670
Livrare 48-72 ore

375,00Lei

Mulineta Sakura Salt Sniper 4004 FD, 5.2:1, 0.25mm/345m, 3+1rul

Mulineta Sakura Salt Sniper 4004 FD, 5.2:1, 0.25mm/345m, 3+1rul

30234saprg70234004
Livrare imediată!

199,31Lei

Mulineta Shakespeare Cedar Canyon Disk Fly Reel, clasa 5/6

Mulineta Shakespeare Cedar Canyon Disk Fly Reel, clasa 5/6

1564803
Stoc epuizat

179,96Lei

Mulineta Shakespeare Firebird 50 RD

Mulineta Shakespeare Firebird 50 RD

1550362
Livrare imediată!

84,95Lei

Mulineta Shakespeare Mach II Spinning Reel 2000

Mulineta Shakespeare Mach II Spinning Reel 2000

1537725
Stoc epuizat

152,96Lei

Afişare 621 - 640 din 3506 (176 pagini)
Queries: 5, Total time: 101.853 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '6be9823187d224dbffcded0903'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.147)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (101.319)
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('+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 (0.156)
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
5 (0.124)
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