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


Umbrela Baracuda Sheleter U5 250cm -34%

Umbrela Baracuda Sheleter U5 250cm

shelteru5
Stoc epuizat

393,40Lei(-34%) 261,03Lei

Umbrela Baracuda Shelter U2 220cm

Umbrela Baracuda Shelter U2 220cm

shelter u2
Livrare imediată!

393,40Lei

UMBRELA BARACUDA SHELTER U3 UT25

UMBRELA BARACUDA SHELTER U3 UT25

shelter u3
Livrare imediată!

270,56Lei

UMBRELA BARACUDA SHELTER U4 220cm OUT22

UMBRELA BARACUDA SHELTER U4 220cm OUT22

shelter u4 out22
Livrare imediată!

376,10Lei

Fox Easy Shelter+ -16%
Exclusiv online!

Fox Easy Shelter+

cum287
Livrare 7-14 zile

899,96Lei(-16%) 758,14Lei

CORT JRC DEFENDER SHELTER 280x200x135cm

CORT JRC DEFENDER SHELTER 280x200x135cm

1441620
Livrare imediată!

749,37Lei

Adapost Shakespeare Salt Beach Shelter
Exclusiv online!

Adapost Shakespeare Salt Beach Shelter

1545369
Livrare 7-14 zile

727,00Lei

Brolly Korum Recoil Shelter, 260x160x140cm
Exclusiv online!

Brolly Korum Recoil Shelter, 260x160x140cm

k0370010
Livrare 7-14 zile

710,19Lei

Adapost Nash Titan Hide Shelter -10%

Adapost Nash Titan Hide Shelter

t4296
Livrare imediată!

1.269,99Lei(-10%) 1.139,72Lei

Cort Solar SP Cube Shelter, 2.40x2.40x2.40cm -8%

Cort Solar SP Cube Shelter, 2.40x2.40x2.40cm

bv14mk2
Livrare imediată!

2.555,50Lei(-8%) 2.339,60Lei

Pavilion Fox EOS Social Shelter, 340x290x205cm

Pavilion Fox EOS Social Shelter, 340x290x205cm

cum342
Livrare imediată!

1.649,10Lei

Adapost Nash Titan Hide Pro Shelter
Exclusiv online!

Adapost Nash Titan Hide Pro Shelter

t4298
Livrare 7-14 zile

1.699,06Lei

CORT KORUM DAY SHELTER LITE 140X195X170CM
Exclusiv online!

CORT KORUM DAY SHELTER LITE 140X195X170CM

k0370003
Livrare 7-14 zile

641,55Lei

Umbrela Shelter Energo Team 2.20m

Umbrela Shelter Energo Team 2.20m

73749221
Livrare imediată!

270,35Lei

Pavilion Tip Cort FOX Social Shelter, 200x200x240cm -26%

Pavilion Tip Cort FOX Social Shelter, 200x200x240cm

cum292
Livrare imediată!

2.699,95Lei(-26%) 1.996,98Lei

CORT CARP ZOOM INSTAQUICK SHELTER 180x180x205cm -29%
Exclusiv online!

CORT CARP ZOOM INSTAQUICK SHELTER 180x180x205cm

cz5196
Livrare 48-72 ore

960,00Lei(-29%) 685,21Lei

UMRELA CARP ZOOM EXPEDITION SHELTER 240x150x140cm
Exclusiv online!

UMRELA CARP ZOOM EXPEDITION SHELTER 240x150x140cm

cz0008
Livrare 48-72 ore

671,99Lei

Cort Carp Zoom Expedition Shelter 260x170x135cm
Exclusiv online!

Cort Carp Zoom Expedition Shelter 260x170x135cm

cz3499
Livrare 48-72 ore

845,86Lei

BROLLY MIVARDI SHELTER PREMIUM XL + FRONT PANEL

BROLLY MIVARDI SHELTER PREMIUM XL + FRONT PANEL

m-sheprxlset
Livrare imediată!

814,45Lei

Cort Zfish Classic Shelter ZFP, 140x150x260cm
Exclusiv online!

Cort Zfish Classic Shelter ZFP, 140x150x260cm

