Pentru o livrare cat mai rapida va recomandam sa alegeti produse cu stoc in Magazin fizic si in Depozit Online. Produsele cu Stoc furnizor au termen de livrare mai mare si pot intarzia comanda dvs.
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

Filtreaza

Set Dam 4 Avertizoare + Statie, Red / Green / Yellow / Blue

Set Dam 4 Avertizoare + Statie, Red / Green / Yellow / Blue

1604061
Livrare imediată!

550,08Lei

Set Avertizori Korum Ksi8 Remote Bite Alarm, 3+1 Bule
Exclusiv online!

Set Avertizori Korum Ksi8 Remote Bite Alarm, 3+1 Bule

k0360084
Livrare 7-14 zile

514,33Lei

Set Avertizori Korum Ksi8 Remote Bite Alarm, 2+1 Bule
Exclusiv online!

Set Avertizori Korum Ksi8 Remote Bite Alarm, 2+1 Bule

k0360083
Livrare 7-14 zile

444,32Lei

Set Avertizori Korum Ksi6 Rod Remote Alarm Set, 3+1
Exclusiv online!

Set Avertizori Korum Ksi6 Rod Remote Alarm Set, 3+1

k0360079
Livrare 7-14 zile

389,89Lei

Set Avertizori Korum Ksi6 Rod Remote Alarm Set, 2+1
Exclusiv online!

Set Avertizori Korum Ksi6 Rod Remote Alarm Set, 2+1

k0360078
Livrare 7-14 zile

321,26Lei

Set Avertizori Korum Kri Remote Alarm Set, 3+1

Set Avertizori Korum Kri Remote Alarm Set, 3+1

k0360073
Livrare imediată!

298,39Lei

Set Avertizori Korum Kri Remote Alarm Set, 2+1
Exclusiv online!

Set Avertizori Korum Kri Remote Alarm Set, 2+1

k0360071
Livrare 7-14 zile

252,62Lei

Set Avertizori Korum Kri Remote Alarm Set + Hangere, 3+1
Exclusiv online!

Set Avertizori Korum Kri Remote Alarm Set + Hangere, 3+1

k0360080
Livrare 7-14 zile

367,01Lei

Set Avertizor Carp Academy Eurosignal 2buc
Exclusiv online!

Set Avertizor Carp Academy Eurosignal 2buc

6318-003
Livrare 48-72 ore

80,31Lei

Set Avertizoare Mack2 Carp Addict Sx Alarm Set 4+1

Set Avertizoare Mack2 Carp Addict Sx Alarm Set 4+1

41904mk2-143262-1
Livrare imediată!

618,03Lei

Set Avertizoare Dam Tfx Alarm Set 3+1

Set Avertizoare Dam Tfx Alarm Set 3+1

1604060
Livrare imediată!

455,50Lei

Set 3 Avertizoare Trakker Db7-r 3 Rod Bite Alarm Set

Set 3 Avertizoare Trakker Db7-r 3 Rod Bite Alarm Set

222205
Livrare imediată!

2.034,55Lei

Kit Prologic 2 Snag Bar Wireless + Receiver -77%
Exclusiv online!

Kit Prologic 2 Snag Bar Wireless + Receiver

svs48397
Livrare 7-14 zile

1.119,95Lei(-77%) 260,00Lei

Inele Cauciuc Trakker Spare Rubber O Ring, 3buc/plic
Exclusiv online!

Inele Cauciuc Trakker Spare Rubber O Ring, 3buc/plic

222860
Livrare 7-14 zile

18,74Lei

Carcasa Statie Delkim Rx-d Moulded Hardcase, Negru, 1buc/pac
Exclusiv online!

Carcasa Statie Delkim Rx-d Moulded Hardcase, Negru, 1buc/pac

dd021
Livrare 7-14 zile

36,54Lei

Carcasa Statie Delkim Rx-d Moulded Hardcase, Clear, 1buc/pac
Exclusiv online!

Carcasa Statie Delkim Rx-d Moulded Hardcase, Clear, 1buc/pac

dd023
Livrare 7-14 zile

44,17Lei

Carcasa Avertizor Delkim Txi-d Moulded Hardcase, Negru, 1buc/pac
Exclusiv online!

Carcasa Avertizor Delkim Txi-d Moulded Hardcase, Negru, 1buc/pac

dd020
Livrare 7-14 zile

36,54Lei

Avertizor Korum Ksi8 Remote Bite Alarm, Bule
Exclusiv online!

Avertizor Korum Ksi8 Remote Bite Alarm, Bule

k0360082
Livrare 7-14 zile

140,97Lei

Avertizor Jrc Radar Drs Alarm, Red
Exclusiv online!

Avertizor Jrc Radar Drs Alarm, Red

1580482
Livrare 7-14 zile

133,18Lei

Avertizor Jrc Radar Drs Alarm, Green
Exclusiv online!

Avertizor Jrc Radar Drs Alarm, Green

1580484
Livrare 7-14 zile

133,18Lei

Afişare 281 - 300 din 504 (26 pagini)

Descoperă gama noastră de avertizoare electronice și senzori pentru pescuit, esențiale pentru detectarea rapidă a trăsăturilor.
Alege avertizoare wireless, senzori digitali și modele cu LED, ideale pentru pescuit la crap și feeder.
Disponibile în variante pentru pescuit de zi și noapte, optimizează fiecare partidă de pescuit.
Avertizoarele cu senzor de vibrație și volum ajustabil oferă precizie maximă și confort sporit.
Pentru pescuit de competiție, recomandăm senzori pentru detecție precisă și avertizoare profesionale.
Modelele pentru pescuit la distanță sunt testate pentru performanță și fiabilitate maximă.
Avertizoarele cu baterie de lungă durată asigură utilizare extinsă fără întreruperi.
Indispensabile pentru pescarii amatori și profesioniști, îmbunătățesc semnalizarea trăsăturilor.
Senzorii de pescuit premium detectează rapid orice mișcare a firului.
Alege cele mai bune avertizoare electronice și senzori pentru pescuit și fii mereu pregătit pentru capturi!

Queries: 15, Total time: 38.665 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '1f14c133ec5daa38b17e34dbc1'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.103)
SELECT *
FROM oc_url_alias
WHERE keyword = 'avertizoare-electronice-246'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.411)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '246' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
5 (9.665)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) ENGINE=InnoDB 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_to_category` AS p2c ON (p.product_id = p2c.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 = '2' AND p2c.category_id = '246' 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:857
6 (0.227)
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:1593
7 (2.287)
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 DESC LIMIT 280, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (18.559)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN `oc_bf_tmp_product` AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND match_filters = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, CAST(av.value AS UNSIGNED), av.value
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1286
9 (0.582)
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:1393
10 (0.084)
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:1415
11 (0.181)
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:1180
12 (6.027)
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:1094
13 (0.139)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"246"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
14 (0.132)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"246"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
15 (0.082)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37