🏠 AI for Real Estate

{
  // Filterable
  "propertyTypes": ["residential", "commercial"],
  "functional": ["valuation", "market-analysis"],

  "reStandards": {
    "mismoCompliant": true,
    "reso": true,
    "fairHousing": true,
    "esign": false,
    "respa": false,
    "narCompliant": true,
    "tcpaCompliant": false,
    "mlsCompliant": true,
    "trainsOnClientData": false   // false → "re:no-trains-on-data" filter
  },

  // Display-only
  "targetUsers": ["Appraisers", "Investors", "Agents"],
  "integrations": ["Zillow", "MLS", "Salesforce"],
  "coverageArea": "United States",
  "founded": 2021,
  "headquarters": "Austin, TX",
  "dataSource": ["MLS listings", "Public records"],
  "dataRefreshRate": "Daily",
  "setupTime": "< 1 hour",
  "contractRequired": false,
  "freeTrialDays": 14,
  "sharesDataWithPortals": false,
  "agentVerifiedCount": 500,
  "roiMetrics": ["2x faster valuations"]
}

// label              → value (use as ?propertyType=value)
"Residential"      → "residential"
"Commercial"       → "commercial"
"Multifamily"      → "multifamily"
"Industrial"       → "industrial"
"Retail"           → "retail"
"Office"           → "office"
"Land"             → "land"

// label                      → value (use as ?functional=value)
"Valuation"              → "valuation"
"Market Analysis"        → "market-analysis"
"Risk Assessment"        → "risk-assessment"
"Investment Analysis"    → "investment-analysis"
"Due Diligence"          → "due-diligence"
"Lead Generation"        → "lead-generation"
"Lead Nurturing"         → "lead-nurturing"
"Showing Management"     → "showing-management"
"Prospecting"            → "prospecting"
"Predictive Analytics"   → "predictive-analytics"
"Listing Optimization"   → "listing-optimization"
"Property Management"    → "property-management"
"Maintenance Automation" → "maintenance-automation"
"Virtual Tours"          → "virtual-tours"
"Content Creation"       → "content-creation"
"Digital Marketing"      → "digital-marketing"
"Mortgage & Finance"     → "mortgage-finance"
"Transaction Management" → "transaction-management"
"Data Platform"          → "data-platform"
"Photo Analysis"         → "photo-analysis"
"Automation"             → "automation"
"Documentation"          → "documentation"

// typeFilters is a single DB column that holds prefixed slugs for ALL structured filters.
// There is NO ?typeFilters= query param. Instead, each named param translates
// into a substring check on this one column:

//   ?propertyType=residential  →  WHERE typeFilters LIKE '%prop:residential%'
//   ?functional=valuation      →  WHERE typeFilters LIKE '%func:valuation%'
//   ?mismoCompliant=true       →  WHERE typeFilters LIKE '%re:mismo-compliant%'
//   multiple params            →  all ANDed together

// Prefix system (all values are predefined — see Filter Values section above):
"prop:"  → property type  (e.g. prop:residential, prop:commercial)
"func:"  → functional role (e.g. func:valuation, func:lead-generation)
"re:"    → RE compliance  (e.g. re:mismo-compliant, re:no-trains-on-data)

// What the column actually contains for a tool (array in the API response):
"typeFilters": ["prop:residential", "func:valuation", "re:mismo-compliant"]

// tags is a completely separate DB column from typeFilters.
// Values are NOT predefined — the tool author sets whatever makes sense.
// Used for generic cross-category labels, NOT RE-specific structured filtering.

// What the column contains for a tool (array in the API response):
"tags": ["crm", "api", "automation", "zillow-integration"]

// When you send ?tags=crm,api the server splits by comma and ANDs each:
//   WHERE tags LIKE '%crm%'
//   AND   tags LIKE '%api%'
// It searches ONLY the tags column — it never touches typeFilters.
// Sending ?tags=residential will NOT match a tool that has prop:residential in typeFilters.

// Stored in DB as a JSON blob. NOT returned in the list endpoint.
// Only available on GET /api/ai-for-real-estate/:slug

// Contains the structured source-of-truth that typeFilters is derived from:
{
  "propertyTypes": ["residential", "commercial"],   // → populates prop:* in typeFilters
  "functional":    ["valuation", "market-analysis"],  // → populates func:* in typeFilters
  "reStandards": {
    "mismoCompliant":    true,   // → re:mismo-compliant in typeFilters
    "reso":              true,   // → re:reso-compliant
    "fairHousing":       true,   // → re:fair-housing
    "esign":             false,
    "respa":             false,
    "narCompliant":      true,   // → re:nar-compliant
    "tcpaCompliant":     false,
    "mlsCompliant":      true,   // → re:mls-compliant
    "trainsOnClientData":false   // false → re:no-trains-on-data
  },
  // Display-only fields (not filterable):
  "targetUsers":    ["Appraisers", "Investors"],
  "integrations":   ["Zillow", "MLS"],
  "coverageArea":   "United States",
  "dataRefreshRate":"Daily"
}

