select
distinct View1_outer.ID as PersonID
, stuff
    (
        (select ', ' + Name
            from View1 View1_inner
            inner join View2 View2_inner
            inner join View3 View3_inner
            inner join View4 View4_inner
            where View1_inner.ID = View1_outer.ID
            for XML path('')
        )
    ,1,2,' ') as Houses
from View1 View1_outer
inner join View2 View2_outer
inner join View3 View3_outer
inner join View4 View4_outer

where View1_outer.ID = 'XXX'