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


SONDA GARMIN TRANSDUCTOR GT51M TM XDCR 12PIN

SONDA GARMIN TRANSDUCTOR GT51M TM XDCR 12PIN

hg.010.01966.00
Stoc epuizat

2.915,87Lei

SONAR GARMIN GPSMAP 8410XSV WW

SONAR GARMIN GPSMAP 8410XSV WW

hg.010.02091.02
Stoc epuizat

15.744,90Lei

SONAR GARMIN ECHOMAP ULTRA 102SV WWW/GT56

SONAR GARMIN ECHOMAP ULTRA 102SV WWW/GT56

hg.010.02526.01
Stoc epuizat

8.124,95Lei

SONAR GARMIN ECHOMAP ULTRA 122SV WWW/GT56XDCR

SONAR GARMIN ECHOMAP ULTRA 122SV WWW/GT56XDCR

hg.010.02528.01
Stoc epuizat

17.095,30Lei

Geanta / Husa Sonar Nash Echo Sounder Bag -52%

Geanta / Husa Sonar Nash Echo Sounder Bag

t3594
Stoc epuizat

367,50Lei(-52%) 177,60Lei

Sonar Garmin GPS MAP 1223XSV WW -39%

Sonar Garmin GPS MAP 1223XSV WW

hg.010.02367.02
Stoc epuizat

16.295,34Lei(-39%) 9.899,00Lei

Sonar Garmin GPSMAP 8416XSV WW

Sonar Garmin GPSMAP 8416XSV WW

hg.010.02093.02
Stoc epuizat

33.808,99Lei

Garmin Panoptix PS21-TM

Garmin Panoptix PS21-TM

hg.010.01588.01
Stoc epuizat

7.279,00Lei

SONAR ENERGO TEAM WIRELESS SMART OUTDOOR LUCKY LAKER

SONAR ENERGO TEAM WIRELESS SMART OUTDOOR LUCKY LAKER

74871100
Stoc epuizat

885,00Lei

SONAR ENERGO TEAM OUTDOOR WIRLESS -20%

SONAR ENERGO TEAM OUTDOOR WIRLESS

74871035
Stoc epuizat

384,00Lei(-20%) 307,20Lei

SONAR GARMIN STRIKER PLUS 7SV GPS

SONAR GARMIN STRIKER PLUS 7SV GPS

hg.010.01874.01
Stoc epuizat

2.613,85Lei

SONAR HUMMINBIRD HELIX 7 CHIRP MEGA DI GPS G3

SONAR HUMMINBIRD HELIX 7 CHIRP MEGA DI GPS G3

hb.596981
Stoc epuizat

3.271,57Lei

SONAR HUMMINBIRD HELIX 7 CHIRP MEGA DI GPS G3N

SONAR HUMMINBIRD HELIX 7 CHIRP MEGA DI GPS G3N

hb.596986
Stoc epuizat

3.681,03Lei

Suport Deeper pentru Smartphone

Suport Deeper pentru Smartphone

flacc03
Stoc epuizat

69,00Lei

Camera Subacvatica Savage Gear Waterwolf 2.0 1080K

Camera Subacvatica Savage Gear Waterwolf 2.0 1080K

a8.okr.77477
Stoc epuizat

676,40Lei

Cablu Ethernet Garmin RJ45

Cablu Ethernet Garmin RJ45

hg.010.10551.00
Stoc epuizat

198,00Lei

Suport Deeper Smartphone Pentru Barca si Caiac

Suport Deeper Smartphone Pentru Barca si Caiac

dp.itgam0026
Stoc epuizat

247,45Lei

Set Sonar Deeper Smart Chirp+2.0, Suport Smartphone, Lanterna

Set Sonar Deeper Smart Chirp+2.0, Suport Smartphone, Lanterna

dp.itgam1330
Stoc epuizat

1.969,99Lei

Suport Sonar RAM Mounts Drill-Down Marine Electronic Mount with 1.5" Ball

Suport Sonar RAM Mounts Drill-Down Marine Electronic Mount with 1.5" Ball

ram-111u
Stoc epuizat

420,93Lei

Set Sonar Deeper Smart Chirp+ 2.0, Range Extender, Phone Holder

Set Sonar Deeper Smart Chirp+ 2.0, Range Extender, Phone Holder

dp.itgam0997.set
Stoc epuizat

1.969,99Lei

Afişare 81 - 100 din 114 (6 pagini)
Queries: 7, Total time: 205.458 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = '45b1aee31f4c2da3b391172c04'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (204.054)
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 = '3' AND (pd.tag LIKE "%sonar%") 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.843)
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 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.110)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAM MOUNTS BALTIC"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.111)
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