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

Produse ce potrivesc criteriilor de căutare


Lanseta Cormoran Pro Carp XR B 3.60m 3lbs 2Seg -20%

Lanseta Cormoran Pro Carp XR B 3.60m 3lbs 2Seg

c.20.0630361
Livrare imediată!

219,00Lei(-20%) 175,20Lei

Lanseta Cormoran Cross Water Spinning 2.40M 15-40g 2SEG -30%
Exclusiv online!

Lanseta Cormoran Cross Water Spinning 2.40M 15-40g 2SEG

c.27.4040240
Livrare 24-48 ore

243,56Lei(-30%) 170,49Lei

Mulineta Cormoran Ultra Light Cross Water 5PiF 500

Mulineta Cormoran Ultra Light Cross Water 5PiF 500

c.12.59050
Livrare imediată!

117,46Lei

Lanseta Cormoran Power Creek UL Spin 2.10m 3-14g 2SEG

Lanseta Cormoran Power Creek UL Spin 2.10m 3-14g 2SEG

c.27.8514211
Livrare imediată!

143,24Lei

LINGURITA ROTATIVA CORMORAN BULLET NR.1/3G COOPER

LINGURITA ROTATIVA CORMORAN BULLET NR.1/3G COOPER

f.50.84021
Livrare imediată!

9,31Lei

Lanseta Cormoran Power Creek Jigger 2.10m 5-25g 2SEG

Lanseta Cormoran Power Creek Jigger 2.10m 5-25g 2SEG

c.27.8525211
Livrare imediată!

149,32Lei

SALOPETA CORMORAN NEOPREN XL MAR.42/43
Exclusiv online!

SALOPETA CORMORAN NEOPREN XL MAR.42/43

a8.94.03243.xl
Livrare 24-48 ore

692,39Lei

Mulineta Cormoran Cross Water 5PiF 3000

Mulineta Cormoran Cross Water 5PiF 3000

c.12.59300
Livrare imediată!

127,44Lei

Mulineta Cormoran VeyCor BR 7PiF 5000

Mulineta Cormoran VeyCor BR 7PiF 5000

c.19.74500
Livrare imediată!

210,73Lei

LINGURITA ROTATIVA CORMORAN ORAN. BULLET NR.3 COOPER 7G

LINGURITA ROTATIVA CORMORAN ORAN. BULLET NR.3 COOPER 7G

f.50.84023
Livrare imediată!

10,75Lei

Mulineta Cormoran Cross Water 5PiF 1000
Exclusiv online!

Mulineta Cormoran Cross Water 5PiF 1000

c.12.59100
Livrare 24-48 ore

112,48Lei

Cosulet CORMORAN FEEDER FARA PLUMB PREMIUM ROTUND 32MM 15G
Exclusiv online!

Cosulet CORMORAN FEEDER FARA PLUMB PREMIUM ROTUND 32MM 15G

a.49.37020
Livrare 24-48 ore

8,48Lei

LINGURITA ROTATIVA CORMORAN BULLET NR.2 COOPER 4G

LINGURITA ROTATIVA CORMORAN BULLET NR.2 COOPER 4G

f.50.84022
Livrare imediată!

9,31Lei

Cosulet CORMORAN FEEDER FARA PLUMB PREMIUM ROTUND 44MM 40G
Exclusiv online!

Cosulet CORMORAN FEEDER FARA PLUMB PREMIUM ROTUND 44MM 40G

a.49.37340
Livrare 24-48 ore

9,48Lei

Mulineta Cormoran Cross Water 5PiF 2000
Exclusiv online!

Mulineta Cormoran Cross Water 5PiF 2000

c.12.59200
Livrare 24-48 ore

118,07Lei

LANSETA CORMORAN 2 SEG .RAYCOR X 2.40M/10-35G -30%

LANSETA CORMORAN 2 SEG .RAYCOR X 2.40M/10-35G

c.27.8003524
Livrare imediată!

214,03Lei(-30%) 149,82Lei

CIZME CORMORAN PIEPT MARIME 44
Exclusiv online!

CIZME CORMORAN PIEPT MARIME 44

a8.95.07444
Livrare 24-48 ore

314,84Lei

LINGURITA ROTATIVA CORMORAN BULLET NR.3 SILVER HOLO 7G

LINGURITA ROTATIVA CORMORAN BULLET NR.3 SILVER HOLO 7G

f.50.84033
Livrare imediată!

10,75Lei

Lanseta Cormoran Power Creek Spin 2.40m 20-60g -10%
Exclusiv online!

Lanseta Cormoran Power Creek Spin 2.40m 20-60g

c.27.8560240
Livrare 24-48 ore

188,48Lei(-10%) 169,63Lei

CIZME CORMORAN PIEPT MARIME 42

CIZME CORMORAN PIEPT MARIME 42

a8.95.07442
Livrare imediată!

314,84Lei

Afişare 21 - 40 din 659 (33 pagini)
Queries: 15, Total time: 208.880 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = 'a53851a9aac6add869f869e819'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
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 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.036)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
6 (198.275)
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 = '0' AND (pd.tag LIKE "%cormoran%") 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
7 (0.191)
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
8 (2.689)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
9 (0.484)
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.138)
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.197)
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 (6.108)
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.143)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.103)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
15 (0.110)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38