I was thinking more on line of

SELECT XX.XY, XX.YY, XX.YX

FROM Properties

JOIN XX ON XX.RMPROPID = Properties.RMPROPID

WHERE Properties.RMPROPID IN (@PROPERTIES)

Which will give you one row per property and each column required in the report (i.e. XY = Units)

This is only guesswork since you have not supplied any DDL or sample data as requested by others.