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


CARLIGE ENERGO TEAM EXCALIBUR BREAM MATCH BROWN NR 12

CARLIGE ENERGO TEAM EXCALIBUR BREAM MATCH BROWN NR 12

47025012
Livrare imediată!

8,00Lei

Fir Mivardi Leadcore Camou Brown 10m 45lbs
Exclusiv online!

Fir Mivardi Leadcore Camou Brown 10m 45lbs

m-acrllccb
Livrare 48-72 ore

42,00Lei

FIR monofilament PROLOGIC DENSITY CARP MONO BROWN 0.35MM/6.80KG/1000M -20%
Exclusiv online!

FIR monofilament PROLOGIC DENSITY CARP MONO BROWN 0.35MM/6.80KG/1000M

a.pro.64115
Livrare 24-48 ore

126,18Lei(-20%) 100,94Lei

VOBLER CORMORAN COR F1 3,5CM/2G METALLIC BROWN

VOBLER CORMORAN COR F1 3,5CM/2G METALLIC BROWN

f3.53.04353
Livrare imediată!

24,94Lei

Chatterbait Quantum 4Street 10g Brown Craw

Chatterbait Quantum 4Street 10g Brown Craw

3139104
Livrare imediată!

26,78Lei

FIR CARP ZOOM SERIA EXTREME CARP 250m 0.40mm Brown

FIR CARP ZOOM SERIA EXTREME CARP 250m 0.40mm Brown

cz2293
Livrare imediată!

12,50Lei

Nada Sensas 3000 Club Bream Brown 1 Kg
Exclusiv online!

Nada Sensas 3000 Club Bream Brown 1 Kg

a0.s11282
Livrare 24-48 ore

18,22Lei

Stoper Garbolino Hair Speed Brown XS

Stoper Garbolino Hair Speed Brown XS

40230gofah0321-mbr
Livrare imediată!

9,81Lei

Fir Textil Carp Spirit Reaction Braid Camo Brown 20m 15lbs 6.80kg -36%
Exclusiv online!

Fir Textil Carp Spirit Reaction Braid Camo Brown 20m 15lbs 6.80kg

acs640062
Livrare 48-72ore

45,01Lei(-36%) 29,00Lei

Fir monofilament Climax FIR HYPER FEEDER 250M 0.25mm Dark Brown
Exclusiv online!

Fir monofilament Climax FIR HYPER FEEDER 250M 0.25mm Dark Brown

8581-10250-025
Livrare 48-72 ore

33,00Lei

FIR MONOFILAMENT ASSO SINKING 3X FEEDER - Brown 0.198mm 150m 2.6Kg
Exclusiv online!

FIR MONOFILAMENT ASSO SINKING 3X FEEDER - Brown 0.198mm 150m 2.6Kg

604080034
Livrare 48-72 ore

48,03Lei

Fir Textil Carp Spirit Ballistic 20m, 15.90 kg, Camo Brown -24%
Exclusiv online!

Fir Textil Carp Spirit Ballistic 20m, 15.90 kg, Camo Brown

acs640037
Livrare 48-72ore

59,00Lei(-24%) 45,01Lei

Fir Textil 007 CPK SILKY NATURAL Hooklink 0.23 MM 26 lb/ 11.8 kg BROWN

Fir Textil 007 CPK SILKY NATURAL Hooklink 0.23 MM 26 lb/ 11.8 kg BROWN

999965
Livrare imediată!

29,00Lei

VOBLER COLMIC HERAKLES TINY ASTRO F 8.5cm 12gr Brown Craw -30%
Exclusiv online!

VOBLER COLMIC HERAKLES TINY ASTRO F 8.5cm 12gr Brown Craw

arhkeb04
Livrare 48-72 ore

33,00Lei(-30%) 23,10Lei

Fir ASSO Ultra Carp Brown 0.30 mm 1000 m

Fir ASSO Ultra Carp Brown 0.30 mm 1000 m

607080065
Livrare imediată!

73,84Lei

Rotativa 3.5g Zebco Waterwings Spinner Brown

Rotativa 3.5g Zebco Waterwings Spinner Brown

3330105
Livrare imediată!

13,28Lei

Fir textil Kryston Ton Up Brown 85lb 10m
Exclusiv online!

Fir textil Kryston Ton Up Brown 85lb 10m

krto1
Livrare 48-72 ore

62,00Lei

LACUSTA RAPTURE DRAGONFLY NIMPH 4.2CM 1GR BROWN

LACUSTA RAPTURE DRAGONFLY NIMPH 4.2CM 1GR BROWN

187-21-093
Livrare imediată!

21,00Lei

FIR monofilament PROLOGIC DENSITY CARP MONO BROWN 0.37MM/8.17KG/1000M -20%
Exclusiv online!

FIR monofilament PROLOGIC DENSITY CARP MONO BROWN 0.37MM/8.17KG/1000M

a.pro.64116
Livrare 24-48 ore

130,36Lei(-20%) 104,27Lei

FIR TEXTIL Climax CULT CATFISH STRONG BROWN 1000m 0.50mm 50kg
Exclusiv online!

FIR TEXTIL Climax CULT CATFISH STRONG BROWN 1000m 0.50mm 50kg

9152-01000-050
Livrare 48-72 ore

463,01Lei

Afişare 421 - 440 din 850 (43 pagini)
Queries: 6, Total time: 21.159 ms [By time] [By id] [By file]
1 (0.186)
SELECT data
FROM `oc_session`
WHERE session_id = 'accd1f54daee177ba28fce915e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (20.439)
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('+brown' 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.168)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.134)
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