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


SET TRABUCCO GENIUS SPECIALIST TAVA PLUS SUPORT
Exclusiv online!

SET TRABUCCO GENIUS SPECIALIST TAVA PLUS SUPORT

116-15-110
Livrare 48-72ore

85,00Lei

SET K-KARP DRAKE TX BITE INDICATOR SET 4+1
Exclusiv online!

SET K-KARP DRAKE TX BITE INDICATOR SET 4+1

019-25-930
Livrare 48-72 ore

841,00Lei

Set Avertizoare Carp Hunter Alfa 4 plus 1

Set Avertizoare Carp Hunter Alfa 4 plus 1

78005274
Livrare imediată!

432,01Lei

Set Monturi Benzar Method Feeder Matrita Si Pelete Nr.10 7.65kg 40g

Set Monturi Benzar Method Feeder Matrita Si Pelete Nr.10 7.65kg 40g

79805040
Livrare imediată!

50,00Lei

TAPARINE TRABUCCO SABIKY 6 BUC PER SET

TAPARINE TRABUCCO SABIKY 6 BUC PER SET

183-20-020
Livrare imediată!

15,01Lei

TRABUCCO AERO SP. FLATBED METHOD INLINE 15+30g/2pcs/set
Exclusiv online!

TRABUCCO AERO SP. FLATBED METHOD INLINE 15+30g/2pcs/set

140-66-100
Livrare 48-72 ore

17,01Lei

SET AVERTIZOR JAXON XTR CRAP SENSITIVE MAGIC 2+1

SET AVERTIZOR JAXON XTR CRAP SENSITIVE MAGIC 2+1

aj-syx2+1ax
Livrare imediată!

630,00Lei

BATERII GP LR1 1.5V 2BUCATI SET

BATERII GP LR1 1.5V 2BUCATI SET

4891199000065
Livrare imediată!

8,00Lei

Set Suporti Feeder Falcon V si U

Set Suporti Feeder Falcon V si U

f4300
Livrare imediată!

24,00Lei

SET AVERTIZOARE KAMASAKI THUNDER C3-W 3 plus 1

SET AVERTIZOARE KAMASAKI THUNDER C3-W 3 plus 1

78007303
Livrare imediată!

384,00Lei

SET FOLIE AUTOCOLANT REFLECTORIZANT CARP ZOOM 15x20cm alb/galben/rosu

SET FOLIE AUTOCOLANT REFLECTORIZANT CARP ZOOM 15x20cm alb/galben/rosu

cz3970
Livrare imediată!

22,00Lei

SET AVERTIZORI CARP EXPERT TEVERE 2+1

SET AVERTIZORI CARP EXPERT TEVERE 2+1

78000721
Livrare imediată!

512,00Lei

SET BANDA COLMIC LANSETE NEOPREN 40x70mm

SET BANDA COLMIC LANSETE NEOPREN 40x70mm

rb4070
Livrare imediată!

34,00Lei

DANDINETA JAXON MIX 2D 2GR 3CM 5/SET -21%

DANDINETA JAXON MIX 2D 2GR 3CM 5/SET

bp-jdd02mix
Livrare imediată!

61,00Lei(-21%) 47,90Lei

BAMBINE NOAPTE MOSTIRO 100 BUC SET

BAMBINE NOAPTE MOSTIRO 100 BUC SET

nn-00000043
Livrare imediată!

40,00Lei

SET PLUMBI FOX KWIK CHANGE POP UP WEIGHTS
Exclusiv online!

SET PLUMBI FOX KWIK CHANGE POP UP WEIGHTS

cac518
Livrare 7-14 zile

134,10Lei

Set tacamuri Coghlans din plastic Duracon
Exclusiv online!

Set tacamuri Coghlans din plastic Duracon

c9450
Livrare 24-48 ore

31,00Lei

Set Avertizoare FOX Mini Micron X inc. Hardcases + Statie 2+1 -17%
Exclusiv online!

Set Avertizoare FOX Mini Micron X inc. Hardcases + Statie 2+1

cei197
Livrare 7-14 zile

967,46Lei(-17%) 799,99Lei

Set Avertizoare Carp Hunter Alfa 3 plus 1
Exclusiv online!

Set Avertizoare Carp Hunter Alfa 3 plus 1

78005273
Livrare 24-48 ore

376,00Lei

SET NALUCI SAVAGE CANNIBAL S 20BUC

SET NALUCI SAVAGE CANNIBAL S 20BUC

f1.sg.57614
Livrare imediată!

63,68Lei

Afişare 441 - 460 din 1642 (83 pagini)
Queries: 7, Total time: 42.577 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = '12ef8c7b47927d44282a64a8a3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.132)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (34.775)
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('+set' 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 (7.179)
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 440, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.130)
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
7 (0.136)
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