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


CONECTOR WAGLER CULISANT NR 2M

CONECTOR WAGLER CULISANT NR 2M

aj-kru02m
Livrare imediată!

4,00Lei

CONECTOR WAGLER CULISANT NR 1S
Exclusiv online!

CONECTOR WAGLER CULISANT NR 1S

aj-kru01s
Livrare 48-72 ore

4,00Lei

FIR LINEAEFFE MONOFILAMENT SPECIMEN SILICONE 0.50MM/29.60KG 300M
Exclusiv online!

FIR LINEAEFFE MONOFILAMENT SPECIMEN SILICONE 0.50MM/29.60KG 300M

l.3600550
Livrare 24-48 ore

34,71Lei

VOBLER RAPALA SUPER SHADOW RAP TWILIGHT ZONE 16CM 77G
Exclusiv online!

VOBLER RAPALA SUPER SHADOW RAP TWILIGHT ZONE 16CM 77G

ssdr16 twz
Livrare 48-72ore

79,00Lei

CONECTOR WAGLER CULISANT NR 2S

CONECTOR WAGLER CULISANT NR 2S

aj-kru02s
Livrare imediată!

4,00Lei

FIR LINEAEFFE MONOFILAMENT SPECIMEN SILICONE 0.60MM/34.3KG 300M

FIR LINEAEFFE MONOFILAMENT SPECIMEN SILICONE 0.60MM/34.3KG 300M

l.3600560
Livrare imediată!

37,68Lei

Stopper The One Gummy Stops S

Stopper The One Gummy Stops S

79633410
Livrare imediată!

8,00Lei

Conector Baracuda Set 4 Adaptoare Montare Rapida 4buc/set

Conector Baracuda Set 4 Adaptoare Montare Rapida 4buc/set

set 4 adaptoare montare rapida av
Livrare imediată!

82,90Lei

Lanseta Daiwa N Zone Distance Feeder 3.66m 150g 3+2seg

Lanseta Daiwa N Zone Distance Feeder 3.66m 150g 3+2seg

d.11332.366
Livrare imediată!

433,76Lei

TIJA INTERSCHIMBABILA FEEDER FL CU CONECTOR LONG 15CM 5BUC

TIJA INTERSCHIMBABILA FEEDER FL CU CONECTOR LONG 15CM 5BUC

64-3032
Livrare imediată!

7,90Lei

SET METHOD FEEDER JAXON E2 CU MATRITA SI CONECTOR 20GR -20%

SET METHOD FEEDER JAXON E2 CU MATRITA SI CONECTOR 20GR

af-e220x
Livrare imediată!

45,01Lei(-20%) 35,90Lei

SPRAY CARP ZOOM FC RAPID METHOD 50ml Honey-Apple

SPRAY CARP ZOOM FC RAPID METHOD 50ml Honey-Apple

cz2057
Livrare imediată!

16,00Lei

FIR MONOFILAMENT GENLOG NUMBER ONE FEEDER AND METHOD 150 M 0.20 MM 11 KG
Exclusiv online!

FIR MONOFILAMENT GENLOG NUMBER ONE FEEDER AND METHOD 150 M 0.20 MM 11 KG

gzy-nofm-20
Livrare 48-72 ore

31,00Lei

Hook Keeper FUJI EHKM GB AB GOLD BLACK
Exclusiv online!

Hook Keeper FUJI EHKM GB AB GOLD BLACK

mehkmigbab
Livrare 48-72 ore

42,99Lei

Conector Pluta Match Cralusso Agrafa Metal Waggler, 2buc/pac

Conector Pluta Match Cralusso Agrafa Metal Waggler, 2buc/pac

79008203
Livrare imediată!

17,01Lei

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 SCARLET 005
Exclusiv online!

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 SCARLET 005

mftupa0005
Livrare 48-72 ore

21,00Lei

Manson Black Cat Silicone Sleeve 25mm

Manson Black Cat Silicone Sleeve 25mm

6612005
Livrare imediată!

22,28Lei

WINDING CHECK FUJI WCS 16-8
Exclusiv online!

WINDING CHECK FUJI WCS 16-8

mwcs16-8
Livrare 48-72 ore

5,80Lei

PIULITA MANDRINA FUJI KDPS-ASH NR 17
Exclusiv online!

PIULITA MANDRINA FUJI KDPS-ASH NR 17

mkdps17ash
Livrare 48-72 ore

35,00Lei

Conector Prologic Negru Cu Eliberare Rapida 3buc/plic S

Conector Prologic Negru Cu Eliberare Rapida 3buc/plic S

a.pro.43884
Livrare imediată!

60,90Lei

Afişare 601 - 620 din 1442 (73 pagini)
Queries: 11, Total time: 946.219 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = 'b534f8fb59d903b3e31a58a740'
/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 (918.585)
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 (pd.tag LIKE "%one%") 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 (0.243)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (6.516)
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 600, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.153)
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 (2.465)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1235
8 (0.109)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1257
9 (0.576)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1022
10 (17.213)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:936
11 (0.143)
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