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

Produse ce potrivesc criteriilor de căutare


Fir Cormoran Textil CoraStrong 8Braid, Green, 018MM/13,2KG/135M

Fir Cormoran Textil CoraStrong 8Braid, Green, 018MM/13,2KG/135M

c.32.8013518
Livrare imediată!

35,14Lei

CARLIGE GAMAKATSU A1 G-CARP GREEN SPECIAL 10BUC/PLIC nr 6

CARLIGE GAMAKATSU A1 G-CARP GREEN SPECIAL 10BUC/PLIC nr 6

149085-00600-00000
Livrare imediată!

35,20Lei

, WAFTERS, CARP, ZOOM, FC, METHOD, FEEDER, NBC, 11mm, 13gr, Fluo, Green, cz8784, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Carp Zoom, Carp Zoom
Fir Monofilament Carp Spirit Riga Mortis Lo-Vis Green Chod Hooklink 20m, 25lbs, 11.30kg -23%
Exclusiv online!

Fir Monofilament Carp Spirit Riga Mortis Lo-Vis Green Chod Hooklink 20m, 25lbs, 11.30kg

acs640055
Livrare 48-72ore

39,00Lei(-23%) 29,90Lei

FIR TEXTIL CU CAMASA CARP SPIRIT COMBI SOFT 35LB 20MT CAMO GREEN

FIR TEXTIL CU CAMASA CARP SPIRIT COMBI SOFT 35LB 20MT CAMO GREEN

acs640083
Livrare imediată!

69,00Lei

NADA JAXON METHOD FEEDER GREEN MARZIPAN 750gr

NADA JAXON METHOD FEEDER GREEN MARZIPAN 750gr

fm-zr12
Livrare imediată!

25,00Lei

Racheta de Nadire Tip Spomb Mostiro 4451 Green, Marime S -20%

Racheta de Nadire Tip Spomb Mostiro 4451 Green, Marime S

nn-4451
Livrare imediată!

15,80Lei(-20%) 12,64Lei

Fir Textil Momoi Ryujin PE Braided, Moss Green, 30kg, 0.33mm, 300m

Fir Textil Momoi Ryujin PE Braided, Moss Green, 30kg, 0.33mm, 300m

ryu033mg
Livrare imediată!

178,00Lei

FIR, TEXTIL, CPK, XTRA, SUPPLE, HOOKLINK, SINKING,, Green/Black,, 15lb, 999872, Fire Monturi Crap, Fire Monturi Crap CPK, CPK
Bluza Fox Chunk Crew Pouch Sweatshirt Green Marl Marime M -30%

Bluza Fox Chunk Crew Pouch Sweatshirt Green Marl Marime M

cpr676
Livrare imediată!

203,16Lei(-30%) 141,38Lei

Manson Protectie Agrafa / Vartej Korda Tapered Silicon Sleeves, 10buc/plic, Weedy Green

Manson Protectie Agrafa / Vartej Korda Tapered Silicon Sleeves, 10buc/plic, Weedy Green

a.ktssg
Livrare imediată!

23,19Lei

Racheta de Nadire Tip Spomb Mostiro 4445 Green, Marime S
Exclusiv online!

Racheta de Nadire Tip Spomb Mostiro 4445 Green, Marime S

4445
Livrare 48-72 ore

14,70Lei

FIR TEXTIL CARP SPIRIT BALLISTIC BRAIDED LEADER 45LB 20.4KG 20MT CAMO GREEN

FIR TEXTIL CARP SPIRIT BALLISTIC BRAIDED LEADER 45LB 20.4KG 20MT CAMO GREEN

acs640035
Livrare imediată!

59,00Lei

Shad 4Predators Slim Shad Floating 9 CM L020 Culoare Ultra Green – Orange Gold 5 buc/plic

Shad 4Predators Slim Shad Floating 9 CM L020 Culoare Ultra Green – Orange Gold 5 buc/plic

4p-ss9-l020
Livrare imediată!

10,00Lei

Fir Textil Momoi Ryujin PE Braided, Moss Green, 55kg, 0.49mm, 300m
Exclusiv online!

Fir Textil Momoi Ryujin PE Braided, Moss Green, 55kg, 0.49mm, 300m

ryu049mg
Livrare 48-72 ore

199,00Lei

FIR, TEXTIL, CU, CAMASA, CARP, SPIRIT, COMBI-SOFT, 20LB, 9.1KG, 20MT, CAMO, GREEN, acs640081, Fire Monturi Crap, Fire Monturi Crap Carp Spirit, Carp Spirit
Lanseta Maver BOLOGNEZA SUPERLITIUM EVO GREEN POWER MX 8M Inele Fuji Torzite
Exclusiv online!

Lanseta Maver BOLOGNEZA SUPERLITIUM EVO GREEN POWER MX 8M Inele Fuji Torzite

5744800
Livrare 48-72 ore

3.200,01Lei

Fir Monofilament Benzar Method Feeder Mono Dark Green Verde Inchis 600m 0.20mm

Fir Monofilament Benzar Method Feeder Mono Dark Green Verde Inchis 600m 0.20mm

30606020
Livrare imediată!

30,00Lei

FIR TEXTIL CARP SPIRIT BALLISTIC BRAIDED LEADER 35LB 15.9KG 20MT CAMO GREEN

FIR TEXTIL CARP SPIRIT BALLISTIC BRAIDED LEADER 35LB 15.9KG 20MT CAMO GREEN

acs640034
Livrare imediată!

59,00Lei

Fir Textil Momoi Ryujin PE Braided, Lime Green, 9kg, 0.10mm, 130m

Fir Textil Momoi Ryujin PE Braided, Lime Green, 9kg, 0.10mm, 130m

ryu010lg
Livrare imediată!

155,00Lei

Afişare 941 - 960 din 2811 (141 pagini)
Queries: 6, Total time: 224.560 ms [By time] [By id] [By file]
1 (0.144)
SELECT data
FROM `oc_session`
WHERE session_id = '99c7f799467fab9aa09261011c'
/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:427
3 (211.815)
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 = '0' AND (pd.tag LIKE "%green%") 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 (12.271)
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 940, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.130)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.096)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38