The detective senior constable with the Queensland Police Service's Crime Command was charged this week with dangerous conduct with a weapon, enter dwelling and commit offence, and sexual assault.
He was also charged with three counts of misconduct in public office, two counts each of common assault, computer hacking and misuse, distribute prohibited recording, and unlawful stalking.
He also faced one count each of deprivation of liberty and distributing intimate images.
The 36-year-old appeared on Tuesday in Brisbane Magistrates Court via videolink to apply for bail having spent one night in custody.
He would contest the charges, defence solicitor Calvin Gnech told magistrate Julian Noud.
"He has no criminal history and strong ties to the community," Mr Gnech said.
The detective was facing serious allegations and needed to demonstrate he should not be kept in custody, Mr Noud said.
"This includes most concerningly an allegation the defendant has removed his police issued firearm and held it in his hand and raised it to his own temple for a number of seconds while standing in close proximity to the complainant," Mr Noud said.
The allegations of police misconduct were particularly grave but the case could take years to resolve, the magistrate said.
The prosecutor opposed bail.
"He is facing substantial time in jail. The case could be described as strong," the prosecutor said.
Mr Noud said  there would need to be stringent bail conditions considering the nature of the charges.
Mr Gnech said his client no longer had access to the police firearm and database he was accused of misusing.
Currently suspended with pay from Queensland Police, he was initially charged with one count of stalking in March - allegedly committed while off duty.
Following that charge, he was further investigated by Ethical Standards Command and on Monday arrested on the additional charges.
Police will allege he committed offences over several years both on and off duty.
Mr Noud ordered his release on bail with the condition he be fitted with an electronic tracking device and face restrictions on social media use.
The case is due to return to court in July.
1800 RESPECT (1800 737 732)
National Sexual Abuse and Redress Support Service 1800 211 028
9°C