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

Produse ce potrivesc criteriilor de căutare


Maceta NGT Cu Maner Caucicucat + Husa, 50cm

Maceta NGT Cu Maner Caucicucat + Husa, 50cm

ngt-k-mach-165
Stoc epuizat

100,00Lei

Maceta NGT Cu Maner Caucicucat + Husa, 61cm

Maceta NGT Cu Maner Caucicucat + Husa, 61cm

ngt-k-mach-123
Stoc epuizat

129,00Lei

Husa FL Camuflaj 3 compartimente cu burta 205 cm Material Gros

Husa FL Camuflaj 3 compartimente cu burta 205 cm Material Gros

8111148960117
Stoc epuizat

109,90Lei

JUVELNIC FL CAUCIUCAT + HUSA 2.5MT DIAMETRU 45CM

JUVELNIC FL CAUCIUCAT + HUSA 2.5MT DIAMETRU 45CM

5511729797010
Stoc epuizat

123,37Lei

HUSA GAMO ARMA+LUNETA L=117CM

HUSA GAMO ARMA+LUNETA L=117CM

g.6212357
Stoc epuizat

255,20Lei

HUSA LISA WINCHESTER 132CM

HUSA LISA WINCHESTER 132CM

a8.bo.641904252
Stoc epuizat

267,85Lei

JUVELNIC FL CAUCIUCAT + HUSA 2.0MT DIAMETRU 40CM

JUVELNIC FL CAUCIUCAT + HUSA 2.0MT DIAMETRU 40CM

2511793532268
Stoc epuizat

46,60Lei

HUSA BLASER PT F16/F3 135CM

HUSA BLASER PT F16/F3 135CM

a8.bl.80405363
Stoc epuizat

941,37Lei

JUVELNIC FL CAUCIUCAT + HUSA 2.3MT DIAMETRU 30CM

JUVELNIC FL CAUCIUCAT + HUSA 2.3MT DIAMETRU 30CM

8511752348132
Stoc epuizat

69,90Lei

HUSA BLASER TIP C LODEN PT. CARABINA 105CM

HUSA BLASER TIP C LODEN PT. CARABINA 105CM

a8.bl.80405362
Stoc epuizat

1.120,68Lei

HUSA BROWNING PLAINSMAN TEXTIL CARABINA 122CM

HUSA BROWNING PLAINSMAN TEXTIL CARABINA 122CM

a8.bo.1410049248
Stoc epuizat

167,40Lei

HUSA ARROW TEXTIL CARABINA 130CM

HUSA ARROW TEXTIL CARABINA 130CM

ve.ntcb130
Stoc epuizat

296,94Lei

HUSA ARROW INT. PIELE CARABINA 120CM MARO BUZUNAR ACCES

HUSA ARROW INT. PIELE CARABINA 120CM MARO BUZUNAR ACCES

ve.npcb120acc.1
Stoc epuizat

549,90Lei

HUSA BENELLI CARABINE 124X26X8CM

HUSA BENELLI CARABINE 124X26X8CM

a8.b.800122
Stoc epuizat

302,00Lei

HUSA DELFIN PENTRU NAVOMODELE 87X30X30CM -21%

HUSA DELFIN PENTRU NAVOMODELE 87X30X30CM

4207186269597
Stoc epuizat

329,00Lei(-21%) 259,90Lei

Husa Arma Si Luneta 120CM Negru/Rosu Gamo

Husa Arma Si Luneta 120CM Negru/Rosu Gamo

g.6212367
Stoc epuizat

174,81Lei

HUSA GAMO ARMA+LUNETA 125CM NEAGRA

HUSA GAMO ARMA+LUNETA 125CM NEAGRA

g.6212374
Stoc epuizat

268,79Lei

HUSA BLASER TIP A CORDURA PT.SEMIAUTOMATA 134CM

HUSA BLASER TIP A CORDURA PT.SEMIAUTOMATA 134CM

a8.bl.80405372
Stoc epuizat

369,82Lei

Afişare 1181 - 1198 din 1198 (60 pagini)
Queries: 7, Total time: 37.203 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = 'e4ef2314d2655dde2ecbef303d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.140)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (31.155)
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 = '2' AND (MATCH(pd.tag) AGAINST('+husa' 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 (5.428)
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 1180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.161)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"GHEORGHE SH GABRIELA PFA"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.140)
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