I've never stayed there, but I pass it coming home from OAK.
This hotel is not in a residential neighborhood. It's fairly close, 50 yards, to Interstate 880. You'll need a car to visit the Lakeside area mentioned earlier or just about anywhere else. Not to say that it's undesirable, just to place it in context.
I'd consider it a business hotel, on the far periphery of OAK, suitable for people travelling in the Oaktown area with a car.
Rich