SELECT l.sysid,l.144, l.18, l.922,l.924,l.10 as Zip,l.881,l.137,l.25 as Beds,l.92 as Baths,l.1 as PropertyType,numpics, `276` as tp FROM RE1 l WHERE l.136 ='3097642' UNION ALL SELECT l.sysid,l.144, l.18, l.922,l.924,l.10 as Zip,l.881,l.137,l.25 as Beds,l.92 as Baths,l.1 as PropertyType,numpics, `370` as tp FROM RE2 l WHERE l.136 ='3097642' UNION ALL SELECT l.sysid,l.144, l.18, l.922,l.924,l.10 as Zip,l.881,l.137,l.25 as Beds,l.92 as Baths,l.1 as PropertyType,numpics, `588` as tp FROM RNT l WHERE l.136 ='3097642' UNION ALL SELECT l.sysid,l.144, l.18, l.922,l.924,l.10 as Zip,l.881,l.137,'0' as Beds,'0' as Baths,l.1 as PropertyType,numpics, `1` as tp FROM RIN l WHERE l.136 ='3097642' UNION ALL SELECT l.sysid,l.144, l.18, l.922,l.924,l.10 as Zip,l.881,l.137,'0' as Beds,'0' as Baths,l.1 as PropertyType,numpics, `1` as tp FROM RLD l WHERE l.136 ='3097642'