But I would remain open to long-term rental as an option as this seems like a more stable option in terms of income, again this may be my inexperience talking.However, I have always  been somewhat risk averse and investing in real estate is always a big venture, in my opinion/experience, in terms of capital.

Believe it or not, these things actually impact all parts of the housing market, not just the new home sector.Again, to truly weigh the options in front of you, I would suggest having a Realtor do an evaluation for you, and give you a pro/con rundown of each option. 

If this property is hard to rent, or is functionally obsolescent (only 1 bathroom, no yard, etc), or has deferred maintenance that will be costly, or is in a location that is not appealing to Tenants, then maybe a sale would be a good option in favor of a property that has better Tenant appeal, which will likely increase rent and avoid long vacancies in between Tenants.An option to consider....

I have considered turnkey properties as an option

Being a NYC resident (originally from Long Island), the price of entry in the area is on the higher end, so I've been considering some options in the NY Capitol region, as well as NJ and CT.

Unfortunately, such a funding option is not generally available for commercial properties, unless your LLC or Corp that is the borrower has other "unencumbered" assets that can be leveraged to generate the funds you need. 

Account Closed a PMC has two options to get liability insurance (tenant slip & fall) protection:1) Get added to owner's policy as Additionally Insured (NOT named insured).2) Setup a master commercial policy and add every property they manage to it and then charge those owners the cost of the policy.Otherwise, a PMC CANNOT get liability coverage on a property they have no ownership interest in.So, nothing wrong with their request.

Financing & Loans: What are the best loan options for short-term rentals?

Both options have pros and cons, and the right choice depends on your lifestyle, experience, and long-term goals.

It's possible to buy property in Germany with as little as 5-10% down, making it an attractive option for service members and civilian government employees stationed there or planning to settle.