Real estate investor sentiment bounced back from two quarters of decline, but lingering fears around tariffs, interest rates still weigh on many buyers’ minds