Simple model systems with short-range attractive potentials have turned out to play a crucial role in determining theoretically the phase behavior of proteins or colloids. However, as pointed out by D. Gazzillo [J. Chem. Phys. 134, 124504 (2011)], one of these widely used model potentials, namely, the attractive hard-core Yukawa potential, shows an unphysical behavior when one approaches its sticky limit, since the second virial coefficient is diverging. However, it is exactly this second virial coefficient that is typically used to depict the experimental phase diagram for a large variety of complex fluids and that, in addition, plays an important role in the Noro-Frenkel scaling law [J. Chem. Phys. 113, 2941 (2000)], which is thus not applicable to the Yukawa fluid. To overcome this deficiency of the attractive Yukawa potential, D. Gazzillo has proposed the so-called modified hard-core attractive Yukawa fluid, which allows one to correctly obtain the second and third virial coefficients of adhesive hard-spheres starting from a system with an attractive logarithmic Yukawa-like interaction. In this work we present liquid-vapor coexistence curves for this system and investigate its behavior close to the sticky limit. Results have been obtained with the self-consistent Ornstein-Zernike approximation (SCOZA) for values of the reduced inverse screening length parameter up to 18. The accuracy of SCOZA has been assessed by comparison with Monte Carlo simulations.