Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

Exclusiv online!

SWINGER, SIMPLU, JAXON, MEDIUM, 25BUC/PLIC, aj-352, Swingere Hangere, Swingere Hangere Jaxon, Jaxon

aj-352

Livrare 48-72 ore

224,01Lei

Exclusiv online!

Varf, Feeder, Maver, Genesis, Pro, 3.00m/90g, 2sec, Medium, a2502, Varfuri Feeder, Varfuri Feeder Maver, Maver

a2502

Livrare 48-72 ore

67,00Lei

Nash Blow Out Tube Medium 0.75mm

t8041

Livrare imediată!

17,10Lei

Exclusiv online!

Lanseta Sportex XCLUSIVE FEEDER NT MEDIUM HEAVY 360 100-190gr

mh3618

Livrare 48-72 ore

1.410,00Lei

Lansete Sportex XCLUSIVE FEEDER NT MEDIUM 360 90-160gr

mf3616

Livrare imediată!

1.350,00Lei

Exclusiv online!

Window Feeder Guru Medium Weight Pack Light 2x30g + 2x40g

a.gu.gwf11

Livrare 24-48 ore

23,00Lei

SWINGER, SIMPLU, JAXON, MEDIUM, aj-352m, Swingere Hangere, Swingere Hangere Jaxon, Jaxon

aj-352m

Livrare imediată!

21,50Lei

WINDOW, GURU, FEEDER, MEDIUM, 50G+60G, a.gu.gwf06, Cosulete Feeder, Cosulete Feeder Guru, Guru

a.gu.gwf06

Livrare imediată!

25,51Lei

CARLIGE FOX EDGES ARMAPOINT CURVE SHANK MEDIUM Nr.8 10/plic

chk203

Livrare imediată!

26,80Lei

Exclusiv online!

INDICATOR PORTSTARLITE JAXON MEDIUM 25BUC/PLIC

aj-321

Livrare 48-72 ore

119,00Lei

-47%

GEANTA ACCESORII FOX RAGE CARRYALL PLUS 5 CUTII PENTRU NALUCI MEDIUM

nlu051

Livrare imediată!

489,99Lei(-47%) 258,90Lei

Stopper Carp Spirit Hook Rig Stops Medium

-25%

Exclusiv online!

Stopper Carp Spirit Hook Rig Stops Medium

acs010297

Livrare 48-72ore

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

Exclusiv online!

Varf Feeder Maver Elite Medium 3m

a2202

Livrare 48-72 ore

78,00Lei

Exclusiv online!

LANSETA COLMIC HERAKLES WILD STRIKE 240ML 240cm 2-10gr Medium Light

cahkws02

Livrare 48-72 ore

510,00Lei

INDICATOR, JAXON, MEDIUM, aj-312m, Clopotei Bambine Starlite Crap, Clopotei Bambine Starlite Crap Jaxon, Jaxon

aj-312m

Livrare imediată!

12,99Lei

Exclusiv online!

Lansete Sportex XCLUSIVE FEEDER NT MEDIUM 420 90-160gr

mf4216

Livrare 48-72 ore

1.390,00Lei

Exclusiv online!

Varf Feeder Maver Abyss X Medium 2.70m

a2047

Livrare 48-72 ore

40,00Lei

Exclusiv online!

Varf Feeder Maver Abyss X Medium 3.00m

a2027

Livrare 48-72 ore

39,00Lei

Agrafa Daiwa Rapida 10buc/plic Medium

d.14905.000

Livrare imediată!

5,50Lei

Method Mould DAM Sumo Method Feeder Mould Medium

403098009000

Livrare imediată!

14,70Lei

Afişare 201 - 220 din 569 (29 pagini)

Queries: 10, Total time: 340.825 ms [By time] [By id] [By file]

1 (0.122)

SELECT data
FROM `oc_session`
WHERE session_id = 'c1ebc6c4e03144938db7e48f5e'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.123)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.126)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (339.889)

SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%medium%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 200, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

5 (0.172)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130

6 (0.097)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
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)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%medium%") AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:997

7 (0.086)

SELECT COUNT(1) AS val, filter_group, filter_id
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)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%medium%") AND p.status_filtru > 0 AND p.price > 0 AND f.language_id = '2' GROUP BY p.product_id, filter_group, filter_id HAVING match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:912

8 (0.075)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

9 (0.062)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

10 (0.073)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare