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 300 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


PISTOL UMAREX CO2 AIRSOFT GLOCK 17 6MM 13BB 1.3J

PISTOL UMAREX CO2 AIRSOFT GLOCK 17 6MM 13BB 1.3J

vu.2.6428
Livrare imediată!

774,12Lei

PISTOL UMAREX CO2 AIRSOFT GLOCK 22 GEN4 6MM 15BB 2J
Exclusiv online!

PISTOL UMAREX CO2 AIRSOFT GLOCK 22 GEN4 6MM 15BB 2J

vu.2.6439
Livrare 24-48 ore

825,71Lei

PISTOL UMAREX CO2 AIRSOFT GLOCK 19 6MM 11BB 2J
Exclusiv online!

PISTOL UMAREX CO2 AIRSOFT GLOCK 19 6MM 11BB 2J

vu.2.6418
Livrare 24-48 ore

567,70Lei

Carabina CO2 Airsoft Umarex Legend Cowboy Rifle Renegade 6mm, 10bb, 4j -35%

Carabina CO2 Airsoft Umarex Legend Cowboy Rifle Renegade 6mm, 10bb, 4j

vu.2.6506
Livrare imediată!

1.980,49Lei(-35%) 1.289,41Lei

Carabina CO2 Airsoft Umarex Legend Cowboy Antique 6mm, 10bb, 4j

Carabina CO2 Airsoft Umarex Legend Cowboy Antique 6mm, 10bb, 4j

vu.2.6388
Livrare imediată!

1.622,53Lei

Pistol Airsoft CO2 Umarex Glock 22 GEN4 6MM 15BB 2J

Pistol Airsoft CO2 Umarex Glock 22 GEN4 6MM 15BB 2J

vu.2.6427
Livrare imediată!

597,63Lei

Minciog Mivardi Classic Eco 210 -29%

Minciog Mivardi Classic Eco 210

m-poeco21
Livrare imediată!

88,00Lei(-29%) 62,90Lei

PISTOL UMAREX CO2 AIRSOFT BERETTA 90TWO 6MM 15BB 2J 17L69133

PISTOL UMAREX CO2 AIRSOFT BERETTA 90TWO 6MM 15BB 2J 17L69133

vu.2.5913
Livrare imediată!

407,29Lei

PISTOL UMAREX CO2 AIRSOFT WALTHER P99 DAO 6MM 15BB 2J 16L63593

PISTOL UMAREX CO2 AIRSOFT WALTHER P99 DAO 6MM 15BB 2J 16L63593

vu.2.5684
Livrare imediată!

540,86Lei

PISTOL UMAREX CO2 AIRSOFT HEKLER KOCH USP 6MM 16BB 2J 17L04541
Exclusiv online!

PISTOL UMAREX CO2 AIRSOFT HEKLER KOCH USP 6MM 16BB 2J 17L04541

vu.2.5561
Livrare 24-48 ore

550,26Lei

REVOLVER UMAREX CO2 AIRSOFT RUGER SUPERHAWK.8 6MM 8BB 4J 17C01791
Exclusiv online!

REVOLVER UMAREX CO2 AIRSOFT RUGER SUPERHAWK.8 6MM 8BB 4J 17C01791

vu.2.5680
Livrare 24-48 ore

722,43Lei

Pistol Umarex CO2 Airsoft Ruger P345 6 MM 15BB 2,8J

Pistol Umarex CO2 Airsoft Ruger P345 6 MM 15BB 2,8J

vu.2.5637
Livrare imediată!

351,42Lei

Capsule Umarex Walther CO2 Special Oil 12g, 10buc/pac
Exclusiv online!

Capsule Umarex Walther CO2 Special Oil 12g, 10buc/pac

vu.4.1682.1
Livrare 24-48 ore

52,75Lei

PISTOL UMAREX CO2 AIRSOFT COP SK 6MM PLUS AMORTIZOR

PISTOL UMAREX CO2 AIRSOFT COP SK 6MM PLUS AMORTIZOR

vu.2.5958
Livrare imediată!

301,42Lei

CAPSULE UMAREX CO2 12 GRAME 25BUC/BOX

CAPSULE UMAREX CO2 12 GRAME 25BUC/BOX

vu.4.1687.1
Livrare imediată!

105,76Lei

ARMA UMAREX SEMIAUTOMATA CO2 AIRSOFT HEKLER KOCH MP5 K 6MM

ARMA UMAREX SEMIAUTOMATA CO2 AIRSOFT HEKLER KOCH MP5 K 6MM

vu.2.5786
Livrare imediată!

706,10Lei

PISTOL UMAREX CO2 AIRSOFT LEGEND P08 6MM 15BB 2J
Exclusiv online!

PISTOL UMAREX CO2 AIRSOFT LEGEND P08 6MM 15BB 2J

vu.2.5874
Livrare 24-48 ore

488,91Lei

PISTOL UMAREX CO2 AIRSOFT HEKLER KOCH HK45 6MM

PISTOL UMAREX CO2 AIRSOFT HEKLER KOCH HK45 6MM

vu.2.5978
Livrare imediată!

407,29Lei

BUTELIE UMAREX CO2 PT 1250 DOMINATOR -17%
Exclusiv online!

BUTELIE UMAREX CO2 PT 1250 DOMINATOR

v.w465.123
Livrare 24-48 ore

849,70Lei(-17%) 706,72Lei

Revolver Umarex CO2 Airsoft Ruger Superhawk 8CR 6mm, 8bb, 4j -25%

Revolver Umarex CO2 Airsoft Ruger Superhawk 8CR 6mm, 8bb, 4j

vu.2.5681
Livrare imediată!

865,09Lei(-25%) 650,62Lei

Afişare 1 - 20 din 30 (2 pagini)
Queries: 13, Total time: 190.602 ms [By time] [By id] [By file]
1 (0.096)
SELECT data
FROM `oc_session`
WHERE session_id = 'df36060870ba11dd6b5855c219'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.081)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (189.051)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%co2%") 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:697
5 (0.109)
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:1547
6 (0.327)
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:181
7 (0.184)
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:1204
8 (0.088)
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:1223
9 (0.071)
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:982
10 (0.276)
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:904
11 (0.077)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.080)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.084)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38