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


LANSETA JAXON GREY STREAM SPIN 2.40 10-40GR -19%

LANSETA JAXON GREY STREAM SPIN 2.40 10-40GR

wj-dsf24040
Livrare imediată!

245,00Lei(-19%) 199,00Lei

Struna DAM Effzett M 30cm No.6 16Kg Coated Core7 Spin Leader 2 buc

Struna DAM Effzett M 30cm No.6 16Kg Coated Core7 Spin Leader 2 buc

40956415
Livrare imediată!

7,01Lei

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Chartreuse Impact
Exclusiv online!

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Chartreuse Impact

arhkcle34
Livrare 48-72 ore

10,00Lei

Struna DAM Effzett XS 30cm Nr10 7Kg Coated Core7 Spin Leader 2 buc

Struna DAM Effzett XS 30cm Nr10 7Kg Coated Core7 Spin Leader 2 buc

40956413
Livrare imediată!

7,01Lei

Lanseta Sportex CATFIRE SPIN 270 70-190gr
Exclusiv online!

Lanseta Sportex CATFIRE SPIN 270 70-190gr

cf2714
Livrare 48-72 ore

830,00Lei

Struna DAM Effzett M 55cm Nr.6 21Kg Mono Spin Leader 2 buc/plic

Struna DAM Effzett M 55cm Nr.6 21Kg Mono Spin Leader 2 buc/plic

a7.dam.56444
Livrare imediată!

8,57Lei

Struna DAM Effzett L 55cm Nr.4 24Kg Mono Spin Leader 2 buc
Exclusiv online!

Struna DAM Effzett L 55cm Nr.4 24Kg Mono Spin Leader 2 buc

40956445
Livrare 48-72 ore

7,01Lei

MULINETA ENERGOTEAM BOKOR SPIN JF 2000
Exclusiv online!

MULINETA ENERGOTEAM BOKOR SPIN JF 2000

20601200
Livrare 24-48 ore

234,00Lei

Lanseta Sportex REVOLT SPIN HEPTACORE 270 60gr
Exclusiv online!

Lanseta Sportex REVOLT SPIN HEPTACORE 270 60gr

rs2703
Livrare 48-72 ore

2.320,00Lei

LANSETA JAXON GREY STREAM ULTRA SPIN 1.98M 2 12G

LANSETA JAXON GREY STREAM ULTRA SPIN 1.98M 2 12G

wj-dsb19812
Livrare imediată!

215,00Lei

MONTURA CARP ZOOM METHOD FC-545 NR12 SPIN 10mm 8cm 0.14mm

MONTURA CARP ZOOM METHOD FC-545 NR12 SPIN 10mm 8cm 0.14mm

cz6735
Livrare imediată!

12,00Lei

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Rainbow
Exclusiv online!

LINGURITA ROTATIVA COLMIC CLEVER SPIN 1.5gr Rainbow

arhkcle31
Livrare 48-72 ore

10,00Lei

LANSETA CORMORAN SPINNING 2BUC.BLACK MASTER SPIN 2,70M /35-80G
Exclusiv online!

LANSETA CORMORAN SPINNING 2BUC.BLACK MASTER SPIN 2,70M /35-80G

c.27.2125270
Livrare 24-48 ore

233,97Lei

Lanseta Cormoran Black Master Spin, 2.70m, 35-80g, 2seg -23%

Lanseta Cormoran Black Master Spin, 2.70m, 35-80g, 2seg

c.27.2080270
Livrare imediată!

261,32Lei(-23%) 201,90Lei

Lanseta Black Cat Perfect Passion Boat Spin 2.40m 190gr

Lanseta Black Cat Perfect Passion Boat Spin 2.40m 190gr

16581240
Livrare imediată!

351,09Lei

Lanseta EnergoTeam Kamasaki Elite Spin 1.80m 5-20g 2buc
Exclusiv online!

Lanseta EnergoTeam Kamasaki Elite Spin 1.80m 5-20g 2buc

13189180
Livrare 48-72ore

92,00Lei

LINGURA JAXON HR PRO SPIN DOUBLE HMX 2E 30GR
Exclusiv online!

LINGURA JAXON HR PRO SPIN DOUBLE HMX 2E 30GR

bw-hmx2e
Livrare 48-72 ore

12,99Lei

LINGURA JAXON HR PRO SPIN HHX 2A 22GR
Exclusiv online!

LINGURA JAXON HR PRO SPIN HHX 2A 22GR

bw-hhx2a
Livrare 48-72 ore

6,50Lei

Lanseta Sakura Shukan Spin SHUS 802 M 2.44m 7-28gr EGI
Exclusiv online!

Lanseta Sakura Shukan Spin SHUS 802 M 2.44m 7-28gr EGI

20434saprj803280-2m-egi
Livrare 48-72 ore

688,47Lei

LINGURA JAXON HR PRO SPIN HCX 2C 15GR
Exclusiv online!

LINGURA JAXON HR PRO SPIN HCX 2C 15GR

bw-hcx2c
Livrare 48-72 ore

7,70Lei

Afişare 741 - 760 din 1805 (91 pagini)
Queries: 6, Total time: 58.311 ms [By time] [By id] [By file]
1 (0.066)
SELECT data
FROM `oc_session`
WHERE session_id = 'd930b109ae86de47e532d4288c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.142)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (50.207)
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('+spin' 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 (7.614)
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 740, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.143)
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.139)
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