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 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
Exclusiv online!

Fir monofilament Trabucco T-Force XPS Match Sinking O.18mm/150m

053-85-180
Livrare 48-72 ore

31,00Lei

VOBLER RAPALA SHADOW RAP 11CM S

VOBLER RAPALA SHADOW RAP 11CM S

sdr11 s
Livrare imediată!

59,00Lei

Vobler GoldStar Bug Culoare 14

Vobler GoldStar Bug Culoare 14

87225214
Livrare imediată!

8,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 Rapala Ultra Light Shad 4cm/3gr. SB

Vobler Rapala Ultra Light Shad 4cm/3gr. SB

uls04 sb
Livrare imediată!

42,00Lei

VOBLER SALMO TH9S BLUE FINGERLING Thrill 070MM Sinking

VOBLER SALMO TH9S BLUE FINGERLING Thrill 070MM Sinking

qth008
Livrare imediată!

49,46Lei

VOBLER COLMIC DARKO-S 14.5cm 60gr Holo Clown -40%
Exclusiv online!

VOBLER COLMIC DARKO-S 14.5cm 60gr Holo Clown

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

VOBLER COLMIC HELIX TOPWATER 11.5cm 16gr CHARTREUSE IMPACT -30%
Exclusiv online!

VOBLER COLMIC HELIX TOPWATER 11.5cm 16gr CHARTREUSE IMPACT

arhkiw04
Livrare 48-72 ore

58,00Lei(-30%) 40,60Lei

Fir monofilament Trabucco T-Force XPS Match Sinking O.20mm/150m

Fir monofilament Trabucco T-Force XPS Match Sinking O.20mm/150m

053-85-200
Livrare imediată!

34,00Lei

Fir Monofilament Scufundator Cralusso Match Sinking 500m 0.20mm 4.10kg

Fir Monofilament Scufundator Cralusso Match Sinking 500m 0.20mm 4.10kg

33903520
Livrare imediată!

50,00Lei

Fir ASSO Sinking 3X Feeder Brown 0.149mm
Exclusiv online!

Fir ASSO Sinking 3X Feeder Brown 0.149mm

604080031
Livrare 48-72 ore

38,87Lei

VOBLER LINEAEFFE NOMURA RANGER MINNOW 7CM/13G NATURAL LIGHT BLUE
Exclusiv online!

VOBLER LINEAEFFE NOMURA RANGER MINNOW 7CM/13G NATURAL LIGHT BLUE

nm.52208307
Livrare 24-48 ore

42,27Lei

VOBLER RAPTURE UNDER SILENT MAX 7.5CM 19GR HRH

VOBLER RAPTURE UNDER SILENT MAX 7.5CM 19GR HRH

180-02-838
Livrare imediată!

28,00Lei

FIR MONOFILAMENT TRABUCCO TF XPS SINKING PLUS 150MT 0.16MM

FIR MONOFILAMENT TRABUCCO TF XPS SINKING PLUS 150MT 0.16MM

052-00-160
Livrare imediată!

36,00Lei

VOBLER STRIKE PRO 6,5CM/13,6G FLAP JACK

VOBLER STRIKE PRO 6,5CM/13,6G FLAP JACK

sp.eg128b.a02at
Livrare imediată!

31,61Lei

Vobler Salmo Hornet H2S Hot Perch, 2.5cm, 1.5g -34%

Vobler Salmo Hornet H2S Hot Perch, 2.5cm, 1.5g

qht001
Livrare imediată!

40,46Lei(-34%) 26,91Lei

Afişare 1861 - 1880 din 4831 (242 pagini)
Queries: 4, Total time: 114.478 ms [By time] [By id] [By file]
1 (0.188)
SELECT data
FROM `oc_session`
WHERE session_id = '3102b8cf65de6c3e98460ac279'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (114.024)
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 = '2' AND (MATCH(pd.tag) AGAINST('+sinking' 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.154)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38