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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


MIX STICKY ACTIVE MANILLA 900 GR

MIX STICKY ACTIVE MANILLA 900 GR

stk066
Livrare imediată!

33,59Lei

PELETE JAXON METHOD FEEDER VANILLA 4mm 500g
Exclusiv online!

PELETE JAXON METHOD FEEDER VANILLA 4mm 500g

fm-pe11
Livrare 48-72 ore

29,51Lei

PELETE JAXON METHOD FEEDER VANILLA 2mm 500g

PELETE JAXON METHOD FEEDER VANILLA 2mm 500g

fm-pe01
Livrare imediată!

29,51Lei

PELETE JAXON METHOD FEEDER READY VANILLA 2mm 500g
Exclusiv online!

PELETE JAXON METHOD FEEDER READY VANILLA 2mm 500g

fm-pr01
Livrare 48-72 ore

30,53Lei

POP UP CARP ZOOM FANATI-X 16mm 40gr Vanilla
Exclusiv online!

POP UP CARP ZOOM FANATI-X 16mm 40gr Vanilla

cz9001
Livrare 48-72 ore

23,30Lei

Tablete Nada ZFISH Feeding Briquettes, 45x30x12mm, 220g, Vanilla/Hemp

Tablete Nada ZFISH Feeding Briquettes, 45x30x12mm, 220g, Vanilla/Hemp

zf-5881
Livrare imediată!

14,83Lei

Pufuleti CARP ZOOM Pufi-X Floating Corn Bait Midi, Cream, Vanilla, 25g
Exclusiv online!

Pufuleti CARP ZOOM Pufi-X Floating Corn Bait Midi, Cream, Vanilla, 25g

cz6221
Livrare 48-72 ore

14,12Lei

Pufuleti CARP ZOOM Pufi-X Floating Corn Bait Mini, Cream, Vanilla, 25g
Exclusiv online!

Pufuleti CARP ZOOM Pufi-X Floating Corn Bait Mini, Cream, Vanilla, 25g

cz5972
Livrare 48-72 ore

14,12Lei

Wafter CPK Competition Method, Tiger Nuts & Vanilla, 7mm, 20g

Wafter CPK Competition Method, Tiger Nuts & Vanilla, 7mm, 20g

1001023
Livrare imediată!

30,90Lei

Boilies Dynamite Baits CarpTec Scopex & Vanilla, 20mm, 1,8kg

Boilies Dynamite Baits CarpTec Scopex & Vanilla, 20mm, 1,8kg

dy1781
Livrare imediată!

72,18Lei

Boilies Dynamite Baits CarpTec Scopex & Vanilla, 15mm, 1,8kg
Exclusiv online!

Boilies Dynamite Baits CarpTec Scopex & Vanilla, 15mm, 1,8kg

dy1780
Livrare 48-72 ore

74,21Lei

Porumb CUKK LK Baits Mega Corn, Ice Vanilla, 220ml
Exclusiv online!

Porumb CUKK LK Baits Mega Corn, Ice Vanilla, 220ml

lk-123
Livrare 30-60 zile

33,49Lei

BOILIES DE CARLIG CARP ZOOM FIRE SHOT HOOK BOILIE 16mm 120gr Sweet Vanilla
Exclusiv online!

BOILIES DE CARLIG CARP ZOOM FIRE SHOT HOOK BOILIE 16mm 120gr Sweet Vanilla

cz6802
Livrare 48-72 ore

11,08Lei

Pop Up CARP ZOOM Fanati-X Mini, Vanilla, 10mm, 25g
Exclusiv online!

Pop Up CARP ZOOM Fanati-X Mini, Vanilla, 10mm, 25g

cz8936
Livrare 48-72 ore

19,23Lei

WAFTERS STICKY MANILLA -29%

WAFTERS STICKY MANILLA

stk063
Stoc epuizat

42,75Lei(-29%) 30,56Lei

Nada Umeda MIVARDI Method Particle, Scopex-Vanilla, 1kg

Nada Umeda MIVARDI Method Particle, Scopex-Vanilla, 1kg

m-ramepascv10
Stoc epuizat

31,54Lei

SPRAY CARP ZOOM FC RAPID METHOD 50ml Strawberry-Vanilla -19%

SPRAY CARP ZOOM FC RAPID METHOD 50ml Strawberry-Vanilla

cz2040
Stoc epuizat

16,00Lei(-19%) 12,99Lei

Dip MIVARDI Method Gel Booster, Scopex-Vanilla, 100ml

Dip MIVARDI Method Gel Booster, Scopex-Vanilla, 100ml

m-ramegbscv01
Stoc epuizat

23,40Lei

Afişare 1 - 18 din 18 (1 pagini)
Queries: 13, Total time: 1.549 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = '5fa0849dfaae0cb8dd62fb958f'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.069)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.084)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.080)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("66586", "2", "2", "342", "1", "30.260000000000", "1"),("32158", "2", "1000", "42", "1", "26.590000000000", "2"),("32151", "2", "1", "42", "1", "26.590000000000", "3"),("91135", "2", "1000", "42", "1", "27.500000000000", "4"),("159147", "1", "1000", "75", "1", "20.990000000000", "5"),("222366", "1", "1004", "370", "1", "12.260000000000", "6"),("242797", "2", "1000", "75", "1", "11.670000000000", "7"),("242801", "2", "1000", "75", "1", "11.670000000000", "8"),("240750", "1", "3", "100", "1", "27.840000000000", "9"),("178381", "2", "1001", "178", "1", "65.030000000000", "10"),("178380", "2", "1000", "178", "1", "66.860000000000", "11"),("236360", "2", "1000", "63", "1", "30.170000000000", "12"),("129549", "2", "1000", "75", "1", "9.980000000000", "13"),("158959", "1", "1000", "75", "1", "17.320000000000", "14"),("66585", "2", "0", "342", "1", "27.530000000000", "15"),("232102", "1", "0", "98", "1", "28.410000000000", "16"),("84445", "2", "0", "75", "1", "11.700000000000", "17"),("232107", "1", "0", "98", "1", "21.080000000000", "18")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.077)
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:1593
6 (0.157)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.108)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"OVIDIUS DOCTOR FISHING SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.082)
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
9 (0.228)
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:1393
10 (0.094)
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:1415
11 (0.073)
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:1180
12 (0.326)
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:1094
13 (0.083)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37