Homes, Land & Commercial Properties in Northwest Montana

Mapped search results

select *, 1 as firstSort, IF(num_photos > 0,1,0) as secondSort from wp_remax_ucwre_listing_search where ( status='Active' OR status='ActiveUnderContract' ) ORDER BY firstSort desc, secondSort desc,price desc LIMIT 0,21 ;