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 Salmo Hornet H2S BBS, 2.5cm, 1.5g
Exclusiv online!

Vobler Salmo Hornet H2S BBS, 2.5cm, 1.5g

84412558
Livrare 24-48 ore

37,00Lei

Vobler Salmo Trill Sinking Black Metallic Bleak 7cm 13g

Vobler Salmo Trill Sinking Black Metallic Bleak 7cm 13g

qth026
Livrare imediată!

49,46Lei

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.22mm, 150m

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.22mm, 150m

33905122
Livrare imediată!

24,00Lei

Vobler Salmo Thrill TH7 OB
Exclusiv online!

Vobler Salmo Thrill TH7 OB

84537522
Livrare 24-48 ore

46,01Lei

VOBLER JAXON HS LIL BUG F CV 2CM 1.8GR -20%

VOBLER JAXON HS LIL BUG F CV 2CM 1.8GR

vj-sp02scv
Livrare imediată!

35,00Lei(-20%) 27,91Lei

FIR TEXTIL JAXON HEGEMON 8X SINKING 10m 0.16mm 17kg

FIR TEXTIL JAXON HEGEMON 8X SINKING 10m 0.16mm 17kg

zj-des016c
Livrare imediată!

19,00Lei

VOBLER RAPALA BALSA EXTREME MINNOW 10CM GSH
Exclusiv online!

VOBLER RAPALA BALSA EXTREME MINNOW 10CM GSH

bxm10 gsh
Livrare 48-72ore

59,00Lei

FIR SPRO C-TEC FEEDER BROWN SINKING 0.30 7.3 KG 500M

FIR SPRO C-TEC FEEDER BROWN SINKING 0.30 7.3 KG 500M

005303-00330-00000
Livrare imediată!

22,50Lei

VOBLER RAPALA COUNTDOWN 2.5CM / 2.7GR BTR
Exclusiv online!

VOBLER RAPALA COUNTDOWN 2.5CM / 2.7GR BTR

cd01 btr
Livrare 48-72ore

45,01Lei

VOBLER RAPALA X-RAP PETO HOT TIGER PIKE 20CM 83G
Exclusiv online!

VOBLER RAPALA X-RAP PETO HOT TIGER PIKE 20CM 83G

xrpt20 htip
Livrare 48-72ore

99,00Lei

VOBLER STRIKE PRO FLAP JACK 7,5CM/21,8G 177
Exclusiv online!

VOBLER STRIKE PRO FLAP JACK 7,5CM/21,8G 177

sp.eg128c.177
Livrare 24-48 ore

33,83Lei

Vobler Yo-Zuri L-Minnow S 3.3cm, 3.5gr, Sinking (New Series) Culoare M92 1 buc/pac
Exclusiv online!

Vobler Yo-Zuri L-Minnow S 3.3cm, 3.5gr, Sinking (New Series) Culoare M92 1 buc/pac

f1166-m92
Livrare 48-72ore

37,00Lei

VOBLER RAPALA BX JOINTED MINNOW 9CM FT
Exclusiv online!

VOBLER RAPALA BX JOINTED MINNOW 9CM FT

bxjm09 ft
Livrare 48-72ore

59,00Lei

Vobler BIWAA SEVEN SECTION S4 10cm 17gr 02 Real Perch -21%

Vobler BIWAA SEVEN SECTION S4 10cm 17gr 02 Real Perch

b000060
Livrare imediată!

110,00Lei(-21%) 86,91Lei

FIR TEXTIL CARP EXPERT FAST SINKING CAMOU GREEN 10M 25lbs

FIR TEXTIL CARP EXPERT FAST SINKING CAMOU GREEN 10M 25lbs

31550253
Livrare imediată!

9,00Lei

Vobler Rapala Count Down 5cm/5gr. ALB

Vobler Rapala Count Down 5cm/5gr. ALB

cd05 alb
Livrare imediată!

49,00Lei

FIR TEXTIL KORDA SUB BRAID SINKING 0.30mm 15LBS/450M
Exclusiv online!

FIR TEXTIL KORDA SUB BRAID SINKING 0.30mm 15LBS/450M

a.sbb1
Livrare 24-48 ore

255,35Lei

Vobler Biwaa Seven Section S4 10cm 17gr 04 Fire Tiger

Vobler Biwaa Seven Section S4 10cm 17gr 04 Fire Tiger

b000212
Livrare imediată!

99,00Lei

Vobler Biwaa Seven Section S4 10cm 17gr 12 Carassin -21%

Vobler Biwaa Seven Section S4 10cm 17gr 12 Carassin

b000289
Livrare imediată!

99,00Lei(-21%) 77,90Lei

VOBLER JAXON ATRACT MULTI PARTS XMP-A S B 9.5CM 20GR

VOBLER JAXON ATRACT MULTI PARTS XMP-A S B 9.5CM 20GR

vr-msa095b
Livrare imediată!

49,00Lei

Afişare 1641 - 1660 din 4832 (242 pagini)
Queries: 10, Total time: 128.223 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '96c9985b579eb65edf67f0fa2f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (109.484)
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('+sinking' 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 (17.746)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 1640, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.131)
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
6 (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
7 (0.117)
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 '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.131)
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
10 (0.122)
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