Property Dealer for Residential Properties in SS4, Petaling Jaya (1 Results Found)

Array
(
    [page_view] => list
    [transaction_type] => B
    [ct_id] => 3190
    [parent_category] => 1
    [subcats] => 116,117,119,120,121,122
    [filter_pcid] => 116,117,119,120,121,122
    [filter_location_master_loid] => 4948
    [all_filter_id] => 284
    [all_pagination_agent_id] => 284
    [location_properties] => 
    [property_properties] => 
    [cityname] => Petaling Jaya
)
select * from UserCompanyView where uid in (select user_uid from All_props where usertype='A' and del_status =1  and city_id=3190 and parent_id in (1)  and pcid in (116,117,119,120,121,122)  and location_master_loid in (4948)  and country in (26) ) and company_name2 like '%' group by uid  GS REALTY SDN BHD