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


Nada Fish Pro Special, Clean 1kg

Nada Fish Pro Special, Clean 1kg

nfp-spc
Livrare imediată!

13,90Lei

Norfin sac de dormit NORDIC 500 Right Fermoar pe stanga
Exclusiv online!

Norfin sac de dormit NORDIC 500 Right Fermoar pe stanga

nf-30219
Livrare 48-72ore

345,00Lei

Borseta Sensas P&M Eaux Source M, 56x20cm
Exclusiv online!

Borseta Sensas P&M Eaux Source M, 56x20cm

a8.spm.32767
Livrare 24-48 ore

131,07Lei

Borseta Sensas P&M Eaux Source S, 35x18x16cm
Exclusiv online!

Borseta Sensas P&M Eaux Source S, 35x18x16cm

a8.spm.32722
Livrare 24-48 ore

147,00Lei

Mulineta Sensas Pezon&Michel Specialist FXC FV 4500
Exclusiv online!

Mulineta Sensas Pezon&Michel Specialist FXC FV 4500

spm.09251
Livrare 24-48 ore

451,06Lei

Geanta Sensas P&M Eaux Source M, 35x12x26cm
Exclusiv online!

Geanta Sensas P&M Eaux Source M, 35x12x26cm

a8.spm.32212
Livrare 24-48 ore

114,84Lei

Geanta Sensas P&M Eaux Source S, 25x13x23cm
Exclusiv online!

Geanta Sensas P&M Eaux Source S, 25x13x23cm

a8.spm.32361
Livrare 24-48 ore

163,53Lei

MULINETA SENSAS P&M TITAN TRACK FV 650 5RUL 250MX0.50MM 4.5:1

MULINETA SENSAS P&M TITAN TRACK FV 650 5RUL 250MX0.50MM 4.5:1

spm.61329
Livrare imediată!

361,71Lei

Lanseta Sensas Pezon&Michel Eaux Vives Source Boost 1.80m 2-7g 2seg

Lanseta Sensas Pezon&Michel Eaux Vives Source Boost 1.80m 2-7g 2seg

spm.71186
Livrare imediată!

212,78Lei

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 VIB&BLADE SPEC. 2,08M/4-21G -20%
Exclusiv online!

LANSETA SPINNING SAVAGE GEAR 2BUC SG4 VIB&BLADE SPEC. 2,08M/4-21G

svs75805
Livrare 7-14 zile

597,55Lei(-20%) 478,03Lei

MULINETA SENSAS Pezon&Michel REDOUTABLE Z-CAST FD 40 3RUL 310MX0.25MM 5.0:1

MULINETA SENSAS Pezon&Michel REDOUTABLE Z-CAST FD 40 3RUL 310MX0.25MM 5.0:1

spm.61428
Livrare imediată!

196,25Lei

VOBLER JAXON HS FAT PIKE 2 SEC F FP 16CM 45GR -22%

VOBLER JAXON HS FAT PIKE 2 SEC F FP 16CM 45GR

vj-ph16fp
Stoc epuizat

61,00Lei(-22%) 47,60Lei

Norfin sac de dormit NORDIC 500 Right Fermoar pe dreapta -17%

Norfin sac de dormit NORDIC 500 Right Fermoar pe dreapta

nf-30220
Stoc epuizat

345,00Lei(-17%) 286,00Lei

VESTA SENSAS P&M PESCAR RAPITOR 50x30cm -23%

VESTA SENSAS P&M PESCAR RAPITOR 50x30cm

a8.spm.32803
Stoc epuizat

243,74Lei(-23%) 187,48Lei

Porumb Flotant Silicon C&B SPD-TTX, 10 buc/cutie + 2 Fluo -27%

Porumb Flotant Silicon C&B SPD-TTX, 10 buc/cutie + 2 Fluo

6427416146148
Stoc epuizat

12,99Lei(-27%) 9,52Lei

Sac de Dormit JRC Defender Sleeping Bag&Cover, 3 Sezoane -49%

Sac de Dormit JRC Defender Sleeping Bag&Cover, 3 Sezoane

1441639
Stoc epuizat

591,00Lei(-49%) 300,21Lei

MULINETA SENSAS Pezon&Michel SPEC.GOLD MEDAL FV 50 5RUL 220MX0.25MM 5.1:1 -23%

MULINETA SENSAS Pezon&Michel SPEC.GOLD MEDAL FV 50 5RUL 220MX0.25MM 5.1:1

spm.61421
Stoc epuizat

253,85Lei(-23%) 195,27Lei

Afişare 1 - 17 din 17 (1 pagini)
Queries: 14, Total time: 1.949 ms [By time] [By id] [By file]
1 (0.128)
SELECT data
FROM `oc_session`
WHERE session_id = '9ec85bff3d89a50759cc5c2e15'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.131)
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.118)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("193897", "1", "1005", "654", "1", "16.320000000000", "1"),("142329", "2", "1000", "332", "1", "289.920000000000", "2"),("149601", "2", "1000", "62", "1", "110.140000000000", "3"),("203021", "2", "1000", "62", "1", "123.530000000000", "4"),("159317", "1", "1000", "62", "1", "379.040000000000", "5"),("149599", "2", "1000", "62", "1", "96.500000000000", "6"),("203023", "2", "1000", "62", "1", "137.420000000000", "7"),("149723", "2", "1001", "62", "1", "303.960000000000", "8"),("149737", "1", "1001", "62", "1", "178.810000000000", "9"),("146589", "2", "1000", "85", "1", "401.710000000000", "10"),("149727", "1", "1001", "62", "1", "164.920000000000", "11"),("51045", "2", "0", "42", "1", "40.000000000000", "12"),("142331", "2", "0", "332", "1", "240.340000000000", "13"),("159293", "2", "0", "62", "1", "157.550000000000", "14"),("169737", "2", "0", "625", "1", "8.000000000000", "15"),("147965", "2", "0", "121", "1", "252.280000000000", "16"),("149725", "1", "0", "62", "1", "164.090000000000", "17")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.122)
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.211)
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.086)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.085)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.070)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CB NADA SHOP SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.158)
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
11 (0.116)
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
12 (0.101)
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
13 (0.412)
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
14 (0.116)
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