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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Cap Minciog Maver Laser Gummy Cauciucat, 55x45cm 9x3mm
Exclusiv online!

Cap Minciog Maver Laser Gummy Cauciucat, 55x45cm 9x3mm

1962003
Livrare 48-72 ore

141,00Lei

Cap Minciog Maver Laser Gummy Cauciucat, 55x45cm 11x7mm
Exclusiv online!

Cap Minciog Maver Laser Gummy Cauciucat, 55x45cm 11x7mm

1962004
Livrare 48-72 ore

141,00Lei

Cap Minciog Maver Laser Gummy Cauciucat, 50x40cm 9x5mm

Cap Minciog Maver Laser Gummy Cauciucat, 50x40cm 9x5mm

1962002
Livrare imediată!

129,00Lei

Cap Minciog Maver Laser Gummy Cauciucat, 50x40cm 5x3mm
Exclusiv online!

Cap Minciog Maver Laser Gummy Cauciucat, 50x40cm 5x3mm

1962001
Livrare 48-72 ore

129,00Lei

Vobler Jackall TN60 Trigon, Baba Taku Akakin Laser, 6cm, 8.5g
Exclusiv online!

Vobler Jackall TN60 Trigon, Baba Taku Akakin Laser, 6cm, 8.5g

ja.807263978
Livrare 24-48 ore

111,24Lei

Vobler Jackall TN70 Trigon, Baba Taku Akakin Laser, 7cm, 31.5g
Exclusiv online!

Vobler Jackall TN70 Trigon, Baba Taku Akakin Laser, 7cm, 31.5g

ja.807264036
Livrare 24-48 ore

128,73Lei

Vobler Jackall TN50 Trigon, Baba Taku Akakin Laser, 5.2cm, 11.2g
Exclusiv online!

Vobler Jackall TN50 Trigon, Baba Taku Akakin Laser, 5.2cm, 11.2g

ja.807263893
Livrare 24-48 ore

104,92Lei

Twister Profiblinker Octopus Laser 10 Cm 5 Buc

Twister Profiblinker Octopus Laser 10 Cm 5 Buc

32-10-25
Livrare imediată!

13,20Lei

Vobler Biwaa Seven Section S5 13cm 34gr 13 Gardon Laser
Exclusiv online!

Vobler Biwaa Seven Section S5 13cm 34gr 13 Gardon Laser

b000292
Livrare 48-72 ore

109,00Lei

Lanseta Maver BOLOGNEZA LASER BLX EVO 4M
Exclusiv online!

Lanseta Maver BOLOGNEZA LASER BLX EVO 4M

5685400
Livrare 48-72 ore

661,00Lei

Vobler Biwaa Seven Section S4 10cm 17gr 13 Gardon Laser -21%

Vobler Biwaa Seven Section S4 10cm 17gr 13 Gardon Laser

b000290
Livrare imediată!

99,00Lei(-21%) 77,90Lei

MULINETA MAVER LASER 6000 10+1RUL
Exclusiv online!

MULINETA MAVER LASER 6000 10+1RUL

809mla60
Livrare 48-72 ore

405,00Lei

MULINETA MAVER LASER 4000 10+1RUL
Exclusiv online!

MULINETA MAVER LASER 4000 10+1RUL

809mla40
Livrare 48-72 ore

375,00Lei

MULINETA MAVER LASER 2000 10+1RUL
Exclusiv online!

MULINETA MAVER LASER 2000 10+1RUL

809mla20
Livrare 48-72 ore

339,99Lei

DISPOZITIV BUSHNELL REGLAT LUNETA CU LASER
Exclusiv online!

DISPOZITIV BUSHNELL REGLAT LUNETA CU LASER

vb.74.0100c
Livrare 24-48 ore

307,92Lei

Varga Maver IT LASER BLX EVOO 7M -25%

Varga Maver IT LASER BLX EVOO 7M

4760b700
Stoc epuizat

1.162,00Lei(-25%) 872,00Lei

JUVELNIC Maver IT LASER 3.0M patrat

JUVELNIC Maver IT LASER 3.0M patrat

8045300
Stoc epuizat

323,00Lei

Tripod Filfishing Filex Laser, 2 Posturi

Tripod Filfishing Filex Laser, 2 Posturi

fil6878
Stoc epuizat

319,99Lei

Binouclu Atn Lrf Laser Ballistics 2000, 10X42

Binouclu Atn Lrf Laser Ballistics 2000, 10X42

vat.bn1042lrf2k
Stoc epuizat

2.741,11Lei

Afişare 1 - 19 din 19 (1 pagini)
Queries: 11, Total time: 3.275 ms [By time] [By id] [By file]
1 (0.091)
SELECT data
FROM `oc_session`
WHERE session_id = 'd5003cf5b9966f2620d1e2cc3e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.119)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (1.708)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (MATCH(pd.tag) AGAINST('+laser' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
5 (0.131)
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:1561
6 (0.356)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.162)
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:1248
8 (0.081)
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:1270
9 (0.076)
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:1035
10 (0.347)
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:949
11 (0.106)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38