What you need to do is nest the SQL select statements. Something like this

Select

(

SELECT

'123 any Street' as "DisplayAddress",

'123432' as "LatLong/Latitude",

'-2342424' as "LatLong/Longitude"

For XML PATH(''), type) as "FoundAddress",

(SELECT

mp_Location.LocationID as "Property/@LocationID",

mp_Location.Company...