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


MOMITOR COLMIC ROUND CAGE FEEDER O-RING 25x32mm 15gr -30%
Exclusiv online!

MOMITOR COLMIC ROUND CAGE FEEDER O-RING 25x32mm 15gr

fedko36
Livrare 48-72 ore

7,00Lei(-30%) 4,90Lei

MOMITOR COLMIC STICKY MAGGOTS FEEDER LARGE 25gr

MOMITOR COLMIC STICKY MAGGOTS FEEDER LARGE 25gr

fed51a
Livrare imediată!

19,00Lei

ARGILA COLMIC DRY 1kg
Exclusiv online!

ARGILA COLMIC DRY 1kg

pcbel50d
Livrare 48-72 ore

26,00Lei

GRUB COLMIC HERAKLES MATO WORM 16.5cm Pumpkin Purple Flakes -30%
Exclusiv online!

GRUB COLMIC HERAKLES MATO WORM 16.5cm Pumpkin Purple Flakes

arhkmat26
Livrare 48-72 ore

22,00Lei(-30%) 15,40Lei

LINGURITA OSCILANTA COLMIC DRIBBLE SPOON 2.5gr Gold -35%
Exclusiv online!

LINGURITA OSCILANTA COLMIC DRIBBLE SPOON 2.5gr Gold

arhkiq05
Livrare 48-72 ore

17,01Lei(-35%) 11,10Lei

POPPER COLMIC HERAKLES SKYWALK 13cm 27.5gr Herakles Shiner
Exclusiv online!

POPPER COLMIC HERAKLES SKYWALK 13cm 27.5gr Herakles Shiner

arhklv06
Livrare 48-72 ore

58,00Lei

FIR COLMIC SHADE COLMICE FLUOROCARBON 50M 0.20mm
Exclusiv online!

FIR COLMIC SHADE COLMICE FLUOROCARBON 50M 0.20mm

nysh20
Livrare 48-72 ore

63,00Lei

JIG COLMIC IMPACT ANTIBRADIS 1/4oz 7gr Brown/Pumpkin
Exclusiv online!

JIG COLMIC IMPACT ANTIBRADIS 1/4oz 7gr Brown/Pumpkin

arhkfi03
Livrare 48-72 ore

28,00Lei

VIBER CRAW COLMIC 3.5" 8.9cm BLACK RED FLK -40%
Exclusiv online!

VIBER CRAW COLMIC 3.5" 8.9cm BLACK RED FLK

arhkcg08
Livrare 48-72 ore

37,00Lei(-40%) 22,21Lei

GEANTA COLMIC ROLLER SERIA RED 21x29x73
Exclusiv online!

GEANTA COLMIC ROLLER SERIA RED 21x29x73

bo211
Livrare 48-72 ore

225,01Lei

Lanseta Telescopica Colmic Arkas XT Boat 2.70m 250g
Exclusiv online!

Lanseta Telescopica Colmic Arkas XT Boat 2.70m 250g

caark01c
Livrare 48-72 ore

308,00Lei

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr Matt Sunny -30%
Exclusiv online!

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr Matt Sunny

arhkdd04
Livrare 48-72 ore

38,00Lei(-30%) 26,60Lei

GHOST SHAD COLMIC 13cm BLACK IMPACT -40%
Exclusiv online!

GHOST SHAD COLMIC 13cm BLACK IMPACT

arhkct06
Livrare 48-72 ore

41,00Lei(-40%) 24,60Lei

FIR COLMIC STEEL RESISTANCE NX80 150M 0.35mm
Exclusiv online!

FIR COLMIC STEEL RESISTANCE NX80 150M 0.35mm

nyst15035
Livrare 48-72 ore

62,00Lei

FIR COLMIC OKY 150M 0.25mm
Exclusiv online!

FIR COLMIC OKY 150M 0.25mm

nyok025
Livrare 48-72 ore

13,49Lei

FIR COLMIC HOLO SURF FLUO 300M 0.14mm -30%
Exclusiv online!

FIR COLMIC HOLO SURF FLUO 300M 0.14mm

nyho14
Livrare 48-72 ore

33,00Lei(-30%) 23,10Lei

FIR COLMIC HOLO SURF FLUO 0.18MM 300M -30%

FIR COLMIC HOLO SURF FLUO 0.18MM 300M

nyho18
Livrare imediată!

33,00Lei(-30%) 23,10Lei

CARLIGE COLMIC NUCLEAR MR66 NR 8
Exclusiv online!

CARLIGE COLMIC NUCLEAR MR66 NR 8

am0380
Livrare 48-72 ore

27,00Lei

VIBER CRAW COLMIC 3.5" 8.9cm WATERMELON RED -40%
Exclusiv online!

VIBER CRAW COLMIC 3.5" 8.9cm WATERMELON RED

arhkcg01
Livrare 48-72 ore

37,00Lei(-40%) 22,21Lei

ARGILA COLMIC TERRA DI FIUME 2kg
Exclusiv online!

ARGILA COLMIC TERRA DI FIUME 2kg

pci260c
Livrare 48-72 ore

25,50Lei

Afişare 921 - 940 din 2950 (148 pagini)
Queries: 5, Total time: 111.149 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = 'cb271c7e7fede34e5afbf0ab1d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (91.474)
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('+colmic' 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 (19.301)
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 920, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.124)
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