{
  "meta": {
    "last_updated": "2026-04-01",
    "updated_by": "Earle",
    "notes": "Kate's lead pipeline and listings tracker. Edit lead status, dates, and notes as deals progress. Status values: new | warm | hot | closed | dead",
    "primary_market": "Magnolia / Montgomery County TX",
    "secondary_market": "Spring / The Woodlands TX"
  },
  "photographer_status": "needed",
  "active_leads": 4,
  "active_listings": 1,
  "pipeline_value": 2625000,
  "leads": [
    {
      "id": "L001",
      "name": "Jennifer & Marcus Whitfield",
      "contact": {
        "phone": "832-555-0142",
        "email": "jwhitfield@example.com"
      },
      "source": "Zillow Referral",
      "status": "hot",
      "type": "buyer",
      "price_range": {
        "min": 650000,
        "max": 850000
      },
      "area": "The Woodlands / Spring TX",
      "last_contact": "2026-03-24",
      "next_followup": "2026-03-26",
      "notes": "Relocating from Austin. Pre-approved at $800K. Want 4BR, home office, large backyard. Motivated \u2014 need to be in before school year. Toured 2 homes last weekend, liked both but nothing clicked yet.",
      "created": "2026-03-10"
    },
    {
      "id": "L002",
      "name": "Dr. Priya Nair",
      "contact": {
        "phone": "713-555-0287",
        "email": "pnair@example.com"
      },
      "source": "Past Client Referral",
      "status": "warm",
      "type": "buyer",
      "price_range": {
        "min": 400000,
        "max": 550000
      },
      "area": "Magnolia / Tomball TX",
      "last_contact": "2026-03-20",
      "next_followup": "2026-03-28",
      "notes": "First-time buyer, physician at Houston Methodist. Not in a rush but serious. Looking for something with a guest suite for parents. Referred by the Hendersons (closed 2024). Very thorough \u2014 will want to see comps before committing.",
      "created": "2026-03-05"
    },
    {
      "id": "L003",
      "name": "Robert & Diane Castellano",
      "contact": {
        "phone": "281-555-0391",
        "email": "rcastellano@example.com"
      },
      "source": "Open House",
      "status": "warm",
      "type": "buyer",
      "price_range": {
        "min": 900000,
        "max": 1200000
      },
      "area": "Champions / Memorial TX",
      "last_contact": "2026-03-18",
      "next_followup": "2026-03-27",
      "notes": "Empty nesters downsizing from 5BR. Want luxury finishes, single story preferred, 3-car garage. Cash buyers \u2014 no financing contingency. Toured Kate's open house on March 15, left contact card. High-value opportunity.",
      "created": "2026-03-15"
    },
    {
      "id": "L004",
      "name": "Tyler Beaumont",
      "contact": {
        "phone": "832-555-0519",
        "email": "tbeaumont@example.com"
      },
      "source": "Instagram DM",
      "status": "new",
      "type": "buyer",
      "price_range": {
        "min": 300000,
        "max": 400000
      },
      "area": "Spring / Klein TX",
      "last_contact": "2026-04-01",
      "next_followup": "2026-03-27",
      "notes": "Young professional, first home purchase. Found Kate through Instagram (@ElevateWithKate). Just reached out today. Needs pre-approval conversation first. High potential for referral network \u2014 active social presence.",
      "created": "2026-03-25"
    }
  ],
  "listings": [
    {
      "id": "LST001",
      "address": "24318 Harmony Pines Dr",
      "city": "Spring",
      "state": "TX",
      "zip": "77389",
      "price": 725000,
      "beds": 4,
      "baths": 3.5,
      "sqft": 3420,
      "status": "active",
      "days_on_market": 14,
      "list_date": "2026-03-11",
      "open_house": "2026-03-29",
      "photographer_status": "needed",
      "showings": 6,
      "notes": "Stunning lake-view lot, updated kitchen, primary suite with spa bath. Seller motivated. Waiting on photographer for professional listing photos \u2014 current MLS photos are phone quality.",
      "created": "2026-03-11"
    }
  ],
  "closed_this_year": 2,
  "gci_ytd": 38400,
  "followups_due": [
    {
      "id": "L001",
      "name": "Jennifer & Marcus Whitfield",
      "contact": {
        "phone": "832-555-0142",
        "email": "jwhitfield@example.com"
      },
      "source": "Zillow Referral",
      "status": "hot",
      "type": "buyer",
      "price_range": {
        "min": 650000,
        "max": 850000
      },
      "area": "The Woodlands / Spring TX",
      "last_contact": "2026-03-24",
      "next_followup": "2026-03-26",
      "notes": "Relocating from Austin. Pre-approved at $800K. Want 4BR, home office, large backyard. Motivated \u2014 need to be in before school year. Toured 2 homes last weekend, liked both but nothing clicked yet.",
      "created": "2026-03-10"
    },
    {
      "id": "L002",
      "name": "Dr. Priya Nair",
      "contact": {
        "phone": "713-555-0287",
        "email": "pnair@example.com"
      },
      "source": "Past Client Referral",
      "status": "warm",
      "type": "buyer",
      "price_range": {
        "min": 400000,
        "max": 550000
      },
      "area": "Magnolia / Tomball TX",
      "last_contact": "2026-03-20",
      "next_followup": "2026-03-28",
      "notes": "First-time buyer, physician at Houston Methodist. Not in a rush but serious. Looking for something with a guest suite for parents. Referred by the Hendersons (closed 2024). Very thorough \u2014 will want to see comps before committing.",
      "created": "2026-03-05"
    },
    {
      "id": "L003",
      "name": "Robert & Diane Castellano",
      "contact": {
        "phone": "281-555-0391",
        "email": "rcastellano@example.com"
      },
      "source": "Open House",
      "status": "warm",
      "type": "buyer",
      "price_range": {
        "min": 900000,
        "max": 1200000
      },
      "area": "Champions / Memorial TX",
      "last_contact": "2026-03-18",
      "next_followup": "2026-03-27",
      "notes": "Empty nesters downsizing from 5BR. Want luxury finishes, single story preferred, 3-car garage. Cash buyers \u2014 no financing contingency. Toured Kate's open house on March 15, left contact card. High-value opportunity.",
      "created": "2026-03-15"
    },
    {
      "id": "L004",
      "name": "Tyler Beaumont",
      "contact": {
        "phone": "832-555-0519",
        "email": "tbeaumont@example.com"
      },
      "source": "Instagram DM",
      "status": "new",
      "type": "buyer",
      "price_range": {
        "min": 300000,
        "max": 400000
      },
      "area": "Spring / Klein TX",
      "last_contact": "2026-04-01",
      "next_followup": "2026-03-27",
      "notes": "Young professional, first home purchase. Found Kate through Instagram (@ElevateWithKate). Just reached out today. Needs pre-approval conversation first. High potential for referral network \u2014 active social presence.",
      "created": "2026-03-25"
    }
  ],
  "last_updated": "2026-04-01"
}