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


Lestaj BigFish Flex Jig Head 28G -15%

Lestaj BigFish Flex Jig Head 28G

13250028
Stoc epuizat

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

Lestaj BigFish Flex Jig Head 9G -15%

Lestaj BigFish Flex Jig Head 9G

13250009
Stoc epuizat

12,00Lei(-15%) 10,20Lei

Lestaj BigFish Flex Jig Head 26G -15%

Lestaj BigFish Flex Jig Head 26G

13250026
Stoc epuizat

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

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

Jig Lestat Owner Swing Head 11683 JH-10 Nr.1 1/32Oz 1.0gr

1168301
Stoc epuizat

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

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

Jig Lestat Owner Swing Head 11683 JH-10 Nr.1 1/20 Oz 1.4gr

1168302
Stoc epuizat

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

Cap Jig Quantum Screw Jig Head 15gr

Cap Jig Quantum Screw Jig Head 15gr

3148015
Stoc epuizat

31,29Lei

Cap Jig Quantum Screw Jig Head 25gr

Cap Jig Quantum Screw Jig Head 25gr

3148025
Stoc epuizat

31,29Lei

Cap Jig Quantum Screw Jig Head 35gr

Cap Jig Quantum Screw Jig Head 35gr

3148035
Stoc epuizat

31,29Lei

VOBLER COLMIC HERAKLES STRIKE 90SK 9cm 11gr Pink Head

VOBLER COLMIC HERAKLES STRIKE 90SK 9cm 11gr Pink Head

arhkbl01
Stoc epuizat

48,00Lei

Shad Biwaa Divinator Medium 18cm/35g culoare Red Head

Shad Biwaa Divinator Medium 18cm/35g culoare Red Head

b000550
Stoc epuizat

52,00Lei

VOBLER COLMIC HERAKLES LIP 95S 9.5cm 12gr Red Head

VOBLER COLMIC HERAKLES LIP 95S 9.5cm 12gr Red Head

arhkat03
Stoc epuizat

46,01Lei

Shad Quantum Joker 4g 12cm Fudge Head

Shad Quantum Joker 4g 12cm Fudge Head

8163239201
Stoc epuizat

8,07Lei

Jig Head Nevis Master 3/0 3gr Rosu

Jig Head Nevis Master 3/0 3gr Rosu

8560-342
Stoc epuizat

6,90Lei

Vobler Salmo Slider SD7F RH Red head 7cm 17g

Vobler Salmo Slider SD7F RH Red head 7cm 17g

84577192
Stoc epuizat

58,00Lei

Spinnertail BIWAA DIVINATOR MINI 9.5cm 9gr 15 Red Head

Spinnertail BIWAA DIVINATOR MINI 9.5cm 9gr 15 Red Head

b001305
Stoc epuizat

37,00Lei

JIG SAVAGE BALL JIG HEAD TOURNAMENT NR 2/0 7,5G 25BUC

JIG SAVAGE BALL JIG HEAD TOURNAMENT NR 2/0 7,5G 25BUC

f2.sg.61911
Stoc epuizat

74,26Lei

Cap Jig Savage Gear Screw Head 60g

Cap Jig Savage Gear Screw Head 60g

sg.71924
Stoc epuizat

12,02Lei

SHAD SAVAGE LB CANNIBAL 10CM/9G/RED HEAD/4BUC/PLIC

SHAD SAVAGE LB CANNIBAL 10CM/9G/RED HEAD/4BUC/PLIC

f1.sg.67021
Stoc epuizat

22,78Lei

Shad Quantum 4street B-Ass Shad 61mm Red Head -36%

Shad Quantum 4street B-Ass Shad 61mm Red Head

3337209
Stoc epuizat

31,29Lei(-36%) 19,90Lei

Cicada Wizard BLD Spin Bream White Red-Head 5.5cm 20g

Cicada Wizard BLD Spin Bream White Red-Head 5.5cm 20g

84230207
Stoc epuizat

19,10Lei

Afişare 501 - 520 din 619 (31 pagini)
Queries: 4, Total time: 15.008 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '4dda7f9384426f04959a36498b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (14.655)
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('+head' 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 (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