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 lansete Carp Zoom Feeder Competition Triple Rodbag 150x20x30cm

Husa lansete Carp Zoom Feeder Competition Triple Rodbag 150x20x30cm

cz4441
Livrare imediată!

225,01Lei

GEANTA ARROW CAMO 3BUZUNARE 50X30X30CM
Exclusiv online!

GEANTA ARROW CAMO 3BUZUNARE 50X30X30CM

vso.e711
Livrare 24-48 ore

127,43Lei

Saltea Trakker Sanctuary Cradle, 120x60x30cm
Exclusiv online!

Saltea Trakker Sanctuary Cradle, 120x60x30cm

212702
Livrare 7-14 zile

824,96Lei

Minciog DAIWA Prorex Short Track, 150x70x60cm
Exclusiv online!

Minciog DAIWA Prorex Short Track, 150x70x60cm

a2.15810.470
Livrare 24-48 ore

213,30Lei

Geanta Fox Voyager Carryall, Medium, 50x30x30cm

Geanta Fox Voyager Carryall, Medium, 50x30x30cm

clu555
Livrare imediată!

269,96Lei

Saltea Primire Trakker Sanctuary Insta-Mat, 110x50x30cm
Exclusiv online!

Saltea Primire Trakker Sanctuary Insta-Mat, 110x50x30cm

212420
Livrare 7-14 zile

524,94Lei

Cort Trakker Tempest RS 150 Aquatexx, 150x320x230cm
Exclusiv online!

Cort Trakker Tempest RS 150 Aquatexx, 150x320x230cm

201320
Livrare 7-14 zile

4.999,95Lei

Saltea Primire DAIWA Tip Cadita 160x80x30cm

Saltea Primire DAIWA Tip Cadita 160x80x30cm

d.18860.020
Livrare imediată!

599,12Lei

Geanta Avid Carp VS Carryall Medium, 50x30x30cm

Geanta Avid Carp VS Carryall Medium, 50x30x30cm

a0430090
Livrare imediată!

247,46Lei

Saltea Cantarire Zfish Floating Weight Sling, 120x60x30cm
Exclusiv online!

Saltea Cantarire Zfish Floating Weight Sling, 120x60x30cm

zf-3269
Livrare 48-72ore

258,80Lei

Cap Minciog Feeder Competition FCR1, 50x40x30cm

Cap Minciog Feeder Competition FCR1, 50x40x30cm

cz1413
Livrare imediată!

72,99Lei

Cap Minciog DAM OTT Spoon Net Shake And Dry, 50x40x30cm -53%

Cap Minciog DAM OTT Spoon Net Shake And Dry, 50x40x30cm

svs74990
Livrare imediată!

84,89Lei(-53%) 40,31Lei

Geanta Spinning cu Suport Lansete Carp Zoom EVA Tackle Bag 50x28x30cm

Geanta Spinning cu Suport Lansete Carp Zoom EVA Tackle Bag 50x28x30cm

cz0113
Livrare imediată!

289,00Lei

Geanta Energo Team Outdoor Deluxe 50x25x30cm -25%

Geanta Energo Team Outdoor Deluxe 50x25x30cm

73302000
Stoc epuizat

158,00Lei(-25%) 117,81Lei

Geanta Carryall Fox R-Series Medium 50x30x30cm -34%

Geanta Carryall Fox R-Series Medium 50x30x30cm

clu365
Stoc epuizat

247,46Lei(-34%) 162,78Lei

GEANTA DAIWA BLACK WIDOW CARRYALL 50X25X30CM -23%

GEANTA DAIWA BLACK WIDOW CARRYALL 50X25X30CM

d.18705.040
Stoc epuizat

275,40Lei(-23%) 211,86Lei

Geanta Carp Zoom Practic Fishing Camou 50x23x30cm -22%

Geanta Carp Zoom Practic Fishing Camou 50x23x30cm

cz7046
Stoc epuizat

178,00Lei(-22%) 139,23Lei

Geanta Abu Garcia Carabus Station Bag, 50x26x30cm -21%

Geanta Abu Garcia Carabus Station Bag, 50x26x30cm

1525869
Stoc epuizat

494,96Lei(-21%) 389,08Lei

Geanta RIVE Roller Bag, Black / Aqua Blue, Size L, 110x25x30cm

Geanta RIVE Roller Bag, Black / Aqua Blue, Size L, 110x25x30cm

90410370223
Stoc epuizat

657,46Lei

Geanta KORDA Compac Duffel Bag, 50x30x30cm, 30ltr

Geanta KORDA Compac Duffel Bag, 50x30x30cm, 30ltr

klug142
Stoc epuizat

329,95Lei

Afişare 1 - 20 din 23 (2 pagini)
Queries: 13, Total time: 2.125 ms [By time] [By id] [By file]
1 (0.096)
SELECT data
FROM `oc_session`
WHERE session_id = '4b3cb8bf7f0f66d79e515f6513'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.116)
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.147)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("54969", "2", "1001", "75", "1", "189.080000000000", "1"),("77983", "2", "1000", "271", "1", "107.080000000000", "2"),("205843", "1", "1000", "476", "1", "693.240000000000", "3"),("235145", "1", "1000", "11", "1", "179.240000000000", "4"),("228224", "1", "1001", "168", "1", "226.860000000000", "5"),("206423", "1", "1000", "476", "1", "441.130000000000", "6"),("205369", "1", "1000", "476", "1", "4201.640000000000", "7"),("230442", "2", "1", "11", "1", "503.460000000000", "8"),("186151", "1", "1001", "353", "1", "207.950000000000", "9"),("212585", "2", "1000", "370", "1", "217.480000000000", "10"),("166562", "1", "1001", "75", "1", "61.340000000000", "11"),("233502", "2", "4", "124", "1", "33.870000000000", "12"),("178143", "1", "1001", "75", "1", "242.860000000000", "13"),("62465", "2", "0", "24", "1", "99.000000000000", "14"),("82388", "2", "0", "168", "1", "136.790000000000", "15"),("68155", "2", "0", "11", "1", "178.030000000000", "16"),("84351", "2", "0", "75", "1", "117.000000000000", "17"),("198557", "2", "0", "122", "1", "326.960000000000", "18"),("232398", "2", "0", "725", "1", "552.490000000000", "19"),("244130", "1", "0", "73", "1", "277.270000000000", "20"),("150821", "1", "0", "357", "1", "197.480000000000", "21"),("141187", "1", "0", "353", "1", "249.950000000000", "22"),("59614", "2", "0", "324", "1", "43.210000000000", "23")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.099)
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.233)
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.161)
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.106)
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.255)
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.085)
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.078)
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.557)
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.112)
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