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


Lanseta Rapture Deep Fall Slow Pitch M 1.98m 100g
Exclusiv online!

Lanseta Rapture Deep Fall Slow Pitch M 1.98m 100g

126-19-200
Livrare 48-72 ore

367,97Lei

Lanseta Abu Garcia Svartzonker X 642H, 40-100g, 1.93m, 2seg
Exclusiv online!

Lanseta Abu Garcia Svartzonker X 642H, 40-100g, 1.93m, 2seg

1579820
Livrare 7-14 zile

408,74Lei

Lanseta Penn Conflict Jigging Cast, 200g, 1.91m, 1seg
Exclusiv online!

Lanseta Penn Conflict Jigging Cast, 200g, 1.91m, 1seg

1530411
Livrare 7-14 zile

623,30Lei

Lingurita Oscilanta JACKALL Rekuze, Karekin, 1.9cm, 1.0g
Exclusiv online!

Lingurita Oscilanta JACKALL Rekuze, Karekin, 1.9cm, 1.0g

ja.807246148
Livrare 24-48 ore

34,52Lei

Lanseta Casting Okuma Guide Select Jerk EH, 60-100g , 1.97m, 2seg
Exclusiv online!

Lanseta Casting Okuma Guide Select Jerk EH, 60-100g , 1.97m, 2seg

gs-c-662xxh-1
Livrare 48-72 ore

509,30Lei

Lanseta Zeck Evo Cat Vertic, 180g, 1.90m, 1+1seg

Lanseta Zeck Evo Cat Vertic, 180g, 1.90m, 1+1seg

20305100191
Livrare imediată!

792,17Lei

Lingurita Oscilanta JACKALL Rekuze, Kira Olive, 1.9cm, 1.0g
Exclusiv online!

Lingurita Oscilanta JACKALL Rekuze, Kira Olive, 1.9cm, 1.0g

ja.807246186
Livrare 24-48 ore

34,52Lei

Lanseta OVERFIGHT Tank Vertical 1.90m, 150g, 1seg

Lanseta OVERFIGHT Tank Vertical 1.90m, 150g, 1seg

20339oft-150707-1
Livrare imediată!

363,19Lei

Lanseta Abu Garica Beast Pro Jerkbait Casting Rod EH, 45-120g, 1.98m, 1+1seg
Exclusiv online!

Lanseta Abu Garica Beast Pro Jerkbait Casting Rod EH, 45-120g, 1.98m, 1+1seg

1612413
Livrare 7-14 zile

987,30Lei

Lanseta Spinning DAIWA Prorex E Casting 662 XXHRB 1.98m, 60-120g, 2seg
Exclusiv online!

Lanseta Spinning DAIWA Prorex E Casting 662 XXHRB 1.98m, 60-120g, 2seg

d.pxe662xxhrbbf
Livrare 24-48 ore

426,74Lei

Combo DAM Fire Wave XP Spin, 1000, 290/0.18mm, 7-22g, 1.98m, 2seg
Exclusiv online!

Combo DAM Fire Wave XP Spin, 1000, 290/0.18mm, 7-22g, 1.98m, 2seg

1608864
Livrare 7-14 zile

234,87Lei

Lingurita Oscilanta JACKALL Rekuze, Yazy Silver White UV, 1.9cm, 1.0g
Exclusiv online!

Lingurita Oscilanta JACKALL Rekuze, Yazy Silver White UV, 1.9cm, 1.0g

ja.807246100
Livrare 24-48 ore

34,52Lei

Lanseta SAVAGE GEAR SGS2 JIG M, 40-120g, 1.93m, 1seg -76%
Exclusiv online!

Lanseta SAVAGE GEAR SGS2 JIG M, 40-120g, 1.93m, 1seg

svs74908
Livrare 7-14 zile

424,93Lei(-76%) 99,95Lei

Lanseta Catgear X-Rock Solid Stick 1.95m, 200g, 1+1 seg
Exclusiv online!

Lanseta Catgear X-Rock Solid Stick 1.95m, 200g, 1+1 seg

300-19-195
Livrare 48-72 ore

652,67Lei

Lanseta Savage Gear SGS6 Slow Jigging, Up To 200g, 1.93m, 1seg
Exclusiv online!

Lanseta Savage Gear SGS6 Slow Jigging, Up To 200g, 1.93m, 1seg

