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 WOUNDED REAL GREY SHINER 7CM 21G

VOBLER SALMO SLIDER SINKING WOUNDED REAL GREY SHINER 7CM 21G

qsd016
Livrare imediată!

60,71Lei

VOBLER OWNER MIRA VIBE 5288 8.3CM / 21.3GR GOLD CROWN

VOBLER OWNER MIRA VIBE 5288 8.3CM / 21.3GR GOLD CROWN

804020052
Livrare imediată!

49,00Lei

Vobler Owner Mira Vibe Sinking, 13 Baby Bass, 19g, 8.3cm

Vobler Owner Mira Vibe Sinking, 13 Baby Bass, 19g, 8.3cm

804020051
Livrare imediată!

49,17Lei

Vobler, Yo-Zuri, 3D, Inshore, Twitchbait, SS, 7cm, 8.5g, culoare, C5, r1207-c5, Voblere Sinking, Voblere Sinking Yo-Zuri, Yo-Zuri -31%
Vobler, Salmo, Hornet, 3.5, Cm, Hot, Perch, 2.6, Gr, qht017, Voblere Sinking, Voblere Sinking Salmo, Salmo
Vobler Salmo Tiny 3,0cm/2,5g Sinking IT3S CC

Vobler Salmo Tiny 3,0cm/2,5g Sinking IT3S CC

84503573
Livrare imediată!

38,00Lei

FIR, MONOFILAMENT, TRABUCCO, TF, XPS, SINKING, PLUS, 150MT, , 0.20MM, 052-00-200, Fire Match (Scufundatoare), Fire Match (Scufundatoare) Trabucco, Trabucco
Vobler Strike Pro Rattle-N-Shad 7.5cm, culoare SM51F

Vobler Strike Pro Rattle-N-Shad 7.5cm, culoare SM51F

sp.jl027.sm51f
Livrare imediată!

42,08Lei

VOBLER RAPALA X-RAP COUNTDOWN 5CM / 4GR S

VOBLER RAPALA X-RAP COUNTDOWN 5CM / 4GR S

xrcd05 s
Livrare imediată!

52,00Lei

VOBLER SALMO THRILL 7CM BMG

VOBLER SALMO THRILL 7CM BMG

84537529
Livrare imediată!

46,01Lei

Fir, monofilament, Trabucco, T-Force, XPS, Match, Sinking, O.18mm/150m, 053-85-180, Fire Match (Scufundatoare), Fire Match (Scufundatoare) Trabucco, Trabucco
VOBLER, RAPALA, SHADOW, RAP, 11CM, S, , sdr11 s, Voblere Sinking, Voblere Sinking Rapala, Rapala

VOBLER, RAPALA, SHADOW, RAP, 11CM, S, , sdr11 s, Voblere Sinking, Voblere Sinking Rapala, Rapala

sdr11 s
Livrare imediată!

59,00Lei

Vobler GoldStar Bug Culoare 14

Vobler GoldStar Bug Culoare 14

87225214
Livrare imediată!

8,00Lei

VOBLER SPRO BBZ-14 SWIMBAIT SLOW SINKING 25 GR WICKED PERCH
Exclusiv online!

VOBLER SPRO BBZ-14 SWIMBAIT SLOW SINKING 25 GR WICKED PERCH

004864-00600-00000
Livrare 48-72 ore

66,00Lei

Vobler Biwaa Strout 14cm/29g culoare Rainbow
Exclusiv online!

Vobler Biwaa Strout 14cm/29g culoare Rainbow

b000285
Livrare 48-72 ore

103,99Lei

VOBLER OWNER MIRA VIBE 5268 6CM / 9.5GR BABY BASS
Exclusiv online!

VOBLER OWNER MIRA VIBE 5268 6CM / 9.5GR BABY BASS

804020061
Livrare 48-72 ore

46,29Lei

Vobler Spro Mini Crank DR 3 Cm
Exclusiv online!

Vobler Spro Mini Crank DR 3 Cm

004916-00001-00000
Livrare 48-72 ore

29,90Lei

VOBLER, SALMO, TH9S, BLUE, FINGERLING, Thrill, 070MM, Sinking, qth008, Voblere Sinking, Voblere Sinking Salmo, Salmo
VOBLER, COLMIC, DARKO-S, 14.5cm, 60gr, Holo, Clown, arhkdv06, Voblere Sinking, Voblere Sinking Colmic, Colmic -40%
Exclusiv online!

VOBLER, COLMIC, DARKO-S, 14.5cm, 60gr, Holo, Clown, arhkdv06, Voblere Sinking, Voblere Sinking Colmic, Colmic

arhkdv06
Livrare 48-72 ore

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

Fir Monofilament Scufundator Cralusso Match Sinking 500m 0.16mm 2.77kg

Fir Monofilament Scufundator Cralusso Match Sinking 500m 0.16mm 2.77kg

33903516
Livrare imediată!

50,00Lei

Afişare 1381 - 1400 din 4214 (211 pagini)
Queries: 7, Total time: 276.643 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = 'b0540fe850c6d11d8ca1153851'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (276.029)
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 "%sinking%") 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 (0.143)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
6 (0.111)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (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