Is the word by a noun or pronoun?

One way is to say "we went by a house the other day that smelt weird." that's all i can think of right now. There's also "I went by a house the other day that smelt good, and i wanted to BUY it."