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


VOBLER COLMIC DARKO-S 14.5cm 60gr Bandit -40%

VOBLER COLMIC DARKO-S 14.5cm 60gr Bandit

arhkdv07
Stoc epuizat

48,00Lei(-40%) 28,80Lei

GHOST SHAD COLMIC 8.5cm WATERMELON -40%

GHOST SHAD COLMIC 8.5cm WATERMELON

arhkav08
Stoc epuizat

25,00Lei(-40%) 15,01Lei

CARLIGE COLMIC NUCLEAR DK800 GOLD NR 6

CARLIGE COLMIC NUCLEAR DK800 GOLD NR 6

amq06
Stoc epuizat

25,50Lei

COLANT GUMA ARABICA COLMIC 350gr

COLANT GUMA ARABICA COLMIC 350gr

col6
Stoc epuizat

70,00Lei

WAGLER COLMIC SINFLEX MISTRAL GR 6+2

WAGLER COLMIC SINFLEX MISTRAL GR 6+2

gciv0106
Stoc epuizat

21,00Lei

CARLIGE COLMIC NUCLEAR MR200 NR 14

CARLIGE COLMIC NUCLEAR MR200 NR 14

am0514
Stoc epuizat

16,51Lei

CICADA COLMIC HERAKLES METAL FIRE 5.2CM 12GR Gold Carp

CICADA COLMIC HERAKLES METAL FIRE 5.2CM 12GR Gold Carp

jhkai04
Stoc epuizat

34,00Lei

FIR COLMIC RBS 100M 0.145mm

FIR COLMIC RBS 100M 0.145mm

nyrb14
Stoc epuizat

30,00Lei

Lanseta Colmic Telematch Stor Siluro 4.20m 300g

Lanseta Colmic Telematch Stor Siluro 4.20m 300g

cast70a
Stoc epuizat

879,01Lei

PILKER METAL JIG COLMIC SLIDE 7gr 5.2cm Violet -40%

PILKER METAL JIG COLMIC SLIDE 7gr 5.2cm Violet

jhkaa01
Stoc epuizat

12,00Lei(-40%) 7,20Lei

VARGA COLMIC AIRFORM 5.00M

VARGA COLMIC AIRFORM 5.00M

caai02b
Stoc epuizat

419,00Lei

FIR COLMIC RBS 100M 0.125mm

FIR COLMIC RBS 100M 0.125mm

nyrb12
Stoc epuizat

26,00Lei

PILKER METAL JIG COLMIC SLIDE 7gr 5.2cm Orange -40%

PILKER METAL JIG COLMIC SLIDE 7gr 5.2cm Orange

jhkaa04
Stoc epuizat

12,00Lei(-40%) 7,20Lei

PLUMBI COLMIC OLIVETA SUPREME 4.00gr

PLUMBI COLMIC OLIVETA SUPREME 4.00gr

tos0400
Stoc epuizat

21,00Lei

SPINNERBAIT COLMIC JUMP 10.5GR CHARTREUSE/WHITE -30%

SPINNERBAIT COLMIC JUMP 10.5GR CHARTREUSE/WHITE

arhkcm03
Stoc epuizat

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

CARLIGE COLMIC NUCLEAR DK800 GOLD NR 12

CARLIGE COLMIC NUCLEAR DK800 GOLD NR 12

amq12
Stoc epuizat

21,00Lei

LANSETA COLMIC GHEMON YOUNG 2.70M 300GR

LANSETA COLMIC GHEMON YOUNG 2.70M 300GR

cagh60b
Stoc epuizat

646,00Lei

CARLIGE COLMIC NUCLEAR WN501 F/BARB NR 16

CARLIGE COLMIC NUCLEAR WN501 F/BARB NR 16

amhw26
Stoc epuizat

13,99Lei

UMBRELA COLMIC FIBERGLASS HIGH TECH 240T UV 3.10M

UMBRELA COLMIC FIBERGLASS HIGH TECH 240T UV 3.10M

omh10g
Stoc epuizat

930,00Lei

FIR COLMIC RBS 100M 0.090mm

FIR COLMIC RBS 100M 0.090mm

nyrb09
Stoc epuizat

26,00Lei

Afişare 1061 - 1080 din 2949 (148 pagini)
Queries: 4, Total time: 66.971 ms [By time] [By id] [By file]
1 (0.089)
SELECT data
FROM `oc_session`
WHERE session_id = '1adc811a3a9af6d584a3976b2e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (66.659)
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 (0.135)
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