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

Produse ce potrivesc criteriilor de căutare


Penar Rigid Jaxon pentru Riguri 25x9x5cm

Penar Rigid Jaxon pentru Riguri 25x9x5cm

rh-320
Livrare imediată!

72,99Lei

SHAD JAXON EXTREME SOFT DROP SHOT 2B 13.5CM -41%

SHAD JAXON EXTREME SOFT DROP SHOT 2B 13.5CM

td-02b
Livrare imediată!

18,00Lei(-41%) 10,59Lei

Carlige Jaxon Sumato Chinu Cu Ochet Negru Nr.6

Carlige Jaxon Sumato Chinu Cu Ochet Negru Nr.6

hy-hbc06
Livrare imediată!

4,00Lei

LINGURA JAXON CAST 10GR 1G

LINGURA JAXON CAST 10GR 1G

bw-he1g
Livrare imediată!

10,00Lei

CUTIE CARLIGE JAXON CU MAGNET 15x11x2cm

CUTIE CARLIGE JAXON CU MAGNET 15x11x2cm

rh-160s
Livrare imediată!

28,00Lei

VARTEJ CU CARABINA JAXON INTERLOCK NR 10

VARTEJ CU CARABINA JAXON INTERLOCK NR 10

aj-ka10210c
Livrare imediată!

4,50Lei

Carlige Jaxon Sumato Baitholder Negru HY-HFA nr.1/0

Carlige Jaxon Sumato Baitholder Negru HY-HFA nr.1/0

hy-hfa1/0
Livrare imediată!

7,00Lei

SHAD JAXON INTENSA INB 8CM H -21%

SHAD JAXON INTENSA INB 8CM H

tg-inb075h
Livrare imediată!

20,00Lei(-21%) 15,90Lei

STRUNE FLUOROCARBON JAXON JERK 20CM 15KG 2/PLIC

STRUNE FLUOROCARBON JAXON JERK 20CM 15KG 2/PLIC

ak-prf2015
Livrare imediată!

18,00Lei

CARLIGE LEGATE JAXON METHOD FEEDER FH NR 8 0.22mm 30cm -19%

CARLIGE LEGATE JAXON METHOD FEEDER FH NR 8 0.22mm 30cm

hy-mfh08
Livrare imediată!

11,00Lei(-19%) 8,90Lei

Fir Textil Jaxon SUMATO PREMIUM 10m 0.20mm

Fir Textil Jaxon SUMATO PREMIUM 10m 0.20mm

zj-rap020c
Livrare imediată!

11,00Lei

VARTEJ STRONG JAXON CU AGRAFA DUO LOCK NR 22

VARTEJ STRONG JAXON CU AGRAFA DUO LOCK NR 22

aj-ka10322c
Livrare imediată!

7,00Lei

Set Jaxon Safety Clips

Set Jaxon Safety Clips

ac-3564
Livrare imediată!

5,50Lei

PLUTA JAXON CATFISH SU 70GR

PLUTA JAXON CATFISH SU 70GR

sp-su070
Livrare imediată!

25,00Lei

ROTATIVA JAXON ROTUS MINNOW 3B 18GR

ROTATIVA JAXON ROTUS MINNOW 3B 18GR

bo-hd3b
Livrare imediată!

15,01Lei

SUPORT LANSETA JAXON CAUCIUC AC-PC061

SUPORT LANSETA JAXON CAUCIUC AC-PC061

ac-pc061
Livrare imediată!

18,00Lei

VARTEJ STRONG JAXON CU AGRAFA DUO LOCK NR 6

VARTEJ STRONG JAXON CU AGRAFA DUO LOCK NR 6

aj-ka10306c
Livrare imediată!

9,00Lei

SET METHOD FEEDER JAXON E2 CU MATRITA SI CONECTOR 40GR

SET METHOD FEEDER JAXON E2 CU MATRITA SI CONECTOR 40GR

af-e240x
Livrare imediată!

49,00Lei

CARLIGE LEGATE JAXON METHOD FEEDER FH NR 4 0.22mm 30cm -19%

CARLIGE LEGATE JAXON METHOD FEEDER FH NR 4 0.22mm 30cm

hy-mfh04
Livrare imediată!

11,00Lei(-19%) 8,90Lei

VOBLER JAXON ATRACT MULTI PARTS XMP-B S B 12CM - 35GR -23%

VOBLER JAXON ATRACT MULTI PARTS XMP-B S B 12CM - 35GR

vr-msb120b
Livrare imediată!

49,00Lei(-23%) 37,84Lei

Afişare 1081 - 1100 din 6620 (331 pagini)
Queries: 5, Total time: 166.979 ms [By time] [By id] [By file]
1 (0.090)
SELECT data
FROM `oc_session`
WHERE session_id = '5462d18f1cc01d399d076ab354'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (144.719)
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('+jaxon' 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 (21.924)
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 1080, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.143)
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