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


Shad Savage Gear Minnow WL Green Silver 10cm 16g 3buc
Exclusiv online!

Shad Savage Gear Minnow WL Green Silver 10cm 16g 3buc

f1.sg.72438
Livrare 24-48 ore

50,13Lei

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.20mm 5.6kg Fluo Green
Exclusiv online!

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.20mm 5.6kg Fluo Green

cz6482
Livrare 48-72 ore

18,00Lei

ADITIV MAINLINE MATCH PELLET GREEN BETAINA 100ML

ADITIV MAINLINE MATCH PELLET GREEN BETAINA 100ML

a0.m.mm4003
Livrare imediată!

51,74Lei

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.25mm 7.6kg Fluo Green
Exclusiv online!

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.25mm 7.6kg Fluo Green

cz6505
Livrare 48-72 ore

19,00Lei

Vobler Gunki Gamera 63HW 5cm 6.4g Spot Green Trout
Exclusiv online!

Vobler Gunki Gamera 63HW 5cm 6.4g Spot Green Trout

spm.37129
Livrare 24-48 ore

38,65Lei

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.31mm 11.2kg Fluo Green
Exclusiv online!

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.31mm 11.2kg Fluo Green

cz6529
Livrare 48-72 ore

20,50Lei

CREATURA SAVAGE REACTION CRAYFISH 7,3CM/4G GREEN PUMPKIN 5BUC/PLIC
Exclusiv online!

CREATURA SAVAGE REACTION CRAYFISH 7,3CM/4G GREEN PUMPKIN 5BUC/PLIC

f1.sg.74104
Livrare 24-48 ore

35,25Lei

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.28mm 9.4kg Fluo Green
Exclusiv online!

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.28mm 9.4kg Fluo Green

cz6512
Livrare 48-72 ore

20,00Lei

Fir textil Climax FIR FLASH BRAID GREEN 100m 0.60mm 48kg -20%

Fir textil Climax FIR FLASH BRAID GREEN 100m 0.60mm 48kg

9261-10100-060
Livrare imediată!

42,00Lei(-20%) 33,61Lei

Ghete Delphin GATOR Marime 44 Green Black

Ghete Delphin GATOR Marime 44 Green Black

768000044
Livrare imediată!

236,00Lei

FOARFECA MUSTAD GREEN 12.7CM
Exclusiv online!

FOARFECA MUSTAD GREEN 12.7CM

m.mt120
Livrare 24-48 ore

59,50Lei

CLESTE MUSTAD GREEN 24.5CM -20%

CLESTE MUSTAD GREEN 24.5CM

m.mt118
Livrare imediată!

178,83Lei(-20%) 143,06Lei

Vobler Yo-Zuri Rattlin Vibe GT Green Silver 6.5cm 17g

Vobler Yo-Zuri Rattlin Vibe GT Green Silver 6.5cm 17g

r1160-gt
Livrare imediată!

40,00Lei

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.22mm 6.4kg Fluo Green
Exclusiv online!

FIR MONOFILAMENT CARPZOOM BULL-DOG FLUO FEEDER 300m 0.22mm 6.4kg Fluo Green

cz6499
Livrare 48-72 ore

18,50Lei

CLESTE MUSTAD GREEN 17.8CM -20%

CLESTE MUSTAD GREEN 17.8CM

m.mt114
Livrare imediată!

131,10Lei(-20%) 104,87Lei

NALUCA LIBRA DYING WORM 70MM 027 Cheese Apple Green 15buc/plic
Exclusiv online!

NALUCA LIBRA DYING WORM 70MM 027 Cheese Apple Green 15buc/plic

dying70-027
Livrare 48-72ore

29,50Lei

Fir DAM Damyl Tectan Hyper 4OZ 0.50mm 430m Light Green
Exclusiv online!

Fir DAM Damyl Tectan Hyper 4OZ 0.50mm 430m Light Green

11010977641
Livrare 48-72 ore

30,19Lei

FIR TEXTIL KORDA CU CAMASA STIFF HYBRID COATED BRAID 20LBS WEED GREEN 15M
Exclusiv online!

FIR TEXTIL KORDA CU CAMASA STIFF HYBRID COATED BRAID 20LBS WEED GREEN 15M

a.khy5
Livrare 24-48 ore

90,57Lei

FIR TEXTIL TRABUCCO DYNA-TEX PRO SLK X8 LIME GREEN 150M 0.12mm 7.48kg

FIR TEXTIL TRABUCCO DYNA-TEX PRO SLK X8 LIME GREEN 150M 0.12mm 7.48kg

055-00-120
Livrare imediată!

105,01Lei

CACIULA DAIWA KNITTED GREEN BEANIE
Exclusiv online!

CACIULA DAIWA KNITTED GREEN BEANIE

d.dkbh1
Livrare 24-48 ore

58,41Lei

Afişare 1701 - 1720 din 2791 (140 pagini)
Queries: 5, Total time: 99.358 ms [By time] [By id] [By file]
1 (0.312)
SELECT data
FROM `oc_session`
WHERE session_id = '13bb691cb7c545ccdfa53ef04b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.571)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (98.188)
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('+green' 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.160)
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
5 (0.127)
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