Note I have no affiliation with them except I use them and they have provided me a great VA.

Though I have purchased some with a mix where 330+ days a year, people parked in the driveway and the street except when there were snow bans, but there was enough room to fit everyone in the driveway/parking lot, and that was a hassle to deal with some days. 

This would help save me some money to use on the house that is getting renovated and I wouldn't have any money out of my pocket up front for the duplex except when the mortgage starts.

Partial or full doesn't matter (except see note below re: coming even on delinquent rent).The statute regarding notice for evictions states: "No judgment of possession shall be entered for . . . except in the nonpayment unless the landlord has made written demand and given written notice for delivery of possession of the premises.”

At one point I talked to my financially advisor and he said that it would be smart for me to open a HELOC on the property, but not draw from it, except in the case of emergencies.  

Quote from @Scott Trench: @Scott Johnson we typically don't delete forum posts, and I don't see a reason to make an exception here. 

And because there are so many, demand is ultra low, except in the busiest of months.  

As the market evolves we've intensified our commitment to helping investors focus only on listings that are eligible for vacation rental usages and either; have exceptional existing production or high potential for rental performance.

I’ve obtained all the necessary clearances except for the septic system.

Structurally, the property is in pretty good shape EXCEPT one problem that I cannot properly assess: the plumbing will not hold pressure.