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 - cahkbr54

Produse ce potrivesc criteriilor de căutare


VARF LANSETA MATRIX Spare Feeder Tip 2.0oz Carbon

VARF LANSETA MATRIX Spare Feeder Tip 2.0oz Carbon

grd180
Livrare imediată!

157,46Lei

PLUMB TIP BETISOR DELPHIN DROP SHOT BOMB 5BUC PLIC 10Gr -21%

PLUMB TIP BETISOR DELPHIN DROP SHOT BOMB 5BUC PLIC 10Gr

965926010
Livrare imediată!

15,01Lei(-21%) 11,90Lei

Plumb Delphin tip lacrima cu tub 90g -20%

Plumb Delphin tip lacrima cu tub 90g

830512090
Livrare imediată!

9,00Lei(-20%) 7,20Lei

SALTEA WAYBACK TIP VANA CU SUPORT 100X60CM
Exclusiv online!

SALTEA WAYBACK TIP VANA CU SUPORT 100X60CM

5133-001
Livrare 48-72 ore

432,01Lei

Pensa Filfishing Curbata tip Foarfeca, 15cm

Pensa Filfishing Curbata tip Foarfeca, 15cm

fil5130
Livrare imediată!

27,99Lei

FOARFECA REIVA FIR TEXTIL TIP CLESTE 12.5CM

FOARFECA REIVA FIR TEXTIL TIP CLESTE 12.5CM

8440-001
Livrare imediată!

39,60Lei

AVERTIZOR RON THOMPSON TIP STRIKE

AVERTIZOR RON THOMPSON TIP STRIKE

a.dam.44176
Livrare imediată!

19,62Lei

Lanterna Spro Compacta Cu Led Tip Lampa 80 Lumens -22%

Lanterna Spro Compacta Cu Led Tip Lampa 80 Lumens

004708-00600-00000
Livrare imediată!

83,30Lei(-22%) 64,90Lei

SALTEA TEAM FEEDER BY DOME TIP VANA CU SUPORT 100X60CM

SALTEA TEAM FEEDER BY DOME TIP VANA CU SUPORT 100X60CM

5133-002
Livrare imediată!

466,00Lei

Varf de Rezerva pentru Lansete Matrix Ethos XRS 1.0oz Tip Carbon 2.2mm -26%

Varf de Rezerva pentru Lansete Matrix Ethos XRS 1.0oz Tip Carbon 2.2mm

grd199
Livrare imediată!

107,96Lei(-26%) 79,90Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 1A SMOKE 13,8X7,7X3,1CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 1A SMOKE 13,8X7,7X3,1CM

a4.sg.76767
Livrare imediată!

18,06Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 2 A 16.1X9.1X3.1CM -19%

CUTIE SAVAGE GEAR PT.NALUCI TIP 2 A 16.1X9.1X3.1CM

a4.sg.76769
Livrare imediată!

24,60Lei(-19%) 19,90Lei

Varf de Rezerva pentru Lansete Matrix Ethos XRD 3.5oz Tip Carbon 3.4mm

Varf de Rezerva pentru Lansete Matrix Ethos XRD 3.5oz Tip Carbon 3.4mm

grd216
Livrare imediată!

107,96Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 6B 36X22.5X5CM
Exclusiv online!

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

a4.sg.76778
Livrare 24-48 ore

58,91Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 2B 16.1X9.1X3.1CM -4%

CUTIE SAVAGE GEAR PT.NALUCI TIP 2B 16.1X9.1X3.1CM

a4.sg.76770
Livrare imediată!

24,60Lei(-4%) 23,70Lei

Agrafa Rapida Lucky John Duolock Snap Tip V Nr.003, 19kg, 10buc/plic

Agrafa Rapida Lucky John Duolock Snap Tip V Nr.003, 19kg, 10buc/plic

ljp5115-003
Livrare imediată!

7,90Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 3B 18.6X10.3X3.4CM -27%

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

a4.sg.76772
Livrare imediată!

30,10Lei(-27%) 21,90Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 5A 27.5X18X4.5CM -21%

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

a4.sg.76775
Livrare imediată!

43,11Lei(-21%) 33,90Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 1/L 3.20x600mm

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 1/L 3.20x600mm

101-00-210
Livrare imediată!

69,00Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 4A 21.4X11.8X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 4A 21.4X11.8X4.5CM

a4.sg.76773
Livrare imediată!

39,50Lei

Afişare 181 - 200 din 420 (21 pagini)
Queries: 4, Total time: 9.065 ms [By time] [By id] [By file]
1 (0.076)
SELECT data
FROM `oc_session`
WHERE session_id = '4c6b7f3281f5b0b21f90bb9d3a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (8.692)
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('+tip' 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.188)
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