SELECT * FROM rl5k7_properties_listing p where p.id > 0 and p.state = 1 and property_type = 1 and property_bedrooms = 1 order by ordering asc