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 Prowess Insedia RS, 3.90m, 3.5lb, 2seg
Exclusiv online!

Lanseta Prowess Insedia RS, 3.90m, 3.5lb, 2seg

20233prcrl8070390-2-350
Livrare 48-72 ore

419,48Lei

Lanseta Prowess Insedia, 3.00m, 3.25lb, 2seg
Exclusiv online!

Lanseta Prowess Insedia, 3.00m, 3.25lb, 2seg

20233prcrj8070300-2-325
Livrare 48-72 ore

343,86Lei

Lanseta, Prowess, Insedia,, 3.60m,, 3.50lb,, 2seg, 20233prcrj8070360-2-350, Lansete Crap, Lansete Crap Prowess, Prowess
Exclusiv online!

Lanseta, Prowess, Insedia,, 3.60m,, 3.50lb,, 2seg, 20233prcrj8070360-2-350, Lansete Crap, Lansete Crap Prowess, Prowess

20233prcrj8070360-2-350
Livrare 48-72 ore

338,00Lei

Lanseta, Prowess, Scorpium, 3.60m,, 3.00lbs,, 2seg, 20233prcrf8004360-2-3, Lansete Crap, Lansete Crap Prowess, Lansete Prowess, Crap Prowess, Prowess
Lanseta, Prowess, Scorpium, 3.60m,, 3.00lbs,, 3seg, 20233prcrg8004360-3-3, Lansete Crap, Lansete Crap Prowess, Lansete Prowess, Crap Prowess, Prowess
Mulineta Prowess Xcelia Spod WRX 8004 FD

Mulineta Prowess Xcelia Spod WRX 8004 FD

30733prcrm75108004spod
Livrare imediată!

360,09Lei

Picheti Prowess Masurare Distanta
Exclusiv online!

Picheti Prowess Masurare Distanta

42133prcah0007
Livrare 48-72 ore

88,89Lei

Hanorac Prowess, Marimea L, Verde
Exclusiv online!

Hanorac Prowess, Marimea L, Verde

80533prccm2145-l
Livrare 48-72 ore

278,84Lei

Kit 4 Lansete Prowess Insedia RS, 3.5lbs, 3.60m, 2seg -20%
Exclusiv online!

Kit 4 Lansete Prowess Insedia RS, 3.5lbs, 3.60m, 2seg

995010084
Livrare 48-72 ore

1.621,67Lei(-20%) 1.297,33Lei

Lanseta Prowess Excelia 3.60m, 3.50lb, 2seg
Exclusiv online!

Lanseta Prowess Excelia 3.60m, 3.50lb, 2seg

20233prcrj8030360-2-350
Livrare 48-72 ore

465,50Lei

Rig Crap W-Rigs Prowess Ronnie Spinner Rig Nr.6, 3buc/plic
Exclusiv online!

Rig Crap W-Rigs Prowess Ronnie Spinner Rig Nr.6, 3buc/plic

120233prcam0540t6b
Livrare 48-72 ore

18,86Lei

Rig Crap W-Rigs Prowess Ronnie Spinner Rig Nr.4, 3buc/plic
Exclusiv online!

Rig Crap W-Rigs Prowess Ronnie Spinner Rig Nr.4, 3buc/plic

120233prcam0540t4b
Livrare 48-72 ore

18,86Lei

Kit, 4, Mulinete, Prowess, Insedia, 8004, FD, 995020007, Mulinete Crap, Mulinete Crap Prowess, Mulinete Prowess, Crap Prowess, Prowess -20%
Exclusiv online!

Kit, 4, Mulinete, Prowess, Insedia, 8004, FD, 995020007, Mulinete Crap, Mulinete Crap Prowess, Mulinete Prowess, Crap Prowess, Prowess

995020007
Livrare 48-72 ore

1.374,20Lei(-20%) 1.099,36Lei

Kit 4 Mulinete Prowess Excelia 6008FD -20%
Exclusiv online!

Kit 4 Mulinete Prowess Excelia 6008FD

995020008
Livrare 48-72 ore

1.909,70Lei(-20%) 1.527,76Lei

Elastic Momeala Elitech Prowess 8mm -24%

Elastic Momeala Elitech Prowess 8mm

acpr0760080
Livrare imediată!

6,47Lei(-24%) 4,91Lei

Rod Pod Prowess Starpod 3-4 poz.
Exclusiv online!

Rod Pod Prowess Starpod 3-4 poz.

41333prceh3007
Livrare 48-72 ore

945,85Lei

Pelete Flotante Aromate Prowess Fish 10mm
Exclusiv online!

Pelete Flotante Aromate Prowess Fish 10mm

prcaa0002-10mm
Livrare 48-72 ore

14,27Lei

Pelete Flotante Aromate Prowess Fish 20mm
Exclusiv online!

Pelete Flotante Aromate Prowess Fish 20mm

prcaa0002-20mm
Livrare 48-72 ore

22,05Lei

Avertizor Electronic PROWESS GI

Avertizor Electronic PROWESS GI

40333prcec3005
Livrare imediată!

50,96Lei

Pelete Flotante Prowess 6mm -26%

Pelete Flotante Prowess 6mm

acca7140060
Livrare imediată!

8,00Lei(-26%) 5,90Lei

Afişare 41 - 60 din 143 (8 pagini)
Queries: 13, Total time: 177.289 ms [By time] [By id] [By file]
1 (0.134)
SELECT data
FROM `oc_session`
WHERE session_id = 'a021cee17c0fa617c42ff9f8df'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.135)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (173.626)
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 "%prowess%") 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.180)
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.857)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.240)
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:1196
8 (0.112)
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:1218
9 (0.114)
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:986
10 (1.472)
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:905
11 (0.105)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.101)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (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