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


CUTIE KORDA SWINGER

CUTIE KORDA SWINGER

a.kebc3
Stoc epuizat

41,38Lei

Cutie magnetica Feeder Concept 145*115*20mm

Cutie magnetica Feeder Concept 145*115*20mm

1500-77
Stoc epuizat

28,00Lei

GEANTA SAVAGE GEAR SPECIALIST SLING 20X31X15CM+1 CUTII

GEANTA SAVAGE GEAR SPECIALIST SLING 20X31X15CM+1 CUTII

a8.sg.74237
Stoc epuizat

256,30Lei

GEANTA SAVAGE GEAR SPECIALIST LURE 35 X 50 X 25CM INCL.6 CUTII

GEANTA SAVAGE GEAR SPECIALIST LURE 35 X 50 X 25CM INCL.6 CUTII

a8.sg.74236
Stoc epuizat

600,60Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 3A 18.6X10.3X3.4CM -8%

CUTIE SAVAGE GEAR PT.NALUCI TIP 3A 18.6X10.3X3.4CM

a4.sg.76771
Stoc epuizat

32,70Lei(-8%) 30,10Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 5D 27.5X18X4.5CM -28%

CUTIE SAVAGE GEAR PT.NALUCI TIP 5D 27.5X18X4.5CM

a4.sg.76777
Stoc epuizat

46,80Lei(-28%) 33,90Lei

CUTIE SAVAGE DUBLA PT.NALUCI 20,5X17.4X4,8CM

CUTIE SAVAGE DUBLA PT.NALUCI 20,5X17.4X4,8CM

a4.sg.74222
Stoc epuizat

39,64Lei

CUTIE SAVAGE DUBLA PT.NALUCI 20,5X17X4,8CM

CUTIE SAVAGE DUBLA PT.NALUCI 20,5X17X4,8CM

a4.sg.74221
Stoc epuizat

39,64Lei

CUTIE PLANO FILLER LINE SPOOL BOX W LABEL 108401

CUTIE PLANO FILLER LINE SPOOL BOX W LABEL 108401

pmc108401
Stoc epuizat

69,50Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 6B DEEP 36X22.5X5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 6B DEEP 36X22.5X5CM

a4.sg.76780
Stoc epuizat

79,97Lei

Geanta DAM Intenze Lure Carryall 44x21x24cm cu 3 Cutii

Geanta DAM Intenze Lure Carryall 44x21x24cm cu 3 Cutii

9040960341
Stoc epuizat

394,59Lei

CUTIE SAVAGE DUBLA PT.NALUCI 29,5X20,5X6,2CM

CUTIE SAVAGE DUBLA PT.NALUCI 29,5X20,5X6,2CM

a4.sg.74223
Stoc epuizat

68,29Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 6C DEEP 36X22.5X5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 6C DEEP 36X22.5X5CM

a4.sg.76781
Stoc epuizat

62,03Lei

Cutie Accesorii Jackall 1500D Double Open Black S 20x15.3x4cm

Cutie Accesorii Jackall 1500D Double Open Black S 20x15.3x4cm

a4.ja.807196993
Stoc epuizat

70,67Lei

CUTIE DAIWA MAGNETIC HOOK 13.5X9.5X1.5CM

CUTIE DAIWA MAGNETIC HOOK 13.5X9.5X1.5CM

a4.15809.815
Stoc epuizat

43,17Lei

Cutie Plano Custom Divider StowAway Thin 3700 35.6X22.8X3.5CM -16%

Cutie Plano Custom Divider StowAway Thin 3700 35.6X22.8X3.5CM

pmc377100
Stoc epuizat

67,50Lei(-16%) 57,00Lei

Cutie Plano StowAway Thin 3700 35.5X23X3.5CM

Cutie Plano StowAway Thin 3700 35.5X23X3.5CM

pmc2370100
Stoc epuizat

53,60Lei

CUTIE ACCESORII PLANO CUSTOM DIVIDER STOWAWAY LURE BOX 3600 27.9X18.4X4.4CM

CUTIE ACCESORII PLANO CUSTOM DIVIDER STOWAWAY LURE BOX 3600 27.9X18.4X4.4CM

pmc367000
Stoc epuizat

69,50Lei

Cutie Momeala Cresta Maggot Box Square 1.2L

Cutie Momeala Cresta Maggot Box Square 1.2L

006403-00320-00000
Stoc epuizat

13,30Lei

PENAR RIGURI DELPHIN RIGLUX SPACE C2G + 3 CUTII ACCESORII 30X13X8CM

PENAR RIGURI DELPHIN RIGLUX SPACE C2G + 3 CUTII ACCESORII 30X13X8CM

101002371
Stoc epuizat

106,01Lei

Afişare 1061 - 1080 din 1123 (57 pagini)
Queries: 5, Total time: 25.903 ms [By time] [By id] [By file]
1 (0.160)
SELECT data
FROM `oc_session`
WHERE session_id = '4c2f3e721bcb335183742f3ae3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.131)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (25.371)
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('+cutii' 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.150)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.091)
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