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


VOBLER STRIKE PRO CRANKY 4CM/4,2G A103T
Exclusiv online!

VOBLER STRIKE PRO CRANKY 4CM/4,2G A103T

sp.eg164.a103t
Livrare 24-48 ore

27,58Lei

VOBLER STRIKE PRO MUSTANG MINNOW 3,5CM/1,6G A103T
Exclusiv online!

VOBLER STRIKE PRO MUSTANG MINNOW 3,5CM/1,6G A103T

sp.mg015.a103t
Livrare 24-48 ore

27,96Lei

Caciula Maver UK IARNA BEANIE
Exclusiv online!

Caciula Maver UK IARNA BEANIE

n1055
Livrare 48-72 ore

81,23Lei

SET PRO FL 2BUC IN-LINE METHOD FEEDER MARIME L 60G

SET PRO FL 2BUC IN-LINE METHOD FEEDER MARIME L 60G

64-71031-l-60
Livrare imediată!

27,35Lei

TRICOU Maver UK TEAM BLACK XXL
Exclusiv online!

TRICOU Maver UK TEAM BLACK XXL

n1233
Livrare 48-72 ore

96,49Lei

TRICOU Maver UK TEAM BLACK XXXL
Exclusiv online!

TRICOU Maver UK TEAM BLACK XXXL

n1234
Livrare 48-72 ore

96,49Lei

TRICOU Maver UK TEAM WHITE XXL
Exclusiv online!

TRICOU Maver UK TEAM WHITE XXL

n1238
Livrare 48-72 ore

96,49Lei

Protectie Obiectiv Luneta Hawke 60MM -61%
Exclusiv online!

Protectie Obiectiv Luneta Hawke 60MM

vd.61013
Livrare 24-48 ore

144,43Lei(-61%) 56,66Lei

OPRITOR FALCON DIN SILICON L 15BUC/PLIC

OPRITOR FALCON DIN SILICON L 15BUC/PLIC

f1331-l
Livrare imediată!

3,55Lei

PORUMB PREPARAT DYNAMITE BAITS FEEDER

PORUMB PREPARAT DYNAMITE BAITS FEEDER

dy031
Livrare imediată!

82,37Lei

Varf Feeder Maver Abyss X Light 3.30m
Exclusiv online!

Varf Feeder Maver Abyss X Light 3.30m

a2031
Livrare 48-72 ore

41,58Lei

ChatterBait Blade Spro Freestyle Chatter Blades 20mm Chrome

ChatterBait Blade Spro Freestyle Chatter Blades 20mm Chrome

004589-01011-00000
Livrare imediată!

18,59Lei

Jacheta Maver Soft Shell marime XXL -23%
Exclusiv online!

Jacheta Maver Soft Shell marime XXL

n1014
Livrare 48-72 ore

325,01Lei(-23%) 250,02Lei

Jacheta Maver Soft Shell marime XXXL -23%
Exclusiv online!

Jacheta Maver Soft Shell marime XXXL

n1015
Livrare 48-72 ore

325,01Lei(-23%) 250,02Lei

Ulei Universal BALLISTOL, 100ml
Exclusiv online!

Ulei Universal BALLISTOL, 100ml

vk.21036.ro
Livrare 24-48 ore

33,44Lei

Jacheta NASH Waterproof Jacket, Marimea M -30%

Jacheta NASH Waterproof Jacket, Marimea M

c0031
Livrare imediată!

439,99Lei(-30%) 308,47Lei

TUB PROTECTIE JAXON WAGLERE 39x60CM 45MM
Exclusiv online!

TUB PROTECTIE JAXON WAGLERE 39x60CM 45MM

aj-hn103
Livrare 48-72 ore

22,35Lei

SCARITA ELASTIC STONFO 3.5
Exclusiv online!

SCARITA ELASTIC STONFO 3.5

as-31035
Livrare 48-72 ore

16,25Lei

CARLIGE MAVER SERIA INVINCIBLE CS22 CARP FINESSE NR 14
Exclusiv online!

CARLIGE MAVER SERIA INVINCIBLE CS22 CARP FINESSE NR 14

g1011
Livrare 48-72 ore

12,08Lei

CARLIGE MAVER SERIA INVINCIBLE CS22 CARP FINESSE NR 18
Exclusiv online!

CARLIGE MAVER SERIA INVINCIBLE CS22 CARP FINESSE NR 18

g1013
Livrare 48-72 ore

12,08Lei

