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


Lanseta DAM Madcat New Black Heavy Duty 3.00m, 200-300g, 2seg

Lanseta DAM Madcat New Black Heavy Duty 3.00m, 200-300g, 2seg

mad.70696
Livrare imediată!

367,79Lei

Manusi Mikado Fleece - Half Finger Xl - Black - Gray
Exclusiv online!

Manusi Mikado Fleece - Half Finger Xl - Black - Gray

umr-11b-xl
Livrare 48-72 ore

51,75Lei

Pantaloni Scurti Fox Collection LW Jogger Short Black & Orange, Marime XL
Exclusiv online!

Pantaloni Scurti Fox Collection LW Jogger Short Black & Orange, Marime XL

ccl217
Livrare 7-14 zile

103,46Lei

PANTALONI SCURTI PRESTON BLACK BLUE JOGGER SHORTS L

PANTALONI SCURTI PRESTON BLACK BLUE JOGGER SHORTS L

p0200272
Livrare imediată!

134,96Lei

Scaun Modular Rive ST8 2.0 Black
Exclusiv online!

Scaun Modular Rive ST8 2.0 Black

90810118007
Livrare 48-72 ore

3.758,08Lei

Shad Hide Up Stagger Original 3.5", 142 Light Green Pumpkin Black Blue Flk, 9cm, 8buc/pac

Shad Hide Up Stagger Original 3.5", 142 Light Green Pumpkin Black Blue Flk, 9cm, 8buc/pac

hide20643
Livrare imediată!

40,00Lei

Shad Live Target Slow Roll Mullet Paddle Tail, Silver / Black, 10cm, 4buc/pac
Exclusiv online!

Shad Live Target Slow Roll Mullet Paddle Tail, Silver / Black, 10cm, 4buc/pac

f1.lt.srm100sk717
Livrare 24-48 ore

42,88Lei

Shad Live Target Slow Roll Mullet Paddle Tail, Silver / Black, 12.5cm, 4buc/pac
Exclusiv online!

Shad Live Target Slow Roll Mullet Paddle Tail, Silver / Black, 12.5cm, 4buc/pac

f1.lt.srm125sk717
Livrare 24-48 ore

42,88Lei

Soarece Live Target Hollow Body Mouse Walking Bait, Black / Black, 7cm, 14g -20%
Exclusiv online!

Soarece Live Target Hollow Body Mouse Walking Bait, Black / Black, 7cm, 14g

lt.mhb70t404
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Soarece Live Target Hollow Body Mouse Walking Bait, Black / White, 6cm, 11g -20%
Exclusiv online!

Soarece Live Target Hollow Body Mouse Walking Bait, Black / White, 6cm, 11g

lt.mhb60t403
Livrare 24-48 ore

38,51Lei(-20%) 30,81Lei

Tricou BKK Casual Legacy, Black, Marime 2XL
Exclusiv online!

Tricou BKK Casual Legacy, Black, Marime 2XL

6941780925722
Livrare 48-72 ore

155,00Lei

Tricou Korda Le Blossom Black, Marime M

Tricou Korda Le Blossom Black, Marime M

a8.kcl902
Livrare imediată!

138,88Lei

VARTEJ CU ANOU KRYSTON RING SWIVEL 7 Black
Exclusiv online!

VARTEJ CU ANOU KRYSTON RING SWIVEL 7 Black

krac47
Livrare 48-72 ore

21,00Lei

Vartej Filfishing Crane Swivel Black, nr.4/0, 135kg, 5buc/plic
Exclusiv online!

Vartej Filfishing Crane Swivel Black, nr.4/0, 135kg, 5buc/plic

fil9540
Livrare 48-72 ore

11,00Lei

Vobler Jackall TN60 Trigon, Kawashima Silhouette Gold & Black, 6cm, 8.5g
Exclusiv online!

Vobler Jackall TN60 Trigon, Kawashima Silhouette Gold & Black, 6cm, 8.5g

ja.807143157
Livrare 24-48 ore

111,24Lei

Vobler Live Target Golden Shiner Rattlebait, Glow / Black, 7.0cm, 14.0g -17%

Vobler Live Target Golden Shiner Rattlebait, Glow / Black, 7.0cm, 14.0g

lt.gs70sk211
Livrare imediată!

40,23Lei(-17%) 33,55Lei

Vobler Live Target Minnow Finesse Jerkbait, Silver / Black, 7.5cm, 7g -20%
Exclusiv online!

Vobler Live Target Minnow Finesse Jerkbait, Silver / Black, 7.5cm, 7g

lt.mjb75sk202
Livrare 24-48 ore

53,44Lei(-20%) 42,74Lei

Ancora VMC 7548 Black/Nickel Paleta Silver Nr.12, 3buc/pac
Exclusiv online!

Ancora VMC 7548 Black/Nickel Paleta Silver Nr.12, 3buc/pac

7548 bd12 x3
Livrare 48-72ore

39,00Lei

Broasca Live Target Hollow Body Frog Walking Bait, Yellow / Black, 4.5cm, 7g -20%
Exclusiv online!

Broasca Live Target Hollow Body Frog Walking Bait, Yellow / Black, 4.5cm, 7g

lt.fgh45t501
Livrare 24-48 ore

38,51Lei(-20%) 30,81Lei

Buzz Bar Carp Academy Black Carp DLX 30cm, 3 Posturi

Buzz Bar Carp Academy Black Carp DLX 30cm, 3 Posturi

6129-330
Livrare imediată!

52,00Lei

Afişare 681 - 700 din 4755 (238 pagini)
Queries: 5, Total time: 101.732 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = '1aa4de8c074118b58db22ae4b4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (101.227)
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('+black' 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 (0.191)
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.097)
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