and p.cid = 4 and p.bid = 7 and p.mid = 6  and (p.area > 1000 and p.area <= 3000)   and (p.least_rent_time <= 3)