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


Set Avertizoare DAM Madcat Smart Mcl 4+1

Set Avertizoare DAM Madcat Smart Mcl 4+1

a.mad.70841
Livrare imediată!

1.464,14Lei

Set Avertizoare Sonik Cu Statie Si Lampa Semnalizare Cort, 4+1
Exclusiv online!

Set Avertizoare Sonik Cu Statie Si Lampa Semnalizare Cort, 4+1

hc0084
Livrare 48-72 ore

1.049,21Lei

Avertizor Electronic DAM Madcat Topcat Green

Avertizor Electronic DAM Madcat Topcat Green

a.mad.707630002
Livrare imediată!

380,25Lei

Casti Antifonice Electronice Stereo Browning BDM Activ NRR22 dB
Exclusiv online!

Casti Antifonice Electronice Stereo Browning BDM Activ NRR22 dB

bo.126902
Livrare 24-48 ore

765,02Lei

Set 3 Avertizoare + Statie DAM Somn Madcat Topcat

Set 3 Avertizoare + Statie DAM Somn Madcat Topcat

a.mad.70764
Livrare imediată!

1.509,87Lei

Set Avertizoare Sonik Cu Statie Si Lampa Semnalizare Cort, 3+1

Set Avertizoare Sonik Cu Statie Si Lampa Semnalizare Cort, 3+1

hc0083
Livrare imediată!

960,66Lei

Avertizor electronic DAM Ontario Blue

Avertizor electronic DAM Ontario Blue

a.dam.63617
Livrare imediată!

45,52Lei

Cantar Electronic cu Termometru Lucky John BBS 50kg
Exclusiv online!

Cantar Electronic cu Termometru Lucky John BBS 50kg

ljbbs050-fs
Livrare 48-72ore

165,01Lei

Set 3 Avertizoare Electronici + Statie SNZ + Lanterna Prologic C-Series

Set 3 Avertizoare Electronici + Statie SNZ + Lanterna Prologic C-Series

a.pro.76135
Livrare imediată!

676,32Lei

Set Avertizoare Electronice Sonik Vaderx RGB, 3+1

Set Avertizoare Electronice Sonik Vaderx RGB, 3+1

hc0064
Livrare imediată!

505,95Lei

Cantar Mikado Electronic Fishing Scale 50 Kg
Exclusiv online!

Cantar Mikado Electronic Fishing Scale 50 Kg

am-dfs-50-002
Livrare 48-72 ore

61,00Lei

Set Avertizori Mikado Bait Indicator - Carp - Cfl Ii, 2+1
Exclusiv online!

Set Avertizori Mikado Bait Indicator - Carp - Cfl Ii, 2+1

ams08-cfl2-set
Livrare 48-72 ore

420,00Lei

Avertizor Electronic DAM Nano Bite Blue
Exclusiv online!

Avertizor Electronic DAM Nano Bite Blue

a.dam.52330
Livrare 24-48 ore

65,44Lei

Avertizor Electronic Trakker DB7-R Bite Alarm, 11.2x5.4x4.5cm
Exclusiv online!

Avertizor Electronic Trakker DB7-R Bite Alarm, 11.2x5.4x4.5cm

222201
Livrare 7-14 zile

549,95Lei

Avertizor Electronic DAM Mini E-Motion G2 Green -26%

Avertizor Electronic DAM Mini E-Motion G2 Green

4230960243
Livrare imediată!

108,11Lei(-26%) 80,00Lei

Senzor Mikado Bait Indicator - Carp - Cfl Ii - Green
Exclusiv online!

Senzor Mikado Bait Indicator - Carp - Cfl Ii - Green

ams08-cfl2-g
Livrare 48-72 ore

126,00Lei

Senzor Mikado Bait Indicator - Carp - Cfl Ii - Yellow
Exclusiv online!

Senzor Mikado Bait Indicator - Carp - Cfl Ii - Yellow

ams08-cfl2-y
Livrare 48-72 ore

126,00Lei

Set Avertizoare Wizard MXT Cat, 2+1
Exclusiv online!

Set Avertizoare Wizard MXT Cat, 2+1

78001621
Livrare 24-48 ore

315,36Lei

Avertizor Electronic FL Model Stas

Avertizor Electronic FL Model Stas

896543
Livrare imediată!

31,09Lei

SET AVERTIZOARE RADIO PROLOGIC BAT PLUS MULTICOLOR 4 plus 1

SET AVERTIZOARE RADIO PROLOGIC BAT PLUS MULTICOLOR 4 plus 1

a.pro.57082
Livrare imediată!

749,16Lei

Afişare 81 - 100 din 549 (28 pagini)
Queries: 6, Total time: 239.603 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = 'ca0662d6ca93adb94bdb394f33'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (234.984)
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 = '2' AND (pd.tag LIKE "%electronic%") 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
4 (4.114)
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 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.130)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.131)
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