I would give similar advice to someone that wanted to open a restaurant, landscaping company, hair saloon, etc.  

but there are tons of small multi families in those two areas along with a ton of walkable neighborhoods with great bars and restaurants, and great neighborhoods.

I'm sure there are more but I know for sure there are 2. facebook group SETX-409 real estate investing, they have meet-ups at the Tony mexican restaurant at the mall.

Gordon Ramsey has had a restaurant for sale and it was taken over by professional squatters (didn't know that was a job title :-)They planned to give away free food and open an art gallery there and are threatening to prosecute anyone entering without their permission.

I've seen a couple of communities like Ocean Lakes in Myrtle Beach where you can buy a SFH in the community, there's a pool, lazy river, bar and restaurant, etc., and you drive your golf cart around to each place.

They want activities, restaurants, cafés, shops, yoga studios.

Maybe a giftcard to a local restaurant or just about anything.

mixed use residential conversion of retail space to str units plus real estate office, two restaurants space tenants What made you interested in investing in this type of deal?

Downtown exploded with 30 story Towers as the Mayor did all she could to turn that into a Concrete Jungle where everybody can work online from their expensive apartments and walk to all the stores and fancy restaurants.

In cases of environmental contamination, that can limit what could be there in the future, for example a former car repair shop (that you found the stale yelp reviews for) is likely sufficiently contaminated that it can only ever be something like that, you won't be able to put a daycare center or restaurant in there.