Impressive waterfront 7-bedroom house