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


CARLIGE JAXON SUMATO ROUND NR 4 maro
Exclusiv online!

CARLIGE JAXON SUMATO ROUND NR 4 maro

hy-hea04
Livrare 48-72 ore

4,00Lei

MOMITOR CU PLUMB JAXON INT. 40GR 6.5cm 25/set

MOMITOR CU PLUMB JAXON INT. 40GR 6.5cm 25/set

aj-045
Livrare imediată!

187,00Lei

MOMITOR CU ANTITANGLE JAXON 20GR 30cm 25BUC/PLIC
Exclusiv online!

MOMITOR CU ANTITANGLE JAXON 20GR 30cm 25BUC/PLIC

aj-054
Livrare 48-72 ore

136,01Lei

MULINETA JAXON HERCULES 550 6RUL
Exclusiv online!

MULINETA JAXON HERCULES 550 6RUL

kj-hrc550
Livrare 48-72 ore

382,00Lei

SPIN MOMEALA JAXON CU INEL SILICON 12buc/plic 0.6x10mm

SPIN MOMEALA JAXON CU INEL SILICON 12buc/plic 0.6x10mm

ac-pc091b
Livrare imediată!

13,99Lei

PLUMBI FLAT HEXAGONAL JAXON INLINE 120g 1buc/plic

PLUMBI FLAT HEXAGONAL JAXON INLINE 120g 1buc/plic

cc-ac120g
Livrare imediată!

11,00Lei

Mulineta Tica EZI Surf 8000, 4.4:1, 2rul
Exclusiv online!

Mulineta Tica EZI Surf 8000, 4.4:1, 2rul

es8000
Livrare 48-72 ore

165,01Lei

Surub Filetant Metalic cu Inel Mostiro Bait Screw, S+M, 20buc/plic

Surub Filetant Metalic cu Inel Mostiro Bait Screw, S+M, 20buc/plic

4222ms
Livrare imediată!

6,50Lei

Mulineta Tica EZI Surf 6000, 4.4:1, 2rul
Exclusiv online!

Mulineta Tica EZI Surf 6000, 4.4:1, 2rul

es6000
Livrare 48-72 ore

165,01Lei

PLUMBI FLAT HEXAGONAL JAXON INLINE 50g 1buc/plic

PLUMBI FLAT HEXAGONAL JAXON INLINE 50g 1buc/plic

cc-ac50g
Livrare imediată!

5,00Lei

SPIN MOMEALA JAXON CU INEL SILICON 12buc/plic 0.6x7mm

SPIN MOMEALA JAXON CU INEL SILICON 12buc/plic 0.6x7mm

ac-pc091a
Livrare imediată!

13,99Lei

HUSA LANSETE JAXON CRAP X-TEAM, 210CM
Exclusiv online!

HUSA LANSETE JAXON CRAP X-TEAM, 210CM

uj-xdf210
Livrare 48-72 ore

345,00Lei

PLUMBI FLAT HEXAGONAL JAXON INLINE 80g 1buc/plic

PLUMBI FLAT HEXAGONAL JAXON INLINE 80g 1buc/plic

cc-ac80g
Livrare imediată!

8,00Lei

PLUMBI FLAT HEXAGONAL JAXON INLINE 100g 1buc/plic

PLUMBI FLAT HEXAGONAL JAXON INLINE 100g 1buc/plic

cc-ac100g
Livrare imediată!

9,00Lei

Lanseta Jaxon Carp Academy X 360 3.0lbs 2seg -25%
Exclusiv online!

Lanseta Jaxon Carp Academy X 360 3.0lbs 2seg

wj-cbc360300-2x
Livrare 48-72 ore

310,99Lei(-25%) 233,00Lei

Lanseta Jaxon Carp Academy V 360 3.50lbs 3seg -25%
Exclusiv online!

Lanseta Jaxon Carp Academy V 360 3.50lbs 3seg

wj-ccc360350-3v
Livrare 48-72 ore

300,00Lei(-25%) 225,01Lei

Lanseta Jaxon Carp Academy X 360 3.0lbs 3seg -25%
Exclusiv online!

Lanseta Jaxon Carp Academy X 360 3.0lbs 3seg

wj-cbc360300-3x
Livrare 48-72 ore

281,99Lei(-25%) 211,00Lei

Lanseta Jaxon Carp Academy L 360 3.50lbs 3seg -25%
Exclusiv online!

Lanseta Jaxon Carp Academy L 360 3.50lbs 3seg

wj-cac360350-3l
Livrare 48-72 ore

402,01Lei(-25%) 302,00Lei

Lanseta Jaxon Carp Academy V 390 3.50lbs 3seg -25%
Exclusiv online!

Lanseta Jaxon Carp Academy V 390 3.50lbs 3seg

wj-ccc390350-3v
Livrare 48-72 ore

317,00Lei(-25%) 238,00Lei

Lanseta Jaxon Carp Academy V 360 3.00lbs 3seg -25%
Exclusiv online!

Lanseta Jaxon Carp Academy V 360 3.00lbs 3seg

wj-ccc360300-3v
Livrare 48-72 ore

292,00Lei(-25%) 219,00Lei

Afişare 341 - 360 din 419 (21 pagini)
Queries: 4, Total time: 19.308 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = 'd6a76ca517d6a91147e1cd3eea'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.128)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (18.887)
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('+crap +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.144)
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