The guide includes Henley-in-Arden, Warwick, Kenilworth and Stratford-upon-Avon plus some small hamlets offering surprising affordability with average prices starting from £345,000