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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


VOBLER SALMO TINY IT3F OYT, 3CM, 2G

VOBLER SALMO TINY IT3F OYT, 3CM, 2G

84503179
Livrare imediată!

38,00Lei

Vobler Colmic Herakles Moth Sinking 3.7cm Pink Glow
Exclusiv online!

Vobler Colmic Herakles Moth Sinking 3.7cm Pink Glow

arhkmos03
Livrare 48-72 ore

53,00Lei

VOBLER JAXON ATRACT XXT-C F G 7CM 7GR
Exclusiv online!

VOBLER JAXON ATRACT XXT-C F G 7CM 7GR

vr-tc070g
Livrare 48-72 ore

22,00Lei

VOBLER JAXON POPPER ATRACT EDAR F D 7.5CM 9GR
Exclusiv online!

VOBLER JAXON POPPER ATRACT EDAR F D 7.5CM 9GR

vr-xhe075d
Livrare 48-72 ore

15,01Lei

Vobler Rapala Original Floater, Culoare TR, 5cm, 3g
Exclusiv online!

Vobler Rapala Original Floater, Culoare TR, 5cm, 3g

f05 tr
Livrare 48-72ore

46,01Lei

Vobler Savage Gear 3D Minnow Diver F03 9.5cm 19g

Vobler Savage Gear 3D Minnow Diver F03 9.5cm 19g

sg.57370
Livrare imediată!

28,52Lei

VOBLER RAPALA ORIGINAL FLOATER 11CM / 6GR ALB

VOBLER RAPALA ORIGINAL FLOATER 11CM / 6GR ALB

f11 alb
Livrare imediată!

50,00Lei

VOBLER RAPTURE HOT BUZZ AREA S 25MM 3G CHY
Exclusiv online!

VOBLER RAPTURE HOT BUZZ AREA S 25MM 3G CHY

180-06-983
Livrare 48-72 ore

25,00Lei

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr RL04 Real Life Fario Trout
Exclusiv online!

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr RL04 Real Life Fario Trout

130234saplh500950-rl04
Livrare 48-72 ore

52,00Lei

Vobler Salmo Slider Floating Real Hot Perch 7cm 17g

Vobler Salmo Slider Floating Real Hot Perch 7cm 17g

qsd267
Livrare imediată!

60,30Lei

Vobler Strike Pro Mustang Minnow 6cm/6g
Exclusiv online!

Vobler Strike Pro Mustang Minnow 6cm/6g

sp.mg002a.022pt
Livrare 24-48 ore

35,74Lei

Vobler GoldStar Vertic culoare 2 6cm

Vobler GoldStar Vertic culoare 2 6cm

87215602
Livrare imediată!

8,00Lei

Vobler Salmo Slider Floating 10cm/36g culoare Golden Crucian

Vobler Salmo Slider Floating 10cm/36g culoare Golden Crucian

qsd364
Livrare imediată!

67,10Lei

VOBLER SALMO HORNET H3F DB 3.5CM/2.2G
Exclusiv online!

VOBLER SALMO HORNET H3F DB 3.5CM/2.2G

84413108
Livrare 24-48 ore

40,00Lei

VOBLER JAXON PIKE 2-SEC F PF 14CM 21GR
Exclusiv online!

VOBLER JAXON PIKE 2-SEC F PF 14CM 21GR

vj-pj14fpf
Livrare 48-72 ore

50,00Lei

VOBLER JAXON POPPER ATRACT EDAR F H 7.5CM 9GR
Exclusiv online!

VOBLER JAXON POPPER ATRACT EDAR F H 7.5CM 9GR

vr-xhe075h
Livrare 48-72 ore

15,01Lei

VOBLER RAPALA X-RAP PETO CULOARE ARB 14CM 39G
Exclusiv online!

VOBLER RAPALA X-RAP PETO CULOARE ARB 14CM 39G

xrpt14 arb
Livrare 48-72ore

84,00Lei

Vobler Rapala X-Rap Twitchin Minnow Culoare S 10cm 14g
Exclusiv online!

Vobler Rapala X-Rap Twitchin Minnow Culoare S 10cm 14g

sxrt10 s
Livrare 48-72ore

61,00Lei

VOBLER SALMO HORNET H3F UVGS, 3.5CM, 2.2G
Exclusiv online!

VOBLER SALMO HORNET H3F UVGS, 3.5CM, 2.2G

84413177
Livrare 24-48 ore

40,00Lei

VOBLER RAPALA SHALLOW SHAD RAP S

VOBLER RAPALA SHALLOW SHAD RAP S

ssr05 s
Livrare imediată!

45,01Lei

Afişare 3981 - 4000 din 8773 (439 pagini)
Queries: 9, Total time: 251.795 ms [By time] [By id] [By file]
1 (0.145)
SELECT data
FROM `oc_session`
WHERE session_id = '9eecba7ac0010075f6e001049d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (219.288)
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('+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:737
5 (31.683)
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 3980, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.128)
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.085)
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.089)
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.130)
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