Let's say I have homes and neighborhoods (homes reference the neighborhood they're in via a node reference field). On the home detail page I want to show other homes in the same neighborhood.
Seems simple enough, and I've found this: Create a view on a node reference field but it is not quite what I need to do, since I need to find other homes that reference the same neighborhood as the current home does (not ones that reference the current home).
I also found this: Node references view: get other nodes that also reference the same node but I am only using 2 content types (homes and neighborhoods). Any ideas? My brain is tired after trying to think through the relationships and arguments of this thing :)