The retreat center we went to in eastern Iowa was in a town with nothing much, West Union. She also provided housing for reunions, weddings and other events needing housing because there was no hotel/motel and the residents needed it. She had taken two apartments upstairs and converted to multi bed rooms. Very nicely decorated with antique sewing things and quilts on the beds. Two clean bathrooms and the kitchen had enough for coffee.
http://www.moonlightstitching.com/retreats
Here is another one in Oelwein, Iowa that had a small quilt shop downstairs with a sewing area and the rooms upstairs.
https://www.facebook.com/Lou-Anns-Qu...9062/timeline/
No one can tell you if you are really in a spot that will draw people and make money. It takes a lot of research and work.