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


Clips pentru Viermusi Orange size Maggot Clips, Marime L, 5buc/pac

Clips pentru Viermusi Orange size Maggot Clips, Marime L, 5buc/pac

40441ac2091
Livrare imediată!

12,09Lei

Fir Sunset RS Competition Ultra Power Hi-Visibility Orange 0.45mm 250m

Fir Sunset RS Competition Ultra Power Hi-Visibility Orange 0.45mm 250m

110311stslj48060.45250m
Livrare imediată!

60,94Lei

Grub Mustad Aji Micro Vierme Naf Orange Glow Glitter 5cm 10buc -20%
Exclusiv online!

Grub Mustad Aji Micro Vierme Naf Orange Glow Glitter 5cm 10buc

f1.m.naf2008
Livrare 24-48 ore

19,17Lei(-20%) 15,34Lei

Lingura oscilanta Forest Miu 1.5g FLUORESCENT ORANGE ( W/LAME )
Exclusiv online!

Lingura oscilanta Forest Miu 1.5g FLUORESCENT ORANGE ( W/LAME )

miu1.5g-18
Livrare 48-72ore

23,00Lei

CUTIE TRABUCCO ACCESORII TOUGH BOX ORANGE 12 COMPARTIMENTE 11.5X8X3.5CM

CUTIE TRABUCCO ACCESORII TOUGH BOX ORANGE 12 COMPARTIMENTE 11.5X8X3.5CM

110-40-100
Livrare imediată!

29,00Lei

SHAD LUCKY JOHN TIOGA FAT Orange Chart 9.9cm 5buc/plic

SHAD LUCKY JOHN TIOGA FAT Orange Chart 9.9cm 5buc/plic

140146-t26
Livrare imediată!

14,49Lei

Surub Pop-up Orange Plastic Bait Screws 10buc 20mm

Surub Pop-up Orange Plastic Bait Screws 10buc 20mm

40441ac2087
Livrare imediată!

9,78Lei

Clips pentru Viermusi Orange size Maggot Clips, Marime M, 5buc/pac

Clips pentru Viermusi Orange size Maggot Clips, Marime M, 5buc/pac

40441ac2090
Livrare imediată!

12,09Lei

Surub Pop-up Orange Plastic Bait Screws 10buc 16mm

Surub Pop-up Orange Plastic Bait Screws 10buc 16mm

40441ac2086
Livrare imediată!

9,78Lei

Fir Sunset RS Competition Ultra Power Hi-Visibility Orange 0.40mm 250m
Exclusiv online!

Fir Sunset RS Competition Ultra Power Hi-Visibility Orange 0.40mm 250m

110311stslj48060.40250m
Livrare 48-72 ore

57,22Lei

FIR VARIVAS SUPER TROUT ADVANCE DOUBLE CROSS PE 8X 100m 9.6lb 0.13mm HI-VIS Orange
Exclusiv online!

FIR VARIVAS SUPER TROUT ADVANCE DOUBLE CROSS PE 8X 100m 9.6lb 0.13mm HI-VIS Orange

v41410006
Livrare 48-72 ore

207,00Lei

Fir Sunset RS Competition Ultra Power Hi-Visibility Orange 0.31mm 250m
Exclusiv online!

Fir Sunset RS Competition Ultra Power Hi-Visibility Orange 0.31mm 250m

110311stslj48060.31250m
Livrare 48-72 ore

43,08Lei

Fir Sunset RS Competition Ultra Power Hi-Visibility Orange 0.36mm 250m
Exclusiv online!

Fir Sunset RS Competition Ultra Power Hi-Visibility Orange 0.36mm 250m

110311stslj48060.36250m
Livrare 48-72 ore

48,77Lei

Clip Metal + Agrafa Rapida Orange pentru Plumb Pierdut 33mm 5buc/plic

Clip Metal + Agrafa Rapida Orange pentru Plumb Pierdut 33mm 5buc/plic

40341ac2039
Livrare imediată!

14,58Lei

Clips Plumb Pierdut Orange Safe Clip+Fix+Tail Rubber 5buc 40mm

Clips Plumb Pierdut Orange Safe Clip+Fix+Tail Rubber 5buc 40mm

40441ac2041
Livrare imediată!

10,27Lei

Vartej Rapid Orange Quick Change Negru Mat nr.4 10buc/plic

Vartej Rapid Orange Quick Change Negru Mat nr.4 10buc/plic

40341ac2021
Livrare imediată!

19,55Lei

Clips Plumb Pierdut Orange Power Lead Clip 5buc 45mm

Clips Plumb Pierdut Orange Power Lead Clip 5buc 45mm

40441ac2040
Livrare imediată!

11,10Lei

Fir Sunset RS Competition Ultra Power Hi-Visibility Orange 0.27mm 250m
Exclusiv online!

Fir Sunset RS Competition Ultra Power Hi-Visibility Orange 0.27mm 250m

110311stslj48060.27250m
Livrare 48-72 ore

40,95Lei

Montura In-Line Grip Orange 99g nr.4 -26%

Montura In-Line Grip Orange 99g nr.4

120241mf999
Livrare imediată!

21,48Lei(-26%) 15,90Lei

Rig Rings Orange Rotunde 3mm Negru Mat 10buc

Rig Rings Orange Rotunde 3mm Negru Mat 10buc

40641ac2028
Livrare imediată!

9,78Lei

Afişare 981 - 1000 din 1642 (83 pagini)
Queries: 6, Total time: 63.077 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = '0117b17fb98151a8246de213dd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (52.299)
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('+orange' 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 (10.291)
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 980, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.153)
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.092)
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