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 JAXON HS GERIT FL SN 14CM 25G
Exclusiv online!

VOBLER JAXON HS GERIT FL SN 14CM 25G

vj-ge11fsn
Livrare 48-72 ore

52,00Lei

VOBLER RAPALA DIVES-TO 6CM / 17GR FT

VOBLER RAPALA DIVES-TO 6CM / 17GR FT

dt10 ft
Livrare imediată!

54,00Lei

Vobler Salmo Hornet H5.5F Holographic Blue Sky 5.5cm 10.5g
Exclusiv online!

Vobler Salmo Hornet H5.5F Holographic Blue Sky 5.5cm 10.5g

84415853
Livrare 24-48 ore

50,00Lei

Vobler Salmo Hornet H5s HP
Exclusiv online!

Vobler Salmo Hornet H5s HP

84415518
Livrare 24-48 ore

43,99Lei

Vobler Biwaa Glider Raffal Loro 13cm 75g
Exclusiv online!

Vobler Biwaa Glider Raffal Loro 13cm 75g

b001712
Livrare 48-72 ore

72,00Lei

VOBLER JAXON HS SPIRIT DR F TR 7CM 15G
Exclusiv online!

VOBLER JAXON HS SPIRIT DR F TR 7CM 15G

vj-sc07drtr
Livrare 48-72 ore

36,00Lei

VOBLER RAPALA J09 S JOINTED

VOBLER RAPALA J09 S JOINTED

j09 s
Livrare imediată!

53,00Lei

Vobler Salmo Freediver Super Deep Runner 7cm culoare Hot Perch

Vobler Salmo Freediver Super Deep Runner 7cm culoare Hot Perch

qfd092
Livrare imediată!

56,22Lei

VOBLER JAXON SENSO F OM 4CM 3GR
Exclusiv online!

VOBLER JAXON SENSO F OM 4CM 3GR

vj-se04fom
Livrare 48-72 ore

26,00Lei

Vobler Kenart Diver Floating 4cm 3gr NP Natural Perch 1 buc/pac
Exclusiv online!

Vobler Kenart Diver Floating 4cm 3gr NP Natural Perch 1 buc/pac

div4f-np
Livrare 48-72ore

21,50Lei

VOBLER RAPALA ULTRA LIGHT CRANK 3CM / 4GR SB

VOBLER RAPALA ULTRA LIGHT CRANK 3CM / 4GR SB

ulc03 sb
Livrare imediată!

42,99Lei

Vobler Rapala BX Brat 06, Culoare ROC, 5cm, 11g

Vobler Rapala BX Brat 06, Culoare ROC, 5cm, 11g

bxb06 roc
Livrare imediată!

59,00Lei

Vobler Salmo Bullhead Floating BD6F Culoare Red Tail Shiner 6cm 6g -20%
Exclusiv online!

Vobler Salmo Bullhead Floating BD6F Culoare Red Tail Shiner 6cm 6g

84436132
Livrare 24-48 ore

32,00Lei(-20%) 25,60Lei

Vobler Salmo Slick Stick SU6F RBL Real Bleak 6cm 3g

Vobler Salmo Slick Stick SU6F RBL Real Bleak 6cm 3g

84619272
Livrare imediată!

46,01Lei

Vobler Biwaa Glider Raffal Hi Viz 13cm 75g
Exclusiv online!

Vobler Biwaa Glider Raffal Hi Viz 13cm 75g

b001710
Livrare 48-72 ore

72,00Lei

Vobler DUO Jerkbait 85 SP 8.5cm 8g ADA3058 Prism Gill

Vobler DUO Jerkbait 85 SP 8.5cm 8g ADA3058 Prism Gill

duo26261
Livrare imediată!

72,00Lei

VOBLER JAXON ATRACT LOGIS F D 8CM 10GR
Exclusiv online!

VOBLER JAXON ATRACT LOGIS F D 8CM 10GR

vr-xhi080d
Livrare 48-72 ore

13,99Lei

VOBLER JAXON HOLO SELECT FEROX UV F PE 10CM 16GR

VOBLER JAXON HOLO SELECT FEROX UV F PE 10CM 16GR

vu-f10fpe
Livrare imediată!

38,00Lei

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 Rattlin Hornet Culoare VIK 3.5cm 3.1g
Exclusiv online!

Vobler Salmo Rattlin Hornet Culoare VIK 3.5cm 3.1g

84413099
Livrare 24-48 ore

45,01Lei

Afişare 4001 - 4020 din 8749 (438 pagini)
Queries: 5, Total time: 245.222 ms [By time] [By id] [By file]
1 (0.090)
SELECT data
FROM `oc_session`
WHERE session_id = '6847c632ab0e45ac943563f12c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (244.794)
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('+vobler' 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
4 (0.165)
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
5 (0.090)
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