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 - GOVERNOR

Produse ce potrivesc criteriilor de căutare


Fir monofilament Delphin CITRUS galben 0,30mm 15lbs 600m

Fir monofilament Delphin CITRUS galben 0,30mm 15lbs 600m

101001325
Stoc epuizat

39,00Lei

Carlige Fanatik FK-1026 No.4 Carp Profi 8buc/plic -33%

Carlige Fanatik FK-1026 No.4 Carp Profi 8buc/plic

120513fk10264
Stoc epuizat

5,50Lei(-33%) 3,67Lei

Mulineta Delphin TwinDRAG 5T DP 5000

Mulineta Delphin TwinDRAG 5T DP 5000

101001216
Stoc epuizat

185,00Lei

SET MONTURI NASH Cling-On Leadcore Helicopter Leaders Silt 1m 3BUC/PLIC
Carlige Fanatik FK-1026 No.6 Carp Profi 8buc/plic

Carlige Fanatik FK-1026 No.6 Carp Profi 8buc/plic

120513fk10266
Stoc epuizat

5,50Lei

Mulineta Delphin CHIMERA NXT 5T 5000 -30%

Mulineta Delphin CHIMERA NXT 5T 5000

101001219
Stoc epuizat

299,00Lei(-30%) 209,00Lei

Fir monofilament Delphin MAMBA Carp camuflaj 0.30mm 15.5lbs 600m

Fir monofilament Delphin MAMBA Carp camuflaj 0.30mm 15.5lbs 600m

101001658
Stoc epuizat

67,00Lei

Carlige Fudo Maruseigo with Ring (MSGR-BN) nr.8 BN - Black Nickel 13 buc/plic -20%

Carlige Fudo Maruseigo with Ring (MSGR-BN) nr.8 BN - Black Nickel 13 buc/plic

3201-8
Stoc epuizat

10,00Lei(-20%) 8,00Lei

Carlige Fudo Round (FDRD-BN) nr.10 BN - Black Nickel 15 buc/plic -20%

Carlige Fudo Round (FDRD-BN) nr.10 BN - Black Nickel 15 buc/plic

2701-10
Stoc epuizat

10,00Lei(-20%) 8,00Lei

LANSETA PROLOGIC 2BUC C2 ELEMENT 3,60/3LBS

LANSETA PROLOGIC 2BUC C2 ELEMENT 3,60/3LBS

o.pro.64121
Stoc epuizat

464,45Lei

Lanseta Lineaeffe XTR Carp MT 3.60m 3lbs 2SEG

Lanseta Lineaeffe XTR Carp MT 3.60m 3lbs 2SEG

l.2724037
Stoc epuizat

73,67Lei

Carlige Maruto Barbed 8356-BD BN Nr.10

Carlige Maruto Barbed 8356-BD BN Nr.10

43205010
Stoc epuizat

8,90Lei

Mulineta Carp Expert Classic Runner 5000

Mulineta Carp Expert Classic Runner 5000

20911500
Stoc epuizat

131,00Lei

Lanseta Fox Horizon X4 3.60M 3.50lbs Abbreviated Handle -20%

Lanseta Fox Horizon X4 3.60M 3.50lbs Abbreviated Handle

crd278
Stoc epuizat

1.341,86Lei(-20%) 1.073,48Lei

Mulineta Delphin QUEEN 5T TwinDRAG DP 5000

Mulineta Delphin QUEEN 5T TwinDRAG DP 5000

101001225
Stoc epuizat

179,00Lei

Carlige Fudo Slider Carp (SLCR TF) nr.6 TF Teflonat 9 buc/plic

Carlige Fudo Slider Carp (SLCR TF) nr.6 TF Teflonat 9 buc/plic

2807-6
Stoc epuizat

10,00Lei

Mulineta Delphin INOX 70D 0.30mm/410m -39%

Mulineta Delphin INOX 70D 0.30mm/410m

101000968
Stoc epuizat

487,00Lei(-39%) 295,00Lei

MONTURA KORDA SPINNER RIG KURV BOOM NR.4 25LB

MONTURA KORDA SPINNER RIG KURV BOOM NR.4 25LB

a.kcr134
Stoc epuizat

16,22Lei

Carlige Maruto HC 8346 BD 10buc nr 8

Carlige Maruto HC 8346 BD 10buc nr 8

43203008
Stoc epuizat

10,00Lei

Mulineta Delphin QUEEN 5T TwinDRAG DP 6000

Mulineta Delphin QUEEN 5T TwinDRAG DP 6000

101001226
Stoc epuizat

134,01Lei

Afişare 9901 - 9920 din 10369 (519 pagini)
Queries: 11, Total time: 302.334 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = 'a82cfea6315119f2d61594a3ae'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (257.936)
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('+crap' 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
5 (43.237)
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 9900, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.172)
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
7 (0.138)
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
8 (0.122)
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.127)
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
10 (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
11 (0.137)
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