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


Monofilament Nevis Fluo Carbon 150m 0.16mm

Monofilament Nevis Fluo Carbon 150m 0.16mm

3213-016
Stoc epuizat

22,00Lei

FIR TEXTIL Delphin BOXER 4 galben fluo 0.40mm 30.10kg 1100m

FIR TEXTIL Delphin BOXER 4 galben fluo 0.40mm 30.10kg 1100m

101001686
Stoc epuizat

215,00Lei

Twistere Profiblinker Riptor 10 Cm Fluo Cu Gliter 135 Buc

Twistere Profiblinker Riptor 10 Cm Fluo Cu Gliter 135 Buc

37efl
Stoc epuizat

503,00Lei

Pluta Culisanta Black Cat Somn 5gr U-Float Tree Fluo Yellow

Pluta Culisanta Black Cat Somn 5gr U-Float Tree Fluo Yellow

5532105
Stoc epuizat

17,78Lei

Fir Textil Delphin ZANDERA 8 Verde Fluo 0.10mm, 6.9kg, 150m

Fir Textil Delphin ZANDERA 8 Verde Fluo 0.10mm, 6.9kg, 150m

101001635
Stoc epuizat

108,00Lei

FIR TEXTIL DELPHIN FIN TRON 20m Galben Fluo 0.06mm

FIR TEXTIL DELPHIN FIN TRON 20m Galben Fluo 0.06mm

500793410
Stoc epuizat

17,01Lei

Tub antitangle DAM 85mm Casting Boom Fluo Green

Tub antitangle DAM 85mm Casting Boom Fluo Green

405098089085
Stoc epuizat

8,54Lei

FIR TEXTIL DELPHIN FIN TRON 300m Galben Fluo 0.05mm

FIR TEXTIL DELPHIN FIN TRON 300m Galben Fluo 0.05mm

500793455
Stoc epuizat

138,00Lei

FIR TEXTIL Delphin BOXER 4 galben fluo 0.60mm 52.60kg 1100m

FIR TEXTIL Delphin BOXER 4 galben fluo 0.60mm 52.60kg 1100m

101001688
Stoc epuizat

287,00Lei

Fir Delphin FIN Strong CARP 300m Galben Fluo 0.32mm

Fir Delphin FIN Strong CARP 300m Galben Fluo 0.32mm

500604032
Stoc epuizat

41,00Lei

FIR TEXTIL Delphin BOXER 4 galben fluo 0.50mm 41.70kg 150m

FIR TEXTIL Delphin BOXER 4 galben fluo 0.50mm 41.70kg 150m

101001679
Stoc epuizat

43,99Lei

Fir Delphin FIN Strong CARP 600m Galben Fluo 0.28mm

Fir Delphin FIN Strong CARP 600m Galben Fluo 0.28mm

500604328
Stoc epuizat

47,01Lei

FIR TEXTIL DELPHIN FIN TRON 20m Galben Fluo 0.05mm 2.25 kg

FIR TEXTIL DELPHIN FIN TRON 20m Galben Fluo 0.05mm 2.25 kg

500793405
Stoc epuizat

20,00Lei

POP-UP MAINLINE FLUO INDIAN SPICE 15MM

POP-UP MAINLINE FLUO INDIAN SPICE 15MM

a0.m.m13006
Stoc epuizat

46,98Lei

Vobler Salmo Rattlin Hornet 6.5F Gold Fluo Perch 6.5CM 20G

Vobler Salmo Rattlin Hornet 6.5F Gold Fluo Perch 6.5CM 20G

84416041
Stoc epuizat

59,00Lei

FIR TEXTIL Delphin BOXER 4 galben fluo 0.60mm 52.60kg 150m

FIR TEXTIL Delphin BOXER 4 galben fluo 0.60mm 52.60kg 150m

101001680
Stoc epuizat

52,00Lei

Porumb artificial EnergoTeam Flexi Bait Dublu - Fluo

Porumb artificial EnergoTeam Flexi Bait Dublu - Fluo

79456081
Stoc epuizat

15,01Lei

Fir textil Climax FIR FLASH BRAID FLUO YELLOW 100m 0.40mm 35kg -30%

Fir textil Climax FIR FLASH BRAID FLUO YELLOW 100m 0.40mm 35kg

9262-10100-040
Stoc epuizat

42,00Lei(-30%) 29,40Lei

Vobler Kenart Hunter Floating 3cm 2.5gr NPX Natural Perch Fluo 1 buc/pac

Vobler Kenart Hunter Floating 3cm 2.5gr NPX Natural Perch Fluo 1 buc/pac

hu3f-npx
Stoc epuizat

21,50Lei

Vobler Kenart Diver Floating 4cm 3gr NRX Natural Roach Fluo 1 buc/pac

Vobler Kenart Diver Floating 4cm 3gr NRX Natural Roach Fluo 1 buc/pac

div4f-nrx
Stoc epuizat

21,50Lei

Afişare 1201 - 1220 din 1272 (64 pagini)
Queries: 7, Total time: 36.617 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = 'f2c127be220c3f056085aad86b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.122)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (30.741)
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('+fluo' 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 (5.287)
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 1200, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.139)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.124)
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