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 300 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


CARLIGE, LEGATE, TRABUCCO, AKURA, PENTRU, BIBAN, SI, SALAU, Nr06x0.25mm, 10BUC/PLIC, 027-15-060, Carlige Legate Stationar, Carlige Legate Stationar Trabucco, Trabucco
Fir Monofilament Jaxon INTENSA MATCH 0.25mm 150m

Fir Monofilament Jaxon INTENSA MATCH 0.25mm 150m

zj-inm025a
Livrare imediată!

22,00Lei

FIR, TRABUCCO, TOURNAMENT, S/ISO, 500M, 0.255MM, 8.36, Kg, 052-53-250, Fire Monofilament Crap, Fire Monofilament Crap Trabucco, Trabucco
Pop Up Mainline Critic Echilibrat High Impact Balanced Wafters Ananas 15mm 60buc/borcan
Exclusiv online!

Pop Up Mainline Critic Echilibrat High Impact Balanced Wafters Ananas 15mm 60buc/borcan

a0.m.m23070
Livrare 24-48 ore

51,72Lei

ADAPTOR INNOMOUNT AIMPOINT MICRO H 5MM -36%
Exclusiv online!

ADAPTOR INNOMOUNT AIMPOINT MICRO H 5MM

vim.24am.05
Livrare 24-48 ore

197,50Lei(-36%) 127,34Lei

Fir, Monofilament, Jaxon, INTENSA, CRAP, 0.35mm, 600m, zj-inc035d, Fire Monofilament Crap, Fire Monofilament Crap Jaxon, Jaxon
Fir Fluorocarbon Lineaeffe Nobu HFC Super Soft Transparent 50M 0.185mm 3.60kg -30%
Exclusiv online!

Fir Fluorocarbon Lineaeffe Nobu HFC Super Soft Transparent 50M 0.185mm 3.60kg

l.3043118
Livrare 24-48 ore

46,67Lei(-30%) 32,67Lei

KIT PLASA SOLUBILA 25mm SENZOR PVA SYSTEM + TIJA COMPRESIE, 5m

KIT PLASA SOLUBILA 25mm SENZOR PVA SYSTEM + TIJA COMPRESIE, 5m

snz99552
Livrare imediată!

32,00Lei

Fir ASSO Light Games PE 8x 0185mm 150m Fluo Chartreuse -27%

Fir ASSO Light Games PE 8x 0185mm 150m Fluo Chartreuse

1106080185
Livrare imediată!

93,11Lei(-27%) 67,90Lei

FIR TEXTIL SUFIX RAPINOVA X8 LEMON GREEN 150M 0.205MM

FIR TEXTIL SUFIX RAPINOVA X8 LEMON GREEN 150M 0.205MM

asu640284
Livrare imediată!

169,00Lei

Fir ASSO Light Games PE 8x 0165mm 150m Fluo Chartreuse -27%

Fir ASSO Light Games PE 8x 0165mm 150m Fluo Chartreuse

1106080165
Livrare imediată!

93,11Lei(-27%) 67,90Lei

APICALE JAXON VERGI STONFO ELIT 0.65MM 5BUC/SET
Exclusiv online!

APICALE JAXON VERGI STONFO ELIT 0.65MM 5BUC/SET

as-232065
Livrare 48-72 ore

56,00Lei

Fir Asso Tapered Shock Leader Clear 016-0.45mm 15m

Fir Asso Tapered Shock Leader Clear 016-0.45mm 15m

602080019
Livrare imediată!

35,05Lei

MULINETA, RAPTURE, GUIDE, MASTER, XLT, 75MM, 3, 4, 032-96-030, Mulinete Musca, Mulinete Musca Rapture, Rapture
MULINETA, RAPTURE, GUIDE, MASTER, XLT, 95MM, 7, 8, 032-96-060, Mulinete Musca, Mulinete Musca Rapture, Rapture
Exclusiv online!

MULINETA, RAPTURE, GUIDE, MASTER, XLT, 95MM, 7, 8, 032-96-060, Mulinete Musca, Mulinete Musca Rapture, Rapture

032-96-060
Livrare 48-72 ore

489,99Lei

KIT PLASA SOLUBILA 35mm SENZOR PVA SYSTEM + TIJA COMPRESIE, 5m

KIT PLASA SOLUBILA 35mm SENZOR PVA SYSTEM + TIJA COMPRESIE, 5m

snz99550
Livrare imediată!

34,00Lei

MULINETA, RAPTURE, GUIDE, MASTER, XLT, 85MM, 5, 6, 032-96-050, Mulinete Musca, Mulinete Musca Rapture, Rapture
Exclusiv online!

MULINETA, RAPTURE, GUIDE, MASTER, XLT, 85MM, 5, 6, 032-96-050, Mulinete Musca, Mulinete Musca Rapture, Rapture

032-96-050
Livrare 48-72 ore

440,00Lei

Fir Monofilament Jaxon INTENSA CRAP 0.25mm 600m

Fir Monofilament Jaxon INTENSA CRAP 0.25mm 600m

zj-inc025d
Livrare imediată!

57,00Lei

MULINETA Rapture LMF FLY REEL CLK (FLP) 80mm 3/4 25mm
Exclusiv online!

MULINETA Rapture LMF FLY REEL CLK (FLP) 80mm 3/4 25mm

032-98-030
Livrare 48-72 ore

410,00Lei

Fir Asso Mainline Master Green 0.35mm 1000m
Exclusiv online!

Fir Asso Mainline Master Green 0.35mm 1000m

110108fnasdi274bm10006e0350
Livrare 48-72 ore

67,10Lei

Afişare 61 - 80 din 3145 (158 pagini)
Queries: 4, Total time: 313.363 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = '4d5e7c114ace656b3f33a591f4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.143)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (312.988)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%5mm%") 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:698
4 (0.129)
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