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


Carlig Owner Chika 50363 Nr 17 -25%

Carlig Owner Chika 50363 Nr 17

5036309
Livrare imediată!

8,29Lei(-25%) 6,22Lei

Rig Feeder Owner 56931 Nr.10 0.20 FD-53 Quick Stop BL -29%

Rig Feeder Owner 56931 Nr.10 0.20 FD-53 Quick Stop BL

5693510
Livrare imediată!

18,33Lei(-29%) 13,02Lei

Carlig Owner Funa 50563 Nr 10

Carlig Owner Funa 50563 Nr 10

5056302
Livrare imediată!

10,90Lei

Jig Lestat Owner X Head 11681 JH-86 Nr.4 4gr
Exclusiv online!

Jig Lestat Owner X Head 11681 JH-86 Nr.4 4gr

1168103
Livrare 48-72 ore

22,30Lei

Carlig Owner Seigo, BH 51440, Nr. 10, 12buc/plic -23%

Carlig Owner Seigo, BH 51440, Nr. 10, 12buc/plic

5144009
Livrare imediată!

10,25Lei(-23%) 7,90Lei

Creatura Owner Yuki Bug 85mm 17 Grub White
Exclusiv online!

Creatura Owner Yuki Bug 85mm 17 Grub White

1301375594-17
Livrare 48-72 ore

27,38Lei

Carlig Owner Funa 50563 Nr 6

Carlig Owner Funa 50563 Nr 6

5056300
Livrare imediată!

10,90Lei

Rig Feeder Owner 56933 No.10 0.20 FD-62 Pellet Band BL
Exclusiv online!

Rig Feeder Owner 56933 No.10 0.20 FD-62 Pellet Band BL

12030256933-010
Livrare 48-72 ore

17,84Lei

Carlig Owner Pint-S 50922 NR 4

Carlig Owner Pint-S 50922 NR 4

5092201
Livrare imediată!

10,41Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 65 Negru

Vobler Owner Bug Eye Bait 50mm 6.5gr 65 Negru

804020210
Livrare imediată!

37,69Lei

Carlig Owner 50152 Nr.12 Amano Tenkara Eye

Carlig Owner 50152 Nr.12 Amano Tenkara Eye

5015212
Livrare imediată!

10,41Lei

Carlige Legate Owner RL340 53816 Nr.14 Fir 0.10mm

Carlige Legate Owner RL340 53816 Nr.14 Fir 0.10mm

5381614
Livrare imediată!

19,49Lei

Carlige Legate Owner S284 56911 Nr.16 Fir 0.09mm

Carlige Legate Owner S284 56911 Nr.16 Fir 0.09mm

5691105
Livrare imediată!

12,72Lei

Carlige Legate Owner S282 56910 Nr.10 Fir 0.14mm
Exclusiv online!

Carlige Legate Owner S282 56910 Nr.10 Fir 0.14mm

5691002
Livrare 48-72 ore

12,72Lei

Carlig Owner So-Chinu 50081 Nr 5 -23%

Carlig Owner So-Chinu 50081 Nr 5

5008105
Livrare imediată!

10,25Lei(-23%) 7,90Lei

Carlig Owner Sode 50257 Nr 12

Carlig Owner Sode 50257 Nr 12

5025704
Livrare imediată!

10,41Lei

Jig Lestat Owner Mushi Head 11788 JH 89 Nr.8 2gr
Exclusiv online!

Jig Lestat Owner Mushi Head 11788 JH 89 Nr.8 2gr

1178801
Livrare 48-72 ore

26,43Lei

Jig Owner Lestat 56978 Nr.1 1.50gr Round Jig Head

Jig Owner Lestat 56978 Nr.1 1.50gr Round Jig Head

56978115
Livrare imediată!

31,05Lei

Carlig Owner Furansu 50560 Nr 10
Exclusiv online!

Carlig Owner Furansu 50560 Nr 10

5056009
Livrare 48-72 ore

6,22Lei

Carlige Legate Owner RL284 53817 Nr.10 fir 0.14mm -29%

Carlige Legate Owner RL284 53817 Nr.10 fir 0.14mm

5381710
Livrare imediată!

19,49Lei(-29%) 13,90Lei

Afişare 1081 - 1100 din 1689 (85 pagini)
Queries: 5, Total time: 41.999 ms [By time] [By id] [By file]
1 (0.176)
SELECT data
FROM `oc_session`
WHERE session_id = '079010169275ed12468aeeaf2e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (35.256)
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('+owner' 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 (6.344)
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 1080, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.119)
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