Respected property adviser retires after 45 years in the business