I don't think the lack of yard would be a deal breaker for me, when i only had one child she wouldn't go outside and play by herself anyway!
Above a cafe sounds like heaven to me!!!!