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


Mulineta Abu Garcia Spike Pro Spinning Reel, 3000SH

Mulineta Abu Garcia Spike Pro Spinning Reel, 3000SH

1564207
Stoc epuizat

944,96Lei

SET 3 CARLIGE LEGATE PLUS CROSETA SI OPRITOARE NR 8 15LB PRO FL

SET 3 CARLIGE LEGATE PLUS CROSETA SI OPRITOARE NR 8 15LB PRO FL

64-48637
Stoc epuizat

11,90Lei

Shad Fox Rage Zander Pro Ultra UV - Red Belly Roller, 12cm

Shad Fox Rage Zander Pro Ultra UV - Red Belly Roller, 12cm

nzs108
Stoc epuizat

6,71Lei

UNDITA PRO FL PHENOMENON 10-30G, 7.00M

UNDITA PRO FL PHENOMENON 10-30G, 7.00M

64-4034
Stoc epuizat

142,90Lei

Lanseta Abu Garcia Spike Pro Jigging Rod 902M, 12-32g, 2.74m, 2seg

Lanseta Abu Garcia Spike Pro Jigging Rod 902M, 12-32g, 2.74m, 2seg

1539762
Stoc epuizat

1.169,96Lei

MANER MINCIOG PRO FL COMPETITION TELE 3.00M

MANER MINCIOG PRO FL COMPETITION TELE 3.00M

64-45773
Stoc epuizat

85,89Lei

MULINETA PRO FL NOBLE FEEDER HP 7500

MULINETA PRO FL NOBLE FEEDER HP 7500

8183248123709
Stoc epuizat

209,90Lei

Combo Mitchell Catch Pro Tele Adjustable, 4.00m, 2-10g, 4seg

Combo Mitchell Catch Pro Tele Adjustable, 4.00m, 2-10g, 4seg

1544464
Stoc epuizat

189,95Lei

Combo Spinning Abu Garcia Pro Max Spinning H, 20-60g, 2.74m, 2seg

Combo Spinning Abu Garcia Pro Max Spinning H, 20-60g, 2.74m, 2seg

1531511
Stoc epuizat

539,96Lei

Combo Spinning Mitchell Catch Pro Lanseta Cu Mulineta L, 5-15g, 1.80m,2seg
Lanseta Baitcast Abu Garcia Beast Pro Casting Allr Pike Rod 802H, 40-100g, 2.44m, 2seg
MULINETA PRO FL PIONER LAC 6000

MULINETA PRO FL PIONER LAC 6000

64-13352
Stoc epuizat

104,90Lei

MULINETA PRO FL STRATEGIST FEEDER PRO BLUE 7000

MULINETA PRO FL STRATEGIST FEEDER PRO BLUE 7000

8183248634991
Stoc epuizat

276,90Lei

MULINETA PRO FL STRATEGIST FEEDER PRO Red 8000

MULINETA PRO FL STRATEGIST FEEDER PRO Red 8000

7183247492364
Stoc epuizat

289,90Lei

MULINETA PRO FL ULTIMATE FEEDER FD 8000

MULINETA PRO FL ULTIMATE FEEDER FD 8000

64-13437
Stoc epuizat

189,90Lei

Pavilion Modular Nash Bank Life Gazebo Camo Pro

Pavilion Modular Nash Bank Life Gazebo Camo Pro

t1320
Stoc epuizat

4.500,00Lei

Shad Fox Rage Zander Pro Ultra UV - Pink Candy, 7.5cm -30%

Shad Fox Rage Zander Pro Ultra UV - Pink Candy, 7.5cm

nsl1263
Stoc epuizat

4,45Lei(-30%) 3,12Lei

UNDITA PRO FL PHENOMENON 10-30G, 5.00M

UNDITA PRO FL PHENOMENON 10-30G, 5.00M

64-4032
Stoc epuizat

95,90Lei

Combo Spinning Abu Garcia Pro Max Spinning L, 5-15g, 2.13m, 2seg

Combo Spinning Abu Garcia Pro Max Spinning L, 5-15g, 2.13m, 2seg

1531504
Stoc epuizat

494,96Lei

Lanseta Abu Garcia Beast Pro Pike Spinning 802H, 40-100g, 2.44m, 2buc

Lanseta Abu Garcia Beast Pro Pike Spinning 802H, 40-100g, 2.44m, 2buc

1528387
Stoc epuizat

899,96Lei

Afişare 3141 - 3160 din 3904 (196 pagini)
Queries: 5, Total time: 101.284 ms [By time] [By id] [By file]
1 (0.162)
SELECT data
FROM `oc_session`
WHERE session_id = 'fc6482220f6d30c0cfc237b7a2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (100.659)
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('+pro' 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.178)
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
5 (0.179)
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