You can do a
select ot.details_col into :new.column_one from other_table ot where ot.property_id = :new.property_id;
Of course, I’d strongly question the data model if this makes sense. That strongly implies that you’ve got a data model in need of some normalization.
CLICK HERE to find out more related problems solutions.