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


Geanta Matrix Ethos Pro Feeder -32%

Geanta Matrix Ethos Pro Feeder

glu083
Stoc epuizat

214,65Lei(-32%) 147,00Lei

STRUNE SPRO INOX 1X7 30CM 18,2KG SW S 2BUC

STRUNE SPRO INOX 1X7 30CM 18,2KG SW S 2BUC

004623-00100-00403
Stoc epuizat

16,51Lei

JACHETA FREESTYLE CREWMAN L

JACHETA FREESTYLE CREWMAN L

007227-00300-00000
Stoc epuizat

361,00Lei

Prosecto Insectivorous Haiths

Prosecto Insectivorous Haiths

ing067
Stoc epuizat

35,00Lei

Strike Pro Cicada Cyber Vibe 4cm 6.6gr culoare 781 -0%

Strike Pro Cicada Cyber Vibe 4cm 6.6gr culoare 781

sp.jg005b.781
Stoc epuizat

30,29Lei(-0%) 30,27Lei

Kit Prologic Buzz Bar Avenger Pentru 3 Posturi + Husa

Kit Prologic Buzz Bar Avenger Pentru 3 Posturi + Husa

a6.pro.65023
Stoc epuizat

284,27Lei

Heli-Chod PB Products Downforce Rubber & Beads X-Small 4buc/plic

Heli-Chod PB Products Downforce Rubber & Beads X-Small 4buc/plic

pb19230
Stoc epuizat

29,00Lei

Geanta Zebco Pro Staff Rig and LureBag 30x16x20cm

Geanta Zebco Pro Staff Rig and LureBag 30x16x20cm

8407005
Stoc epuizat

179,79Lei

SHAD SPRO FREESTYLE URBAN PREY SLUG CAMO PERCH 3.7CM 6BUC PLIC

SHAD SPRO FREESTYLE URBAN PREY SLUG CAMO PERCH 3.7CM 6BUC PLIC

004695-00502-00000
Stoc epuizat

24,89Lei

SHAD SPRO IRIS POP EYE 14 CM UV SUNBURST

SHAD SPRO IRIS POP EYE 14 CM UV SUNBURST

004664-00206-00000
Stoc epuizat

18,90Lei

LINGURA JAXON HR PRO SPIN DOUBLE HIX 1D 18GR

LINGURA JAXON HR PRO SPIN DOUBLE HIX 1D 18GR

bw-hix1d
Stoc epuizat

12,00Lei

Mulineta Carp Expert Pro Cast Method Feeder 6000

Mulineta Carp Expert Pro Cast Method Feeder 6000

20112600
Stoc epuizat

384,00Lei

Shad Lucky John Pro Series Chunk Tail 2inch 5cm SB05 Dark Green 10 buc/plic

Shad Lucky John Pro Series Chunk Tail 2inch 5cm SB05 Dark Green 10 buc/plic

lj-ct2-sb05
Stoc epuizat

16,01Lei

TRICOU SPRO PREDATOR OFFSCALE MAR XXL

TRICOU SPRO PREDATOR OFFSCALE MAR XXL

007208-00500-00000
Stoc epuizat

69,50Lei

LINGURA JAXON HR PRO SPIN DOUBLE HIX 2B 25GR

LINGURA JAXON HR PRO SPIN DOUBLE HIX 2B 25GR

bw-hix2b
Stoc epuizat

12,50Lei

STARLETI SPRO NEON GLOWSTICK CLIP ON L

STARLETI SPRO NEON GLOWSTICK CLIP ON L

4199-006
Stoc epuizat

3,75Lei

FIR TEXTIL SUFIX MATRIX PRO 135M 0.12MM 18LB 8.1KG ORANGE

FIR TEXTIL SUFIX MATRIX PRO 135M 0.12MM 18LB 8.1KG ORANGE

ds1wt0148gfb1p
Stoc epuizat

99,00Lei

CAP TWISTER SPRO-GAMAKATSU ROTUND JIG 23 5/0 5 GR 4BUC

CAP TWISTER SPRO-GAMAKATSU ROTUND JIG 23 5/0 5 GR 4BUC

4931-500-005
Stoc epuizat

13,20Lei

Jig 22 Spro Cu Carlig Gamakatsu Nr.4/0, 5g, 4buc/plic

Jig 22 Spro Cu Carlig Gamakatsu Nr.4/0, 5g, 4buc/plic

4931-400-005
Stoc epuizat

12,80Lei

MONTURA PROLOGIC 15CM CU CARLIG XC7 NR.4 2BUC

MONTURA PROLOGIC 15CM CU CARLIG XC7 NR.4 2BUC

a.pro.50106
Stoc epuizat

20,50Lei

Afişare 6481 - 6500 din 7177 (359 pagini)
Queries: 9, Total time: 654.266 ms [By time] [By id] [By file]
1 (0.069)
SELECT data
FROM `oc_session`
WHERE session_id = 'e16ba685e4141edc62899ce642'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.118)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (625.570)
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 (pd.tag LIKE "%pro%") 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 (27.854)
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 6480, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.190)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"OVIDIUS DOCTOR FISHING SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.128)
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
8 (0.123)
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.132)
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