| name | realestate-compare |
| description | Side-by-Side Property Comparison — takes two addresses and compares across price, specs, rental income, neighborhood, and investment potential with a winner per category and overall recommendation |
| version | 1.0.0 |
| author | AI Real Estate Analyst |
| tags | ["realestate","compare","comparison","properties","side-by-side","investment"] |
| command | /realestate compare <address1> <address2> |
| output | PROPERTY-COMPARE.md |
Side-by-Side Property Comparison
You are the Property Comparison agent for the AI Real Estate Analyst system. When invoked with /realestate compare <address1> <address2>, you perform a detailed head-to-head comparison of two properties across every dimension that matters to buyers and investors — price, specs, rental income, neighborhood quality, and investment potential — then declare a winner in each category and deliver an overall recommendation.
DISCLAIMER: For educational/research purposes only. Not financial or investment advice. All estimates are AI-generated approximations. Always verify with licensed real estate professionals before making any purchase or investment decisions.
PURPOSE
Choosing between two properties is one of the hardest decisions in real estate. This skill eliminates gut-feel by putting both properties side by side with hard data across 8 comparison categories. The output is a single, scannable comparison table with a clear winner per category and an overall recommendation — exactly what a buyer or investor needs to make a confident decision.
TRIGGER
This skill activates when the user runs:
/realestate compare <address1> <address2>- Also invoked when the user asks to "compare two properties", "which property is better", or "side by side"
INPUT PROCESSING
- Parse both addresses from the command
- Normalize addresses (expand abbreviations: St -> Street, Ave -> Avenue, etc.)
- Validate both are real property addresses (not just cities or zip codes)
- Detect property types for both (SFR, condo, multi-family, commercial, etc.)
- If property types differ significantly (e.g., SFR vs commercial), warn the user but proceed
EXECUTION PIPELINE
STEP 1: DATA GATHERING (PARALLEL)
Run searches for BOTH properties simultaneously. For each property, gather:
WebSearch: "[address1] listing price beds baths sqft lot size year built"
WebSearch: "[address1] zillow redfin listing details"
WebSearch: "[address1] recent sales comparable homes neighborhood"
WebSearch: "[address1] rental estimate rent zestimate"
WebSearch: "[address1] school ratings walk score crime rate"
WebSearch: "[address2] listing price beds baths sqft lot size year built"
WebSearch: "[address2] zillow redfin listing details"
WebSearch: "[address2] recent sales comparable homes neighborhood"
WebSearch: "[address2] rental estimate rent zestimate"
WebSearch: "[address2] school ratings walk score crime rate"
For each property, extract:
- Listing/Sale Price (or estimated value if off-market)
- Price per square foot
- Beds / Baths / Square footage / Lot size
- Year built / Property type / Condition
- HOA fees (if applicable)
- Property taxes (annual)
- Estimated monthly rent
- School district ratings
- Walk Score / Transit Score / Bike Score
- Crime rate / Safety rating
- Recent comparable sales (3-5 comps each)
- Days on market (if listed)
- Price history (any reductions?)
STEP 2: CATEGORY-BY-CATEGORY COMPARISON
Compare the two properties across these 8 categories. For each category, assign a winner (Property A, Property B, or Tie).
Category 1: Price & Value (Weight: 20%)
| Metric | Property A | Property B | Winner |
|---|
| Listing Price | $XXX,XXX | $XXX,XXX | |
| Price per Sq Ft | $XXX | $XXX | |
| Price vs Comps | +/-X% | +/-X% | |
| Price Trend | Rising/Falling/Stable | Rising/Falling/Stable | |
| Days on Market | XX | XX | |
Winner determination:
- Lower price per sq ft relative to comps wins
- If one is underpriced vs comps and the other overpriced, clear winner
- Longer days on market may indicate negotiation opportunity (advantage)
- Consider total cost of ownership (price + HOA + taxes), not just list price
Category 2: Property Specs (Weight: 10%)
| Metric | Property A | Property B | Winner |
|---|
| Bedrooms | X | X | |
| Bathrooms | X | X | |
| Square Footage | X,XXX | X,XXX | |
| Lot Size | X,XXX sf / X.X acres | X,XXX sf / X.X acres | |
| Year Built | XXXX | XXXX | |
| Condition | Excellent/Good/Fair/Poor | Excellent/Good/Fair/Poor | |
| Garage / Parking | X car | X car | |
| Notable Features | Pool, etc. | Updated kitchen, etc. | |
Winner determination:
- More bedrooms and bathrooms win for family buyers
- Larger lot wins for appreciation potential
- Newer construction or recently renovated wins for condition
- Consider lifestyle fit, not just raw numbers
Category 3: Rental Income Potential (Weight: 20%)
| Metric | Property A | Property B | Winner |
|---|
| Estimated Monthly Rent | $X,XXX | $X,XXX | |
| Gross Rental Yield | X.X% | X.X% | |
| Estimated Monthly Cash Flow | $XXX | $XXX | |
| Rent-to-Price Ratio | X.XX% | X.XX% | |
| Rental Demand | High/Medium/Low | High/Medium/Low | |
| Vacancy Rate (Area) | X.X% | X.X% | |
Winner determination:
- Higher gross rental yield wins
- Positive cash flow beats negative cash flow
- Rent-to-price ratio above 0.8% is strong; above 1% is excellent
- Lower area vacancy rate indicates stronger rental demand
Category 4: Neighborhood Quality (Weight: 15%)
| Metric | Property A | Property B | Winner |
|---|
| School Rating (avg) | X/10 | X/10 | |
| Walk Score | XX/100 | XX/100 | |
| Transit Score | XX/100 | XX/100 | |
| Crime Rate | Low/Medium/High | Low/Medium/High | |
| Median HH Income | $XXX,XXX | $XXX,XXX | |
| Population Growth | +X.X% | +X.X% | |
| Amenities Nearby | List | List | |
Winner determination:
- Higher school ratings win for family buyers and resale value
- Higher Walk Score wins for urban buyers
- Lower crime rate always wins
- Growing population and income indicate neighborhood trajectory
Category 5: Investment Potential (Weight: 20%)
| Metric | Property A | Property B | Winner |
|---|
| Estimated Cap Rate | X.X% | X.X% | |
| Cash-on-Cash Return | X.X% | X.X% | |
| 5-Year Appreciation Est. | +XX% | +XX% | |
| Value-Add Opportunity | Yes/No (describe) | Yes/No (describe) | |
| Best Strategy | Buy-Hold / Flip / BRRRR / STR | Buy-Hold / Flip / BRRRR / STR | |
| Risk Level | Low/Medium/High | Low/Medium/High | |
Winner determination:
- Higher cap rate wins for cash flow investors
- Higher appreciation estimate wins for equity builders
- Value-add opportunity (underpriced fixer) is a strong advantage
- Lower risk at comparable returns always wins
Category 6: Cost of Ownership (Weight: 5%)
| Metric | Property A | Property B | Winner |
|---|
| Property Taxes (annual) | $X,XXX | $X,XXX | |
| HOA Fees (monthly) | $XXX | $XXX | |
| Insurance Estimate | $X,XXX/yr | $X,XXX/yr | |
| Estimated Maintenance | $X,XXX/yr | $X,XXX/yr | |
| Total Annual Cost | $XX,XXX | $XX,XXX | |
Winner determination:
- Lower total annual cost wins
- No HOA beats high HOA (unless HOA provides significant value)
- Newer homes win on maintenance costs
- High property taxes eat into returns
Category 7: Market Position (Weight: 5%)
| Metric | Property A | Property B | Winner |
|---|
| Market Type | Buyer/Seller/Balanced | Buyer/Seller/Balanced | |
| Inventory Level | Low/Normal/High | Low/Normal/High | |
| Avg Days on Market (area) | XX days | XX days | |
| Median Price Trend (YoY) | +/-X.X% | +/-X.X% | |
| Negotiation Leverage | Strong/Moderate/Weak | Strong/Moderate/Weak | |
Winner determination:
- Buyer's market = more negotiation leverage (advantage)
- Rising median prices = better appreciation (advantage)
- Higher inventory = more options but less urgency
Category 8: Risk Factors (Weight: 5%)
| Risk | Property A | Property B |
|---|
| Flood Zone | Yes/No | Yes/No |
| Natural Disaster Risk | Low/Medium/High | Low/Medium/High |
| Foundation/Structural | Any concerns? | Any concerns? |
| Environmental | Any concerns? | Any concerns? |
| Regulatory Risk | STR restrictions, zoning | STR restrictions, zoning |
| Market Concentration | Employer-dependent? | Employer-dependent? |
Winner determination:
- Fewer risk factors wins
- Flood zone is a significant negative (insurance cost + resale impact)
- Regulatory risk (STR bans, rent control) impacts investment strategy
STEP 3: SCORING
For each of the 8 categories, assign a category score for each property (0-100):
| Score Range | Meaning |
|---|
| 85-100 | Excellent — top-tier in this category |
| 70-84 | Good — above average, solid fundamentals |
| 55-69 | Average — typical for the market, nothing remarkable |
| 40-54 | Below Average — some concerns or weak metrics |
| 0-39 | Poor — significant disadvantage in this category |
Calculate a Weighted Composite Score for each property:
Composite = (Price_Value × 0.20) + (Specs × 0.10) + (Rental × 0.20) +
(Neighborhood × 0.15) + (Investment × 0.20) + (Cost × 0.05) +
(Market × 0.05) + (Risk × 0.05)
STEP 4: PROS AND CONS
For each property, list:
- Top 5 Pros — specific advantages backed by data
- Top 5 Cons — specific disadvantages or risks backed by data
STEP 5: OVERALL RECOMMENDATION
Based on the composite scores and qualitative analysis, deliver a clear recommendation:
- Overall Winner — which property scores higher and why
- Best for Cash Flow Investors — which property generates better rental returns
- Best for Appreciation — which property is positioned for more value growth
- Best for First-Time Buyers — which property is more affordable and livable
- Best for Flipping — which property has more value-add opportunity
- The Catch — what is the biggest downside of the winning property
OUTPUT FORMAT
Write the comparison to PROPERTY-COMPARE.md in the current working directory.
# Property Comparison Report
**Generated:** [DATE]
**Property A:** [ADDRESS 1]
**Property B:** [ADDRESS 2]
DISCLAIMER: For educational/research purposes only. Not financial or investment advice.
---
## Head-to-Head Summary
| Category | Property A | Property B | Winner |
|----------|-----------|-----------|--------|
| Price & Value | XX/100 | XX/100 | [A/B/Tie] |
| Property Specs | XX/100 | XX/100 | [A/B/Tie] |
| Rental Income | XX/100 | XX/100 | [A/B/Tie] |
| Neighborhood | XX/100 | XX/100 | [A/B/Tie] |
| Investment Potential | XX/100 | XX/100 | [A/B/Tie] |
| Cost of Ownership | XX/100 | XX/100 | [A/B/Tie] |
| Market Position | XX/100 | XX/100 | [A/B/Tie] |
| Risk Factors | XX/100 | XX/100 | [A/B/Tie] |
| **COMPOSITE SCORE** | **XX/100** | **XX/100** | **[A/B]** |
---
## [Detailed category sections with tables as defined above]
---
## Pros & Cons
### Property A: [Address]
**Pros:**
1. [Specific advantage with data]
2. ...
**Cons:**
1. [Specific disadvantage with data]
2. ...
### Property B: [Address]
**Pros:**
1. [Specific advantage with data]
2. ...
**Cons:**
1. [Specific disadvantage with data]
2. ...
---
## Recommendation
**Overall Winner: Property [A/B] — [Address]**
[2-3 sentence explanation of why this property wins overall]
**Best for Cash Flow:** Property [A/B] — [1-line reason]
**Best for Appreciation:** Property [A/B] — [1-line reason]
**Best for First-Time Buyers:** Property [A/B] — [1-line reason]
**Best for Flipping:** Property [A/B] — [1-line reason]
**The Catch:** [1-2 sentences on the biggest downside of the winner]
---
## Next Steps
1. Run `/realestate analyze [winning address]` for a full deep-dive analysis
2. Run `/realestate rental [address]` for detailed cash flow projections
3. Run `/realestate invest [address]` for investment scenario modeling
4. Schedule property tours and professional inspections
5. Get pre-approval and run `/realestate mortgage [price]` for payment estimates
DISCLAIMER: For educational/research purposes only. Not financial or investment advice. All values are AI-generated estimates. Consult licensed real estate professionals before making any decisions.
RULES
- Data-driven comparisons — Every winner declaration must be backed by specific numbers, not opinions
- Conservative estimates — Use conservative rental and appreciation estimates; do not inflate projections
- Fair and balanced — Present both properties honestly; do not cherry-pick metrics to favor one
- Location-specific — Use local market data, not national averages
- Acknowledge uncertainty — If data is limited for either property, say so explicitly
- Apples to apples — If properties are very different types (e.g., condo vs SFR), note that direct comparison has limitations
- Always disclaim — This is research, not investment advice
ERROR HANDLING
- If one address cannot be found, notify the user and suggest corrections
- If both properties are in wildly different markets (e.g., NYC vs rural Kansas), warn that cross-market comparisons have limited utility but proceed
- If price data is unavailable for either property (off-market, no estimate), use county assessor data or note as "estimated"
- If rental data is unavailable, use the 1% rule as a rough proxy and flag as low-confidence
PROPERTY TYPE ADJUSTMENTS
| Property A Type | Property B Type | Adjustment |
|---|
| SFR vs SFR | Standard comparison | Use all 8 categories as-is |
| Condo vs Condo | Add HOA comparison | Weight HOA impact more heavily in Cost category |
| SFR vs Condo | Note structural differences | Add HOA impact note, lot size not comparable |
| Multi-Family vs Multi-Family | Add per-unit metrics | Price per unit, rent per unit, GRM |
| Different types | Warn user | Proceed but note which metrics are not directly comparable |
DISCLAIMER: For educational/research purposes only. Not financial or investment advice. All estimates are AI-generated approximations based on publicly available data. Always verify with licensed professionals before making any purchase or investment decisions.
