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


Vobler DUO Tetra Works Pocopoco F, DHH0317 Clear Pink GB, 4cm, 3g

Vobler DUO Tetra Works Pocopoco F, DHH0317 Clear Pink GB, 4cm, 3g

DUO36980
Stoc epuizat

66,00Lei

Vobler DUO Tetra Works Toto 48HS Heavy Sinking, AQA0313 Pink Candy GB, 4.8cm, 4.3g
Vobler DUO Tetra Works Toto 48HS Heavy Sinking, CSA0577 Sexy Pink GB, 4.8cm, 4.3g
Vobler DUO Tetra Works Totoshad, AQUA0313 Pink Candy GB, 4.8cm, 4.5g

Vobler DUO Tetra Works Totoshad, AQUA0313 Pink Candy GB, 4.8cm, 4.5g

DUO67977
Stoc epuizat

66,00Lei

Vobler DUO Tetra Works Totoshad, CCC0377 Clear Light Pink, 4.8cm, 4.5g

Vobler DUO Tetra Works Totoshad, CCC0377 Clear Light Pink, 4.8cm, 4.5g

DUO25622
Stoc epuizat

66,00Lei

Vobler DUO Tide Minnow 75 Sprint, ADA0119 Pink Sardine, 7.5cm, 11g

Vobler DUO Tide Minnow 75 Sprint, ADA0119 Pink Sardine, 7.5cm, 11g

DUO36195
Stoc epuizat

82,00Lei

Vobler Hide Up HU-30BT F, 50 Bomber Pink Crown, 4.3cm, 8.6g

Vobler Hide Up HU-30BT F, 50 Bomber Pink Crown, 4.3cm, 8.6g

hide25440
Stoc epuizat

82,00Lei

Vobler Hide Up Hu-Minnow 77SP, S-36 Pink Mekki Bait, 7.7cm, 5g

Vobler Hide Up Hu-Minnow 77SP, S-36 Pink Mekki Bait, 7.7cm, 5g

hide88336
Stoc epuizat

85,00Lei

Vobler HMKL Alive Bait, Pink Pearl, 3g, 6.5cm

Vobler HMKL Alive Bait, Pink Pearl, 3g, 6.5cm

hmkl-ab65sp-pp
Stoc epuizat

110,00Lei

BALL SHAD COLMIC 5cm SILVER PINK -30%

BALL SHAD COLMIC 5cm SILVER PINK

arhkeu02
Stoc epuizat

11,00Lei(-30%) 7,70Lei

BILE POP UP FLUO PINK MAVER

BILE POP UP FLUO PINK MAVER

75056009
Stoc epuizat

12,99Lei

GRUB CAT SPIRIT ONDULIA 18CM CULOARE PINK 2BUC -30%

GRUB CAT SPIRIT ONDULIA 18CM CULOARE PINK 2BUC

act230024
Stoc epuizat

24,00Lei(-30%) 16,90Lei

COMBO SHAD COLMIC BENJO 3" 7.5cm SMOKE PINK COMBO SHAD -40%

COMBO SHAD COLMIC BENJO 3" 7.5cm SMOKE PINK COMBO SHAD

arhkfz01
Stoc epuizat

20,00Lei(-40%) 12,00Lei

ZIGGY SHAD COLMIC 5.5cm PINK IMPACT -40%

ZIGGY SHAD COLMIC 5.5cm PINK IMPACT

arhkei03
Stoc epuizat

13,99Lei(-40%) 8,40Lei

Boilies Mainline Fluoro Pop-Ups Pink White Essential Cell 8mm 150ml

Boilies Mainline Fluoro Pop-Ups Pink White Essential Cell 8mm 150ml

a0.m.m21041
Stoc epuizat

56,49Lei

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 HOT PINK 022

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 HOT PINK 022

mftupa0022
Stoc epuizat

21,00Lei

SHAD BASS ASSASSIN CURLY SHAD 10CM PINK DIAMOND 10BUC

SHAD BASS ASSASSIN CURLY SHAD 10CM PINK DIAMOND 10BUC

wc33374
Stoc epuizat

22,90Lei

POP-UP STICKY BAITS PINK KRILL 12MM

POP-UP STICKY BAITS PINK KRILL 12MM

kpk12
Stoc epuizat

39,00Lei

CAP JIG DAIWA PROREX FLEXI JIG-SYSTEM TG HEAD FLUO-PINK 7G 3BUC/PLIC

CAP JIG DAIWA PROREX FLEXI JIG-SYSTEM TG HEAD FLUO-PINK 7G 3BUC/PLIC

f2.15412.307
Stoc epuizat

26,85Lei

Grub Colmic Herakles Viber 6.2cm PINK SILVER FLK -40%

Grub Colmic Herakles Viber 6.2cm PINK SILVER FLK

arhklq07
Stoc epuizat

11,00Lei(-40%) 6,60Lei

Afişare 541 - 560 din 751 (38 pagini)
Queries: 7, Total time: 33.478 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = 'acbc70b277ed3270be31446089'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (32.747)
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('+pink' 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.208)
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.113)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC INDISPONIBIL 2 (IULIA)"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.100)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"OVIDIUS DOCTOR FISHING SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.124)
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