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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Clipsuri Tip Ancora C2070 Coghlans
Exclusiv online!

Clipsuri Tip Ancora C2070 Coghlans

c2070
Livrare 24-48 ore

47,67Lei

Opritoare Pelete Extra Carp 21mm, 26buc/pac

Opritoare Pelete Extra Carp 21mm, 26buc/pac

ec4820
Livrare imediată!

8,93Lei

Lanseta Spro Ridge Classix Spin 2.10m/15-40g

Lanseta Spro Ridge Classix Spin 2.10m/15-40g

002870-00213-00000
Livrare imediată!

255,20Lei

Lanseta Spro Ridge Classix Spin 2.40m/15-40g

Lanseta Spro Ridge Classix Spin 2.40m/15-40g

002870-00243-00000
Livrare imediată!

286,72Lei

Method Feeder In Line 50g EXTRA CARP

Method Feeder In Line 50g EXTRA CARP

ec8279
Livrare imediată!

10,56Lei

Plumb Extra Carp Flat Pear cu Vartej 120g

Plumb Extra Carp Flat Pear cu Vartej 120g

ec4875-120
Livrare imediată!

10,35Lei

Amnar Coghlans Magnesium Fire Starter

Amnar Coghlans Magnesium Fire Starter

c7870
Livrare imediată!

37,50Lei

Plumbi Despicati + 50cm Tub Cauciuc EXTRA CARP Pop-Up Weights 1.50g, 10buc/pac

Plumbi Despicati + 50cm Tub Cauciuc EXTRA CARP Pop-Up Weights 1.50g, 10buc/pac

ec8170
Livrare imediată!

23,37Lei

EXTRA CARP SARMA PT INTRODUCEREA FIRULUI PRIN ANTITANGLE

EXTRA CARP SARMA PT INTRODUCEREA FIRULUI PRIN ANTITANGLE

ec2710
Livrare imediată!

7,61Lei

ANTI TANGLE SET 101 EXTRA CARP VARTEJ CU AGRAFA RAPIDA + CROSETA

ANTI TANGLE SET 101 EXTRA CARP VARTEJ CU AGRAFA RAPIDA + CROSETA

ec9770
Livrare imediată!

21,34Lei

Set Method Feeder EXTRA CARP 3 plus 1/ 20.25.30Gr plus matrita

Set Method Feeder EXTRA CARP 3 plus 1/ 20.25.30Gr plus matrita

ec3570
Livrare imediată!

31,50Lei

Fir Textil EXTRA CARP Dyna Tec Leader, Green, 10m, 0.25mm, 18.90kg

Fir Textil EXTRA CARP Dyna Tec Leader, Green, 10m, 0.25mm, 18.90kg

ec2702
Livrare imediată!

10,15Lei

Fir Textil EXTRA CARP Dyna Tec Leader, Green, 10m, 0.18mm, 13.50kg

Fir Textil EXTRA CARP Dyna Tec Leader, Green, 10m, 0.18mm, 13.50kg

ec2672
Livrare imediată!

10,15Lei

Rod Pod Extra Carp Eco 3 Posturi

Rod Pod Extra Carp Eco 3 Posturi

ec2030
Livrare imediată!

138,27Lei

Kit Plumb Pierdut EXTRA CARP Lead Clup + Vartej Nr.8, 10kit-uri/pac

Kit Plumb Pierdut EXTRA CARP Lead Clup + Vartej Nr.8, 10kit-uri/pac

ec9876
Livrare imediată!

17,27Lei

Montura Extra Carp Ronnie Rig 777P Cu Surub, Nr.8, 3buc/pac

Montura Extra Carp Ronnie Rig 777P Cu Surub, Nr.8, 3buc/pac

ec6470
Stoc epuizat

15,25Lei

Fir Monofilament Extra Carp Magic Yellow, 15.50kg, 0.35mm, 1000m -30%

Fir Monofilament Extra Carp Magic Yellow, 15.50kg, 0.35mm, 1000m

ec3875-35
Stoc epuizat

70,14Lei(-30%) 49,39Lei

LEAD CLIP TAILRUBBER 30Buc accesorii /Set EXTRA CARP -45%

LEAD CLIP TAILRUBBER 30Buc accesorii /Set EXTRA CARP

ec3830
Stoc epuizat

13,20Lei(-45%) 7,25Lei

Tricou NASH Make It Happen Badge Pocket T Shirt - Navy Blue, Marime L

Tricou NASH Make It Happen Badge Pocket T Shirt - Navy Blue, Marime L

c2170
Stoc epuizat

123,01Lei

Bluza NASH Make It Happen Since 1978 Jumper Black, Marime S

Bluza NASH Make It Happen Since 1978 Jumper Black, Marime S

c2270
Stoc epuizat

224,68Lei

Afişare 1 - 20 din 21 (2 pagini)
Queries: 11, Total time: 1.873 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = 'f8e74c24810fd39038aedc5fc3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.138)
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.099)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("180309", "2", "1000", "464", "1", "39.400000000000", "1"),("4471", "2", "7", "96", "1", "7.380000000000", "2"),("146059", "1", "1001", "67", "1", "210.910000000000", "3"),("146061", "1", "1001", "67", "1", "236.960000000000", "4"),("4488", "2", "37", "96", "1", "8.730000000000", "5"),("96791", "2", "2", "96", "1", "8.550000000000", "6"),("72799", "2", "1001", "464", "1", "30.990000000000", "7"),("11459", "2", "9", "96", "1", "19.310000000000", "8"),("56574", "2", "2", "96", "1", "6.290000000000", "9"),("145707", "1", "5", "96", "1", "17.640000000000", "10"),("63519", "2", "5", "96", "1", "26.030000000000", "11"),("63489", "2", "4", "96", "1", "8.390000000000", "12"),("63486", "2", "2", "96", "1", "8.390000000000", "13"),("179011", "2", "11", "96", "1", "114.270000000000", "14"),("4492", "2", "1", "96", "1", "14.270000000000", "15"),("224970", "1", "0", "96", "1", "12.600000000000", "16"),("197719", "1", "0", "96", "1", "40.820000000000", "17"),("12929", "2", "0", "96", "1", "5.990000000000", "18"),("238591", "1", "0", "59", "1", "101.660000000000", "19"),("239027", "1", "0", "59", "1", "185.690000000000", "20"),("225490", "1", "0", "59", "1", "126.880000000000", "21")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.145)
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.244)
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.273)
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
8 (0.154)
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
9 (0.106)
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
10 (0.422)
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
11 (0.111)
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