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

Produse ce potrivesc criteriilor de căutare


VOBLER, SAVAGE, GEAR, 3D, STICKLEBAIT, TWITCH, 6.5CM, 9.4G, GREEN, SILVER, sg.72325, Voblere Sinking, Voblere Sinking Savage Gear, Savage Gear
VOBLER MUSTAD ROUSE VIBE 50S 5CM/7,6G YELLOW T -20%
Exclusiv online!

VOBLER MUSTAD ROUSE VIBE 50S 5CM/7,6G YELLOW T

f3.mlrv50s.ylt
Livrare 24-48 ore

43,73Lei(-20%) 34,97Lei

Vobler Jackall Tricoroll Ryushin 63HW Silver Yamame 6.3cm 7g
Exclusiv online!

Vobler Jackall Tricoroll Ryushin 63HW Silver Yamame 6.3cm 7g

ja.807171266
Livrare 24-48 ore

95,24Lei

, VOBLER, BERKLEY, FLATT, SHAD, NATURAL, SHINER, 5cm, 11g, 1532662, Voblere Sinking, Voblere Sinking Berkley, Berkley
VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 5.5CM 7G BLACK SILVER

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 5.5CM 7G BLACK SILVER

sg.72314
Livrare imediată!

44,03Lei

VOBLER MUSTAD ROUSE VIBE 50S 5CM/7,6G GREEN PE -20%
Exclusiv online!

VOBLER MUSTAD ROUSE VIBE 50S 5CM/7,6G GREEN PE

f3.mlrv50s.gpc
Livrare 24-48 ore

43,73Lei(-20%) 34,97Lei

Vobler, Jackall, Tricoroll, Ryushin, Gold, Ayu, 7cm, 9.2g, ja.418099891, Voblere Sinking, Voblere Sinking Jackall, Jackall
Exclusiv online!

Vobler, Jackall, Tricoroll, Ryushin, Gold, Ayu, 7cm, 9.2g, ja.418099891, Voblere Sinking, Voblere Sinking Jackall, Jackall

ja.418099891
Livrare 24-48 ore

95,24Lei

VOBLER JACKALL NAZZY BUG 6,7CM/16,4G ZARIGAERU
Exclusiv online!

VOBLER JACKALL NAZZY BUG 6,7CM/16,4G ZARIGAERU

ja.807211641
Livrare 24-48 ore

118,79Lei

VOBLER JACKALL TN60 FULL TUNGSTEN 6CM 13G DCGB

VOBLER JACKALL TN60 FULL TUNGSTEN 6CM 13G DCGB

ja.807125993
Livrare imediată!

106,12Lei

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 5.5CM 7G FIRETIGER
Exclusiv online!

VOBLER SAVAGE GEAR 3D STICKLEBAIT TWITCH 5.5CM 7G FIRETIGER

sg.72318
Livrare 24-48 ore

44,03Lei

Vobler, Berkley, Zilla, Swimmer, 120,, Roach,, 12cm,, 15g, 1531754, Voblere Sinking, Voblere Sinking Berkley, Berkley
Vobler, Jackall, Tricoroll, Mai, 45S, Native, Ayu, 4.5cm, 3.7g, ja.807207934, Voblere Sinking, Voblere Sinking Jackall, Jackall
Exclusiv online!

Vobler, Jackall, Tricoroll, Mai, 45S, Native, Ayu, 4.5cm, 3.7g, ja.807207934, Voblere Sinking, Voblere Sinking Jackall, Jackall

ja.807207934
Livrare 24-48 ore

87,74Lei

Vobler, Kenart, Diver, 4cm, /, 5gr, (sinking), div4s-gt, div4s-gt, Voblere Sinking, Voblere Sinking Kenart, Kenart
, VOBLER, BERKLEY, FLATT, SHAD, UVCRAWDAD, 7.7cm, 22g, 1532685, Voblere Sinking, Voblere Sinking Berkley, Berkley
VOBLER MUSTAD ROUSE VIBE 50S 5CM/7,6G ORANGE T -20%
Exclusiv online!

VOBLER MUSTAD ROUSE VIBE 50S 5CM/7,6G ORANGE T

f3.mlrv50s.ot
Livrare 24-48 ore

43,73Lei(-20%) 34,97Lei

, VOBLER, BERKLEY, FLATT, SHAD, FIRETIGER, GOLD, 5cm, 11g, 1532659, Voblere Sinking, Voblere Sinking Berkley, Berkley
Vobler Jackall Tricoroll Ryushin Silver Yamame 7cm 9.2g
Exclusiv online!

Vobler Jackall Tricoroll Ryushin Silver Yamame 7cm 9.2g

ja.418099013
Livrare 24-48 ore

90,12Lei

VOBLER SAVAGE GEAR GRAVITY TWITCH 8,3CM/10G SUSPENDING BTS -20%
Exclusiv online!

VOBLER SAVAGE GEAR GRAVITY TWITCH 8,3CM/10G SUSPENDING BTS

sg.74111
Livrare 24-48 ore

44,98Lei(-20%) 35,99Lei

Vobler, Kenart, Diver, 4cm, /, 5gr, (sinking), div4s-ng, div4s-ng, Voblere Sinking, Voblere Sinking Kenart, Kenart
VOBLER JACKALL TN50 FULL TUNGSTEN 5.2CM 9.5G UHSR -20%

VOBLER JACKALL TN50 FULL TUNGSTEN 5.2CM 9.5G UHSR

ja.807112207
Livrare imediată!

102,90Lei(-20%) 82,32Lei

Afişare 141 - 160 din 3530 (177 pagini)
Queries: 11, Total time: 4,066.325 ms [By time] [By id] [By file]
1 (0.175)
SELECT data
FROM `oc_session`
WHERE session_id = '1497cbba403d22fd48c2cfe348'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.130)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.124)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (1,915.247)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%voblere%' AND pd.tag LIKE '%sinking%')) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
6 (2,132.625)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%voblere%' AND pd.tag LIKE '%sinking%')) AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.267)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
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)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%voblere%' AND pd.tag LIKE '%sinking%')) AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066
8 (0.155)
SELECT COUNT(*) AS val, filter_group, filter_id
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)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%voblere%' AND pd.tag LIKE '%sinking%')) AND p.status_filtru > 0 AND p.price > 0 AND f.language_id = '2' GROUP BY p.product_id, filter_group, filter_id HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911
9 (0.223)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.187)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (17.055)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38