Looking at all the new search capability in 2013 I'm thinking this should be do-able.. where as in 2010 we put it in the "too hard basket"
Basically we plan to build some site collections (project template) and each site collection will contain a list that will have columns such as project name, project manager, start date and end date. The column names and the list names will always be the same. The site collections will always be under the managed path /proj/
Now, I'd like to be able to display a page that shows the result of a query against all these site collections. So if there are 7 site collections there will be 7 results showing the columns mentioned above. I don't want to use the standard core results with a query builder using "path" as I want spefici list column values in my results rather than the normal hyperlink and synopsis