Reddit mentions of Latin for Americans: First Book

I dunno if you'll see this but maybe.

Rosetta Stone is garbage. So is Pimsleur and basically any other commercial product you can imagine. The company survives by amping the viewer up during the commercial so that you'll buy the thing in excitement, then you won't use it and it collects dust on the shelf. They know this. Or if you do use it you get very good at having the exact conversation the thing taught you to have and you are useless in all other areas and don't have the skills to continue learning independently.

What you need is a textbook. You don't mention which language you are interested in but the best one I ever saw was Latin for Americans. Once you understand grammar from start to finish then it doesn't matter which language you choose, you can just sit down with a catchy song with lyrics in hand and a dictionary and translate it. Listen to it over and over, sing it out loud for accent acquisition. Do that until your vocabulary hits the 10,000 words mark.

Perhaps the best solution is to get on Craigslist and post an ad or respond to one in their Lessons section. You can offer to trade lessons if you don't want to pay. I did that and offered German lessons in exchange for Cooking.

I used Latin for Americans (first book, second book). Then we just translated the works of Caesar and Pliny, then the whole Aeneid.