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 JAXON ATRACT XXT-A F D 6CM 3.5GR

VOBLER JAXON ATRACT XXT-A F D 6CM 3.5GR

vr-ta060d
Stoc epuizat

19,00Lei

VOBLER JAXON ATRACT XXT-A F H 7.5CM 7GR

VOBLER JAXON ATRACT XXT-A F H 7.5CM 7GR

vr-ta075h
Stoc epuizat

25,00Lei

Vobler SALMO SLIDER SD6F 6CM 11G EP

Vobler SALMO SLIDER SD6F 6CM 11G EP

84576157
Stoc epuizat

46,01Lei

Shad 4Predators Worm Shad Floating 8 CM L016 Culoare Orange - Gold 7 buc/plic

Shad 4Predators Worm Shad Floating 8 CM L016 Culoare Orange - Gold 7 buc/plic

4p-ws8-l016
Stoc epuizat

10,00Lei

VOBLER JAXON HOLO SELECT NIDOR F OD 11CM 18GR 2.0-5.5M

VOBLER JAXON HOLO SELECT NIDOR F OD 11CM 18GR 2.0-5.5M

vj-ni11fod
Stoc epuizat

38,00Lei

Vobler Kenart Hunter Floating 2cm 1.5gr YB Yellow Black 1 buc/pac

Vobler Kenart Hunter Floating 2cm 1.5gr YB Yellow Black 1 buc/pac

hu2f-yb
Stoc epuizat

21,50Lei

VOBLER Carp Zoom PREDATOR-Z UL BUG 3.2cm 3.5gr Floating Culoare: 28

VOBLER Carp Zoom PREDATOR-Z UL BUG 3.2cm 3.5gr Floating Culoare: 28

cz3528
Stoc epuizat

33,00Lei

Vobler Salmo Rattlin Hornet 3.5F Sexy Shad 3.5cm 3.1g

Vobler Salmo Rattlin Hornet 3.5F Sexy Shad 3.5cm 3.1g

84413042
Stoc epuizat

45,01Lei

VOBLER JAXON HOLO SELECT NIDOR F N 11CM 18GR 2.0-5.5M

VOBLER JAXON HOLO SELECT NIDOR F N 11CM 18GR 2.0-5.5M

vj-ni11fn
Stoc epuizat

38,00Lei

VOBLER JAXON ATRACT F XXT-F G 8CM 12GR 0.6-2.5M

VOBLER JAXON ATRACT F XXT-F G 8CM 12GR 0.6-2.5M

vr-tf080g
Stoc epuizat

23,00Lei

VOBLER ILLEX DEEP DIVING CHUBBY SENSAS XX 3,8CM/4,7G NF ABLETTE

VOBLER ILLEX DEEP DIVING CHUBBY SENSAS XX 3,8CM/4,7G NF ABLETTE

si.03358
Stoc epuizat

109,78Lei

VOBLER JAXON KARAS SW KRX 7CM-10GR

VOBLER JAXON KARAS SW KRX 7CM-10GR

vj-kb07fkrx
Stoc epuizat

37,00Lei

Vobler Salmo Executor 5SR SFF Silver Flashy Fish 5cm 5g

Vobler Salmo Executor 5SR SFF Silver Flashy Fish 5cm 5g

84595601
Stoc epuizat

42,00Lei

Vobler Salmo SD10F Slider QSD332 10cm 36gr

Vobler Salmo SD10F Slider QSD332 10cm 36gr

84570132
Stoc epuizat

62,00Lei

VOBLER JAXON ATRACT F XXT-F K 8CM 12GR 0.6-2.5M

VOBLER JAXON ATRACT F XXT-F K 8CM 12GR 0.6-2.5M

vr-tf080k
Stoc epuizat

23,00Lei

VOBLER CORMORAN COR F4 FIRETIGER 5.5CM 4.5G

VOBLER CORMORAN COR F4 FIRETIGER 5.5CM 4.5G

f3.53.04553
Stoc epuizat

23,35Lei

VOBLER FIGHTER SDR ST 5CM-6GR -30%

VOBLER FIGHTER SDR ST 5CM-6GR

vj-fa5sdrst
Stoc epuizat

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

VOBLER RAPALA ULTRA LIGHT CRANK 3CM / 4GR HS

VOBLER RAPALA ULTRA LIGHT CRANK 3CM / 4GR HS

ulc03 hs
Stoc epuizat

42,99Lei

VOBLER RAPTURE FLAT SHACKER FLOATING CRYSTAL CHARTREUSE MATT 7CM

VOBLER RAPTURE FLAT SHACKER FLOATING CRYSTAL CHARTREUSE MATT 7CM

180-15-427
Stoc epuizat

24,00Lei

VOBLER SALMO MINNOW M5F DB, 5CM, 3G

VOBLER SALMO MINNOW M5F DB, 5CM, 3G

84425108
Stoc epuizat

37,00Lei

Afişare 3621 - 3640 din 4296 (215 pagini)
Queries: 9, Total time: 142.910 ms [By time] [By id] [By file]
1 (0.078)
SELECT data
FROM `oc_session`
WHERE session_id = '27b4a668a32bcb07692e6ef299'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.126)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (141.961)
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('+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
5 (0.154)
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
6 (0.125)
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
7 (0.141)
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.103)
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
9 (0.107)
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