Has anyone used an affiliate marketing strategy to refresh their property, create unique experiences and provide local products to their guests? 

There is an exact replica unit down the street higher (marketed well) and another listed for lower (marketed poorly) Both about $65 higher and lower.

Second, I'd like to know any specific marketing tactics and methods to screen potential renters.

I understand that doing bi-weekly simply means you are doing 13 mortgage payments a year as opposed to 12. So you get one payment each year that goes straight to principal. I've read other threads on the topic and it ...

I'm looking to connect with investors in this market to share ideas. 

@Kaustubh Vongole, nice job on narrowing down your potential markets!

Would need to know more about the project but fairly confident in that market myself.

Mexico is by far the main market for the whole area and  one of the main agents in Puerto Vallarta, one of the main markets, recently told me that every American he knows who is a pro rehabber in the US who's done a rehab there has hated it and said they'd never do it again.Hope this helps.

Is the micro market (neighborhood) appreciating, flat, or declining, and what is it expected to do over the next 5 years?  

I will call you to discuss Cincinnati's market and some areas in which I am interested in investing.