No idea what the sweet spot is. But thought it might be helpful to mention that I purchased a condo in a Colorado ski resort area in early 2021, when prices were just starting to go nuts and interest rates were still low.
I have been disappointed in the overall percentage of occupancy. While we don’t “need” the rental income, I assumed we’d be earning more. For example, our 2 bed, 2 bath, very clean and cute condo (but not “luxury”) in Summit County that is 15 minutes from 3 major ski resorts sat empty for most of the summer, except for when we used it personally. We had exactly 2 renters all summer. Nothing over the 4th of July weekend… we were stunned. This was our first full summer to have it on the rental market, and I thought it would do better. I’ve “heard” that if our home was 3 or 4 bedrooms it would do much better and I totally get that, but that kind of home would have been way out of our price point at the time.
I haven’t calculated the true occupancy rate yet, but I’m not sure it will even crest 40%. I love the condo and the area and am so glad we purchased here as a vacation home for our family, but it is definitely not a cash cow.