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


Cap Minciog Pro TF By Dome 55x65cm Cauciucat

Cap Minciog Pro TF By Dome 55x65cm Cauciucat

4265-601
Stoc epuizat

135,01Lei

Mulineta FL Team Feeder TF 7000

Mulineta FL Team Feeder TF 7000

64-0976
Stoc epuizat

127,70Lei

Lanseta DAM Madcat Black Allround 2.85m 100-250gr

Lanseta DAM Madcat Black Allround 2.85m 100-250gr

2033170701
Stoc epuizat

307,88Lei

Lanseta DAM Madcat Black Vertical 1.90m 150gr

Lanseta DAM Madcat Black Vertical 1.90m 150gr

2033170699
Stoc epuizat

445,79Lei

Lanseta DAM Shadow Tele 2.10m 5-25gr

Lanseta DAM Shadow Tele 2.10m 5-25gr

2040970346
Stoc epuizat

212,22Lei

Mulineta FL Team Feeder TF 6000

Mulineta FL Team Feeder TF 6000

64-0975
Stoc epuizat

139,90Lei

Agrafa Vartej DAM Detek Double Link Swivel Nr.8

Agrafa Vartej DAM Detek Double Link Swivel Nr.8

4030466000
Stoc epuizat

13,61Lei

Mulineta FL Team Feeder TF 5000

Mulineta FL Team Feeder TF 5000

64-0974
Stoc epuizat

139,90Lei

Lanseta DAM Salt-X Boat Quiver 2.40m 250gr

Lanseta DAM Salt-X Boat Quiver 2.40m 250gr

2080965747
Stoc epuizat

326,90Lei

Agrafa Vartej Rolling DAM Detek Swivel Bead cu Margea Culisanta

Agrafa Vartej Rolling DAM Detek Swivel Bead cu Margea Culisanta

4030466004
Stoc epuizat

14,01Lei

Vartej Rolling DAM Detek Quick Change Swivel Bead Nr.8

Vartej Rolling DAM Detek Quick Change Swivel Bead Nr.8

4030466008
Stoc epuizat

13,14Lei

Geanta DAM Effzett Pro-Tact Sling Bag 27.5x18.5x4.5cm 2 M Lure Cases

Geanta DAM Effzett Pro-Tact Sling Bag 27.5x18.5x4.5cm 2 M Lure Cases

9042971254
Stoc epuizat

344,81Lei

Lanseta Team Feeder By Dome Royal Method Carp 4.20M 50-140g 3+3SEG

Lanseta Team Feeder By Dome Royal Method Carp 4.20M 50-140g 3+3SEG

1848-421
Stoc epuizat

790,01Lei

OCHELARI POLARIZATI TEAM FEEDER BY DOME ANGEL

OCHELARI POLARIZATI TEAM FEEDER BY DOME ANGEL

7720-104
Stoc epuizat

79,19Lei

Jacheta DAM Dryzone Wading Jacket L Black Grey

Jacheta DAM Dryzone Wading Jacket L Black Grey

8030965501
Stoc epuizat

463,04Lei

Husa DAM Effzett Pro-Tact Single Rod Sleeve 150cm Up To 2.75m

Husa DAM Effzett Pro-Tact Single Rod Sleeve 150cm Up To 2.75m

9052971261
Stoc epuizat

125,35Lei

GEACA JAXON IMPERMEABILA FISHING TEAM XS XXL -30%

GEACA JAXON IMPERMEABILA FISHING TEAM XS XXL

uj-ftgxxl
Stoc epuizat

164,90Lei(-30%) 115,00Lei

OCHELARI POLARIZATI TEAM FEEDER BY DOME LION

OCHELARI POLARIZATI TEAM FEEDER BY DOME LION

7720-103
Stoc epuizat

80,00Lei

Husa lansete Dragon Team 3 compartimente 130cm -15%

Husa lansete Dragon Team 3 compartimente 130cm

chr9600130
Stoc epuizat

294,00Lei(-15%) 249,90Lei

OCHELARI POLARIZATI TEAM FEEDER BY DOME RAPTOR -20%

OCHELARI POLARIZATI TEAM FEEDER BY DOME RAPTOR

7720-102
Stoc epuizat

99,00Lei(-20%) 79,19Lei

Afişare 1041 - 1060 din 1214 (61 pagini)
Queries: 7, Total time: 32.793 ms [By time] [By id] [By file]
1 (0.066)
SELECT data
FROM `oc_session`
WHERE session_id = 'a3ca6738169fe916b759096103'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (27.390)
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('+team' 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
4 (4.875)
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 1040, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.128)
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
6 (0.097)
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
7 (0.142)
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