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 monofilament Varivas Super Trout Advance VEP 6lb 91m

Fir monofilament Varivas Super Trout Advance VEP 6lb 91m

v26209106
Stoc epuizat

42,00Lei

FIR TEXTIL COLMIC WEPER X4 GREY 100lbs 150yds 137m 0.55mm

FIR TEXTIL COLMIC WEPER X4 GREY 100lbs 150yds 137m 0.55mm

nywex4299
Stoc epuizat

80,00Lei

Fir Textil Fox Submerge Dark Camo Sinking Braid 300m 0.16mm 11.3Kg -25%

Fir Textil Fox Submerge Dark Camo Sinking Braid 300m 0.16mm 11.3Kg

cbl008
Stoc epuizat

214,70Lei(-25%) 161,00Lei

Fir Fluorocarbon Carp Expert Shock Leader 0.30mm-0.55mm, 5x15m/75m

Fir Fluorocarbon Carp Expert Shock Leader 0.30mm-0.55mm, 5x15m/75m

30020530
Stoc epuizat

35,00Lei

SNUR MUSCA JAXON EASY CAST 90FT/27.43m 5 WF-SINKING

SNUR MUSCA JAXON EASY CAST 90FT/27.43m 5 WF-SINKING

nm-1wf05s
Stoc epuizat

116,00Lei

Fir Textil Spiderwire Dura 4 Galben 012MM/10.5KG/150M -31%

Fir Textil Spiderwire Dura 4 Galben 012MM/10.5KG/150M

1450405
Stoc epuizat

43,13Lei(-31%) 29,74Lei

FIR COLMIC SHADE COLMICE FLUOROCARBON 50M 0.16mm

FIR COLMIC SHADE COLMICE FLUOROCARBON 50M 0.16mm

nysh16
Stoc epuizat

55,00Lei

FIR JAXON TEXTIL PRO CARP SINKING MARO 25LB 10m

FIR JAXON TEXTIL PRO CARP SINKING MARO 25LB 10m

zj-pab25c
Stoc epuizat

15,51Lei

FIR CPK HEAVY LEADCORE 45 lb CAMO BROWN

FIR CPK HEAVY LEADCORE 45 lb CAMO BROWN

999967
Stoc epuizat

32,00Lei

FIR MONOFILAMENT MAVER SMART MRT 500M 0.30MM -50%

FIR MONOFILAMENT MAVER SMART MRT 500M 0.30MM

638030
Stoc epuizat

94,50Lei(-50%) 47,20Lei

FIR VARIVAS NEW HIGH GRADE PE 150M 21.4lb -20%

FIR VARIVAS NEW HIGH GRADE PE 150M 21.4lb

v2015015
Stoc epuizat

110,00Lei(-20%) 88,00Lei

FIR TEXTIL WFT GLISS MONOTEX VERDE 0.25MM / 150MT

FIR TEXTIL WFT GLISS MONOTEX VERDE 0.25MM / 150MT

30446025
Stoc epuizat

93,00Lei

FIR TEXTIL COLMIC WEPER X4 GREY 10lbs 100yds 91m 0.06mm

FIR TEXTIL COLMIC WEPER X4 GREY 10lbs 100yds 91m 0.06mm

nywex4110
Stoc epuizat

85,00Lei

Fir ASSO Ultra Cast Verde Fluo 0.20mm 150m

Fir ASSO Ultra Cast Verde Fluo 0.20mm 150m

603080005
Stoc epuizat

16,40Lei

Fir Erson Taifun 200m 0.35mm

Fir Erson Taifun 200m 0.35mm

30091035
Stoc epuizat

12,00Lei

FIR TEXTIL VARIVAS HIGH GRADE PE GALBEN FLUO 21.4LB 150MT

FIR TEXTIL VARIVAS HIGH GRADE PE GALBEN FLUO 21.4LB 150MT

v20215015
Stoc epuizat

110,00Lei

Fir Toray Bawo Upgrade Fluorocarbon 0.219mm 150m

Fir Toray Bawo Upgrade Fluorocarbon 0.219mm 150m

605210023
Stoc epuizat

86,47Lei

Fir Energo Team Excalibur Carp FLUO ORANGE 300M 0.25MM

Fir Energo Team Excalibur Carp FLUO ORANGE 300M 0.25MM

34060025
Stoc epuizat

16,01Lei

Fir Textil Wft 51kg Strong Chartreuse 0.32mm 300m -20%

Fir Textil Wft 51kg Strong Chartreuse 0.32mm 300m

30443032
Stoc epuizat

358,00Lei(-20%) 286,40Lei

FIR SOLUBIL CARP SPIRIT GROSIME XL DIZOLVARE MODERATA 20MT

FIR SOLUBIL CARP SPIRIT GROSIME XL DIZOLVARE MODERATA 20MT

151600361
Stoc epuizat

17,01Lei

Afişare 9301 - 9320 din 10732 (537 pagini)
Queries: 8, Total time: 1,477.159 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = 'bcae86d5b18c7950095a9f1360'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1,426.529)
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 (49.865)
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 9300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.117)
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.142)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CPK CARP & MORE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.145)
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
8 (0.130)
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