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


CICADA STRIKE PRO 6.5CM/26G CYBER VIBE 022PE

CICADA STRIKE PRO 6.5CM/26G CYBER VIBE 022PE

sp.jg005e.022pe
Stoc epuizat

32,19Lei

TUB PRO CARP TUNGSTEN JAXON MAROU 1M -30%

TUB PRO CARP TUNGSTEN JAXON MAROU 1M

ac-pc037c
Stoc epuizat

18,40Lei(-30%) 12,90Lei

OCHELARI POLARIZANTI PROLOGIC MAX4 AMBER

OCHELARI POLARIZANTI PROLOGIC MAX4 AMBER

a8.pro.42523
Stoc epuizat

126,79Lei

LANSETA TRABUCCO SYGNUM XS PRO ENERGY 4.50M

LANSETA TRABUCCO SYGNUM XS PRO ENERGY 4.50M

157-72-450
Stoc epuizat

650,00Lei

GEACA MAVER POLAR NEW PRO XXL -30%

GEACA MAVER POLAR NEW PRO XXL

n923
Stoc epuizat

311,99Lei(-30%) 218,00Lei

KIT PROLOGIC SNZ CHUBBY HANG INDICATOR 4 BUC.

KIT PROLOGIC SNZ CHUBBY HANG INDICATOR 4 BUC.

a.pro.54398
Stoc epuizat

209,74Lei

GEANTA MATRIX ETHOS PRO CARRYALL MEDIUM 55L -47%

GEANTA MATRIX ETHOS PRO CARRYALL MEDIUM 55L

glu075
Stoc epuizat

326,48Lei(-47%) 172,26Lei

VOBLER STRIKE PRO 3.5CM/2.2G ARCHBACK -20%

VOBLER STRIKE PRO 3.5CM/2.2G ARCHBACK

sp.eg125e.500g
Stoc epuizat

32,06Lei(-20%) 25,64Lei

FIR TEXTIL TRABUCCO DYNA-TEX X8 PRO EXTREME 150M 0.153MM 20LBS

FIR TEXTIL TRABUCCO DYNA-TEX X8 PRO EXTREME 150M 0.153MM 20LBS

054-26-150
Stoc epuizat

75,01Lei

MULINETA JAXON PRO SURF 700 6RUL

MULINETA JAXON PRO SURF 700 6RUL

kj-sur700
Stoc epuizat

369,99Lei

FIR TEXTIL SUFIX MATRIX PRO 135M 0.60MM 200LB 90.0KG MID.GREEN -26%

FIR TEXTIL SUFIX MATRIX PRO 135M 0.60MM 200LB 90.0KG MID.GREEN

ds1wt15011tb1p
Stoc epuizat

129,00Lei(-26%) 95,90Lei

OCHELARI POLARIZANTI DAIWA PRO LENTILA AMBER

OCHELARI POLARIZANTI DAIWA PRO LENTILA AMBER

d.dpropsg4
Stoc epuizat

169,08Lei

Vobler Lucky John Pro Series Haira Tiny Plus One 33LBF 3.3cm 4gr 202 1 buc/pac

Vobler Lucky John Pro Series Haira Tiny Plus One 33LBF 3.3cm 4gr 202 1 buc/pac

lj-hat33lbf-202
Stoc epuizat

37,00Lei

Preston Offbox 36 Pro Feeder Arm

Preston Offbox 36 Pro Feeder Arm

obp/96
Stoc epuizat

292,45Lei

VARF CORMORAN PT.FEEDER PRO YELLOW 1,05OZ Model 3

VARF CORMORAN PT.FEEDER PRO YELLOW 1,05OZ Model 3

c.25.2180420y
Stoc epuizat

21,11Lei

FIR PROLOGIC VIPER 3S 20LBS/15M

FIR PROLOGIC VIPER 3S 20LBS/15M

a.pro.50085
Stoc epuizat

32,90Lei

Varf Feeder Maver Genesis Pro XD 3.90m/130g 3sec 4 oz

Varf Feeder Maver Genesis Pro XD 3.90m/130g 3sec 4 oz

a2544
Stoc epuizat

67,00Lei

TUB PRO CARP TUNGSTEN JAXON GRI 1M -30%

TUB PRO CARP TUNGSTEN JAXON GRI 1M

ac-pc037a
Stoc epuizat

18,40Lei(-30%) 12,90Lei

CLESTE SAVAGE MP PRO MULTIFUNCTIONAL -23%

CLESTE SAVAGE MP PRO MULTIFUNCTIONAL

a.sg.54937
Stoc epuizat

115,11Lei(-23%) 88,90Lei

LEAD CORE JAXON PRO CARP MARO 30LBS 5m

LEAD CORE JAXON PRO CARP MARO 30LBS 5m

zj-pdb30d
Stoc epuizat

25,00Lei

Afişare 3241 - 3260 din 3904 (196 pagini)
Queries: 9, Total time: 120.825 ms [By time] [By id] [By file]
1 (0.167)
SELECT data
FROM `oc_session`
WHERE session_id = '09bd3ac2c18345ed43647b8303'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (104.738)
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('+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 (15.190)
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 3240, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.153)
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 INDISPONIBIL 2 (IULIA)"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.121)
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
8 (0.129)
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
9 (0.121)
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