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


Juvelnic Browning Black Magic Standard Keep Net 3.50m

Juvelnic Browning Black Magic Standard Keep Net 3.50m

7015003
Stoc epuizat

179,79Lei

Husa Pentru Juvelnic/Minciog Matrix Ethos Pro EVA Triple Net Bag 60x50x25cm -20%

Husa Pentru Juvelnic/Minciog Matrix Ethos Pro EVA Triple Net Bag 60x50x25cm

glu089
Stoc epuizat

245,97Lei(-20%) 196,78Lei

Cap Minciog Matrix Carp Rubber Landing Net 6mm 55x45cm

Cap Minciog Matrix Carp Rubber Landing Net 6mm 55x45cm

gln047
Stoc epuizat

84,89Lei

MINCIOG SELECT LIFTUP NET 42 INCHI

MINCIOG SELECT LIFTUP NET 42 INCHI

smi421k
Stoc epuizat

625,00Lei

MANER MINCIOG COLMIC JAVIK NET 4.0M

MANER MINCIOG COLMIC JAVIK NET 4.0M

gxja01b
Stoc epuizat

210,00Lei

Minciog Sonik X Net 42 250CM

Minciog Sonik X Net 42 250CM

sn714029
Stoc epuizat

706,00Lei

MINCIOG PLIABIL JAXON SPLINE FISHING RUBBERIZED NET 2.40M 59X70CM

MINCIOG PLIABIL JAXON SPLINE FISHING RUBBERIZED NET 2.40M 59X70CM

pl-ab240x
Stoc epuizat

245,00Lei

Plasa minciog Select Baits Landing Net Mesh 42 Inch

Plasa minciog Select Baits Landing Net Mesh 42 Inch

smr42
Stoc epuizat

115,00Lei

Minciog Colmic Herakles Area Net 45x35x169cm

Minciog Colmic Herakles Area Net 45x35x169cm

guhan07
Stoc epuizat

161,00Lei

Maner Minciog DAM Sensomax II Tele 3.00m Landing Net Handle

Maner Minciog DAM Sensomax II Tele 3.00m Landing Net Handle

5010960839
Stoc epuizat

90,57Lei

Minciog Nash Scope Black Ops Landing Net 1.8 M

Minciog Nash Scope Black Ops Landing Net 1.8 M

t1762
Stoc epuizat

1.269,99Lei

Cap minciog Matrix Supa Lite Free Flow Landing Net 50 x 40cm

Cap minciog Matrix Supa Lite Free Flow Landing Net 50 x 40cm

gln043
Stoc epuizat

76,46Lei

Minciog DAM Foldable Landing Net With Lock -53%

Minciog DAM Foldable Landing Net With Lock

416098221110
Stoc epuizat

155,32Lei(-53%) 72,70Lei

Minciog Sert Epuisette Carnassier Rubber Net 1.80m

Minciog Sert Epuisette Carnassier Rubber Net 1.80m

50101sepnh6679cf-1802
Stoc epuizat

142,70Lei

Minciog DAM Crosspower Landing Net 310cm 60x60x50cm 6mm Rubber 138cm

Minciog DAM Crosspower Landing Net 310cm 60x60x50cm 6mm Rubber 138cm

5010960822
Stoc epuizat

197,55Lei

Minciog Rapture Trout Rubba Net 51x41cm

Minciog Rapture Trout Rubba Net 51x41cm

084-50-200
Stoc epuizat

95,08Lei

GEANTA GURU EVA FUSION NET

GEANTA GURU EVA FUSION NET

a8.gu.glg08
Stoc epuizat

441,48Lei

Minciog Rapture Aggressor Pro Net XXL 70x60 1.60m

Minciog Rapture Aggressor Pro Net XXL 70x60 1.60m

084-51-530
Stoc epuizat

339,99Lei

Minciog DAM Crosspower Landing Net 260cm 60x60x50cm 6mm Rubber 113cm

Minciog DAM Crosspower Landing Net 260cm 60x60x50cm 6mm Rubber 113cm

5010960821
Stoc epuizat

157,68Lei

REZERVA PLASA MINCIOG FOX Camo Landing Net Mesh 42

REZERVA PLASA MINCIOG FOX Camo Landing Net Mesh 42

cln053
Stoc epuizat

143,10Lei

Afişare 361 - 380 din 436 (22 pagini)
Queries: 10, Total time: 15.236 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = 'd83cf24c52cee30d6afa2c5e7d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (10.222)
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('+net' 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.126)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (0.138)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.583)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
7 (0.079)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
8 (0.127)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
9 (3.622)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
10 (0.136)
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