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 Graphiteleader Silverado Cast GSIC-762M Fast 2.28m 3-16g 2seg

Lanseta Graphiteleader Silverado Cast GSIC-762M Fast 2.28m 3-16g 2seg

g08684
Stoc epuizat

1.990,00Lei

Lanseta bolognesa Italica Super Fortexa Bronze 5m 5-25g

Lanseta bolognesa Italica Super Fortexa Bronze 5m 5-25g

it103500
Stoc epuizat

530,00Lei

Lanseta spinning Baracuda Jet Spin II 2.10M 10-40g 2SEG

Lanseta spinning Baracuda Jet Spin II 2.10M 10-40g 2SEG

jet spin ii 2102
Stoc epuizat

181,90Lei

Lanseta Spinning Gamakatsu Areatry 66L, 1.98m, 1-10g, 2seg

Lanseta Spinning Gamakatsu Areatry 66L, 1.98m, 1-10g, 2seg

gk.24386.660
Stoc epuizat

629,50Lei

Lanseta Fox EOS Pro 3.60M 3lb 3seg

Lanseta Fox EOS Pro 3.60M 3lb 3seg

crd329
Stoc epuizat

337,46Lei

INELE JAXON VARF SIC/TS NR 12 4.0MM

INELE JAXON VARF SIC/TS NR 12 4.0MM

ok-a1240
Stoc epuizat

12,00Lei

Lanseta Airrus Stargate Spinning MH 1.88M 7-35g 2seg

Lanseta Airrus Stargate Spinning MH 1.88M 7-35g 2seg

asg6215mhf-s
Stoc epuizat

1.370,00Lei

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 95x6.3cm -31%

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 95x6.3cm

uj-xar6395
Stoc epuizat

129,00Lei(-31%) 89,25Lei

INELE JAXON VARF NR 6 2.2MM

INELE JAXON VARF NR 6 2.2MM

ok-sm0622
Stoc epuizat

22,00Lei

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

LANSETA FOX HORIZON X3 CORK HANDLE 3.60M 3.50LBS

crd292
Stoc epuizat

719,96Lei(-14%) 618,76Lei

Lanseta EnergoTeam Kamasaki Elite Spin 2.70m 30-50g 2buc -20%

Lanseta EnergoTeam Kamasaki Elite Spin 2.70m 30-50g 2buc

13189270
Stoc epuizat

123,00Lei(-20%) 98,40Lei

Lanseta Nomura Samurai Spinning 2.10m 10-40g

Lanseta Nomura Samurai Spinning 2.10m 10-40g

nm.22224021
Stoc epuizat

272,33Lei

Inel EnergoTeam Varf Match SIC UMHSIT 2,5x6

Inel EnergoTeam Varf Match SIC UMHSIT 2,5x6

81506025
Stoc epuizat

7,50Lei

Lanseta Daiwa Telescopica Triforce Bombette 4.20m 40-90g

Lanseta Daiwa Telescopica Triforce Bombette 4.20m 40-90g

d.tfbb42txhcf
Stoc epuizat

344,37Lei

Lanseta FL Aqua Tele Spin 2.70M 15-45g

Lanseta FL Aqua Tele Spin 2.70M 15-45g

8255193660780
Stoc epuizat

120,80Lei

Lanseta DAM Madcat Green Spin 2.10m 40-150gr

Lanseta DAM Madcat Green Spin 2.10m 40-150gr

2033155830
Stoc epuizat

299,49Lei

Lanseta Baracuda fibra sticla 2seg 3.0m 500g

Lanseta Baracuda fibra sticla 2seg 3.0m 500g

fibra plina 3002
Stoc epuizat

61,81Lei

Lanseta Black Cat Freestyle Fireball V-JIG 1.90m 225gr

Lanseta Black Cat Freestyle Fireball V-JIG 1.90m 225gr

16430190
Stoc epuizat

453,41Lei

LANSETA RAPTURE FLIT MASTER 2.13M 11-28G 2BUC

LANSETA RAPTURE FLIT MASTER 2.13M 11-28G 2BUC

126-35-300
Stoc epuizat

530,00Lei

LANSETA SAVAGE GEAR PREDATOR SPINNING 2 SPIN 2.21M/20-60G 2SEG

LANSETA SAVAGE GEAR PREDATOR SPINNING 2 SPIN 2.21M/20-60G 2SEG

o.sg.57550
Stoc epuizat

316,83Lei

Afişare 7721 - 7740 din 8555 (428 pagini)
Queries: 8, Total time: 207.024 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = 'a02e853ed8424f15c68b1d0b86'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.134)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (206.276)
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.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.108)
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.085)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.099)
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