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


JIG JAXON OWNER SILVER NR 1/0-8GR 4/PLIC
Exclusiv online!

JIG JAXON OWNER SILVER NR 1/0-8GR 4/PLIC

gj-ow1/008n
Livrare 48-72 ore

16,51Lei

Creatura Owner Getnet Juster Hog 58mm 10 Glow
Exclusiv online!

Creatura Owner Getnet Juster Hog 58mm 10 Glow

13013782916-10
Livrare 48-72 ore

33,03Lei

Jig Owner J Hook cod 5140 Nr.5/0

Jig Owner J Hook cod 5140 Nr.5/0

5140001
Livrare imediată!

26,76Lei

Vartej Owner Amaz Rolling Dublu W Crane Swivel 72457, Nr.22, 5.2kg, 12buc/plic -28%

Vartej Owner Amaz Rolling Dublu W Crane Swivel 72457, Nr.22, 5.2kg, 12buc/plic

410260015
Livrare imediată!

16,54Lei(-28%) 11,90Lei

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 66 Konoshiro
Exclusiv online!

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 66 Konoshiro

804020044
Livrare 48-72 ore

52,19Lei

Vartej Owner Amaz Rolling Dublu W Crane Swivel 72457, Nr.18, 12.1kg, 12buc/plic

Vartej Owner Amaz Rolling Dublu W Crane Swivel 72457, Nr.18, 12.1kg, 12buc/plic

410260013
Livrare imediată!

13,24Lei

Carlig Owner Pint Hook 53117 Nr 6 -23%

Carlig Owner Pint Hook 53117 Nr 6

5311706
Livrare imediată!

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

Jig Lestat Owner JH-82R No.8 3.5gr Mebaru Shot

Jig Lestat Owner JH-82R No.8 3.5gr Mebaru Shot

1156608
Livrare imediată!

26,43Lei

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.8, 18buc/plic

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.8, 18buc/plic

1175108
Livrare imediată!

16,55Lei

Carlige Legate Owner RL284 53817 Nr.8 fir 0.16mm

Carlige Legate Owner RL284 53817 Nr.8 fir 0.16mm

5381708
Livrare imediată!

19,49Lei

Rig Feeder Owner 56931 Nr.10 0.20 FD-51 Spear BL

Rig Feeder Owner 56931 Nr.10 0.20 FD-51 Spear BL

5693310
Livrare imediată!

19,49Lei

Vartej Owner 52481 Nr 10 Crane Swivel

Vartej Owner 52481 Nr 10 Crane Swivel

410020021
Livrare imediată!

16,98Lei

Carlig Owner CF-3 No.9/0
Exclusiv online!

Carlig Owner CF-3 No.9/0

12100256966-90
Livrare 48-72 ore

33,03Lei

Jig Jaxon cu carlig Owner Big Game carlig nr 7/0 28GR 3/PLIC -19%

Jig Jaxon cu carlig Owner Big Game carlig nr 7/0 28GR 3/PLIC

gj-og7/028bc
Livrare imediată!

22,00Lei(-19%) 17,90Lei

Vobler Owner Zip n Ziggy 5257 ZZ-80 80mm 7.5gr 13 Baby Bass
Exclusiv online!

Vobler Owner Zip n Ziggy 5257 ZZ-80 80mm 7.5gr 13 Baby Bass

804020093
Livrare 48-72 ore

51,90Lei

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.1/0, 12buc/plic -26%

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.1/0, 12buc/plic

1175110
Livrare imediată!

15,51Lei(-26%) 11,42Lei

Rig Feeder Owner 56933 No.8 0.22 FD-63 Quick Stop BL
Exclusiv online!

Rig Feeder Owner 56933 No.8 0.22 FD-63 Quick Stop BL

12030256933-108
Livrare 48-72 ore

21,97Lei

Jig Lestat Owner Swing Head 11683 JH-10 Nr.1 1/16 Oz 1.8gr -29%

Jig Lestat Owner Swing Head 11683 JH-10 Nr.1 1/16 Oz 1.8gr

1168303
Livrare imediată!

18,90Lei(-29%) 13,42Lei

Creatura Owner Getnet Juster Hog 58mm 04 Scuppernong

Creatura Owner Getnet Juster Hog 58mm 04 Scuppernong

13013782916-04
Livrare imediată!

33,03Lei

Rig Feeder Owner 56931 Nr.16 0.16 FD-53 Quick Stop BL
Exclusiv online!

Rig Feeder Owner 56931 Nr.16 0.16 FD-53 Quick Stop BL

5693516
Livrare 48-72 ore

18,33Lei

Afişare 941 - 960 din 1684 (85 pagini)
Queries: 5, Total time: 41.750 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '2c7c560c642c18f07a1ec87b51'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (35.047)
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('+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.379)
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 940, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.135)
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