# 🏢 Real Estate Command Center Pro

> **Cover Image:** Abstract architectural blueprint or high-end city skyline.
> **Icon:** 🏢

---

## 📊 Dashboard (Command View)

**Layout:** 3-Column Layout

### Column 1: Business Health (Metrics)
*   **Projected GCI (Rollup):** Sum of `Gross Commission` from *Transactions* where Status is "Under Contract" or "Closing Soon."
*   **Year-to-Date Closed (Rollup):** Sum of `Net Commission` from *Transactions* where Status is "Closed" in the current year.
*   **Pipeline Velocity (Formula):** Average `Days on Market` for active listings.
*   **Active Lead Count (Rollup):** Count of *Transactions* where Status is "New Lead."

### Column 2: Deal Pipeline (Board View)
*   **Source:** *Transactions Database*
*   **Group By:** Status
*   **Filter:** Status is NOT "Closed" or "Lost."
*   **Properties Shown:** Property Address, Client, Sale Price, Closing Date.

### Column 3: Critical Action Items (List View)
*   **Source:** *Tasks Database*
*   **Filter:** Status is NOT "Done" AND Due Date is within next 7 days.
*   **Sort By:** Due Date (Ascending)
*   **Properties Shown:** Task Name, Related Transaction, Priority.

---

## 🏠 Transactions Database (Core)

**Icon:** 🏠 | **Database Template:** Enabled

### Properties
*   **Property Address** (Title) — Text
*   **Status** (Select) — Options: `🔵 New Lead`, `🟣 Showing`, `🟠 Offer Submitted`, `🟡 Under Contract`, `🟢 Closed`, `🔴 Lost`, `⚫ On Hold`
*   **Client** (Relation) — Links to *Contacts Database*
*   **Transaction Side** (Select) — `Buyer`, `Seller`, `Dual`
*   **List Date** (Date)
*   **Under Contract Date** (Date) — *Critical for task automation*
*   **Closing Date** (Date)
*   **Sale Price** (Number) — Format: Currency ($)
*   **Commission %** (Number) — Format: Percent (%)
*   **Gross Commission** (Formula) — `prop("Sale Price") * prop("Commission %")`
*   **Broker Split %** (Number)
*   **Net Commission** (Formula) — `prop("Gross Commission") * (1 - prop("Broker Split %"))`
*   **Days on Market** (Formula) — `if(not empty(prop("List Date")), dateBetween(now(), prop("List Date"), "days"), 0)`
*   **Offers** (Relation) — Links to *Offers Database*
*   **Expenses** (Relation) — Links to *Expenses Database*

### Views
1.  **Pipeline Board:** Grouped by Status. Cards show Address & Price.
2.  **Closing Calendar:** Calendar view using `Closing Date`.
3.  **Financial Table:** Table view showing Sale Price, Gross Commission, Net Commission.

---

## 📝 Offers Database (Bid Management)

**Icon:** 📝 | **Database Template:** Enabled

### Properties
*   **Offer ID** (Title) — Auto-generated or Text (e.g., "Offer - 124 Maple")
*   **Related Transaction** (Relation) — Links to *Transactions Database*
*   **Buyer** (Relation) — Links to *Contacts Database*
*   **Offer Amount** (Number) — Currency
*   **Earnest Money** (Number) — Currency
*   **Financing Type** (Select) — `Cash`, `Conventional`, `FHA`, `VA`
*   **Contingencies** (Multi-select) — `Inspection`, `Appraisal`, `Financing`, `Sale of Home`
*   **Offer Status** (Select) — `🟢 Accepted`, `🟡 Counter Offer`, `🔴 Rejected`, `⚪ Withdrawn`, `🔵 Submitted`
*   **Expiration Date** (Date)

### Views
1.  **Active Offers:** Filtered by `Offer Status` is "Submitted" or "Counter Offer". Sorted by `Offer Amount` (High to Low).

---

## 👥 Contacts & CRM Database

**Icon:** 👥 | **Database Template:** Enabled

### Properties
*   **Name** (Title) — Text
*   **Role** (Select) — `Buyer`, `Seller`, `Investor`, `Lender`, `Title Agent`, `Inspector`, `Contractor`
*   **Lead Source** (Select) — `Zillow`, `Referral`, `Website`, `Open House`, `Past Client`, `Zillow Flex`
*   **Email** (Email)
*   **Phone** (Phone)
*   **Transactions** (Relation) — Links to *Transactions Database*
*   **Total Spend (Rollup)** — Rolls up `Sale Price` from *Transactions* (for ROI calculation).
*   **Notes** (Text)

