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 Spro Iris Fatboy Shad 8.5cm 24g
Exclusiv online!

Vobler Spro Iris Fatboy Shad 8.5cm 24g

004867-01506-00000
Livrare 48-72 ore

69,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g DCW
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g DCW

sdd07 dcw
Livrare 48-72ore

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g PC

VOBLER RAPALA SHAD DANCER 7 cm 15 g PC

sdd07 pc
Livrare imediată!

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g RFCW
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g RFCW

sdd07 rfcw
Livrare 48-72ore

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g PD
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g PD

sdd07 pd
Livrare 48-72ore

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g YP
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g YP

sdd07 yp
Livrare 48-72ore

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g SD
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g SD

sdd07 sd
Livrare 48-72ore

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g SFL
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g SFL

sdd07 sfl
Livrare 48-72ore

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g HS
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g HS

sdd07 hs
Livrare 48-72ore

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g PTU
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g PTU

sdd07 ptu
Livrare 48-72ore

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g PSL
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g PSL

sdd07 psl
Livrare 48-72ore

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g RCW
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g RCW

sdd07 rcw
Livrare 48-72ore

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g GTU

VOBLER RAPALA SHAD DANCER 7 cm 15 g GTU

sdd07 gtu
Livrare imediată!

49,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g HSD
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g HSD

sdd07 hsd
Livrare 48-72ore

49,00Lei

LANSETA FOX RAGE STREET FIGHTER HEAVY SHAD ROD 230CM 10-35GR

LANSETA FOX RAGE STREET FIGHTER HEAVY SHAD ROD 230CM 10-35GR

nrd362
Livrare imediată!

402,51Lei

LANSETA FOX RAGE STREET FIGHTER LIGHT SHAD ROD 220CM 5-20GR -11%

LANSETA FOX RAGE STREET FIGHTER LIGHT SHAD ROD 220CM 5-20GR

nrd361
Livrare imediată!

404,96Lei(-11%) 359,90Lei

Lanseta Zebco Quantum G-Force Shad 2.70m 14-90gr

Lanseta Zebco Quantum G-Force Shad 2.70m 14-90gr

14350271
Livrare imediată!

368,78Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g PRC
Exclusiv online!

VOBLER RAPALA SHAD DANCER 7 cm 15 g PRC

sdd07 prc
Livrare 48-72ore

49,00Lei

Spinnerbait Strike King, Hack Attack Heavy Cover, Chartreuse Sexy Shad, 21.3g -33%

Spinnerbait Strike King, Hack Attack Heavy Cover, Chartreuse Sexy Shad, 21.3g

hahc34cw-538sg
Livrare imediată!

44,96Lei(-33%) 29,90Lei

Vobler Spro Iris Underdog 70, Shad, 7cm, 13g -20%
Exclusiv online!

Vobler Spro Iris Underdog 70, Shad, 7cm, 13g

004867-01706-00000
Livrare 48-72 ore

43,99Lei(-20%) 35,20Lei

Afişare 1 - 20 din 1001 (51 pagini)
Queries: 16, Total time: 49.472 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = '747902507954c72a6ed5d4e76b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (47.772)
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('+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.184)
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.125)
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.121)
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.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
8 (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
9 (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
10 (0.126)
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.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
12 (0.073)
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.069)
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
14 (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
15 (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
16 (0.134)
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