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


Fir Textil Nevis Technology Dyneema 10m 0.16mm

Fir Textil Nevis Technology Dyneema 10m 0.16mm

5304-016
Livrare imediată!

8,40Lei

Rig Strategy Position KD Gamakatasu Rig Nr.6

Rig Strategy Position KD Gamakatasu Rig Nr.6

008541-00406-00000
Livrare imediată!

13,49Lei

Fir Textil Carp Expert SKIN LINE 15LBS PITCH BLACK 10M

Fir Textil Carp Expert SKIN LINE 15LBS PITCH BLACK 10M

31556154
Livrare imediată!

18,00Lei

Fir textil Climax CULT HUNTERSBRAID SINKING HOOKLINK 20m 25lb Dark Silt
Exclusiv online!

Fir textil Climax CULT HUNTERSBRAID SINKING HOOKLINK 20m 25lb Dark Silt

9900-10029-025
Livrare 48-72 ore

35,00Lei

FIR PB Products Silk Ray Hit and Run Leader Weed 90cm, 2buc/plic
Exclusiv online!

FIR PB Products Silk Ray Hit and Run Leader Weed 90cm, 2buc/plic

shrlw90
Livrare 48-72 ore

38,00Lei

Fir Textil K-Karp Weedy Trap HookLink 45lbs 5m
Exclusiv online!

Fir Textil K-Karp Weedy Trap HookLink 45lbs 5m

198-84-045
Livrare 48-72 ore

32,00Lei

FIR TEXTIL KAMASAKI SUPER BRAID LEADER 10M 0.22MM 18.1KG

FIR TEXTIL KAMASAKI SUPER BRAID LEADER 10M 0.22MM 18.1KG

34021022
Livrare imediată!

9,00Lei

Fir textil CPK Silky Natural Feeder Hooklink Grey 0.14mm/5.44kg/15m

Fir textil CPK Silky Natural Feeder Hooklink Grey 0.14mm/5.44kg/15m

999960
Livrare imediată!

29,00Lei

MONTURA ARROW LEADCORE PB GRIPPA INLINE SOFT RIG NR6

MONTURA ARROW LEADCORE PB GRIPPA INLINE SOFT RIG NR6

a.mpdg06.60
Livrare imediată!

19,92Lei

Fir textil Kryston Merlin Fast Sinking Gravel Brown 15lb 20m

Fir textil Kryston Merlin Fast Sinking Gravel Brown 15lb 20m

krme9
Livrare imediată!

48,00Lei

MONTURA CORMORAN CLASIC BOILIE RIG ST NR.6/2BUC

MONTURA CORMORAN CLASIC BOILIE RIG ST NR.6/2BUC

a.11.02320.6
Livrare imediată!

9,31Lei

Montura Mivardi Double Looped Leadcore 80cm 45lbs 2buc/plic

Montura Mivardi Double Looped Leadcore 80cm 45lbs 2buc/plic

m-acrsdllc
Livrare imediată!

19,90Lei

INELE JAXON OVALE MONTURI

INELE JAXON OVALE MONTURI

ac-pc129
Livrare imediată!

10,00Lei

MONTURA CARP EXPERT PVC-RING 45CM 2BUC/PLIC

MONTURA CARP EXPERT PVC-RING 45CM 2BUC/PLIC

42775040
Livrare imediată!

19,50Lei

MULTI RIG KORDA NR 4 30LB
Exclusiv online!

MULTI RIG KORDA NR 4 30LB

a.kcr082
Livrare 24-48 ore

15,29Lei

FIR CARP ZOOM TEXTIL LEADER ALLROUND 20m 0.18mm Gri

FIR CARP ZOOM TEXTIL LEADER ALLROUND 20m 0.18mm Gri

cz7497
Livrare imediată!

11,00Lei

Fir Leadcore Carp Spirit Gravity Super Supple Camo Brown 45lbs 10m 20.40kg
Exclusiv online!

Fir Leadcore Carp Spirit Gravity Super Supple Camo Brown 45lbs 10m 20.40kg

acs640047
Livrare 48-72ore

72,99Lei

FIR TEXTIL FOX EDGES ARMADILLO SHOCK AND SNAG LEADER CAMO 40Lbs 20M

FIR TEXTIL FOX EDGES ARMADILLO SHOCK AND SNAG LEADER CAMO 40Lbs 20M

cac745
Livrare imediată!

85,47Lei

Montura Rig Crap Zebco No.6 Z-Carp Stiff-D Rig

Montura Rig Crap Zebco No.6 Z-Carp Stiff-D Rig

4136006
Livrare imediată!

13,28Lei

Fir Textil Cu Camasa Kryston Super Mantis Coated Braid, Grawel Brown, 20m, 15lbs
Exclusiv online!

Fir Textil Cu Camasa Kryston Super Mantis Coated Braid, Grawel Brown, 20m, 15lbs

krman3
Livrare 48-72 ore

66,00Lei

Afişare 1161 - 1180 din 2364 (119 pagini)
Queries: 5, Total time: 57.683 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '16461a816f9b49e5ab6d28cd93'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (57.156)
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 +crap' 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:722
4 (0.181)
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
5 (0.126)
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