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


Activator Select Baits Meat Fish 250ml

Activator Select Baits Meat Fish 250ml

sc0125
Livrare imediată!

56,00Lei

Fir Textil Varivas FIR HIGH GRADE PE X4 MILKY PINK 150m 0.185mm 21lb
Exclusiv online!

Fir Textil Varivas FIR HIGH GRADE PE X4 MILKY PINK 150m 0.185mm 21lb

v20815012
Livrare 48-72 ore

92,00Lei

Fir Textil Varivas FIR AVANI JIGGING 10x10 MAX PE X8 200m 24.1lb 10mx10 Culori
Exclusiv online!

Fir Textil Varivas FIR AVANI JIGGING 10x10 MAX PE X8 200m 24.1lb 10mx10 Culori

v29820012
Livrare 48-72 ore

261,00Lei

Vartej Agrafa Zebco Trophy Safety Swivel No.12 26mm
Exclusiv online!

Vartej Agrafa Zebco Trophy Safety Swivel No.12 26mm

6204012
Livrare 7-14 zile

8,78Lei

Manusi EnergoTeam Outdoor Neopren marime XL

Manusi EnergoTeam Outdoor Neopren marime XL

74300124
Livrare imediată!

45,01Lei

Fir, Textil, Varivas, FIR, AVANI, JIGGING, 10x10, PREMIUM, PE, X4, 200m, 21lb, 10mx10, Culori, v29620012, Fire Textile Rapitori, Fire Textile Rapitori Varivas, Varivas
Fir Textil Varivas FIR MAX POWER PE X8 150m 24.1lb 0.185mm Lime Green Fluo
Exclusiv online!

Fir Textil Varivas FIR MAX POWER PE X8 150m 24.1lb 0.185mm Lime Green Fluo

v30015012
Livrare 48-72 ore

189,00Lei

Tambur de rezerva Delphin ELIXIR 3T aluminium

Tambur de rezerva Delphin ELIXIR 3T aluminium

101001253
Livrare imediată!

34,00Lei

Tambur de rezerva Delphin ELIXIR 4T aluminium

Tambur de rezerva Delphin ELIXIR 4T aluminium

101001254
Livrare imediată!

34,00Lei

KNOT PULLER DINSMORES

KNOT PULLER DINSMORES

40120085
Livrare imediată!

7,50Lei

CARLIGE, Maver, IT, KATANA, 1095, BLACK, NR, 12, 1095a012, Carlige Stationar, Carlige Stationar Maver, Maver -20%

CARLIGE, Maver, IT, KATANA, 1095, BLACK, NR, 12, 1095a012, Carlige Stationar, Carlige Stationar Maver, Maver

1095a012
Livrare imediată!

19,50Lei(-20%) 15,60Lei

Fir Textil Varivas FIR HIGH GRADE PE X4 WATER BLUE 150m 0.185mm 21lb
Exclusiv online!

Fir Textil Varivas FIR HIGH GRADE PE X4 WATER BLUE 150m 0.185mm 21lb

v20515012
Livrare 48-72 ore

99,00Lei

CAP SUPORT FEEDER TF BY DOME DIN EVA 30CM

CAP SUPORT FEEDER TF BY DOME DIN EVA 30CM

7325-012
Livrare imediată!

64,00Lei

Vartej Agrafa Zebco Trophy Rolling Swivel No.12 26mm

Vartej Agrafa Zebco Trophy Rolling Swivel No.12 26mm

6217012
Livrare imediată!

13,28Lei

Vartej Agrafa Zebco Trophy Safety Power Swivel No.12 30mm
Exclusiv online!

Vartej Agrafa Zebco Trophy Safety Power Swivel No.12 30mm

6206012
Livrare 7-14 zile

8,78Lei

CARLIGE, Maver, IT, KATANA, 1045, BLACK, NR, 12, 1045a012, Carlige Stationar, Carlige Stationar Maver, Maver
Exclusiv online!

CARLIGE, Maver, IT, KATANA, 1045, BLACK, NR, 12, 1045a012, Carlige Stationar, Carlige Stationar Maver, Maver

1045a012
Livrare 48-72 ore

20,00Lei

CARLIGE, Maver, IT, KATANA, 1210, NICKEL, NR, 12, 1210a012, Carlige Stationar, Carlige Stationar Maver, Maver
Exclusiv online!

CARLIGE, Maver, IT, KATANA, 1210, NICKEL, NR, 12, 1210a012, Carlige Stationar, Carlige Stationar Maver, Maver

1210a012
Livrare 48-72 ore

16,51Lei

Lanseta Delphin REWIR Picker 3.00M 2+3SEG 60g -36%

Lanseta Delphin REWIR Picker 3.00M 2+3SEG 60g

101001285
Livrare imediată!

307,00Lei(-36%) 195,01Lei

Cantar digital Korum Compact Digital Scale

Cantar digital Korum Compact Digital Scale

k0310121
Livrare imediată!

161,96Lei

Fir KORDA BASIX BRAIDED HOOKLINK 18LB/10M
Exclusiv online!

Fir KORDA BASIX BRAIDED HOOKLINK 18LB/10M

a.kbx012
Livrare 24-48 ore

25,51Lei

Afişare 41 - 60 din 1703 (86 pagini)
Queries: 10, Total time: 237.005 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = 'caba18676acaedce38e08d07df'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (212.672)
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 = '3' AND (pd.tag LIKE "%012%") 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 (0.264)
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:1561
5 (7.102)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (1.642)
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
7 (0.117)
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
8 (0.348)
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
9 (14.550)
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
10 (0.095)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38