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


Husa Rigida Lansete cu Mulineta MIVARDI Feeder TMX Xtra Safe, 3 Compartimente, 141x15cm
Exclusiv online!

Husa Rigida Lansete cu Mulineta MIVARDI Feeder TMX Xtra Safe, 3 Compartimente, 141x15cm

m-tmxrhxs
Livrare 48-72 ore

295,00Lei

CUTIE MOMEALA JAXON 11X5cm

CUTIE MOMEALA JAXON 11X5cm

rh-154
Livrare imediată!

7,50Lei

HUSA DAIWA NEOPREN PT. MULINETA 17X15CM
Exclusiv online!

HUSA DAIWA NEOPREN PT. MULINETA 17X15CM

a8.15802.010
Livrare 24-48 ore

63,11Lei

Cutie Panaro pentru Accesorii, 4 Compartimente, 24x15cm
Exclusiv online!

Cutie Panaro pentru Accesorii, 4 Compartimente, 24x15cm

a4.p191.4n
Livrare 24-48 ore

16,79Lei

Strune Wolfram Wizard Stiuca 10x15cm 10x22cm Si 10x30cm 30buc

Strune Wolfram Wizard Stiuca 10x15cm 10x22cm Si 10x30cm 30buc

82008100
Livrare imediată!

41,00Lei

CUTIE PANARO 7 COMPART. FIXE PT. ACCESORII 24X15CM

CUTIE PANARO 7 COMPART. FIXE PT. ACCESORII 24X15CM

a4.p191.7n
Livrare imediată!

16,79Lei

Cutie Plastica Panaro 12 Compartimente Fixe Accesorii 24x15cm

Cutie Plastica Panaro 12 Compartimente Fixe Accesorii 24x15cm

a4.p191.12n
Livrare imediată!

16,37Lei

Husa Neopren Sportex Roller Bag, Marime S, 15x15cm -23%

Husa Neopren Sportex Roller Bag, Marime S, 15x15cm

s300715
Livrare imediată!

70,39Lei(-23%) 53,90Lei

Portofel Permis Pescuit Carp Academy + Pix, 14x17cm
Exclusiv online!

Portofel Permis Pescuit Carp Academy + Pix, 14x17cm

5205-001
Livrare 48-72 ore

15,60Lei

Punga PVA Carp Academy 10X15cm
Exclusiv online!

Punga PVA Carp Academy 10X15cm

6408-050
Livrare 48-72 ore

55,00Lei

Platou Jaxon pentru Filetat Pesti 40x15cm

Platou Jaxon pentru Filetat Pesti 40x15cm

ak-df02
Livrare imediată!

63,00Lei

BAC COLMIC MAGIC NET PATRAT 15x15cm
Exclusiv online!

BAC COLMIC MAGIC NET PATRAT 15x15cm

sc102c
Livrare 48-72 ore

80,00Lei

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 145x11cm

Tub Rigid pentru Protectie Lanseta Jaxon X-Team 145x11cm

uj-xar110145
Livrare imediată!

220,00Lei

SITA MIKADO PENTRU NADA FISHING SIEVE SQUARE 15X15CM

SITA MIKADO PENTRU NADA FISHING SIEVE SQUARE 15X15CM

is15-sito15x15/3
Livrare imediată!

49,00Lei

Husa Minciog PROLOGIC Waterproof Stink, 125x15cm -80%

Husa Minciog PROLOGIC Waterproof Stink, 125x15cm

svs62067
Stoc epuizat

149,95Lei(-80%) 29,66Lei

Geanta Nash Waterbox 115 Series, 16.5x 14x11.5cm

Geanta Nash Waterbox 115 Series, 16.5x 14x11.5cm

t3646
Stoc epuizat

97,98Lei

HUSA PROLOGIC PT MINCIOG WATERPROOF STINK 125X15CM -23%

HUSA PROLOGIC PT MINCIOG WATERPROOF STINK 125X15CM

a8.pro.62067
Stoc epuizat

102,47Lei(-23%) 78,84Lei

Husa Lansete Colmic Oslo 3D, 1 compartiment, 150x15cm -24%

Husa Lansete Colmic Oslo 3D, 1 compartiment, 150x15cm

pr301
Stoc epuizat

96,00Lei(-24%) 72,59Lei

Husa Lansete Colmic Oslo 3D, 1 compartiment, 160x15cm -24%

Husa Lansete Colmic Oslo 3D, 1 compartiment, 160x15cm

pr302
Stoc epuizat

100,00Lei(-24%) 76,16Lei

Husa Lansete Colmic Oslo 3D, 1 compartiment, 170x15cm -24%

Husa Lansete Colmic Oslo 3D, 1 compartiment, 170x15cm

pr303
Stoc epuizat

105,01Lei(-24%) 79,73Lei

Afişare 1 - 20 din 20 (1 pagini)
Queries: 11, Total time: 1.804 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = '790d6c2eb9429fa9262ff2f140'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.139)
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 ("232754", "2", "1000", "98", "1", "247.900000000000", "1"),("18061", "2", "1001", "42", "1", "6.300000000000", "2"),("92042", "2", "1000", "11", "1", "53.030000000000", "3"),("92137", "2", "1000", "112", "1", "14.110000000000", "4"),("114797", "2", "1001", "401", "1", "34.450000000000", "5"),("22458", "2", "1001", "112", "1", "14.110000000000", "6"),("94857", "2", "1", "112", "1", "13.760000000000", "7"),("129493", "2", "1003", "192", "1", "45.290000000000", "8"),("229337", "2", "1000", "168", "1", "13.110000000000", "9"),("89506", "2", "1000", "362", "1", "46.220000000000", "10"),("16935", "2", "1001", "42", "1", "52.940000000000", "11"),("85818", "2", "1000", "115", "1", "67.230000000000", "12"),("91125", "2", "1", "42", "1", "184.870000000000", "13"),("154481", "1", "1001", "224", "1", "41.180000000000", "14"),("237895", "1", "0", "47", "1", "24.927800000000", "15"),("193835", "2", "0", "59", "1", "82.340000000000", "16"),("86916", "2", "0", "47", "1", "66.250000000000", "17"),("179675", "2", "0", "115", "1", "61.000000000000", "18"),("179676", "2", "0", "115", "1", "64.000000000000", "19"),("179677", "2", "0", "115", "1", "67.000000000000", "20")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.087)
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.202)
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.240)
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.123)
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.107)
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.391)
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.124)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37