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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


MONTURA PROLOGIC SAFETLY CLIP SMC LEADER 80CM/45LBS

MONTURA PROLOGIC SAFETLY CLIP SMC LEADER 80CM/45LBS

a.pro.50151
Stoc epuizat

34,28Lei

Surub Savage Gear Screwin Weight Spike, 3.5g, 12buc/plic

Surub Savage Gear Screwin Weight Spike, 3.5g, 12buc/plic

a.sg.61954
Stoc epuizat

24,80Lei

CON PLUMB PIERDUT KORDA TAIL RUBER 10BUC/PL

CON PLUMB PIERDUT KORDA TAIL RUBER 10BUC/PL

a.krw
Stoc epuizat

25,51Lei

TUB PROLOGIC ANTI TANGLE MIMICRY 2M

TUB PROLOGIC ANTI TANGLE MIMICRY 2M

a.pro.54420
Stoc epuizat

19,80Lei

Montura Corkscrew Savage Gear Nr. 1/0/40 Cm

Montura Corkscrew Savage Gear Nr. 1/0/40 Cm

a.sg.57458
Stoc epuizat

44,36Lei

CARLIGE SPRO C-TEC LEGATE STOPPER VARTEJ WEEDY CARLIG NR8 2 BUC/PLIC

CARLIGE SPRO C-TEC LEGATE STOPPER VARTEJ WEEDY CARLIG NR8 2 BUC/PLIC

008620-00109-00000
Stoc epuizat

7,50Lei

Fir textil Kryston Super Nova Solid Bag Supple Gravel Brown 35lb 20m

Fir textil Kryston Super Nova Solid Bag Supple Gravel Brown 35lb 20m

krsu9
Stoc epuizat

48,00Lei

K-KARP CON CAUCIUC

K-KARP CON CAUCIUC

190-00-030
Stoc epuizat

8,87Lei

Agrafe Delphin A 01 BN NR.1/0

Agrafe Delphin A 01 BN NR.1/0

969a01100
Stoc epuizat

12,99Lei

CUTIE VARNIS MOSTIRO SILICON MULTICOLOR D 0.5 -1.2

CUTIE VARNIS MOSTIRO SILICON MULTICOLOR D 0.5 -1.2

4630
Stoc epuizat

3,61Lei

MONTURA KORDA SOLIDZ PVA NR 4 18LB

MONTURA KORDA SOLIDZ PVA NR 4 18LB

a.kcr104
Stoc epuizat

32,48Lei

STRATEGY POP UP WEIGHT L 9 PCS

STRATEGY POP UP WEIGHT L 9 PCS

008035-00409-00000
Stoc epuizat

41,00Lei

Montura Fluoro Rigid Nr.2 Carp Zoom -50%

Montura Fluoro Rigid Nr.2 Carp Zoom

cz1410
Stoc epuizat

15,01Lei(-50%) 7,50Lei

Fir Textil Prologic Viper 3S 30LBS/15M

Fir Textil Prologic Viper 3S 30LBS/15M

a.pro.50086
Stoc epuizat

39,40Lei

LEAD CORE MOSTIRO SAFETY SLEEVERUN RIG

LEAD CORE MOSTIRO SAFETY SLEEVERUN RIG

4227ms
Stoc epuizat

11,40Lei

MONTURA PROLOGIC 10CM/20LBS CU CARLIG XC7 NR.4 3BUC

MONTURA PROLOGIC 10CM/20LBS CU CARLIG XC7 NR.4 3BUC

a.pro.50131
Stoc epuizat

36,38Lei

FIR TEXTIL KRYSTON QUICKSILVER GRAVEL BROWN 25M 45LBS

FIR TEXTIL KRYSTON QUICKSILVER GRAVEL BROWN 25M 45LBS

krqs3
Stoc epuizat

56,00Lei

Tub Silicon DAM MAD Silicone Tube 0.5mm Green

Tub Silicon DAM MAD Silicone Tube 0.5mm Green

4030952115
Stoc epuizat

16,01Lei

KIT MONTURA FOX EDGES ZIG LEAD CLIP KIT 5X5BUC/BLISTER -30%

KIT MONTURA FOX EDGES ZIG LEAD CLIP KIT 5X5BUC/BLISTER

cac722
Stoc epuizat

31,27Lei(-30%) 22,00Lei

PB JELLY WIRE GRAVEL-NISIP 35LB 20M FIR FORFAC CU CAMASA

PB JELLY WIRE GRAVEL-NISIP 35LB 20M FIR FORFAC CU CAMASA

pb10004
Stoc epuizat

70,00Lei

Afişare 4121 - 4140 din 4601 (231 pagini)
Queries: 7, Total time: 103.551 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = 'dbeab9a3d8185fe7a94af36b86'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.126)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (102.902)
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('+monturi' 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
5 (0.121)
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.100)
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.090)
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