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 Jaxon SUMATO PREMIUM 10m 0.18mm

Fir Textil Jaxon SUMATO PREMIUM 10m 0.18mm

zj-rap018c
Livrare imediată!

11,00Lei

Fir fluorocarbon Kryston Super Incognito 20m 15lb

Fir fluorocarbon Kryston Super Incognito 20m 15lb

krinc6
Livrare imediată!

51,00Lei

FLUOROCARBON RIDGE MONKEY 20MT 20LB CLEAR -35%

FLUOROCARBON RIDGE MONKEY 20MT 20LB CLEAR

rm-t 049
Livrare imediată!

52,00Lei(-35%) 33,80Lei

Montura Mivardi Lead Core Rig System + Antitangle Sleeves 2buc/plic -30%

Montura Mivardi Lead Core Rig System + Antitangle Sleeves 2buc/plic

m-acrslccr
Livrare imediată!

31,90Lei(-30%) 22,32Lei

Rig Crap Owner 56994 Nr.6 15Lb Bungee Rig

Rig Crap Owner 56994 Nr.6 15Lb Bungee Rig

5699406
Livrare imediată!

28,91Lei

MONTURA PROLOGIC 15CM CU CARLIG XC5 NR.4 2BUC -40%
Exclusiv online!

MONTURA PROLOGIC 15CM CU CARLIG XC5 NR.4 2BUC

a.pro.50115
Livrare 24-48 ore

24,47Lei(-40%) 14,68Lei

FIR TEXTIL CRALUSSO XTREME 15M 0.08MM

FIR TEXTIL CRALUSSO XTREME 15M 0.08MM

33908008
Livrare imediată!

37,00Lei

Montura Carp Spirit Blow Back Rig Nr.8 1buc/plic
Exclusiv online!

Montura Carp Spirit Blow Back Rig Nr.8 1buc/plic

acs340047
Livrare 48-72ore

19,00Lei

Fir Textil Nevis Technology 10m 0.14mm

Fir Textil Nevis Technology 10m 0.14mm

5304-914
Livrare imediată!

12,00Lei

Fir Textil Carp Spirit Ballistic 20m, 11.30kg, Camo Brown -24%
Exclusiv online!

Fir Textil Carp Spirit Ballistic 20m, 11.30kg, Camo Brown

acs640036
Livrare 48-72ore

59,00Lei(-24%) 45,01Lei

Fir Textil Carp Spirit Kameleon 20m 35lbs 15.80kg -20%

Fir Textil Carp Spirit Kameleon 20m 35lbs 15.80kg

acs640094
Livrare imediată!

75,01Lei(-20%) 60,00Lei

Forfac Boilie Strategy Rig Shot On The Pod Nr.10
Exclusiv online!

Forfac Boilie Strategy Rig Shot On The Pod Nr.10

8517-010
Livrare 48-72 ore

10,81Lei

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

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

9900-10037-030
Livrare 48-72 ore

51,00Lei

Fir textil Climax CULT HUNTERSBRAID SINKING HOOKLINK 20m 25lbs 0.25mm Weed Green
Exclusiv online!

Fir textil Climax CULT HUNTERSBRAID SINKING HOOKLINK 20m 25lbs 0.25mm Weed Green

9900-10028-025
Livrare 48-72 ore

35,00Lei

FIR COLMIC FLUOROCARBON ZAYO 50M 0.22mm
Exclusiv online!

FIR COLMIC FLUOROCARBON ZAYO 50M 0.22mm

nyza22
Livrare 48-72 ore

85,00Lei

Fir textil Kryston Merlin Fast Sinking Weed Green 15lb 20m
Exclusiv online!

Fir textil Kryston Merlin Fast Sinking Weed Green 15lb 20m

krme6
Livrare 48-72 ore

48,00Lei

Fir PB Products Fluoro Carbon Ghost Butterfly 20m 20lb

Fir PB Products Fluoro Carbon Ghost Butterfly 20m 20lb

pb10422
Livrare imediată!

58,00Lei

Fir textil Climax CULT HUNTERSBRAID SINKING HOOKLINK 20m 30lbs 0.30mm Camouflage
Exclusiv online!

Fir textil Climax CULT HUNTERSBRAID SINKING HOOKLINK 20m 30lbs 0.30mm Camouflage

9900-10004-030
Livrare 48-72 ore

35,00Lei

FIR TEXTIL JAXON HEGEMON 8X PREMIUM 150m 0.22mm 25kg -21%

FIR TEXTIL JAXON HEGEMON 8X PREMIUM 150m 0.22mm 25kg

zj-dep022a
Livrare imediată!

131,00Lei(-21%) 102,90Lei

MULTI RIG KORDA NR 8 30LB

MULTI RIG KORDA NR 8 30LB

a.kcr084
Livrare imediată!

15,29Lei

Afişare 1221 - 1240 din 2364 (119 pagini)
Queries: 7, Total time: 63.825 ms [By time] [By id] [By file]
1 (0.126)
SELECT data
FROM `oc_session`
WHERE session_id = 'cc866315ff24a98bec54e07882'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (54.760)
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:724
4 (8.545)
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 1220, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.108)
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.098)
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
7 (0.094)
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