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


Blank Harrison Ballista Spod 3.90m 5.00lbs 2seg
Exclusiv online!

Blank Harrison Ballista Spod 3.90m 5.00lbs 2seg

bal13spod-blank
Livrare 30-60 zile

930,00Lei

Catapulta Nash Spot On Ball Blaster Small -38%

Catapulta Nash Spot On Ball Blaster Small

t2880
Livrare imediată!

49,99Lei(-38%) 31,01Lei

Sapca, Nash, Tackle, Baseball, Cap, Black, c1155, Sepci, Sepci Nash, Nash

Sapca, Nash, Tackle, Baseball, Cap, Black, c1155, Sepci, Sepci Nash, Nash

c1155
Livrare imediată!

45,01Lei

Sapca, Nash, Tackle, Baseball, Cap, Green, c1156, Sepci, Sepci Nash, Nash

Sapca, Nash, Tackle, Baseball, Cap, Green, c1156, Sepci, Sepci Nash, Nash

c1156
Livrare imediată!

49,99Lei

Plumb, Cheburashka, Zeck, Cat, Fireball, Pro, Black, 50g, 40305150001, Plumbi Cheburashka, Plumbi Cheburashka Zeck, Zeck
Exclusiv online!

Plumb, Cheburashka, Zeck, Cat, Fireball, Pro, Black, 50g, 40305150001, Plumbi Cheburashka, Plumbi Cheburashka Zeck, Zeck

40305150001
Livrare 48-72 ore

49,77Lei

Blank, Harrison, Ballista, , 3.90m, 4.00lbs, 2seg, bal1304-blank, Blankuri, Blankuri Harrison, Blankuri Harrison, Harrison
Exclusiv online!

Blank, Harrison, Ballista, , 3.90m, 4.00lbs, 2seg, bal1304-blank, Blankuri, Blankuri Harrison, Blankuri Harrison, Harrison

bal1304-blank
Livrare 30-60 zile

1.104,00Lei

Blank Harrison Ballista Spod 3.60m 4.00lbs 2seg
Exclusiv online!

Blank Harrison Ballista Spod 3.60m 4.00lbs 2seg

bal12spod-blank
Livrare 30-60 zile

888,00Lei

CORDON BALLISTOL PT CURATAT ARMA GLONT/LISA
Exclusiv online!

CORDON BALLISTOL PT CURATAT ARMA GLONT/LISA

vk.23265
Livrare 24-48 ore

180,44Lei

Spray Ballistol Pump Sensitive Contra Tantarilor / Capuselor, 100ml

Spray Ballistol Pump Sensitive Contra Tantarilor / Capuselor, 100ml

vk.26915.ro
Livrare imediată!

44,39Lei

Ballistol, Spray, Autoaparare, Piper, 15ml, vk.24436.ro, Autoaparare, Autoaparare Ballistol, Autoaparare Ballistol, Ballistol
Exclusiv online!

Ballistol, Spray, Autoaparare, Piper, 15ml, vk.24436.ro, Autoaparare, Autoaparare Ballistol, Autoaparare Ballistol, Ballistol

vk.24436.ro
Livrare 24-48 ore

35,02Lei

Ballistol Spray Autoaparare Piper-jet 100ml

Ballistol Spray Autoaparare Piper-jet 100ml

vk.24491.ro
Livrare imediată!

67,48Lei

Spray Ballistol Auto Aparare Anticaine, 50ml

Spray Ballistol Auto Aparare Anticaine, 50ml

vk.24000.ro
Livrare imediată!

30,37Lei

Ballistol, Spray, Autoaparare, Piper-Dispersat, 50ml, VK.24404.RO, Autoaparare, Autoaparare Ballistol, Autoaparare Ballistol, Ballistol
Ballistol, Spray, Autoaparare, Piper-Dispersat, Fog, 100ml, VK.24405.RO, Autoaparare, Autoaparare Ballistol, Autoaparare Ballistol, Ballistol
Bile Airsoft Umarex Powerballs Cauciuc CAL.43 0.72G 100BUC
Exclusiv online!

Bile Airsoft Umarex Powerballs Cauciuc CAL.43 0.72G 100BUC

vu.2.4772
Livrare 24-48 ore

95,00Lei

CUTIE PELETE BALLISTOL LANA PT CURATAT TEAVA CAL.30.06/300WM/308W 60BUC/PL

CUTIE PELETE BALLISTOL LANA PT CURATAT TEAVA CAL.30.06/300WM/308W 60BUC/PL

vk.23206
Livrare imediată!

51,54Lei

CUTIE BILE UMAREX AIRSOFT POWERBALLS CAUCIUC CAL.43 1,3G 430BUC

CUTIE BILE UMAREX AIRSOFT POWERBALLS CAUCIUC CAL.43 1,3G 430BUC

vu.2.4770.1
Livrare imediată!

245,00Lei

CUTIE PELETE BALLISTOL LANA PT CURATAT TEAVA CAL.12 30BUC/PL
Exclusiv online!

CUTIE PELETE BALLISTOL LANA PT CURATAT TEAVA CAL.12 30BUC/PL

vk.23241
Livrare 24-48 ore

59,27Lei

CUTIE PELETE BALLISTOL LANA PT CURATAT TEAVA CAL.8X57/8X64/8X68 60BUC/PL
Exclusiv online!

CUTIE PELETE BALLISTOL LANA PT CURATAT TEAVA CAL.8X57/8X64/8X68 60BUC/PL

vk.23210
Livrare 24-48 ore

51,54Lei

CUTIE PELETE BALLISTOL LANA PT CURATAT TEAVA CAL.338/9,3X62/375 60BUC/PL
Exclusiv online!

CUTIE PELETE BALLISTOL LANA PT CURATAT TEAVA CAL.338/9,3X62/375 60BUC/PL

vk.23214
Livrare 24-48 ore

61,84Lei

Afişare 281 - 300 din 418 (21 pagini)
Queries: 10, Total time: 241.225 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = '29237094e8e01059a13decbbd2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (234.688)
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 = '0' AND (pd.tag LIKE "%ball%") 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:698
4 (0.247)
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
5 (1.901)
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 280, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.458)
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:1209
7 (0.079)
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:1231
8 (0.121)
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:996
9 (3.388)
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:910
10 (0.129)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38