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 Strike Pro Cranky SE01F, 4cm, 4.2g -26%

Vobler Strike Pro Cranky SE01F, 4cm, 4.2g

sp.eg164.se01f
Livrare imediată!

31,02Lei(-26%) 22,90Lei

Vobler Rapala RPR 6cm/14gr. YP
Exclusiv online!

Vobler Rapala RPR 6cm/14gr. YP

rpr06 yp
Livrare 48-72ore

46,01Lei

Vobler Spro Trout Master Flat Mini Crank 3 Cm Black Red 2Gr
Exclusiv online!

Vobler Spro Trout Master Flat Mini Crank 3 Cm Black Red 2Gr

004916-00403-00000
Livrare 48-72 ore

32,00Lei

Vobler Rapala X-Rap 6cm/4gr. S

Vobler Rapala X-Rap 6cm/4gr. S

xr06 s
Livrare imediată!

51,00Lei

Vobler Biwaa Strout 9cm/8g culoare Vairon -23%

Vobler Biwaa Strout 9cm/8g culoare Vairon

b000804
Livrare imediată!

65,00Lei(-23%) 49,90Lei

Vobler Sakura Notobug 30F 30mm 3.5gr 07

Vobler Sakura Notobug 30F 30mm 3.5gr 07

80434saplb50393007
Livrare imediată!

52,29Lei

VOBLER SALMO THRILL TH7 SFF

VOBLER SALMO THRILL TH7 SFF

84537501
Livrare imediată!

46,01Lei

Vobler Biwaa Strout 14cm/29g culoare Fire Tiger -22%

Vobler Biwaa Strout 14cm/29g culoare Fire Tiger

b000283
Livrare imediată!

103,99Lei(-22%) 80,90Lei

VOBLER CARP ZOOM PREDATOR -Z SIDER 6.5cm 6gr FLOATING 1129 -23%

VOBLER CARP ZOOM PREDATOR -Z SIDER 6.5cm 6gr FLOATING 1129

cz1129
Livrare imediată!

12,00Lei(-23%) 9,28Lei

Vobler GoldStar Fat culoare 1 6cm

Vobler GoldStar Fat culoare 1 6cm

87240601
Livrare imediată!

8,00Lei

Vobler Savage Soft Vibes S03, 6.6cm, 22g -26%

Vobler Savage Soft Vibes S03, 6.6cm, 22g

sg.50684
Livrare imediată!

32,09Lei(-26%) 23,90Lei

VOBLER COLMIC DEVIL S 4cm 3.8gr GHOST AYU -30%

VOBLER COLMIC DEVIL S 4cm 3.8gr GHOST AYU

arhkbf01
Livrare imediată!

30,00Lei(-30%) 21,00Lei

VOBLER LINEAEFFE NOMURA RANGER MINNOW 7CM/13G REAL
Exclusiv online!

VOBLER LINEAEFFE NOMURA RANGER MINNOW 7CM/13G REAL

nm.52210807
Livrare 24-48 ore

42,27Lei

Vobler Rapala X-Rap 6cm/4gr. GGH

Vobler Rapala X-Rap 6cm/4gr. GGH

xr06 ggh
Livrare imediată!

51,00Lei

VOBLER STRIKE PRO FLAP JACK 6,5CM/13,6G 962T

VOBLER STRIKE PRO FLAP JACK 6,5CM/13,6G 962T

sp.eg128b.962t
Livrare imediată!

31,61Lei

Vobler Rapture Pro Under Silent Sinking, Glow Red Head, 6.5cm, 11g

Vobler Rapture Pro Under Silent Sinking, Glow Red Head, 6.5cm, 11g

180-02-947
Livrare imediată!

26,00Lei

COADA DE REZERVA VOBLER RAPALA X-RAP PETO SPARE TAIL CULOARE PEL 3BUC/BLISTER
Exclusiv online!

COADA DE REZERVA VOBLER RAPALA X-RAP PETO SPARE TAIL CULOARE PEL 3BUC/BLISTER

pptp20 pel
Livrare 48-72ore

99,00Lei

VOBLER STRIKE PRO SHIFTY SHAD 8CM/15,3G

VOBLER STRIKE PRO SHIFTY SHAD 8CM/15,3G

sp.eg162sp.c202f
Livrare imediată!

33,38Lei

VOBLER STRIKE PRO FLAP JACK 6,5CM/13,6G A09
Exclusiv online!

VOBLER STRIKE PRO FLAP JACK 6,5CM/13,6G A09

sp.eg128b.a09
Livrare 24-48 ore

31,61Lei

Vobler Strike Pro Rattle-N-Shad 7.5cm, culoare A70-713

Vobler Strike Pro Rattle-N-Shad 7.5cm, culoare A70-713

sp.jl027.a70.713
Livrare imediată!

42,08Lei

Afişare 1981 - 2000 din 8744 (438 pagini)
Queries: 13, Total time: 370.534 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = 'e162ae05e2d31fd9f74819ab7d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.124)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (224.080)
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:737
5 (0.862)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
6 (37.448)
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 1980, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.125)
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.110)
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 (4.416)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
10 (0.121)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
11 (1.379)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
12 (101.495)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
13 (0.148)
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