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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Mulineta Prologic Element XD 8000 FD -24%

Mulineta Prologic Element XD 8000 FD

o.pro.74711
Livrare imediată!

587,47Lei(-24%) 449,02Lei

Mulineta Prologic Element XD 7000 FD -24%

Mulineta Prologic Element XD 7000 FD

o.pro.74710
Livrare imediată!

569,39Lei(-24%) 433,81Lei

MULINETA PROLOGIC ELEMENT 6000 BF 9RUL/340MX035/5,1:1

MULINETA PROLOGIC ELEMENT 6000 BF 9RUL/340MX035/5,1:1

o.pro.74707
Livrare imediată!

359,59Lei

MULINETA PROLOGIC ELEMENT XD 7000 BF 6 plus 1BB -46%

MULINETA PROLOGIC ELEMENT XD 7000 BF 6 plus 1BB

o.pro.74712
Stoc epuizat

640,58Lei(-46%) 348,19Lei

MULINETA PROLOGIC ELEMENT XD 8000 BF 6 plus 1BB

MULINETA PROLOGIC ELEMENT XD 8000 BF 6 plus 1BB

o.pro.74713
Livrare imediată!

383,03Lei

MULINETA PROLOGIC ELEMENT 5000 BF 9RUL/200MX035/5,1:1

MULINETA PROLOGIC ELEMENT 5000 BF 9RUL/200MX035/5,1:1

o.pro.74706
Livrare imediată!

287,68Lei

LANSETA PROLOGIC 2BUC ELEMENT COM-PACT 3,00M/3,5LBS -20%
Exclusiv online!

LANSETA PROLOGIC 2BUC ELEMENT COM-PACT 3,00M/3,5LBS

o.pro.72667
Livrare 24-48 ore

606,64Lei(-20%) 485,31Lei

Mulineta Prologic Element 3000 BF, 5.2:1, 0.25mm/280m, 9rul -56%
Exclusiv online!

Mulineta Prologic Element 3000 BF, 5.2:1, 0.25mm/280m, 9rul

o.pro.74704
Livrare 24-48 ore

352,45Lei(-56%) 155,30Lei

MULINETA PROLOGIC ELEMENT BAITFEEDER 4000 BF -55%
Exclusiv online!

MULINETA PROLOGIC ELEMENT BAITFEEDER 4000 BF

o.pro.74705
Livrare 24-48 ore

361,50Lei(-55%) 162,07Lei

Galeata Prologic Element Water Bag Transparent - Camo, Medium, 7.9l

Galeata Prologic Element Water Bag Transparent - Camo, Medium, 7.9l

a8.pro.72825
Livrare imediată!

111,03Lei

Fir Textil Zeox Element Leader Camo, 38.7kg, 0.40mm, 25m
Exclusiv online!

Fir Textil Zeox Element Leader Camo, 38.7kg, 0.40mm, 25m

gcz-4110110
Livrare 48-72 ore

10,70Lei

Galeata Prologic Element Camo Water Bag Medium, 6.2litri
Exclusiv online!

Galeata Prologic Element Camo Water Bag Medium, 6.2litri

a8.pro.72827
Livrare 24-48 ore

105,47Lei

Galeata Prologic Element Water Bag Transparent - Camo, Large, 11l

Galeata Prologic Element Water Bag Transparent - Camo, Large, 11l

a8.pro.72824
Livrare imediată!

127,71Lei

Galeata Prologic Element Camo Water Bag Large, 8.6litri
Exclusiv online!

Galeata Prologic Element Camo Water Bag Large, 8.6litri

a8.pro.72826
Livrare 24-48 ore

116,58Lei

Costum Iarna Norfin Element+ L
Exclusiv online!

Costum Iarna Norfin Element+ L

4320-03-l
Livrare 48-72ore

899,00Lei

Fir Textil Zeox Element Leader Camo, 25.9kg, 0.30mm, 25m
Exclusiv online!

Fir Textil Zeox Element Leader Camo, 25.9kg, 0.30mm, 25m

gcz-4110108
Livrare 48-72 ore

10,70Lei

Costum Iarna Norfin Element+ XL
Exclusiv online!

Costum Iarna Norfin Element+ XL

4320-04-xl
Livrare 48-72ore

1.030,00Lei

Set Wizard Cutie Spinning, 50 Elemente, 26x17x7.5cm
Exclusiv online!

Set Wizard Cutie Spinning, 50 Elemente, 26x17x7.5cm

12046035
Livrare 24-48 ore

89,00Lei

Costum Iarna Norfin Element+ M
Exclusiv online!

Costum Iarna Norfin Element+ M

4320-02-m
Livrare 48-72ore

1.030,00Lei

Saltea de Primire PROLOGIC Element Com-Pact Sling Mat, Camo, 50x100cm
Exclusiv online!

Saltea de Primire PROLOGIC Element Com-Pact Sling Mat, Camo, 50x100cm

a.pro.1604139
Livrare 24-48 ore

483,98Lei

Afişare 1 - 20 din 102 (6 pagini)
Queries: 9, Total time: 558.999 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '9e2dcf50b2edff86e3ece08cfc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (557.383)
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 (pd.tag LIKE "%element%") 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
5 (0.724)
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
6 (0.142)
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
7 (0.123)
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
8 (0.120)
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
9 (0.117)
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