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 STRIKE PRO CRAZY PLANKTON 2.1CM/1.3G F

VOBLER STRIKE PRO CRAZY PLANKTON 2.1CM/1.3G F

sp.eg182.c352e
Livrare imediată!

29,98Lei

Vobler Strike Pro Supersonic Joint, Culoare A010, 8cm, 27.4g -20%

Vobler Strike Pro Supersonic Joint, Culoare A010, 8cm, 27.4g

sp.eg081c.a010
Livrare imediată!

37,37Lei(-20%) 29,90Lei

Vobler GoldStar Perch 3 Culoare 3 4.5cm
Exclusiv online!

Vobler GoldStar Perch 3 Culoare 3 4.5cm

87205503
Livrare 24-48 ore

8,00Lei

VOBLER JAXON CARPAN F D 9CM-27GR
Exclusiv online!

VOBLER JAXON CARPAN F D 9CM-27GR

vj-ca09fd
Livrare 48-72 ore

39,00Lei

Vobler Salmo Rattlin Hornet F 4.5cm GREEN TIGER

Vobler Salmo Rattlin Hornet F 4.5cm GREEN TIGER

qrh026
Livrare imediată!

58,46Lei

Vobler Owner Tango Dancer 5249 TD-95 95mm 11gr 27 Rainbow Trout
Exclusiv online!

Vobler Owner Tango Dancer 5249 TD-95 95mm 11gr 27 Rainbow Trout

804020104
Livrare 48-72 ore

46,72Lei

Vobler EnergoTeam Kamasaki Minnow, Culoare 5, 9.5cm, 3g

Vobler EnergoTeam Kamasaki Minnow, Culoare 5, 9.5cm, 3g

87230805
Livrare imediată!

8,00Lei

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 18 Red Head
Exclusiv online!

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 18 Red Head

804020041
Livrare 48-72 ore

52,19Lei

VOBLER RAPALA SHADOW RAP SHAD 9CM 12GR CULOARE YP
Exclusiv online!

VOBLER RAPALA SHADOW RAP SHAD 9CM 12GR CULOARE YP

sdrs09 yp
Livrare 48-72ore

58,00Lei

Vobler GoldStar Perch 1 Culoare 16 3cm

Vobler GoldStar Perch 1 Culoare 16 3cm

87225316
Livrare imediată!

8,00Lei

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 06 Shiner
Exclusiv online!

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 06 Shiner

804020040
Livrare 48-72 ore

52,19Lei

VOBLER STRIKE PRO BABY PRO 2,5CM/2G 610T

VOBLER STRIKE PRO BABY PRO 2,5CM/2G 610T

sp.eg036.610t
Livrare imediată!

30,71Lei

VOBLER COLMIC HERAKLES HDD55F 7.0cm 27gr Red Craw
Exclusiv online!

VOBLER COLMIC HERAKLES HDD55F 7.0cm 27gr Red Craw

arhklp04
Livrare 48-72 ore

53,00Lei

Vobler Kenart Shark Floating 4cm 4gr XR Fluo Roach 1 buc/pac
Exclusiv online!

Vobler Kenart Shark Floating 4cm 4gr XR Fluo Roach 1 buc/pac

sh4f-xr
Livrare 48-72ore

21,50Lei

VOBLER COLMIC HERAKLES WT DOG 125HF 12.5cm 28gr Acciuga
Exclusiv online!

VOBLER COLMIC HERAKLES WT DOG 125HF 12.5cm 28gr Acciuga

arhkde06
Livrare 48-72 ore

87,00Lei

VOBLER JAXON JAXON ATRACT MULTI PARTS XMP-F S D 9.5CM 9GR -30%
Exclusiv online!

VOBLER JAXON JAXON ATRACT MULTI PARTS XMP-F S D 9.5CM 9GR

vr-msf095d
Livrare 48-72 ore

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

Vobler Sakura Notobug 22F 22mm 1.4gr 10

Vobler Sakura Notobug 22F 22mm 1.4gr 10

80234saplb50392210
Livrare imediată!

51,22Lei

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 52 Small Mouth
Exclusiv online!

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 52 Small Mouth

804020083
Livrare 48-72 ore

54,63Lei

VOBLER RAPALA X RAP POP 7CM PGS
Exclusiv online!

VOBLER RAPALA X RAP POP 7CM PGS

xrp07 pgs
Livrare 48-72ore

59,00Lei

Vobler Strike Pro Baby Buster, C384F, 25g, 10cm

Vobler Strike Pro Baby Buster, C384F, 25g, 10cm

sp.eg050.c384f
Livrare imediată!

53,50Lei

Afişare 1221 - 1240 din 4080 (204 pagini)
Queries: 7, Total time: 138.979 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = 'cfeb3a001073f18fc89ad80269'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (138.095)
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.271)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.112)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.134)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.180)
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