Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

Lada, frigorifica, electrica, Campingaz, Powerbox, Plus, 28l, 2000024956, Lazi Frigorifice, Lazi Frigorifice Campingaz, Campingaz

-8%

Exclusiv online!

Lada, frigorifica, electrica, Campingaz, Powerbox, Plus, 28l, 2000024956, Lazi Frigorifice, Lazi Frigorifice Campingaz, Campingaz

2000024956

Livrare 24-48 ore

649,00Lei(-8%) 599,00Lei

-20%

Exclusiv online!

Kit 4 Mulinete Prowess Insedia 8004 FD

995020007

Livrare 48-72 ore

1.374,20Lei(-20%) 1.099,36Lei

Mulineta, Tica, Galant, GBAT, 2000, gbat2000, Mulinete Feeder, Mulinete Feeder Tica, Tica

gbat2000

Livrare imediată!

355,00Lei

Exclusiv online!

Aragaz Campingaz Base Camp

2000009597

Livrare 24-48 ore

230,00Lei

-24%

Exclusiv online!

Toaleta portabila Campingaz 20l

2000030582

Livrare 24-48 ore

790,01Lei(-24%) 599,00Lei

PB SINKING RIG TUBE WEED-VEGETATIE 2M / 0,75MM

pb20003

Livrare imediată!

20,00Lei

Exclusiv online!

Caiac Sevylor Ottawa gonflabil

2000026702

Livrare 24-48 ore

3.599,00Lei

Mulineta Carp Zoom Predator-Z Oplus Flash 2000FD

-30%

Exclusiv online!

Mulineta Carp Zoom Predator-Z Oplus Flash 2000FD

cz3079

Livrare 48-72 ore

156,00Lei(-30%) 109,00Lei

Zebco Bank Stick stainless steel 75cm

8200010

Livrare imediată!

31,29Lei

Exclusiv online!

Cort de evenimente pavilion Coleman 4.5x4.5m

2000016832

Livrare 24-48 ore

1.649,99Lei

Mulineta, Spinning, Ryobi, Zauber, 2000, 22105201, Mulinete Rapitori, Mulinete Rapitori Ryobi, Mulinete Ryobi, Rapitori Ryobi, Mulinete Match, Mulinete Match Ryobi, Mulinete Ryobi, Match Ryobi, Ryobi

22105201

Livrare imediată!

590,00Lei

-14%

Mulineta K-Karp FUSION 12000

037-81-120

Livrare imediată!

395,00Lei(-14%) 339,90Lei

Husa ZEBCO Rod Holdall 150x10x8cm

8420005

Livrare imediată!

71,78Lei

-20%

Exclusiv online!

Kit 4 Mulinete Prowess Excelia 6008FD

995020008

Livrare 48-72 ore

1.909,70Lei(-20%) 1.527,76Lei

Agrafa Sakura Hooked Snap Nickelees Nr 000 4kg

sapab1002000-nkl

Livrare imediată!

6,37Lei

-16%

Aragaz Campingaz Party Grill 200

2000023716

Livrare imediată!

537,00Lei(-16%) 449,00Lei

Exclusiv online!

Caiac Sevylor Hudson gonflabil

2000014708

Livrare 24-48 ore

3.230,01Lei

Pluta, Balsa, Mostiro, Cristina, R, 2.00Gr, 2420030520000-bucxxx, Plute Stationar, Plute Stationar Mostiro, Mostiro

2420030520000-bucxxx

Livrare imediată!

3,80Lei

Exclusiv online!

Tija Cupru pt.Monturi Somn Black Cat Baiting Wire 1.0mm 120mm

403226152000

Livrare 48-72 ore

11,98Lei

Agrafa Sakura Diamond Snap Nickelees Nr 2 22kg

41034acsk3200020

Livrare imediată!

9,69Lei

Afişare 261 - 280 din 1029 (52 pagini)

Queries: 10, Total time: 853.690 ms [By time] [By id] [By file]

1 (0.088)

SELECT data
FROM `oc_session`
WHERE session_id = '81ec8a15b51739dc8d82b80b38'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.087)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.089)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (480.034)

SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%2000%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555

5 (372.786)

SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%2000%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 260, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

6 (0.146)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
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)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%2000%") AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066

7 (0.129)

SELECT COUNT(*) AS val, filter_group, filter_id
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)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%2000%") AND p.status_filtru > 0 AND p.price > 0 AND f.language_id = '2' GROUP BY p.product_id, filter_group, filter_id HAVING match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911

8 (0.110)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

9 (0.103)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

10 (0.118)

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

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare