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

Produse ce potrivesc criteriilor de căutare


Vobler Rapala X-Rap Countdown Culoare ROL 7cm 10g
Exclusiv online!

Vobler Rapala X-Rap Countdown Culoare ROL 7cm 10g

xrcd07 rol
Livrare 48-72ore

55,00Lei

VOBLER SALMO HORNET 4CM 4G H4S RDE -20%

VOBLER SALMO HORNET 4CM 4G H4S RDE

qht040
Livrare imediată!

42,45Lei(-20%) 33,96Lei

Vobler GoldStar Shad Culoare:9

Vobler GoldStar Shad Culoare:9

87245909
Livrare imediată!

8,00Lei

VOBLER NOMURA TROUT RACE 3.5CM/3.10G GREY
Exclusiv online!

VOBLER NOMURA TROUT RACE 3.5CM/3.10G GREY

nm.60980103
Livrare 24-48 ore

40,42Lei

VOBLER RAPALA S SKITTER POP
Exclusiv online!

VOBLER RAPALA S SKITTER POP

sp05 s
Livrare 48-72ore

51,00Lei

VOBLER RAPALA ULTRA LIGHT RIPPIN' RAP 4CM / 5GR FT
Exclusiv online!

VOBLER RAPALA ULTRA LIGHT RIPPIN' RAP 4CM / 5GR FT

ulrpr04 ft
Livrare 48-72ore

42,00Lei

VOBLER STRIKE PRO BABY PRO 2.5CM/1.9G

VOBLER STRIKE PRO BABY PRO 2.5CM/1.9G

sp.sp100.a09
Livrare imediată!

29,68Lei

VOBLER JAXON KARAS F KZ 6CM-6GR

VOBLER JAXON KARAS F KZ 6CM-6GR

vj-ka6fkz
Livrare imediată!

35,00Lei

VOBLER SALMO HORNET 3.5CM 2.2G FLOATING TRO -32%

VOBLER SALMO HORNET 3.5CM 2.2G FLOATING TRO

qht010
Livrare imediată!

42,71Lei(-32%) 28,91Lei

VOBLER STRIKE PRO SILVER SPRAT 4CM/2,5G 71
Exclusiv online!

VOBLER STRIKE PRO SILVER SPRAT 4CM/2,5G 71

sp.eg093ja.71
Livrare 24-48 ore

30,27Lei

Vobler DUO Ryuki 50S Takumi 5cm 4g ANI4004 Natural Yamame S
Exclusiv online!

Vobler DUO Ryuki 50S Takumi 5cm 4g ANI4004 Natural Yamame S

duo33337
Livrare 48-72 ore

66,00Lei

VOBLER STORM SO-RUN MINNOW 9.5CM / 11GR SFCO

VOBLER STORM SO-RUN MINNOW 9.5CM / 11GR SFCO

srm95f sfco
Livrare imediată!

26,00Lei

Vobler Kenart Shark Floating 4cm 4gr T Trout 1 buc/pac

Vobler Kenart Shark Floating 4cm 4gr T Trout 1 buc/pac

sh4f-t
Livrare imediată!

21,50Lei

VOBLER RAPTURE PRO HELLION S CHY 50MM 3G -22%

VOBLER RAPTURE PRO HELLION S CHY 50MM 3G

180-11-783
Livrare imediată!

23,00Lei(-22%) 17,85Lei

VOBLER SALMO TINY IT3F GRH, 3CM, 2G

VOBLER SALMO TINY IT3F GRH, 3CM, 2G

84503198
Livrare imediată!

38,00Lei

Vobler Swimbait Biwaa Seven Section Sexy Shad 15cm 60g
Exclusiv online!

Vobler Swimbait Biwaa Seven Section Sexy Shad 15cm 60g

b000784
Livrare 48-72 ore

126,00Lei

VOBLER SALMO THRILL TH5 SGH 5CM/6.5G

VOBLER SALMO THRILL TH5 SGH 5CM/6.5G

84535523
Livrare imediată!

43,99Lei

Vobler Savage Gear 3D Smash Tail, Firetiger, 10cm, 17g

Vobler Savage Gear 3D Smash Tail, Firetiger, 10cm, 17g

sg.61996
Livrare imediată!

52,88Lei

Vobler Storm Gomoku Dense Culoare FT 4.8cm 6g -28%

Vobler Storm Gomoku Dense Culoare FT 4.8cm 6g

gd48 ft
Livrare imediată!

42,99Lei(-28%) 30,99Lei

Vobler Rapala X-Rap Countdown Culoare PEL 7cm 10g
Exclusiv online!

Vobler Rapala X-Rap Countdown Culoare PEL 7cm 10g

xrcd07 pel
Livrare 48-72ore

55,00Lei

Afişare 2881 - 2900 din 8744 (438 pagini)
Queries: 9, Total time: 254.548 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = '0a5223b1ade95249787ae879ae'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.068)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (217.817)
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('+vobler' 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:725
4 (36.053)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 2880, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.107)
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.073)
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.115)
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
8 (0.118)
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
9 (0.094)
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