SharePoint ListView that points to List from another site in the same site collection

In a few words, it's not possible. SharePoint ListViews only load lists from the current site. My solution was to use a .NET ListView that has its DataSource property set to SPListItemCollection.GetDataTable().

Of course, you also have to set the Layout template of the ListView, as well as the EmptyTempate and the ItemTemplate. It's just a couple of extra lines of code to write.