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 300 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 - Enterprise

Produse ce potrivesc criteriilor de căutare


CAP SUPORT PRO FL MINI BUTT GRIPPER ALBASTRU

CAP SUPORT PRO FL MINI BUTT GRIPPER ALBASTRU

64-25027
Livrare imediată!

15,90Lei

CAP SUPORT PRO FL MINI BUTT GRIPPER Rosu

CAP SUPORT PRO FL MINI BUTT GRIPPER Rosu

64-25034
Livrare imediată!

15,90Lei

Caciula Avid Carp Minimal Green Beanie

Caciula Avid Carp Minimal Green Beanie

a0620296
Livrare imediată!

58,46Lei

Pop Up Dumbell Senzor Planet Minis, Capsuna, 4-5mm, 10g

Pop Up Dumbell Senzor Planet Minis, Capsuna, 4-5mm, 10g

6425968542067
Livrare imediată!

18,00Lei

Mini Wafters C&B N-Butyric & Capsuna, 4mm

Mini Wafters C&B N-Butyric & Capsuna, 4mm

6427416145431
Livrare imediată!

26,00Lei

Spinnerbait, Strike, King, Bleeding, Bait, Mini-King,, Bleeding, Chartreuse, White,, 3.5g, bbmk-303sg, Spinnerbaits, Spinnerbaits Strike King, Strike King
Tambur Rezerva Aluminium Mulineta Trabucco Razar 2500
Exclusiv online!

Tambur Rezerva Aluminium Mulineta Trabucco Razar 2500

034-61-125
Livrare 48-72 ore

95,00Lei

Pop Up Dumbell Senzor Planet Minis, Tutti Frutti, 4-5mm, 10g

Pop Up Dumbell Senzor Planet Minis, Tutti Frutti, 4-5mm, 10g

6425968542081
Livrare imediată!

18,00Lei

Sapca Avid Minimal Green Cap, Green

Sapca Avid Minimal Green Cap, Green

a0620298
Livrare imediată!

58,46Lei

Fox, Rage, Mini, Fry, x, 4, Mixed, UV, Colour, Pack, LOADED, 5g, 1/0, head,, 7cm,, 4, buc, nmc039, Shad-uri, Shad-uri Fox Rage, Fox Rage
Pop Up Dumbell Senzor Planet Minis, Ananas, 4-5mm, 10g

Pop Up Dumbell Senzor Planet Minis, Ananas, 4-5mm, 10g

6425968542050
Livrare imediată!

18,00Lei

Wafters Ice Dumbells Senzor Minis, Pink, 4-5mm, 15g

Wafters Ice Dumbells Senzor Minis, Pink, 4-5mm, 15g

snz99295
Livrare imediată!

18,00Lei

Tambur Rezerva Aluminium Mulineta Trabucco Razar 3500
Exclusiv online!

Tambur Rezerva Aluminium Mulineta Trabucco Razar 3500

034-61-135
Livrare 48-72 ore

95,00Lei

Geanta Avertizoare Fox Camolite Mini Micron Case
Exclusiv online!

Geanta Avertizoare Fox Camolite Mini Micron Case

clu452
Livrare 7-14 zile

161,96Lei

Pop Up Dumbell Senzor Planet Minis, Usturoi, 4-5mm, 10g

Pop Up Dumbell Senzor Planet Minis, Usturoi, 4-5mm, 10g

6425968542098
Livrare imediată!

18,00Lei

Wafters Ice Dumbells Senzor Minis, Orange, 4-5mm, 15g

Wafters Ice Dumbells Senzor Minis, Orange, 4-5mm, 15g

snz99296
Livrare imediată!

18,00Lei

Pop, Up, Dumbell, Senzor, Planet, Minis,, Krill,, 4-5mm,, 10g, 6425968542074, Boilies Pop-Up, Boilies Pop-Up Senzor, Boilies Senzor, Pop-Up Senzor, Senzor
Wafters Ice Dumbells Senzor Minis, White, 4-5mm, 15g

Wafters Ice Dumbells Senzor Minis, White, 4-5mm, 15g

snz99294
Livrare imediată!

18,00Lei

Buzz Bar Fl Aluminiu Negru Cu Conector Magnetic 3 Posturi

Buzz Bar Fl Aluminiu Negru Cu Conector Magnetic 3 Posturi

64-2129
Livrare imediată!

94,90Lei

Spinnerbait, Strike, King, Bleeding, Bait, Mini-King,, Bleeding, Chartreuse,, 3.5g, bbmk-301sg, Spinnerbaits, Spinnerbaits Strike King, Strike King
Afişare 81 - 100 din 901 (46 pagini)
Queries: 12, Total time: 236.132 ms [By time] [By id] [By file]
1 (0.146)
SELECT data
FROM `oc_session`
WHERE session_id = 'b9e00bd88cd72d75362885b5bb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.132)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.139)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (226.537)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%mini%") 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:698
5 (0.259)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
6 (0.974)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1209
7 (0.118)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1231
8 (0.199)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:996
9 (7.326)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:910
10 (0.084)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (0.104)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.114)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38