select *, 1 as firstSort, IF(num_photos > 0,1,0) as secondSort from wp_remax_ucwre_listing_search where ( status='Active' OR status='ActiveUnderContract' ) && ( is_office ) && ( city LIKE '%bigfork%' ) ORDER BY firstSort desc, secondSort desc,price desc LIMIT 0,21 ;
$185,000
1.31 acres