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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


JIG JAXON SUMATO BLACK 7/0 15GR
Exclusiv online!

JIG JAXON SUMATO BLACK 7/0 15GR

gj-sb7/015b
Livrare 48-72 ore

15,01Lei

LANSETA JAXON GREY STREAM SPIN 2.28M 8 30G
Exclusiv online!

LANSETA JAXON GREY STREAM SPIN 2.28M 8 30G

wj-dse22830
Livrare 48-72 ore

259,00Lei

MONTURA METHOD FEEDER JAXON FIR PE FY NR 10 0.12mm 10cm
Exclusiv online!

MONTURA METHOD FEEDER JAXON FIR PE FY NR 10 0.12mm 10cm

hy-mfy10
Livrare 48-72 ore

12,99Lei

Valigeta JAXON cu 3 Sertare, 44x23x20cm

Valigeta JAXON cu 3 Sertare, 44x23x20cm

rh-303
Livrare imediată!

210,00Lei

VOBLER JAXON HS VIRTUS S OZ 4CM 8GR
Exclusiv online!

VOBLER JAXON HS VIRTUS S OZ 4CM 8GR

vj-vr04soz
Livrare 48-72 ore

33,00Lei

MOMITOR FEEDER JAXON SEMIROTUND OPEN 30GR 34x44mm 10/set
Exclusiv online!

MOMITOR FEEDER JAXON SEMIROTUND OPEN 30GR 34x44mm 10/set

aw-pa030
Livrare 48-72 ore

109,00Lei

MULINETA JAXON HARMONY HTX 400 6RUL -25%
Exclusiv online!

MULINETA JAXON HARMONY HTX 400 6RUL

kj-hrm400
Livrare 48-72 ore

305,00Lei(-25%) 229,00Lei

PLUMB ROMB JAXON CU TUB ANTITANGLE MARO 70GR 1BUC/PLIC

PLUMB ROMB JAXON CU TUB ANTITANGLE MARO 70GR 1BUC/PLIC

cp-128270
Livrare imediată!

13,99Lei

JIG TANAMI JAXON MICRO 6-2GR
Exclusiv online!

JIG TANAMI JAXON MICRO 6-2GR

ho-gm0602
Livrare 48-72 ore

23,00Lei

LINGURA JAXON SLIM CAST 5GR 0A
Exclusiv online!

LINGURA JAXON SLIM CAST 5GR 0A

bw-hg0a
Livrare 48-72 ore

8,50Lei

MOMITOR JAXON FEEDER SEMIROTUND OPEN 10GR 34x37mm 10/set
Exclusiv online!

MOMITOR JAXON FEEDER SEMIROTUND OPEN 10GR 34x37mm 10/set

aw-pa010
Livrare 48-72 ore

93,00Lei

VARF JAXON FEEDER GLASS 4.0mm 50cm Soft
Exclusiv online!

VARF JAXON FEEDER GLASS 4.0mm 50cm Soft

ak-sws400a
Livrare 48-72 ore

25,00Lei

CICADA JAXON VIBRO HOLO REFLEX 3B 15GR

CICADA JAXON VIBRO HOLO REFLEX 3B 15GR

bw-hjk03b
Livrare imediată!

15,01Lei

FIR TEXTIL JAXON HEGEMON 8X PREMIUM 10m 0.08mm 5kg
Exclusiv online!

FIR TEXTIL JAXON HEGEMON 8X PREMIUM 10m 0.08mm 5kg

zj-dep008c
Livrare 48-72 ore

17,01Lei

MORMISTE JAXON WOLFRAM PA05 C 1.5G
Exclusiv online!

MORMISTE JAXON WOLFRAM PA05 C 1.5G

mw-pa050c
Livrare 48-72 ore

140,00Lei

PLUTA CULISANTA JAXON BFF STICK BULB 4 4.00GR
Exclusiv online!

PLUTA CULISANTA JAXON BFF STICK BULB 4 4.00GR

bx25003840
Livrare 48-72 ore

5,50Lei

ROTATIVA JAXON HOLO REFLEX SWING 3K 11GR

ROTATIVA JAXON HOLO REFLEX SWING 3K 11GR

bo-hxf3k
Livrare imediată!

9,00Lei

JIG JAXON SUMATO SILVER 2-4GR 5/PLIC

JIG JAXON SUMATO SILVER 2-4GR 5/PLIC

gj-su0204n
Livrare imediată!

12,00Lei

PLUMBI PICATURA JAXON INLINE 6GR

PLUMBI PICATURA JAXON INLINE 6GR

cc-af6g
Livrare imediată!

7,00Lei

VOBLER JAXON HS CARABUS F LT 3CM 1.5GR
Exclusiv online!

VOBLER JAXON HS CARABUS F LT 3CM 1.5GR

vj-sh03flt
Livrare 48-72 ore

35,00Lei

Afişare 3881 - 3900 din 6620 (331 pagini)
Queries: 6, Total time: 275.637 ms [By time] [By id] [By file]
1 (0.091)
SELECT data
FROM `oc_session`
WHERE session_id = 'ab76ee340401e47ca79d73bd88'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.110)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (230.436)
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
5 (44.797)
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 3880, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.110)
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