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


Baterii Alcaline Varta Longlife Power AA, 4 buc

Baterii Alcaline Varta Longlife Power AA, 4 buc

4906
Livrare imediată!

12,50Lei

CARLIGE HAYABUSA FKS130BN NR 6 15 BUC

CARLIGE HAYABUSA FKS130BN NR 6 15 BUC

eb13071-6
Livrare imediată!

8,79Lei

Costum Termo DAM Xthrem Winther 2 Buc, Marime M
Exclusiv online!

Costum Termo DAM Xthrem Winther 2 Buc, Marime M

a8.dam.60121
Livrare 24-48 ore

676,36Lei

Shad Relax Ohio 2.5 inch Standard, 7.5cm S050R 10 buc/plic

Shad Relax Ohio 2.5 inch Standard, 7.5cm S050R 10 buc/plic

oh25-s050r
Livrare imediată!

17,01Lei

STRUNE PROFI BLINKER WOLFRAM 30CM 7KG 20 BUC
Exclusiv online!

STRUNE PROFI BLINKER WOLFRAM 30CM 7KG 20 BUC

617b9
Livrare 48-72 ore

53,00Lei

Set Swinger 4 Buc FL MKM-3 Cu Conector Rapid 4 Color JY-SW-15TS + Cofret

Set Swinger 4 Buc FL MKM-3 Cu Conector Rapid 4 Color JY-SW-15TS + Cofret

jy-sw-15ts
Livrare imediată!

266,60Lei

Set Swinger 6 Buc FL MKM-3 Cu Conector Rapid 6 Colour JY-SW-15TS-6 + Cofret

Set Swinger 6 Buc FL MKM-3 Cu Conector Rapid 6 Colour JY-SW-15TS-6 + Cofret

jy-sw-15ts-6
Livrare imediată!

375,90Lei

Baterii Camelion R03 AAA blister de 4 buc Nealcaline SuperHD

Baterii Camelion R03 AAA blister de 4 buc Nealcaline SuperHD

4260033156327
Livrare imediată!

6,00Lei

Baterii alcaline Varta Long Life Power C R14 blister de 2 buc -37%

Baterii alcaline Varta Long Life Power C R14 blister de 2 buc

4008496559312
Livrare imediată!

10,50Lei(-37%) 6,66Lei

Set Swinger 6 Buc FL MKM-3 Cu conector Rapid Black Color JY-SW-15TSB-6 + Cofret

Set Swinger 6 Buc FL MKM-3 Cu conector Rapid Black Color JY-SW-15TSB-6 + Cofret

jy-sw-15tsb-6
Livrare imediată!

349,90Lei

Set Swinger 4 Buc FL Bile Magnetice Cu Conector Rapid Multicolor JY-SW-19TS + Cofret

Set Swinger 4 Buc FL Bile Magnetice Cu Conector Rapid Multicolor JY-SW-19TS + Cofret

jy-sw-19ts
Livrare imediată!

333,20Lei

Ancora FL FL-9651 Red Nr1 15 Buc/plic

Ancora FL FL-9651 Red Nr1 15 Buc/plic

fl-9651red-1
Livrare imediată!

20,69Lei

SUPORT MOSTIRO PTR STARLETI PRINS PE LANSETA 2 BUC 2.6-3.0 MM

SUPORT MOSTIRO PTR STARLETI PRINS PE LANSETA 2 BUC 2.6-3.0 MM

004759-00200-00000
Livrare imediată!

4,00Lei

ANTI TANGLE MOSTIRO CURBAT RIGID 15CM (2 BUC)

ANTI TANGLE MOSTIRO CURBAT RIGID 15CM (2 BUC)

4067
Livrare imediată!

3,50Lei

Vartej Spro Butoias Cu Agrafa Interlock Nr 6 10 Buc 18 Kg

Vartej Spro Butoias Cu Agrafa Interlock Nr 6 10 Buc 18 Kg

004551-00106-00000
Livrare imediată!

8,79Lei

Vartej Spro Butoias Nr 10 10 Buc 16 Kg

Vartej Spro Butoias Nr 10 10 Buc 16 Kg

004551-00010-00000
Livrare imediată!

4,70Lei

CARLIGE HAYABUSA FLY 384 BZ NR 10 25 BUC

CARLIGE HAYABUSA FLY 384 BZ NR 10 25 BUC

7289
Livrare imediată!

10,50Lei

CARLIGE LEGATE SENSEI CARBON F101N NR 12 (10 BUC)
Exclusiv online!

CARLIGE LEGATE SENSEI CARBON F101N NR 12 (10 BUC)

fil-00000530
Livrare 48-72 ore

10,81Lei

CARLIGE LEGATE SENSEI CARBON F101N NR 16 (10 BUC)
Exclusiv online!

CARLIGE LEGATE SENSEI CARBON F101N NR 16 (10 BUC)

fil-00000532
Livrare 48-72 ore

10,81Lei

CARLIGE LEGATE SENSEI CARBON F101N NR 14 (10 BUC)
Exclusiv online!

CARLIGE LEGATE SENSEI CARBON F101N NR 14 (10 BUC)

fil-00000531
Livrare 48-72 ore

10,81Lei

Afişare 1521 - 1540 din 2491 (125 pagini)
Queries: 4, Total time: 64.799 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = '707da77ccb58d9a101d645dfeb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (64.384)
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('+buc' 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
4 (0.175)
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