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

Produse ce potrivesc criteriilor de căutare


SET AVERTIZOR JAXON XTR CRAP LIBRA 2 PLUS 1

SET AVERTIZOR JAXON XTR CRAP LIBRA 2 PLUS 1

aj-syb104x
Stoc epuizat

628,00Lei

Set Avertizoare Prologic Electronici SMX MKII Bite Blue + Statie

Set Avertizoare Prologic Electronici SMX MKII Bite Blue + Statie

a.pro.72660
Stoc epuizat

881,08Lei

SEMNALIZATOR JAXON COPCA SB2 10cm Medium

SEMNALIZATOR JAXON COPCA SB2 10cm Medium

mp-sb2
Stoc epuizat

63,00Lei

SET AVERTIZOR JAXON XTR CRAP LIBRA 3 PLUS 1

SET AVERTIZOR JAXON XTR CRAP LIBRA 3 PLUS 1

aj-syb105x
Stoc epuizat

850,01Lei

AVERTIZOR JAXON XTR CARP SENSITIVE 6R ROSU

AVERTIZOR JAXON XTR CARP SENSITIVE 6R ROSU

aj-sya106r
Stoc epuizat

51,00Lei

AVERTIZOR JAXON XTR CRAP LIBRA G VERDE

AVERTIZOR JAXON XTR CRAP LIBRA G VERDE

aj-syb105sg
Stoc epuizat

208,00Lei

AVERTIZOR JAXON XTR CARP LIBRA 5Y GALBEN

AVERTIZOR JAXON XTR CARP LIBRA 5Y GALBEN

aj-sya105y
Stoc epuizat

105,01Lei

AVERTIZOR JAXON XTR CARP SENSITIVE 6G VERDE

AVERTIZOR JAXON XTR CARP SENSITIVE 6G VERDE

aj-sya106g
Stoc epuizat

51,00Lei

AVERTIZOR JAXON XTR CARP SENSITIVE 6B GALBEN

AVERTIZOR JAXON XTR CARP SENSITIVE 6B GALBEN

aj-sya106y
Stoc epuizat

51,00Lei

Avertizor FOX Mini Micron X include Hardcase -14%

Avertizor FOX Mini Micron X include Hardcase

cei195
Stoc epuizat

323,97Lei(-14%) 278,42Lei

AVERTIZOR CARP ZOOM MRX

AVERTIZOR CARP ZOOM MRX

cz9392
Stoc epuizat

69,00Lei

AVERTIZOR JAXON XTR CRAP SENSITIVE EASY SR

AVERTIZOR JAXON XTR CRAP SENSITIVE EASY SR

aj-syb103sr
Stoc epuizat

93,00Lei

Set Avertizoare FOX RX plus Micron 2 cu 1 -20%

Set Avertizoare FOX RX plus Micron 2 cu 1

cei156
Stoc epuizat

3.059,95Lei(-20%) 2.459,99Lei

SET AVERTIZOARE CARP ZOOM MARSHAL VIP 3 plus 1

SET AVERTIZOARE CARP ZOOM MARSHAL VIP 3 plus 1

cz0503
Stoc epuizat

1.029,00Lei

SET AVERTIZOARE CARP ZOOM V SAT K-470 3 PLUS 1 STATIE

SET AVERTIZOARE CARP ZOOM V SAT K-470 3 PLUS 1 STATIE

cz6902
Stoc epuizat

516,00Lei

AVERTIZOR JAXON XTR CRAP SENSITIVE EASY SB

AVERTIZOR JAXON XTR CRAP SENSITIVE EASY SB

aj-syb103sb
Stoc epuizat

93,00Lei

AVERTIZOR ELECTRONIC K-KARP DRAKE XTR BITE ALARM 9V YELLOW

AVERTIZOR ELECTRONIC K-KARP DRAKE XTR BITE ALARM 9V YELLOW

019-25-903
Stoc epuizat

93,50Lei

AVERTIZOR JRC RADAR C4 ALBASTRU -49%

AVERTIZOR JRC RADAR C4 ALBASTRU

1445858
Stoc epuizat

136,01Lei(-49%) 70,00Lei

Set Avertizoare Carp Academy Thunder 3 Plus 1

Set Avertizoare Carp Academy Thunder 3 Plus 1

6325-003
Stoc epuizat

618,00Lei

Avertizor electronic Nash SIREN S5 DIGITAL RED

Avertizor electronic Nash SIREN S5 DIGITAL RED

t2972
Stoc epuizat

100,00Lei

Afişare 461 - 480 din 570 (29 pagini)
Queries: 4, Total time: 566.643 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = '19d26e97266b62e13c10076072'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (566.335)
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 = '3' AND (pd.tag LIKE "%avertizoare%") 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
4 (0.129)
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