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

Produse ce potrivesc criteriilor de căutare


METHOD FEEDER EXTRA CARP 60 G CU CONECTORI 2 BUC SET

METHOD FEEDER EXTRA CARP 60 G CU CONECTORI 2 BUC SET

ec6954
Livrare imediată!

20,90Lei

CONECTORI MAVER ELASTIC MINI ALBASTRU
Exclusiv online!

CONECTORI MAVER ELASTIC MINI ALBASTRU

j070
Livrare 48-72 ore

6,50Lei

Adaptor FOX BLACK LABEL QR ADAPTORS 2buc/set -18%

Adaptor FOX BLACK LABEL QR ADAPTORS 2buc/set

cbs061
Livrare imediată!

85,47Lei(-18%) 70,00Lei

METHOD FEEDER EXTRA CARP 20 G CU CONECTORI 2 BUC SET

METHOD FEEDER EXTRA CARP 20 G CU CONECTORI 2 BUC SET

ec6275
Livrare imediată!

15,51Lei

SUPORT AVERTIZOR CATGEAR MAGNETIC ROD CLAMP

SUPORT AVERTIZOR CATGEAR MAGNETIC ROD CLAMP

302-00-500
Livrare imediată!

85,00Lei

CONECTORI MAVER ELASTIC MICRO ALBASTRU
Exclusiv online!

CONECTORI MAVER ELASTIC MICRO ALBASTRU

j080
Livrare 48-72 ore

6,50Lei

ADAPTOR BARACUDA pentru avertizor

ADAPTOR BARACUDA pentru avertizor

hk - adaptor pentru montare rapida a avertizorului
Livrare imediată!

16,90Lei

Conector Rapid din Inox NGT Quick Release Black 1buc/blister

Conector Rapid din Inox NGT Quick Release Black 1buc/blister

ngt-fo-quick-rel-3-blk
Livrare imediată!

54,00Lei

Conectori Select Baits Anti-tangle Sleeves 40MM

Conectori Select Baits Anti-tangle Sleeves 40MM

sel-218001
Livrare imediată!

10,00Lei

SET METHOD JAXON FEEDER ER2 CU MATRITA SI 5 CONECTORI 40GR
Exclusiv online!

SET METHOD JAXON FEEDER ER2 CU MATRITA SI 5 CONECTORI 40GR

af-er240x
Livrare 48-72 ore

57,00Lei

Conector Baracuda Set 4 Adaptoare Montare Rapida 4buc/set

Conector Baracuda Set 4 Adaptoare Montare Rapida 4buc/set

set 4 adaptoare montare rapida av
Livrare imediată!

82,90Lei

Conector Prologic Negru Cu Eliberare Rapida 3buc/plic S

Conector Prologic Negru Cu Eliberare Rapida 3buc/plic S

a.pro.43884
Livrare imediată!

60,90Lei

SET METHOD JAXON FEEDER ER2 CU MATRITA SI 5 CONECTORI 30GR

SET METHOD JAXON FEEDER ER2 CU MATRITA SI 5 CONECTORI 30GR

af-er230x
Livrare imediată!

55,00Lei

SET METHOD JAXON FEEDER ER2 CU MATRITA SI 5 CONECTORI 20GR
Exclusiv online!

SET METHOD JAXON FEEDER ER2 CU MATRITA SI 5 CONECTORI 20GR

af-er220x
Livrare 48-72 ore

52,00Lei

Conversion FOX Black Label QR Kit CBB030
Exclusiv online!

Conversion FOX Black Label QR Kit CBB030

cbb030
Livrare 7-14 zile

40,13Lei

Conversion FOX Black Label Kit Standard CBB029
Exclusiv online!

Conversion FOX Black Label Kit Standard CBB029

cbb029
Livrare 7-14 zile

44,96Lei

ADAPTOR FOX BLACK LABEL QR ANGLE

ADAPTOR FOX BLACK LABEL QR ANGLE

cbb031
Livrare imediată!

107,30Lei

Conector Rapid din Inox NGT Quick Release 1buc/blister

Conector Rapid din Inox NGT Quick Release 1buc/blister

ngt-fo-quick-rel-3ss
Livrare imediată!

22,00Lei

CONECTOR RAPID FL MAGNETIC BLACK LABEL

CONECTOR RAPID FL MAGNETIC BLACK LABEL

64-2126
Livrare imediată!

35,90Lei

Set 4 Conectori Rapizi Coonor Inox Cu Balama 4buc/plic

Set 4 Conectori Rapizi Coonor Inox Cu Balama 4buc/plic

6832219326695
Livrare imediată!

69,02Lei

Afişare 21 - 40 din 58 (3 pagini)
Queries: 5, Total time: 2.723 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = 'f59d8ba1d4f2409fac56d375d6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1.925)
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('+conectori' 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
4 (0.474)
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:184
5 (0.100)
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