A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by close_date desc' at line 3

select * from data_listings where listing_status = 'Closed Sale' and listing_class != 'Residential Rental' and order by close_date desc