Looks as pictured.  Works well.  The top portion that screws into the ceiling is very small relative to other ceiling fans and light fixtures so you may end up with portions of the existing hole exposed (this happened to me), which is the reason for the 4 stars.