Homebuyers in this Northeast city should brace for "bidding wars and broken hearts," according to Zillow.