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 300 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


CAP MINCIOG MATRIX CARP LANDING NETS 60x50 cm

CAP MINCIOG MATRIX CARP LANDING NETS 60x50 cm

gln065
Livrare imediată!

83,20Lei

CAP MINCIOG MATRIX CARP LANDING NETS 45x35 cm

CAP MINCIOG MATRIX CARP LANDING NETS 45x35 cm

gln064
Livrare imediată!

65,21Lei

JUVELNIC DE COMPETITIE PRESTON SPACE SAVER KEEPNETS, 35X45CM, 3.00M

JUVELNIC DE COMPETITIE PRESTON SPACE SAVER KEEPNETS, 35X45CM, 3.00M

p0140017
Livrare imediată!

292,45Lei

Suport Delphin feeder Atoma NetSTICK -32%

Suport Delphin feeder Atoma NetSTICK

101001473
Livrare imediată!

56,00Lei(-32%) 38,00Lei

Maner Minciog Garbolino Netsy Ultra Pro Match, 3.50m, 3seg

Maner Minciog Garbolino Netsy Ultra Pro Match, 3.50m, 3seg

50230gomnk6330350-3
Livrare imediată!

288,24Lei

Maner Minciog Garbolino Netsy Ultra Pro Match, 4.80m, 4seg

Maner Minciog Garbolino Netsy Ultra Pro Match, 4.80m, 4seg

50230gomnk6330480-4
Livrare imediată!

375,16Lei

Maner Minciog Garbolino Netsy Slim Pro Match, 3.60m, 3seg
Exclusiv online!

Maner Minciog Garbolino Netsy Slim Pro Match, 3.60m, 3seg

50230gomnk6130360-3
Livrare 48-72 ore

264,38Lei

Maner Minciog Garbolino Netsy Golden Carp, 3.10m, 3seg

Maner Minciog Garbolino Netsy Golden Carp, 3.10m, 3seg

50230gomng6232310-2+1
Livrare imediată!

229,15Lei

Minciog Nets Abu Garcia Landing Net Alu Tele, 2 seg, 45x45cm -25%

Minciog Nets Abu Garcia Landing Net Alu Tele, 2 seg, 45x45cm

1401562
Livrare imediată!

85,00Lei(-25%) 63,80Lei

OPRITOARE GURU BAYONETS

OPRITOARE GURU BAYONETS

a.gu.gbyt
Livrare imediată!

16,21Lei

MONTURA GURU BAYONETS CARLIG NR.14 019MM/10CM 8BUC/PL

MONTURA GURU BAYONETS CARLIG NR.14 019MM/10CM 8BUC/PL

a.gu.grr043
Livrare imediată!

23,92Lei

Juvelnic Matrix Commercial Keepnets 2.5m 45cm x 35cm

Juvelnic Matrix Commercial Keepnets 2.5m 45cm x 35cm

gln068
Livrare imediată!

214,70Lei

MONTURA GURU BAYONETS QM1 CARLIG 0.25MM 10CM NR.18 8BUC/PLIC

MONTURA GURU BAYONETS QM1 CARLIG 0.25MM 10CM NR.18 8BUC/PLIC

a.gu.grr040
Livrare imediată!

26,64Lei

Montura Guru Bayonets QM1 Hair Rigs, 8 buc/plic Nr.10 / 0.25mm

Montura Guru Bayonets QM1 Hair Rigs, 8 buc/plic Nr.10 / 0.25mm

a.gu.grr045
Livrare imediată!

26,39Lei

Minciog Fox Rage Street Fighter Landing Nets 3.7M
Exclusiv online!

Minciog Fox Rage Street Fighter Landing Nets 3.7M

nln015
Livrare 7-14 zile

584,96Lei

Minciog Fox Rage Street Fighter Landing Nets 2.4M
Exclusiv online!

Minciog Fox Rage Street Fighter Landing Nets 2.4M

nln014
Livrare 7-14 zile

539,96Lei

MONTURA GURU BAYONETS QM1 CARLIG NR.14 0.19MM 38CM 8BUC/PLIC
Exclusiv online!

MONTURA GURU BAYONETS QM1 CARLIG NR.14 0.19MM 38CM 8BUC/PLIC

a.gu.grr047
Livrare 24-48 ore

26,64Lei

Minciog Avid Revole Nets 42” 1.80m 1 seg

Minciog Avid Revole Nets 42” 1.80m 1 seg

a0610016
Livrare imediată!

292,45Lei

Minciog Avid Revole Nets 42” 1.80m 2 seg

Minciog Avid Revole Nets 42” 1.80m 2 seg

a0610017
Livrare imediată!

359,96Lei

Carlige Legate Guru Bayonets QM1, Carlig Nr.12, 0.22mm, 38cm, 8buc/pac
Exclusiv online!

Carlige Legate Guru Bayonets QM1, Carlig Nr.12, 0.22mm, 38cm, 8buc/pac

a.gu.grr207
Livrare 24-48 ore

27,75Lei

Afişare 1 - 20 din 43 (3 pagini)
Queries: 13, Total time: 253.891 ms [By time] [By id] [By file]
1 (0.141)
SELECT data
FROM `oc_session`
WHERE session_id = 'ad28502c7ba347baf40939ef3f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.125)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (251.104)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%nets%") 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:698
5 (0.219)
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:1555
6 (0.648)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
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 match_filters = 1 AND pd.language_id = '2'
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
7 (0.241)
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:1209
8 (0.122)
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:1231
9 (0.098)
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:996
10 (0.802)
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:910
11 (0.096)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.098)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.117)
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