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 COLMIC DARKO-F 14.5cm 29gr Bandit -40%
Exclusiv online!

VOBLER COLMIC DARKO-F 14.5cm 29gr Bandit

arhkdw06
Livrare 48-72 ore

48,00Lei(-40%) 28,80Lei

VOBLER SPRO IRIS SLOW SINKING FIRETIGER 9.5 CM 37 GR
Exclusiv online!

VOBLER SPRO IRIS SLOW SINKING FIRETIGER 9.5 CM 37 GR

004867-01201-00000
Livrare 48-72 ore

69,00Lei

VOBLER RAPALA SHADOW RAP 11CM AS

VOBLER RAPALA SHADOW RAP 11CM AS

sdr11 as
Livrare imediată!

59,00Lei

VOBLER RAPTURE NEO CRANK SQR 5CM 8GR CTM

VOBLER RAPTURE NEO CRANK SQR 5CM 8GR CTM

180-17-827
Stoc epuizat

26,00Lei

VOBLER JAXON ATRACT MULTI PARTS XMP-G S H 15CM 39GR
Exclusiv online!

VOBLER JAXON ATRACT MULTI PARTS XMP-G S H 15CM 39GR

vr-msg150h
Livrare 48-72 ore

57,00Lei

VOBLER SALMO TH5S REAL BLEAK Thrill 050MM Sinking

VOBLER SALMO TH5S REAL BLEAK Thrill 050MM Sinking

qth003
Livrare imediată!

47,21Lei

VOBLER DUO RYUKI 45S 4.5CM 4G ANI4004 NATURAL YAMAME S
Exclusiv online!

VOBLER DUO RYUKI 45S 4.5CM 4G ANI4004 NATURAL YAMAME S

duo30797
Livrare 48-72 ore

66,00Lei

VOBLER COLMIC DOGO 110SP 11cm 19gr Perch
Exclusiv online!

VOBLER COLMIC DOGO 110SP 11cm 19gr Perch

arhkdq08
Livrare 48-72 ore

83,00Lei

VOBLER RAPTURE CRANK SQR DR 5CM 8GR GTS -35%

VOBLER RAPTURE CRANK SQR DR 5CM 8GR GTS

180-17-951
Livrare imediată!

25,00Lei(-35%) 16,18Lei

Vobler Kenart Hunter Floating 3cm 2.5gr YB Yellow Black 1 buc/pac

Vobler Kenart Hunter Floating 3cm 2.5gr YB Yellow Black 1 buc/pac

hu3f-yb
Livrare imediată!

21,50Lei

VOBLER STORM ARASHI RATTLING MINNOW 11CM / 17GR CULOARE 952

VOBLER STORM ARASHI RATTLING MINNOW 11CM / 17GR CULOARE 952

arm11 952
Livrare imediată!

25,00Lei

VOBLER CARP ZOOM PREDATOR-Z DEEP MINNOW 9.5cm 10.2gr Sinking 0818 -20%

VOBLER CARP ZOOM PREDATOR-Z DEEP MINNOW 9.5cm 10.2gr Sinking 0818

cz0818
Livrare imediată!

12,00Lei(-20%) 9,60Lei

Vobler Strike Pro Baby Pro EG-036 Culoarea 536F

Vobler Strike Pro Baby Pro EG-036 Culoarea 536F

sp.eg036.536f
Livrare imediată!

30,71Lei

Vobler GoldStar Bug Culoare 1

Vobler GoldStar Bug Culoare 1

87225201
Livrare imediată!

8,00Lei

VOBLER CARP ZOOM PREDATOR-Z ASP MINNOW 9.0cm 5.8gr FLOATING 1006 -24%

VOBLER CARP ZOOM PREDATOR-Z ASP MINNOW 9.0cm 5.8gr FLOATING 1006

cz1006
Livrare imediată!

12,00Lei(-24%) 9,16Lei

VOBLER CARP ZOOM PREDATOR -Z BOXER CRANK 5.5cm 8.0gr FLOATING 1181 -23%

VOBLER CARP ZOOM PREDATOR -Z BOXER CRANK 5.5cm 8.0gr FLOATING 1181

cz1181
Livrare imediată!

12,00Lei(-23%) 9,28Lei

VOBLER RAPTURE CRANK SQR DR 5CM 8GR CTM

VOBLER RAPTURE CRANK SQR DR 5CM 8GR CTM

180-17-927
Stoc epuizat

25,00Lei

Vobler Salmo Slider 7.0cm/17.0Gr Floating SD7F PA

Vobler Salmo Slider 7.0cm/17.0Gr Floating SD7F PA

84577183
Livrare imediată!

58,00Lei

VOBLER CARP ZOOM PREDATOR -Z ASP SHAD 10cm 11.0gr FLOATING 0856 -24%

VOBLER CARP ZOOM PREDATOR -Z ASP SHAD 10cm 11.0gr FLOATING 0856

cz0856
Livrare imediată!

12,00Lei(-24%) 9,16Lei

VOBLER COLMIC HERAKLES SNAKE 95SP 9.5cm 9gr Alburno Flash
Exclusiv online!

VOBLER COLMIC HERAKLES SNAKE 95SP 9.5cm 9gr Alburno Flash

arhkdo11
Livrare 48-72 ore

67,00Lei

Afişare 2481 - 2500 din 8749 (438 pagini)
Queries: 4, Total time: 245.594 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = 'b7b2e6d36e38127bde8211c7b4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.096)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (245.200)
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.149)
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