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

Produse ce potrivesc criteriilor de căutare


Lanseta Feeder Matrix Aquos Ultra-X 3.30m 50g 2 Plus 2Seg

Lanseta Feeder Matrix Aquos Ultra-X 3.30m 50g 2 Plus 2Seg

grd137
Livrare imediată!

377,90Lei

MULINETA TRABUCCO MARVEL FDR 4000 -16%

MULINETA TRABUCCO MARVEL FDR 4000

034-34-400
Livrare imediată!

210,00Lei(-16%) 176,91Lei

Lanseta Benzar No Limit Method Feeder 3.60m 100-250g 3+5buc

Lanseta Benzar No Limit Method Feeder 3.60m 100-250g 3+5buc

12344360
Livrare imediată!

472,00Lei

Agrafa cu Vartej si Margea Culisanta Spro C-Tec Feeder Easy Parts, Marime M, 5buc/pac

Agrafa cu Vartej si Margea Culisanta Spro C-Tec Feeder Easy Parts, Marime M, 5buc/pac

004707-00007-00000
Livrare imediată!

11,50Lei

Carlige Gamakatsu 1010G 25BUC/PLIC nr 12

Carlige Gamakatsu 1010G 25BUC/PLIC nr 12

gk.146509.12
Livrare imediată!

17,95Lei

SUPORT GURU PENTRU FEEDER

SUPORT GURU PENTRU FEEDER

a6.gu.grpfx
Livrare imediată!

125,41Lei

Mulineta Dome Gabor TF Long Cast LCS 6500
Exclusiv online!

Mulineta Dome Gabor TF Long Cast LCS 6500

2506-665
Livrare 48-72 ore

531,00Lei

COS FEEDER GURU GRIPPER LESTAT L 1 OZ

COS FEEDER GURU GRIPPER LESTAT L 1 OZ

a.gu.ggfl1
Livrare imediată!

20,87Lei

Mulineta Tica Galant 3000 -9%

Mulineta Tica Galant 3000

glat3000
Livrare imediată!

325,00Lei(-9%) 295,91Lei

Conector Rapid Feeder Nevis

Conector Rapid Feeder Nevis

8100-145
Livrare imediată!

5,00Lei

VARF COLMIC PRO FEEDER 2 1/2oz ROSU
Exclusiv online!

VARF COLMIC PRO FEEDER 2 1/2oz ROSU

catip02e
Livrare 48-72 ore

49,00Lei

FIR COLMIC FEEDER PRO AT70 250M 0.260mm

FIR COLMIC FEEDER PRO AT70 250M 0.260mm

nyfep0260
Livrare imediată!

54,00Lei

LANSETA CORMORAN SPORTLINE FEEDER 3.60M/40-120G 3+3SEG

LANSETA CORMORAN SPORTLINE FEEDER 3.60M/40-120G 3+3SEG

c.24.0120365
Livrare imediată!

175,35Lei

Stopere Montura Cu Anou Extra Carp

Stopere Montura Cu Anou Extra Carp

ec2567
Livrare imediată!

8,00Lei

MULINETA OKUMA CEYMAR XT FD 8RUL/325MX030MM -17%

MULINETA OKUMA CEYMAR XT FD 8RUL/325MX030MM

cxt-55fd
Livrare imediată!

359,09Lei(-17%) 299,00Lei

SUPORT LANSETE FATA FEEDER CARP ZOOM COMPETITION 30CM

SUPORT LANSETE FATA FEEDER CARP ZOOM COMPETITION 30CM

cz1369
Livrare imediată!

28,00Lei

Lanseta Arno Intruder Feeder Heavy 30-80gr 3.90m

Lanseta Arno Intruder Feeder Heavy 30-80gr 3.90m

12340390
Livrare imediată!

173,00Lei

Set Monturi Benzar Method Feeder Matrita Si Pelete Nr.10 7.65kg 60g

Set Monturi Benzar Method Feeder Matrita Si Pelete Nr.10 7.65kg 60g

79805060
Livrare imediată!

52,00Lei

MULINETA JAXON RED CARP FRXL 400 8RUL
Exclusiv online!

MULINETA JAXON RED CARP FRXL 400 8RUL

kj-rca400
Livrare 48-72 ore

254,01Lei

MULINETA TRABUCCO KRIUS FA 5500

MULINETA TRABUCCO KRIUS FA 5500

034-35-550
Livrare imediată!

350,00Lei

Afişare 3961 - 3980 din 12491 (625 pagini)
Queries: 6, Total time: 320.542 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = 'ad51d8ed52c209cfe4d59c8082'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (268.925)
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 = '3' AND (MATCH(pd.tag) AGAINST('+feeder' 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 (51.179)
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 3960, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.117)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38