Complete Sales Grid and Reconciliation Case

Complete Sales Grid and Reconciliation Case

Comprehensive Worked Case Study: Three-Comparable Single-Family Grid

To observe reconciliation in practice, we examine a complete valuation case study for a single-family residential property.

Subject Property Profile

• Property Address: 142 Meadowbrook Lane, Oakridge Estates subdivision
• Design & Property Type: 2-story detached suburban colonial residence
• Site Size: 10,890 sq ft (0.25 acre)
• Quality Rating: Q3 (Higher-than-average builder design and finishes)
• Condition Rating: C3 (Well maintained, updated kitchen, no deferred maintenance)
• Gross Living Area (GLA): 2,400 sq ft
• Room Count: 8 total rooms, 4 bedrooms, 2.5 bathrooms
• Garage Capacity: 2-car attached garage
• Porch / Patio: Covered rear porch/patio (200 sq ft)

Market-Derived Adjustment Schedule

Through paired sales, cohort analysis, and depreciated cost analysis in Oakridge Estates, the appraiser has extracted and defended the following adjustment parameters:

• Market Conditions (Time): +0.5% per month from contract date to effective date.
• Gross Living Area (GLA): $70 per square foot.
• Bathroom Count: $8,000 per full bathroom; $4,000 per half bathroom.
• Garage Capacity: $10,000 per stall/bay.
• Site Size: $1.50 per square foot for variances exceeding 2,000 sq ft.
• Porch / Patio: $5,000 for a covered rear porch/patio.
• Condition Rating: $20,000 between C3 and C4 ratings.

Comparable Sales Profiles & Detailed Calculations

Comparable Sale 1: 156 Meadowbrook Lane

• Located 0.1 miles from subject on the same street in Oakridge Estates.
• Sold 1 month ago for $510,000.
• GLA: 2,450 sq ft (50 sq ft larger than subject; CBS: 50 $\times$ $70 = -$3,500).
• Contract Date (1 month prior; CIA: 0.5% $\times$ $510,000 = +$2,550).
• Site, quality, condition, room count, garage, and patio are identical to subject ($0).
• Net Adjustment: +$2,550 - $3,500 = -$950 (-0.19%).
• Gross Adjustment: $2,550 + $3,500 = $6,050 (1.19%).
• Adjusted Sale Price: $509,050.

Comparable Sale 2: 312 Whispering Pines Drive

• Located 0.4 miles from subject in Oakridge Estates.
• Sold 3 months ago for $480,000.
• Contract Date (3 months prior; CIA: 1.5% $\times$ $480,000 = +$7,200).
• GLA: 2,200 sq ft (200 sq ft smaller than subject; CIA: 200 $\times$ $70 = +$14,000).
• Bathrooms: 4 bed, 2.0 bath (Subject has 2.5 baths; CIA: half-bath adjustment = +$4,000).
• Patio: Uncovered concrete slab (Subject has covered patio; CIA: +$5,000).
• Site, quality, condition, and garage are identical to subject ($0).
• Net Adjustment: +$7,200 + $14,000 + $4,000 + $5,000 = +$30,200 (+6.29%).
• Gross Adjustment: $7,200 + $14,000 + $4,000 + $5,000 = $30,200 (6.29%).
• Adjusted Sale Price: $510,200.

Comparable Sale 3: 884 Ridgecrest Boulevard

• Located 1.2 miles away in adjacent, competing subdivision (Ridgecrest Park).
• Sold 5 months ago for $545,000.
• Contract Date (5 months prior; CIA: 2.5% $\times$ $545,000 = +$13,625).
• Site Size: 15,246 sq ft (4,356 sq ft larger than subject; CBS: 4,356 $\times$ $1.50 = -$6,534, rounded to -$6,500).
• Condition: C4 (inferior deferred maintenance relative to subject's C3; CIA: +$20,000).
• GLA: 2,650 sq ft (250 sq ft larger than subject; CBS: 250 $\times$ $70 = -$17,500).
• Bathrooms: 4 bed, 3.0 bath (Subject has 2.5 baths; CBS: half-bath adjustment = -$4,000).
• Garage: 3-car attached (Subject has 2-car; CBS: 1 stall = -$10,000).
• Quality and patio are identical to subject ($0).
• Net Adjustment: +$13,625 - $6,500 + $20,000 - $17,500 - $4,000 - $10,000 = -$4,375 (-0.80%).
• Gross Adjustment: $13,625 + $6,500 + $20,000 + $17,500 + $4,000 + $10,000 = $71,625 (13.14%).
• Adjusted Sale Price: $540,625.

---

The Sales Comparison Adjustment Grid

---

Analyze Adjustment Exposure, Not Obsolete Approval Thresholds

The arithmetic shows Comp 1 gross adjustments of 1.19%, Comp 2 of 6.29%, and Comp 3 of 13.14%. These are diagnostic facts, not pass/fail limits. Comp 3's net adjustment of −0.80% masks larger offsetting differences, and its indicated value is materially above the other indications. Revisit the adjustment support and competitive relationship before deciding its weight.

This hypothetical grid uses a March 2024 effective date and the stated contract-date intervals. It is a historical arithmetic example, not evidence of October 2026 market appreciation or current transactions. The monthly time trend is an explicitly simple trend, not compound growth.

Drafting a Defensible Reconciliation Rationale

The following reconciliation narrative represents the professional standard of documentation required in certified appraisal reports:

Appraiser's Reconciliation Narrative: "The three comparable sales analyzed establish an unadjusted price range from $480,000 to $545,000 and an indicated adjusted value range from $509,050 to $540,625. The subject property's physical characteristics—including gross living area, site size, and room count—are fully bracketed by the comparable dataset.

Comparable Sale 1 (156 Meadowbrook Lane) was accorded predominant qualitative emphasis in the final value conclusion. Located 0.1 miles from the subject on the same residential street within Oakridge Estates, this transaction went under contract one month prior to the appraisal effective date. It required only two minor adjustments (market conditions and 50 square feet of GLA), resulting in an outstanding gross adjustment ratio of only 1.19% ($6,050) and an indicated adjusted value of $509,050.

Comparable Sale 2 (312 Whispering Pines Drive) was accorded secondary qualitative emphasis. Located 0.4 miles from the subject within the same subdivision, this sale went under contract three months prior to the effective date and brackets the subject's gross living area from below (2,200 sq ft). All adjustments were in one direction (CIA), resulting in a modest net and gross adjustment ratio of 6.29% ($30,200) and an indicated value of $510,200, which closely corroborates Comparable 1.

Comparable Sale 3 (884 Ridgecrest Boulevard) was accorded minimal qualitative emphasis. Although its net adjustment is superficially low at -0.80%, this figure masks a 13.14% gross adjustment ($71,625) driven by substantial offsetting modifications for inferior C4 condition, larger site size, third garage bay, and excess GLA. Located 1.2 miles away in an adjacent neighborhood, Comparable 3 serves primarily to bracket the subject's gross living area from above (2,650 sq ft) and provides a higher indication whose support requires scrutiny.

An unweighted arithmetic average of $520,000 was considered and rejected because it inappropriately assigns equal credibility to Comparable 3, which is significantly more distant and heavily modified. Giving primary emphasis to the most proximate and least adjusted sales (Comparables 1 and 2), the final indicated market value by the Sales Comparison Approach is reconciled at $510,000."