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ă:

-20%

PLUMBI, TORPILA, MAVER, CULISANTI, 2.50GR, 129250, Plumbi Stationar, Plumbi Stationar Maver, Maver

129250

Livrare imediată!

16,51Lei(-20%) 13,20Lei

PLUTA BALSA MOSTIRO BRANDUSA G CULISANTA 4GR

2420170340000-bucxxx

Livrare imediată!

4,50Lei

Vartej, cu, Margea, Culisanta, si, Agrafa, Matrix, X-Strong, Feeder, Bead, Snap, Links, Nr.10, 10buc/plic, gac374, Agrafe si Vartejuri Feeder, Agrafe si Vartejuri Feeder Matrix, Agrafe Matrix, Vartejuri Matrix, Feeder Matrix, Matrix

gac374

Livrare imediată!

13,46Lei

Plumb Culisant Arrow Hexagon, 10g

a3.p10

Livrare imediată!

1,40Lei

Mostiro cilindru culisant pentru teu

ai-rm54-m

Livrare imediată!

4,30Lei

Plumb Culisant Arrow Hexagon, 20g

a3.p20

Livrare imediată!

2,52Lei

MOMITOR BAIT TECH CULISANT ANTIAGATARE 70GR

5103070

Livrare imediată!

20,80Lei

Interlock Snap Cralusso Culisanta cu Margea 6buc/plic

79008302

Livrare imediată!

9,00Lei

-60%

PLUMB KORDA CULISANT 5G PT.MONTURI 6BUC/PLIC

a3.kfb5

Livrare imediată!

37,00Lei(-60%) 14,80Lei

MOMITOR BAIT TECH CULISANT ANTIAGATARE 100GR

5103100

Livrare imediată!

24,00Lei

KIT CARP HUNTER ACCESORII MONTURA CULISANTA

79032350

Livrare imediată!

9,40Lei

Set Plumbi GoldStar Culisanti Picatura IV 4.5-7.5g

54104150

Livrare imediată!

32,00Lei

Exclusiv online!

INEL, CULISANT, JAXON, NR, 6, 3.3MM, , ok-11633, Inele de Lanseta, Inele de Lanseta Jaxon, Jaxon

ok-11633

Livrare 48-72 ore

21,00Lei

PLUMBI CULISANTI MAVER CU BLOCAJ MATCH THIS TUNGSTEN 0.8GR

k422

Livrare imediată!

12,40Lei

Plute Energo Team Somn Culisanta 120g

65010120

Livrare imediată!

15,01Lei

PLUTA CULISANTA JAXON BFF STICK 2 5.00GR PORTSTARLITE 4.5MM

bx25003750

Livrare imediată!

5,50Lei

VARTEJ CU MARGEA CULISANTA SI AGRAFA AS FEEDER BEADS 10BUC PLIC

fb0001

Livrare imediată!

19,00Lei

Plumb Culisant EnergoTeam Hexagonal Dunare 100g

59204100

Livrare imediată!

8,00Lei

Vartej, cu, Margea, Culisanta, si, Agrafa, Matrix, Feeder, Bead, Snap, Links, Nr, 14, 10buc/plic, gac371, Vartejuri Feeder, Vartejuri Feeder Matrix, Vartejuri Matrix, Feeder Matrix, Matrix

gac371

Livrare imediată!

13,46Lei

Pluta, Culisanta, Somn, Black, Cat, Pose, 230gr, 5562004, Plute Somn, Plute Somn Black Cat, Black Cat

5562004

Livrare imediată!

17,78Lei

Afişare 101 - 120 din 479 (24 pagini)

Queries: 9, Total time: 386.964 ms [By time] [By id] [By file]

1 (0.089)

SELECT data
FROM `oc_session`
WHERE session_id = '205a565cb24e989bc5bbc66cfc'

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

2 (0.156)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.148)

SELECT `trigger`, `action`
FROM oc_event

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

4 (386.054)

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 "%culisant%") 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 100, 20

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

5 (0.134)

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 "%culisant%") 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

6 (0.123)

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 "%culisant%") 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

7 (0.111)

SELECT *
FROM oc_platforma_promovari

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

8 (0.075)

SELECT *
FROM oc_platforma_promovari

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

9 (0.074)

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