Do you have to use the meta_key prop_order? Or could you use a posts/pages reorder plugin? Then you can drag and drop the posts into the correct order, and use orderby=menu_order, order=ASC or order=DESC in your query then the whole thing would be WP_Query("category_name=office&meta_key=featured_post&meta_value=Yes&posts_per_p‌​age=3&orderby=menu_order&order=ASC");?
–
eileencodesNov 17 '10 at 16:40

Hi @ Eileen, thanks for replying! In truth I need a number of these queries across my site, using different categories etc so I need to have a query like this in the template rather than using a plugin, unfortunately.
–
daveaspinallNov 17 '10 at 16:51

I had a second look, as I thought I may be able to use your suggestion, unfortunately I'm using custom post types aswell and those plugins don't seem to be able to manage them individually.
–
daveaspinallNov 17 '10 at 17:00