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


Lanseta Okuma 8K River Feeder 4.20m, 150g, 3+2seg

Lanseta Okuma 8K River Feeder 4.20m, 150g, 3+2seg

8k-f-1403xh
Stoc epuizat

719,11Lei

Lanseta Sportex STYX B2 240 20gr -33%

Lanseta Sportex STYX B2 240 20gr

xb2400
Stoc epuizat

1.738,99Lei(-33%) 1.169,00Lei

SUPORT U LINEAEFFE FLEXIBIL PENTRU LANSETA

SUPORT U LINEAEFFE FLEXIBIL PENTRU LANSETA

a6.6313076
Stoc epuizat

10,27Lei

LANSETA SAVAGE GEAR SG4 POWER GAME 2.21M 30-70G 2SEG

LANSETA SAVAGE GEAR SG4 POWER GAME 2.21M 30-70G 2SEG

o.sg.72210
Stoc epuizat

466,06Lei

Lanseta Sportex COMPETITION CRAP CS-4 12FT 3.65M 3.00lbs -34%

Lanseta Sportex COMPETITION CRAP CS-4 12FT 3.65M 3.00lbs

cc144300
Stoc epuizat

720,00Lei(-34%) 474,00Lei

Lanseta Okuma Custom Black Feeder 3.60m 60g 3+3SEG -39%

Lanseta Okuma Custom Black Feeder 3.60m 60g 3+3SEG

cb-f-1203mh60g
Stoc epuizat

439,00Lei(-39%) 269,00Lei

LANSETA TELESCOPICA TRABUCCO VEKTOR MASTER BOAT 3.00M 150G

LANSETA TELESCOPICA TRABUCCO VEKTOR MASTER BOAT 3.00M 150G

168-25-300
Stoc epuizat

149,00Lei

Lanseta Okuma Psycho Perch UFR Spin 1.90m 1-8g 2seg

Lanseta Okuma Psycho Perch UFR Spin 1.90m 1-8g 2seg

psy-s-632ul
Stoc epuizat

350,10Lei

LANSETA SAVAGE GEAR SG4 DROP SHOT SPECIALIST 2.23M 2-12G 2SEG

LANSETA SAVAGE GEAR SG4 DROP SHOT SPECIALIST 2.23M 2-12G 2SEG

o.sg.72226
Stoc epuizat

484,90Lei

INEL FUJI ALCONITE SERIA K BCKLAGH NR 12H Dark Grey

INEL FUJI ALCONITE SERIA K BCKLAGH NR 12H Dark Grey

bcklag12h
Stoc epuizat

21,50Lei

Lanseta Daiwa Steez AGS 6101 MLXS 2.09m 5-14g

Lanseta Daiwa Steez AGS 6101 MLXS 2.09m 5-14g

d.stzags6101mlxscf
Stoc epuizat

2.178,35Lei

Lanseta Savage Gear SG2 Vertical Specialist Trigger 1.98m 30-65g 2SEG

Lanseta Savage Gear SG2 Vertical Specialist Trigger 1.98m 30-65g 2SEG

o.sg.72183
Stoc epuizat

344,73Lei

Lanseta Okuma Psycho Perch UFR Cast 2.30m 4-24g 2seg

Lanseta Okuma Psycho Perch UFR Cast 2.30m 4-24g 2seg

psy-c-732ml
Stoc epuizat

359,09Lei

LANSETA SAVAGE GEAR SG4 MEDIUM GAME TRIGGER 2.13M 5-20G 2SEG

LANSETA SAVAGE GEAR SG4 MEDIUM GAME TRIGGER 2.13M 5-20G 2SEG

o.sg.72203
Stoc epuizat

420,83Lei

HUSA DAIWA PENTRU LANSETA CU MULINETA 3 POSTURI 145CM

HUSA DAIWA PENTRU LANSETA CU MULINETA 3 POSTURI 145CM

d.15801.345
Stoc epuizat

421,61Lei

Lanseta feeder Maver IT REACTORLITE F FEEDER 12FT 3.6M 70GR

Lanseta feeder Maver IT REACTORLITE F FEEDER 12FT 3.6M 70GR

5771001
Stoc epuizat

979,00Lei

LANSETA SAVAGE GEAR SG4 MEDIUM GAME 1.98M 12-35G 2SEG

LANSETA SAVAGE GEAR SG4 MEDIUM GAME 1.98M 12-35G 2SEG

o.sg.72198
Stoc epuizat

368,53Lei

Kit Lanseta Sert Fish Instinct Telespin 2.10m+Mulineta Sert Aka 201 RD -20%

Kit Lanseta Sert Fish Instinct Telespin 2.10m+Mulineta Sert Aka 201 RD

995030019
Stoc epuizat

110,17Lei(-20%) 88,14Lei

LANSETA CORMORAN TICORA BLACK SPIN 2.74M 20-62G 2SEG

LANSETA CORMORAN TICORA BLACK SPIN 2.74M 20-62G 2SEG

c.27.1062279
Stoc epuizat

168,94Lei

Lanseta Lucky John Anira 2.34m 12-45gr 2seg

Lanseta Lucky John Anira 2.34m 12-45gr 2seg

lja-782mhef
Stoc epuizat

621,00Lei

Afişare 8001 - 8020 din 8555 (428 pagini)
Queries: 12, Total time: 258.707 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = '24a4bf0510392c7e33124b9e35'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.132)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (257.376)
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('+lanseta' 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 (0.168)
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
6 (0.118)
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.115)
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.107)
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
9 (0.105)
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.095)
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
11 (0.132)
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
12 (0.129)
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