┌─────────────────┬──────────────────────┬──────────────────┬─────────────────────────────────────┐
│ Field           │ Values               │ In list?         │ Purpose                             │
├─────────────────┼──────────────────────┼──────────────────┼─────────────────────────────────────┤
│ typeFilters     │ Predefined (prefixed) │ YES              │ Powers ?propertyType, ?functional,  │
│                 │ prop: func: re:       │                  │ ?mismoCompliant etc. — all ANDed    │
├─────────────────┼──────────────────────┼──────────────────┼─────────────────────────────────────┤
│ tags            │ Free-form, anything  │ YES              │ Powers ?tags= — searches ONLY the   │
│                 │ author-defined       │                  │ tags column, never typeFilters       │
├─────────────────┼──────────────────────┼──────────────────┼─────────────────────────────────────┤
│ typeMetadata    │ Structured JSON blob │ NO (slug only)   │ Rich display data on the detail page│
└─────────────────┴──────────────────────┴──────────────────┴─────────────────────────────────────┘

Key rule: ?tags=residential will NOT match tools with prop:residential in typeFilters.
          Each column is filtered independently and they never overlap.

// No single param for the tab — use functional= per category page

// On the Lead Generation page:
GET /api/ai-for-real-estate?functional=lead-generation&sortBy=rank

// On the Listing Optimization page:
GET /api/ai-for-real-estate?functional=listing-optimization&sortBy=rank

// Homepage "For Agents" section — pick a representative category or show top-rated across all agent categories
GET /api/ai-for-real-estate?functional=lead-generation&topRated=true&limit=6

// Investment analysis tools, top rated
GET /api/ai-for-real-estate?functional=investment-analysis&topRated=true

// Risk assessment tools, NAR + MISMO compliant
GET /api/ai-for-real-estate?functional=risk-assessment&narCompliant=true&mismoCompliant=true

// Data platforms with API access
GET /api/ai-for-real-estate?functional=data-platform&apiAccess=true&sortBy=rank

// Property management tools with API access
GET /api/ai-for-real-estate?functional=property-management&apiAccess=true

// Maintenance automation, multifamily properties
GET /api/ai-for-real-estate?functional=maintenance-automation&propertyType=multifamily

// General automation tools, freemium or free
GET /api/ai-for-real-estate?functional=automation&pricingModel=freemium

For Agents            → ?functional=
  lead-generation
  lead-nurturing
  showing-management
  prospecting
  listing-optimization
  virtual-tours
  content-creation
  digital-marketing
  transaction-management
  photo-analysis
  documentation

For Investors         → ?functional=
  valuation
  market-analysis
  risk-assessment
  investment-analysis
  due-diligence
  predictive-analytics
  data-platform
  mortgage-finance

For Property Mgmt     → ?functional=
  property-management
  maintenance-automation
  automation
  documentation

// Residential tools only
GET /api/ai-for-real-estate?propertyType=residential

// Commercial tools, sorted by rating
GET /api/ai-for-real-estate?propertyType=commercial&sortBy=rating&sortOrder=desc

// Multifamily, top rated, page 2
GET /api/ai-for-real-estate?propertyType=multifamily&topRated=true&page=2

// Land tools, free pricing only
GET /api/ai-for-real-estate?propertyType=land&pricingModel=free

// Valuation tools
GET /api/ai-for-real-estate?functional=valuation

// Lead generation tools, verified only
GET /api/ai-for-real-estate?functional=lead-generation&verified=true

// Property management tools with API access
GET /api/ai-for-real-estate?functional=property-management&apiAccess=true

// Market analysis tools under $100/mo
GET /api/ai-for-real-estate?functional=market-analysis&maxPrice=100

// Investment analysis tools, ranked, limit 10
GET /api/ai-for-real-estate?functional=investment-analysis&sortBy=rank&limit=10

// Residential valuation tools
GET /api/ai-for-real-estate?propertyType=residential&functional=valuation

// Commercial lead-generation tools, featured only
GET /api/ai-for-real-estate?propertyType=commercial&functional=lead-generation&featured=true

// Multifamily property management tools with keyword search
GET /api/ai-for-real-estate?propertyType=multifamily&functional=property-management&search=automation

// MISMO compliant tools only
GET /api/ai-for-real-estate?mismoCompliant=true

// MLS + RESO compliant tools (both required — ANDed)
GET /api/ai-for-real-estate?mlsCompliant=true&reso=true

// Fair Housing compliant, NAR compliant, verified
GET /api/ai-for-real-estate?fairHousing=true&narCompliant=true&verified=true

// Tools that do NOT train on client data
GET /api/ai-for-real-estate?noTrainsOnData=true

// TCPA + RESPA compliant, freemium or free
GET /api/ai-for-real-estate?tcpaCompliant=true&respa=true&pricingModel=freemium

// eSign compliant residential tools
GET /api/ai-for-real-estate?esign=true&propertyType=residential

// Residential valuation tools that are MISMO + MLS compliant
GET /api/ai-for-real-estate?propertyType=residential&functional=valuation&mismoCompliant=true&mlsCompliant=true

// Commercial lead-generation, TCPA compliant, do not train on client data, top rated
GET /api/ai-for-real-estate?propertyType=commercial&functional=lead-generation&tcpaCompliant=true&noTrainsOnData=true&topRated=true

// Any property type, investment-analysis, NAR compliant, API access, max $200/mo
GET /api/ai-for-real-estate?functional=investment-analysis&narCompliant=true&apiAccess=true&maxPrice=200