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


Rotativa DAM Effzett Fluo Green Nr.1 3g
Exclusiv online!

Rotativa DAM Effzett Fluo Green Nr.1 3g

13052960659
Livrare 48-72 ore

12,15Lei

Fir textil YGK X-Braid X8 Upgrade PE Fluo Green 0.171mm 10kg 200m

Fir textil YGK X-Braid X8 Upgrade PE Fluo Green 0.171mm 10kg 200m

x00710
Livrare imediată!

180,00Lei

PLASA MINCIOG PROLOGIC OLIVE GREEN SPARE MASH

PLASA MINCIOG PROLOGIC OLIVE GREEN SPARE MASH

a2.pro.65036
Livrare imediată!

78,40Lei

Fir textil Climax iBRAID OLIVE GREEN 135m 0.30mm 29.5kg
Exclusiv online!

Fir textil Climax iBRAID OLIVE GREEN 135m 0.30mm 29.5kg

9403-10135-030
Livrare 48-72 ore

86,00Lei

Rotativa DAM Effzett Fluo Green Nr.3 6g
Exclusiv online!

Rotativa DAM Effzett Fluo Green Nr.3 6g

13052960675
Livrare 48-72 ore

13,51Lei

Shad Savage Gear Craft Cannibal Paddletail 10.5cm 12g 4buc/plic Green Silver UV -40%
Exclusiv online!

Shad Savage Gear Craft Cannibal Paddletail 10.5cm 12g 4buc/plic Green Silver UV

f1.sg.71813
Livrare 24-48 ore

29,86Lei(-40%) 17,92Lei

Shad Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Green Orange -56%

Shad Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Green Orange

3279402
Livrare imediată!

22,28Lei(-56%) 9,90Lei

Fir textil impletit Nevis Impulse 8Braid Fluo Green 100m 0.08mm 6.50kg

Fir textil impletit Nevis Impulse 8Braid Fluo Green 100m 0.08mm 6.50kg

3223-108
Livrare imediată!

54,20Lei

Fir monofilament Carp Spirit Velocity XS Lo-Vis Green 0.27mm/5.9kg/1200m
Exclusiv online!

Fir monofilament Carp Spirit Velocity XS Lo-Vis Green 0.27mm/5.9kg/1200m

acs470035
Livrare 48-72ore

131,00Lei

Fir Textil Pokee Fighting X 8, Lime Green, 0.15mm, 9.50kg, 130m

Fir Textil Pokee Fighting X 8, Lime Green, 0.15mm, 9.50kg, 130m

fight8lg015
Livrare imediată!

55,00Lei

FIR TEXTIL Trakko FIGHTING X8 GREEN 0.23mm 130M
Exclusiv online!

FIR TEXTIL Trakko FIGHTING X8 GREEN 0.23mm 130M

fight8gr023
Livrare 48-72 ore

45,01Lei

Vobler Nomura Tokyo Crank CL Light Green Shiner 5cm 8.8g -30%
Exclusiv online!

Vobler Nomura Tokyo Crank CL Light Green Shiner 5cm 8.8g

nm.50306505
Livrare 24-48 ore

36,10Lei(-30%) 25,28Lei

Fir textil impletit Nevis Impulse 8Braid Fluo Green 100m 0.18mm 13.75kg

Fir textil impletit Nevis Impulse 8Braid Fluo Green 100m 0.18mm 13.75kg

3223-118
Livrare imediată!

42,99Lei

Fir Textil Pokee 8 X Flash Smart PE Braid, Lime Green, 0.14mm, 8.60kg, 130m

Fir Textil Pokee 8 X Flash Smart PE Braid, Lime Green, 0.14mm, 8.60kg, 130m

flashs8lg014
Livrare imediată!

75,01Lei

Fir textil impletit Nevis Impulse 8Braid Fluo Green 100m 0.14mm 10.20kg

Fir textil impletit Nevis Impulse 8Braid Fluo Green 100m 0.14mm 10.20kg

3223-114
Livrare imediată!

42,99Lei

FIR TEXTIL Climax CATFISH KEVLAR LEADER 20m 0.80mm 80kg Olive Green
Exclusiv online!

FIR TEXTIL Climax CATFISH KEVLAR LEADER 20m 0.80mm 80kg Olive Green

9381-10020-080
Livrare 48-72 ore

53,00Lei

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.55mm, 11.30kg
Exclusiv online!

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.55mm, 11.30kg

a.kboom55
Livrare 24-48 ore

65,00Lei

Fir Cormoran Textil CoraStrong 8Braid, Green, 025MM/6,3KG/300M
Exclusiv online!

Fir Cormoran Textil CoraStrong 8Braid, Green, 025MM/6,3KG/300M

c.32.8030025
Livrare 24-48 ore

72,47Lei

Fir textil impletit Nevis Impulse 8Braid Fluo Green 100m 0.12mm 9.10kg

Fir textil impletit Nevis Impulse 8Braid Fluo Green 100m 0.12mm 9.10kg

3223-112
Livrare imediată!

45,01Lei

Rapture Tungsten Finesse Rub Jig 1.7g Green Pumpkin
Exclusiv online!

Rapture Tungsten Finesse Rub Jig 1.7g Green Pumpkin

188-27-005
Livrare 48-72 ore

20,00Lei

Afişare 1601 - 1620 din 2789 (140 pagini)
Queries: 6, Total time: 94.923 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = 'b8658121355e42d9b4a4e9ad7f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (76.472)
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 (18.013)
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 1600, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.137)
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
6 (0.120)
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