@Khalid Bryan another option if not affordable rental properties is if you would like to try the BRRR method I would look for properties that are not moving ready or maybe the condition prevents them for qualifying for an FHA loan or low down conventional loan, and do the necessary repairs to make it safe to live in clean and fresh.

We are considering a STR option for this property for the summer months due to its proximity to the beach.

Then, be aggressive about negotiating with the seller two options:1) Property vacant at close - you pay original agreed price2) Property NOT vacant at close - you pay orig price LESS an aggressive amount based upon above.Great advice - you should be embarrassed about how low the offer is you make!

Does anyone see any options for me here?

If you decide to pursue this option, I have a qualified lender who can assist you with this program.

I would appreciate any advice on figuring out what we could charge for rent so that we can decide if selling or renting is our best option. 

You may also consider looking for lease with option to own opportunities, for the same reason; lower your down payment- then use the leasing period to build up what you need to exercise the option to purchase. 

Getting a partner is your only option.

Despite diligently analyzing Zillow and MLS properties, viable options seem limited.

Or if the person you're working with is a broker, and the original lender doesn't offer that option, they can take your file to another investor.