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


Cutie Shakespeare Cantilever Tackle Box 30x17x14cm

Cutie Shakespeare Cantilever Tackle Box 30x17x14cm

1247781
Livrare imediată!

108,78Lei

Cutie Accesorii Baracuda HS321, 30x17x4cm

Cutie Accesorii Baracuda HS321, 30x17x4cm

hs327
Livrare imediată!

27,35Lei

Cutie Mikado Pentru Accesorii H413, 30x17x14xm
Exclusiv online!

Cutie Mikado Pentru Accesorii H413, 30x17x14xm

uac-h413
Livrare 48-72 ore

111,73Lei

Valigeta Carp Zoom Kids 30x12x12cm -20%

Valigeta Carp Zoom Kids 30x12x12cm

cz5998
Livrare imediată!

29,00Lei(-20%) 23,27Lei

Geanta Prologic Storm Safe Deep 10x17x13cm

Geanta Prologic Storm Safe Deep 10x17x13cm

svs72728
Livrare imediată!

70,14Lei

CUTIE CARP ZOOM MOMEALA EVA 30x18x10cm -21%
Exclusiv online!

CUTIE CARP ZOOM MOMEALA EVA 30x18x10cm

cz4274
Livrare 48-72 ore

85,00Lei(-21%) 66,79Lei

Geanta Fox Camolite Storage Bag, 39x18x14cm
Exclusiv online!

Geanta Fox Camolite Storage Bag, 39x18x14cm

clu493
Livrare 7-14 zile

120,84Lei

VALIGETA CARP ZOOM, 2 SERTARE, 30X19X15CM

VALIGETA CARP ZOOM, 2 SERTARE, 30X19X15CM

cz7467
Livrare imediată!

89,46Lei

Geanta Fox Camolite Cool Bag Termorezistenta, 39x18x14cm
Exclusiv online!

Geanta Fox Camolite Cool Bag Termorezistenta, 39x18x14cm

clu491
Livrare 7-14 zile

139,14Lei

Geanta CARP ACADEMY Organizator PVA, 30x17x11cm
Exclusiv online!

Geanta CARP ACADEMY Organizator PVA, 30x17x11cm

5272-004
Livrare 48-72 ore

46,90Lei

Geanta Prologic Storm Safe Element 20x17x13cm

Geanta Prologic Storm Safe Element 20x17x13cm

svs72727
Livrare imediată!

87,43Lei

Lopata Nadire Zfish Baiting Spoon Remix Full L, 30x14x10cm
Exclusiv online!

Lopata Nadire Zfish Baiting Spoon Remix Full L, 30x14x10cm

zf-7861
Livrare 48-72ore

19,05Lei

Geanta Din Plasa Fox Air Dry Bag, 24x17x14cm
Exclusiv online!

Geanta Din Plasa Fox Air Dry Bag, 24x17x14cm

clu530
Livrare 7-14 zile

70,51Lei

Penar Semirigid Mivardi S pentru Accesorii si Monturi, 30x18x4cm -26%

Penar Semirigid Mivardi S pentru Accesorii si Monturi, 30x18x4cm

m-chws
Livrare imediată!

115,00Lei(-26%) 85,29Lei

Borseta Spro Freestyle Chest Pouch 07, 30x12x4cm

Borseta Spro Freestyle Chest Pouch 07, 30x12x4cm

006205-01900-00000
Livrare imediată!

169,79Lei

Geanta Buzz Bar KORDA Compac, Medium, 30x17x6cm
Exclusiv online!

Geanta Buzz Bar KORDA Compac, Medium, 30x17x6cm

klug71
Livrare 7-14 zile

138,22Lei

Geanta Buzz Bar KORDA Compac, Medium, Dark Kamo, 30x17x6cm
Exclusiv online!

Geanta Buzz Bar KORDA Compac, Medium, Dark Kamo, 30x17x6cm

klug130
Livrare 7-14 zile

148,39Lei

Geanta NASH Barrow Pannier Back, 30x47x12cm

Geanta NASH Barrow Pannier Back, 30x47x12cm

t3596
Stoc epuizat

163,68Lei

Bac pentru Momeala Carp Zoom EVA, 30x18x10cm -24%

Bac pentru Momeala Carp Zoom EVA, 30x18x10cm

cz4229
Stoc epuizat

60,98Lei(-24%) 46,34Lei

Geanta Accesorii Aqua Products Black Series Bits Bag, Small, 10x17x17cm

Geanta Accesorii Aqua Products Black Series Bits Bag, Small, 10x17x17cm

404912
Stoc epuizat

122,97Lei

Afişare 1 - 20 din 21 (2 pagini)
Queries: 13, Total time: 1.775 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = 'a3362c60289057be59da6f4af1'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
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.097)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("170207", "2", "1001", "191", "1", "89.900000000000", "1"),("187983", "2", "2", "280", "1", "22.600000000000", "2"),("223717", "1", "1000", "224", "1", "92.340000000000", "3"),("81191", "2", "1", "75", "1", "19.230000000000", "4"),("146443", "2", "1004", "47", "1", "57.970000000000", "5"),("47912", "2", "1000", "75", "1", "55.200000000000", "6"),("228193", "1", "1000", "168", "1", "99.870000000000", "7"),("66549", "2", "1", "75", "1", "73.930000000000", "8"),("227951", "1", "1000", "168", "1", "114.990000000000", "9"),("249737", "1", "1000", "362", "1", "38.760000000000", "10"),("146441", "2", "1002", "47", "1", "72.260000000000", "11"),("227273", "2", "1000", "370", "1", "15.740000000000", "12"),("228422", "2", "1000", "168", "1", "58.270000000000", "13"),("4404", "2", "1", "98", "1", "70.490000000000", "14"),("175317", "1", "1002", "67", "1", "140.320000000000", "15"),("244224", "1", "1000", "73", "1", "114.230000000000", "16"),("244111", "1", "1000", "73", "1", "122.640000000000", "17"),("234425", "1", "0", "59", "1", "135.270000000000", "18"),("47910", "2", "0", "75", "1", "38.300000000000", "19"),("216639", "1", "0", "743", "1", "101.630000000000", "20"),("121150", "2", "0", "287", "1", "54.020000000000", "21")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.093)
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.208)
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.139)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.123)
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.195)
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.113)
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.099)
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.331)
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.096)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37