As noted in the comments it takes some care to phrase this question in a nontrivial way. However, this can be done in at least a couple ways, one yielding a positive answer and the other yielding a negative answer.
As clarified in your edit, you have in mind the following question: is there a non-first-order property $X$ of structures which is existentially second-order (= $\Sigma^1_1$ or $\mathsf{ESO}$) characterizable? Here $\mathsf{ESO}$ is the logic which allows expressions of the form "Some expansion of the universe satisfies $\varphi$" for $\varphi\in\mathsf{FOL}$. Note that $\mathsf{ESO}$ is quite a nice logic in many respects - e.g. it is fully compact and has downward Lowenheim-Skolem - but it is not closed under negation (so we don't contradict Lindstrom's theorem, and in fact Shelah/Vaananen showed that there is no direct analogue of Lindstrom's theorem for logics without negation). Broadly speaking, a good rule of thumb is that existential second-order logic is "tame" in a way that its dual (universal second-order logic) isn't; for example, the latter but not the former can characterize well-foundedness, which turns out to be a very strong anti-tameness property.
The answer to this question is yes. There is a vast literature on the topic, and the term "existential second-order" will be a useful search term. One easy example is that a structure is infinite iff it can be expanded to a model of (say) Robinson's arithmetic $\mathsf{Q}$ in a fresh signature. Note that this leans heavily on the lack of negation in $\mathsf{ESO}$: the reason infinitude is not $\mathsf{FOL}$-expressible is roughly that if it were then finiteness would also be $\mathsf{FOL}$-expressible and that would contradict compactness, but this relies on $\mathsf{FOL}$ having negation.
Interestingly, if we ask for the stronger property of both $X$ and $\neg X$ being "detectable" in this way (and this was how I originally interpreted your question), we get a negative answer.
Let $\Sigma$ be a fixed language and suppose $X$ is a property of $\Sigma$-structures of interest. Suppose $R_1, R_2$ are relation symbols not in $\Sigma$ and there are sentences $\varphi_1,\varphi_2$ in $\Sigma\sqcup\{R_1\},\Sigma\sqcup\{R_2\}$ respectively which "detect $X$-ness" in the sense that for every $\Sigma$-structure $\mathcal{M}$ we have
$\mathcal{M}$ has property $X$ iff some expansion of $\mathcal{M}$ satisfies $\varphi_1$, and
$\mathcal{M}$ fails property $X$ iff some expansion of $\mathcal{M}$ satisfies $\varphi_2$.
In this case, the pair $\varphi_1\wedge\varphi_2$ is inconsistent (given a putative model of $\varphi_1\wedge\varphi_2$, does the reduct to $\Sigma$ satisfy $X$ or not?). This means $\vdash\varphi_1\rightarrow\neg\varphi_2$. Applying Craig's interpolation theorem, we get a $\Sigma$-sentence $\theta$ entailed by $\varphi_1$ and entailing $\neg\varphi_2$. This $\theta$, then, exactly characterizes $X$.
At this point, it's worth seeing an example of a logic (necessarily not first-order logic $\mathsf{FOL}$) for which Craig interpolation fails. The two most common extensions of $\mathsf{FOL}$, namely the "small" infinitary logic $\mathcal{L}_{\omega_1,\omega}$ and second-order logic $\mathsf{SOL}$, each do have the interpolation property (interestingly and trivially, respectively), so we have to go into the weeds a bit.
My personal favorite example is $\mathsf{FOL}(Q_\mathit{fin})$, where we add to first-order logic the quantifier "For finitely many." The point is that $(i)$ unlike $\mathsf{FOL}$ this logic we can pin down the standard model of arithmetic $\mathcal{N}=(\mathbb{N};+,\times)$ up to isomorphism, but $(ii)$ like $\mathsf{FOL}$ this logic can in $\mathcal{N}$ give an inductive definition of its own full theory of $\mathcal{N}$. These facts, combined with (the proof of) Tarski's undefinability theorem, give us the failure of Beth definability (a corollary of Craig interpolation) for $\mathsf{FOL}(Q_\mathit{fin})$.
Vaananen's article The Craig interpolation theorem in abstract model theory contains a lot of good information about this topic, albeit at a high level.