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 300 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


LANSETA PRESTON SUPER FEEDER 3.30M 50G 3+2seg

LANSETA PRESTON SUPER FEEDER 3.30M 50G 3+2seg

p0070007
Stoc epuizat

354,20Lei

Lanseta Shakespeare Skp Concept Specialist 3.30m, 1.50lb, 2seg

Lanseta Shakespeare Skp Concept Specialist 3.30m, 1.50lb, 2seg

1550384
Stoc epuizat

292,46Lei

Lanseta Shakespeare Skp Concept Specialist 3.30m, 1.00lb, 2seg

Lanseta Shakespeare Skp Concept Specialist 3.30m, 1.00lb, 2seg

1550382
Stoc epuizat

292,46Lei

Lanseta Shakespeare Superteam SFX Feeder, 3.30m, 90g, 3seg

Lanseta Shakespeare Superteam SFX Feeder, 3.30m, 90g, 3seg

1558424
Stoc epuizat

247,46Lei

Combo Mitchell Catch Pro Tele Light, 20-60g, 3.30m, 4seg

Combo Mitchell Catch Pro Tele Light, 20-60g, 3.30m, 4seg

1544448
Stoc epuizat

118,70Lei

Lanseta Delphin ARMADA NX TRAVEL BlackWay Cork 3.30m, 3lb, 8seg

Lanseta Delphin ARMADA NX TRAVEL BlackWay Cork 3.30m, 3lb, 8seg

101002524
Stoc epuizat

244,70Lei

Lanseta Delphin ETNA E3 Cork 3.30m, 3.00lbs, 2seg

Lanseta Delphin ETNA E3 Cork 3.30m, 3.00lbs, 2seg

101000279
Stoc epuizat

359,00Lei

Lanseta Delphin Method CONXEPT 3.30m, 60g, 3+3seg

Lanseta Delphin Method CONXEPT 3.30m, 60g, 3+3seg

101003236
Stoc epuizat

249,60Lei

Lanseta Mitchell Tanager 2 Red Feeder Rod MH, 3.30m, 20-80g, 2+2seg

Lanseta Mitchell Tanager 2 Red Feeder Rod MH, 3.30m, 20-80g, 2+2seg

1553739
Stoc epuizat

279,96Lei

Lanseta Daiwa Exceler Catfish 3.30m, 200-600g, 2seg

Lanseta Daiwa Exceler Catfish 3.30m, 200-600g, 2seg

d.11818.336
Stoc epuizat

494,08Lei

Lanseta Delphin Lycan Tele Feeder, 80g, 3.30m, 4+1seg

Lanseta Delphin Lycan Tele Feeder, 80g, 3.30m, 4+1seg

101003232
Stoc epuizat

281,99Lei

Lanseta Shakespeare Superteam Method Feeder Rod 3.30m, 60g, 2+2seg -62%

Lanseta Shakespeare Superteam Method Feeder Rod 3.30m, 60g, 2+2seg

1525575
Stoc epuizat

474,50Lei(-62%) 178,50Lei

Lanseta Golden Catch Bionic Feeder 3.30m, 120g, 3+3 Seg

Lanseta Golden Catch Bionic Feeder 3.30m, 120g, 3+3 Seg

gcz-2039180
Stoc epuizat

300,00Lei

Lanseta DAM Madcat White X-TAAZ Far Out 3.30m, 200-500g, 2seg

Lanseta DAM Madcat White X-TAAZ Far Out 3.30m, 200-500g, 2seg

mad.60845
Stoc epuizat

849,93Lei

Lanseta Abu Garcia SOLV AG2 Spinning Rod MH, 15-45g, 3.30m, 3seg

Lanseta Abu Garcia SOLV AG2 Spinning Rod MH, 15-45g, 3.30m, 3seg

1539096
Stoc epuizat

1.327,46Lei

Lanseta Delphin SYMBOL Feeder 3.30m, 100g, 3seg

Lanseta Delphin SYMBOL Feeder 3.30m, 100g, 3seg

101003127
Stoc epuizat

191,40Lei

Lanseta Garbolino Bullet Carp Feeder 3.30m, 20-75g, 2+3seg

Lanseta Garbolino Bullet Carp Feeder 3.30m, 20-75g, 2+3seg

20530gofrf8103330-2
Stoc epuizat

233,42Lei

Lanseta Zfish Miracle Feeder Rod, 90g, 3.30m, 3+3seg

Lanseta Zfish Miracle Feeder Rod, 90g, 3.30m, 3+3seg

ZF-9721
Stoc epuizat

218,97Lei

Lanseta Zfish Pegas Feeder Rod, 3.30m, 60-80g, 2+3seg

Lanseta Zfish Pegas Feeder Rod, 3.30m, 60-80g, 2+3seg

ZF-4604
Stoc epuizat

338,51Lei

LANSETA COLMIC NEXT ADVENTURE FEEDER 2SEC 3.30M 60GR

LANSETA COLMIC NEXT ADVENTURE FEEDER 2SEC 3.30M 60GR

canex02a
Stoc epuizat

792,00Lei

Afişare 161 - 180 din 204 (11 pagini)
Queries: 16, Total time: 200.341 ms [By time] [By id] [By file]
1 (0.089)
SELECT data
FROM `oc_session`
WHERE session_id = '7ece8fec202126228e0af98957'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.076)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (194.727)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%3.30m%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:697
5 (0.172)
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:1547
6 (1.159)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 160, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.127)
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.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.411)
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:1204
11 (0.111)
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:1223
12 (0.125)
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:982
13 (2.686)
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:904
14 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
15 (0.093)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
16 (0.093)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38