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


VARGA JAXON FLOAT ACADEMY GTX 7.80 M

VARGA JAXON FLOAT ACADEMY GTX 7.80 M

wj-fap800tx
Stoc epuizat

530,00Lei

CRACAN JAXON TELE VARF CUI V FILETANT 60-105CM

CRACAN JAXON TELE VARF CUI V FILETANT 60-105CM

pz-poa100b
Stoc epuizat

29,00Lei

LANSETA JAXON INTENSA GTX METHOD FEEDER 3.60M 20-60GR 3Seg 3Varfuri

LANSETA JAXON INTENSA GTX METHOD FEEDER 3.60M 20-60GR 3Seg 3Varfuri

wj-ixf360060
Stoc epuizat

277,00Lei

GALEATA JAXON PESTISORI PANARO 7L

GALEATA JAXON PESTISORI PANARO 7L

rw-1167v
Stoc epuizat

95,00Lei

PLASA PVA FAST WIDE MESH REINCARCARE 44mm 5M JAXON

PLASA PVA FAST WIDE MESH REINCARCARE 44mm 5M JAXON

lc-pva016
Stoc epuizat

64,00Lei

JUVELNIC JAXON ECO 4 8MM 35X80CM

JUVELNIC JAXON ECO 4 8MM 35X80CM

ps-jla0804
Stoc epuizat

39,00Lei

PLASA PVA FAST AVARAGE MESH REINCARCARE 44mm 5M JAXON

PLASA PVA FAST AVARAGE MESH REINCARCARE 44mm 5M JAXON

lc-pva017
Stoc epuizat

55,00Lei

SUPORT LANSETA JAXON V

SUPORT LANSETA JAXON V

al-v1
Stoc epuizat

12,00Lei

HUSA LANSETE JAXON X-TEAM 3 COMPARTIMENTE 145CM XAM

HUSA LANSETE JAXON X-TEAM 3 COMPARTIMENTE 145CM XAM

uj-xam145
Stoc epuizat

181,00Lei

SET FILETAT CUTIT FORFECA ASCUTITOR JAXON 101X

SET FILETAT CUTIT FORFECA ASCUTITOR JAXON 101X

aj-ns101x
Stoc epuizat

72,99Lei

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

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

uj-xar6375
Stoc epuizat

137,00Lei

INELE JAXON LANSETE FLY NR.10

INELE JAXON LANSETE FLY NR.10

ok-fl10
Stoc epuizat

9,00Lei

JIG JAXON OWNER SILVER NR 3/0-12GR 3/PLIC

JIG JAXON OWNER SILVER NR 3/0-12GR 3/PLIC

gj-ow3/012n
Stoc epuizat

15,01Lei

LANSETA JAXON SYMBIAN HX RAZOR SPIN 2.42M 4-18GR -25%

LANSETA JAXON SYMBIAN HX RAZOR SPIN 2.42M 4-18GR

wj-syr24218
Stoc epuizat

340,99Lei(-25%) 256,00Lei

MASA JAXON CRAP MONTURI 40x30CM

MASA JAXON CRAP MONTURI 40x30CM

ak-kzh104b
Stoc epuizat

145,00Lei

TUNEL PLASA PVA JAXON FAST CU INCARCATOR 23mm 5M

TUNEL PLASA PVA JAXON FAST CU INCARCATOR 23mm 5M

lc-pva076
Stoc epuizat

59,00Lei

ANCORA JAXON SUMATO ROSU RD NR 4/0

ANCORA JAXON SUMATO ROSU RD NR 4/0

hy-kf4/0rd
Stoc epuizat

36,00Lei

Ochelari Polarizanti X04 Xm Extra Galben

Ochelari Polarizanti X04 Xm Extra Galben

ak-okx04xm
Stoc epuizat

55,00Lei

LANSETA JAXON GREY STREAM ULTRA SPIN 2.28M 2 12G

LANSETA JAXON GREY STREAM ULTRA SPIN 2.28M 2 12G

wj-dsb22812
Stoc epuizat

250,00Lei

LINIE VARGA JAXON PRO FLOAT ZB 1.0GR 8M 18-14MM NR 10

LINIE VARGA JAXON PRO FLOAT ZB 1.0GR 8M 18-14MM NR 10

sf-zb010
Stoc epuizat

16,01Lei

Afişare 2541 - 2560 din 6621 (332 pagini)
Queries: 5, Total time: 175.407 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = 'c73745dee1def588c01ae6592f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (174.905)
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.172)
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
5 (0.119)
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