plumbing, anyone?

This is a shot of the kitchen in our "best case" house.  Notice the visible gap between the sink and the drain. this is supposed to be redone (with the cabinetry completely replaced), but what will it look like afterward?
No offense meant, whatsoever, to those plumbers (nor their wives!) who did actually offer to come over and help us set up house, had we been here in their timeline...