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

Produse ce potrivesc criteriilor de căutare


Mulineta Penn Squall Lever Drag 60 RH

Mulineta Penn Squall Lever Drag 60 RH

1206096
Stoc epuizat

965,00Lei

Mulineta spinning Baracuda SA3000, 1R

Mulineta spinning Baracuda SA3000, 1R

mulinete sa30
Stoc epuizat

32,90Lei

Husa 3 Lansete cu Mulineta NGT DeLuxe 3.60cm

Husa 3 Lansete cu Mulineta NGT DeLuxe 3.60cm

ngt-fla-rodholdall-510
Stoc epuizat

199,99Lei

Husa DAM Intenze pentru 4 Lansete cu Mulineta, 130x38x29cm

Husa DAM Intenze pentru 4 Lansete cu Mulineta, 130x38x29cm

a8.dam.60362
Stoc epuizat

320,67Lei

Mulineta Abu Garcia Revo SX Low Profile Reel, Left, 7.3:1, 9+1rul

Mulineta Abu Garcia Revo SX Low Profile Reel, Left, 7.3:1, 9+1rul

1565155
Stoc epuizat

854,96Lei

Mulineta Colmic Orion FD 4000 7+1BB

Mulineta Colmic Orion FD 4000 7+1BB

mulor40
Stoc epuizat

315,00Lei

Mulineta Daiwa BG MQ 18000 6+1rul

Mulineta Daiwa BG MQ 18000 6+1rul

d.bgmq18000
Stoc epuizat

1.186,39Lei

MULINETA DAIWA WINDCAST BR 5500 LDA

MULINETA DAIWA WINDCAST BR 5500 LDA

d.wcbr5500lda
Stoc epuizat

886,91Lei

Mulineta Penn Battle Ill Spinning 6000

Mulineta Penn Battle Ill Spinning 6000

1518036
Stoc epuizat

629,96Lei

Mulineta Penn Special Senator Star Drag 114W2LW RH

Mulineta Penn Special Senator Star Drag 114W2LW RH

1187312
Stoc epuizat

989,96Lei

Mulineta Penn Squall II Star Drag Reel Box Right Hand, 25N

Mulineta Penn Squall II Star Drag Reel Box Right Hand, 25N

1522169
Stoc epuizat

854,96Lei

Mulineta Ryobi Ecusima Vi 1000 5+1rul

Mulineta Ryobi Ecusima Vi 1000 5+1rul

ry-ecs1000vi
Stoc epuizat

219,00Lei

Mulineta Ryobi Ecusima Vi 2000 5+1rul

Mulineta Ryobi Ecusima Vi 2000 5+1rul

ry-ecs2000vi
Stoc epuizat

225,01Lei

Mulineta Ryobi Ecusima Vi 4000 5+1rul

Mulineta Ryobi Ecusima Vi 4000 5+1rul

ry-ecs4000vi
Stoc epuizat

253,01Lei

MULINETA RYOBI SLAM 2000 -20%

MULINETA RYOBI SLAM 2000

24503200
Stoc epuizat

601,00Lei(-20%) 480,80Lei

Husa DAM Intenze pentru 4 Lansete cu Mulineta, 170x38x29cm

Husa DAM Intenze pentru 4 Lansete cu Mulineta, 170x38x29cm

a8.dam.60364
Stoc epuizat

360,20Lei

Mulineta Fin-Nor Lethal LTH30 Spinn Reel

Mulineta Fin-Nor Lethal LTH30 Spinn Reel

1531257
Stoc epuizat

560,36Lei

Mulineta NGT XPR DeLuxe Carp Runner 6000, 10 BB

Mulineta NGT XPR DeLuxe Carp Runner 6000, 10 BB

ngt-frl-xpr-6000
Stoc epuizat

169,99Lei

Mulineta Okuma Inspira ISX High Speed, 2500HA

Mulineta Okuma Inspira ISX High Speed, 2500HA

isx-2500ha
Stoc epuizat

518,99Lei

Mulineta Penn Battle Ill Spinning 6000 HS

Mulineta Penn Battle Ill Spinning 6000 HS

1518037
Stoc epuizat

629,96Lei

Afişare 3421 - 3440 din 3531 (177 pagini)
Queries: 10, Total time: 268.323 ms [By time] [By id] [By file]
1 (0.114)
SELECT data
FROM `oc_session`
WHERE session_id = 'f97583ab1fd0217f8fef34f51e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (253.509)
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 = '2' AND (pd.tag LIKE "%mulineta%") 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:698
4 (13.857)
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 3420, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.130)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.120)
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
7 (0.151)
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
8 (0.115)
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
9 (0.115)
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
10 (0.125)
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