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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Spinnertail Konger Boogie, 006 Black Perch, 10g
Exclusiv online!

Spinnertail Konger Boogie, 006 Black Perch, 10g

131606381102006
Livrare 48-72 ore

30,33Lei

Tambur de Rezerva Hardy Fortuna Regent Fly Reel Black 10000
Exclusiv online!

Tambur de Rezerva Hardy Fortuna Regent Fly Reel Black 10000

1578170
Livrare 7-14 zile

1.189,96Lei

Tricou BKK Casual Legacy, Black, Marime M
Exclusiv online!

Tricou BKK Casual Legacy, Black, Marime M

6941780925692
Livrare 48-72 ore

155,00Lei

Tricou Fox Collection T Black & Orange, Marime 3XL

Tricou Fox Collection T Black & Orange, Marime 3XL

ccl183
Livrare imediată!

94,46Lei

Tricou Kumu The Last Cast Black, Marime XL

Tricou Kumu The Last Cast Black, Marime XL

tstlc104
Livrare imediată!

130,00Lei

Varf Rezerva Daiwa pentru Lanseta Feeder Black Widow, Red, 3.60m/3.90m/150g
Exclusiv online!

Varf Rezerva Daiwa pentru Lanseta Feeder Black Widow, Red, 3.60m/3.90m/150g

d.11789.003r
Livrare 24-48 ore

45,36Lei

Vobler Jackall D-Bill Shad 55SR SP, Double Clutch Gold & Black, 5.5cm, 5.5g -20%
Exclusiv online!

Vobler Jackall D-Bill Shad 55SR SP, Double Clutch Gold & Black, 5.5cm, 5.5g

ja.807132304
Livrare 24-48 ore

107,98Lei(-20%) 86,38Lei

Vobler Jackall TN Slim 8, HL Glod Black, 8cm, 12g
Exclusiv online!

Vobler Jackall TN Slim 8, HL Glod Black, 8cm, 12g

ja.807118834
Livrare 24-48 ore

99,67Lei

Ancora VMC 7547 Black/Nickel UV Nr.8, 3buc/pac

Ancora VMC 7547 Black/Nickel UV Nr.8, 3buc/pac

7547 bn-uv8
Livrare imediată!

45,01Lei

Carlige Mikado Sensual Iseama Black Nikel, Nr.1/0, 10buc/plic

Carlige Mikado Sensual Iseama Black Nikel, Nr.1/0, 10buc/plic

hs10071-1/0b
Livrare imediată!

6,00Lei

Carlige Somn Konger Dread Cat Bust Black Nickel Nr.10/0, 3buc/plic
Exclusiv online!

Carlige Somn Konger Dread Cat Bust Black Nickel Nr.10/0, 3buc/plic

121006865000010
Livrare 48-72 ore

15,42Lei

Carlige Somn Konger Dread Cat Power Game Black Nickel Nr.8/0, 3buc/plic
Exclusiv online!

Carlige Somn Konger Dread Cat Power Game Black Nickel Nr.8/0, 3buc/plic

121006865000018
Livrare 48-72 ore

18,23Lei

Cicada Fox Rage Big Eye Blade, 17g, 6cm, UV Black & Gold

Cicada Fox Rage Big Eye Blade, 17g, 6cm, UV Black & Gold

nct022
Livrare imediată!

26,97Lei

Cicada Fox Rage Big Eye Blade, 8g, 4cm, UV Black & Gold

Cicada Fox Rage Big Eye Blade, 8g, 4cm, UV Black & Gold

nct018
Livrare imediată!

24,26Lei

Cicada Live Target Sonic Shad Blade Bait, 5.5cm, 14g, Violet / Black Back
Exclusiv online!

Cicada Live Target Sonic Shad Blade Bait, 5.5cm, 14g, Violet / Black Back

lt.sns55sk240
Livrare 24-48 ore

48,99Lei

Cicada Live Target Sonic Shad Blade Bait, 5cm, 10g, Silver / Black
Exclusiv online!

Cicada Live Target Sonic Shad Blade Bait, 5cm, 10g, Silver / Black

lt.sns50sk202
Livrare 24-48 ore

48,99Lei

Creatura Berkley PowerBait Ice Swordtail, Black Gold, 3cm, 14buc/plic -17%

Creatura Berkley PowerBait Ice Swordtail, Black Gold, 3cm, 14buc/plic

1398963
Livrare imediată!

15,76Lei(-17%) 13,04Lei

Creatura Sakura Zarigani Craw, 112 Black Red Glitter, 78mm, 6.3g, 6buc/pac
Exclusiv online!

Creatura Sakura Zarigani Craw, 112 Black Red Glitter, 78mm, 6.3g, 6buc/pac

131934sapll500778-112
Livrare 48-72 ore

29,46Lei

Cutie Jackall 2300D Double Open M Clear Black -20%
Exclusiv online!

Cutie Jackall 2300D Double Open M Clear Black

a4.ja.807231984
Livrare 24-48 ore

100,34Lei(-20%) 80,27Lei

Cutie Jackall 2800D Tackle M Clear Black -20%
Exclusiv online!

Cutie Jackall 2800D Tackle M Clear Black

a4.ja.807232011
Livrare 24-48 ore

107,42Lei(-20%) 85,94Lei

Afişare 681 - 700 din 4758 (238 pagini)
Queries: 5, Total time: 148.162 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = 'f7e4bd536397f55d45d68c66a1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (126.402)
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('+black' 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 (21.395)
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 680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.146)
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