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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Forceps Ron Thompson Curbat 12.5cm

Forceps Ron Thompson Curbat 12.5cm

6010915237
Stoc epuizat

34,99Lei

Vesta Ron Thompson Mesh Lite Fly Marime XL

Vesta Ron Thompson Mesh Lite Fly Marime XL

a8.tho.45510
Stoc epuizat

132,08Lei

LANSETA RON THOMPSON 2BUC.REFINED CARP 3,60M/3,25LBS

LANSETA RON THOMPSON 2BUC.REFINED CARP 3,60M/3,25LBS

o.tho.61355
Stoc epuizat

130,20Lei

Varga RON THOMPSON REFINED TRAVELPOLE 4.00M

Varga RON THOMPSON REFINED TRAVELPOLE 4.00M

o.tho.61371
Stoc epuizat

69,31Lei

Varga RON THOMPSON REFINED TRAVELPOLE 3.00M

Varga RON THOMPSON REFINED TRAVELPOLE 3.00M

o.tho.61370
Stoc epuizat

61,30Lei

Tripod Ron Thompson Trepied Telescopic RT Match

Tripod Ron Thompson Trepied Telescopic RT Match

j1802412
Stoc epuizat

112,00Lei

Lanseta Ron Thompson Steelhead Iconic Spin, 2.70m, 7-28g, 2buc

Lanseta Ron Thompson Steelhead Iconic Spin, 2.70m, 7-28g, 2buc

o.tho.61415
Stoc epuizat

181,42Lei

UMBRELA RON THOMPSON DELUXE, 250CM -40%

UMBRELA RON THOMPSON DELUXE, 250CM

o.tho.33369
Stoc epuizat

313,03Lei(-40%) 187,82Lei

Lanseta Ron Thompson Steelhead Iconic Spin, 2.40m, 7-28g, 2buc

Lanseta Ron Thompson Steelhead Iconic Spin, 2.40m, 7-28g, 2buc

o.tho.61413
Stoc epuizat

122,65Lei

LANSETA RON THOMPSON O.T.T. FEEDER 3.30M/10-60G 2+4SEG

LANSETA RON THOMPSON O.T.T. FEEDER 3.30M/10-60G 2+4SEG

o.tho.62150
Stoc epuizat

182,86Lei

LANSETA RON THOMPSON SPINNING 2BUC.STEELHEAD ICONIC SPIN 2,10M/15-35G

LANSETA RON THOMPSON SPINNING 2BUC.STEELHEAD ICONIC SPIN 2,10M/15-35G

o.tho.61412
Stoc epuizat

137,39Lei

Lanseta Ron Thompson Hard Core, 2.40m, 80-150g, 2buc

Lanseta Ron Thompson Hard Core, 2.40m, 80-150g, 2buc

o.tho.61330
Stoc epuizat

149,37Lei

Varga RON THOMPSON REFINED TELEPOLE 5.00M

Varga RON THOMPSON REFINED TELEPOLE 5.00M

o.tho.61368
Stoc epuizat

60,90Lei

Lanseta Copca Ron Thompson Ice Pro 45cm 1SEG

Lanseta Copca Ron Thompson Ice Pro 45cm 1SEG

o.tho.54060
Stoc epuizat

28,50Lei

Varga RON THOMPSON REFINED TELEPOLE 3.00M

Varga RON THOMPSON REFINED TELEPOLE 3.00M

o.tho.61366
Stoc epuizat

26,79Lei

Tripod Ron Thompson LUXURY TRIPOD TR-140

Tripod Ron Thompson LUXURY TRIPOD TR-140

j1802422
Stoc epuizat

184,00Lei

Lanseta Ron Thompson Hard Core, 2.10m, 80-150g, 2buc

Lanseta Ron Thompson Hard Core, 2.10m, 80-150g, 2buc

o.tho.61329
Stoc epuizat

145,54Lei

Varga RON THOMPSON REFINED TELEPOLE 4.00M

Varga RON THOMPSON REFINED TELEPOLE 4.00M

o.tho.61367
Stoc epuizat

44,49Lei

MANUSI RON THOMPSON HEAT NEOPREN MARIME M

MANUSI RON THOMPSON HEAT NEOPREN MARIME M

a8.tho.55727
Stoc epuizat

95,08Lei

Lanseta Feeder Ron Thompson O.T.T. Feeder 3.90m 60-120g

Lanseta Feeder Ron Thompson O.T.T. Feeder 3.90m 60-120g

o.tho.64839
Stoc epuizat

223,36Lei

Afişare 41 - 60 din 61 (4 pagini)
Queries: 4, Total time: 3.195 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = 'e1aff290db2e4247dec408d099'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (2.794)
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('+ron' 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.152)
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