### Views
1.  **All Contacts:** List view.
2.  **Vendors Only:** Filtered by Role includes `Lender`, `Title Agent`, `Inspector`.

---

## ✅ Tasks & Deadline Manager

**Icon:** ✅ | **Database Template:** Enabled

### Properties
*   **Task Name** (Title) — Text
*   **Status** (Select) — `🔴 Not Started`, `🟡 In Progress`, `🟢 Done`, `⚫ Blocked`
*   **Priority** (Select) — `High`, `Medium`, `Low`
*   **Due Date** (Date)
*   **Related Transaction** (Relation) — Links to *Transactions Database*
*   **Assigned To** (Person)

### Automation Logic (Database Templates)
*Create these templates in the "New" button menu:*
1.  **Buyer Checklist:**
    *   "Pre-Approval Letter" (Due: Today)
    *   "Home Search Initiated" (Due: Today)
    *   "Offer Submitted" (Due: +2 days from start)
2.  **Under Contract Checklist:**
    *   "Open Escrow/Title" (Due: Date relative to `Under Contract Date` from Transaction)
    *   "Home Inspection Ordered" (Due: `Under Contract Date` + 3 days)
    *   "Disclosures Sent" (Due: `Under Contract Date` + 5 days)
    *   "Loan Application Submitted" (Due: `Under Contract Date` + 7 days)
    *   "Appraisal Ordered" (Due: `Under Contract Date` + 10 days)
    *   "Contingency Removal" (Due: `Under Contract Date` + 14 days)
    *   "Final Walkthrough" (Due: `Closing Date` - 1 day)

### Views
1.  **Task Board:** Grouped by Status.
2.  **Upcoming Deadlines:** Calendar view by `Due Date`.

---

## 💸 Expenses Database

**Icon:** 💸 | **Database Template:** Enabled

### Properties
*   **Expense Name** (Title) — Text
*   **Category** (Select) — `Marketing`, `Closing Costs`, `Home Staging`, `Repairs`, `Office Supplies`, `Client Gift`
*   **Amount** (Number) — Currency
*   **Date** (Date)
*   **Reimbursable?** (Checkbox)
*   **Related Transaction** (Relation) — Links to *Transactions Database*
*   **Receipt** (Files & Media)

### Views
1.  **All Expenses:** Table view.
2.  **Unreimbursed:** Filtered by `Reimbursable?` is checked.

---

## 📂 Document Vault

**Icon:** 📂 | **Database Template:** Enabled

### Properties
*   **Document Name** (Title) — Text
*   **Category** (Select) — `Contract`, `Disclosure`, `Inspection Report`, `Addendum`, `HOA Docs`
*   **Status** (Select) — `Draft`, `Review`, `Signed`, `Filed`
*   **Date Uploaded** (Date)
*   **Related Transaction** (Relation) — Links to *Transactions Database*
*   **File** (Files & Media)

### Views
1.  **Gallery View:** Cover image set to "File" preview (if image) or generic icon. Grouped by `Related Transaction`.

---

## 🔧 Configuration & Formulas Reference

### 1. Commission Formula (Transactions)
```javascript
prop("Sale Price") * prop("Commission %")
```

### 2. Net Commission Formula (Transactions)
```javascript
prop("Gross Commission") - (prop("Gross Commission") * prop("Broker Split %"))
```

### 3. Days on Market (Transactions)
```javascript
if(empty(prop("List Date")), 0, dateBetween(now(), prop("List Date"), "days"))
```

### 4. Dashboard Setup Instructions
*   **Rollups:** In the Dashboard, create "Synced Blocks" or simple text blocks, then type `/rollup` and select the specific property from the related database (e.g., Rollup `Net Commission` from *Transactions*).
*   **Charts:** Use a Notion Chart view (if available in your plan) or create a simple progress bar using a Formula property in the Transactions database:
    *   *Progress Bar Formula:*
        ```javascript
        slice("██████████", 0, floor(prop("Sale Price") / 100000)) + "░" + slice("░░░░░░░░░░", 0, 10 - floor(prop("Sale Price") / 100000))
        ```
        *(Note: Adjust the divisor based on your average home price for visual scaling).*