73.group

  1 2
    4 3
    1 2
    ans
    1 2
    4 3
         $countPropertyRequirementVillaData  = count($propertyRequirementVillaData);

   $roomappartmenthouselocationselect = $propertyRequirementTable->select()
                    ->setIntegrityCheck(false)
                    ->from(array('property_req'=>'engine4_property_requirement',))
                    ->joinLeft(array('state'=>'engine4_state_list',),'state.state_id=property_req.state_id',array('state'))                                
                    ->joinLeft(array('city'=>'engine4_city_list',),'city.city_id=property_req.city_id',array('city'))
                    ->where('property_req.tenant_id = ?', $data['user_id'])
                    ->where('(property_req.housing_type = ?', 'House' )
->orWhere('property_req.housing_type = ?', 'Apartment')
->orWhere('property_req.housing_type = ?)', 'Room')
->group(array('city.city_id'))
;