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, Slider, Sinking, 5cm/8g, culoare, Mirror, Carp, qsd335, Voblere Sinking, Voblere Sinking Salmo, Salmo -29%
Exclusiv online!

Vobler, Salmo, Slider, Sinking, 5cm/8g, culoare, Mirror, Carp, qsd335, Voblere Sinking, Voblere Sinking Salmo, Salmo

qsd335
Livrare 48-72ore

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

VOBLER, SALMO, MINNOW, SINKING,, MINNOW,, 6CM,, 6G, qmw021, Voblere Sinking, Voblere Sinking Salmo, Salmo -40%

VOBLER, SALMO, MINNOW, SINKING,, MINNOW,, 6CM,, 6G, qmw021, Voblere Sinking, Voblere Sinking Salmo, Salmo

qmw021
Livrare imediată!

42,45Lei(-40%) 25,26Lei

Vobler, Salmo, Minnow, M5S, Trout, 5cm, 5g, 84425524, Voblere Sinking, Voblere Sinking Salmo, Salmo
Exclusiv online!

Vobler, Salmo, Minnow, M5S, Trout, 5cm, 5g, 84425524, Voblere Sinking, Voblere Sinking Salmo, Salmo

84425524
Livrare 24-48 ore

37,00Lei

Vobler Avat Salmo Thrill TH7 HBB Holo Blue Bleak 7cm 13g

Vobler Avat Salmo Thrill TH7 HBB Holo Blue Bleak 7cm 13g

84537a24
Livrare imediată!

46,01Lei

Vobler Rapture Hot Buzz 2.5cm Culoare Cluster Aburi Salmon
Exclusiv online!

Vobler Rapture Hot Buzz 2.5cm Culoare Cluster Aburi Salmon

180-06-994
Livrare 48-72 ore

25,00Lei

VOBLER, SALMO, MINNOW, M7S, HP, 7CM, 8G, 84427518, Voblere Sinking, Voblere Sinking Salmo, Salmo
Exclusiv online!

VOBLER, SALMO, MINNOW, M7S, HP, 7CM, 8G, 84427518, Voblere Sinking, Voblere Sinking Salmo, Salmo

84427518
Livrare 24-48 ore

42,00Lei

VOBLER, SALMO, MINNOW, SINKING,, MINNOW,, 5CM,, 5G, qmw010, Voblere Sinking, Voblere Sinking Salmo, Salmo -20%

VOBLER, SALMO, MINNOW, SINKING,, MINNOW,, 5CM,, 5G, qmw010, Voblere Sinking, Voblere Sinking Salmo, Salmo

qmw010
Livrare imediată!

40,21Lei(-20%) 32,17Lei

Vobler, Salmo, Minnow, Culoare, GT, 9cm, 12g, 84429516, Voblere Sinking, Voblere Sinking Salmo, Salmo

Vobler, Salmo, Minnow, Culoare, GT, 9cm, 12g, 84429516, Voblere Sinking, Voblere Sinking Salmo, Salmo

84429516
Livrare imediată!

45,01Lei

Vobler, Salmo, Minnow, Sinking, 7cm, 8g, Olive, Bleak, qmw158, Voblere Sinking, Voblere Sinking Salmo, Voblere Salmo, Sinking Salmo, Salmo -33%
Vobler Avat Salmo Thrill TH5 YBL Yellow Bleak 5cm 6.5g

Vobler Avat Salmo Thrill TH5 YBL Yellow Bleak 5cm 6.5g

84535a21
Livrare imediată!

43,99Lei

VOBLER SALMO MINNOW M6S T 6CM 6G
Exclusiv online!

VOBLER SALMO MINNOW M6S T 6CM 6G

84426524
Livrare 24-48 ore

40,00Lei

Vobler, Salmo, Hornet, H2S, SBH,, 2.5cm,, 1.5g, 84412551, Voblere Sinking, Voblere Sinking Salmo, Salmo

Vobler, Salmo, Hornet, H2S, SBH,, 2.5cm,, 1.5g, 84412551, Voblere Sinking, Voblere Sinking Salmo, Salmo

84412551
Livrare imediată!

37,00Lei

VOBLER SALMO MINNOW M7S DAB 7CM 8G
Exclusiv online!

VOBLER SALMO MINNOW M7S DAB 7CM 8G

84427508
Livrare 24-48 ore

42,00Lei

Vobler Salmo Slider SD7S, SGH Silver Ghost, 7cm, 21g

Vobler Salmo Slider SD7S, SGH Silver Ghost, 7cm, 21g

84577502
Livrare imediată!

48,00Lei

VOBLER SALMO MINNOW M6S HBL 6CM 6G
Exclusiv online!

VOBLER SALMO MINNOW M6S HBL 6CM 6G

84426575
Livrare 24-48 ore

40,00Lei

Vobler Salmo Slider SD7S HSB

Vobler Salmo Slider SD7S HSB

84577510
Livrare imediată!

58,00Lei

Vobler, Salmo, Minnow, Sinking, 5cm, 5g, Spirlin, qmw151, Voblere Sinking, Voblere Sinking Salmo, Salmo
Vobler Avat Salmo Thrill TH7 REB 7cm 13g

Vobler Avat Salmo Thrill TH7 REB 7cm 13g

84537a20
Livrare imediată!

46,01Lei

Vobler, Salmo, Minnow, Sinking, 5cm, 5g, Olive, Bleak, qmw152, Voblere Sinking, Voblere Sinking Salmo, Salmo
Exclusiv online!

Vobler, Salmo, Minnow, Sinking, 5cm, 5g, Olive, Bleak, qmw152, Voblere Sinking, Voblere Sinking Salmo, Salmo

qmw152
Livrare 7-14 zile

42,71Lei

Vobler Salmo Thrill TH9 BMG Blue Metalic Ghost 9cm 22g
Exclusiv online!

Vobler Salmo Thrill TH9 BMG Blue Metalic Ghost 9cm 22g

84539529
Livrare 24-48 ore

48,00Lei

Afişare 161 - 180 din 387 (20 pagini)
Queries: 9, Total time: 218.094 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = 'e26da19f51168677ae9fa60304'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (215.656)
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 (1.686)
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 160, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.092)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.105)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.087)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.124)
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