Or you can get it simply using:
SELECT Name FROM <TABLE> WHERE (Type='Region' AND Value = '9000') OR (Type='Service' AND Value= '6000') GROUP BY Name
Assuming the two types "region" and "Service" are different and you want the ability to say, if a Name has A or B then the above should work. If you change the A or B to AND then you simply change the OR to AND.
Jbutton got the right idea but it will get duplicates, op just wants the name and no duplicates so adding the GROUP BY clause will accomplish that.
OP original assumption is an error because it seems "region = 9000 and service = 6000"
region, service are text within the type field and 9000, 6000 are values within the value field.