SELECT SQL_CALC_FOUND_ROWS * FROM edeaproperty WHERE enabled = '1' AND nobedrooms >= '0' ORDER BY price ASC LIMIT 0,9