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 JAXON PIKE 2-SEC F BM 16CM-30GR
Exclusiv online!

VOBLER JAXON PIKE 2-SEC F BM 16CM-30GR

vj-pj16fbm
Livrare 48-72 ore

51,00Lei

Vobler Owner Bug Eye Bait 50mm 6.5gr 70 Fire tiger

Vobler Owner Bug Eye Bait 50mm 6.5gr 70 Fire tiger

804020211
Livrare imediată!

37,69Lei

Vobler Salmo PE11F, HPE, 11cm, 15g
Exclusiv online!

Vobler Salmo PE11F, HPE, 11cm, 15g

84491197
Livrare 24-48 ore

52,00Lei

Vobler Strike Pro Baby Buster, C503F, 25g, 10cm

Vobler Strike Pro Baby Buster, C503F, 25g, 10cm

sp.eg050.c503f
Livrare imediată!

53,50Lei

VOBLER STRIKE PRO MUSTANG MINNOW 4,5CM/4,2G 402
Exclusiv online!

VOBLER STRIKE PRO MUSTANG MINNOW 4,5CM/4,2G 402

sp.mg002.402
Livrare 24-48 ore

34,26Lei

VOBLER SALMO SLIDER 7CM F SGH
Exclusiv online!

VOBLER SALMO SLIDER 7CM F SGH

84577102
Livrare 24-48 ore

58,00Lei

VOBLER STORM ARASHI RATTLING DEEP 6CM / 16GR CULOARE 686
Exclusiv online!

VOBLER STORM ARASHI RATTLING DEEP 6CM / 16GR CULOARE 686

adp10 686
Livrare 48-72ore

25,00Lei

VOBLER STRIKE PRO STUMPY 4CM/4,5G A010
Exclusiv online!

VOBLER STRIKE PRO STUMPY 4CM/4,5G A010

sp.eg127.a010
Livrare 24-48 ore

31,89Lei

Spinnertail Storm Gomoku Spin Culoare TR 4.5cm 6g

Spinnertail Storm Gomoku Spin Culoare TR 4.5cm 6g

gsp06 tr
Livrare imediată!

35,00Lei

Vobler GoldStar Perch 2 Culoare 14 4cm

Vobler GoldStar Perch 2 Culoare 14 4cm

87225414
Livrare imediată!

8,00Lei

VOBLER JAXON KARAS F ST 11CM-39GR
Exclusiv online!

VOBLER JAXON KARAS F ST 11CM-39GR

vj-ka11fst
Livrare 48-72 ore

46,01Lei

VOBLER RAPALA SKITTER POP 9CM / 14GR FT
Exclusiv online!

VOBLER RAPALA SKITTER POP 9CM / 14GR FT

sp09 f
Livrare 48-72ore

55,00Lei

Vobler Salmo Rattlin Hornet 3.5F Hot Perch 3.5cm 3.1g
Exclusiv online!

Vobler Salmo Rattlin Hornet 3.5F Hot Perch 3.5cm 3.1g

84413018
Livrare 24-48 ore

45,01Lei

VOBLER DAIWA TN KP FLATT CRANK, LIME BLACK CHART, 3.3CM, 1.8G
Exclusiv online!

VOBLER DAIWA TN KP FLATT CRANK, LIME BLACK CHART, 3.3CM, 1.8G

f3.d16709.051
Livrare 24-48 ore

65,00Lei

VOBLER SALMO HORNET H6F SCW 6CM/10G
Exclusiv online!

VOBLER SALMO HORNET H6F SCW 6CM/10G

84416125
Livrare 24-48 ore

46,01Lei

VOBLER JAXON CARPAN F OM 7CM-13GR
Exclusiv online!

VOBLER JAXON CARPAN F OM 7CM-13GR

vj-ca07fom
Livrare 48-72 ore

38,00Lei

VOBLER JAXON PIKE F BM 14CM-21GR
Exclusiv online!

VOBLER JAXON PIKE F BM 14CM-21GR

vj-pi14fbm
Livrare 48-72 ore

43,99Lei

VOBLER RAPALA SHADOW RAP SHAD 9CM 12GR CULOARE HLW
Exclusiv online!

VOBLER RAPALA SHADOW RAP SHAD 9CM 12GR CULOARE HLW

sdrs09 hlw
Livrare 48-72ore

58,00Lei

Vobler GoldStar Perch 3 Culoare 10 4.5cm
Exclusiv online!

Vobler GoldStar Perch 3 Culoare 10 4.5cm

87205510
Livrare 24-48 ore

8,00Lei

NALUCA SAVAGE 3D HOLLOW DUCKLING 7.5CM/15G 03 -23%

NALUCA SAVAGE 3D HOLLOW DUCKLING 7.5CM/15G 03

f1.sg.57651
Livrare imediată!

44,03Lei(-23%) 33,90Lei

Afişare 1361 - 1380 din 4080 (204 pagini)
Queries: 7, Total time: 102.236 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = 'fb74d947e94d6fe27e1f4e82d6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.120)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (101.392)
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('+voblere +floating' 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.232)
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.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
6 (0.120)
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.122)
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