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 Carp Zoom Crap Bull-Dog Fluo, 1000m, 0.31mm, 12.65kg

Fir Monofilament Carp Zoom Crap Bull-Dog Fluo, 1000m, 0.31mm, 12.65kg

cz3032
Stoc epuizat

48,00Lei

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION DISTANCE 250mt 0.22mm 6.35kg Verde
FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION EXTREME 200M 0.19MM 5.70KG
Fir Monofilament Carp Zoom Crap Bull-Dog Dark Green, 300m, 0.25mm, 8.8kg
FIR TEXTIL CARP ZOOM HOOKLINK 3x3 MARO 35LB 20M

FIR TEXTIL CARP ZOOM HOOKLINK 3x3 MARO 35LB 20M

cz6828
Stoc epuizat

42,00Lei

FIR TEXTIL CARP ZOOM HOOKLINK 3x3 MARO 25LB 20M

FIR TEXTIL CARP ZOOM HOOKLINK 3x3 MARO 25LB 20M

cz6811
Stoc epuizat

42,00Lei

FIR TEXTIL CARP ZOOM HOOKLINK 3x3 MARO 15LB 20M

FIR TEXTIL CARP ZOOM HOOKLINK 3x3 MARO 15LB 20M

cz6804
Stoc epuizat

42,00Lei

Fir Monofilament Carp Zoom Crap Bull-Dog Fluo, 300m, 0.28mm, 10.75kg

Fir Monofilament Carp Zoom Crap Bull-Dog Fluo, 300m, 0.28mm, 10.75kg

cz2998
Stoc epuizat

21,50Lei

Fir Monofilament Carp Zoom Crap Bull-Dog Fluo, 300m, 0.25mm, 8.8kg

Fir Monofilament Carp Zoom Crap Bull-Dog Fluo, 300m, 0.25mm, 8.8kg

cz0582
Stoc epuizat

21,00Lei

FIR TEXTIL CARP ZOOM CLASSIC BRAID 120m 0.08mm 3.9kg Galben Fluo

FIR TEXTIL CARP ZOOM CLASSIC BRAID 120m 0.08mm 3.9kg Galben Fluo

cz4700
Stoc epuizat

50,00Lei

FIR TEXTIL CARP ZOOM CLASSIC BRAID 120m 0.16mm 9.4kg Galben Fluo -20%

FIR TEXTIL CARP ZOOM CLASSIC BRAID 120m 0.16mm 9.4kg Galben Fluo

cz4748
Stoc epuizat

42,00Lei(-20%) 33,61Lei

Boilies de Carlig Carp Zoom Fire Shot 24mm 120g Mussel -25%

Boilies de Carlig Carp Zoom Fire Shot 24mm 120g Mussel

cz8951
Stoc epuizat

7,50Lei(-25%) 5,60Lei

FIR TEXTIL CARP ZOOM FEEDER 100m 0.08mm 4.50kg

FIR TEXTIL CARP ZOOM FEEDER 100m 0.08mm 4.50kg

cz0382
Stoc epuizat

31,00Lei

Fir Monofilament Carp Zoom Feeder Competition Extreme 0.28mm 9.20kg 200m
Fir monofilament Carp Zoom Feeder Competition Leader 0.14mm/3.50kg/50m

Fir monofilament Carp Zoom Feeder Competition Leader 0.14mm/3.50kg/50m

cz2113
Stoc epuizat

18,50Lei

LEADCORE CARP ZOOM MAROU 35LB 10M

LEADCORE CARP ZOOM MAROU 35LB 10M

cz6767
Stoc epuizat

42,00Lei

FIR CARP ZOOM SERIA EXTREME AMUR-GRASS CARP 250m 0.30mm Green

FIR CARP ZOOM SERIA EXTREME AMUR-GRASS CARP 250m 0.30mm Green

cz2118
Stoc epuizat

12,50Lei

LEADCORE CARP ZOOM MAROU 25LB 7M

LEADCORE CARP ZOOM MAROU 25LB 7M

cz6750
Stoc epuizat

42,00Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.33mm 8.90kg Fluo Orange -25%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.33mm 8.90kg Fluo Orange

cz6964
Stoc epuizat

72,99Lei(-25%) 54,80Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.30mm 7.20kg Fluo Orange -25%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.30mm 7.20kg Fluo Orange

cz6957
Stoc epuizat

62,00Lei(-25%) 46,51Lei

Afişare 121 - 140 din 177 (9 pagini)
Queries: 6, Total time: 15.474 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = 'd512254e2f4b5bdbcca7507c57'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (14.873)
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('+fire +carp +zoom' 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.139)
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
5 (0.120)
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.123)
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