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


Geanta Momeala Matrix Ethos Pro Bait Bag, 40X40X21CM -20%

Geanta Momeala Matrix Ethos Pro Bait Bag, 40X40X21CM

glu077
Stoc epuizat

268,33Lei(-20%) 214,66Lei

VOBLER RAPTURE PRO HOT BUZZ SINKING, OLIVE SHINER 2.5 CM 3GR

VOBLER RAPTURE PRO HOT BUZZ SINKING, OLIVE SHINER 2.5 CM 3GR

180-06-902
Stoc epuizat

25,00Lei

SET NALUCI SAVAGE SI ACCESORII DROPSHOT PRO 22BUC

SET NALUCI SAVAGE SI ACCESORII DROPSHOT PRO 22BUC

f1.sg.57628
Stoc epuizat

77,20Lei

VOBLER RAPTURE PRO HELLION S PKS 50MM 3G

VOBLER RAPTURE PRO HELLION S PKS 50MM 3G

180-11-701
Stoc epuizat

23,00Lei

Carlige Trabucco Pro Sword 720BN Numarul 16

Carlige Trabucco Pro Sword 720BN Numarul 16

020-72-016
Stoc epuizat

18,00Lei

Cap Minciog Carp Expert Cadru Carbon Pro 50x40cm

Cap Minciog Carp Expert Cadru Carbon Pro 50x40cm

71027351
Stoc epuizat

134,01Lei

Geanta DAM Effzett Pro-Tact Lure Carryall cu 4 Cutii

Geanta DAM Effzett Pro-Tact Lure Carryall cu 4 Cutii

9042971253
Stoc epuizat

491,70Lei

Fir Monofilament Bokor Pro Spin Transparent 0.18mm 150m 4.48kg -20%

Fir Monofilament Bokor Pro Spin Transparent 0.18mm 150m 4.48kg

30980018
Stoc epuizat

14,49Lei(-20%) 11,60Lei

Carlige Trabucco Pro Sword 210 Numarul 8

Carlige Trabucco Pro Sword 210 Numarul 8

020-21-008
Stoc epuizat

16,01Lei

CUTIE PROLOGIC PT.MOMELI M 17X17X6CM

CUTIE PROLOGIC PT.MOMELI M 17X17X6CM

a4.pro.57141
Stoc epuizat

15,92Lei

Carlige Trabucco Pro Sword 410 Numarul 10

Carlige Trabucco Pro Sword 410 Numarul 10

020-41-010
Stoc epuizat

15,01Lei

Fir Monofilament Bokor Pro Spin Transparent 0.25mm 150m 8.95kg

Fir Monofilament Bokor Pro Spin Transparent 0.25mm 150m 8.95kg

30980025
Stoc epuizat

15,51Lei

Minciog Rapture Aggressor Pro Net L 50x40 1 Tronson 1.20m

Minciog Rapture Aggressor Pro Net L 50x40 1 Tronson 1.20m

084-51-510
Stoc epuizat

255,01Lei

LOPATA PROLOGIC PENTRU NADIRE 1.80M

LOPATA PROLOGIC PENTRU NADIRE 1.80M

a.pro.65039
Stoc epuizat

152,37Lei

VOBLER RAPTURE PRO HELLION S GGL 50MM 3G

VOBLER RAPTURE PRO HELLION S GGL 50MM 3G

180-11-715
Stoc epuizat

23,00Lei

TRICOU PROLOGIC BANK BOUND CU BUZUNAR MAR.M

TRICOU PROLOGIC BANK BOUND CU BUZUNAR MAR.M

a8.pro.62341
Stoc epuizat

70,90Lei

Carlige Trabucco Pro Sword 200 Numarul 20

Carlige Trabucco Pro Sword 200 Numarul 20

020-20-020
Stoc epuizat

16,01Lei

Kit Monturi Prologic Helicopter Rig, 3 buc/plic

Kit Monturi Prologic Helicopter Rig, 3 buc/plic

a.pro.49904
Stoc epuizat

28,20Lei

VOBLER STRIKE PRO BEETLE BUSTER(F) 4CM/5,7G 158G

VOBLER STRIKE PRO BEETLE BUSTER(F) 4CM/5,7G 158G

sp.eg174.a158g
Stoc epuizat

32,06Lei

Cantar Prologic Specimen 54kg

Cantar Prologic Specimen 54kg

a.pro.64109
Stoc epuizat

137,22Lei

Afişare 3401 - 3420 din 3893 (195 pagini)
Queries: 4, Total time: 85.011 ms [By time] [By id] [By file]
1 (0.184)
SELECT data
FROM `oc_session`
WHERE session_id = '8515bac776ec60cc46507768bf'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (84.566)
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 (MATCH(pd.tag) AGAINST('+pro' 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.153)
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