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


Combo Abu Garcia Max X Spinning Combo 70M, 5-25g, 2.13m, 6seg
Exclusiv online!

Combo Abu Garcia Max X Spinning Combo 70M, 5-25g, 2.13m, 6seg

1622868
Livrare 7-14 zile

302,98Lei

Combo DAM Full Tech Tele Spin 2000, 0.18mm/290m, 5-15g, 1.80m 5sec

Combo DAM Full Tech Tele Spin 2000, 0.18mm/290m, 5-15g, 1.80m 5sec

1608883
Livrare imediată!

87,43Lei

Vobler DUO Terrif DC-9 Bullet, CCC0517 Marine Ayu, 9cm, 15g

Vobler DUO Terrif DC-9 Bullet, CCC0517 Marine Ayu, 9cm, 15g

duo42414
Livrare imediată!

97,49Lei

Vobler DUO Terrif DC-9 Bullet, DLB0230 Ghost Pearl Chart, 9cm, 15g
Exclusiv online!

Vobler DUO Terrif DC-9 Bullet, DLB0230 Ghost Pearl Chart, 9cm, 15g

duo29913
Livrare 48-72 ore

97,49Lei

Combo Abu Garcia Max SX Spinning 902M, 7-28g, 2.74m, 2seg
Exclusiv online!

Combo Abu Garcia Max SX Spinning 902M, 7-28g, 2.74m, 2seg

1622854
Livrare 7-14 zile

443,31Lei

Lingurita Oscilanta MAPSO Lukris Cobra No.2, Silver, Ancora Nr.2, 9cm, 20g
Exclusiv online!

Lingurita Oscilanta MAPSO Lukris Cobra No.2, Silver, Ancora Nr.2, 9cm, 20g

pco2p
Livrare 48-72 ore

28,35Lei

Lingurita Oscilanta MAPSO Preca No.4, 810 Silver, Ancora Nr.1, 9cm, 20g
Exclusiv online!

Lingurita Oscilanta MAPSO Preca No.4, 810 Silver, Ancora Nr.1, 9cm, 20g

ppre4p-810
Livrare 48-72 ore

66,99Lei

Lanseta Okuma Guide Select Long Distance Spinning M, 20-28g , 2.74m, 2seg
Exclusiv online!

Lanseta Okuma Guide Select Long Distance Spinning M, 20-28g , 2.74m, 2seg

gs-s-902m-1
Livrare 48-72 ore

580,49Lei

Lingurita Oscilanta MAPSO Preca No.4, P-064 Silver, Ancora Nr.1, 9cm, 20g
Exclusiv online!

Lingurita Oscilanta MAPSO Preca No.4, P-064 Silver, Ancora Nr.1, 9cm, 20g

ppre4p-064
Livrare 48-72 ore

66,99Lei

Lingurita Oscilanta MAPSO Preca No.4, O-064 Gold, Ancora Nr.1, 9cm, 20g
Exclusiv online!

Lingurita Oscilanta MAPSO Preca No.4, O-064 Gold, Ancora Nr.1, 9cm, 20g

ppre4o-064
Livrare 48-72 ore

66,99Lei

Fir Monofilament Mikado Sensual N.G. Classic Transparent 50m 2kg 0.10mm
Exclusiv online!

Fir Monofilament Mikado Sensual N.G. Classic Transparent 50m 2kg 0.10mm

zsn500-50-010
Livrare 48-72 ore

15,13Lei

Lanseta INSOMNIA Z17 Belly Concept Spin, 50-250g, 1.70cm, 1seg

Lanseta INSOMNIA Z17 Belly Concept Spin, 50-250g, 1.70cm, 1seg

90 017
Livrare imediată!

600,92Lei

Lanseta Rapture Loomis & Franklin Classic Predator 2.13m 7-28g
Exclusiv online!

Lanseta Rapture Loomis & Franklin Classic Predator 2.13m 7-28g

121-77-001
Livrare 48-72 ore

266,28Lei

Lanseta Rapture Loomis & Franklin Classic Predator 2.43m 7-28g
Exclusiv online!

