Are you sure you want a fan in a DR? Might make napkins, candles, etc., difficult.

Yes. We have lousy air circulation here. We don't do candles and just deal with napkins. It will make for fun dinner games (just kidding).

This isn't over our dining table, but it has great light and air out put. I got it at L's last month. It's by Hunter. It surprisingly inexpensive, but had four down ward lights which is the best when needing task/dining light. There are a number of different finishes available.
Search for Hunter Westminster 5 Minute Fan 52-inch Flush Mount Ceiling fan with light kit.

I did a wall mount fan in my dining room. That way I could have the light fixture I want and the air circulation I need. I used a Matthews Fan. My fan is chrome.

homepro01, that's what I want in our grandson's bedroom since the attic access in in there which keeps us from putting a ceiling fan in there. Thanks for the link.