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


Bolognesa Trabucco Sirenia Light 7.00m, 0-12g, 7seg
Exclusiv online!

Bolognesa Trabucco Sirenia Light 7.00m, 0-12g, 7seg

121-24-070
Livrare 48-72 ore

1.150,00Lei

Bolognesa Trabucco Sirenia Medium 6.00m, 0-16g, 6seg
Exclusiv online!

Bolognesa Trabucco Sirenia Medium 6.00m, 0-16g, 6seg

121-24-160
Livrare 48-72 ore

950,00Lei

Borseta Spro Freestyle Chest Pouch 07, 30x12x4cm

Borseta Spro Freestyle Chest Pouch 07, 30x12x4cm

006205-01900-00000
Livrare imediată!

179,00Lei

CANTAR ELECTRONIC CU RULETA SI INCARCATOR 50KG WEI HENG ROSU

CANTAR ELECTRONIC CU RULETA SI INCARCATOR 50KG WEI HENG ROSU

wh-a28
Livrare imediată!

85,89Lei

Carlige Benzar Classic Carp Nr.8, 8buc/plic

Carlige Benzar Classic Carp Nr.8, 8buc/plic

43459008
Livrare imediată!

10,00Lei

Carlige BKK Nemesis Worm Hook Super Slide Nr.3/0, 7buc/plic

Carlige BKK Nemesis Worm Hook Super Slide Nr.3/0, 7buc/plic

6970595281150
Livrare imediată!

22,00Lei

Carlige Legate Carp Academy Basic Special, nr.4, 25lb, 2buc/pac

Carlige Legate Carp Academy Basic Special, nr.4, 25lb, 2buc/pac

8106-404
Livrare imediată!

7,50Lei

Carp Zoom Tungsten Quick Change Sinker - M, 0.3g, 10buc

Carp Zoom Tungsten Quick Change Sinker - M, 0.3g, 10buc

cz8388
Livrare imediată!

19,00Lei

Cicada Siliconica Dreamlures Seadreamer YW, 6.5cm, 10g, 1buc/pac

Cicada Siliconica Dreamlures Seadreamer YW, 6.5cm, 10g, 1buc/pac

dream-sd10-yw
Livrare imediată!

27,00Lei

Croseta Team Feeder By Dome 002 -20%

Croseta Team Feeder By Dome 002

8409-002
Livrare imediată!

9,00Lei(-20%) 7,20Lei

Cutie Accesorii Rapture Tekbox Tackle System Small 5V (Double Side, 5 Slots “V”)

Cutie Accesorii Rapture Tekbox Tackle System Small 5V (Double Side, 5 Slots “V”)

113-20-633
Livrare imediată!

22,00Lei

Cutie Magnetica Filex Chod si Zig cu 12 Eva Rig Winders 36x16x4cm
Exclusiv online!

Cutie Magnetica Filex Chod si Zig cu 12 Eva Rig Winders 36x16x4cm

fil0998
Livrare 48-72 ore

89,00Lei

Dumbell Pop-up Ibaits Duo, Squid, 8x10mm si 6x8mm

Dumbell Pop-up Ibaits Duo, Squid, 8x10mm si 6x8mm

5941944352037
Livrare imediată!

27,00Lei

Extensie Cort Trakker Tempest Rs 150 Social Cap
Exclusiv online!

Extensie Cort Trakker Tempest Rs 150 Social Cap

201327
Livrare 7-14 zile

2.349,95Lei

Extensie Cort Trakker Tempest RS Brolly Social Cap
Exclusiv online!

Extensie Cort Trakker Tempest RS Brolly Social Cap

200705
Livrare 7-14 zile

1.999,95Lei

Fir Fluorocarbon Berkley Sick FC Leader, Clear, 50m, 0.28mm, 5.9kg -23%

Fir Fluorocarbon Berkley Sick FC Leader, Clear, 50m, 0.28mm, 5.9kg

1558787
Livrare imediată!

42,49Lei(-23%) 32,90Lei

Fir Monofilament Sert SRT Universal Invisible, 0.35mm, 8.5kg, 250m
Exclusiv online!

Fir Monofilament Sert SRT Universal Invisible, 0.35mm, 8.5kg, 250m

110701sevam0103035250m
Livrare 48-72 ore

16,35Lei

Fir Textil Berkley Sick Braid, Moss Green, 150m, 0.10mm, 7.5kg

Fir Textil Berkley Sick Braid, Moss Green, 150m, 0.10mm, 7.5kg

1558595
Livrare imediată!

89,96Lei

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.15mm, 7.5kg -20%
Exclusiv online!

Fir Textil Climax Ibraid Dive Sinking, Fluo Yellow, 135m, 0.15mm, 7.5kg

9432-10135-015
Livrare 48-72 ore

103,99Lei(-20%) 83,20Lei

Fir Textil Fox Submerge Sinking Braid, Orange, 15.8kg, 35lbs, 0.20mm, 600m
Exclusiv online!

Fir Textil Fox Submerge Sinking Braid, Orange, 15.8kg, 35lbs, 0.20mm, 600m

cbl033
Livrare 7-14 zile

404,96Lei

Afişare 1921 - 1940 din 17586 (880 pagini)
Queries: 5, Total time: 861.923 ms [By time] [By id] [By file]
1 (0.179)
SELECT data
FROM `oc_session`
WHERE session_id = '76928dbc8051d1dafe577af56c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (790.379)
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 "%și%") 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 (71.070)
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 1920, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.189)
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