The success rate will hinge largely on location, type of property, and cost of property.

Also, I’d be curious to hear what terms you typically offer (interest rates, LTV, and seasoning requirements) for these types of deals.

Does anyone know a reputable or comp with competitive rates to set up a checkbook IRA?

Builders do this a lot to add extra potential sleeping area without having more bedrooms than septic is rated for.I have seen people put beds in the loft after closing or even close in this area to make an unofficial bedroom.Just be clear in your pictures and description and you should be fine either way.

Even with multiple units, with current interest rates and a competitive market (prices have continued to rise even with higher interest rates) think the Madison market is a stronger long term ownership strategy, where the bulk of your return will come when you sell from appreciation in rents and property value. 

Quote from @Pete Galyon: Quote from @Collin Hays: I've been investing in the Gatlinburg market for 20 years, and I wouldn't rate it anything but so-so right now.

Just keep in mind that it's not all about rate and fees - there is a considerable knowledge and expertise component that should be considered as well.

Real Estate Market Predictions for 2025Single-Family Homes: Prices will likely remain flat due to homeowners holding onto low-interest-rate loans, causing fewer properties to hit the market.

Could you please let me know what cap rate you can get in Canton in the better areas with better schools ? 

If not, re-check everything - listing, photos, rates, booking policies, etc.Often, newbies have rates that are too high and/or booking policies that are far too onerous.