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

Produse ce potrivesc criteriilor de căutare


CUTIE MOMEALA JAXON STONFO 1.2L Model 2
Exclusiv online!

CUTIE MOMEALA JAXON STONFO 1.2L Model 2

as-55r
Livrare 48-72 ore

34,55Lei

Vobler Palms Stroud 55F Smelt 5.5cm 3.3g AL-51
Exclusiv online!

Vobler Palms Stroud 55F Smelt 5.5cm 3.3g AL-51

sr-55f/al-51
Livrare 48-72ore

65,06Lei

WAGLER JAXON AA 5GR

WAGLER JAXON AA 5GR

sj-aa050
Livrare imediată!

18,30Lei

Scaun Walkstool Trepied Comfort, 55x37.5cm
Exclusiv online!

Scaun Walkstool Trepied Comfort, 55x37.5cm

a8.sc.55
Livrare 24-48 ore

515,54Lei

Lanseta Telescopica MITCHELL Suprema A4 PEP, Up To 15-55g, 4.50m, 5seg
Exclusiv online!

Lanseta Telescopica MITCHELL Suprema A4 PEP, Up To 15-55g, 4.50m, 5seg

1595340
Livrare 7-14 zile

460,60Lei

Lanseta Telescopica MITCHELL Suprema A4 PEP, Up To 15-55g, 4.20m, 4seg
Exclusiv online!

Lanseta Telescopica MITCHELL Suprema A4 PEP, Up To 15-55g, 4.20m, 4seg

1595338
Livrare 7-14 zile

416,87Lei

Lanseta Telescopica MITCHELL Suprema A4 PEP, Up To 15-55g, 3.90m, 4seg
Exclusiv online!

Lanseta Telescopica MITCHELL Suprema A4 PEP, Up To 15-55g, 3.90m, 4seg

1595336
Livrare 7-14 zile

395,52Lei

Lanseta Telescopica MITCHELL Suprema A4 PEP, Up To 15-55g, 3.50m, 4seg
Exclusiv online!

Lanseta Telescopica MITCHELL Suprema A4 PEP, Up To 15-55g, 3.50m, 4seg

1600380
Livrare 7-14 zile

352,82Lei

Lantera Led Lenser W5R Work Black 600lm + USB
Exclusiv online!

Lantera Led Lenser W5R Work Black 600lm + USB

a8.z502735
Livrare 24-48 ore

277,53Lei

LANTERNA LED LENSER P5R CORE 500LM/LI-ION + CABLU USB
Exclusiv online!

LANTERNA LED LENSER P5R CORE 500LM/LI-ION + CABLU USB

a8.z502178
Livrare 24-48 ore

379,86Lei

LANTERNA LED LENSER P5R WORK 480LM LI-ION CABLU USB
Exclusiv online!

LANTERNA LED LENSER P5R WORK 480LM LI-ION CABLU USB

a8.z502185
Livrare 24-48 ore

418,27Lei

AVERTIZOR JAXON XTR CARP LIBRA 5R ROSU
Exclusiv online!

AVERTIZOR JAXON XTR CARP LIBRA 5R ROSU

aj-sya105r
Livrare 48-72 ore

101,66Lei

LANTERNA CAP LED LENSER H5R CORE 500LM LI-ION CABLU USB

LANTERNA CAP LED LENSER H5R CORE 500LM LI-ION CABLU USB

a8.z502121
Livrare imediată!

398,97Lei

DANDINETA JAXON LB 1S 5GR 4.6 cm
Exclusiv online!

DANDINETA JAXON LB 1S 5GR 4.6 cm

bp-lb1s
Livrare 48-72 ore

12,69Lei

DANDINETA JAXON LC 1S 5GR 5 cm
Exclusiv online!

DANDINETA JAXON LC 1S 5GR 5 cm

bp-lc1s
Livrare 48-72 ore

12,69Lei

MOMITOR CU ANTITANGLE JAXON 15GR 21cm 25BUC/PLIC
Exclusiv online!

MOMITOR CU ANTITANGLE JAXON 15GR 21cm 25BUC/PLIC

aj-051
Livrare 48-72 ore

137,25Lei

MOMITOR CU ANTITANGLE JAXON 20GR 30cm 25BUC/PLIC
Exclusiv online!

MOMITOR CU ANTITANGLE JAXON 20GR 30cm 25BUC/PLIC

aj-054
Livrare 48-72 ore

139,30Lei

CUTIE MOMEALA JAXON STONFO 1.2L -26%

CUTIE MOMEALA JAXON STONFO 1.2L

as-55
Stoc epuizat

28,45Lei(-26%) 21,18Lei

LINIE ECHILIBRATA MOSTIRO LUX 7M COZMIN 5GR AC 4 (5 BUC) -30%

LINIE ECHILIBRATA MOSTIRO LUX 7M COZMIN 5GR AC 4 (5 BUC)

bf41334
Stoc epuizat

45,74Lei(-30%) 32,13Lei

LANTERNA CAP LED LENSER H5R WORK 500LM+CABLU MAGNETIC -24%

LANTERNA CAP LED LENSER H5R WORK 500LM+CABLU MAGNETIC

a8.z502194
Stoc epuizat

436,73Lei(-24%) 332,63Lei

Afişare 1 - 20 din 21 (2 pagini)
Queries: 12, Total time: 2.190 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = 'e7c752a470f5904da245a64466'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.142)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.174)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("18121", "2", "1000", "42", "1", "28.550000000000", "1"),("137981", "2", "1000", "583", "1", "53.770000000000", "2"),("50549", "2", "1005", "42", "1", "15.120000000000", "3"),("93109", "10", "1000", "512", "1", "426.070000000000", "4"),("236095", "1", "1000", "87", "1", "380.660000000000", "5"),("236101", "1", "1000", "87", "1", "344.520000000000", "6"),("236104", "1", "1000", "87", "1", "326.880000000000", "7"),("236107", "1", "1000", "87", "1", "291.590000000000", "8"),("176401", "1", "1000", "53", "1", "229.360000000000", "9"),("115456", "2", "1000", "53", "1", "313.930000000000", "10"),("118965", "2", "1000", "53", "1", "345.680000000000", "11"),("50736", "2", "1000", "42", "1", "84.020000000000", "12"),("115458", "2", "1001", "53", "1", "329.730000000000", "13"),("20448", "2", "1000", "42", "1", "10.490000000000", "14"),("20457", "2", "1000", "42", "1", "10.490000000000", "15"),("40897", "2", "1000", "42", "1", "113.430000000000", "16"),("40898", "2", "1000", "42", "1", "115.120000000000", "17"),("18120", "2", "0", "42", "1", "17.500000000000", "18"),("93893", "2", "0", "45", "1", "26.550000000000", "19"),("145869", "2", "0", "53", "1", "274.900000000000", "20"),("142771", "2", "0", "17", "1", "185.000000000000", "21")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.139)
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
6 (0.263)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.114)
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.239)
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
9 (0.089)
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
10 (0.079)
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
11 (0.635)
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
12 (0.109)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37