I just wrote this up so I have not tested it but this is how I would go about forcing one post to be at the end. In the first loop it excludes the posts by its ID number and in the second loop it only includes the post by the ID number, essentially you will need to know the ID of the post.
<?php
$loop = new WP_Query( array(
'post_type' => 'agents',
'orderby' => 'meta_value',
'meta_key' => 'dName',
'post__not_in' => array( 00 ),
'posts_per_page' => -1 ) );
$loop2 = new WP_Query( array(
'post_type' => 'agents',
'post__in' => array( 00 ) ) );
if($loop->have_posts() || $loop2->have_posts()) {
if($loop->have_posts()) { while($loop->have_posts()) { $loop->the_post();
echo the_title();
echo get_post_custom_values('dName');
//Post Content
} //endwhile
}
if($loop2->have_posts()) { while($loop2->have_posts()) { $loop2->the_post();
echo the_title();
echo get_post_custom_values('dName');
//Post Content
} //endwhile
}
} else {
echo 'No Agents.';
}
?>