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

Produse ce potrivesc criteriilor de căutare


Vobler Owner Tango Dancer 5249 TD-95 95mm 11gr 15 Blue Back
Exclusiv online!

Vobler Owner Tango Dancer 5249 TD-95 95mm 11gr 15 Blue Back

804020103
Livrare 48-72 ore

46,72Lei

VOBLER STRIKE PRO BABY PRO A12FL, 2,5CM, 2G

VOBLER STRIKE PRO BABY PRO A12FL, 2,5CM, 2G

sp.eg036.a12fl
Livrare imediată!

33,67Lei

VOBLER STRIKE PRO AQUAMAX VIB 5CM/7,3G 626E

VOBLER STRIKE PRO AQUAMAX VIB 5CM/7,3G 626E

sp.jl129.626e
Livrare imediată!

30,27Lei

Vobler Strike Pro Archback A17, 8.0cm, 8.5g -24%

Vobler Strike Pro Archback A17, 8.0cm, 8.5g

sp.eg125a.a17
Livrare imediată!

34,26Lei(-24%) 25,89Lei

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G F
Exclusiv online!

RATA ARTIFICIALA JAXON ATTRACT HAPPY DUCK 13CM 23G F

vr-msl01f
Livrare 48-72 ore

85,00Lei

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 56 Red Shiner
Exclusiv online!

Vobler Owner Gobo Popper 5264 GP-60F 60mm 6.3gr 56 Red Shiner

804020085
Livrare 48-72 ore

54,63Lei

VOBLER RAPALA CH ULTRA LIGHT MINNOW

VOBLER RAPALA CH ULTRA LIGHT MINNOW

ulm04 ch
Livrare imediată!

42,00Lei

Vobler Lucky John Pro Series Vikara Sinking 6.2cm 13gr 704 1 buc/pac -25%

Vobler Lucky John Pro Series Vikara Sinking 6.2cm 13gr 704 1 buc/pac

lj-v62-704
Livrare imediată!

33,00Lei(-25%) 24,89Lei

Vobler Salmo Rattlin Hornet F 4.5cm CHARTREUSE BLUE

Vobler Salmo Rattlin Hornet F 4.5cm CHARTREUSE BLUE

qrh028
Livrare imediată!

58,10Lei

VOBLER JAXON CARPAN F KZ 9CM-27GR
Exclusiv online!

VOBLER JAXON CARPAN F KZ 9CM-27GR

vj-ca09fkz
Livrare 48-72 ore

39,00Lei

Vobler Strike Pro Flap Jack, Culoare A55S, 6.5cm, 13.6g
Exclusiv online!

Vobler Strike Pro Flap Jack, Culoare A55S, 6.5cm, 13.6g

sp.eg128b.a55s
Livrare 24-48 ore

27,08Lei

VOBLER STRIKE PRO MUSTANG MINNOW 3,5CM/1,6G A02AT
Exclusiv online!

VOBLER STRIKE PRO MUSTANG MINNOW 3,5CM/1,6G A02AT

sp.mg015.a02at
Livrare 24-48 ore

31,46Lei

VOBLER JAXON HIPER JERK S OB 11CM-46GR
Exclusiv online!

VOBLER JAXON HIPER JERK S OB 11CM-46GR

vj-v11sob
Livrare 48-72 ore

39,00Lei

Vobler Sakura Notobug 30F 30mm 3.5gr 08

Vobler Sakura Notobug 30F 30mm 3.5gr 08

80434saplb50393008
Livrare imediată!

52,29Lei

Vobler Yo-Zuri 3DS Flat Crank Floating, 5.5cm, 7.5gr Culoare BCL 1 buc/pac
Exclusiv online!

Vobler Yo-Zuri 3DS Flat Crank Floating, 5.5cm, 7.5gr Culoare BCL 1 buc/pac

f1141-bcl
Livrare 48-72ore

39,00Lei

VOBLER COLMIC HERAKLES SNAKE 95F 9.5cm 8.8gr Shad
Exclusiv online!

VOBLER COLMIC HERAKLES SNAKE 95F 9.5cm 8.8gr Shad

arhkfq04
Livrare 48-72 ore

38,00Lei

VOBLER COLMIC HERAKLES STRIKE 90SP 9cm 11gr Smoke Gold
Exclusiv online!

VOBLER COLMIC HERAKLES STRIKE 90SP 9cm 11gr Smoke Gold

arhkbi06
Livrare 48-72 ore

48,00Lei

VOBLER SALMO LIL BUG 3CM 4.3G BG3 GBG

VOBLER SALMO LIL BUG 3CM 4.3G BG3 GBG

qbg001
Livrare imediată!

40,46Lei

VOBLER COLMIC MACISTE RATTLE F 7.0cm 22.5gr RED CRAW -30%
Exclusiv online!

VOBLER COLMIC MACISTE RATTLE F 7.0cm 22.5gr RED CRAW

arhkim02
Livrare 48-72 ore

36,00Lei(-30%) 25,20Lei

VOBLER LINEAEFFE NOMURA RANGER MINNOW 7CM/13G YELLOW ORANGE
Exclusiv online!

VOBLER LINEAEFFE NOMURA RANGER MINNOW 7CM/13G YELLOW ORANGE

nm.52216107
Livrare 24-48 ore

42,27Lei

Afişare 3041 - 3060 din 8963 (449 pagini)
Queries: 6, Total time: 916.605 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = 'a18a0dd68ea1e14ca1bf970ad4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (874.107)
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 (pd.tag LIKE "%vobler%") 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:725
4 (41.904)
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 3040, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.217)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.172)
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