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


FIR TEXTIL SUFIX MATRIX PRO 135M 0.30MM 60LB 27.0KG MID.GREEN -29%

FIR TEXTIL SUFIX MATRIX PRO 135M 0.30MM 60LB 27.0KG MID.GREEN

ds1wt04141tb1p
Livrare imediată!

99,00Lei(-29%) 70,21Lei

VOBLER STRIKE PRO FLAP JACK 4CM/6G A02AT
Exclusiv online!

VOBLER STRIKE PRO FLAP JACK 4CM/6G A02AT

sp.eg128a.a02at
Livrare 24-48 ore

30,86Lei

FOARFECA PROLOGIC PENTRU FIR TEXTIL

FOARFECA PROLOGIC PENTRU FIR TEXTIL

a.pro.49960
Livrare imediată!

63,86Lei

CLESTE SAVAGE MP PRO MULTIFUNCTIONAL -23%

CLESTE SAVAGE MP PRO MULTIFUNCTIONAL

a.sg.54937
Livrare imediată!

115,11Lei(-23%) 88,90Lei

Vobler Strike Pro Rattle-N-Shad 7.5cm, culoare SM51F

Vobler Strike Pro Rattle-N-Shad 7.5cm, culoare SM51F

sp.jl027.sm51f
Livrare imediată!

42,08Lei

GEANTA MIVARDI SPINN BAG EXECUTIVE PRO
Exclusiv online!

GEANTA MIVARDI SPINN BAG EXECUTIVE PRO

m-sbexps
Livrare 48-72 ore

349,00Lei

Mulineta Team Feeder Pro Method Feeder 6000

Mulineta Team Feeder Pro Method Feeder 6000

2509-860
Livrare imediată!

422,00Lei

VOBLER STRIKE PRO 2,5CM/2G BABY PRO EVER GRASS

VOBLER STRIKE PRO 2,5CM/2G BABY PRO EVER GRASS

sp.eg036.205
Livrare imediată!

30,71Lei

Cicada Strike PRO 4.5cm, 9.6g, 986E Astro Vibe
Exclusiv online!

Cicada Strike PRO 4.5cm, 9.6g, 986E Astro Vibe

sp.pjg005a.986e
Livrare 24-48 ore

33,90Lei

Vobler Strike Pro Baby Buster, C544V, 25g, 10cm
Exclusiv online!

Vobler Strike Pro Baby Buster, C544V, 25g, 10cm

sp.eg050.c544v
Livrare 24-48 ore

50,96Lei

BURGHIU PROLOGIC -40%
Exclusiv online!

BURGHIU PROLOGIC

a.pro.49957
Livrare 24-48 ore

28,61Lei(-40%) 17,17Lei

VOBLER STRIKE PRO 3.5CM/2.2G A010 ARCHBACK

VOBLER STRIKE PRO 3.5CM/2.2G A010 ARCHBACK

sp.eg125e.a010
Livrare imediată!

32,06Lei

Van Den Eynde nada Method Mix Hi-Pro Carp 2kg

Van Den Eynde nada Method Mix Hi-Pro Carp 2kg

vn03364
Livrare imediată!

36,99Lei

FIR TEXTIL POWER PRO 135MT 0,32MM 24kg M. Green -5%

FIR TEXTIL POWER PRO 135MT 0,32MM 24kg M. Green

ppbi13532mg
Livrare imediată!

70,00Lei(-5%) 66,50Lei

SAPCA PROLOGIC BANK BOUND FLAT BILL NEGRU/CAMO
Exclusiv online!

SAPCA PROLOGIC BANK BOUND FLAT BILL NEGRU/CAMO

a8.pro.54654
Livrare 24-48 ore

52,06Lei

CICADA STRIKE PRO 6.5CM/26G CYBER VIBE A06ES

CICADA STRIKE PRO 6.5CM/26G CYBER VIBE A06ES

sp.jg005e.a06es
Livrare imediată!

32,19Lei

FIR MONOFILAMENT PROLOGIC MIMICRY GREEN HELO 1000M 0.33MM
Exclusiv online!

FIR MONOFILAMENT PROLOGIC MIMICRY GREEN HELO 1000M 0.33MM

a.pro.57087
Livrare 24-48 ore

188,14Lei

VOBLER RAPTURE PRO BB CRANK 4.5CM 7GR CTM

VOBLER RAPTURE PRO BB CRANK 4.5CM 7GR CTM

180-00-727
Livrare imediată!

20,00Lei

Vobler Lucky John Haira Tiny Plus One Pro Series 33LBF, 204, 3.3cm, 4g, 1buc/pac

Vobler Lucky John Haira Tiny Plus One Pro Series 33LBF, 204, 3.3cm, 4g, 1buc/pac

lj-hat33lbf-204
Livrare imediată!

37,00Lei

CICADA STRIKE PRO 6.5CM/26G CYBER VIBE 788E
Exclusiv online!

CICADA STRIKE PRO 6.5CM/26G CYBER VIBE 788E

sp.jg005e.788e
Livrare 24-48 ore

27,60Lei

Afişare 1261 - 1280 din 3891 (195 pagini)
Queries: 4, Total time: 93.592 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '8bb7b22b4dd859873f65fad96a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (93.204)
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('+pro' 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.165)
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