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


CUTIE ENERGO TEAM PENTRU TWISERE DELUXE HA-1 27X21X4 CM
Exclusiv online!

CUTIE ENERGO TEAM PENTRU TWISERE DELUXE HA-1 27X21X4 CM

75101001
Livrare 24-48 ore

41,58Lei

CUTIE HORVATEH PENTRU TWISERE DELUXE HA-2 (13X21X4 CM)
Exclusiv online!

CUTIE HORVATEH PENTRU TWISERE DELUXE HA-2 (13X21X4 CM)

75101002
Livrare 24-48 ore

25,30Lei

CUTIE KAMASAKI SUPERBOX 1011 17x8.5x3CM

CUTIE KAMASAKI SUPERBOX 1011 17x8.5x3CM

75010011
Livrare imediată!

12,18Lei

CUTIE ENERGO TEAM PENTRU TWISERE DELUXE HA-3 6 COMP 9X17X4 CM
Exclusiv online!

CUTIE ENERGO TEAM PENTRU TWISERE DELUXE HA-3 6 COMP 9X17X4 CM

75101003
Livrare 24-48 ore

22,25Lei

Montura EnergoTeam Somn Pluta Uriasa KOOS

Montura EnergoTeam Somn Pluta Uriasa KOOS

79301001
Livrare imediată!

66,08Lei

Carlig Owner Worm 5100 Nr.5/0
Exclusiv online!

Carlig Owner Worm 5100 Nr.5/0

5100001
Livrare 48-72 ore

20,07Lei

Carp Expert Neo Compact Rod Pod
Exclusiv online!

Carp Expert Neo Compact Rod Pod

77106001
Livrare 24-48 ore

343,56Lei

Carlige Legate KAMASAKI K807G, Auriu, Nr.1, 10buc/pac
Exclusiv online!

Carlige Legate KAMASAKI K807G, Auriu, Nr.1, 10buc/pac

45401001
Livrare 24-48 ore

9,53Lei

Carlig Owner Cps 5111 Negru nr 6/0 - 4buc/plic

Carlig Owner Cps 5111 Negru nr 6/0 - 4buc/plic

5111001
Livrare imediată!

19,97Lei

CARLIG OWNER CPS 5106 Nr.1/0 Negru Rotund Anou
Exclusiv online!

CARLIG OWNER CPS 5106 Nr.1/0 Negru Rotund Anou

5106001
Livrare 48-72 ore

20,07Lei

Rotativa DAM Effzett Standard Nr.1, Black Yellow, 3g
Exclusiv online!

Rotativa DAM Effzett Standard Nr.1, Black Yellow, 3g

f.dam.5131001
Livrare 24-48 ore

13,10Lei

Acumulator Led Lenser Lithium-ion Battery 3000mAh
Exclusiv online!

Acumulator Led Lenser Lithium-ion Battery 3000mAh

a8.z501001
Livrare 24-48 ore

130,67Lei

Ochelari de Soare CARP EXPERT Stream
Exclusiv online!

Ochelari de Soare CARP EXPERT Stream

74101501
Livrare 24-48 ore

85,51Lei

Jig Offset Owner Worm Wide Gap 5102 Nr.5/0 - 5buc/plic

Jig Offset Owner Worm Wide Gap 5102 Nr.5/0 - 5buc/plic

5102001
Livrare imediată!

23,50Lei

Juvelnic EnergoTeam 3 inele diam 40cm PT-43
Exclusiv online!

Juvelnic EnergoTeam 3 inele diam 40cm PT-43

72101003
Livrare 24-48 ore

23,27Lei

Juvelnic EnergoTeam 4 inele diam 40cm PT-44
Exclusiv online!

Juvelnic EnergoTeam 4 inele diam 40cm PT-44

72101004
Livrare 24-48 ore

26,32Lei

Juvelnic EnergoTeam 5 inele diam 40cm PT-45
Exclusiv online!

Juvelnic EnergoTeam 5 inele diam 40cm PT-45

72101005
Livrare 24-48 ore

30,40Lei

Agrafa ZEOX Quick Snap 201BN, Nr.00, 9kg, 10buc/pac

Agrafa ZEOX Quick Snap 201BN, Nr.00, 9kg, 10buc/pac

gcz-4510001
Livrare imediată!

4,56Lei

CUTIE KAMASAKI SUPERBOX 1012 20x10x6CM -32%

CUTIE KAMASAKI SUPERBOX 1012 20x10x6CM

75010012
Stoc epuizat

15,25Lei(-32%) 10,31Lei

Dispozitiv Recuperare Naluci Quantum Lure Retriever Small, 150g -42%

Dispozitiv Recuperare Naluci Quantum Lure Retriever Small, 150g

6501001
Stoc epuizat

55,68Lei(-42%) 32,45Lei

Afişare 1 - 20 din 20 (1 pagini)
Queries: 11, Total time: 1.976 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '75405764196d56e4ec805a55a7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.145)
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.141)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("62582", "2", "1000", "24", "1", "34.360000000000", "1"),("62895", "2", "1000", "38", "1", "20.910000000000", "2"),("96600", "2", "5", "188", "1", "10.070000000000", "3"),("62583", "2", "1000", "24", "1", "18.390000000000", "4"),("69675", "2", "1005", "24", "1", "54.610000000000", "5"),("56998", "2", "1000", "15", "1", "16.590000000000", "6"),("62670", "2", "1000", "27", "1", "283.930000000000", "7"),("61255", "2", "1000", "188", "1", "7.880000000000", "8"),("548", "2", "1004", "15", "1", "16.500000000000", "9"),("64119", "2", "1000", "15", "1", "16.590000000000", "10"),("70979", "2", "1000", "124", "1", "10.830000000000", "11"),("92802", "2", "1000", "53", "1", "107.990000000000", "12"),("245136", "1", "1000", "27", "1", "70.670000000000", "13"),("12324", "2", "1002", "15", "1", "19.420000000000", "14"),("113667", "2", "1000", "24", "1", "19.230000000000", "15"),("113668", "2", "1000", "24", "1", "21.750000000000", "16"),("113669", "2", "1000", "24", "1", "25.120000000000", "17"),("239249", "1", "1006", "782", "1", "3.770000000000", "18"),("96602", "2", "0", "188", "1", "8.520000000000", "19"),("70759", "2", "0", "228", "1", "26.820000000000", "20")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.140)
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.246)
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.274)
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.102)
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.080)
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 (0.542)
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.096)
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