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


Carlige Maruto 9624-BN Nr 4 10buc/plic

Carlige Maruto 9624-BN Nr 4 10buc/plic

43452004
Stoc epuizat

9,50Lei

Fir FIN HOOK LINE DOUBLE 8K 20m Camuflaj 25lbs

Fir FIN HOOK LINE DOUBLE 8K 20m Camuflaj 25lbs

500702025
Stoc epuizat

43,99Lei

Carlige Maruto 9354-R BN Nr.8 10buc

Carlige Maruto 9354-R BN Nr.8 10buc

43851008
Stoc epuizat

7,70Lei

Fir Delphin FIN Strong CARP 300m Gri 0.30mm

Fir Delphin FIN Strong CARP 300m Gri 0.30mm

500601030
Stoc epuizat

39,00Lei

Fir Monofilament Trabucco MASTER ISO 300M 0.28mm 9.54kg

Fir Monofilament Trabucco MASTER ISO 300M 0.28mm 9.54kg

050-60-280
Stoc epuizat

43,60Lei

Fir Fluorocarbon Guru Pure Fluorocarbon, 0,18MM/2,1KG/50M

Fir Fluorocarbon Guru Pure Fluorocarbon, 0,18MM/2,1KG/50M

a.gu.gfc18
Stoc epuizat

46,42Lei

LANSETA FOX HORIZON X3 ABBREVIATED HANDLE 3.60M 3.50LBS -14%

LANSETA FOX HORIZON X3 ABBREVIATED HANDLE 3.60M 3.50LBS

crd291
Stoc epuizat

674,94Lei(-14%) 580,07Lei

Fir fluorocarbon Quantum Fluoro Carbon Predator 0.30mm 25m -43%

Fir fluorocarbon Quantum Fluoro Carbon Predator 0.30mm 25m

2625030
Stoc epuizat

31,29Lei(-43%) 17,90Lei

Fir Delphin FIN Strong CARP 300m Gri 0.32mm

Fir Delphin FIN Strong CARP 300m Gri 0.32mm

500601032
Stoc epuizat

41,00Lei

MONTURA JAXON XTR CRAP HD ADJUSTABIL NR 4

MONTURA JAXON XTR CRAP HD ADJUSTABIL NR 4

ac-pch04
Stoc epuizat

16,01Lei

Lanseta Fox Horizon X4 3.05M 3.00 lbs Abbreviated Handle

Lanseta Fox Horizon X4 3.05M 3.00 lbs Abbreviated Handle

crd281
Stoc epuizat

1.079,95Lei

Minciog Crap Delphin Armada 90x90cm

Minciog Crap Delphin Armada 90x90cm

946006143
Stoc epuizat

302,00Lei

Protectie Boilies Anti Raci KORDA Bait Wrap, Transparent, 22mm

Protectie Boilies Anti Raci KORDA Bait Wrap, Transparent, 22mm

a.sw22
Stoc epuizat

32,48Lei

Fir Delphin FIN Strong CARP 300m Galben Fluo 0.32mm

Fir Delphin FIN Strong CARP 300m Galben Fluo 0.32mm

500604032
Stoc epuizat

41,00Lei

Carlig Gamakatsu Power Carp Hair Rigger, Barbless, Nr.8 10buc/plic

Carlig Gamakatsu Power Carp Hair Rigger, Barbless, Nr.8 10buc/plic

gk.185171.8
Stoc epuizat

15,15Lei

CARLIG MUSTAD NICHEL PT. CRAP 1/0

CARLIG MUSTAD NICHEL PT. CRAP 1/0

m.10829bln.01
Stoc epuizat

14,84Lei

FIR MONOFILAMENT GENLOG ALLROUND ORANGE 150 M 0.22MM 6.5 KG

FIR MONOFILAMENT GENLOG ALLROUND ORANGE 150 M 0.22MM 6.5 KG

gzy-acor-22
Stoc epuizat

21,80Lei

Line Aligner Radical Kicker Curve 10buc/plic

Line Aligner Radical Kicker Curve 10buc/plic

6263003
Stoc epuizat

17,78Lei

Fir Delphin FIN Strong CARP 600m Galben Fluo 0.28mm

Fir Delphin FIN Strong CARP 600m Galben Fluo 0.28mm

500604328
Stoc epuizat

47,01Lei

LANSETA FOX HORIZON X3 ABBREVIATED HANDLE 3.00M 3.50LBS -14%

LANSETA FOX HORIZON X3 ABBREVIATED HANDLE 3.00M 3.50LBS

crd286
Stoc epuizat

584,96Lei(-14%) 502,75Lei

Afişare 9841 - 9860 din 10369 (519 pagini)
Queries: 7, Total time: 316.434 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = 'af437a003ceb92bdaf8566d91c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.103)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (271.110)
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 (44.713)
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 9840, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.136)
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.169)
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