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 Kenart Hunter Floating Clean, Bullhead Fluo, 2.5g, 3cm

Vobler Kenart Hunter Floating Clean, Bullhead Fluo, 2.5g, 3cm

hu3f-hx
Stoc epuizat

21,50Lei

Wafters Fish Pro Solubile Fluo, Somon Branza, 8mm, 40g

Wafters Fish Pro Solubile Fluo, Somon Branza, 8mm, 40g

FHP-WSFSB8-40
Stoc epuizat

29,00Lei

Fir Jaxon Crocodile Marine Verde Fluo, 300m, 0.50mm, 40kg

Fir Jaxon Crocodile Marine Verde Fluo, 300m, 0.50mm, 40kg

zj-crm050b
Stoc epuizat

37,00Lei

MARKER CARP SPIRIT LUMINOS FLUO PORTOCALIU

MARKER CARP SPIRIT LUMINOS FLUO PORTOCALIU

acs010057
Stoc epuizat

51,00Lei

FIR COLMIC HOLO SURF FLUO 0.16MM 300M -30%

FIR COLMIC HOLO SURF FLUO 0.16MM 300M

nyho16
Stoc epuizat

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

Dip Fluo MG Special Carp Miere

Dip Fluo MG Special Carp Miere

mg8779
Stoc epuizat

17,00Lei

FIR TEXTIL WFT GLISS MONOTEX GALBEN FLUO 0.18MM / 150MT

FIR TEXTIL WFT GLISS MONOTEX GALBEN FLUO 0.18MM / 150MT

30447018
Stoc epuizat

85,00Lei

Fir Monofilament Carp Expert UV Fluo 0,20mm/300m/5.40kg

Fir Monofilament Carp Expert UV Fluo 0,20mm/300m/5.40kg

30120020
Stoc epuizat

20,00Lei

FIR COLMIC IRIDE PT50 300M 0.20mm Orange Fluo

FIR COLMIC IRIDE PT50 300M 0.20mm Orange Fluo

nyir020
Stoc epuizat

38,00Lei

FIR JAXON TEXTIL MONOLITH EXCELLENCE FLUO 125m 0.10mm

FIR JAXON TEXTIL MONOLITH EXCELLENCE FLUO 125m 0.10mm

zj-gef010g
Stoc epuizat

175,00Lei

Fir Monofilament Carp Expert UV Fluo 1000m, 0.40mm, 18.70kg

Fir Monofilament Carp Expert UV Fluo 1000m, 0.40mm, 18.70kg

30120840
Stoc epuizat

69,00Lei

FIR JAXON CARAT MARINE 250m 0,40mm Galben Fluo

FIR JAXON CARAT MARINE 250m 0,40mm Galben Fluo

zj-kam040b
Stoc epuizat

36,00Lei

FIR TEXTIL JAXON COMBAT XTY GALBEN FLUO 100m 0.10mm -40%

FIR TEXTIL JAXON COMBAT XTY GALBEN FLUO 100m 0.10mm

zj-mxty010a
Stoc epuizat

114,00Lei(-40%) 68,40Lei

FIR JAXON CARAT MARINE 250m 0,50mm 40.00 kg Galben Fluo

FIR JAXON CARAT MARINE 250m 0,50mm 40.00 kg Galben Fluo

zj-kam050b
Stoc epuizat

46,01Lei

FIR COLMIC IRIDE PT50 300M 0.30mm Orange Fluo

FIR COLMIC IRIDE PT50 300M 0.30mm Orange Fluo

nyir030
Stoc epuizat

49,00Lei

FIR JAXON TEXTIL MONOLITH EXCELLENCE FLUO 125m 0.16mm

FIR JAXON TEXTIL MONOLITH EXCELLENCE FLUO 125m 0.16mm

zj-gef016g
Stoc epuizat

152,00Lei

FIR JAXON TEXTIL MONOLITH EXCELLENCE FLUO 125m 0.12mm

FIR JAXON TEXTIL MONOLITH EXCELLENCE FLUO 125m 0.12mm

zj-gef012g
Stoc epuizat

175,00Lei

WAFTERS FC CARP ZOOM METHOD FEEDER NBC 9mm 13gr Fluo Orange -32%

WAFTERS FC CARP ZOOM METHOD FEEDER NBC 9mm 13gr Fluo Orange

cz8746
Stoc epuizat

14,50Lei(-32%) 9,90Lei

FIR TEXTIL JAXON CONCEPT LINE GALBEN FLUO 100m 0.10mm -30%

FIR TEXTIL JAXON CONCEPT LINE GALBEN FLUO 100m 0.10mm

zj-ncy010a
Stoc epuizat

90,00Lei(-30%) 63,00Lei

FIR MONOFILAMENT MAVER ELITE NO GRAVITY FLUO 300M 0.240MM -50%

FIR MONOFILAMENT MAVER ELITE NO GRAVITY FLUO 300M 0.240MM

727240
Stoc epuizat

67,50Lei(-50%) 33,70Lei

Afişare 961 - 980 din 1272 (64 pagini)
Queries: 8, Total time: 39.738 ms [By time] [By id] [By file]
1 (0.151)
SELECT data
FROM `oc_session`
WHERE session_id = 'ae7890c3e0bc2809230e5b0c4e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (38.868)
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('+fluo' 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:725
4 (0.145)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.121)
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.122)
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
7 (0.125)
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
8 (0.117)
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