Powell's books, and don't forget the separate technical books location: http://www.yelp.com/biz/powells-city-of-books-portland-3 http://www.powells.com/locations/powells-technical-books/

Great coffee: http://www.yelp.com/biz/coffeehouse-northwest-portland http://stumptowncoffee.com/

Fun bars: http://www.dougfirlounge.com/ http://www.rontoms.net/

Cool neighborhoods to explore: - SE Hawthorne - Pearl District - Northwest