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


Vobler Salmo Whacky Floating GOLD CHARTREUSE SHAD QWY015 -37%

Vobler Salmo Whacky Floating GOLD CHARTREUSE SHAD QWY015

qwy015
Stoc epuizat

39,29Lei(-37%) 24,61Lei

Vobler Salmo Hornet Floating SILVER BLUE SHAD QHT116 -20%

Vobler Salmo Hornet Floating SILVER BLUE SHAD QHT116

qht116
Stoc epuizat

46,92Lei(-20%) 37,54Lei

SHAD COLMIC BIG DOUBLE 15cm BLACK RED -30%

SHAD COLMIC BIG DOUBLE 15cm BLACK RED

arhkeq05
Stoc epuizat

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

Shad Biwaa Divinator Medium 18cm/35g culoare Pearl White

Shad Biwaa Divinator Medium 18cm/35g culoare Pearl White

b000167
Stoc epuizat

52,00Lei

VOBLER RAPALA SCATTER RAP SHAD DEEP 7CM HSD

VOBLER RAPALA SCATTER RAP SHAD DEEP 7CM HSD

dscrs07 hsd
Stoc epuizat

45,01Lei

SHAD COLMIC BIG DOUBLE 15cm BLACK PURPLE -30%

SHAD COLMIC BIG DOUBLE 15cm BLACK PURPLE

arhkeq04
Stoc epuizat

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

SHAD COLMIC BIG DOUBLE 15cm TROUT -30%

SHAD COLMIC BIG DOUBLE 15cm TROUT

arhkeq01
Stoc epuizat

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

VOBLER RAPALA SCATTER RAP SHAD 7CM PSL

VOBLER RAPALA SCATTER RAP SHAD 7CM PSL

scrs07 psl
Stoc epuizat

45,01Lei

Vobler Salmo Hornet Floating SILVER BLUE SHAD QHT084 -20%

Vobler Salmo Hornet Floating SILVER BLUE SHAD QHT084

qht084
Stoc epuizat

42,45Lei(-20%) 33,96Lei

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

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

arhkde05
Stoc epuizat

87,00Lei

VOBLER COLMIC HERAKLES TINY ASTRO F 8.5cm 12gr Purple Sexy Shad -30%

VOBLER COLMIC HERAKLES TINY ASTRO F 8.5cm 12gr Purple Sexy Shad

arhkeb05
Stoc epuizat

33,00Lei(-30%) 23,10Lei

VOBLER RAPALA SCATTER RAP SHAD 7CM RSL

VOBLER RAPALA SCATTER RAP SHAD 7CM RSL

scrs07 rsl
Stoc epuizat

45,01Lei

VOBLER RAPALA SCATTER RAP SHAD 5CM ROL

VOBLER RAPALA SCATTER RAP SHAD 5CM ROL

scrs05 rol
Stoc epuizat

45,01Lei

Shad Lucky John Nayada 5cm - PA16 (COLA) 9buc/plic

Shad Lucky John Nayada 5cm - PA16 (COLA) 9buc/plic

140154-pa16
Stoc epuizat

21,00Lei

VOBLER RAPALA SCATTER RAP SHAD 5CM BG

VOBLER RAPALA SCATTER RAP SHAD 5CM BG

scrs05 bg
Stoc epuizat

45,01Lei

SHAD COLMIC BIG DOUBLE 15cm FIRE TIGER -30%

SHAD COLMIC BIG DOUBLE 15cm FIRE TIGER

arhkeq03
Stoc epuizat

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

SHAD COLMIC BIG DOUBLE 15cm ORANGE TIGER -30%

SHAD COLMIC BIG DOUBLE 15cm ORANGE TIGER

arhkeq02
Stoc epuizat

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

SHAD BIWAA DIVINATOR KOMPACT 50 5cm 20gr 12 Fire Tiger

SHAD BIWAA DIVINATOR KOMPACT 50 5cm 20gr 12 Fire Tiger

b001351
Stoc epuizat

48,00Lei

Vobler Owner Zip n Ziggy 5257 ZZ-80 80mm 7.5gr 01 Gold Shad

Vobler Owner Zip n Ziggy 5257 ZZ-80 80mm 7.5gr 01 Gold Shad

804020090
Stoc epuizat

51,90Lei

Shad Lucky John Nayada 5cm - F08 (PIONE) 9buc/plic -7%

Shad Lucky John Nayada 5cm - F08 (PIONE) 9buc/plic

140154-f08
Stoc epuizat

20,00Lei(-7%) 18,50Lei

Afişare 861 - 880 din 1001 (51 pagini)
Queries: 12, Total time: 34.586 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = '4fdc8502030b89e67f824116c6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (33.543)
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:725
4 (0.157)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.095)
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.089)
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.088)
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.086)
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.086)
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
10 (0.085)
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.091)
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
12 (0.092)
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