Select * from MLSListings where StillOnMLS = 'Yes' AND (District = 'North Kona') AND (price <= 400000)