error:select id from mls where 1 and prop_type in ('R','T','M','L','C','O') and water_frontage>0 and area in (90) order by list_price desc