Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

HAWKE RED DOT SIGHT REFLEX DIGITAL CONTROL

vd.12141

Stoc epuizat

828,84Lei

BINOCLU MINOX BINOCLU BLUE 8X25

vm.62062

Stoc epuizat

176,68Lei

LUNETA BUSHNELL FORGE 1-8X30 G4/IR ULTRA SFP/34MM

vb.rf1830bs9

Stoc epuizat

3.474,21Lei

BINOCLU BUSHNELL 10X42 JUMELLES BLACK

vb.21.0142

Stoc epuizat

358,40Lei

LUNETA ZEISS VICTORY V8 4,8-35X60/IR60/ASV

vz.522147asv.60

Stoc epuizat

17.168,30Lei

CORDON BUSHNELL DEN PT.CURATAT CARABINA CAL.5.6MM

vb.24011d

Stoc epuizat

84,50Lei

DISPOZITIV GARMIN DE MONITORIZARE PRIN GPSMAP 66I EMEA

hg.010.02088.02

Stoc epuizat

2.699,73Lei

SISTEM MONITORIZARE GARMIN GPSMAP 86I WW

hg.010.02236.01

Stoc epuizat

2.994,69Lei

BINOCLU BUSHNELL BINOCLU 10X50 LEGEND BLACK

vb.bb1050w

Stoc epuizat

1.401,61Lei

Luneta Bushnell Engage 3-12X56 G4 IR 30mm

vb.re3125bs9

Stoc epuizat

2.060,31Lei

MONOCULAR BUSHNELL NIGHT VISION EQUINOX Z2 4.5X40

vb.26.0240

Stoc epuizat

2.556,62Lei

BINOCLU BUSHNELL BINOCLU 8X42 LEGEND BLACK

vb.bb842w

Stoc epuizat

1.051,17Lei

DISPOZITIV GARMIN DE MONITORIZARE GPS ALPHA 10

hg.010.02290.55

Stoc epuizat

2.128,01Lei

LUNETA ZEISS V8 M 4,8-35X60/RS 60 ASV

vz.m522140asv.60

Stoc epuizat

19.440,60Lei

Luneta Blaser B2 2 12x50IC

vbl.80110896

Stoc epuizat

9.264,28Lei

Binouclu Atn Lrf Laser Ballistics 2000, 10X42

vat.bn1042lrf2k

Stoc epuizat

2.741,11Lei

Dispozitiv de Monitorizare prin GPS Map Garmin 65S Multiband

hg.010.02451.11

Stoc epuizat

2.229,00Lei

Binoclu Hawke Endurace Ed Black, 10x50

vd.36208

Stoc epuizat

1.910,45Lei

Luneta Blaser B2 1.7 10x42IC

vbl.80114784

Stoc epuizat

8.449,19Lei

Afişare 121 - 139 din 139 (7 pagini)

Queries: 10, Total time: 1,645.301 ms [By time] [By id] [By file]

1 (0.200)

SELECT data
FROM `oc_session`
WHERE session_id = 'cf2b164956568cfbc80575cf15'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.147)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.088)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (493.668)

SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%optica%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555

5 (449.454)

SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%optica%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 120, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

6 (0.184)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%optica%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1014

7 (701.247)

SELECT COUNT(*) AS val, filter_group, filter_id
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%optica%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' AND f.filter_group NOT LIKE 'a%' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:923

8 (0.115)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

9 (0.102)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

10 (0.096)

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

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare