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 RAID JAPAN Level VIB, 042 Onion Gill, 5.4cm, 10.6g

Vobler RAID JAPAN Level VIB, 042 Onion Gill, 5.4cm, 10.6g

raid15707
Livrare imediată!

95,00Lei

Vobler RAID JAPAN Level VIB, 046 Ikeno Mabuna, 5.4cm, 10.6g

Vobler RAID JAPAN Level VIB, 046 Ikeno Mabuna, 5.4cm, 10.6g

raid15745
Livrare imediată!

95,00Lei

Voblerul Mikado Fishunter Twilight Yugol Sinking, 64, 3.4g, 4cm, 1buc/pac
Exclusiv online!

Voblerul Mikado Fishunter Twilight Yugol Sinking, 64, 3.4g, 4cm, 1buc/pac

PWF-TW-4S-64
Livrare 48-72 ore

25,00Lei

Voblerul Mikado Fishunter Twilight Yugol Sinking, 67, 3.4g, 4cm, 1buc/pac
Exclusiv online!

Voblerul Mikado Fishunter Twilight Yugol Sinking, 67, 3.4g, 4cm, 1buc/pac

PWF-TW-4S-67
Livrare 48-72 ore

25,00Lei

Voblerul Mikado Fishunter Twilight Yugol Sinking, PH, 3.4g, 4cm, 1buc/pac
Exclusiv online!

Voblerul Mikado Fishunter Twilight Yugol Sinking, PH, 3.4g, 4cm, 1buc/pac

PWF-TW-4S-PH
Livrare 48-72 ore

25,00Lei

CUTIE ACCESORII CARP ZOOM 12.2x10.5x3.4cm

CUTIE ACCESORII CARP ZOOM 12.2x10.5x3.4cm

cz4269
Livrare imediată!

19,00Lei

ANTIRASUCITOR SPRO METALIC 4CM 2BUC

ANTIRASUCITOR SPRO METALIC 4CM 2BUC

004607-00010-00000
Livrare imediată!

8,20Lei

MAGIC FISH JAXON FROG 1A 4CM

MAGIC FISH JAXON FROG 1A 4CM

bt-fr01a
Livrare imediată!

32,00Lei

GRUB COLMIC RUGBY CRAW 4.5" 11.4cm BLACK RED FLK -40%
Exclusiv online!

GRUB COLMIC RUGBY CRAW 4.5" 11.4cm BLACK RED FLK

arhkch04
Livrare 48-72 ore

36,00Lei(-40%) 21,60Lei

Lingurita Rotativa Energo Team Wizard Chub Spinner, Alb - Rosu, 4cm, 8g

Lingurita Rotativa Energo Team Wizard Chub Spinner, Alb - Rosu, 4cm, 8g

87301081
Livrare imediată!

6,50Lei

Vobler Strike Pro Cranky SS DU01G 4cm 3.7g -26%

Vobler Strike Pro Cranky SS DU01G 4cm 3.7g

sp.eg164sl.du01g
Livrare imediată!

31,02Lei(-26%) 22,99Lei

MAGIC FISH JAXON FROG 1D 4CM
Exclusiv online!

MAGIC FISH JAXON FROG 1D 4CM

bt-fr01d
Livrare 48-72 ore

32,00Lei

GRUB COLMIC RUGBY CRAW 4.5" 11.4cm WATERMELON RED FLK -40%
Exclusiv online!

GRUB COLMIC RUGBY CRAW 4.5" 11.4cm WATERMELON RED FLK

arhkch01
Livrare 48-72 ore

36,00Lei(-40%) 21,60Lei

Forceps NGT Large, 24.4cm
Exclusiv online!

Forceps NGT Large, 24.4cm

ngt-fu-fc-10-c
Livrare 48-72 ore

28,00Lei

MAGIC FISH JAXON FROG 1E 4CM
Exclusiv online!

MAGIC FISH JAXON FROG 1E 4CM

bt-fr01e
Livrare 48-72 ore

32,00Lei

CICADA STRIKE PRO 4CM/6,6G CYBER VIBE JU008

CICADA STRIKE PRO 4CM/6,6G CYBER VIBE JU008

sp.jg005b.ju008
Livrare imediată!

30,27Lei

VOBLER STRIKE PRO STUMPY 4CM 4.5G

VOBLER STRIKE PRO STUMPY 4CM 4.5G

sp.eg127.a09
Livrare imediată!

31,89Lei

VIBER GRUB COLMIC 4.5" 11.4cm CHAMPAGNE BLACK FLK -40%
Exclusiv online!

VIBER GRUB COLMIC 4.5" 11.4cm CHAMPAGNE BLACK FLK

arhkcz05
Livrare 48-72 ore

31,00Lei(-40%) 18,60Lei

GRUB COLMIC RUGBY CRAW 4.5" 11.4cm PLUM -40%
Exclusiv online!

GRUB COLMIC RUGBY CRAW 4.5" 11.4cm PLUM

arhkch02
Livrare 48-72 ore

36,00Lei(-40%) 21,60Lei

GRUB COLMIC SCRATCH 4.5" 11.4cm WATERMELON PUMPKIN -40%
Exclusiv online!

GRUB COLMIC SCRATCH 4.5" 11.4cm WATERMELON PUMPKIN

arhkal01
Livrare 48-72 ore

34,00Lei(-40%) 20,40Lei

Afişare 241 - 260 din 1117 (56 pagini)
Queries: 4, Total time: 28.871 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = 'f7a919a770e2e35e677faa7824'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (28.532)
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('+4cm' 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.152)
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