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


INELE JAXON OVALE MICRO MONTURI -30%

INELE JAXON OVALE MICRO MONTURI

ac-359020a
Stoc epuizat

11,31Lei(-30%) 7,90Lei

JIG JAXON OWNER MICRO BLACK NR 8-3.5GR 5/PLIC

JIG JAXON OWNER MICRO BLACK NR 8-3.5GR 5/PLIC

gj-op08035bc
Stoc epuizat

18,50Lei

CAP JIG JAXON CHEBURASKA 20GR 3/PLIC

CAP JIG JAXON CHEBURASKA 20GR 3/PLIC

gj-xd20m
Stoc epuizat

17,01Lei

Cutie Jaxon Fly 2B 11x8x4cm

Cutie Jaxon Fly 2B 11x8x4cm

rj-hb02b
Stoc epuizat

57,00Lei

NADA JAXON METHOD FEEDER READY TURBO BREAM 750gr

NADA JAXON METHOD FEEDER READY TURBO BREAM 750gr

fm-zr08
Stoc epuizat

25,00Lei

TRICOU JAXON PIKE L

TRICOU JAXON PIKE L

ur-kb005m
Stoc epuizat

57,00Lei

Carlige Jaxon Sumato Sode Crystal Negru nr.10 HY-HAE10

Carlige Jaxon Sumato Sode Crystal Negru nr.10 HY-HAE10

hy-hae10
Stoc epuizat

3,50Lei

SONDA JAXON ADANCIME CU NEOPREN 40GR

SONDA JAXON ADANCIME CU NEOPREN 40GR

ck-ab40
Stoc epuizat

10,00Lei

VOBLER JAXON KARAS F GFT 11CM-39GR

VOBLER JAXON KARAS F GFT 11CM-39GR

vj-ka11fgft
Stoc epuizat

46,01Lei

VOBLER JAXON PIKE 2-SEC F PL 16CM-30GR

VOBLER JAXON PIKE 2-SEC F PL 16CM-30GR

vj-pj16fpl
Stoc epuizat

51,00Lei

JIG JAXON OWNER SILVER NR 1/0-6GR 4/PLIC

JIG JAXON OWNER SILVER NR 1/0-6GR 4/PLIC

gj-ow1/006n
Stoc epuizat

16,01Lei

LINGURA JAXON HR PRO SPIN DOUBLE HMX 1A 20GR

LINGURA JAXON HR PRO SPIN DOUBLE HMX 1A 20GR

bw-hmx1a
Stoc epuizat

12,00Lei

LINGURA JAXON HR PRO SPIN HHX 2C 22GR

LINGURA JAXON HR PRO SPIN HHX 2C 22GR

bw-hhx2c
Stoc epuizat

6,50Lei

Carlige Jaxon Sumato Chinu Negru nr.10

Carlige Jaxon Sumato Chinu Negru nr.10

hy-hbb10
Stoc epuizat

3,50Lei

MOMITOR JAXON FEEDER OVAL 100GR 32X57mm 10BUC/PLIC

MOMITOR JAXON FEEDER OVAL 100GR 32X57mm 10BUC/PLIC

aw-oc100
Stoc epuizat

132,99Lei

VOBLER JAXON CARPAN F W 9CM-27GR

VOBLER JAXON CARPAN F W 9CM-27GR

vj-ca09fw
Stoc epuizat

39,00Lei

LANSETA JAXON GREY STREAM SPIN 2.85M 8-30GR

LANSETA JAXON GREY STREAM SPIN 2.85M 8-30GR

wj-dse28530
Stoc epuizat

299,00Lei

MOMITOR JAXON METHOD FEEDER F1 20GR 2/SET

MOMITOR JAXON METHOD FEEDER F1 20GR 2/SET

af-f120
Stoc epuizat

32,00Lei

SHAD JAXON EXTREME SOFT TG-B 5.5CM D -30%

SHAD JAXON EXTREME SOFT TG-B 5.5CM D

tg-b050d
Stoc epuizat

22,00Lei(-30%) 15,40Lei

VOBLER JAXON HS CARABUS F KT 3CM 1.5GR

VOBLER JAXON HS CARABUS F KT 3CM 1.5GR

vj-sh03fkt
Stoc epuizat

35,00Lei

Afişare 4221 - 4240 din 6627 (332 pagini)
Queries: 4, Total time: 148.313 ms [By time] [By id] [By file]
1 (0.514)
SELECT data
FROM `oc_session`
WHERE session_id = '3c11e9cee707d49fc431a31d75'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.379)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (147.247)
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('+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 (0.173)
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