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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


BURGHIU PROLOGIC ULTRA SLIM 0,8MM

BURGHIU PROLOGIC ULTRA SLIM 0,8MM

a.pro.54399
Livrare imediată!

25,64Lei

SET BURGHIU BOILIES B JAXON

SET BURGHIU BOILIES B JAXON

ac-3553b
Livrare imediată!

32,00Lei

BURGHIU EXTRA CARP CU MANER DIN PLASTIC 6CM

BURGHIU EXTRA CARP CU MANER DIN PLASTIC 6CM

ec6107
Livrare imediată!

6,50Lei

BURGHIU PROLOGIC -40%
Exclusiv online!

BURGHIU PROLOGIC

a.pro.49957
Livrare 24-48 ore

28,61Lei(-40%) 17,17Lei

Suport umbrela Delphin Cu Burghiu -32%

Suport umbrela Delphin Cu Burghiu

435001020
Livrare imediată!

34,00Lei(-32%) 23,00Lei

Carp Expert BURGHIU BOILIES
Exclusiv online!

Carp Expert BURGHIU BOILIES

80203403
Livrare 24-48 ore

11,00Lei

BURGHIU MOSTIRO XPERT

BURGHIU MOSTIRO XPERT

4026
Livrare imediată!

7,40Lei

BURGHIU THE ONE BOILIE DRILL, 11CM
Exclusiv online!

BURGHIU THE ONE BOILIE DRILL, 11CM

80209040
Livrare 24-48 ore

15,01Lei

BURGHIU INOX 7CM SS MOSTIRO

BURGHIU INOX 7CM SS MOSTIRO

ai-0965
Livrare imediată!

5,80Lei

BURGHIU CARP EXPERT
Exclusiv online!

BURGHIU CARP EXPERT

80203062
Livrare 24-48 ore

6,70Lei

Burghiu Mostiro Mini
Exclusiv online!

Burghiu Mostiro Mini

4086
Livrare 48-72 ore

6,60Lei

BURGHIU CARP ACADEMY FLUO
Exclusiv online!

BURGHIU CARP ACADEMY FLUO

8100-239
Livrare 48-72 ore

9,00Lei

Burghiu Select Baits Boilie and Nut Drill Mini 1.5mm/3.0cm

Burghiu Select Baits Boilie and Nut Drill Mini 1.5mm/3.0cm

sel-218012
Livrare imediată!

12,99Lei

Burghiu Carp Expert Cu Maner Din Cauciuc

Burghiu Carp Expert Cu Maner Din Cauciuc

80203052
Livrare imediată!

5,00Lei

Burghiu Carp Spirit 6mm

Burghiu Carp Spirit 6mm

871000361
Livrare imediată!

21,00Lei

BURGHIU FOX EDGES MICRO DRILL 1MM

BURGHIU FOX EDGES MICRO DRILL 1MM

cac632
Livrare imediată!

22,30Lei

SET CROSETE PLUS BURGHIU EXTRA CARP. 3BUC/PLIC -29%

SET CROSETE PLUS BURGHIU EXTRA CARP. 3BUC/PLIC

ec6244
Livrare imediată!

13,99Lei(-29%) 9,90Lei

CXP BURGHIU BOILIES FLAT GRIP
Exclusiv online!

CXP BURGHIU BOILIES FLAT GRIP

80206200
Livrare 24-48 ore

6,00Lei

Burghiu Lineaeffe Boilies Negru/Gri
Exclusiv online!

Burghiu Lineaeffe Boilies Negru/Gri

a.4990222
Livrare 24-48 ore

12,99Lei

Set Avid Carp crosete + burghiu Retracta Tool Set

Set Avid Carp crosete + burghiu Retracta Tool Set

a0590010
Livrare imediată!

112,46Lei

Afişare 41 - 60 din 102 (6 pagini)
Queries: 6, Total time: 3.973 ms [By time] [By id] [By file]
1 (0.154)
SELECT data
FROM `oc_session`
WHERE session_id = 'f73cca6150e182e03db59bc51e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.139)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.122)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (2.785)
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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+burghiu' IN BOOLEAN MODE)) 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:737
5 (0.642)
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:184
6 (0.131)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38