show results for a view with certain node reference
This is what views is particularly good at, in my opinion. You should be able to get started by creating a subdivision page view. Then you should be able to create a relationship based on the reference field. This would give you access to sort based upon whether the home appeared in that subdivision.