Property Price Index
Property Price index is a global real estate Portal.
Array ( [page_view] => list [transaction_type] => B [statename] => Abu Dhabi [ct_id] => 53 [parent_category] => 1 [subcats] => 48,49,291,493 [filter_pcid] => 48,49,291,493 [filter_location_master_loid] => 5073 [location_properties] => [property_properties] => [cityname] => ) select * from UserCompanyView where uid in (select user_uid from All_props where usertype='A' and del_status =1 and state_id=53 and parent_id in (1) and pcid in (48,49,291,493) and location_master_loid in (5073) and country in (3) ) and company_name2 like '%' group by uid