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 PROLOGIC VIPER ULTRASOFT CAMO SS 35LB/15M

FIR PROLOGIC VIPER ULTRASOFT CAMO SS 35LB/15M

a.pro.50083
Stoc epuizat

32,40Lei

Vobler Lucky John Pro Series Haira Tiny Shallow 33F 3.3cm 4gr 503 1 buc/pac

Vobler Lucky John Pro Series Haira Tiny Shallow 33F 3.3cm 4gr 503 1 buc/pac

lj-hat33f-503
Stoc epuizat

37,00Lei

Montura Prologic Leader Mirage Loop Vertej cu Inel 1M/35LBS 2BUC/PL

Montura Prologic Leader Mirage Loop Vertej cu Inel 1M/35LBS 2BUC/PL

a.pro.54423
Stoc epuizat

14,29Lei

HANGER NITE LITE PRO VERDE PT AVERTIZORI DELKIM

HANGER NITE LITE PRO VERDE PT AVERTIZORI DELKIM

a.de.dp048
Stoc epuizat

181,70Lei

VARF CORMORAN PT.FEEDER PRO RED 3,05OZ Model 3

VARF CORMORAN PT.FEEDER PRO RED 3,05OZ Model 3

c.25.2180420r
Stoc epuizat

42,52Lei

CROSETA PROLOGIC 0.72MM

CROSETA PROLOGIC 0.72MM

a.pro.54400
Stoc epuizat

24,50Lei

HUSA PROLOGIC CRUZADE PENTRU O LANSETA 3.90M

HUSA PROLOGIC CRUZADE PENTRU O LANSETA 3.90M

a8.pro.54437
Stoc epuizat

147,30Lei

FIR PROLOGIC REPTILIAN COATED MARO SS 25LBS/15M -40%

FIR PROLOGIC REPTILIAN COATED MARO SS 25LBS/15M

a.pro.50093
Stoc epuizat

68,21Lei(-40%) 40,92Lei

JACHETA PROLOGIC BANK BOUND 3 CAMO MARIMEA L -20%

JACHETA PROLOGIC BANK BOUND 3 CAMO MARIMEA L

a8.pro.55260
Stoc epuizat

311,52Lei(-20%) 249,23Lei

Set Avertizoare Prologic Electronici SMX MKII Bite Blue + Statie

Set Avertizoare Prologic Electronici SMX MKII Bite Blue + Statie

a.pro.72660
Stoc epuizat

881,08Lei

FIR MONOFILAMENT PROLOGIC XLNT HP CAMO 035MM/8,1KG/1000M

FIR MONOFILAMENT PROLOGIC XLNT HP CAMO 035MM/8,1KG/1000M

a.pro.44694
Stoc epuizat

81,38Lei

ROD-POD PROLOGIC TRI-LUX ALUMINIU 3PST.

ROD-POD PROLOGIC TRI-LUX ALUMINIU 3PST.

a6.pro.54355
Stoc epuizat

878,53Lei

MARKER JAXON PRO CARP MODEL2

MARKER JAXON PRO CARP MODEL2

ac-pc049
Stoc epuizat

11,00Lei

CICADA STRIKE PRO 6.5CM/26G CYBER VIBE 781 -20%

CICADA STRIKE PRO 6.5CM/26G CYBER VIBE 781

sp.jg005e.781
Stoc epuizat

32,19Lei(-20%) 25,75Lei

FIR PROLOGIC SUPER SNAKE FS VERDE 25LB/15M

FIR PROLOGIC SUPER SNAKE FS VERDE 25LB/15M

a.pro.50089
Stoc epuizat

33,62Lei

VARF CORMORAN PT.FEEDER PRO GREEN 2,05OZ Model 2

VARF CORMORAN PT.FEEDER PRO GREEN 2,05OZ Model 2

c.25.2180390g
Stoc epuizat

51,31Lei

FIR PROLOGIC MIMICRY WATHER GHOST 038MM/11,3KG/1000M

FIR PROLOGIC MIMICRY WATHER GHOST 038MM/11,3KG/1000M

a.pro.48446
Stoc epuizat

165,76Lei

FIR PROLOGIC VIPER ULTRASOFT CAMO SS 25LB/15M

FIR PROLOGIC VIPER ULTRASOFT CAMO SS 25LB/15M

a.pro.50000
Stoc epuizat

31,30Lei

MINCIOG PROLOGIC CH42 1.80M

MINCIOG PROLOGIC CH42 1.80M

a2.pro.57126
Stoc epuizat

282,95Lei

FIR JAXON XT-PRO PREMIUM 25m 0.14mm -29%

FIR JAXON XT-PRO PREMIUM 25m 0.14mm

zj-xtp014c
Stoc epuizat

4,50Lei(-29%) 3,20Lei

Afişare 3441 - 3460 din 3916 (196 pagini)
Queries: 5, Total time: 106.513 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '3067824499ec4906d182695c47'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (106.052)
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 (MATCH(pd.tag) AGAINST('+pro' 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.132)
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.123)
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