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 - cahkbr54

Produse ce potrivesc criteriilor de căutare


MULINETA JAXON BLACK SHADOW FLY 7 8

MULINETA JAXON BLACK SHADOW FLY 7 8

kj-bsf7/8
Stoc epuizat

258,00Lei

SNUR MUSCA JAXON EASY CAST 100FT/30.48m 4F WFX-FLOATING

SNUR MUSCA JAXON EASY CAST 100FT/30.48m 4F WFX-FLOATING

nm-1wfx04f
Stoc epuizat

170,00Lei

SNUR VARIVAS FLY ULTIMATTE DISTANCE SAND WF-6-F 27M -25%

SNUR VARIVAS FLY ULTIMATTE DISTANCE SAND WF-6-F 27M

v32swf6f
Stoc epuizat

335,00Lei(-25%) 251,30Lei

SNUR MUSCA JAXON EASY CAST 90FT/27.43m 5 WF-SINKING

SNUR MUSCA JAXON EASY CAST 90FT/27.43m 5 WF-SINKING

nm-1wf05s
Stoc epuizat

116,00Lei

CARLIGE KAMASAN FLY B110 NR 12 /25BUC

CARLIGE KAMASAN FLY B110 NR 12 /25BUC

khfb110012
Stoc epuizat

21,00Lei

MULINETA JAXON TRADA MASTER 7 8

MULINETA JAXON TRADA MASTER 7 8

kj-trb7/8
Stoc epuizat

109,00Lei

Streamer Zebco M Rig Nr2/0 Silver Red

Streamer Zebco M Rig Nr2/0 Silver Red

3441000
Stoc epuizat

13,28Lei

CARLIGE KAMASAN FLY B160 NR 10 /25BUC

CARLIGE KAMASAN FLY B160 NR 10 /25BUC

khfb160010
Stoc epuizat

21,00Lei

Fir Scierra Leader Trout 018MM/2.3KG 9m

Fir Scierra Leader Trout 018MM/2.3KG 9m

a.sie.27796
Stoc epuizat

26,33Lei

INAINTAS MUSCA JAXON CONIC 270CM 0.182-0.53MM

INAINTAS MUSCA JAXON CONIC 270CM 0.182-0.53MM

nm-19ft4x
Stoc epuizat

10,50Lei

CARLIGE VARIVAS FLY 2400V 2X-1X FINE NR 16 MICRO BARB

CARLIGE VARIVAS FLY 2400V 2X-1X FINE NR 16 MICRO BARB

vcv240016
Stoc epuizat

25,00Lei

CARLIGE VARIVAS FLY 2500V 3X FINE NR 12 V-CUT

CARLIGE VARIVAS FLY 2500V 3X FINE NR 12 V-CUT

vcv250012
Stoc epuizat

25,00Lei

CARLIGE VARIVAS FLY 2500V 3X FINE NR 8 V-CUT

CARLIGE VARIVAS FLY 2500V 3X FINE NR 8 V-CUT

vcv250008
Stoc epuizat

26,00Lei

Fir Scierra Leader Trout 020MM/2.8KG 9m

Fir Scierra Leader Trout 020MM/2.8KG 9m

a.sie.27797
Stoc epuizat

26,33Lei

Fir Scierra Leader Trout 012MM/0.9KG 9m

Fir Scierra Leader Trout 012MM/0.9KG 9m

a.sie.27793
Stoc epuizat

26,33Lei

Carlige pentru Musca Mustad Bronz Forjat, Nr.14

Carlige pentru Musca Mustad Bronz Forjat, Nr.14

m.r43.94831.14
Stoc epuizat

18,24Lei

CARLIG MUSTAD BRONZ FORJAT CURBAT PT. MUSCA NR.14

CARLIG MUSTAD BRONZ FORJAT CURBAT PT. MUSCA NR.14

m.co68.14
Stoc epuizat

18,24Lei

CARLIGE KAMASAN FLY B175 NR 6 25BUC

CARLIGE KAMASAN FLY B175 NR 6 25BUC

khfb175006
Stoc epuizat

21,00Lei

CARLIGE VARIVAS FLY 2200BL 2X-3X FINE NR 20 F/BARB

CARLIGE VARIVAS FLY 2200BL 2X-3X FINE NR 20 F/BARB

vcbl220020
Stoc epuizat

24,00Lei

Fir Scierra Leader Trout 022MM/3.2KG 9m

Fir Scierra Leader Trout 022MM/3.2KG 9m

a.sie.27798
Stoc epuizat

26,33Lei

Afişare 501 - 520 din 592 (30 pagini)
Queries: 6, Total time: 16.020 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '21c85c57377f5b6433a15614c2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (13.213)
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('+musca' 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 (2.357)
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 500, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.137)
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