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

Agrafa Rapida Lucky John Fastlock Snap Nr.003, 27kg, 10buc/plic

ljp5111-003

Livrare imediată!

6,00Lei

Agrafa Snap Orange Lock Snap No.000, 10buc/pac

41441ap1604

Livrare imediată!

9,78Lei

Agrafa Twistlock Snap cu Vartej Zeck Rolling 72kg, 3buc/pac

41405110073

Livrare imediată!

34,82Lei

Exclusiv online!

Maner Telescopic Minciog Colmic Overlock 5m

gxove01b

Livrare 48-72 ore

670,01Lei

Agrafa Rapida Lucky John Fastlock Snap Nr.002, 22kg, 10buc/plic

ljp5111-002

Livrare imediată!

6,00Lei

Exclusiv online!

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura XXXL

npr535

Livrare 7-14 zile

494,96Lei

Minciog Complet NGT Combo Profiler cu Spreader Block Metal DeLuxe 100x100x90cm

ngt-fnh-combo-profiler

Livrare imediată!

239,00Lei

Exclusiv online!

Pichet Telescopic Suport Sonik Stanz Camlock Bankstick, 46cm

hc0026

Livrare 48-72 ore

66,76Lei

Suport de Perete pentru Lansete Berkley Twist Lock Utility 4 Rod Rack

1546010

Livrare imediată!

84,95Lei

Exclusiv online!

Vobler, Jackall, Block, Ripper, 48MR,, Blue, Back, Chartreuse,, 4.8cm,, 8.5g, ja.807179279, Voblere Floating, Voblere Floating Jackall, Jackall

ja.807179279

Livrare 24-48 ore

92,81Lei

Exclusiv online!

Vobler, Jackall, Block, Ripper, 48MR,, Chart, Back, Pearl,, 4.8cm,, 8.5g, ja.807179286, Voblere Floating, Voblere Floating Jackall, Jackall

ja.807179286

Livrare 24-48 ore

92,81Lei

Exclusiv online!

Vobler, Jackall, Block, Ripper, 48MR,, Gitai, Gill,, 4.8cm,, 8.5g, ja.807179347, Voblere Floating, Voblere Floating Jackall, Jackall

ja.807179347

Livrare 24-48 ore

92,81Lei

Exclusiv online!

Agrafa, Cross, Lock, Nevis, cu, Vartej, Ball, Bearing, Nr.4/0,, 62mm,, 4buc/pac, 5581-400, Accesorii Monturi Somn, Accesorii Monturi Somn Nevis, Accesorii Nevis, Monturi Nevis, Somn Nevis, Nevis

5581-400

Livrare 48-72 ore

12,99Lei

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

ljp5115-001

Livrare imediată!

7,90Lei

-23%

Cosulet Feeder Cresta Accelerate Block, Medium, 40g

004021-00240-00000

Livrare imediată!

12,90Lei(-23%) 9,90Lei

Exclusiv online!

Plumb Zfish Back Lead Lock 40g, 2buc/pac

zf-2800

Livrare 48-72ore

11,55Lei

-18%

Agrafa Delphin Crosslock Snap C-03 Nr.000, 4kg, 10buc/plic

969c03000

Stoc epuizat

9,00Lei(-18%) 7,40Lei

Agrafa BKK Duolock Snap Nr.000, 11kg, 12buc/plic

6974190008297

Livrare imediată!

9,90Lei

Agrafa Otel Zeck Twistlock Snap 120kg, 3buc/pac

41405110120

Livrare imediată!

14,78Lei

Agrafa, Snap, Orange, Lock, Snap, No.1,, 10buc/pac, 41441ap1601, Agrafe si Vartejuri Rapitor, Agrafe si Vartejuri Rapitor Orange, Agrafe Orange, Vartejuri Orange, Rapitor Orange, Orange

41441ap1601

Livrare imediată!

9,78Lei

Afişare 81 - 100 din 499 (25 pagini)

Queries: 11, Total time: 1,226.138 ms [By time] [By id] [By file]

1 (0.121)

SELECT data
FROM `oc_session`
WHERE session_id = '661dc84277afef0b6d5d9d1ebe'

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

2 (0.124)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.081)

SELECT `trigger`, `action`
FROM oc_event

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

4 (461.186)

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 "%lock%") 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 (354.431)

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 "%lock%") 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 80, 20

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

6 (0.139)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'

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

7 (0.163)

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

8 (409.510)

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

9 (0.146)

SELECT *
FROM oc_platforma_promovari

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

10 (0.131)

SELECT *
FROM oc_platforma_promovari

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

11 (0.106)

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