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 ENERGOTEAM EXCALIBUR CARP CAMOU 300m 0.35mm

FIR ENERGOTEAM EXCALIBUR CARP CAMOU 300m 0.35mm

34050035
Livrare imediată!

20,00Lei

FIR MONOFILAMENT MAVER SMART EVY 150M 0.228MM -30%
Exclusiv online!

FIR MONOFILAMENT MAVER SMART EVY 150M 0.228MM

656022
Livrare 48-72 ore

21,00Lei(-30%) 14,70Lei

Fir P-LINE FLOROCLEAR 2000 M 0.30 MM CLEAR

Fir P-LINE FLOROCLEAR 2000 M 0.30 MM CLEAR

750187730
Livrare imediată!

106,01Lei

Monofilament Nevis Espirit 600m 0.30mm
Exclusiv online!

Monofilament Nevis Espirit 600m 0.30mm

3207-630
Livrare 48-72 ore

49,00Lei

Fir monofilament Varivas Super Tippet Master Spec Nylon 3X 0.205mm 50m 7.6lb
Exclusiv online!

Fir monofilament Varivas Super Tippet Master Spec Nylon 3X 0.205mm 50m 7.6lb

v3603x
Livrare 48-72 ore

55,00Lei

Monofilament Nevis Navy Carp 300m 0,22mm

Monofilament Nevis Navy Carp 300m 0,22mm

3209-322
Livrare imediată!

22,00Lei

Fir Sakura Sensibraid 8X 0.18mm 150m Chartreuse
Exclusiv online!

Fir Sakura Sensibraid 8X 0.18mm 150m Chartreuse

110634saple40030.18-cha
Livrare 48-72 ore

105,62Lei

Fir Delphin FIN Strong CARP 600m Galben Fluo 0.30mm

Fir Delphin FIN Strong CARP 600m Galben Fluo 0.30mm

500604330
Livrare imediată!

52,00Lei

Monofilament Nevis Red Carp Feeder 150m 0.20mm

Monofilament Nevis Red Carp Feeder 150m 0.20mm

3231-020
Livrare imediată!

17,01Lei

Fir Asso Trout Area Fluorocarbon White 0.093mm 100m -28%

Fir Asso Trout Area Fluorocarbon White 0.093mm 100m

111108301
Livrare imediată!

52,62Lei(-28%) 37,90Lei

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.139MM
Exclusiv online!

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.139MM

725139
Livrare 48-72 ore

28,00Lei

FIR CARP EXPERT MULTICOLOR 0.40MM 300M
Exclusiv online!

FIR CARP EXPERT MULTICOLOR 0.40MM 300M

30125040
Livrare 24-48 ore

28,00Lei

Monofilament Nevis Espirit 150m 0.18mm

Monofilament Nevis Espirit 150m 0.18mm

3207-018
Livrare imediată!

12,00Lei

Fir Monofilament Mivardi Ultra Sinking Feeder, Dark, 150m 0.185mm 3.95kg
Exclusiv online!

Fir Monofilament Mivardi Ultra Sinking Feeder, Dark, 150m 0.185mm 3.95kg

miv-lusf1518
Livrare 48-72 ore

29,99Lei

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

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

8581-10250-018
Livrare imediată!

27,00Lei

Fir Monofilament Rameau Competition Transparent 100m 0.084mm
Exclusiv online!

Fir Monofilament Rameau Competition Transparent 100m 0.084mm

ara470001
Livrare 48-72ore

45,01Lei

Fir Monofilament Carp Expert Method Feeder Roz 200m 0.30mm 12.75kg
Exclusiv online!

Fir Monofilament Carp Expert Method Feeder Roz 200m 0.30mm 12.75kg

30127530
Livrare 24-48 ore

18,00Lei

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

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

a.pro.64112
Livrare 24-48 ore

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

Monofilament Nevis Endura 600m 0.30mm

Monofilament Nevis Endura 600m 0.30mm

3212-630
Livrare imediată!

39,00Lei

FIR MONOFILAMENT MAVER DYNASTY GREEN 150m 0.24mm
Exclusiv online!

FIR MONOFILAMENT MAVER DYNASTY GREEN 150m 0.24mm

605024
Livrare 48-72 ore

25,00Lei

Afişare 2681 - 2700 din 4620 (231 pagini)
Queries: 6, Total time: 117.764 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '46f641f43edee0995aa5e32697'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.063)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (100.508)
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('+monofilament' 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 (16.815)
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 2680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.140)
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