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


PLIOR PRESTON DOUBLE SLIDER WINDERS TRAYS 13cm Yellow 20buc/set
Exclusiv online!

PLIOR PRESTON DOUBLE SLIDER WINDERS TRAYS 13cm Yellow 20buc/set

p0020019
Livrare 7-14 zile

76,46Lei

Wafters Dynamite Baits Speedy's Washters Yellow ES-L 3mm

Wafters Dynamite Baits Speedy's Washters Yellow ES-L 3mm

dy1557
Livrare imediată!

28,00Lei

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.25mm, 8.85kg, 1200m
Exclusiv online!

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.25mm, 8.85kg, 1200m

31722425
Livrare 24-48 ore

89,04Lei

Fir Asso Invisilk Yellow 0.26mm 600m 9.6kg
Exclusiv online!

Fir Asso Invisilk Yellow 0.26mm 600m 9.6kg

602080102
Livrare 48-72 ore

55,06Lei

Fir Textil Kamasaki Braid, Yellow, 23.6kg, 0.25mm, 100m

Fir Textil Kamasaki Braid, Yellow, 23.6kg, 0.25mm, 100m

30907125
Livrare imediată!

21,12Lei

Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 4mm Yellow F1 Amino
Exclusiv online!

Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 4mm Yellow F1 Amino

dy1438
Livrare 48-72ore

27,00Lei

Teaser Black Cat Real Worm, Yellow, 80g

Teaser Black Cat Real Worm, Yellow, 80g

6244080
Livrare imediată!

109,50Lei

Kit Spinning pentru Copii Shakespeare Catch a Monster Spin Yellow

Kit Spinning pentru Copii Shakespeare Catch a Monster Spin Yellow

1506890
Livrare imediată!

112,46Lei

Teaser Black Cat Real Worm, Yellow, 160g

Teaser Black Cat Real Worm, Yellow, 160g

6244160
Livrare imediată!

124,50Lei

Cap Jig Articulat Fanatik Granennyy 10gr Yellow 5buc/plic
Exclusiv online!

Cap Jig Articulat Fanatik Granennyy 10gr Yellow 5buc/plic

41713cfg02410
Livrare 48-72 ore

7,77Lei

Creatura Black Cat Calamar U-float, Yellow Zombie, 20g -15%

Creatura Black Cat Calamar U-float, Yellow Zombie, 20g

5550002
Livrare imediată!

49,69Lei(-15%) 42,40Lei

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.22mm, 7.15kg, 300m
Exclusiv online!

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.22mm, 7.15kg, 300m

31722022
Livrare 24-48 ore

27,36Lei

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.22mm, 7.15kg, 600m
Exclusiv online!

Fir Monofilament The One Carp Long Cast, Fluo Yellow, 0.22mm, 7.15kg, 600m

31722122
Livrare 24-48 ore

48,00Lei

Fir Select Baits SilkRay Fluo Matt Yellow 0.26/1000m

Fir Select Baits SilkRay Fluo Matt Yellow 0.26/1000m

sel-0621186
Livrare imediată!

59,00Lei

Fir Textil Kamasaki Braid, Yellow, 15.5kg, 0.20mm, 100m
Exclusiv online!

Fir Textil Kamasaki Braid, Yellow, 15.5kg, 0.20mm, 100m

30907120
Livrare 24-48 ore

21,12Lei

Fir Textil Sert Str 4X, Fluo Yellow, 6.82kg, 0.12mm, 135m

Fir Textil Sert Str 4X, Fluo Yellow, 6.82kg, 0.12mm, 135m

110801sevam0120012135m
Livrare imediată!

24,19Lei

Streamer Zebco Holografix Rig Yellow Nr10, 0.40mm -10%

Streamer Zebco Holografix Rig Yellow Nr10, 0.40mm

4111006
Livrare imediată!

13,28Lei(-10%) 11,95Lei

Swinger Z-Fish Bite Indicator Classic Twin Ball, Yellow
Exclusiv online!

Swinger Z-Fish Bite Indicator Classic Twin Ball, Yellow

zf-2494
Livrare 48-72ore

29,70Lei

Clopotel Dublu Black Cat BigBells black/yellow
Exclusiv online!

Clopotel Dublu Black Cat BigBells black/yellow

409226700005
Livrare 48-72 ore

20,30Lei

Inaintas Conic Varivas Fly Tapered Leader Super Yamame Flat Butt St 15ft/4.57m 5X Flash Yellow
Exclusiv online!

Inaintas Conic Varivas Fly Tapered Leader Super Yamame Flat Butt St 15ft/4.57m 5X Flash Yellow

v54155x
Livrare 48-72 ore

13,99Lei

Afişare 701 - 720 din 1059 (53 pagini)
Queries: 6, Total time: 24.931 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = '82a473c5a4e3b54fe4d6682577'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (24.400)
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('+yellow' 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.152)
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.100)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.103)
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