attractive [adjective] + waterfront [noun]