Looks exactly like the picture provided. Solid lamp. Good base. Great value for the dollar. I recommend it. No bulb included. It says LED bulb but I used a standard small red Xmas bulb type light as I wanted it to be a night light for my bathroom. It works great as that. I do not think this light could actually provide much light,... but it is exactly what I was looking for.