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


FIR JAXON CARAT SPINNING 150m 0.30mm

FIR JAXON CARAT SPINNING 150m 0.30mm

zj-kas030a
Stoc epuizat

19,00Lei

SNUR MUSCA JAXON EASY CAST 100FT/30.48m 4F WFX-FLOATING

SNUR MUSCA JAXON EASY CAST 100FT/30.48m 4F WFX-FLOATING

nm-1wfx04f
Stoc epuizat

170,00Lei

FIR TEXTIL FAVORITE SMART PE4X 1.0/0.17 150M VERDE -15%

FIR TEXTIL FAVORITE SMART PE4X 1.0/0.17 150M VERDE

16931025
Stoc epuizat

85,00Lei(-15%) 72,24Lei

Fir Textil Falcon Powerful 0.16mm 100m 10.50kg

Fir Textil Falcon Powerful 0.16mm 100m 10.50kg

f2801
Stoc epuizat

40,00Lei

Fir Carp Expert Carbon 0.35mm 1000m

Fir Carp Expert Carbon 0.35mm 1000m

30100835
Stoc epuizat

55,00Lei

Fir Carp Expert Carbon 0.30mm 1000m

Fir Carp Expert Carbon 0.30mm 1000m

30100830
Stoc epuizat

45,01Lei

FIR JAXON CROCODILE GREEN 150m 0.18mm -23%

FIR JAXON CROCODILE GREEN 150m 0.18mm

zj-crg018a
Stoc epuizat

9,00Lei(-23%) 6,90Lei

FIR SAVAGE TEXTIL HD8 SILENCER 019MM/12.2KG/120M

FIR SAVAGE TEXTIL HD8 SILENCER 019MM/12.2KG/120M

a.sg.54810
Stoc epuizat

62,34Lei

Fir Textil Benzar Braided Method Hooklink 10M, 0.20mm, 16.81kg

Fir Textil Benzar Braided Method Hooklink 10M, 0.20mm, 16.81kg

30598020
Stoc epuizat

13,70Lei

FIR TEXTIL WFT STRONG GREEN 150M 0.25mm 39kg

FIR TEXTIL WFT STRONG GREEN 150M 0.25mm 39kg

30441125
Stoc epuizat

187,00Lei

Fir monofilament Carp Spirit Velocity Impact Abrasion Shock Leader Green 0.70mm/27.2kg/100m
Carlige DAM Sumo Spezi Sander Nickel Legate Nr.4 Fir 0.30mm

Carlige DAM Sumo Spezi Sander Nickel Legate Nr.4 Fir 0.30mm

709096849004
Stoc epuizat

12,25Lei

PB CHAMELEON 15LB 20M FIR MONTURI EXTREME SOFT

PB CHAMELEON 15LB 20M FIR MONTURI EXTREME SOFT

pb10100
Stoc epuizat

58,00Lei

FIR PROLOGIC VIPER ULTRASOFT CAMO SS 15LB/15M

FIR PROLOGIC VIPER ULTRASOFT CAMO SS 15LB/15M

a.pro.49999
Stoc epuizat

29,30Lei

FIR BERKLEY TEXTIL WHIPLASH 8 CRYSTAL 020MM/ KG/150M

FIR BERKLEY TEXTIL WHIPLASH 8 CRYSTAL 020MM/ KG/150M

p.1446624
Stoc epuizat

124,49Lei

FIR TEXTIL KAMASAKI SUPER BRAID 100M 0,14 MM

FIR TEXTIL KAMASAKI SUPER BRAID 100M 0,14 MM

30905014
Stoc epuizat

25,00Lei

LINGURA JAXON ALGA FIR 2C 16GR -30%

LINGURA JAXON ALGA FIR 2C 16GR

bw-jaf2c
Stoc epuizat

12,40Lei(-30%) 8,70Lei

FLUOROCARBON SUNLINE FC SNIPER 3LB 185MT -24%

FLUOROCARBON SUNLINE FC SNIPER 3LB 185MT

4968813419494
Stoc epuizat

60,00Lei(-24%) 45,90Lei

FIR MONOFILAMENT GAMAKATSU G-LINE ELEMENT DARK BROWN 028MM/6KG/1490M

FIR MONOFILAMENT GAMAKATSU G-LINE ELEMENT DARK BROWN 028MM/6KG/1490M

gk.5110.028
Stoc epuizat

63,93Lei

Fir ASSO Hard Skin Siliconed Green 0.30mm 300m

Fir ASSO Hard Skin Siliconed Green 0.30mm 300m

607080025
Stoc epuizat

48,46Lei

Afişare 9241 - 9260 din 10732 (537 pagini)
Queries: 8, Total time: 1,568.688 ms [By time] [By id] [By file]
1 (0.665)
SELECT data
FROM `oc_session`
WHERE session_id = '55a09e4726e22fc39f40166765'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1,487.829)
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 (pd.tag LIKE "%fir%") 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:724
4 (79.372)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 9240, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.223)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.126)
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
7 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ABREVIS"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.235)
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