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


SHAD Relax Ohio 5CM Standard S067R
Exclusiv online!

SHAD Relax Ohio 5CM Standard S067R

oh2-s067r-b
Livrare 48-72ore

9,00Lei

Shad Relax Diamond Standard S067R 7.5cm 10buc/plic

Shad Relax Diamond Standard S067R 7.5cm 10buc/plic

ds3-s067r
Livrare imediată!

24,00Lei

Shad Relax Diamond Standard 6.2cm S067R 10buc/plic
Exclusiv online!

Shad Relax Diamond Standard 6.2cm S067R 10buc/plic

ds25-s067r
Livrare 48-72ore

17,01Lei

CUTIE PLANO 1 SETAR RABATABIL
Exclusiv online!

CUTIE PLANO 1 SETAR RABATABIL

6101-06
Livrare 48-72ore

189,00Lei

SLIDER COLMIC AERO BLINDO SCORR. 18 gr
Exclusiv online!

SLIDER COLMIC AERO BLINDO SCORR. 18 gr

gcablsd
Livrare 48-72 ore

43,99Lei

SLIDER COLMIC AERO BLINDO SCORR. 20 gr
Exclusiv online!

SLIDER COLMIC AERO BLINDO SCORR. 20 gr

gcablse
Livrare 48-72 ore

43,99Lei

BASTON EXTENSIBIL UMAREX WALTHER PRO SECUR L=40 CM + SUPORT

BASTON EXTENSIBIL UMAREX WALTHER PRO SECUR L=40 CM + SUPORT

vu.2.1914
Livrare imediată!

100,52Lei

Cort Sloar Quick Up Shelter Green MkII With Heavy Duty Ground Sheet, 2.50x2.05x1.70cm -7%
Exclusiv online!

Cort Sloar Quick Up Shelter Green MkII With Heavy Duty Ground Sheet, 2.50x2.05x1.70cm

bv01mk2
Livrare 7-14 zile

2.132,83Lei(-7%) 1.989,89Lei

Lanseta Colmic Telematch Stor Siluro 4.20m 300g
Exclusiv online!

Lanseta Colmic Telematch Stor Siluro 4.20m 300g

cast70a
Livrare 48-72 ore

879,01Lei

Shad Lake Fork Live Baby 5.71cm Sour Grape

Shad Lake Fork Live Baby 5.71cm Sour Grape

01-2500-221
Livrare imediată!

21,50Lei

Lingurita ABU GARCIA Stor Zigge, Minnow, 18g, 5cm, 1buc/pac
Exclusiv online!

Lingurita ABU GARCIA Stor Zigge, Minnow, 18g, 5cm, 1buc/pac

1579814
Livrare 7-14 zile

20,00Lei

Lingurita ABU GARCIA Stor Zigge, Ayu Green, 18g, 5cm, 1buc/pac
Exclusiv online!

Lingurita ABU GARCIA Stor Zigge, Ayu Green, 18g, 5cm, 1buc/pac

1579813
Livrare 7-14 zile

20,00Lei

KIT PRINDERE LANT. SEO PE CASCA LED LENSER
Exclusiv online!

KIT PRINDERE LANT. SEO PE CASCA LED LENSER

a8.z0368
Livrare 24-48 ore

48,50Lei

Shad Relax Ohio Standard, S057R, 7.5cm, 10buc/plic -41%

Shad Relax Ohio Standard, S057R, 7.5cm, 10buc/plic

oh25-s057r
Stoc epuizat

24,00Lei(-41%) 14,28Lei

Shad Relax Kopyto Standard Blister, S067R, 0.7g, 3cm, 8buc/plic -33%

Shad Relax Kopyto Standard Blister, S067R, 0.7g, 3cm, 8buc/plic

bls1-s067r-b
Stoc epuizat

9,00Lei(-33%) 6,00Lei

SPRAY AUTOAPARARE WALTHER PRO SECUR PIPER JET GEL 50ML -24%

SPRAY AUTOAPARARE WALTHER PRO SECUR PIPER JET GEL 50ML

vu.2.2022
Stoc epuizat

130,17Lei(-24%) 99,38Lei

LANTERNA LENSER DE CAP LED NEO6R BLUE, 240 LUMENI 1XLI-ION -24%

LANTERNA LENSER DE CAP LED NEO6R BLUE, 240 LUMENI 1XLI-ION

a8.z500918
Stoc epuizat

153,50Lei(-24%) 116,29Lei

Lingurita ABU GARCIA Stor Zigge, Pink Glitter, 18g, 5cm, 1buc/pac -24%

Lingurita ABU GARCIA Stor Zigge, Pink Glitter, 18g, 5cm, 1buc/pac

1579812
Stoc epuizat

20,00Lei(-24%) 15,29Lei

Lingurita ABU GARCIA Stor Zigge, Glitter RBT, 18g, 5cm, 1buc/pac -24%

Lingurita ABU GARCIA Stor Zigge, Glitter RBT, 18g, 5cm, 1buc/pac

1579816
Stoc epuizat

20,00Lei(-24%) 15,29Lei

Lingurita ABU GARCIA Stor Zigge, Golden Minnow, 18g, 5cm, 1buc/pac -24%

Lingurita ABU GARCIA Stor Zigge, Golden Minnow, 18g, 5cm, 1buc/pac

1579815
Stoc epuizat

20,00Lei(-24%) 15,29Lei

Afişare 1 - 20 din 22 (2 pagini)
Queries: 16, Total time: 2.282 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = '5b2f06103fd84c99a08657a9c9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.124)
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.103)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("142353", "2", "1000", "48", "1", "7.560000000000", "1"),("139933", "2", "1001", "48", "1", "20.170000000000", "2"),("139873", "2", "1000", "48", "1", "14.290000000000", "3"),("32898", "2", "1000", "174", "1", "158.820000000000", "4"),("14228", "2", "1000", "115", "1", "36.970000000000", "5"),("14229", "2", "1000", "115", "1", "36.970000000000", "6"),("149819", "4", "1", "246", "1", "84.470000000000", "7"),("207393", "1", "1000", "173", "1", "1672.180000000000", "8"),("80249", "2", "1000", "115", "1", "738.660000000000", "9"),("87739", "2", "1005", "310", "1", "18.070000000000", "10"),("239099", "2", "1000", "122", "1", "16.810000000000", "11"),("239100", "2", "1000", "122", "1", "16.810000000000", "12"),("22486", "2", "1000", "53", "1", "40.760000000000", "13"),("197779", "2", "0", "48", "1", "12.000000000000", "14"),("197807", "2", "0", "48", "1", "5.040000000000", "15"),("94292", "10", "0", "246", "1", "83.510000000000", "16"),("68210", "2", "0", "53", "1", "97.720000000000", "17"),("239098", "2", "0", "122", "1", "12.850000000000", "18"),("239102", "2", "0", "122", "1", "12.850000000000", "19"),("239103", "2", "0", "122", "1", "12.850000000000", "20"),("239101", "2", "0", "122", "1", "12.850000000000", "21"),("46099", "2", "0", "289", "1", "8.400000000000", "22")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.120)
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.241)
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.136)
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.139)
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.121)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.161)
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
11 (0.098)
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
12 (0.199)
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
13 (0.080)
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
14 (0.075)
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
15 (0.367)
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
16 (0.093)
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