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 'real-estate ORDER BY houses.price DESC' at line 5 SELECT houses.mls_id, houses.id, houses.unit, houses.price, houses.bedroom, houses.bath, houses.type, houses.lot_size, houses.street, houses.thumb, status.status, houses.meta AS housemeta, houses.title AS housetitle, cities.state, cities.city FROM ((houses INNER JOIN cities ON houses.city = cities.id) INNER JOIN `status` ON houses.status = status.id) WHERE 1=1 AND houses.city = 12santa-ana-texas-real-estate ORDER BY houses.price DESC