SELECT pic1, pic_qty, our_listing, LIST_NO, PROP_TYPE, LIST_PRICE, Address AS ADDRESS, mid, STREET_NO, STREET_DIR, STREET_NAME, CITY, ZIP_CODE, COUNTY, SUBDIVISION, BEDROOMS, FULL_BATHS, HALF_BATHS, OFFICE_PHONE, SQFT_LONG, LOT_SIZE, LIST_AGENT, LOT, ACREAGE, date_added, date_updated, UnitNo, PropertyType, Remarks AS paragraph, `Status`, Style, SellingAgent, Sold, `Status Date`, mktg_photo, AgentFirstName, AgentLastName, Wireless, EmailDomain, AgentPhone, DOM, IsActive from cbharperluxury_listings where 1=1 and IsActive = 1 and LIST_PRICE between 500000 and 999999999 and water_view = 1 ORDER BY LIST_PRICE desc ; Luxury Property Results| Coldwell Banker D'Ann Harper REALTORS Luxury