There isn't any requirement regarding the sequence. Similarity and Location often indicates Actives &/or Contracted Sales are the most similar, most proximate, and most current value indicators. Mandatory 3 CLOSED sales is a requirement.
XI, 406.02: Selection of Comparable Sales (06/30/02)
We require an appraiser to research, analyze, and consider influences that may affect value based on market evidence (such as closed sales, contract sales, and properties for sale in the market area; market studies; etc.). For example, if a property is located in a neighborhood that includes (or is close to) an airport or hazardous waste site or that has relatively high property taxes or vacant or boarded-up properties, we expect the appraiser to research, analyze and use comparable sales from the same neighborhood or affected area (whenever possible) in his or her analysis. This will ensure that any effect of these value-influencing characteristics is taken into consideration in the development of the opinion of value for the property.
If a property is located in an area in which there is a shortage of truly comparable sales—either because of the nature of the property improvements or the relatively low number of sales transactions in the neighborhood—the appraiser might need to use as comparable sales properties that are not truly comparable to the subject property or properties that are located in competing neighborhoods.
In some situations, sales of properties that are not truly comparable or sales of properties that are located in competing neighborhoods may simply be the best comparables available and the most appropriate for the appraiser’s analysis. The use of such comparables is acceptable as long as the appraiser adequately documents his or her analysis and explains why these comparable sales were used (including a discussion of how a competing neighborhood is comparable to the subject neighborhood).
The appraiser must report a minimum of three comparable sales as part of the sales comparison approach to value. The appraiser may submit more than three comparable sales to support his or her opinion of market value, as long as at least three are actual settled or closed sales. Generally, the appraiser should use comparable sales that have been settled or closed within the last 12 months. However, the appraiser may use older comparable sales if he or she believes that it is appropriate, and selects comparable sales that are the best indicators of value for the subject property. The appraiser must comment on the reasons for using any comparable sales that are more than six months old. For example, if the subject property is located in a rural area that has minimal sales activity, the appraiser may not be able to locate three truly comparable sales that sold in the last 12 months. In this case, the appraiser may use older comparable sales as long as he or she explains why they are being used.