The grossest type of anartha which binds the conditioned soul in material existence is sex desire, and this sex desire gradually develops in the union of the male and female. When the male and female are united, the sex desire is further aggravated by the accumulation of buildings, children, friends, relatives and wealth. When all these are acquired, the conditioned soul becomes overwhelmed by such entanglements, and the false sense of egoism, or the sense of "myself" and "mine," becomes prominent, and the sex desire expands to various political, social, altruistic, philanthropic and many other unwanted engagements, resembling the foam of the sea waves, which becomes very prominent at one time and at the next moment vanishes as quickly as a cloud in the sky. The conditioned soul is encircled by such products, as well as products of sex desire, and therefore bhakti-yoga leads to gradual evaporation of the sex desire, which is summarized in three headings, namely profit, adoration and distinction. All conditioned souls are mad after these different forms of sex desire, and one shall see for himself how much he has been freed from such material hankerings based primarily on the sex desire. As a person feels his hunger satisfied after eating each morsel of foodstuff, he must similarly be able to see the degree to which he has been freed from sex desire. The sex desire is diminished along with its various forms by the process of bhakti-yoga because bhakti-yoga automatically, by the grace of the Lord, effectively results in knowledge and renunciation, even if the devotee is not materially very well educated.
(Srimad Bhagavatam---2:2:12---purport).

In Bhagavad-gītā sexual intercourse for begetting children is accepted as righteous. A person sexually inclined for simple sense gratification, however, is unrighteous. In Diti's appeal to her husband for sex, it was not exactly that she was afflicted by sex desires, but she desired sons. Since she had no sons, she felt poorer than her co-wives. Therefore Kasyapa was supposed to satisfy his bona fide wife.
(Srimad Bhagavatam--3:14:11---purport).

Sex life is the background of material existence. Here also it is repeated that demons are very fond of sex life. The more one is free from the desires for sex, the more he is promoted to the level of the demigods; the more one is inclined to enjoy sex, the more he is degraded to the level of demoniac life.
(Srimad Bhagavatam--3:20:23---purport).

Without being attached by sex, the husband and wife may live together for the advancement of spiritual life. The husband should engage in devotional service, and the wife should be faithful and religious according to the Vedic injunctions. Such a combination is very good. However, if the husband becomes too much attracted to the wife due to sex, the position becomes very dangerous. Women in general are very much sexually inclined. Indeed, it is said that a woman's sex desire is nine times stronger than a man's. It is therefore a man's duty to keep a woman under his control by satisfying her, giving her ornaments, nice food and clothes, and engaging her in religious activities. Of course, a woman should have a few children and in this way not be disturbing to the man. Unfortunately, if the man becomes attracted to the woman simply for sex enjoyment, then family life becomes abominable.
(Srimad Bhagavatam----4:27:1---purport).

Prostitute hunting is so abominable that the desire for sex with a prostitute can ruin one's character, destroy one's exalted position and plunder all one's money. Therefore illicit sex is strictly prohibited. One should be satisfied with his married wife, for even a slight deviation will create havoc.
(Srimad Bhagavatam---6:1:64---purport).

Even if there are opportunities for sex life, one should voluntarily accept the limitation of having sex only for progeny, not for any other purpose. Kardama Muni was also given the facility for sex life, but he had only a slight desire for it. Therefore after begetting children in the womb of Devahūti, Kardama Muni became completely renounced.
(Srimad Bhagavatam---6:4:52---purport).