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


Vobler Salmo Thrill TH5 Gunmetal Fish 5cm 6.5g
Exclusiv online!

Vobler Salmo Thrill TH5 Gunmetal Fish 5cm 6.5g

84535528
Livrare 24-48 ore

43,99Lei

Vobler Salmo Rattlin' Slider 11cm culoare Bright Perch

Vobler Salmo Rattlin' Slider 11cm culoare Bright Perch

qrn012
Livrare imediată!

76,46Lei

Vobler Salmo Chubby Darter CD5 D 5cm 9g
Exclusiv online!

Vobler Salmo Chubby Darter CD5 D 5cm 9g

84525506
Livrare 24-48 ore

34,00Lei

Vobler Salmo Freediver Super Deep Runner 7cm culoare Purple Rain -39%

Vobler Salmo Freediver Super Deep Runner 7cm culoare Purple Rain

qfd093
Livrare imediată!

57,45Lei(-39%) 34,90Lei

Vobler, Salmo, Slider, Sinking, 7cm/21g, culoare, Mirror, Carp, qsd350, Voblere Sinking, Voblere Sinking Salmo, Salmo -20%

Vobler, Salmo, Slider, Sinking, 7cm/21g, culoare, Mirror, Carp, qsd350, Voblere Sinking, Voblere Sinking Salmo, Salmo

qsd350
Livrare imediată!

60,30Lei(-20%) 48,24Lei

VOBLER, SALMO, MINNOW, M7S, M, 7CM, 8G, 84427526, Voblere Sinking, Voblere Sinking Salmo, Salmo

VOBLER, SALMO, MINNOW, M7S, M, 7CM, 8G, 84427526, Voblere Sinking, Voblere Sinking Salmo, Salmo

84427526
Livrare imediată!

42,00Lei

VOBLER, SALMO, TINY, IT3S, HC,, 3CM,, 2.5G, 84503578, Voblere Sinking, Voblere Sinking Salmo, Salmo

VOBLER, SALMO, TINY, IT3S, HC,, 3CM,, 2.5G, 84503578, Voblere Sinking, Voblere Sinking Salmo, Salmo

84503578
Livrare imediată!

38,00Lei

Vobler Salmo Freediver Super Deep Runner 7cm culoare Silver Blue -33%

Vobler Salmo Freediver Super Deep Runner 7cm culoare Silver Blue

qfd094
Livrare imediată!

56,22Lei(-33%) 37,90Lei

Vobler, Salmo, Slider, Sinking, 10cm/46g, culoare, Mirror, Carp, qsd338, Voblere Sinking, Voblere Sinking Salmo, Voblere Salmo, Sinking Salmo, Salmo -38%
Vobler, Salmo, Hornet, H5s, HP, 84415518, Voblere Sinking, Voblere Sinking Salmo, Salmo
Exclusiv online!

Vobler, Salmo, Hornet, H5s, HP, 84415518, Voblere Sinking, Voblere Sinking Salmo, Salmo

84415518
Livrare 24-48 ore

43,99Lei

Vobler Salmo Freediver Super Deep Runner 7cm culoare Hot Perch -33%

Vobler Salmo Freediver Super Deep Runner 7cm culoare Hot Perch

qfd092
Livrare imediată!

56,22Lei(-33%) 37,90Lei

Vobler Salmo Rail Shad RBIPE Ice Perch 6cm 14g
Exclusiv online!

Vobler Salmo Rail Shad RBIPE Ice Perch 6cm 14g

84458004
Livrare 24-48 ore

62,00Lei

Vobler Salmo Rail Shad RBHNS Holographic Green Shiner 6cm 14g
Exclusiv online!

Vobler Salmo Rail Shad RBHNS Holographic Green Shiner 6cm 14g

84458002
Livrare 24-48 ore

62,00Lei

Vobler, Salmo, Slider, Sinking, 5cm/8g, culoare, Tench, qsd334, Voblere Sinking, Voblere Sinking Salmo, Salmo -29%

Vobler, Salmo, Slider, Sinking, 5cm/8g, culoare, Tench, qsd334, Voblere Sinking, Voblere Sinking Salmo, Salmo

qsd334
Livrare imediată!

42,40Lei(-29%) 29,90Lei

VOBLER SALMO THRILL TH9 SFF 9CM 22G

VOBLER SALMO THRILL TH9 SFF 9CM 22G

84539585
Livrare imediată!

48,00Lei

Vobler, Salmo, Hornet, Super, Deep, Runner, HOT, PERCH, QHT107, qht107, Voblere Sinking, Voblere Sinking Salmo, Salmo
VOBLER, SALMO, TINY, IT3S, SBT,, 3CM,, 2.5G, 84503580, Voblere Sinking, Voblere Sinking Salmo, Salmo

VOBLER, SALMO, TINY, IT3S, SBT,, 3CM,, 2.5G, 84503580, Voblere Sinking, Voblere Sinking Salmo, Salmo

84503580
Livrare imediată!

38,00Lei

Vobler Salmo Wave Luminescent Tobias 7cm 14g
Exclusiv online!

Vobler Salmo Wave Luminescent Tobias 7cm 14g

84807191
Livrare 24-48 ore

40,00Lei

VOBLER, SALMO, CHUBBY, DARTER, CD5, YD, 5cm, 9g, 84525534, Voblere Sinking, Voblere Sinking Salmo, Salmo
Exclusiv online!

VOBLER, SALMO, CHUBBY, DARTER, CD5, YD, 5cm, 9g, 84525534, Voblere Sinking, Voblere Sinking Salmo, Salmo

84525534
Livrare 24-48 ore

34,00Lei

Vobler Salmo Minnow Sinking 7cm 8g Grayling

Vobler Salmo Minnow Sinking 7cm 8g Grayling

qmw156
Livrare imediată!

46,31Lei

Afişare 141 - 160 din 387 (20 pagini)
Queries: 7, Total time: 184.358 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = 'bd7e6a5f9632c5bd4c057321dc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (183.660)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%voblere%' AND pd.tag LIKE '%sinking%' AND pd.tag LIKE '%salmo%')) 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:698
5 (0.119)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
6 (0.108)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.151)
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