Hi @Joshua Lupo! Looks like you're where I was about a year ago exactly. I scoured the capital region for a small multi to house hack. I had my trusty rental calculator handy and analyzed deals everyday from hits my realtor sent and on realtor.com. My criteria were not too stringent. I wanted $200 cash flow for a duplex (after PITI and 25% for vacancy, capex, repairs, and management collectively). I found that the numbers in Albany/Schenectady were almost always killed because of the taxes. I found that Saratoga was priced too high. Glens Falls and Queensbury did look nice but I am working in Latham and that commute doesn't interest me. I found Troy and the surrounding area (Cohoes/Watervliet) to be right to make the numbers work.
I was checking listings everyday and found a nice turnkey property in Troy that I jumped on immediately. Because of a mishap in the timing of the appointment, I got to meet the owners who I sold myself to (we're a young couple, with a baby, trying to find an affordable place to live). They loved our story. I wrote them a nice letter too and included a picture of us with the baby. It was a thing of beauty. So when I made an offer (the next day - all offers needed to be in within 24 hours), and they had a bunch of other conventional 20% or cash offers, they didn't care that I only had 3.5% to put down with an FHA - they wanted to sell to me!
House hacking has saved a ton of money and now we're ready for another one just a year later. Keep in mind you'll only likely be able to house hack twice. Once with an FHA and another time with 15% down conventional. After that, the underwriters apparently become suspicious and will require 25% down on a duplex.
Troy has some bad parts. Be vigilant where the property is located. You are charged for water 4x a year (about $150 for me), waste is 2x a year (I think it's $160). In my area homes often include heat so that's another charge to consider (I'm paying ~$1200/year for the two units). Your numbers start to drop when these things are considered.
The homes are old so be sure to get one that's in great condition, unless you're handy (which I am not).
PM me if you have any questions!!