I managed to get the result on my own after much playing with the codes. Here is the working code 🙂
<div class="collections_dresses_container">
<?php query_posts('posts_per_page=-1&cat=10'); if(have_posts()) : while(have_posts()) :the_post(); ?>
<div class="collections_thumbnails">
<?php
$imgID = get_post_thumbnail_id();
$url = MultiPostThumbnails::get_post_thumbnail_url(get_post_type(), 'secondary-image');
?>
<?php if ( has_post_thumbnail()) { $large_image_url = wp_get_attachment_image_src( get_post_thumbnail_id(), 'large'); echo '<a class="fancybox" href="' . $large_image_url[0] . '"><img src="' . $large_image_url[0] . '" title="' . the_title_attribute('echo=0') . '"></a>'; } ?>
<div class="hover_dress">
<a class="fancybox" href="<?php echo $url; ?>"><span><?php the_title(); ?></span></a>
</div>
<?php /*
<div class="hover_dress">
<h3><a class="dress_title" href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></h3>
</div>
*/ ?>
</div>
<?php endwhile; endif; wp_reset_query();?>
</div>