Lanseta Rapture Loomis & Franklin Classic Predator 2.43m 7-28g

121-77-002
Livrare 48-72 ore

291,71Lei

Lanseta TRABUCCO Swims Deep Quiver 2.70m, 250g, 2+2seg
Exclusiv online!

Lanseta TRABUCCO Swims Deep Quiver 2.70m, 250g, 2+2seg

161-90-010
Livrare 48-72 ore

509,30Lei

Lanseta TRABUCCO Swims Deep Quiver 3.00m, 250g, 2+2seg
Exclusiv online!

Lanseta TRABUCCO Swims Deep Quiver 3.00m, 250g, 2+2seg

161-90-020
Livrare 48-72 ore

571,33Lei

Lanseta TRABUCCO Swims Deep Quiver 3.50m, 250g, 2+2seg
Exclusiv online!

Lanseta TRABUCCO Swims Deep Quiver 3.50m, 250g, 2+2seg

161-90-030
Livrare 48-72 ore

662,84Lei

Combo DAM Full Tech Spin 2000, 0.18mm/290m, 5-20g, 1.80m 2sec -22%

Combo DAM Full Tech Spin 2000, 0.18mm/290m, 5-20g, 1.80m 2sec

1608901
Stoc epuizat

98,62Lei(-22%) 77,10Lei

Wafter FEEDERX Orange, Sweet Formula, 9mm, 25g -31%

Wafter FEEDERX Orange, Sweet Formula, 9mm, 25g

plf109-9
Stoc epuizat

32,37Lei(-31%) 22,20Lei

Vobler DUO Terrif DC-9 Bullet, AHA0010 Ayu, 9cm, 15g -26%

Vobler DUO Terrif DC-9 Bullet, AHA0010 Ayu, 9cm, 15g

duo58050
Stoc epuizat

97,49Lei(-26%) 72,60Lei

Afişare 1 - 20 din 25 (2 pagini)
Queries: 12, Total time: 2.128 ms [By time] [By id] [By file]
1 (0.171)
SELECT data
FROM `oc_session`
WHERE session_id = '0d2687c54ab01d42cd7bdf5598'
/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.146)
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.168)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("233360", "1", "1000", "122", "1", "250.400000000000", "1"),("231340", "2", "1001", "124", "1", "72.260000000000", "2"),("222094", "1", "1002", "459", "1", "80.570000000000", "3"),("222099", "1", "1000", "459", "1", "80.570000000000", "4"),("233344", "1", "1000", "122", "1", "366.370000000000", "5"),("240953", "1", "1000", "146", "1", "23.430000000000", "6"),("240959", "1", "1000", "146", "1", "55.360000000000", "7"),("201439", "1", "1000", "17", "1", "479.740000000000", "8"),("240962", "1", "1000", "146", "1", "55.360000000000", "9"),("242650", "1", "1000", "146", "1", "55.360000000000", "10"),("169891", "1", "1000", "224", "1", "12.500000000000", "11"),("246896", "1", "1001", "809", "1", "496.630000000000", "12"),("116611", "2", "1000", "105", "1", "220.070000000000", "13"),("116612", "2", "1000", "105", "1", "241.080000000000", "14"),("244845", "2", "1000", "58", "1", "420.910000000000", "15"),("244847", "2", "1000", "58", "1", "472.170000000000", "16"),("244849", "2", "1000", "58", "1", "547.800000000000", "17"),("231345", "2", "0", "124", "1", "63.720000000000", "18"),("237488", "1", "0", "361", "1", "20.000000000000", "19"),("222090", "1", "0", "459", "1", "60.000000000000", "20"),("222091", "1", "0", "459", "1", "60.000000000000", "21"),("213631", "1", "0", "224", "1", "4.380000000000", "22"),("147517", "2", "0", "17", "1", "290.000000000000", "23"),("222092", "1", "0", "459", "1", "60.000000000000", "24"),("53061", "2", "0", "67", "1", "13.760000000000", "25")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.136)
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.259)
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.141)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PESCUITLAFEEDER S.R.L"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.211)
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.094)
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.072)
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.516)
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.112)
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