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 DUO Realis Pencil 110, ACC3059 Mat Tiger, 20.5g, 11cm -14%

Vobler DUO Realis Pencil 110, ACC3059 Mat Tiger, 20.5g, 11cm

4525918036348
Livrare imediată!

72,00Lei(-14%) 61,90Lei

Vobler Strike Pro Baby Buster, C29, 25g, 10cm -26%

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

sp.eg050.c29
Livrare imediată!

50,96Lei(-26%) 37,90Lei

VOBLER STRIKE PRO 2,5CM/2G BABY PRO A63

VOBLER STRIKE PRO 2,5CM/2G BABY PRO A63

sp.eg036.a63
Livrare imediată!

30,71Lei

VOBLER STRIKE PRO BABY PRO 2,5CM/2G 626E

VOBLER STRIKE PRO BABY PRO 2,5CM/2G 626E

sp.eg036.626e
Livrare imediată!

30,71Lei

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 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 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

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

VOBLER RAPALA SHADOW RAP SHAD 9CM 12GR CULOARE CLN

sdrs09 cln
Livrare 48-72ore

58,00Lei

VOBLER STRIKE PRO BEETLE BUSTER(F) 4CM/5,7G 130G
Exclusiv online!

VOBLER STRIKE PRO BEETLE BUSTER(F) 4CM/5,7G 130G

sp.eg174.130g
Livrare 24-48 ore

32,06Lei

Afişare 981 - 1000 din 4079 (204 pagini)
Queries: 7, Total time: 141.374 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = 'de8d64df519f663543fad41c3d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (140.704)
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 = '3' 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.127)
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.119)
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
6 (0.099)
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.131)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38