Hi Jessica! My fiance and I are also relatively new investors in the Sacramento market. Just a quick background - we bought our principal residence in 2013 and purchased a cash flowing rental in Oak Park right off Broadway a few months ago (I know there are mixed feelings about this area but our $90k 2/1 home is cash flowing about $300/month so we felt it was worth it for us). We're currently looking for something similar to what you're looking for.
I definitely get your frustrations with the lack of cash flow in Sac and understand your dilemma with feeling stuck and out of cash if you buy this property BUT if you can get that kind of deal on a property, especially in a highly desirable area, I think it is way too good of a deal to give up.
A lot of good suggestions mentioned - one I think is worth re-iterating is that if you find another good deal in the future, there WILL be a way to finance it. We've found there are so many sources for funding out there that if you have a good deal the money will likely follow - someone will want to partner with you, or find seller financing, or find a hard money lender who will lend up to 90%, pull out equity in your first home if you can afford it, if you have a retirement account from an old employer, you may be able to roll it to a self-directed IRA that you can use to invest in real estate, etc...
Another new one - have you considered renting out the second bedroom if you purchase your friend's house? It's something my fiance and I thought we would never want to do in our primary residence, but we're realizing that doing something like that for a relatively short term (1-2 yrs) could really get us closer to our real estate goals.
Hope that helps! Best of luck!