$q = 'SELECT rs.*,rr.*,cs.*,cr.*,cl.*,ls.*,ll.* FROM 
               tbl_residential_sale as rs,
               tbl_residential_rent as rr,
               tbl_commercial_sale as cs,
               tbl_commercial_rent as cr,
               tbl_commercial_lease as cl,
               tbl_land_sale as ls,
               tbl_land_lease as ll
               WHERE 
               rs.start_date IS NOT NULL AND rs.expire_date >= NOW() AND rs.region_id=1
               AND
               rr.start_date IS NOT NULL AND rr.expire_date >= NOW() AND rr.region_id=1
               AND
               cs.start_date IS NOT NULL AND cs.expire_date >= NOW() AND cs.region_id=1
               AND
               cr.start_date IS NOT NULL AND cr.expire_date >= NOW() AND cr.region_id=1
               AND
               cl.start_date IS NOT NULL AND cl.expire_date >= NOW() AND cl.region_id=1
               AND
               ls.start_date IS NOT NULL AND ls.expire_date >= NOW() AND ls.region_id=1
               AND
               ll.start_date IS NOT NULL AND ll.expire_date >= NOW() AND ll.region_id=1';

select * from  tbl_residential_sale as rs join tbl_residential_rent as rr
         join  tbl_commercial_sale as cs join tbl_commercial_rent as cr
         join  tbl_commercial_lease as cl join tbl_land_sale as ls
         join  tbl_land_lease as ll