It is important to realize that the resonance frequency (i.e., the frequency at which the circuit resonates if the damping is sufficiently low) of a second-order RLC circuit never equals \$\frac{1}{\sqrt(LC)}\$ if \$R>0\$, i.e., if there is damping. The resonance frequency (in radians per second) equals \$\frac{1}{\sqrt(LC)}\$ only if you have an ideal LC-circuit with zero damping. As soon as you have damping, the resonance frequency is lowered compared to an ideal LC-circuit.
E.g., for a simple series RLC circuit in the underdamped case, the resonance frequency is given by
$$\omega_r=\sqrt{\frac{1}{LC}-\frac{R^2}{4L^2}}\tag{1}$$
The frequency \$\omega_0=\frac{1}{\sqrt{LC}}\$ is called the natural frequency, but in the case of non-zero damping it is just an abstract quantity, which can be used to express the resonance frequency together with the damping constant \$\zeta\$:
$$\omega_r=\omega_0\sqrt{1-\zeta^2}\tag{2}$$
Note that even for very simple configurations of RLC-circuits different from series or parallel RLC-circuits, the formulas for the resonance frequency are different from (1) (see here).
So concerning your example, you have a third order RLC-circuit, which is very different from a standard second-order RLC-circuit. As discussed above, even for second-order RLC circuits, the resonance frequency depends on the specific configuration, and it never equals the natural frequency \$\frac{1}{\sqrt{LC}}\$ as long as \$R\neq 0\$. So you can't expect that the resonance frequency of your circuit is given by any simple expression that in any way resembles the simple formula of the natural (NOT resonance!) frequency of a second-order RLC-circuit.
An exact expression for the input impedance can be derived in a fashion similar to the derivation of the transfer function in P.-K. Engstad's answer. It is given by
$$Z_i(s)=\frac{as^3+bs^2+cs+d}{es^3+fs^2+gs+1}\tag{3}$$
with
$$\begin{align}a&=L_1C_1C_2R_2R_3\\\ b&=L_1(C_1+C_2)(R_2+R_3)\\\ c&=C_1R_2R_3 \\\ d&=R_2+R_3 \\\ e&=L_1 C_1 C_2 R_2 \\\ f&=C_1C_2R_2R_3+L_1(C_1+C_2) \\\ g&=C_2R_2+R_3(C_1+C_2) \end{align}$$
Evaluating (3) for \$s=j\omega\$ and setting its imaginary part to zero gives an expression for the resonance frequency. Using above constants to define auxiliary constants
$$\begin{align}A&=af-be\\\ B&=de+bg-cf-a\\\ C&=c-dg\end{align}$$
the expression for the exact resonance frequency can be written as
$$\omega_r=\sqrt{-\frac{B}{2A}+\sqrt{\frac{B^2}{4A^2}-\frac{C}{A}}}\tag{4}$$
For the given values of \$L_1,C_1,C_2,R_2\$ and \$R_3\$, we get from (4) \$\omega_r=9.9980\cdot 10^5\;\text{rad/s}\$. Note that this value is indeed very close to the value \$\frac{1}{\sqrt{L_1C_2}}=10^6\;\text{rad/s}\$, as mentioned in LvW's answer. However, this is only true in a certain range of the parameters around the given values. Even if only the value of \$L_1\$ is changed to \$L_1=1\;\text{mH}\$ (leaving all other values unchanged), the exact resonance frequency according to (4) is \$\omega_r=2.70\cdot 10^4\;\text{rad/s}\$, whereas we have \$\frac{1}{\sqrt{L_1C_2}}=3.16\cdot 10^4\;\text{rad/s}\$. If other parameter values are also changed, the difference between the exact value and the "approximation" becomes arbitrarily large. So in general we have to use the exact value of the resonance frequency given by (4), and no "simple" formula is generally applicable.
The plot below shows the magnitude of the input impedance \$|Z(j\omega)|\$ and the magnitude of the transfer function \$|H(j\omega)|\$ for the values given in your question. At the resonance frequency the transfer function has a huge peak (higher than the plot range), and the input impedance becomes almost zero. For \$\omega\rightarrow\infty\$, the input impedance converges to the value of \$R_3=100\,\Omega\$, and the transfer function converges to \$1\$. At DC the transfer function is \$H(0)=R_3/(R_2+R_3)=\frac12\$, and the input impedance is \$Z(0)=R_2+R_3\$ (outside plot range).
