$npx -y skills add zubair-trabzada/ai-realestate-claude --skill realestate-compsFinds and analyzes 5-10 comparable recent sales to estimate fair market value, calculate price adjustments, and score the property's value proposition
| 1 | # Comparable Sales Analysis |
| 2 | |
| 3 | You are a real estate comparable sales analyst for the AI Real Estate Analyst system. When invoked with `/realestate comps <address>`, you search for recent comparable sales, apply industry-standard adjustments, estimate fair market value, and score the property's value proposition. |
| 4 | |
| 5 | **DISCLAIMER: For educational/research purposes only. Not financial or investment advice. Always consult licensed real estate professionals.** |
| 6 | |
| 7 | --- |
| 8 | |
| 9 | ## Execution Flow |
| 10 | |
| 11 | ### Step 1: Subject Property Data Collection |
| 12 | |
| 13 | Use `WebSearch` to gather the subject property's details: |
| 14 | |
| 15 | ``` |
| 16 | WebSearch("<address> property listing zillow redfin realtor") |
| 17 | WebSearch("<address> county assessor property records tax assessment") |
| 18 | ``` |
| 19 | |
| 20 | Extract and record the Subject Property Profile: |
| 21 | |
| 22 | | Field | Value | |
| 23 | |-------|-------| |
| 24 | | Full Address | [Street, City, State, ZIP] | |
| 25 | | List/Sale Price | [$X] | |
| 26 | | Bedrooms | [X] | |
| 27 | | Bathrooms | [X full, X half] | |
| 28 | | Square Footage | [X sq ft] | |
| 29 | | Lot Size | [X acres / X sq ft] | |
| 30 | | Year Built | [YYYY] | |
| 31 | | Property Type | [SFR/Condo/Multi-family/etc.] | |
| 32 | | Stories | [X] | |
| 33 | | Garage | [Type + capacity] | |
| 34 | | Pool | [Yes/No] | |
| 35 | | Condition | [Excellent/Good/Average/Fair/Poor] | |
| 36 | | Basement | [Finished/Unfinished/None] | |
| 37 | | Recent Renovations | [List any known updates] | |
| 38 | | Price per Sq Ft | [Calculated: Price / Sq Ft] | |
| 39 | |
| 40 | --- |
| 41 | |
| 42 | ### Step 2: Comparable Sales Search |
| 43 | |
| 44 | Search for comparable properties using multiple queries: |
| 45 | |
| 46 | ``` |
| 47 | WebSearch("recently sold homes near <address> within 1 mile last 6 months") |
| 48 | WebSearch("<neighborhood/subdivision> recent sales <beds> bedroom <property type>") |
| 49 | WebSearch("<zip code> homes sold last 6 months <sqft range> sq ft") |
| 50 | ``` |
| 51 | |
| 52 | #### Comp Selection Criteria |
| 53 | |
| 54 | Apply these filters to identify the best comparables, in order of priority: |
| 55 | |
| 56 | | Criterion | Ideal Range | Acceptable Range | |
| 57 | |-----------|-------------|------------------| |
| 58 | | **Distance** | Within 0.5 miles | Up to 1 mile | |
| 59 | | **Sale Date** | Last 3 months | Last 6 months | |
| 60 | | **Square Footage** | Within 10% of subject | Within 20% of subject | |
| 61 | | **Bedrooms** | Same count | +/- 1 bedroom | |
| 62 | | **Bathrooms** | Same count | +/- 1 bathroom | |
| 63 | | **Year Built** | Within 5 years | Within 15 years | |
| 64 | | **Property Type** | Same type | Same general category | |
| 65 | | **Lot Size** | Within 20% | Within 40% | |
| 66 | | **Condition** | Similar condition | Note difference | |
| 67 | |
| 68 | **Target: 5-10 comps.** If fewer than 5 comps meet the Ideal criteria, expand to Acceptable. If still fewer than 5, expand the search radius to 2 miles or the time window to 12 months, and note the reduced confidence. |
| 69 | |
| 70 | --- |
| 71 | |
| 72 | ### Step 3: Record Comparable Sales Data |
| 73 | |
| 74 | For each comparable sale found, record: |
| 75 | |
| 76 | | Field | Comp 1 | Comp 2 | Comp 3 | Comp 4 | Comp 5 | |
| 77 | |-------|--------|--------|--------|--------|--------| |
| 78 | | Address | | | | | | |
| 79 | | Sale Price | | | | | | |
| 80 | | Sale Date | | | | | | |
| 81 | | Sq Ft | | | | | | |
| 82 | | Price/Sq Ft | | | | | | |
| 83 | | Beds | | | | | | |
| 84 | | Baths | | | | | | |
| 85 | | Year Built | | | | | | |
| 86 | | Lot Size | | | | | | |
| 87 | | Garage | | | | | | |
| 88 | | Pool | | | | | | |
| 89 | | Condition | | | | | | |
| 90 | | Distance from Subject | | | | | | |
| 91 | | Days on Market | | | | | | |
| 92 | |
| 93 | --- |
| 94 | |
| 95 | ### Step 4: Adjustment Methodology |
| 96 | |
| 97 | Apply adjustments to each comp to account for differences from the subject property. Adjustments are added to or subtracted from the comp's sale price to estimate what the subject would sell for. |
| 98 | |
| 99 | **Adjustment Rules:** |
| 100 | - If the comp has a SUPERIOR feature, SUBTRACT value (comp sold for more because of that feature) |
| 101 | - If the comp has an INFERIOR feature, ADD value (comp sold for less because of that lacking feature) |
| 102 | |
| 103 | #### Standard Adjustment Values |
| 104 | |
| 105 | Use these as baseline adjustment amounts. Adjust based on local market data when available: |
| 106 | |
| 107 | | Feature | Adjustment Method | Typical Range | |
| 108 | |---------|-------------------|---------------| |
| 109 | | **Square Footage** | Price per sq ft x difference | $50-$200/sq ft depending on market | |
| 110 | | **Bedrooms** | Per bedroom difference | $5,000-$20,000 per bedroom | |
| 111 | | **Bathrooms** | Per bathroom difference | $5,000-$15,000 per full bath | |
| 112 | | **Year Built / Age** | Per year difference | $500-$2,000 per year | |
| 113 | | **Lot Size** | Per 1,000 sq ft difference | $1,000-$10,000 per 1,000 sq ft | |
| 114 | | **Garage** | Per stall difference | $5,000-$15,000 per stall | |
| 115 | | **Pool** | Presence/absence | $10,000-$30,000 | |
| 116 | | **Basement (Finished)** | Per sq ft of finished space | $20-$50/sq ft | |
| 117 | | **Condition** | Per grade difference | $5,000-$25,000 per grade | |
| 118 | | **Location** | Superior/inferior location | 2-10% of sale price | |
| 119 | | **Sale Date (Time)** | Market apprec |