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


Mulineta Mitchell Spin MX2 3000 FD

Mulineta Mitchell Spin MX2 3000 FD

1530819
Livrare imediată!

199,96Lei

Vobler Rapala Shadow Rap Jack Deep 7cm 10g Glass Ghost
Exclusiv online!

Vobler Rapala Shadow Rap Jack Deep 7cm 10g Glass Ghost

sdrjd07 ggh
Livrare 48-72ore

62,00Lei

Fir Fluorocarbon Lucky John Area Trout Game Roz 75m 0.23mm 3.8kg
Exclusiv online!

Fir Fluorocarbon Lucky John Area Trout Game Roz 75m 0.23mm 3.8kg

lj4050-023
Livrare 48-72ore

43,99Lei

BILE TUNGSTEN SLOTTED BEADS 4.6mm FLUO YELLOW 10buc/plic
Exclusiv online!

BILE TUNGSTEN SLOTTED BEADS 4.6mm FLUO YELLOW 10buc/plic

tsb46-fy
Livrare 48-72ore

11,50Lei

Carlige Reiva Offset Worm Nr.3/0 5buc/pac

Carlige Reiva Offset Worm Nr.3/0 5buc/pac

9960-300
Livrare imediată!

7,79Lei

Mulineta Abu Garcia Revo X 2000

Mulineta Abu Garcia Revo X 2000

1430446
Livrare imediată!

494,60Lei

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.26mm 5.70kg

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.26mm 5.70kg

d.12200.326
Livrare imediată!

34,90Lei

Mulineta Abu Garcia Cardinal 1000 -23%

Mulineta Abu Garcia Cardinal 1000

1345011
Livrare imediată!

106,20Lei(-23%) 81,90Lei

Carlige BKK Iseama Shark, Black Nickel, Nr.1, 7buc/pac

Carlige BKK Iseama Shark, Black Nickel, Nr.1, 7buc/pac

6939067098535
Livrare imediată!

9,81Lei

MANUSI GAMAKATSU CU DEGETE TAIATE MARIME XXL
Exclusiv online!

MANUSI GAMAKATSU CU DEGETE TAIATE MARIME XXL

a8.gk.7239.210
Livrare 24-48 ore

79,19Lei

LANSETA ARROW INT. 2BUC F5 MAX CARP 3.90M 3.5LBS -20%

LANSETA ARROW INT. 2BUC F5 MAX CARP 3.90M 3.5LBS

arr.c320.391
Livrare imediată!

399,00Lei(-20%) 319,21Lei

Lanseta Harrison Aviator TE 3.96m 4.2lbs 2seg

Lanseta Harrison Aviator TE 3.96m 4.2lbs 2seg

av13ter
Livrare imediată!

2.916,00Lei

CARLIGE BKK CHIMERA OFFSET SUPER SLIDE Worm Hook Nr 2/0 7/Plic
Exclusiv online!

CARLIGE BKK CHIMERA OFFSET SUPER SLIDE Worm Hook Nr 2/0 7/Plic

6970595280849
Livrare 48-72 ore

21,00Lei

Lingurita Oscilanta Rapala Harmaja Stickleback 11.6cm, 31g
Exclusiv online!

Lingurita Oscilanta Rapala Harmaja Stickleback 11.6cm, 31g

har31 stb
Livrare 48-72ore

49,00Lei

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.23mm 4.50kg

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.23mm 4.50kg

d.12200.323
Livrare imediată!

33,20Lei

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.XL
Exclusiv online!

MANUSI SAVAGE GEAR NEOPREN CU DEGETE TAIATE BLACK MAR.XL

a8.sg.76464
Livrare 24-48 ore

71,05Lei

MULINETA TARBUCCO XANTHOS STC 4000

MULINETA TARBUCCO XANTHOS STC 4000

034-83-400
Livrare imediată!

115,00Lei

Lanseta Mitchell Traxx MX7 Finesse Jig 7-28g 2.10m -49%

Lanseta Mitchell Traxx MX7 Finesse Jig 7-28g 2.10m

1530366
Livrare imediată!

825,00Lei(-49%) 419,00Lei

Vobler Rapala BX Skitter Frog 5.5cm/13g, culoare Fire Snake
Exclusiv online!

Vobler Rapala BX Skitter Frog 5.5cm/13g, culoare Fire Snake

bxsf05 fsn
Livrare 48-72ore

62,00Lei

MANUSI SAVAGE GEAR AQUA MESH SEA BLUE MAR.XL -30%
Exclusiv online!

MANUSI SAVAGE GEAR AQUA MESH SEA BLUE MAR.XL

a8.sg.76485
Livrare 24-48 ore

92,53Lei(-30%) 64,77Lei

Afişare 1661 - 1680 din 24344 (1218 pagini)
Queries: 9, Total time: 1,127.585 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = '6f2c2318227db4a3ecdffc38bb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1,126.485)
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 (pd.tag LIKE "%rap%") 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:725
4 (0.168)
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.126)
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.123)
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
7 (0.116)
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
8 (0.118)
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
9 (0.234)
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