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


Boilies Benzar Mix Feed Usturoi alb 20mm 5kg

Boilies Benzar Mix Feed Usturoi alb 20mm 5kg

98019005
Stoc epuizat

99,00Lei

Boilies Benzar Mix Turbo Boilies Choco Orange 24mm 800g

Boilies Benzar Mix Turbo Boilies Choco Orange 24mm 800g

98018288
Stoc epuizat

23,00Lei

Sita Genlog Feeder Orange Diametru 3mm 34cm

Sita Genlog Feeder Orange Diametru 3mm 34cm

gsg0-02-3mm
Stoc epuizat

79,00Lei

Sita Genlog Feeder Orange Diametru 3mm 37cm -20%

Sita Genlog Feeder Orange Diametru 3mm 37cm

gsg0-03-3mm
Stoc epuizat

84,00Lei(-20%) 67,20Lei

ADITIV MAINLINE MULTI STIM PENTRU MIX BOILIES 250ML

ADITIV MAINLINE MULTI STIM PENTRU MIX BOILIES 250ML

a0.m.m16004
Stoc epuizat

86,97Lei

Vaselina Daiwa pentru Mulinete Space Age

Vaselina Daiwa pentru Mulinete Space Age

d.drg1
Stoc epuizat

64,32Lei

Multifilament Spro Scufundator Cresta Pentru Feeder 150m 0.10mm

Multifilament Spro Scufundator Cresta Pentru Feeder 150m 0.10mm

005302-00110-00000
Stoc epuizat

138,00Lei

PENAR GURU PENTRU MONTURI XL RIG CASE 48X25X6CM

PENAR GURU PENTRU MONTURI XL RIG CASE 48X25X6CM

a4.gu.grcx
Stoc epuizat

320,65Lei

PRESA ATTACK PENTRU BULGARI NADA 40 MM

PRESA ATTACK PENTRU BULGARI NADA 40 MM

ai-bm11-40
Stoc epuizat

14,49Lei

BORSETA PENTRU NALUCI JACKALL GREEN -20%

BORSETA PENTRU NALUCI JACKALL GREEN

a8.ja.807189018
Stoc epuizat

195,41Lei(-20%) 156,33Lei

ULEI DAIWA PENTRU MULINETE

ULEI DAIWA PENTRU MULINETE

d.dro1
Stoc epuizat

47,03Lei

DISPOZITIV GURU PENTRU PELETE 6MM 8MM 10MM 12MM

DISPOZITIV GURU PENTRU PELETE 6MM 8MM 10MM 12MM

a.gu.gps
Stoc epuizat

69,66Lei

COLANT SENSAS PENTRU VIERMI 350G

COLANT SENSAS PENTRU VIERMI 350G

a0.s15041
Stoc epuizat

40,92Lei

Sita Delphin ATOMA RoundMESH 29cm 4mm -14%

Sita Delphin ATOMA RoundMESH 29cm 4mm

101002102
Stoc epuizat

58,00Lei(-14%) 50,00Lei

Varf de Rezerva pentru Lansete Matrix Ethos XRD 2.5oz Tip Carbon 3.4mm

Varf de Rezerva pentru Lansete Matrix Ethos XRD 2.5oz Tip Carbon 3.4mm

grd215
Stoc epuizat

107,96Lei

Garnitura de Rezerva pentru Tigaie Delphin, 70cm

Garnitura de Rezerva pentru Tigaie Delphin, 70cm

101002163
Stoc epuizat

16,01Lei

Tigaie Delphin ProfiPAN 22x28x7cm -24%

Tigaie Delphin ProfiPAN 22x28x7cm

101002095
Stoc epuizat

190,00Lei(-24%) 145,00Lei

Borseta Avid Carp Compound Pouch Large 40x20x10cm

Borseta Avid Carp Compound Pouch Large 40x20x10cm

a0430050
Stoc epuizat

53,95Lei

Plasa de Rezerva pentru Minciog Avid Carp 107x107cm

Plasa de Rezerva pentru Minciog Avid Carp 107x107cm

a0610007
Stoc epuizat

97,37Lei

Plasa de Rezerva pentru Minciog Avid Carp CAMO 107x107cm

Plasa de Rezerva pentru Minciog Avid Carp CAMO 107x107cm

a0610013
Stoc epuizat

134,96Lei

Afişare 4821 - 4840 din 5141 (258 pagini)
Queries: 6, Total time: 122.052 ms [By time] [By id] [By file]
1 (0.148)
SELECT data
FROM `oc_session`
WHERE session_id = 'c6f0114683f839fc402ed58ac8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (100.957)
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('+pentru' 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 (20.581)
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 4820, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.134)
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