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 Berkley Cherrywood Original 2.00m 7-28g

Lanseta Berkley Cherrywood Original 2.00m 7-28g

1531528
Livrare imediată!

140,21Lei

Lanseta Berkley Cherrywood Original 2.00m 5-15g

Lanseta Berkley Cherrywood Original 2.00m 5-15g

1531527
Livrare imediată!

135,96Lei

ELASTIC TRABUCCO HYBRID SOLID CORE 5m 2.00mm match-feeder

ELASTIC TRABUCCO HYBRID SOLID CORE 5m 2.00mm match-feeder

102-04-020
Livrare imediată!

55,00Lei

Lanseta Palms MOLLA MGGS-67L2F 2.00M 2SEG
Exclusiv online!

Lanseta Palms MOLLA MGGS-67L2F 2.00M 2SEG

mggs-67l2f
Livrare 48-72ore

885,00Lei

MANER MINCIOG PRO FL COMPETITION TELE 2.00M

MANER MINCIOG PRO FL COMPETITION TELE 2.00M

64-45766
Livrare imediată!

72,90Lei

Lanseta Reiva Silent 2.00M 2-10g 2seg
Exclusiv online!

Lanseta Reiva Silent 2.00M 2-10g 2seg

1440-200
Livrare 48-72 ore

383,00Lei

Maner Minciog Telescopic Spro C-Tec S-Fix Handle, 2.00m

Maner Minciog Telescopic Spro C-Tec S-Fix Handle, 2.00m

003884-00520-00000
Livrare imediată!

91,00Lei

Lanseta Berkley URBN Micro Lure Spinning Rod, 2.00m, 3-`14g, 2seg -44%

Lanseta Berkley URBN Micro Lure Spinning Rod, 2.00m, 3-`14g, 2seg

1525610
Livrare imediată!

409,00Lei(-44%) 229,90Lei

Lanseta Konger Streeto Twitch Portable 1904ML, 7-21g, 2.00m, 4seg
Exclusiv online!

Lanseta Konger Streeto Twitch Portable 1904ML, 7-21g, 2.00m, 4seg

20406161005200
Livrare 48-72 ore

529,04Lei

Lanseta Berkley Cherrywood Spezi Perch Spin 202, 2.00m, 7-28g, 2seg

Lanseta Berkley Cherrywood Spezi Perch Spin 202, 2.00m, 7-28g, 2seg

1573343
Livrare imediată!

143,00Lei

Lanseta EnergoFish Wizard Active Spin, 2.00m, 10-30g, 2seg
Exclusiv online!

Lanseta EnergoFish Wizard Active Spin, 2.00m, 10-30g, 2seg

12063200
Livrare 24-48 ore

109,68Lei

Lanseta Spinning Daiwa WILDERNESS ST 2.00m, 2-10g, 2seg
Exclusiv online!

Lanseta Spinning Daiwa WILDERNESS ST 2.00m, 2-10g, 2seg

d.11873.200
Livrare 24-48 ore

490,08Lei

Maner Minciog Nytro Impax Put Over 2.00m

Maner Minciog Nytro Impax Put Over 2.00m

20500001
Livrare imediată!

200,02Lei

Lanseta, Daiwa, Ballistic, X, Spin, 2.00m,, 3-10g,, 2seg, d.11525.200, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Exclusiv online!

Lanseta, Daiwa, Ballistic, X, Spin, 2.00m,, 3-10g,, 2seg, d.11525.200, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.11525.200
Livrare 24-48 ore

522,93Lei

Lanseta Penn Legion Cat Silver Inliner, 2.00m , 200-300g, 1seg

Lanseta Penn Legion Cat Silver Inliner, 2.00m , 200-300g, 1seg

1519182
Livrare imediată!

339,96Lei

Lanseta Sunset Tataki SW20, 100-200g, 2.00m, 2seg

Lanseta Sunset Tataki SW20, 100-200g, 2.00m, 2seg

20311stsrl8958200-2
Livrare imediată!

321,45Lei

Maner Minciog Berkley URBN Stash Net Handle Tele, 2.00m -25%
Exclusiv online!

Maner Minciog Berkley URBN Stash Net Handle Tele, 2.00m

1529953
Livrare 7-14 zile

340,00Lei(-25%) 255,00Lei

Lanseta Greys Kite Single Handed Fly Rod 4 Line 3WT, 2.00m, 4seg
Exclusiv online!

Lanseta Greys Kite Single Handed Fly Rod 4 Line 3WT, 2.00m, 4seg

1564891
Livrare 7-14 zile

807,46Lei

Minciog Zebco Metal Power Landing Net 2.00m -34%
Exclusiv online!

Minciog Zebco Metal Power Landing Net 2.00m

7081200
Livrare 48-72ore

123,81Lei(-34%) 82,16Lei

Lanseta Greys Wing Streamflex Fly Rod 3 Line 3WT, 2.00m, 4seg
Exclusiv online!

Lanseta Greys Wing Streamflex Fly Rod 3 Line 3WT, 2.00m, 4seg

1571635
Livrare 7-14 zile

1.274,96Lei

Afişare 1 - 20 din 85 (5 pagini)
Queries: 15, Total time: 192.534 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '001bf790e0fa9e01ca2b78c7a0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.079)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (189.314)
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 "%2.00m%") 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:693
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:1547
6 (0.633)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.126)
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.124)
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
9 (0.295)
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
10 (0.114)
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
11 (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:978
12 (1.129)
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:900
13 (0.108)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.104)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
15 (0.116)
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