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 Realis Jerkbait 85F, ASAZ399 Gunmetal M Gold Tiger, 8.5cm, 7.3g
Exclusiv online!

Vobler DUO Realis Jerkbait 85F, ASAZ399 Gunmetal M Gold Tiger, 8.5cm, 7.3g

DUO86210
Livrare 48-72 ore

72,00Lei

Vobler DUO Realis Jerkbait 85SP, ASA3146 Gold Perch, 8.5cm, 8g
Exclusiv online!

Vobler DUO Realis Jerkbait 85SP, ASA3146 Gold Perch, 8.5cm, 8g

DUO66069
Livrare 48-72 ore

72,00Lei

Vobler DUO Realis Rozante 63SP, ASA3146 Gold Perch, 6.3cm, 5g
Exclusiv online!

Vobler DUO Realis Rozante 63SP, ASA3146 Gold Perch, 6.3cm, 5g

DUO78539
Livrare 48-72 ore

70,00Lei

Vobler DUO Realis Rozante 63SP, MCC4054 Metal Black Gold, 6.3cm, 5g
Exclusiv online!

Vobler DUO Realis Rozante 63SP, MCC4054 Metal Black Gold, 6.3cm, 5g

DUO91071
Livrare 48-72 ore

70,00Lei

Vobler Duo Realis Vibration 62 G-Fix, Gold Yamame, 6.2cm, 14.5g

Vobler Duo Realis Vibration 62 G-Fix, Gold Yamame, 6.2cm, 14.5g

duo74286
Livrare imediată!

72,00Lei

Vobler DUO Spearhead Ryuki Quattro 70S, MCC4084 Gold Yamame, 7cm 5.7g
Exclusiv online!

Vobler DUO Spearhead Ryuki Quattro 70S, MCC4084 Gold Yamame, 7cm 5.7g

DUO53083
Livrare 48-72 ore

107,00Lei

Vobler DUO Spearhead Ryuki Quattro 90S, CSA0026 Red Gold, 9cm 14g
Exclusiv online!

Vobler DUO Spearhead Ryuki Quattro 90S, CSA0026 Red Gold, 9cm 14g

DUO58125
Livrare 48-72 ore

126,00Lei

Opritor Dublu GoldStar Negru/Galben XL

Opritor Dublu GoldStar Negru/Galben XL

79006404
Livrare imediată!

2,00Lei

GROUNDBAIT THE ONE SPOD MIX GOLD 1KG
Exclusiv online!

GROUNDBAIT THE ONE SPOD MIX GOLD 1KG

98200050
Livrare 24-48 ore

19,00Lei

Spinnerbait Sakura Cajun Full Gold 14g 11.5cm -28%

Spinnerbait Sakura Cajun Full Gold 14g 11.5cm

130334saplf50041/2-jc4
Livrare imediată!

31,86Lei(-28%) 22,90Lei

Rucsac Daiwa Black Gold 20x15x45cm

Rucsac Daiwa Black Gold 20x15x45cm

d.sebg
Stoc epuizat

316,16Lei

Lanseta feeder Team Feeder by Dome Gold Series 3.60m 30-65g 3+3SEG

Lanseta feeder Team Feeder by Dome Gold Series 3.60m 30-65g 3+3SEG

1861-361
Stoc epuizat

1.135,00Lei

BILE TUNGSTEN SLOTTED BEADS 3.3mm PLATED GOLD 10buc/plic

BILE TUNGSTEN SLOTTED BEADS 3.3mm PLATED GOLD 10buc/plic

tsb33-pg
Stoc epuizat

7,50Lei

Mulineta Penn Rival Gold 7000LC

Mulineta Penn Rival Gold 7000LC

p.1524486
Stoc epuizat

599,45Lei

BILE TUNGSTEN SLOTTED BEADS 3.8mm PLATED GOLD 10buc/plic

BILE TUNGSTEN SLOTTED BEADS 3.8mm PLATED GOLD 10buc/plic

tsb38-pg
Stoc epuizat

8,50Lei

Shad Biwaa Submission 10cm, culoare Gold Perch

Shad Biwaa Submission 10cm, culoare Gold Perch

b001757
Stoc epuizat

50,00Lei

VOBLER MUSTAD SCATTRER PEN 70S 7CM/10,6G GOLD SCALES

VOBLER MUSTAD SCATTRER PEN 70S 7CM/10,6G GOLD SCALES

f3.mlsp70s.gs
Stoc epuizat

43,40Lei

Vobler Jackall Tricoroll Ryushin Sight Red Gold 7cm 9.2g

Vobler Jackall Tricoroll Ryushin Sight Red Gold 7cm 9.2g

ja.418099952
Stoc epuizat

90,12Lei

VOBLER MUSTAD ROUSE VIBE 50S 5CM/7,6G GOLD SCA

VOBLER MUSTAD ROUSE VIBE 50S 5CM/7,6G GOLD SCA

f3.mlrv50s.gs
Stoc epuizat

43,40Lei

VOBLER JACKALL TRICOROLL RYUSHIN 43HW 4,3CM/3G GOLD AYU

VOBLER JACKALL TRICOROLL RYUSHIN 43HW 4,3CM/3G GOLD AYU

ja.807191424
Stoc epuizat

87,74Lei

Afişare 1041 - 1060 din 1295 (65 pagini)
Queries: 6, Total time: 34.856 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = '0da04f6da99be86447431e1dbe'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (34.368)
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('+gold' 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.122)
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.089)
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
6 (0.088)
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