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


Swinger FL MKM-3 Rosu

Swinger FL MKM-3 Rosu

2243164713951
Livrare imediată!

49,00Lei

Lanseta FL Drop Carp 3.60M 3.50Lbs 2Seg Sakana Hanta

Lanseta FL Drop Carp 3.60M 3.50Lbs 2Seg Sakana Hanta

2153178730557
Livrare imediată!

311,54Lei

Lanseta Telescopica FL Fibra Sticla 2.10m

Lanseta Telescopica FL Fibra Sticla 2.10m

8255199326017
Livrare imediată!

25,89Lei

Baterie LR1 FL

Baterie LR1 FL

6927799689190
Livrare imediată!

6,10Lei

Husa FL Camuflaj 1.15m 2 Compartimente

Husa FL Camuflaj 1.15m 2 Compartimente

5192146495347
Livrare imediată!

39,90Lei

Swinger FL MKM-3 Verde

Swinger FL MKM-3 Verde

8243165015515
Livrare imediată!

49,00Lei

Swinger FL Black Multi Light JY -SW 19

Swinger FL Black Multi Light JY -SW 19

6242182884526
Livrare imediată!

60,40Lei

Lanseta Telescopica FL Fibra Sticla 3.00m

Lanseta Telescopica FL Fibra Sticla 3.00m

3255195346113
Livrare imediată!

36,20Lei

Lanseta FL Aqua Spin 2.70M 10-30Gr/2Seg

Lanseta FL Aqua Spin 2.70M 10-30Gr/2Seg

4153178910377
Livrare imediată!

91,11Lei

Mulineta FL LF 3000

Mulineta FL LF 3000

7272203005301
Livrare imediată!

93,20Lei

Varf Lanseta Strategist Spod 3.90M/5.00Lbs/2Seg

Varf Lanseta Strategist Spod 3.90M/5.00Lbs/2Seg

4841928968708
Livrare imediată!

120,80Lei

Suport Spate U Telescopic 120cm

Suport Spate U Telescopic 120cm

221253
Livrare imediată!

5,70Lei

Varga FL Happy 5M

Varga FL Happy 5M

1313158706625
Livrare imediată!

169,90Lei

Mulineta Fl Vio Steeze 2018 6000

Mulineta Fl Vio Steeze 2018 6000

4242185192255
Livrare imediată!

143,20Lei

Minciog 3 Tronsoane Aluminiu 80

Minciog 3 Tronsoane Aluminiu 80

7777047
Livrare imediată!

65,60Lei

SWINGER FL Black Multi Light Bile Magnetice JY-SW 17

SWINGER FL Black Multi Light Bile Magnetice JY-SW 17

2242185201997
Livrare imediată!

69,00Lei

Minciog FL 3 Tronsoane Aluminiu 60

Minciog FL 3 Tronsoane Aluminiu 60

7777045
Livrare imediată!

50,00Lei

Lanseta FL Aqua Spin 2.10M 10-30Gr/2Seg

Lanseta FL Aqua Spin 2.10M 10-30Gr/2Seg

8153170020025
Livrare imediată!

77,81Lei

Minciog FL 3 Tronsoane Aluminiu 70

Minciog FL 3 Tronsoane Aluminiu 70

7777046
Livrare imediată!

69,90Lei

Mulineta FL CT 4000

Mulineta FL CT 4000

8262191428021
Livrare imediată!

138,00Lei

Afişare 1181 - 1200 din 1920 (96 pagini)
Queries: 4, Total time: 588.768 ms [By time] [By id] [By file]
1 (0.084)
SELECT data
FROM `oc_session`
WHERE session_id = 'b9927c0e0b6d73f23420535010'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (588.469)
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 (pd.tag LIKE "%fl.%") 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.115)
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