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 GoldStar Perch 3 Culoare 10 4.5cm

Vobler GoldStar Perch 3 Culoare 10 4.5cm

87205510
Livrare imediată!

8,00Lei

NALUCA SAVAGE 3D HOLLOW DUCKLING 7.5CM/15G 03 -23%

NALUCA SAVAGE 3D HOLLOW DUCKLING 7.5CM/15G 03

f1.sg.57651
Livrare imediată!

44,03Lei(-23%) 33,90Lei

VOBLER JAXON FEROX F TR 6CM-5GR

VOBLER JAXON FEROX F TR 6CM-5GR

vj-f06ftr
Stoc epuizat

34,00Lei

VOBLER JAXON KARAS F TR 11CM-39GR

VOBLER JAXON KARAS F TR 11CM-39GR

vj-ka11ftr
Stoc epuizat

46,01Lei

Vobler GoldStar Popp culoare 3 5cm

Vobler GoldStar Popp culoare 3 5cm

87210503
Livrare imediată!

8,00Lei

Vobler Strike Pro Baby Pro 2.5cm, culoare 999

Vobler Strike Pro Baby Pro 2.5cm, culoare 999

sp.eg036.999
Livrare imediată!

30,71Lei

VOBLER SALMO PIKE FLOATING HOT PIKE 11CM 15G

VOBLER SALMO PIKE FLOATING HOT PIKE 11CM 15G

qpe009
Livrare imediată!

53,95Lei

VOBLER JAXON TINGO F OB 7CM-12GR

VOBLER JAXON TINGO F OB 7CM-12GR

vj-ti07fob
Stoc epuizat

25,00Lei

VOBLER SALMO SLIDER SD7F GFP 7CM/17G

VOBLER SALMO SLIDER SD7F GFP 7CM/17G

84577141
Livrare imediată!

58,00Lei

VOBLER JAXON KARAS F GFT 11CM-39GR

VOBLER JAXON KARAS F GFT 11CM-39GR

vj-ka11fgft
Stoc epuizat

46,01Lei

VOBLER JAXON PIKE 2-SEC F PL 16CM-30GR

VOBLER JAXON PIKE 2-SEC F PL 16CM-30GR

vj-pj16fpl
Stoc epuizat

51,00Lei

VOBLER STRIKE PRO JOINT 9CM/12G 626E
Exclusiv online!

VOBLER STRIKE PRO JOINT 9CM/12G 626E

sp.eg079ja.626e
Livrare 24-48 ore

43,57Lei

VOBLER COLMIC HERAKLES ASTRO F 9.5cm 16gr Ayu -30%

VOBLER COLMIC HERAKLES ASTRO F 9.5cm 16gr Ayu

arhkaa05
Stoc epuizat

29,00Lei(-30%) 20,30Lei

Vobler Strike Pro Baby Pro 2.5cm Culoare 291

Vobler Strike Pro Baby Pro 2.5cm Culoare 291

sp.eg036.291
Livrare imediată!

30,71Lei

VOBLER JAXON CARPAN F W 9CM-27GR

VOBLER JAXON CARPAN F W 9CM-27GR

vj-ca09fw
Stoc epuizat

39,00Lei

VOBLER JAXON HS CARABUS F KT 3CM 1.5GR

VOBLER JAXON HS CARABUS F KT 3CM 1.5GR

vj-sh03fkt
Stoc epuizat

35,00Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 06 Auriu spate negru

Vobler Owner Bug Eye Bait 50mm 6.5gr 06 Auriu spate negru

804020202
Livrare imediată!

37,69Lei

VOBLER SALMO HORNET H3S D 3.5CM/2.6G
Exclusiv online!

VOBLER SALMO HORNET H3S D 3.5CM/2.6G

84413506
Livrare 24-48 ore

40,00Lei

VOBLER BIWAA GLIDER RAFFAL YELLOW PEARCH 10CM 43G

VOBLER BIWAA GLIDER RAFFAL YELLOW PEARCH 10CM 43G

b001601
Stoc epuizat

62,00Lei

VOBLER BIWAA GLIDER RAFFAL SUNFISH 10CM 43G -21%

VOBLER BIWAA GLIDER RAFFAL SUNFISH 10CM 43G

b001724
Livrare imediată!

62,00Lei(-21%) 48,90Lei

Afişare 1301 - 1320 din 4104 (206 pagini)
Queries: 4, Total time: 118.219 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = '9fe0b731b23e62df0f58e77dba'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.119)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (117.800)
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('+voblere +floating' 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.181)
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