The lock-in effect occurs when existing homeowners hesitate to sell their properties due to low mortgage rates, resulting in reduced market activity and limited inventory.