Take a look at this site
Have a look at this site www.chrismcavoylettings.co.uk all the mapping is done in propmaps with minor hand alteration to set the centre and the level of magification.
This is houses you say but the issue is just the same as members there is a list and/or a map showing all the houses and then a detail page for each house same as a members list and a profile.
The switch from list to detail is managed by the standard Dreamweaver go to detail behaviour which should resolve your sql - the problem is nothing to do with Promaps but is down to you creating the correct sql that reads the parameter (ckey) passed from the list table to the second/detail page from your second table and then using the resulting single record file as the datafile in propmaps.
Hope this helps