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

Produse ce potrivesc criteriilor de căutare


Kit Pva Sistem Claumar Slow Melt 25mm/7m + 35mm/7m cu Tub + Plunger

Kit Pva Sistem Claumar Slow Melt 25mm/7m + 35mm/7m cu Tub + Plunger

clm243331
Livrare imediată!

56,50Lei

Rezerva Plasa Pva Claumar Slow Melt 25mm, 7m

Rezerva Plasa Pva Claumar Slow Melt 25mm, 7m

clm243348
Livrare imediată!

27,91Lei

Rezerva Plasa Pva Claumar Slow Melt 35mm, 7m

Rezerva Plasa Pva Claumar Slow Melt 35mm, 7m

clm243355
Livrare imediată!

27,91Lei

BANDA PVA SOLUBILA FOX EDGES SLOW MELT 20M

BANDA PVA SOLUBILA FOX EDGES SLOW MELT 20M

cpv081
Livrare imediată!

21,40Lei

LINGURITA, OSCILANTA, RAPALA, HARMAJA, SMELT, ON, THE, BEACH, SMB, 11.6CM, 31G, har31 smb, Lingurite Oscilante, Lingurite Oscilante Rapala, Rapala
SHAD SAVAGE GEAR GOBSTER 7.5CM 5G SMELT 5BUC/PLIC -40%
Exclusiv online!

SHAD SAVAGE GEAR GOBSTER 7.5CM 5G SMELT 5BUC/PLIC

f1.sg.76934
Livrare 24-48 ore

22,05Lei(-40%) 13,23Lei

SHAD SAVAGE GEAR GOBSTER 11.5CM 16G SMELT 5BUC/PLIC -40%
Exclusiv online!

SHAD SAVAGE GEAR GOBSTER 11.5CM 16G SMELT 5BUC/PLIC

f1.sg.76946
Livrare 24-48 ore

30,70Lei(-40%) 18,42Lei

SHAD SAVAGE GEAR GOBSTER 9CM 9G SMELT 5BUC/PLIC -40%
Exclusiv online!

SHAD SAVAGE GEAR GOBSTER 9CM 9G SMELT 5BUC/PLIC

f1.sg.76940
Livrare 24-48 ore

24,54Lei(-40%) 14,72Lei

Rezerva Plasa Solubila FOX Refill Spool, Fast Melt Refills, Narrow-25mm, 5m

Rezerva Plasa Solubila FOX Refill Spool, Fast Melt Refills, Narrow-25mm, 5m

cpv067
Livrare imediată!

26,97Lei

PUNGA PVA SOLUBILA FL Slow MELT 70X140 10BUC

PUNGA PVA SOLUBILA FL Slow MELT 70X140 10BUC

64-19378
Livrare imediată!

10,90Lei

Vobler Live Target Rainbow Smelt Jerkbait, Gold / Orange, 7cm, 3g -20%

Vobler Live Target Rainbow Smelt Jerkbait, Gold / Orange, 7cm, 3g

lt.rs70s220
Livrare imediată!

40,00Lei(-20%) 31,99Lei

PUNGA PVA SOLUBILA FL Slow MELT 60X120 10BUC

PUNGA PVA SOLUBILA FL Slow MELT 60X120 10BUC

64-19361
Livrare imediată!

9,90Lei

Vobler LIVE TARGET RAINBOW SMELT JERKBAIT 7CM/3,5G GOLD/BLACK

Vobler LIVE TARGET RAINBOW SMELT JERKBAIT 7CM/3,5G GOLD/BLACK

lt.rs70d208
Livrare imediată!

40,00Lei

Vobler LIVE TARGET RAINBOW SMELT JERKBAIT 7CM/3,5G SILVER/BLACK

Vobler LIVE TARGET RAINBOW SMELT JERKBAIT 7CM/3,5G SILVER/BLACK

lt.rs70d202
Livrare imediată!

40,00Lei

Vobler Salmo Fatso Sinking, Spotted Holo Smelt, 8cm

Vobler Salmo Fatso Sinking, Spotted Holo Smelt, 8cm

qfa105
Livrare imediată!

58,00Lei

Vobler, Live, Target, Rainbow, Smelt, Ban, Bait,, Silver, Blue,, 11.5cm,, 18g, lt.rsb115d201, Voblere Suspending, Voblere Suspending Live Target, Live Target
Vobler, LIVE, TARGET, RAINBOW, SMELT, JERKBAIT, 7CM/3,5G, SILVER/BLUE, lt.rs70d201, Voblere Suspending, Voblere Suspending Live Target, Voblere Live Target, Suspending Live Target, Live Target
Shad Savage Gear Fat Minnow T-Tail, Smelt, 10.5cm, 11g, 5buc/pac -40%

Shad Savage Gear Fat Minnow T-Tail, Smelt, 10.5cm, 11g, 5buc/pac

f1.sg.76994
Livrare imediată!

40,48Lei(-40%) 24,29Lei

Shad Savage Gear Fat Minnow T-Tail, Smelt, 13cm, 20g, 5buc/pac -40%
Exclusiv online!

Shad Savage Gear Fat Minnow T-Tail, Smelt, 13cm, 20g, 5buc/pac

f1.sg.77000
Livrare 24-48 ore

51,90Lei(-40%) 31,14Lei

Vobler, Salmo, Fatso, Floating,, Spotted, Holo, Smelt,, 12cm, qfa099, Voblere Floating, Voblere Floating Salmo, Salmo
Exclusiv online!

Vobler, Salmo, Fatso, Floating,, Spotted, Holo, Smelt,, 12cm, qfa099, Voblere Floating, Voblere Floating Salmo, Salmo

qfa099
Livrare 7-14 zile

76,46Lei

Afişare 1 - 20 din 125 (7 pagini)
Queries: 11, Total time: 1,488.535 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = '9036c2c5f33363308d0c32a6d1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.120)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.136)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (503.383)
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 = '2' AND (pd.tag LIKE "%melt%") 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
5 (492.641)
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 = '2' AND (pd.tag LIKE "%melt%") 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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.201)
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.214)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
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 = '2' AND (pd.tag LIKE "%melt%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1005
8 (491.330)
SELECT COUNT(*) AS val, filter_group, filter_id
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 = '2' AND (pd.tag LIKE "%melt%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:917
9 (0.144)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.123)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (0.126)
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