Afişare 1 - 20 din 64 (4 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 11, Total time: 2.653 ms [By time] [By id] [By file]
1 (0.131)
SELECT data
FROM `oc_session`
WHERE session_id = '1079c4cee7fdc4d9584a5cc2df'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.149)
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.332)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("27907", "2", "1000", "94", "1", "22.790000000000", "1"),("28171", "2", "1000", "94", "1", "23.110000000000", "2"),("108549", "2", "1000", "49", "1", "67.130000000000", "3"),("200467", "1", "1031", "13", "1", "22.600000000000", "4"),("108597", "1", "1000", "49", "1", "79.740000000000", "5"),("108598", "1", "1000", "49", "1", "79.740000000000", "6"),("108602", "1", "1000", "49", "1", "79.740000000000", "7"),("81534", "10", "1000", "445", "1", "46.830000000000", "8"),("63548", "2", "1004", "97", "1", "2.930000000000", "9"),("32753", "2", "1001", "178", "1", "74.210000000000", "10"),("37953", "2", "1000", "49", "1", "34.360000000000", "11"),("122635", "2", "1001", "67", "1", "15.360000000000", "12"),("38005", "2", "1000", "49", "1", "206.630000000000", "13"),("38006", "2", "1000", "49", "1", "206.630000000000", "14"),("231627", "2", "1000", "157", "1", "27.640000000000", "15"),("237906", "1", "1", "59", "1", "254.930000000000", "16"),("104195", "1", "1000", "42", "1", "18.470000000000", "17"),("50699", "2", "1000", "138", "1", "13.430000000000", "18"),("54605", "2", "1000", "49", "1", "9.980000000000", "19"),("54608", "2", "1000", "49", "1", "9.980000000000", "20"),("11240", "10", "4", "59", "1", "210.910000000000", "21"),("101598", "1", "1005", "42", "1", "5.020000000000", "22"),("38176", "2", "1000", "49", "1", "9.980000000000", "23"),("164727", "1", "1000", "23", "1", "127.640000000000", "24"),("111328", "2", "1000", "49", "1", "82.260000000000", "25"),("27913", "2", "1000", "94", "1", "23.310000000000", "26"),("172412", "1", "1000", "224", "1", "6.630000000000", "27"),("13486", "2", "1001", "115", "1", "15.950000000000", "28"),("17527", "2", "1001", "42", "1", "32.760000000000", "29"),("13479", "2", "1000", "115", "1", "15.530000000000", "30"),("13480", "2", "1000", "115", "1", "15.530000000000", "31"),("13483", "2", "1000", "115", "1", "15.530000000000", "32"),("13485", "2", "1000", "115", "1", "15.530000000000", "33"),("13487", "2", "1000", "115", "1", "15.950000000000", "34"),("17528", "2", "1000", "42", "1", "32.760000000000", "35"),("17529", "2", "1000", "42", "1", "32.760000000000", "36"),("176356", "1", "1000", "492", "1", "353.930000000000", "37"),("13482", "2", "2", "115", "1", "10.130000000000", "38"),("72133", "2", "1002", "149", "1", "58.810000000000", "39"),("72134", "2", "1001", "149", "1", "58.810000000000", "40"),("81665", "2", "1000", "67", "1", "25.620000000000", "41"),("175633", "1", "1000", "124", "1", "7.540000000000", "42"),("87217", "2", "1005", "354", "1", "31.830000000000", "43"),("165437", "1", "4", "67", "1", "11.500000000000", "44"),("242916", "2", "1001", "149", "1", "94.940000000000", "45"),("64417", "2", "1000", "67", "1", "10.830000000000", "46"),("115007", "2", "1000", "47", "1", "95.740000000000", "47"),("115146", "1", "1000", "85", "1", "27.550000000000", "48"),("252610", "1", "1012", "351", "1", "63.870000000000", "49"),("108601", "1", "0", "49", "1", "63.000000000000", "50"),("81537", "10", "0", "445", "1", "65.770000000000", "51"),("162249", "1", "0", "59", "1", "535.270000000000", "52"),("59642", "2", "0", "67", "1", "79.260000000000", "53"),("48587", "2", "0", "94", "1", "19.950000000000", "54"),("48743", "2", "0", "94", "1", "16.550000000000", "55"),("164726", "1", "0", "23", "1", "85.000000000000", "56"),("13481", "2", "0", "115", "1", "11.300000000000", "57"),("13484", "2", "0", "115", "1", "11.300000000000", "58"),("122633", "2", "0", "67", "1", "10.390000000000", "59"),("111136", "2", "0", "67", "1", "10.930000000000", "60"),("116418", "2", "0", "85", "1", "9.960000000000", "61"),("188231", "1", "0", "23", "1", "105.000000000000", "62"),("110806", "10", "0", "445", "1", "235.040000000000", "63"),("25564", "2", "0", "75", "1", "10.500000000000", "64")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.135)
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.270)
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.231)
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
8 (0.081)
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
9 (0.071)
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
10 (1.040)
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
11 (0.130)
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