I need advice or assistance on how I should go about this Bundle Deal of distressed properties I just came across.The bundle includes 13 properties (all single-family) that all add up to $407,150 and all but possibly 2 are not in shape to be rented out and would need rehab done to it.

Because the real work, the heavy lift, is going to be getting yourself into shape and educated to be a proficient well performing host.

Since you already own the land, you appear to be in good shape.

The house is nearly 100% new inside, and overall in very good shape. 

That's a decent area over there in Euclid / South Euclid, definitely not a D neighborhood, so as long as the property is in decent shape, you really should have no problem renting it out. 

by the way I choose to maintain my properties in good shape, but my rents are not at bottom of market rate.  

Kitchen has the light brown cabinets in excellent shape.

It was built in 1973, is in fantastic shape but dated, has a 4 year old roof, is in a good part of town, 1,100 square feet upstairs as well as down and both apartments are 2 bed 1 bath.  

I would say each property should be around a bare minimum  150k per for a standard row home in relatively decent shape. 

I also don't think it's common to convince the appraisal district that your property did not appreciate at all, unless you can back it up with pictures that your property was damaged or is in worse shape that it was the year before.