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


Lingura Oscilanta Jackall TRICOROLL 6,4CM/10G GREEN GOLD AYU

Lingura Oscilanta Jackall TRICOROLL 6,4CM/10G GREEN GOLD AYU

f3.ja.418096982
Stoc epuizat

45,93Lei

GRUB SAVAGE GEAR 5CM 0.8G GREEN PUMPKIN 8BUC/PLIC

GRUB SAVAGE GEAR 5CM 0.8G GREEN PUMPKIN 8BUC/PLIC

f1.sg.74312
Stoc epuizat

28,43Lei

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G GREEN SILVER 4BUC/PLIC

SHAD SAVAGE GEAR 3D RIVER ROACH 10CM 10G GREEN SILVER 4BUC/PLIC

f1.sg.74287
Stoc epuizat

39,69Lei

Shad Storm Jointed Minnow NATURAL GREEN PERCH 9CM 7G 4buc/plic

Shad Storm Jointed Minnow NATURAL GREEN PERCH 9CM 7G 4buc/plic

jmn04 ngp
Stoc epuizat

25,00Lei

Sapca DAM Haze Baseball Dusky Green

Sapca DAM Haze Baseball Dusky Green

a8.dam.73782
Stoc epuizat

51,11Lei

MONTURA CLONC WIZARD VERTIX CLONK CATFISH LURE GREEN 65G

MONTURA CLONC WIZARD VERTIX CLONK CATFISH LURE GREEN 65G

82710101
Stoc epuizat

55,00Lei

Vobler Salmo Rattlin' Hornet Floating - Green Tiger, 4.5cm, 3g

Vobler Salmo Rattlin' Hornet Floating - Green Tiger, 4.5cm, 3g

qrh446
Stoc epuizat

51,71Lei

Pilker Abu Garcia Micro Jig Flat, Green Sidepkzrb, 3cm, 5g -66%

Pilker Abu Garcia Micro Jig Flat, Green Sidepkzrb, 3cm, 5g

1506108
Stoc epuizat

24,75Lei(-66%) 8,40Lei

Vobler Salmo Rattlin' Hornet Floating Green Gill Clear 4.5cm, 6g

Vobler Salmo Rattlin' Hornet Floating Green Gill Clear 4.5cm, 6g

qrh545
Stoc epuizat

51,71Lei

Cafetiera Delphin CoToGo Green -32%

Cafetiera Delphin CoToGo Green

101004012
Stoc epuizat

81,00Lei(-32%) 55,00Lei

Conectori Conici Gardner Covert Green C-Thru 12buc/plic

Conectori Conici Gardner Covert Green C-Thru 12buc/plic

ctrcg
Stoc epuizat

17,01Lei

Hamac Ticket to the Moon King Size Dark Green & Army Green, 320x230cm

Hamac Ticket to the Moon King Size Dark Green & Army Green, 320x230cm

tmk0524
Stoc epuizat

369,00Lei

Fir Monofilament Carp Expert Go Green Invisible, Clear, 150m, 0.14mm, 3.17kg
Fir Monofilamet Wizard Cat Mono Line Dark Green, 300m, 0.50mm, 29.4kg

Fir Monofilamet Wizard Cat Mono Line Dark Green, 300m, 0.50mm, 29.4kg

33300050
Stoc epuizat

37,00Lei

Hanger Delphin LightBLOCK Green -19%

Hanger Delphin LightBLOCK Green

101001389
Stoc epuizat

47,01Lei(-19%) 38,20Lei

Husa Flexibila Lansete Rapitor RTB Rod Cover Green Chartreuse

Husa Flexibila Lansete Rapitor RTB Rod Cover Green Chartreuse

rtb8156
Stoc epuizat

27,00Lei

RTB Dual Blade Spinnerbait 16g Green Chartreuse

RTB Dual Blade Spinnerbait 16g Green Chartreuse

rtb8154
Stoc epuizat

15,01Lei

Clips Plumb Pierdut Dam Mad Lead Clips, Green, 10buc/plic -61%

Clips Plumb Pierdut Dam Mad Lead Clips, Green, 10buc/plic

8404101
Stoc epuizat

12,57Lei(-61%) 4,90Lei

Fir Textil Berkley Whiplash 8 Green 0.16mm 20.8kg 150m

Fir Textil Berkley Whiplash 8 Green 0.16mm 20.8kg 150m

1446652
Stoc epuizat

112,10Lei

FIR TEXTIL P-LINE X TCB 8 BRAID TEFLON GREEN 0.18mm 14.5kg 135M -5%

FIR TEXTIL P-LINE X TCB 8 BRAID TEFLON GREEN 0.18mm 14.5kg 135M

750190004
Stoc epuizat

77,00Lei(-5%) 72,99Lei

Afişare 2661 - 2680 din 2850 (143 pagini)
Queries: 6, Total time: 925.996 ms [By time] [By id] [By file]
1 (0.089)
SELECT data
FROM `oc_session`
WHERE session_id = 'ecb323e82c59d7d481ca6a7ac3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (925.351)
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 "%green%") 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:725
4 (0.222)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.136)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.104)
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