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


Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 15.1L / 16QT, Polar White

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 15.1L / 16QT, Polar White

10-01623-123
Livrare imediată!

478,74Lei

Lada Frigorifica Plano Frost 32QT -20%
Exclusiv online!

Lada Frigorifica Plano Frost 32QT

p000083
Livrare 7-14 zile

855,00Lei(-20%) 685,00Lei

Lada Frigorifica STANLEY The Cold-For-Days Outdoor Cooler 28.3L / 30QT, Polar

Lada Frigorifica STANLEY The Cold-For-Days Outdoor Cooler 28.3L / 30QT, Polar

10-01936-039
Livrare imediată!

1.067,89Lei

Lada Frigorifica Pasiva cu Roti Coleman Marine Xtreme 2023 94
Exclusiv online!

Lada Frigorifica Pasiva cu Roti Coleman Marine Xtreme 2023 94

2000037402
Livrare 24-48 ore

1.500,00Lei

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 15.1L / 16QT, Stanley Green

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 15.1L / 16QT, Stanley Green

10-01623-197
Livrare imediată!

496,46Lei

Lada Frigorifica Electrica 12/230V Campingaz Powerbox Plus 24l
Exclusiv online!

Lada Frigorifica Electrica 12/230V Campingaz Powerbox Plus 24l

2000037453
Livrare 24-48 ore

698,99Lei

Lada Frigorifica Pasiva cu Roti Coleman Marine Xtreme 2023, 47l
Exclusiv online!

Lada Frigorifica Pasiva cu Roti Coleman Marine Xtreme 2023, 47l

3000005137
Livrare 24-48 ore

999,01Lei

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 6.6L / 7QT, Polar

Lada Frigorifica STANLEY The Easy-Carry Outdoor Cooler 6.6L / 7QT, Polar

10-01622-086
Livrare imediată!

349,80Lei

Lada Frigorifica Campingaz Powerbox Plus 24l
Exclusiv online!

Lada Frigorifica Campingaz Powerbox Plus 24l

2000024955
Livrare 24-48 ore

599,00Lei

Lada Frigorifica Plano Frost 21QT

Lada Frigorifica Plano Frost 21QT

p000073
Livrare imediată!

585,00Lei

Lada Frigorifica Plano Frost 14QT -20%
Exclusiv online!

Lada Frigorifica Plano Frost 14QT

p000063
Livrare 7-14 zile

495,00Lei(-20%) 396,00Lei

Lada Frigorifica Igloo Eskimo Blue 57 L -9%

Lada Frigorifica Igloo Eskimo Blue 57 L

igltpx 6005c
Stoc epuizat

274,90Lei(-9%) 249,90Lei

Lada Frigorifica IGLOO MARINE CONTOUR 70 White 66L -18%

Lada Frigorifica IGLOO MARINE CONTOUR 70 White 66L

00050069
Stoc epuizat

1.102,05Lei(-18%) 899,90Lei

Lada Frigorifica Igloo Contour Marine, Blue, 23L, 46x30x39cm -5%

Lada Frigorifica Igloo Contour Marine, Blue, 23L, 46x30x39cm

igl00049644
Stoc epuizat

241,90Lei(-5%) 229,90Lei

Dop pentru Sistem Scurgere Lada Frigorifica Coleman

Dop pentru Sistem Scurgere Lada Frigorifica Coleman

5010001683
Stoc epuizat

55,00Lei

Lada Frigorifica Coleman Convoy 62L, Gri, 73x38x47cm

Lada Frigorifica Coleman Convoy 62L, Gri, 73x38x47cm

2193724
Stoc epuizat

1.144,99Lei

Lada Frigorifica Coleman Convoy 62L, Gri, 73x38x47cm

Lada Frigorifica Coleman Convoy 62L, Gri, 73x38x47cm

2193723
Stoc epuizat

624,00Lei

Lada Frigorifica Stanley, The Cold-For-Days, Green, 28.3L

Lada Frigorifica Stanley, The Cold-For-Days, Green, 28.3L

10-01936-062
Stoc epuizat

1.067,91Lei

Lada frigorifica electrica Campingaz Powerbox Plus 36l -7%

Lada frigorifica electrica Campingaz Powerbox Plus 36l

2000024957
Stoc epuizat

749,00Lei(-7%) 698,99Lei

Lada izoterma cu roti Coleman Xtreme 58l

Lada izoterma cu roti Coleman Xtreme 58l

2000037213
Stoc epuizat

950,00Lei

Afişare 21 - 40 din 49 (3 pagini)
Queries: 8, Total time: 2.604 ms [By time] [By id] [By file]
1 (0.196)
SELECT data
FROM `oc_session`
WHERE session_id = '065c2f62e7c469946fe4173a11'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1.709)
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 = '2' AND (MATCH(pd.tag) AGAINST('+lazi' 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.131)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TWINS SOFIA LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.114)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TWINS SOFIA LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.112)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TWINS SOFIA LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.112)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.125)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38