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


PROTECTIE BUSHNELL FLIP BUTLER CREEK OCULAR LUNETA 17, 42,50MM
Exclusiv online!

PROTECTIE BUSHNELL FLIP BUTLER CREEK OCULAR LUNETA 17, 42,50MM

vb.mo20170
Livrare 24-48 ore

72,47Lei

PROTECTIE BUSHNELL BUTLER CREEK OBIECTIV LUNETA(30) 49,80MM
Exclusiv online!

PROTECTIE BUSHNELL BUTLER CREEK OBIECTIV LUNETA(30) 49,80MM

vb.30300
Livrare 24-48 ore

69,75Lei

PROTECTIE GARMIN PENTRU ECHOMAP UHD 9X
Exclusiv online!

PROTECTIE GARMIN PENTRU ECHOMAP UHD 9X

hg.010.13127.00
Livrare 24-48 ore

129,00Lei

CAPAC PROTECTIE GARMIN STRIKER X7
Exclusiv online!

CAPAC PROTECTIE GARMIN STRIKER X7

hg.010.13131.00
Livrare 24-48 ore

130,29Lei

PROTECTIE, GARMIN, , PENTRU, SONAR, STRIKER, 9X, HG.010.13132.00, Optica, Optica Garmin, Garmin
Exclusiv online!

PROTECTIE, GARMIN, , PENTRU, SONAR, STRIKER, 9X, HG.010.13132.00, Optica, Optica Garmin, Garmin

hg.010.13132.00
Livrare 24-48 ore

130,29Lei

Degetar Baracuda II albastru

Degetar Baracuda II albastru

degetar ii
Stoc epuizat

20,65Lei

DEGETAR SPORTEX CASTING

DEGETAR SPORTEX CASTING

s300718
Stoc epuizat

62,00Lei

Protectie Guru Tops and Tails

Protectie Guru Tops and Tails

a8.gu.glg031
Stoc epuizat

92,89Lei

PROTECTIE LUNETA NIGGELOH NEOPREN S D=42MM/L=24CM

PROTECTIE LUNETA NIGGELOH NEOPREN S D=42MM/L=24CM

a8.ng.0711.00009
Stoc epuizat

171,97Lei

Husa Protectie Mulineta Casting (Multiplicator) 13Fishing Skull Cap TX, Orange
Protectie ancora Savage Gear Treble Hook Protectors Small

Protectie ancora Savage Gear Treble Hook Protectors Small

a.sg.72326
Stoc epuizat

13,84Lei

Degetar Daiwa Single Finger Guard

Degetar Daiwa Single Finger Guard

d.dl403726
Stoc epuizat

23,57Lei

PROTECTIE LUNETA ZEISS NEOPREN SIZE L

PROTECTIE LUNETA ZEISS NEOPREN SIZE L

vz.000000.2231.633
Stoc epuizat

300,69Lei

Bluza Cu Protectie UV RTB Long Sleeve SPF +50 Light Grey masura XL

Bluza Cu Protectie UV RTB Long Sleeve SPF +50 Light Grey masura XL

rtb8183
Stoc epuizat

149,00Lei

Bluza Cu Protectie UV RTB Long Sleeve SPF +50 Light Grey masura XXL

Bluza Cu Protectie UV RTB Long Sleeve SPF +50 Light Grey masura XXL

rtb8184
Stoc epuizat

149,00Lei

Bluza cu Protectie UV RTB Long Sleeve SPF +50, Bright White, Masura XXL

Bluza cu Protectie UV RTB Long Sleeve SPF +50, Bright White, Masura XXL

rtb8189
Stoc epuizat

149,00Lei

Degetar Delphin Protex C2G -26%

Degetar Delphin Protex C2G

101003082
Stoc epuizat

38,00Lei(-26%) 28,00Lei

Bluza cu Protectie UV RTB Long Sleeve SPF +50, Bright White, Masura S

Bluza cu Protectie UV RTB Long Sleeve SPF +50, Bright White, Masura S

rtb8185
Stoc epuizat

149,00Lei

Degetar Strategy Casting Glove

Degetar Strategy Casting Glove

006598-00081-00000
Stoc epuizat

55,00Lei

Husa Arrow Tapel Protectie Luneta, Material Textil

Husa Arrow Tapel Protectie Luneta, Material Textil

ve.t723p
Stoc epuizat

138,00Lei

Afişare 281 - 300 din 397 (20 pagini)
Queries: 7, Total time: 226.958 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = '2d59924118f92e343d4a8c6092'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (224.294)
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 "%protectie%") 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 (2.089)
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 280, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.155)
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.095)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.100)
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