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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


SWIMBAIT BIWAA SPINJET 10CM 18G SEXY SHAD

SWIMBAIT BIWAA SPINJET 10CM 18G SEXY SHAD

b001661
Livrare imediată!

46,01Lei

VOBLER COLMIC HERAKLES WT DOG 125HF 12.5cm 28gr Shad
Exclusiv online!

VOBLER COLMIC HERAKLES WT DOG 125HF 12.5cm 28gr Shad

arhkde05
Livrare 48-72 ore

87,00Lei

VOBLER RAPALA GLASS SHAD RAP 5CM GPS
Exclusiv online!

VOBLER RAPALA GLASS SHAD RAP 5CM GPS

gsr05 gps
Livrare 48-72ore

41,00Lei

VOBLER RAPALA SHALLOW SHAD RAP 9CM ROL
Exclusiv online!

VOBLER RAPALA SHALLOW SHAD RAP 9CM ROL

ssr09 rol
Livrare 48-72ore

51,00Lei

Shad Biwaa Ultra Hog 10cm culoare Texas Craw -23%

Shad Biwaa Ultra Hog 10cm culoare Texas Craw

b001492
Livrare imediată!

26,00Lei(-23%) 19,90Lei

Shad Biwaa Armored Craw 10 cm culoare Black Blue
Exclusiv online!

Shad Biwaa Armored Craw 10 cm culoare Black Blue

b001150
Livrare 48-72 ore

25,00Lei

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 66 Konoshiro
Exclusiv online!

Vobler Owner Savoy Shad 5279 SS-80S 80mm 14.2gr 66 Konoshiro

804020044
Livrare 48-72 ore

52,19Lei

Shad Biwaa Ultra Hog 7.5cm culoare Black Blue
Exclusiv online!

Shad Biwaa Ultra Hog 7.5cm culoare Black Blue

b001158
Livrare 48-72 ore

26,00Lei

SHAD COLMIC BIG DOUBLE 15cm ORANGE TIGER -30%
Exclusiv online!

SHAD COLMIC BIG DOUBLE 15cm ORANGE TIGER

arhkeq02
Livrare 48-72 ore

36,00Lei(-30%) 25,20Lei

VOBLER RAPALA SHALLOW SHAD RAP 9CM HS

VOBLER RAPALA SHALLOW SHAD RAP 9CM HS

ssr09 hs
Livrare imediată!

51,00Lei

VOBLER RAPALA SHAD RAP 9CM S 15 g
Exclusiv online!

VOBLER RAPALA SHAD RAP 9CM S 15 g

sr09 s
Livrare 48-72ore

52,00Lei

VOBLER RAPALA SCATTER RAP SHAD 5CM BBH
Exclusiv online!

VOBLER RAPALA SCATTER RAP SHAD 5CM BBH

scrs05 bbh
Livrare 48-72ore

45,01Lei

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE FT 8CM 13G
Exclusiv online!

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE FT 8CM 13G

xrts08 ft
Livrare 48-72ore

54,00Lei

Shad Biwaa Armored Craw 10 cm culoare Nighcrawler
Exclusiv online!

Shad Biwaa Armored Craw 10 cm culoare Nighcrawler

b001089
Livrare 48-72 ore

25,00Lei

VOBLER RAPALA X-RAP JOINTED SHAD 13GR CLN
Exclusiv online!

VOBLER RAPALA X-RAP JOINTED SHAD 13GR CLN

xjs13 cln
Livrare 48-72ore

79,00Lei

VOBLER RAPALA X-RAP JOINTED SHAD CULOARE PEL 13CM 46G
Exclusiv online!

VOBLER RAPALA X-RAP JOINTED SHAD CULOARE PEL 13CM 46G

xjs13 pel
Livrare 48-72ore

79,00Lei

VOBLER RAPALA SHAD RAP 7CM SFC
Exclusiv online!

VOBLER RAPALA SHAD RAP 7CM SFC

sr07 sfc
Livrare 48-72ore

47,01Lei

Shad Biwaa Ultra Hog 10cm, 04 Watermelon Red 8/plic
Exclusiv online!

Shad Biwaa Ultra Hog 10cm, 04 Watermelon Red 8/plic

b001122
Livrare 48-72 ore

26,00Lei

Vobler GoldStar Shad Culoare:9

Vobler GoldStar Shad Culoare:9

87245909
Livrare imediată!

8,00Lei

Vobler Swimbait Biwaa Seven Section Sexy Shad 15cm 60g
Exclusiv online!

Vobler Swimbait Biwaa Seven Section Sexy Shad 15cm 60g

b000784
Livrare 48-72 ore

126,00Lei

Afişare 381 - 400 din 1001 (51 pagini)
Queries: 13, Total time: 52.643 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '80abca866314b88adb77e9ecc2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (47.552)
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('+shad-uri' 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:722
4 (3.935)
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 380, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.103)
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.079)
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.077)
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.162)
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.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
10 (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
11 (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
12 (0.068)
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
13 (0.116)
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