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 - Ciorapi Carp Zoom

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

Cizme Fox Rage Neoprene Boots size 8 Marime 42

nfw014

Livrare imediată!

337,46Lei

Exclusiv online!

Cizme Fox Rage Neoprene Boots size 11 Marime 45

nfw017

Livrare 7-14 zile

337,46Lei

Husa pentru Semnalizatorul Delphin ALARM Neoprene

101002380

Livrare imediată!

47,01Lei

Exclusiv online!

Benzi Prindere Lansete Garbolino Neoprene 2.40x3.00x0.4cm

90530braneo

Livrare 48-72 ore

41,19Lei

Cizme Fox Neoprene Lined Camo & Khaki Wellies, Marime UK8 / EU42

cfw163

Livrare imediată!

494,96Lei

Cizme Fox Neoprene Lined Camo & Khaki Wellies, Marime U10 / EU44

cfw165

Livrare imediată!

494,96Lei

Exclusiv online!

Cizme Fox Neoprene Lined Camo & Khaki Wellies, Marime UK11 / EU45

cfw166

Livrare 7-14 zile

494,96Lei

Cizme Fox Neoprene Lined Camo & Khaki Wellies, Marime UK9 / EU43

cfw164

Livrare imediată!

494,96Lei

Exclusiv online!

Suport Mikado Feeder Neoprene, 50cm

is15-pod-13-50

Livrare 48-72 ore

55,00Lei

Exclusiv online!

Feeder Arm Mikado Suport Feeder - Neoprene Combo Cu Opritor, 42cm

is15-pod-14-42

Livrare 48-72 ore

70,00Lei

Exclusiv online!

Suport Mikado Feeder Neoprene, 25cm

is15-pod-03-25

Livrare 48-72 ore

49,00Lei

Exclusiv online!

CIORAPI NEOPRENE CORMORAN MARIME 38-41

a8.94.25001

Livrare 24-48 ore

97,19Lei

-19%

BANDA CATGEAR NEOPRENE ROD BELTS

302-00-600

Livrare imediată!

22,00Lei(-19%) 17,90Lei

Exclusiv online!

MANUSI NEOPRENE RON THOMPSON MARIME M

a8.tho.49481

Livrare 24-48 ore

73,96Lei

Exclusiv online!

MANUSI NEOPRENE RON THOMPSON MARIME XL

a8.tho.49483

Livrare 24-48 ore

73,96Lei

Exclusiv online!

MANUSI NEOPRENE RON THOMPSON MARIME L

a8.tho.49482

Livrare 24-48 ore

73,96Lei

Exclusiv online!

MANUSI Carp Zoom NEOPRENE CARP ZOOM SMART M

cz2811

Livrare 48-72 ore

89,00Lei

Exclusiv online!

MANUSI Carp Zoom NEOPRENE CARP ZOOM SMART L

cz2750

Livrare 48-72 ore

89,00Lei

Exclusiv online!

HUSA SPORTEX PROTECTIE LANSETE NEOPRENE Small

s300719

Livrare 48-72 ore

150,00Lei

HUSA SPORTEX PROTECTIE LANSETE NEOPRENE Medium

s300720

Livrare imediată!

189,00Lei

Afişare 1 - 20 din 83 (5 pagini)

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

1 (0.147)

SELECT data
FROM `oc_session`
WHERE session_id = '8bd5771e28b0ac098f2b07d311'

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

2 (0.154)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.106)

SELECT `trigger`, `action`
FROM oc_event

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

4 (452.511)

SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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 "%neoprene%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t

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

5 (400.891)

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 "%neoprene%") 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 0, 20

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

6 (0.175)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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 "%neoprene%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p

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

7 (469.821)

SELECT COUNT(*) AS val, filter_group, filter_id
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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 "%neoprene%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' AND f.filter_group NOT LIKE 'a%' GROUP BY filter_group, filter_id

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

8 (0.135)

SELECT *
FROM oc_platforma_promovari

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

9 (0.090)

SELECT *
FROM oc_platforma_promovari

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

10 (0.094)

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 - Ciorapi Carp Zoom

Produse ce potrivesc criteriilor de căutare