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 300 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 - Kryston

Produse ce potrivesc criteriilor de căutare


Pluta Balsa Mostiro Flexi Elite V 4.00Gr

Pluta Balsa Mostiro Flexi Elite V 4.00Gr

2420550640000-bucxxx
Livrare imediată!

5,00Lei

Varf, Feeder, Sportex, Carboflex, Classx, Feeder, 3.90m/1.5oz, cx3906a1, Varfuri Feeder, Varfuri Feeder Sportex, Sportex
Exclusiv online!

Varf, Feeder, Sportex, Carboflex, Classx, Feeder, 3.90m/1.5oz, cx3906a1, Varfuri Feeder, Varfuri Feeder Sportex, Sportex

cx3906a1
Livrare 48-72 ore

69,00Lei

WAGLER, COLMIC, SINFLEX, IBERIA, GR, 10, gciv0210, Plute Stationar, Plute Stationar Colmic, Colmic

WAGLER, COLMIC, SINFLEX, IBERIA, GR, 10, gciv0210, Plute Stationar, Plute Stationar Colmic, Colmic

gciv0210
Livrare imediată!

21,00Lei

Vartej, cu, Anou, CPK, C-Lock, Flexi, Swivel, 999896, Vartejuri, Vartejuri CPK, Vartejuri CPK, CPK

Vartej, cu, Anou, CPK, C-Lock, Flexi, Swivel, 999896, Vartejuri, Vartejuri CPK, Vartejuri CPK, CPK

999896
Livrare imediată!

16,01Lei

SPINNER BAIT JAXON REFLEX 2A HKG2A
Exclusiv online!

SPINNER BAIT JAXON REFLEX 2A HKG2A

bo-hkg2a
Livrare 48-72 ore

22,00Lei

Fir monofilament Climax CULT CRAP FLEXI CHOD MONO HOOKLINK 20m 0.50mm 25lb
Exclusiv online!

Fir monofilament Climax CULT CRAP FLEXI CHOD MONO HOOKLINK 20m 0.50mm 25lb

8700-10002-050
Livrare 48-72 ore

31,00Lei

PLUTE MOSTIRO FLEXI ELITE R 2.5GR 2 BUC
Exclusiv online!

PLUTE MOSTIRO FLEXI ELITE R 2.5GR 2 BUC

2420550525000-2
Livrare 48-72 ore

10,50Lei

ROTATIVA JAXON HOLO REFLEX SWING 1A 4GR

ROTATIVA JAXON HOLO REFLEX SWING 1A 4GR

bo-hxf1a
Livrare imediată!

7,00Lei

Twister, Berkley, Flex, Cut, Shad, 7.5, Cm, Smelt, 100, Buc, 1303789, Shad-uri, Shad-uri Berkley, Berkley -20%
Exclusiv online!

Twister, Berkley, Flex, Cut, Shad, 7.5, Cm, Smelt, 100, Buc, 1303789, Shad-uri, Shad-uri Berkley, Berkley

1303789
Livrare 48-72 ore

236,30Lei(-20%) 189,04Lei

SPINNER BAIT JAXON REFLEX 2B
Exclusiv online!

SPINNER BAIT JAXON REFLEX 2B

bo-hks2b
Livrare 48-72 ore

23,00Lei

Lingura, Rotativa, 10gr, DAM, Effzett, Standard, Reflex, Silver, 8035124104, Lingurite Rotative, Lingurite Rotative DAM, DAM
Twister, Berkley, Flex, Cut, Shad, 7.5, Cm, Pearl, 100, Buc, 1303790, Shad-uri, Shad-uri Berkley, Berkley -20%
Exclusiv online!

Twister, Berkley, Flex, Cut, Shad, 7.5, Cm, Pearl, 100, Buc, 1303790, Shad-uri, Shad-uri Berkley, Berkley

1303790
Livrare 48-72 ore

236,30Lei(-20%) 189,04Lei

Lestaj BigFish Flex Jig Head 20G -15%

Lestaj BigFish Flex Jig Head 20G

13250020
Livrare imediată!

20,00Lei(-15%) 17,01Lei

SPINNER BAIT JAXON REFLEX 1B
Exclusiv online!

SPINNER BAIT JAXON REFLEX 1B

bo-hks1b
Livrare 48-72 ore

20,00Lei

Cutie, Flexibila, Black, Cat, Flex, Box, Medium, 24x6x13cm, 8061070, Cutii, Cutii Black Cat, Black Cat

Cutie, Flexibila, Black, Cat, Flex, Box, Medium, 24x6x13cm, 8061070, Cutii, Cutii Black Cat, Black Cat

8061070
Livrare imediată!

53,78Lei

SPINNER BAIT JAXON REFLEX 2A
Exclusiv online!

SPINNER BAIT JAXON REFLEX 2A

bo-hks2a
Livrare 48-72 ore

23,00Lei

Fir monofilament Climax CULT CRAP FLEXI CHOD MONO HOOKLINK 20m 0.60mm 35lb
Exclusiv online!

Fir monofilament Climax CULT CRAP FLEXI CHOD MONO HOOKLINK 20m 0.60mm 35lb

8700-10002-060
Livrare 48-72 ore

31,00Lei

ROTATIVA JAXON HOLO REFLEX SWING 1C 4GR

ROTATIVA JAXON HOLO REFLEX SWING 1C 4GR

bo-hxf1c
Livrare imediată!

7,00Lei

PLUTE MOSTIRO FLEXI ELITE R 4GR(10 BUC)
Exclusiv online!

PLUTE MOSTIRO FLEXI ELITE R 4GR(10 BUC)

2420550540000
Livrare 48-72 ore

51,00Lei

Lestaj BigFish Flex Jig Head 7G -15%

Lestaj BigFish Flex Jig Head 7G

13250007
Livrare imediată!

10,00Lei(-15%) 8,50Lei

Afişare 141 - 160 din 539 (27 pagini)
Queries: 6, Total time: 188.318 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = '5c6737826d7eb45e644f72a08c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.084)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (185.626)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%flex%") 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:698
5 (2.261)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.140)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38