svs74948
Livrare 7-14 zile

1.044,24Lei

Lanseta PENN Retaliate X Solid Jigging Cast Rod, Up To 200g, 1.90m, 1+1seg
Exclusiv online!

Lanseta PENN Retaliate X Solid Jigging Cast Rod, Up To 200g, 1.90m, 1+1seg

1621307
Livrare 7-14 zile

664,97Lei

Lanseta PENN Retaliate X Light Jigging Spin Rod, Up To 120g, 1.88m, 1+1seg
Exclusiv online!

Lanseta PENN Retaliate X Light Jigging Spin Rod, Up To 120g, 1.88m, 1+1seg

1621293
Livrare 7-14 zile

623,30Lei

Lanseta Abu Garcia Beast Pro Pelagic Casting Rod 6511H, 50-120g, 1.95m, 1+1seg
Exclusiv online!

Lanseta Abu Garcia Beast Pro Pelagic Casting Rod 6511H, 50-120g, 1.95m, 1+1seg

1577392
Livrare 7-14 zile

1.007,60Lei

Lanseta SAVAGE GEAR SGS6 SJ 6FT4IN XF M Baitcast, Up To 150g, 1.93m, 1seg -67%
Exclusiv online!

Lanseta SAVAGE GEAR SGS6 SJ 6FT4IN XF M Baitcast, Up To 150g, 1.93m, 1seg

svs74947
Livrare 7-14 zile

1.199,94Lei(-67%) 394,24Lei

Elastic Powergum Method Feeder Konger Shock Absorber Clear, 5m, 1.2mm, 10kg
Exclusiv online!

Elastic Powergum Method Feeder Konger Shock Absorber Clear, 5m, 1.2mm, 10kg

110706960400032
Livrare 48-72 ore

20,56Lei

Afişare 1 - 20 din 29 (2 pagini)
Queries: 11, Total time: 1.721 ms [By time] [By id] [By file]
1 (0.090)
SELECT data
FROM `oc_session`
WHERE session_id = '251c00ae386a7e234f8041630d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.072)
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.156)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("116526", "2", "1000", "105", "1", "304.110000000000", "1"),("199743", "1", "1000", "122", "1", "337.800000000000", "2"),("192599", "1", "1000", "88", "1", "515.120000000000", "3"),("218033", "1", "1000", "150", "1", "28.530000000000", "4"),("202145", "1", "1000", "17", "1", "420.910000000000", "5"),("198187", "1", "1001", "656", "1", "654.690000000000", "6"),("218035", "1", "1000", "150", "1", "28.530000000000", "7"),("239783", "1", "1", "797", "1", "300.160000000000", "8"),("233314", "1", "1000", "122", "1", "815.950000000000", "9"),("244080", "1", "1000", "11", "1", "352.680000000000", "10"),("231268", "2", "1000", "124", "1", "194.110000000000", "11"),("218031", "1", "1000", "150", "1", "28.530000000000", "12"),("237897", "1", "1000", "85", "1", "82.600000000000", "13"),("170238", "1", "1000", "514", "1", "539.400000000000", "14"),("236114", "1", "1000", "85", "1", "863.010000000000", "15"),("233596", "1", "1000", "88", "1", "549.560000000000", "16"),("233598", "1", "1000", "88", "1", "515.120000000000", "17"),("199641", "1", "1000", "122", "1", "832.730000000000", "18"),("237896", "1", "1000", "85", "1", "325.820000000000", "19"),("181395", "1", "1000", "500", "1", "16.990000000000", "20"),("123015", "2", "1", "469", "1", "17.550000000000", "21"),("238814", "1", "1000", "85", "1", "111.780000000000", "22"),("229409", "1", "0", "117", "1", "647.800000000000", "23"),("199071", "1", "0", "122", "1", "509.970000000000", "24"),("236340", "1", "0", "85", "1", "176.790000000000", "25"),("242092", "1", "0", "805", "1", "687.080000000000", "26"),("198471", "1", "0", "122", "1", "184.930000000000", "27"),("243774", "1", "0", "805", "1", "687.080000000000", "28"),("225573", "2", "0", "97", "1", "25.210000000000", "29")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.119)
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.175)
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.196)
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.080)
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.065)
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.545)
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.081)
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