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 Penn Spinfisher Vl Spinning 9500

Mulineta Penn Spinfisher Vl Spinning 9500

1481267
Stoc epuizat

1.056,42Lei

Mulineta Shakespeare Mach III Spinning Reel 3000

Mulineta Shakespeare Mach III Spinning Reel 3000

1537780
Stoc epuizat

197,96Lei

Mulineta Shakespeare Salt Spin 80 Pre-Spooled

Mulineta Shakespeare Salt Spin 80 Pre-Spooled

1548354
Stoc epuizat

134,96Lei

Mulineta Shakespeare Superteam FLX 3000 5+1rul

Mulineta Shakespeare Superteam FLX 3000 5+1rul

1546262
Stoc epuizat

337,46Lei

Mulineta Abu Garcia Revo ALX Spinning Reel, 2500MSH

Mulineta Abu Garcia Revo ALX Spinning Reel, 2500MSH

1530587
Stoc epuizat

899,96Lei

Mulineta Abu Garcia Revo ALX Spinning Reel, 3000SH

Mulineta Abu Garcia Revo ALX Spinning Reel, 3000SH

1530588
Stoc epuizat

944,96Lei

Mulineta Mikado Bixlite 3006 FD

Mulineta Mikado Bixlite 3006 FD

kda138-3006fd
Stoc epuizat

181,00Lei

Mulineta Mikado Sensual Ng 3004 Fd/0,22Mm

Mulineta Mikado Sensual Ng 3004 Fd/0,22Mm

kda151-3004z
Stoc epuizat

127,00Lei

Mulineta Abu Garcia Max PRO Spincast Reel 1000

Mulineta Abu Garcia Max PRO Spincast Reel 1000

1518646
Stoc epuizat

254,96Lei

Mulineta Abu Garcia Max STX Spincast Fishing Reel 1000

Mulineta Abu Garcia Max STX Spincast Fishing Reel 1000

1518648
Stoc epuizat

233,70Lei

Mulineta Garcia Max X SP40 Spinning Reel 4000

Mulineta Garcia Max X SP40 Spinning Reel 4000

1523254
Stoc epuizat

233,70Lei

Mulineta Mikado Carp Range 12008

Mulineta Mikado Carp Range 12008

KDA151-4004Z
Stoc epuizat

135,01Lei

Mulineta Ryobi Virtus Black FD4000

Mulineta Ryobi Virtus Black FD4000

ry-vrtb4000
Stoc epuizat

217,00Lei

Mulineta Shinju 2004 Fd

Mulineta Shinju 2004 Fd

kda045-2004fd
Stoc epuizat

99,00Lei

Mulineta Van Staal VR Series Bailed Spinning 125, 4.8:1, 0.30mm/260m, 13rul

Mulineta Van Staal VR Series Bailed Spinning 125, 4.8:1, 0.30mm/260m, 13rul

1531202
Stoc epuizat

2.649,95Lei

Mulineta Zeox Netrino Spinning Reel, 5000

Mulineta Zeox Netrino Spinning Reel, 5000

GCZ-1010303
Stoc epuizat

119,00Lei

Mulineta Zfish Skipper FR Reel, 4000

Mulineta Zfish Skipper FR Reel, 4000

zf-2584
Stoc epuizat

159,17Lei

MULINETA OKUMA CEYMAR XT 2500 -25%

MULINETA OKUMA CEYMAR XT 2500

cxt-25fd
Stoc epuizat

239,00Lei(-25%) 179,00Lei

Mulineta Daiwa 18 Exist G LT 2500-XH -22%

Mulineta Daiwa 18 Exist G LT 2500-XH

d.10100.257
Stoc epuizat

4.854,90Lei(-22%) 3.776,00Lei

MULINETA RYOBI ZAUBER 4000 -20%

MULINETA RYOBI ZAUBER 4000

22106400
Stoc epuizat

616,00Lei(-20%) 492,80Lei

Afişare 1261 - 1280 din 1503 (76 pagini)
Queries: 8, Total time: 58.054 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = '12b6b32b301844225032c2605a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (50.857)
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('+mulinete +rapitori' 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.452)
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 1260, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.144)
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.128)
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.122)
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
8 (0.132)
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