I am in no hurry, and I am certain that there is a gem to be found somewhere near to home.  

Might there be a few gems?  

As with those examples I just gave, there are also  Realtors who are absolute gems, and I hope you'll get to experience one, one day.

Should I hold out for that gem of a duplex or go the SFH route and rent that out when I am ready to move?

I will say that in Indianapolis we were buying 2000's vintage 200+ unit properties for ~110k/unit two years ago, last year they were trading in the $130k/unit range, and I've seen current on market listings closer to $145k/unit. 

This property could be a gem......

Specifically, I'm exploring wholesaling and creative financing deals for SFH, but finding those exclusive, hidden-gem deals is tough, especially on a tighter budget. 

Hi we’re hoping to connect with others in the RV park and campground business.We found a gorgeous property in the Upper Hudson Valley, 120 miles from NYC in Columbia County, NY.Property is 15 acres with a 1 acre pondProperty is under contract Met with the zoning board and just got a variance and a Special Permit to do the campground consisting of vintage campers and glamping tents.

Averages are $200K in south areas to $750K in near northeast areas -  vintage with some upgrades. 

First, if it is cash flowing and not a hassle and you don't need the money right now, I wouldn't sell.Second, you would look for three properties that are within half a mile of the property that have sold in the last 3 months and have basically the same floor plan and vintage and come up with "comps".