afrexai-real-estate-engineComprehensive real estate system for investment and operations, including strategies, market analysis, deal sourcing, financial calculators, stress testing,...
Install via ClawdBot CLI:
clawdbot install 1kalin/afrexai-real-estate-engineComplete real estate system ā from deal sourcing through portfolio management. Covers buying, selling, investing, landlording, and development with actionable frameworks, calculators, and templates.
| Strategy | Capital Needed | Time Commitment | Risk | Cash Flow | Appreciation |
|----------|---------------|-----------------|------|-----------|-------------|
| Buy & Hold (rental) | Medium | Medium | Low-Med | ā Strong | ā Long-term |
| BRRRR | Medium-High | High | Medium | ā Recycled | ā Forced |
| Fix & Flip | High | Very High | High | ā Lump sum | N/A |
| House Hack | Low | Low | Low | ā Offset | ā Yes |
| Wholesale | Very Low | High | Low | ā Fee-based | N/A |
| Short-Term Rental (STR) | Medium | High | Med-High | ā ā Higher | ā Yes |
| Commercial | Very High | Medium | Medium | ā Strong | ā Yes |
| Land Banking | Low-Med | Very Low | Med-High | ā None | ā ā Speculative |
| REIT/Syndication | Any | Very Low | Varies | ā Passive | ā Diversified |
investment_criteria:
strategy: "buy_and_hold" # buy_and_hold | brrrr | flip | house_hack | str | commercial
markets:
primary: "" # City/metro you know best
secondary: [] # Expansion markets
property_types: [] # SFR, duplex, triplex, fourplex, MFH, commercial
price_range:
min: 0
max: 0
target_metrics:
min_cash_on_cash: 8 # % annual
min_cap_rate: 6 # %
max_price_per_unit: 0 # For multi-family
min_monthly_cashflow: 200 # Per unit, after all expenses
max_rehab_budget: 0 # For value-add
financing:
available_cash: 0
max_leverage: 80 # % LTV
preferred_loan: "conventional" # conventional | FHA | VA | DSCR | hard_money | seller_finance
deal_breakers: # Auto-reject
- "flood_zone"
- "foundation_issues"
- "environmental_contamination"
- "declining_population"
nice_to_haves:
- "below_median_price"
- "near_employment_centers"
- "growing_population"
- "landlord_friendly_state"
Score each market (0-100):
| Dimension | Weight | Metrics |
|-----------|--------|---------|
| Population Growth | 20% | 5yr trend, net migration, age demographics |
| Job Market | 20% | Unemployment rate, employer diversity, wage growth |
| Rent-to-Price Ratio | 15% | Gross rent / purchase price (>0.7% = good) |
| Landlord Friendliness | 15% | Eviction timeline, rent control, regulations |
| Supply/Demand | 15% | Vacancy rates, permits issued, absorption |
| Affordability | 10% | Median income vs median home price |
| Infrastructure | 5% | Transportation, schools, development plans |
Market grades:
ā” Meets price range criteria
ā” Rent-to-price ratio > 0.7% (or flip ARV margin > 30%)
ā” No deal-breaker conditions
ā” Neighborhood grade C+ or better
ā” Verified comparable sales within 6 months
ā” No major structural red flags from photos
ā” Zoning allows intended use
ā” Insurance obtainable (not in exclusion zone)
If ALL checked ā proceed to full analysis. If ANY unchecked ā pass or investigate.
MONTHLY INCOME
Gross Rent: $______
+ Other Income (laundry, parking, storage): $______
= Gross Monthly Income: $______
MONTHLY EXPENSES
Mortgage (P&I): $______
Property Tax: $______ (annual / 12)
Insurance: $______ (annual / 12)
Vacancy Reserve: $______ (8-10% of gross rent)
Maintenance Reserve: $______ (8-10% of gross rent)
CapEx Reserve: $______ (5-8% of gross rent)
Property Management: $______ (8-12% of gross rent)
HOA/Condo Fees: $______
Utilities (if landlord-paid): $______
= Total Monthly Expenses: $______
MONTHLY CASH FLOW = Gross Income - Total Expenses
ANNUAL CASH FLOW = Monthly Ć 12
KEY METRICS
Cash-on-Cash Return = Annual Cash Flow / Total Cash Invested Ć 100
Cap Rate = NOI / Purchase Price Ć 100
NOI = Annual Income - Annual Operating Expenses (excluding mortgage)
GRM = Purchase Price / Annual Gross Rent
DSCR = NOI / Annual Debt Service (lenders want > 1.25)
50% Rule (screening): Expenses ā 50% of gross rent (excluding mortgage)
ACQUISITION
Purchase Price: $______
Closing Costs (buy): $______ (2-4%)
= Total Acquisition: $______
REHAB
Renovation Budget: $______
+ Contingency (15%): $______
= Total Rehab: $______
HOLDING COSTS (Monthly Ć Hold Time)
Loan Payments: $______ /mo Ć ____ months
Insurance: $______ /mo Ć ____ months
Taxes: $______ /mo Ć ____ months
Utilities: $______ /mo Ć ____ months
= Total Holding: $______
SELLING COSTS
Agent Commission: $______ (5-6% of ARV)
Closing Costs: $______ (1-2% of ARV)
Staging: $______
= Total Selling: $______
TOTAL INVESTMENT = Acquisition + Rehab + Holding + Selling
PROFIT = ARV - Total Investment
ROI = Profit / Cash Invested Ć 100
RULES:
70% Rule: Max Offer = ARV Ć 0.70 - Repair Costs
Minimum profit target: $25,000 or 15% of ARV
BUY: Purchase price + closing costs
REHAB: Renovation budget + contingency
RENT: Market rent verification (3+ comps)
REFINANCE:
After Repair Value (ARV): $______
Refinance LTV (75%): $______
New Loan Amount: $______
Cash Recovered: New Loan - Original Loan Payoff
Cash Left In Deal: Total Invested - Cash Recovered
REPEAT:
Cash-on-Cash = Annual Cash Flow / Cash Left In Deal
Target: Infinite return (recover 100%+ of cash invested)
Run every deal through these scenarios:
| Scenario | Test | Pass Threshold |
|----------|------|----------------|
| Vacancy Spike | What if vacancy hits 20%? | Still cash-flow positive |
| Rate Increase | What if rates rise 2%? (ARM/refi) | Still cash-flow positive |
| Rent Decline | What if rents drop 10%? | Still covers mortgage + reserves |
| Major Repair | $10K-$20K unexpected expense | Can cover without selling |
| Market Crash | What if value drops 20%? | Not underwater on loan |
| Eviction | 3 months no rent + legal costs | Reserves cover it |
If ANY scenario = financial distress ā don't buy or renegotiate terms.
STRUCTURE (Deal-Breakers First)
ā” Foundation ā cracks, settling, water intrusion
ā” Roof ā age, condition, remaining life (replace: $8K-$15K+)
ā” Electrical ā panel age, amperage (100A minimum), knob-and-tube?
ā” Plumbing ā material (copper/PEX good, polybutylene/galvanized bad), water pressure
ā” HVAC ā age, type, efficiency (replace: $5K-$12K)
ā” Water heater ā age, capacity, type
ā” Windows ā single/double pane, condition, drafts
INTERIOR
ā” Flooring ā type, condition, repair vs replace
ā” Walls/ceilings ā water stains (= active leak?), cracks
ā” Kitchen ā cabinets, counters, appliances, layout
ā” Bathrooms ā fixtures, tile, ventilation, water damage
ā” Doors ā operation, locks, weather sealing
EXTERIOR
ā” Siding ā material, condition, paint
ā” Drainage ā grading away from foundation, gutters
ā” Driveway/walkways ā condition
ā” Landscaping ā trees near foundation, overgrowth
ā” Fencing ā condition, property line verification
ENVIRONMENTAL
ā” Lead paint (pre-1978 homes)
ā” Asbestos (insulation, tiles, siding)
ā” Radon testing
ā” Mold inspection
ā” Termite/pest inspection
ā” Flood zone check (FEMA maps)
TITLE & LEGAL
ā” Title search ā liens, encumbrances, easements
ā” Survey ā boundaries match deed
ā” Zoning verification ā conforming use
ā” HOA review ā rules, reserves, assessments, litigation
ā” Permit history ā all work permitted and closed
ā” Property tax verification ā pending reassessment?
subject_property:
address: ""
beds: 0
baths: 0
sqft: 0
lot_size: 0
year_built: 0
condition: "" # poor | fair | average | good | excellent
features: [] # garage, pool, basement, updated kitchen
comparables: # Need 3-5, sold within 6 months, within 1 mile
- address: ""
sold_price: 0
sold_date: ""
beds: 0
baths: 0
sqft: 0
adjustments:
sqft_diff: 0 # +/- $50-$150 per sqft
bed_diff: 0 # +/- $5K-$15K per bedroom
bath_diff: 0 # +/- $5K-$10K per bathroom
condition_diff: 0 # +/- $5K-$30K
garage_diff: 0 # +/- $5K-$15K
age_diff: 0 # +/- $1K-$5K per decade
adjusted_price: 0
estimated_value:
low: 0 # Lowest adjusted comp
mid: 0 # Average of adjusted comps
high: 0 # Highest adjusted comp
confidence: "" # high (tight range) | medium | low (wide spread)
| Loan Type | Down Payment | Rate | Best For | Watch Out |
|-----------|-------------|------|----------|-----------|
| Conventional | 20-25% | Lowest | Strong credit, primary or investment | DTI limits |
| FHA | 3.5% | Low | First-time buyers, house hack | Owner-occupy required, MIP |
| VA | 0% | Very Low | Veterans, house hack | Eligibility, funding fee |
| DSCR | 20-25% | Higher | Investors, no income verification | Higher rates, prepay penalty |
| Hard Money | 10-30% | Highest (10-15%) | Flips, bridge loans | Short term (6-18mo), points |
| Seller Finance | Negotiable | Negotiable | Creative deals, no bank qualifying | Balloon risk, due-on-sale |
| HELOC | N/A | Variable | Rehab funding, down payment | Variable rate, cross-collateral |
| Commercial | 25-35% | Medium-High | 5+ units, mixed-use | Shorter amort, balloon |
Refinance when ALL true:
screening_criteria:
income:
minimum_ratio: 3.0 # Monthly income / monthly rent
verification: ["pay_stubs_2mo", "tax_returns", "bank_statements", "employment_letter"]
credit:
minimum_score: 620 # Adjust for market
red_flags:
- "active_collections_over_500"
- "prior_eviction"
- "bankruptcy_under_2yrs"
- "multiple_late_payments"
background:
check: ["criminal", "eviction_history", "sex_offender"]
disqualify:
- "violent_felony"
- "drug_manufacturing"
- "prior_eviction_last_5yrs"
# NOTE: Follow Fair Housing laws ā no blanket bans
rental_history:
minimum_years: 2
verify: ["landlord_references_x2", "payment_history"]
red_flags:
- "no_references_available"
- "lease_violations"
- "unauthorized_occupants"
scoring: # Weight and score for borderline cases
income: 30
credit: 25
rental_history: 25
employment_stability: 10
completeness: 10
# Accept: >70/100 | Review: 50-70 | Decline: <50
MUST INCLUDE (All Jurisdictions)
ā” Parties (full legal names of all adults)
ā” Property address and description
ā” Lease term (start/end dates)
ā” Rent amount, due date, payment methods
ā” Security deposit amount and return conditions
ā” Late fee policy (amount, grace period)
ā” Maintenance responsibilities (landlord vs tenant)
ā” Entry/access notice requirements
ā” Termination/renewal procedures
ā” Pet policy (if applicable ā breed, size, deposit)
ā” Occupancy limits
ā” Utilities responsibility
ā” Insurance requirements (renter's insurance)
JURISDICTION-SPECIFIC (Verify Locally)
ā” Rent increase notice requirements
ā” Security deposit limits and interest
ā” Lead paint disclosure (pre-1978)
ā” Mold disclosure
ā” Bed bug policy
ā” Smoke/CO detector compliance
ā” Habitability standards
ā” Domestic violence provisions
MARKET RENT DETERMINATION
1. Search 5+ comparable rentals within 1 mile (same beds/baths/sqft range)
2. Adjust for: condition, amenities, parking, laundry, updates
3. Check trend: rising, flat, or declining market
4. Set at or slightly below market for fast occupancy (2-4 weeks target)
RENT INCREASE DECISION
Current market rent: $______
Current tenant rent: $______
Gap: $______
Tenant tenure: ____ years
Payment history: excellent / good / fair / poor
IF gap < 3%: Skip increase (retention > marginal revenue)
IF gap 3-10%: Increase to close 50% of gap
IF gap > 10%: Increase to close 75% of gap
IF tenant is problematic: Increase to full market (or non-renew)
TURNOVER COST CHECK:
Vacancy (1 month): $______
Make-ready repairs: $______
Listing/screening: $______
Total turnover cost: $______
Months to recoup with increase: Total / Monthly Increase
IF > 12 months to recoup: Consider smaller increase
| Priority | Response Time | Examples |
|----------|-------------|---------|
| P0 ā Emergency | Immediate (1-4 hrs) | Water leak, no heat (winter), gas leak, fire damage, lockout |
| P1 ā Urgent | 24 hours | Broken AC (summer), no hot water, toilet not working (only one), appliance failure |
| P2 ā Standard | 3-7 days | Minor plumbing, non-critical appliance, pest issue |
| P3 ā Low | 2-4 weeks | Cosmetic issues, landscaping, minor repairs |
| P4 ā Scheduled | Next turnover | Paint, carpet, upgrades |
ā” Track all income by property
ā” Track all expenses by property (receipts!)
ā” Calculate depreciation (include improvements)
ā” Document mileage for property visits
ā” Review 1031 exchange eligibility for any sales
ā” Evaluate cost segregation for new purchases
ā” Review RE Professional status hours log
ā” Consult CPA before Dec 31 for year-end planning
portfolio_snapshot:
date: ""
total_units: 0
total_value: 0 # Current market value
total_debt: 0 # Outstanding mortgages
total_equity: 0 # Value - Debt
ltv_ratio: 0 # Debt / Value (target: <70%)
monthly_gross_income: 0
monthly_expenses: 0
monthly_net_cashflow: 0
annual_cash_on_cash: 0 # %
portfolio_cap_rate: 0 # %
average_vacancy: 0 # % (target: <8%)
properties:
- address: ""
type: "" # SFR, duplex, etc.
units: 1
purchase_price: 0
purchase_date: ""
current_value: 0
mortgage_balance: 0
equity: 0
monthly_rent: 0
monthly_expenses: 0
monthly_cashflow: 0
cash_on_cash: 0
cap_rate: 0
occupancy: 0 # %
condition: "" # A, B, C, D
next_action: "" # hold, refinance, sell, improve
Sell when 2+ are true:
Hold when:
| Portfolio Size | Focus | Key Challenge |
|---------------|-------|---------------|
| 1-4 units | Learn fundamentals, systems | Analysis paralysis |
| 5-10 units | Hire PM, systematize | Cash flow vs growth |
| 11-25 units | Team building, commercial loans | Financing complexity |
| 26-50 units | Asset management, syndication | Operational complexity |
| 50+ units | Institutional standards, raise capital | Compliance, investor relations |
REVENUE ESTIMATION
Average Daily Rate (ADR): $______ (AirDNA, PriceLabs, comp search)
Occupancy Rate: ______% (conservative: 65%, good: 75%, great: 85%)
Monthly Revenue = ADR Ć 30 Ć Occupancy Rate
ADDITIONAL STR COSTS (vs long-term rental)
Furnishing (one-time): $5K-$25K depending on size
Cleaning (per turnover): $75-$200
Supplies/amenities (monthly): $100-$300
Channel management software: $50-$200/mo
Dynamic pricing tool: $20-$100/mo
Professional photos: $200-$500 (one-time)
Higher insurance: +$500-$2K/year
Higher utilities: +$200-$500/mo (you pay all)
Licensing/permits: $0-$5K/year
Occupancy/tourism tax: varies (8-15% of revenue)
NET = Revenue - All LTR Expenses - Additional STR Costs
Compare: STR Net vs LTR Net. Need >30% premium to justify extra work.
TITLE FORMULA: [Unique Feature] + [Location/View] + [Key Amenity]
Example: "Lakefront Cabin w/ Hot Tub | 5 Min to Slopes | Sleeps 8"
PHOTOS (20+ required):
1. Hero shot (best exterior or view)
2. Living room (wide angle, lights on)
3. Kitchen (clean, staged)
4. Master bedroom
5. Master bathroom
6. Each additional bedroom
7. Outdoor space / patio
8. Amenities (hot tub, pool, game room)
9. Neighborhood / attraction proximity
10. Welcome touches (basket, guidebook)
DESCRIPTION STRUCTURE:
Para 1: The experience (emotional, what makes it special)
Para 2: The space (factual, beds/baths/capacity)
Para 3: The location (distance to attractions, restaurants)
Para 4: The amenities (bullet list)
Para 5: Guest expectations (house rules, check-in)
PRICING STRATEGY:
- Use dynamic pricing (PriceLabs, Beyond, Wheelhouse)
- New listing: 20% below market for first 5 bookings (reviews)
- Weekend premium: +20-40%
- Event/seasonal premium: +50-200%
- Last-minute discount: -15% within 3 days
- Length-of-stay discount: 10% weekly, 20% monthly
| Strategy | Cost | Rent Increase | ROI |
|----------|------|---------------|-----|
| Kitchen update (counters, paint, hardware) | $3K-$8K | $75-$200/mo | 12-30 months |
| Bathroom refresh (vanity, fixtures, paint) | $1.5K-$4K | $50-$100/mo | 15-40 months |
| Flooring (LVP throughout) | $2K-$6K | $50-$150/mo | 20-40 months |
| Washer/dryer (in-unit) | $1K-$2K | $50-$100/mo | 10-20 months |
| Smart home (thermostat, locks, lights) | $500-$1.5K | $25-$50/mo | 10-30 months |
| Add bedroom (convert den/office) | $2K-$10K | $100-$300/mo | 7-33 months |
| ADU / garage conversion | $30K-$100K | $800-$2000/mo | 15-50 months |
| Utility bill-back (RUBS) | $500 | $50-$150/mo | 3-10 months |
| Laundry (coin-op) | $3K-$8K | $50-$100/unit/mo | 3-13 months |
BEFORE SELLING
ā” Identify qualified intermediary (QI) BEFORE closing
ā” Document investment intent (not personal use)
ā” Calculate basis and estimated gain
ā” Identify potential replacement properties
TIMELINE (Strict ā No Extensions)
Day 0: Close sale of relinquished property
Day 45: Identify up to 3 replacement properties (or 200% rule)
Day 180: Close on replacement property
RULES
ā” Like-kind (any real property ā any real property)
ā” Equal or greater value
ā” Equal or greater debt
ā” All equity reinvested (boot = taxable)
ā” Same taxpayer on both transactions
ā” Not personal residence (unless converted)
ā” QI holds funds (never touch the money)
STRUCTURE
- GP (General Partner): You ā finds deals, manages, earns fees + promote
- LP (Limited Partners): Investors ā passive, earn preferred return + split
TYPICAL TERMS
Preferred Return: 6-8% (LP gets paid first)
Profit Split: 70/30 or 80/20 (LP/GP after preferred)
Acquisition Fee: 1-3% of purchase price (to GP)
Asset Management Fee: 1-2% of revenue (to GP)
Hold Period: 3-7 years
REQUIREMENTS
- Securities attorney (506(b) or 506(c) exemption)
- CPA experienced in syndication
- Track record (start with JV, then syndicate)
- PPM, operating agreement, subscription agreement
- Investor relations system
EXPANSION ā HYPER-SUPPLY ā RECESSION ā RECOVERY ā EXPANSION...
EXPANSION (BUY)
Signals: Rising rents, falling vacancy, new construction starting
Strategy: Acquire aggressively, lock long-term financing
HYPER-SUPPLY (CAUTION)
Signals: Overbuilding, rising vacancy, rent growth slowing
Strategy: Stop acquiring, focus on operations, build reserves
RECESSION (PREPARE)
Signals: Rising vacancy, falling rents, distress sales emerging
Strategy: Hold cash, hunt distressed deals, negotiate hard
RECOVERY (AGGRESSIVE BUY)
Signals: Vacancy stabilizing, construction stopped, prices bottoming
Strategy: Maximum acquisition mode ā best deals of the cycle
| Dimension | Weight | Score |
|-----------|--------|-------|
| Financial Analysis Rigor | 20% | Numbers verified, stress-tested, conservative assumptions |
| Due Diligence Completeness | 15% | All inspection items checked, title clear |
| Market Research Depth | 15% | Multiple data sources, trends analyzed |
| Risk Assessment | 15% | Downside scenarios modeled, mitigations planned |
| Legal/Tax Compliance | 10% | Jurisdiction-specific, professional consultation noted |
| Operational Planning | 10% | PM, maintenance, tenant systems in place |
| Exit Strategy Clarity | 10% | Hold period, triggers, 1031 optionality |
| Documentation Quality | 5% | Organized, retrievable, complete records |
"Analyze this deal" ā Full rental/flip/BRRRR calculator
"Screen this property" ā 5-minute screening checklist
"Compare these comps" ā CMA analysis with adjustments
"Set rent for [addr]" ā Market rent analysis with comp research
"Screen this tenant" ā Scoring template with criteria
"Review my portfolio" ā Portfolio health dashboard
"Should I sell [addr]" ā Hold vs sell framework
"STR feasibility" ā Short-term rental analysis
"1031 exchange plan" ā Timeline and checklist
"Market analysis [city]" ā Full market scoring
"Value-add options" ā Renovation ROI analysis
"Tax strategy review" ā Annual tax optimization checklist
This skill provides educational frameworks and analysis templates. It is not legal, tax, or investment advice. Always consult qualified professionals (attorney, CPA, licensed agent) for jurisdiction-specific guidance. Laws vary dramatically by location. Never make investment decisions based solely on AI analysis.
Generated Feb 26, 2026
An individual looking to purchase their first rental property using a buy-and-hold strategy. They need help defining investment criteria, analyzing markets, and calculating cash flow to ensure a profitable, low-risk entry into real estate investing.
A seasoned investor focusing on acquiring distressed properties, renovating them, and selling for profit. They require tools for deal sourcing, rehab budgeting, and holding cost analysis to maximize margins and manage project timelines effectively.
A professional managing a portfolio of rental units, such as duplexes or apartment buildings. They use the skill to screen new deals, optimize financing strategies, and monitor key metrics like cap rate and cash-on-cash return across multiple properties.
An entrepreneur who sources off-market deals and assigns contracts to other investors for a fee. They leverage the skill's deal channels and screening checklist to quickly identify viable properties and negotiate with sellers without holding long-term assets.
A first-time homebuyer aiming to reduce living expenses by purchasing a multi-unit property, living in one unit, and renting out the others. They use the skill to evaluate financing options, calculate offset cash flow, and ensure the property meets their criteria for long-term appreciation.
Generates revenue through monthly rental income from long-term tenants. This model focuses on acquiring properties with strong cash flow, managing expenses like maintenance and vacancies, and leveraging appreciation over time for wealth building.
Involves buying undervalued properties, renovating them, and selling quickly for a profit. Revenue comes from the sale price minus acquisition and rehab costs, with high returns but significant risk and time commitment.
Pools capital from multiple investors to acquire larger properties like commercial buildings or multi-family units. Revenue is generated through passive income distributions, management fees, and eventual sale proceeds, offering diversification with lower direct involvement.
š¬ Integration Tip
Integrate with financial tracking software or CRM systems to automate deal analysis and monitor portfolio performance in real-time.
Guide any property decision for buyers, sellers, landlords, investors, or agents in any jurisdiction.
Use when designing new system architecture, reviewing existing designs, or making architectural decisions. Invoke for system design, architecture review, design patterns, ADRs, scalability planning.
Document significant technical decisions with context, rationale, and consequences to maintain clear, lightweight architectural records for future reference.
Predict construction project costs using Machine Learning. Use Linear Regression, K-Nearest Neighbors, and Random Forest models on historical project data. Train, evaluate, and deploy cost prediction models.
Generate photorealistic architectural renders and visualizations using each::sense AI. Create exterior views, interior renders, sketch-to-render conversions,...
Dual-stream event publishing combining Kafka for durability with Redis Pub/Sub for real-time delivery. Use when building event-driven systems needing both guaranteed delivery and low-latency updates. Triggers on dual stream, event publishing, Kafka Redis, real-time events, pub/sub, streaming architecture.