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 Hard Bait Abu Garcia Svartzonker McCelly, Fire Carp, 90g, 17cm

Vobler Hard Bait Abu Garcia Svartzonker McCelly, Fire Carp, 90g, 17cm

1531934
Stoc epuizat

95,96Lei

Vobler Hard Bait Abu Garcia Svartzonker McCelly, Yellow Fin Perch, 90g, 17cm
HUSA SPRO SEMI-HARD 150CM

HUSA SPRO SEMI-HARD 150CM

006203-00800-00000
Stoc epuizat

355,00Lei

FIR MONOFILAMENT VARIVAS BASS PRIDE HARD 91M 0.285MM 12LB -40%

FIR MONOFILAMENT VARIVAS BASS PRIDE HARD 91M 0.285MM 12LB

v2309112
Stoc epuizat

42,00Lei(-40%) 25,00Lei

HUSA RIGIDA TRAKKO PENTRU 3 LANSETE L 160CM

HUSA RIGIDA TRAKKO PENTRU 3 LANSETE L 160CM

trakko hard 1,6m/3
Stoc epuizat

335,00Lei

FIR MONOFILAMENT ASSO HARD SKIN WHITE 0.30MM / 12LB / 1430MT

FIR MONOFILAMENT ASSO HARD SKIN WHITE 0.30MM / 12LB / 1430MT

607080044
Stoc epuizat

53,91Lei

Fir ASSO Hard Skin Siliconed Green 0.30mm 300m

Fir ASSO Hard Skin Siliconed Green 0.30mm 300m

607080025
Stoc epuizat

48,46Lei

VOBLER CARP ZOOM PREDATOR-Z HARD MINNOW 8.5cm 4.5gr FLOATING 1389 -20%

VOBLER CARP ZOOM PREDATOR-Z HARD MINNOW 8.5cm 4.5gr FLOATING 1389

cz1389
Stoc epuizat

12,00Lei(-20%) 9,60Lei

CROSETA CARP SPIRIT BRAID AND HARD BAIT -21%

CROSETA CARP SPIRIT BRAID AND HARD BAIT

acs010263
Stoc epuizat

29,00Lei(-21%) 23,00Lei

HUSA RIGIDA TRAKKO 1.50MT 2 COMPARTIMENTE

HUSA RIGIDA TRAKKO 1.50MT 2 COMPARTIMENTE

trakko hard 1,5m/2
Stoc epuizat

299,00Lei

Fir Trabucco Super Hard 0.25mm/300m

Fir Trabucco Super Hard 0.25mm/300m

052-60-250
Stoc epuizat

49,00Lei

Geanta Winner Hard Double Base Extra Large Bag -50%

Geanta Winner Hard Double Base Extra Large Bag

36410
Stoc epuizat

400,99Lei(-50%) 199,90Lei

Lanseta Ron Thompson Hard Core, 2.40m, 80-150g, 2buc

Lanseta Ron Thompson Hard Core, 2.40m, 80-150g, 2buc

o.tho.61330
Stoc epuizat

149,37Lei

Boilies Nash Scopex Squid Hard Ons 12 mm 100 G

Boilies Nash Scopex Squid Hard Ons 12 mm 100 G

b6820
Stoc epuizat

39,99Lei

Lanseta Ron Thompson Hard Core, 2.10m, 80-150g, 2buc

Lanseta Ron Thompson Hard Core, 2.10m, 80-150g, 2buc

o.tho.61329
Stoc epuizat

145,54Lei

Boilies Nash Scopex Squid Hard Ons 15 mm 125 G

Boilies Nash Scopex Squid Hard Ons 15 mm 125 G

b6821
Stoc epuizat

39,99Lei

Boilies Dynamite Baits The Crave Hard Hookbaits 14/15mm

Boilies Dynamite Baits The Crave Hard Hookbaits 14/15mm

dy1578
Stoc epuizat

39,00Lei

Boilies Dynamite Baits Squid & Octopus Hard Hookbaits 20mm

Boilies Dynamite Baits Squid & Octopus Hard Hookbaits 20mm

dy1581
Stoc epuizat

46,00Lei

NALUCA SAVAGE GEAR HARD EEL DIRTY SILVER 17CM, 1+2BUC/PLIC -20%

NALUCA SAVAGE GEAR HARD EEL DIRTY SILVER 17CM, 1+2BUC/PLIC

f1.sg.48536
Stoc epuizat

56,35Lei(-20%) 45,09Lei

Boilies Dynamite Baits Monster Tiger Nut Red-Amo Hard Hookbaits 14/15mm
Afişare 201 - 220 din 244 (13 pagini)
Queries: 9, Total time: 6.836 ms [By time] [By id] [By file]
1 (0.136)
SELECT data
FROM `oc_session`
WHERE session_id = 'c97ee80a316be3867950630765'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.138)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (6.095)
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 = '3' AND (MATCH(pd.tag) AGAINST('+hard' 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.104)
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.079)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EVOS FISHING SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.074)
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
7 (0.071)
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.070)
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.069)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38