zf-2475
Livrare 48-72ore

709,85Lei

Afişare 1 - 20 din 50 (3 pagini)
Queries: 13, Total time: 2.601 ms [By time] [By id] [By file]
1 (0.074)
SELECT data
FROM `oc_session`
WHERE session_id = '9872922df5e951034db7f80faf'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.137)
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.193)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("169198", "2", "0", "280", "1", "215.730000000000", "1"),("117072", "4", "2", "280", "1", "325.120000000000", "2"),("117073", "4", "2", "280", "1", "223.600000000000", "3"),("117074", "4", "2", "280", "1", "310.830000000000", "4"),("164937", "2", "1000", "168", "1", "626.560000000000", "5"),("148079", "2", "1001", "121", "1", "619.310000000000", "6"),("173672", "1", "1000", "191", "1", "600.830000000000", "7"),("231194", "1", "1000", "357", "1", "586.930000000000", "8"),("167285", "2", "1", "59", "1", "941.920000000000", "9"),("207397", "1", "1001", "173", "1", "1933.550000000000", "10"),("219997", "1", "1001", "168", "1", "1362.890000000000", "11"),("167286", "2", "1000", "59", "1", "1404.180000000000", "12"),("151379", "2", "1000", "357", "1", "530.210000000000", "13"),("62475", "2", "1002", "24", "1", "223.430000000000", "14"),("112318", "1", "2", "168", "1", "1650.400000000000", "15"),("84129", "2", "1000", "75", "1", "566.290000000000", "16"),("84341", "2", "1000", "75", "1", "555.360000000000", "17"),("55024", "2", "1000", "75", "1", "699.060000000000", "18"),("35507", "2", "2", "98", "1", "673.100000000000", "19"),("220354", "1", "1000", "743", "1", "586.650000000000", "20"),("55026", "2", "1", "75", "1", "210.830000000000", "21"),("159153", "2", "1005", "75", "1", "220.070000000000", "22"),("207395", "1", "1001", "173", "1", "842.830000000000", "23"),("209185", "2", "1001", "75", "1", "400.740000000000", "24"),("243376", "1", "1000", "357", "1", "757.090000000000", "25"),("242851", "2", "1000", "75", "1", "202.420000000000", "26"),("237762", "2", "1003", "464", "1", "126.830000000000", "27"),("207393", "1", "1002", "173", "1", "1429.390000000000", "28"),("246623", "1", "1001", "168", "1", "2315.830000000000", "29"),("179986", "2", "1000", "290", "1", "209.150000000000", "30"),("146343", "1", "3", "98", "1", "924.360000000000", "31"),("199483", "2", "1003", "648", "1", "369.740000000000", "32"),("248688", "1", "2", "353", "1", "1680.660000000000", "33"),("247523", "1", "1000", "294", "1", "444.360000000000", "34"),("180353", "2", "1000", "680", "1", "47.800000000000", "35"),("171273", "1", "0", "59", "1", "2017.630000000000", "36"),("121104", "2", "0", "98", "1", "524.120000000000", "37"),("106576", "1", "0", "98", "1", "913.790000000000", "38"),("117340", "2", "0", "280", "1", "21.420000000000", "39"),("224638", "1", "0", "168", "1", "2147.210000000000", "40"),("151381", "2", "0", "357", "1", "388.850000000000", "41"),("130083", "2", "0", "75", "1", "398.000000000000", "42"),("114554", "4", "0", "394", "1", "286.180000000000", "43"),("229880", "2", "0", "42", "1", "359.000000000000", "44"),("229881", "2", "0", "42", "1", "359.000000000000", "45"),("229883", "2", "0", "42", "1", "461.000000000000", "46"),("217407", "2", "0", "476", "1", "76.410000000000", "47"),("229882", "2", "0", "42", "1", "510.000000000000", "48"),("190291", "2", "0", "287", "1", "202.760000000000", "49"),("114400", "2", "0", "75", "1", "173.470000000000", "50")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.132)
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.248)
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.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.140)
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
9 (0.284)
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.083)
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.081)
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.893)
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.136)
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