select ListingID, ListingStatus, LotAreaAcre, LivingArea, ForSale, Longitude, ModificationTimestamp, YearBuilt, Latitude, Subdivision, VirtualTourURL, ListPicture2URL,ListPicture3URL, ListOfficeName, ListingKey, ZipCode, FullStreetAddress, StreetName, Beds, BathsFull,BathsHalf, CityName,state,ZipCode, ListPrice, ClosePrice, Advertising, STATE, Stories, ListOfficeName, ListingKey, VirtualTourURL,InternetRemarks, LotAreaAcre from bright.searchALL where (ListingStatus LIKE "Active%" and StreetName = '' ) order by StreetName, ListPrice DESC LIMIT 0,1000;