What you asking sounds a lot like the Wollombi Valley website. If you look under each one of their accommodation types… each is powered by Connections. Same goes for their Wine & Produce and Local Businesses pages which shows all the businesses from the directories. This is done by separating the directory by category by using the category shortcode option. The template, they are using on their site is a custom modded version of the cMap template.
Hope that answers your question, let me know.