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


Geanta DAM O.T.T. Carryall L 54x29x45cm
Exclusiv online!

Geanta DAM O.T.T. Carryall L 54x29x45cm

9040974979
Livrare 48-72 ore

344,83Lei

Husa Mulineta DAM O.T.T. Reel Case 10x20x16cm -44%
Exclusiv online!

Husa Mulineta DAM O.T.T. Reel Case 10x20x16cm

svs74982
Livrare 7-14 zile

59,95Lei(-44%) 33,28Lei

Husa Lansete DAM O.T.T. Rod Holdall Hardcase 192x12x8cm -53%
Exclusiv online!

Husa Lansete DAM O.T.T. Rod Holdall Hardcase 192x12x8cm

svs74975
Livrare 7-14 zile

425,83Lei(-53%) 199,90Lei

Maner Telescopic Minciog DAM O.T.T. 186cm -48%

Maner Telescopic Minciog DAM O.T.T. 186cm

svs74985
Livrare imediată!

54,89Lei(-48%) 28,30Lei

Lanseta Ron Thompson Steelhead Iconic Spin, 2.70m, 7-28g, 2buc -40%

Lanseta Ron Thompson Steelhead Iconic Spin, 2.70m, 7-28g, 2buc

o.tho.61415
Livrare imediată!

181,42Lei(-40%) 108,85Lei

Lanseta Ron Thompson Refined Light Boat 2.10M 60-120g 2SEG

Lanseta Ron Thompson Refined Light Boat 2.10M 60-120g 2SEG

o.tho.61345
Livrare imediată!

92,70Lei

SET RING BUSHNELL GRAVAT OT.H D=26 MM
Exclusiv online!

SET RING BUSHNELL GRAVAT OT.H D=26 MM

vb.er00003
Livrare 24-48 ore

78,06Lei

Cap Minciog DAM OTT Spoon Net Shake And Dry, 50x40x30cm -53%

Cap Minciog DAM OTT Spoon Net Shake And Dry, 50x40x30cm

svs74990
Livrare imediată!

84,89Lei(-53%) 40,31Lei

Cap Minciog DAM OTT Spoon Net Shake And Dry, 45x35x30cm -55%

Cap Minciog DAM OTT Spoon Net Shake And Dry, 45x35x30cm

svs74989
Livrare imediată!

79,90Lei(-55%) 36,30Lei

Husa DAM OTT Rod Holdall Soft 1 Rod, 171x23x6cm -64%
Exclusiv online!

Husa DAM OTT Rod Holdall Soft 1 Rod, 171x23x6cm

svs74976
Livrare 7-14 zile

174,95Lei(-64%) 62,48Lei

Mulineta DAM Impulse 4/Ott 4000 Fd 3+1BB Iasp + Gsp
Exclusiv online!

Mulineta DAM Impulse 4/Ott 4000 Fd 3+1BB Iasp + Gsp

svs73074
Livrare 7-14 zile

213,00Lei

Mulineta DAM Impulse 4/Ott 3000 Fd 3+1BB Iasp + Gsp
Exclusiv online!

Mulineta DAM Impulse 4/Ott 3000 Fd 3+1BB Iasp + Gsp

svs73073
Livrare 7-14 zile

200,00Lei

LANSETA RON THOMPSON 3BUC O.T.T. FEEDER 3.60M 10-60G -23%

LANSETA RON THOMPSON 3BUC O.T.T. FEEDER 3.60M 10-60G

o.tho.64837
Stoc epuizat

193,18Lei(-23%) 148,61Lei

Lanseta Feeder Ron Thompson O.T.T. Feeder 3.60m 60-120g -23%

Lanseta Feeder Ron Thompson O.T.T. Feeder 3.60m 60-120g

o.tho.64838
Stoc epuizat

198,80Lei(-23%) 152,92Lei

Husa lansete DAM O.T.T. Holdall 4 Tube pt 4 Lansete 192x16x10cm -35%

Husa lansete DAM O.T.T. Holdall 4 Tube pt 4 Lansete 192x16x10cm

9050974977
Stoc epuizat

350,36Lei(-35%) 227,73Lei

Maner Telescopic Minciog DAM O.T.T. 200cm -23%

Maner Telescopic Minciog DAM O.T.T. 200cm

svs74983
Stoc epuizat

49,61Lei(-23%) 38,16Lei

Maner Telescopic Minciog DAM O.T.T. 325cm -23%

Maner Telescopic Minciog DAM O.T.T. 325cm

a2.dam.74984
Stoc epuizat

69,54Lei(-23%) 53,49Lei

Varga RON THOMPSON REFINED TELEPOLE 3.00M -29%

Varga RON THOMPSON REFINED TELEPOLE 3.00M

o.tho.61366
Stoc epuizat

26,79Lei(-29%) 19,14Lei

Lanseta Ron Thompson Steelhead Iconic Spin 2.28M 8-25g 2SEG -23%

Lanseta Ron Thompson Steelhead Iconic Spin 2.28M 8-25g 2SEG

o.tho.62133
Stoc epuizat

107,42Lei(-23%) 82,63Lei

Lanseta Ultra Light Ron Thompson Trout and Perch 2.42m 5-20g -23%

Lanseta Ultra Light Ron Thompson Trout and Perch 2.42m 5-20g

o.tho.60893
Stoc epuizat

180,38Lei(-23%) 138,75Lei

Afişare 1 - 20 din 20 (1 pagini)
Queries: 12, Total time: 1.827 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = 'd5976ae0883e6cd5717a3b5084'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.125)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.131)
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.126)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("153373", "2", "1000", "124", "1", "289.770000000000", "1"),("159215", "1", "1000", "124", "1", "27.970000000000", "2"),("153663", "2", "1000", "124", "1", "167.980000000000", "3"),("175669", "2", "1007", "124", "1", "23.780000000000", "4"),("91244", "2", "1", "86", "1", "91.470000000000", "5"),("109351", "2", "1", "86", "1", "77.900000000000", "6"),("95715", "10", "1000", "255", "1", "65.600000000000", "7"),("233502", "2", "4", "124", "1", "33.870000000000", "8"),("233501", "2", "2", "124", "1", "30.500000000000", "9"),("233500", "2", "1003", "124", "1", "52.500000000000", "10"),("236962", "1", "1000", "124", "1", "178.990000000000", "11"),("236963", "1", "1000", "124", "1", "168.070000000000", "12"),("156951", "1", "0", "86", "1", "124.880000000000", "13"),("116556", "2", "0", "86", "1", "128.500000000000", "14"),("153665", "2", "0", "124", "1", "191.370000000000", "15"),("175670", "2", "0", "124", "1", "32.070000000000", "16"),("175671", "2", "0", "124", "1", "44.950000000000", "17"),("109315", "2", "0", "86", "1", "16.080000000000", "18"),("109223", "2", "0", "86", "1", "69.440000000000", "19"),("116555", "2", "0", "86", "1", "116.600000000000", "20")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.130)
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.218)
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.098)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.173)
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.075)
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.062)
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.479)
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.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:37