[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_334":335,"_336":337},"routes/_app.x.$handle.$name",{"_112":111,"_38":52,"_120":98,"_33":121,"_13":14,"_122":-5,"_11":123,"_124":125,"_126":127,"_128":129,"_130":131,"_26":-5,"_132":133,"_134":135,"_136":31,"_137":138,"_139":67,"_140":-5,"_141":-5,"_142":143},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_50":51,"_38":52,"_45":53,"_54":-5,"_55":31,"_56":57,"_58":57,"_59":60,"_61":62,"_19":63,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":71,"_72":73,"_74":75,"_76":77,"_78":79,"_80":-5,"_81":82,"_83":82,"_84":85,"_86":85,"_87":85,"_88":82,"_89":82,"_90":91,"_92":93,"_94":95,"_96":31},"version",27,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","e4ae5f13-2593-4cd9-86b0-e48301743e91","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":41,"_42":44,"_45":46,"_47":14,"_48":49,"_30":31},"previous",{"_36":37,"_38":39,"_40":41,"_42":43},"deleted",false,"deletedHere","path","frontend/components/ListingsTable.tsx","latestPath","fileId","ded182a2-7c97-11f1-8c37-1607ee4eb77e","name","ListingsTable.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport type { Listing } from \"../types.ts\";\n\nfunction telHref(phone: string): string | null {\n const match = phone.match(/\$?\\d{3}\$?[-.\\s]?\\d{3}[-.\\s]?\\d{4}/);\n return match ? `tel:${match[0].replace(/\\D/g, \"\")}` : null;\n}\n\nfunction WebsiteCell({ listing }: { listing: Listing }) {\n if (listing.website) {\n const label = listing.website_label || new URL(listing.website).hostname;\n return (\n \n {label}\n \n );\n }\n if (listing.website_label) {\n // Legacy rows from the spreadsheet where only the link text survived:\n // link to a web search so the site is still one click away\n return (\n \n {listing.website_label}\n \n );\n }\n return null;\n}\n\ninterface Props {\n listings: Listing[];\n staff: boolean;\n onEdit: (l: Listing) => void;\n onDelete: (l: Listing) => void;\n onMarkVerified: (l: Listing) => void;\n}\n\nexport function ListingsTable({ listings, staff, onEdit, onDelete, onMarkVerified }: Props) {\n return (\n \n \n \n \n \n \n \n \n \n {staff && }\n \n \n \n {listings.map((l) => (\n \n \n \n \n \n \n \n {staff && (\n \n )}\n \n ))}\n \n

Property / Landlord	Location	Phone	Website	Notes	Contact verified	Actions
{l.name \|\| (no name)}	{l.location}	\n {telHref(l.phone)\n ? {l.phone}\n : l.phone}\n	\n \n	{l.notes}	{l.contact_updated}	\n \n \n \n

\n );\n}\n","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport type { Listing } from \"../types.ts\";\n\ntype SortKey = \"created_at\" | \"name\" | \"location\";\n\nfunction telHref(phone: string): string | null {\n const match = phone.match(/\$?\\d{3}\$?[-.\\s]?\\d{3}[-.\\s]?\\d{4}/);\n return match ? `tel:${match[0].replace(/\\D/g, \"\")}` : null;\n}\n\nfunction WebsiteCell({ listing }: { listing: Listing }) {\n if (listing.website) {\n const label = listing.website_label || new URL(listing.website).hostname;\n return (\n \n {label}\n \n );\n }\n if (listing.website_label) {\n // Legacy rows from the spreadsheet where only the link text survived:\n // link to a web search so the site is still one click away\n return (\n \n {listing.website_label}\n \n );\n }\n return null;\n}\n\nfunction SortHeader({\n label,\n sortKey,\n activeKey,\n sortDir,\n onSort,\n}: {\n label: string;\n sortKey: SortKey;\n activeKey: SortKey;\n sortDir: \"asc\" | \"desc\";\n onSort: (key: SortKey) => void;\n}) {\n const active = sortKey === activeKey;\n return (\n onSort(activeKey)}\n >\n {label}\n {active && {sortDir === \"asc\" ? \"↑\" : \"↓\"}}\n \n );\n}\n\ninterface Props {\n listings: Listing[];\n staff: boolean;\n sortKey: SortKey;\n sortDir: \"asc\" | \"desc\";\n onSort: (key: SortKey) => void;\n onEdit: (l: Listing) => void;\n onDelete: (l: Listing) => void;\n onMarkVerified: (l: Listing) => void;\n}\n\nexport function ListingsTable({\n listings,\n staff,\n sortKey,\n sortDir,\n onSort,\n onEdit,\n onDelete,\n onMarkVerified,\n}: Props) {\n return (\n \n \n \n \n \n \n \n \n \n \n {staff && }\n \n \n \n {listings.map((l) => (\n \n \n \n \n \n \n \n \n {staff && (\n \n )}\n \n ))}\n \n

Phone	Website	Notes	Contact verified	Actions
{l.name \|\| (no name)}	{l.location}	\n {telHref(l.phone)\n ? {l.phone}\n : l.phone}\n	\n \n	{l.notes}	{l.contact_updated}	{l.created_at}	\n \n \n \n

\n );\n}\n","createdAt",["D",1784739421499],"branchVersion","branchId","cb93a182-7d33-477a-951e-56f9a7b9bf82","id","6d79585e-4f87-4a0f-9f9e-e0782f6ee9c5","haven-housing-directory",["D",1783712246617],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Searchable rental directory for The Haven (Charlottesville)","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789567199&sig=be2da3e537d6269cefeedcb88843ac66f83d7a4623f50e71633938e44918ec3c","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","019f4d88-ebd3-7218-9092-185c08774ad1","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f4d98-342f-73e3-90b3-c7f210ff5067","tursoName","6d79585e4f874a0f9f9ee0782f6ee9c5","tursoHostname","6d79585e4f874a0f9f9ee0782f6ee9c5-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525245864],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_112":111,"_119":-5},"org",{"_112":111,"_113":114,"_115":-5,"_19":-5,"_116":117,"_118":67},"branch",{"_13":97,"_38":98,"_50":49,"_99":51,"_100":101,"_102":103,"_104":57,"_105":106,"_107":108,"_109":52,"_110":111},"isOwned",128,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",89,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","the_haven","handle","displayName","The Haven","avatar","tier","business","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_50":51,"_38":52,"_45":329,"_54":-5,"_55":31,"_56":57,"_58":57,"_59":60,"_61":62,"_19":63,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":71,"_72":73,"_74":75,"_76":77,"_78":330,"_80":-5,"_81":82,"_83":82,"_84":85,"_86":85,"_87":85,"_88":82,"_89":82,"_90":331,"_92":332,"_94":333,"_96":31},"tree",[207,212,221,222,223],"files",[207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223],"counts",{"_197":71,"_198":166,"_199":71,"_200":201,"_202":203},"contents",[155,156,157,158,159],"upstreamProject",{"_50":106,"_38":151,"_59":152,"_61":62,"_56":57,"_90":153},"upstreamBranch",{"_50":101,"_45":144,"_145":146,"_38":98,"_99":106,"_13":147,"_100":-5,"_102":-5,"_148":149,"_54":-5,"_96":31,"_56":57,"_110":150,"_72":108,"_109":151},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","Starter template with client-side React & Hono server",{"_112":150,"_119":154},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789567199&sig=d8af4f1d5d6ef07a152f6225f86a0227f22fe92650a7f9572d94a5f64256bba9",{"_50":192,"_38":193,"_36":194,"_162":-5,"_48":49,"_47":176,"_164":67,"_45":195,"_13":71,"_40":190,"_42":-5,"_30":31,"_169":-5,"_33":196},{"_50":186,"_38":187,"_36":188,"_162":-5,"_48":49,"_47":166,"_164":67,"_45":189,"_13":71,"_40":190,"_42":-5,"_30":31,"_169":-5,"_33":191},{"_50":179,"_38":180,"_36":181,"_162":-5,"_48":49,"_47":182,"_164":31,"_45":183,"_13":71,"_40":26,"_42":184,"_30":31,"_169":-5,"_33":185},{"_50":171,"_38":172,"_36":173,"_162":-5,"_48":49,"_47":174,"_164":67,"_45":175,"_13":176,"_40":26,"_42":177,"_30":31,"_169":-5,"_33":178},{"_50":160,"_38":161,"_36":65,"_162":-5,"_48":49,"_47":163,"_164":31,"_45":165,"_13":166,"_40":167,"_42":168,"_30":31,"_169":52,"_33":170},"d433612b-7cbf-48c9-8edb-c9fa70e34b79","index.ts","parentId",4,"latest",["D",1783712432496],1,"http","import { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport {\n createListing,\n deleteListing,\n ensureTableAndSeed,\n listListings,\n updateListing,\n} from \"./backend/db.ts\";\n\nawait ensureTableAndSeed();\n\nconst app = new Hono();\n\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.get(\"/api/listings\", async (c) => c.json(await listListings()));\n\n// Staff auth: shared password from the ADMIN_PASSWORD env var, sent as a header\nconst requireStaff = async (c: any, next: () => Promise) => {\n const password = Deno.env.get(\"ADMIN_PASSWORD\");\n if (!password || c.req.header(\"x-admin-password\") !== password) {\n return c.json({ error: \"Wrong password\" }, 401);\n }\n await next();\n};\n\napp.post(\"/api/login\", requireStaff, (c) => c.json({ ok: true }));\n\napp.post(\"/api/listings\", requireStaff, async (c) => {\n await createListing(await c.req.json());\n return c.json({ ok: true });\n});\n\napp.put(\"/api/listings/:id\", requireStaff, async (c) => {\n await updateListing(Number(c.req.param(\"id\")), await c.req.json());\n return c.json({ ok: true });\n});\n\napp.delete(\"/api/listings/:id\", requireStaff, async (c) => {\n await deleteListing(Number(c.req.param(\"id\")));\n return c.json({ ok: true });\n});\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[161],"f7550f94-d3cf-4a91-a523-4e6b6ce98e34","README.md","019f4d88-ebd3-7218-9092-1474528366c9",16,["D",1784738706111],2,"# Charlottesville Area Landlord Directory\n\nA searchable directory of rental properties, apartment complexes, and property\nmanagers, maintained by [The Haven](https://thehaven.org) to help clients find\nhousing. Replaces a manually-updated Excel spreadsheet.\n\n- **Browse**: anyone with the link can search, filter by area, and print.\n- **Edit**: staff sign in with a shared password (`ADMIN_PASSWORD` env var) to\n add, edit, delete, or mark a listing's contact info as verified today.\n\nData was imported from the \"Landlord Directory FY25\" spreadsheet in July 2026\nand lives in this val's SQLite database (`backend/db.ts`).\n\n## Automated Discovery\n\nA weekly cron job (`backend/cron.ts`, runs Mondays 9 AM UTC) uses OpenAI's web\nsearch to find new rental properties and property management companies in the\nCharlottesville area that aren't already in the directory. New finds are:\n\n1. Inserted into the database automatically.\n2. Tagged with \"AI-discovered — verify contact info\" in the notes field.\n3. Left for staff to review and verify contact details.\n\nThe discovery logic lives in `backend/discover.ts` and uses\n[`std/openai`](https://www.val.town/v/std/openai) with the Responses API,\nthe `web_search` tool, and structured outputs.\n",[172],"d7cc2c0b-6502-40e4-afd4-982cdd18cfab","AGENTS.md","d017a62a-85ec-11f1-ab6d-1607ee4eb77e",17,["D",1784738757506],"# Haven Landlord Directory — AGENTS.md\n\nSearchable rental property directory for The Haven (Charlottesville, VA nonprofit).\nReplaces a manually-maintained Excel spreadsheet. Staff can browse, search, and\nedit listings via a password-protected web UI.\n\n## File Map\n\n```\nindex.ts # HTTP entrypoint — Hono router, serves frontend + API\nbackend/\n db.ts # SQLite schema, CRUD functions, seed-on-first-run\n seed.ts # Initial 93 listings imported from FY25 spreadsheet\n discover.ts # AI discovery logic — OpenAI web_search + structured outputs\n cron.ts # Weekly interval — discovers new listings, inserts into DB\nfrontend/\n index.html # Static HTML shell (loads React bundle)\n index.tsx # React entrypoint\n types.ts # Listing / ListingInput TypeScript interfaces\n favicon.svg\n components/\n App.tsx # Root component — search, filter, auth state\n ListingsTable.tsx # Read-only table view with search & area filter\n ListingForm.tsx # Add/edit form (staff only)\n```\n\n## Architecture\n\n- **Backend**: Hono router in `index.ts` — serves static frontend files and a\n REST API (`/api/listings` CRUD). Staff auth via `x-admin-password` header\n checked against `ADMIN_PASSWORD` env var.\n- **Database**: Project-scoped SQLite (`listings_v1` table) accessed via\n `std/sqlite/main.ts`. Seeded from `backend/seed.ts` on first run.\n- **Frontend**: React SPA bundled in-browser, components in `frontend/components/`.\n- **Automated discovery**: Weekly cron (`backend/cron.ts`) uses `std/openai`\n Responses API with `web_search` tool and structured outputs to find new\n rental properties. New entries are tagged \"AI-discovered — verify contact info\".\n\n## Env Vars\n\n- `ADMIN_PASSWORD` — shared password for staff edit access\n",[180],"e500cffe-1cb9-4041-9dd5-9f74efd2410a","frontend","019f4d88-ebd3-7218-9092-104a308a0db8",["D",1783712246617],"directory",[187],"83688e9c-c04c-4cea-8600-2b3d4f973f05","backend","102650c1-16df-4425-91f4-ad09aa6fdd92",["D",1783712386625],[193],"pulls","branches","forks","envVars",{"_204":166,"_206":71},"connections",{"_204":71,"_205":71},"count","unfilledCount","emptyCount",{"_50":192,"_38":193,"_36":194,"_162":-5,"_48":49,"_47":176,"_164":67,"_45":326,"_13":71,"_40":190,"_42":-5,"_30":31,"_169":-5,"_225":327,"_33":328},{"_50":317,"_38":318,"_36":319,"_162":194,"_48":49,"_47":320,"_164":31,"_45":321,"_13":166,"_40":322,"_42":323,"_30":31,"_169":-5,"_225":324,"_33":325},{"_50":308,"_38":309,"_36":310,"_162":194,"_48":49,"_47":311,"_164":31,"_45":312,"_13":313,"_40":41,"_42":314,"_30":31,"_169":-5,"_225":315,"_33":316},{"_50":300,"_38":301,"_36":302,"_162":194,"_48":49,"_47":303,"_164":31,"_45":304,"_13":166,"_40":41,"_42":305,"_30":31,"_169":-5,"_225":306,"_33":307},{"_50":293,"_38":294,"_36":295,"_162":194,"_48":49,"_47":176,"_164":67,"_45":296,"_13":71,"_40":41,"_42":297,"_30":31,"_169":-5,"_225":298,"_33":299},{"_50":186,"_38":187,"_36":188,"_162":-5,"_48":49,"_47":166,"_164":67,"_45":290,"_13":71,"_40":190,"_42":-5,"_30":31,"_169":-5,"_225":291,"_33":292},{"_50":286,"_38":269,"_36":265,"_162":188,"_48":49,"_47":166,"_164":67,"_45":287,"_13":71,"_40":190,"_42":-5,"_30":31,"_169":-5,"_225":288,"_33":289},{"_50":278,"_38":279,"_36":280,"_162":265,"_48":49,"_47":281,"_164":31,"_45":282,"_13":163,"_40":41,"_42":283,"_30":31,"_169":-5,"_225":284,"_33":285},{"_50":270,"_38":271,"_36":272,"_162":265,"_48":49,"_47":273,"_164":31,"_45":274,"_13":71,"_40":41,"_42":275,"_30":31,"_169":-5,"_225":276,"_33":277},{"_50":264,"_38":39,"_36":37,"_162":265,"_48":49,"_47":14,"_164":31,"_45":266,"_13":166,"_40":41,"_42":44,"_30":31,"_169":-5,"_225":267,"_33":268},{"_50":257,"_38":258,"_36":259,"_162":188,"_48":49,"_47":166,"_164":67,"_45":260,"_13":71,"_40":26,"_42":261,"_30":31,"_169":-5,"_225":262,"_33":263},{"_50":249,"_38":250,"_36":251,"_162":188,"_48":49,"_47":252,"_164":31,"_45":253,"_13":166,"_40":26,"_42":254,"_30":31,"_169":-5,"_225":255,"_33":256},{"_50":242,"_38":243,"_36":244,"_162":188,"_48":49,"_47":166,"_164":67,"_45":245,"_13":71,"_40":41,"_42":246,"_30":31,"_169":-5,"_225":247,"_33":248},{"_50":234,"_38":235,"_36":236,"_162":188,"_48":49,"_47":237,"_164":31,"_45":238,"_13":166,"_40":41,"_42":239,"_30":31,"_169":-5,"_225":240,"_33":241},{"_50":179,"_38":180,"_36":181,"_162":-5,"_48":49,"_47":182,"_164":31,"_45":231,"_13":71,"_40":26,"_42":184,"_30":31,"_169":-5,"_225":232,"_33":233},{"_50":171,"_38":172,"_36":173,"_162":-5,"_48":49,"_47":174,"_164":67,"_45":228,"_13":176,"_40":26,"_42":177,"_30":31,"_169":-5,"_225":229,"_33":230},{"_50":160,"_38":161,"_36":65,"_162":-5,"_48":49,"_47":163,"_164":31,"_45":224,"_13":166,"_40":167,"_42":168,"_30":31,"_169":52,"_225":226,"_33":227},["D",1783712432496],"children",[],[161],["D",1784738706111],[],[172],["D",1784738757506],[],[180],"40e0bfb1-a5cf-4ffc-8179-58cf89adfa8b","types.ts","d290824a-7c97-11f1-a7f6-1607ee4eb77e",22,["D",1784739369762],"export interface Listing {\n id: number;\n location: string;\n name: string;\n phone: string;\n website: string;\n website_label: string;\n notes: string;\n contact_updated: string;\n created_at: string;\n updated_at: string;\n}\n\nexport type ListingInput = Omit;\n\nexport const emptyListing: ListingInput = {\n location: \"\",\n name: \"\",\n phone: \"\",\n website: \"\",\n website_label: \"\",\n notes: \"\",\n contact_updated: \"\",\n};\n",[],[187,235],"e59f18ed-e3f3-4ac7-8c1f-26dc148fb4f8","index.tsx","019f4d88-ebd3-7218-9092-0cf3304a67d4",["D",1783712246617],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[187,243],"0d5d47d0-16ea-464b-8e47-a5b76e805f6b","index.html","019f4d88-ebd3-7218-9092-0bf6e7622fee",10,["D",1783712763233],"\n\n \n \n \n Charlottesville Area Landlord Directory\n \n \n \n \n

\n \n \n \n\n",[],[187,250],"dcdea6f9-7810-432f-9ba2-4cc857d89a29","favicon.svg","019f4d88-ebd3-7218-9092-072314b1de7e",["D",1783712246617],"\n",[],[187,258],"b4516edb-6933-4440-a92c-f65477a17c41","019f4d88-ebd3-7218-9092-021606bdd3ce",["D",1784739421499],[],[187,269,39],"components","cf4e1a3f-5c2c-4a58-93e8-e2d4b99e7600","ListingForm.tsx","e7ba4d72-7c97-11f1-9fef-1607ee4eb77e",7,["D",1783712729449],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { ListingInput } from \"../types.ts\";\n\ninterface Props {\n initial: ListingInput;\n title: string;\n onSave: (input: ListingInput) => Promise;\n onCancel: () => void;\n}\n\nconst inputClass = \"border border-gray-300 rounded px-2 py-1 w-full\";\n\nexport function ListingForm({ initial, title, onSave, onCancel }: Props) {\n const [form, setForm] = useState(initial);\n const [saving, setSaving] = useState(false);\n\n const field = (label: string, key: keyof ListingInput, placeholder = \"\") => (\n \n {label}\n setForm({ ...form, [key]: e.target.value })}\n />\n \n );\n\n return (\n {\n e.preventDefault();\n setSaving(true);\n try {\n await onSave(form);\n } finally {\n setSaving(false);\n }\n }}\n >\n

{title}

\n {field(\"Property / Landlord name\", \"name\")}\n {field(\"Location\", \"location\", \"e.g. Charlottesville, Albemarle\")}\n {field(\"Phone\", \"phone\")}\n {field(\"Website URL\", \"website\", \"https://…\")}\n {field(\"Website label (text to show)\", \"website_label\")}\n {field(\"Notes\", \"notes\", \"e.g. Apartment complex, shared kitchen\")}\n {field(\"Contact verified (date)\", \"contact_updated\", \"e.g. 7/10/2026\")}\n

\n \n {saving ? \"Saving…\" : \"Save\"}\n \n \n

\n \n );\n}\n",[],[187,269,271],"bda97609-d683-43cf-a470-6fe36f94731c","App.tsx","019f4d88-ebd3-7218-9091-fa024ee09187",26,["D",1784739402203],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useMemo, useState } from \"https://esm.sh/react@18.2.0\";\nimport { emptyListing, type Listing, type ListingInput } from \"../types.ts\";\nimport { ListingForm } from \"./ListingForm.tsx\";\nimport { ListingsTable } from \"./ListingsTable.tsx\";\n\nconst AREAS = [\n \"Charlottesville\",\n \"Albemarle\",\n \"Louisa\",\n \"Greene\",\n \"Orange\",\n \"Nelson\",\n \"Fluvanna\",\n \"Culpeper\",\n \"Waynesboro\",\n];\n\nexport function App() {\n const [listings, setListings] = useState([]);\n const [loading, setLoading] = useState(true);\n const [query, setQuery] = useState(\"\");\n const [area, setArea] = useState(\"\");\n const [sortKey, setSortKey] = useState<\"created_at\" | \"name\" | \"location\">(\"created_at\");\n const [sortDir, setSortDir] = useState<\"asc\" | \"desc\">(\"desc\");\n const [password, setPassword] = useState(localStorage.getItem(\"staffPassword\") ?? \"\");\n const [editing, setEditing] = useState(null);\n\n const staff = password !== \"\";\n\n async function refresh() {\n const res = await fetch(\"/api/listings\");\n setListings(await res.json());\n setLoading(false);\n }\n useEffect(() => {\n refresh();\n }, []);\n\n const filtered = useMemo(() => {\n const q = query.trim().toLowerCase();\n const result = listings.filter((l) => {\n if (area && !l.location.toLowerCase().includes(area.toLowerCase())) return false;\n if (!q) return true;\n return [l.name, l.location, l.phone, l.notes, l.website_label, l.website]\n .join(\" \")\n .toLowerCase()\n .includes(q);\n });\n const dir = sortDir === \"asc\" ? 1 : -1;\n return result.sort((a, b) => {\n const av = (a[sortKey] || \"\").toString().toLowerCase();\n const bv = (b[sortKey] || \"\").toString().toLowerCase();\n if (av < bv) return -1 * dir;\n if (av > bv) return 1 * dir;\n return 0;\n });\n }, [listings, query, area, sortKey, sortDir]);\n\n function onSort(key: \"created_at\" | \"name\" | \"location\") {\n if (sortKey === key) {\n setSortDir((d) => d === \"asc\" ? \"desc\" : \"asc\");\n } else {\n setSortKey(key);\n setSortDir(key === \"created_at\" ? \"desc\" : \"asc\");\n }\n }\n\n async function signIn() {\n const attempt = prompt(\"Staff password:\");\n if (!attempt) return;\n const res = await fetch(\"/api/login\", {\n method: \"POST\",\n headers: { \"x-admin-password\": attempt },\n });\n if (res.ok) {\n localStorage.setItem(\"staffPassword\", attempt);\n setPassword(attempt);\n } else {\n alert(\"Wrong password\");\n }\n }\n\n function signOut() {\n localStorage.removeItem(\"staffPassword\");\n setPassword(\"\");\n setEditing(null);\n }\n\n async function apiWrite(method: string, path: string, body?: ListingInput) {\n const res = await fetch(path, {\n method,\n headers: { \"x-admin-password\": password, \"content-type\": \"application/json\" },\n body: body ? JSON.stringify(body) : undefined,\n });\n if (!res.ok) {\n alert(`Save failed (${res.status}). If you were signed in a while ago, sign in again.`);\n return false;\n }\n await refresh();\n return true;\n }\n\n async function save(input: ListingInput) {\n const ok = editing === \"new\"\n ? await apiWrite(\"POST\", \"/api/listings\", input)\n : await apiWrite(\"PUT\", `/api/listings/${(editing as Listing).id}`, input);\n if (ok) setEditing(null);\n }\n\n async function remove(l: Listing) {\n if (!confirm(`Delete \"${l.name || l.phone}\"?`)) return;\n await apiWrite(\"DELETE\", `/api/listings/${l.id}`);\n }\n\n async function markVerified(l: Listing) {\n const today = new Date().toLocaleDateString(\"en-US\");\n await apiWrite(\"PUT\", `/api/listings/${l.id}`, { ...l, contact_updated: today });\n }\n\n return (\n

Charlottesville Area Landlord Directory

\n Rental properties, apartment complexes, and property managers — maintained by{\" \"}\n The Haven.\n

\n\n

\n setQuery(e.target.value)}\n />\n setArea(e.target.value)}\n >\n \n {AREAS.map((a) => )}\n \n \n {filtered.length} of {listings.length} listings\n \n {staff\n ? (\n <>\n setEditing(\"new\")}\n className=\"bg-blue-700 text-white rounded px-3 py-1.5\"\n >\n + Add listing\n \n \n \n )\n : }\n

\n\n {editing && (\n setEditing(null)}\n />\n )}\n\n {loading ?

Loading…

: (\n \n )}\n\n \n

\n );\n}\n",[],[187,269,279],"ae887443-2e14-4b3e-9163-23d32458cece",["D",1783712246617],[214,215,216],[187,269],["D",1783712246617],[213,217,218,219,220],[187],"b5fa7834-3e4a-4260-a261-7e1c83d58b2d","seed.ts","1b60461e-7c97-11f1-9075-1607ee4eb77e",["D",1783712386625],"// Initial data imported from The Haven's \"Landlord Directory FY25\" Google Sheet\n// (Properties and Property Mgt Companies List tab), July 2026.\n// website: real URL when the sheet had one; websiteLabel: hyperlink text whose\n// URL wasn't recoverable from the export; notes: descriptor text from the sheet.\n\nexport interface SeedListing {\n location: string;\n name: string;\n phone: string;\n website?: string;\n websiteLabel?: string;\n notes?: string;\n}\n\nexport const seedListings: SeedListing[] = [\n { location: \"Albemarle\", name: \"1st Dominon Realty - Various Properties\", phone: \"434-531-6688\", website: \"https://1stdominionrealty.com\" },\n { location: \"Albemarle\", name: \"Access Properties - Various Properties\", phone: \"(434) 296-7227\", websiteLabel: \"Explore Our Properties - Access Properties LLC\" },\n { location: \"Charlottesville/Albemarle\", name: \"Ally Properties - Various Properties\", phone: \"434-207-6557\", website: \"https://www.yourallypm.com\" },\n { location: \"Albemarle\", name: \"Wilton Farm Apartments\", phone: \"434-295-7368\", websiteLabel: \"Wilton Farm Apartments\" },\n { location: \"Albemarle\", name: \"Rio Hill Apartments\", phone: \"434-974-6377\", websiteLabel: \"Rio Hill Apartments\" },\n { location: \"Albemarle\", name: \"Spark Charlottesville\", phone: \"434-973-6432\", websiteLabel: \"Spark Charlottesville Apartments\" },\n { location: \"Albemarle\", name: \"Barracks West Apartments\", phone: \"434-542-8052\", websiteLabel: \"Barracks West\" },\n { location: \"Albemarle\", name: \"Braden Property Management - Various Properties\", phone: \"434-973-3003\", websiteLabel: \"Braden Property Management\" },\n { location: \"Charlottesville\", name: \"Carratt Apartments\", phone: \"434-979-7307\", websiteLabel: \"Carratt Apartments - Charlottesville\" },\n { location: \"Albemarle\", name: \"Cobalt Ridge\", phone: \"434-973-3620\", websiteLabel: \"Cobalt Ridge\" },\n { location: \"Charlottesville\", name: \"Carlton View Apartments\", phone: \"434-422-2110\", websiteLabel: \"Carlton Views\" },\n { location: \"Charlottesville\", name: \"Greenstone on 5th\", phone: \"434-295-3094\", websiteLabel: \"Greenstone on 5th Apartments | Community Housing Partners\" },\n { location: \"Orange\", name: \"Spicers Mill Apartments\", phone: \"540-672-3250\", websiteLabel: \"Community Housing Partners\" },\n { location: \"Charlottesville\", name: \"Community Service Housing - Various Properties\", phone: \"434-978-2007\", websiteLabel: \"Community Services Housing, Inc\" },\n { location: \"Charlottesville City, Albemarle County, Scottsville and Nelson County\", name: \"Various Properties (Piedmont Housing Alliance)\", phone: \"\", websiteLabel: \"Our Communities - Piedmont Housing Alliance\", notes: \"View website for contact information\" },\n { location: \"Charlottesville\", name: \"Spruce Street Group Home\", phone: \"434-971-2525\", websiteLabel: \"Community Services Housing, Inc\" },\n { location: \"Louisa\", name: \"Waverly Place\", phone: \"540-603-2477\", websiteLabel: \"Waverly Place - Louisa\" },\n { location: \"Charlottesville\", name: \"D.M. Rothwell - Various Properties\", phone: \"434-977-7676\", websiteLabel: \"D.M. Rothwell, Inc\" },\n { location: \"Charlottesville, Crozet and Lexington\", name: \"BMC Property Management - Various Properties\", phone: \"434-977-6400\", websiteLabel: \"BMC Property Management\" },\n { location: \"Charlottesville City/Albemarle County\", name: \"BlueSky Property Management - Various Properties\", phone: \"434-295-4663\", websiteLabel: \"BlueSky Property Management\" },\n { location: \"Charlottesville, Albemarle and Harrisonburg\", name: \"Barclay Place, Tarleton Square, WestGate Apartments, Solomon Court Apartments, Charlottesville Towers, Residence at 218 and Park Apartments (Harrisonburg)\", phone: \"434-296-4141\", website: \"https://www.gemc.com/residential.cfm\" },\n { location: \"Louisa\", name: \"Pine Ridge Apartments\", phone: \"540-967-9657\", notes: \"Website unavailable\" },\n { location: \"Albemarle\", name: \"Timberland Park Apartments\", phone: \"434-956-4784\", websiteLabel: \"Timberland Park | Apartments in Charlottesville, VA\" },\n { location: \"Nelson\", name: \"Lovingston Ridge Apartments\", phone: \"(434) 263-7724\", notes: \"Website unavailable\" },\n { location: \"Charlottesville and Albemarle\", name: \"Godfrey Property Management - Various Properties\", phone: \"434-979-8155\", websiteLabel: \"Godfrey Property Management\" },\n { location: \"Charlottesville\", name: \"Ephphatha Village Apartments\", phone: \"434-202-2265\", websiteLabel: \"Ephphatha Village Apartments | Community Housing Partners\" },\n { location: \"Albemarle\", name: \"Southwood\", phone: \"434-293-9066\", websiteLabel: \"Southwood Community | Find your Home\" },\n { location: \"Albemarle\", name: \"Hearthwood Apartments\", phone: \"434-260-1903\", websiteLabel: \"Hearthwood Apartments\" },\n { location: \"Louisa\", name: \"Club Hill Apartments\", phone: \"540-967-0965\", notes: \"Website unavailable\" },\n { location: \"Culpeper\", name: \"JHP Rental Properties - Various Properties\", phone: \"540-967-2641\", websiteLabel: \"Rental\" },\n { location: \"Orange\", name: \"Round Hill Meadows\", phone: \"540-672-4827\", websiteLabel: \"Round Hill Meadows\" },\n { location: \"Charlottesville and Albemarle\", name: \"Knight Realty and Investments - Various Properties\", phone: \"(434) 981-3919\", notes: \"Website unavailable\" },\n { location: \"Albemarle\", name: \"Berkshire and Barter Court Apts.\", phone: \"434-270-7771\", websiteLabel: \"Berkshire and Barter Court Apartments\" },\n { location: \"Albemarle\", name: \"The Meadows Apartments\", phone: \"434-328-5268\", website: \"https://www.themeadows-online.com/\" },\n { location: \"Greene\", name: \"Lily Ridge Apartments\", phone: \"(434) 939-9197\", websiteLabel: \"Lily Ridge\" },\n { location: \"Louisa\", name: \"Lloyd's Real Estate - Various Properties\", phone: \"540-967-0168\", websiteLabel: \"Lloyd's Real Estate\" },\n { location: \"Charlottesville\", name: \"MSC - Various Properties\", phone: \"434-423-5400\", websiteLabel: \"MSC UVA\" },\n { location: \"Charlottesville\", name: \"Midway Manor\", phone: \"434-971-6770\", website: \"https://midwaymanorapts.com/\" },\n { location: \"Charlottesville, Albemarle, Amherst and Orange\", name: \"Montague Miller and Co. - Various Properties\", phone: \"434-973-5393\", website: \"https://www.montaguemiller.com/results/?property_category=5&cidonly=1\" },\n { location: \"Charlottesville\", name: \"Nest Realty - Various Properties\", phone: \"434-566-0121\", websiteLabel: \"Nest Realty\" },\n { location: \"Charlottesville\", name: \"New House Company\", phone: \"434-978-7900\", websiteLabel: \"The New House Company\" },\n { location: \"Albemarle\", name: \"Brookdale Apartments\", phone: \"434-282-4986\", website: \"https://www.brookdalecville.com/\" },\n { location: \"Albemarle\", name: \"Treesdale Apartments\", phone: \"434-971-7368\", websiteLabel: \"Treesdale Apartments\" },\n { location: \"Various in Virginia\", name: \"Ruckersville Mobile Home Community\", phone: \"434-760-1994\", websiteLabel: \"Roseland Communities\" },\n { location: \"\", name: \"\", phone: \"434-465-8461\" },\n { location: \"Charlottesville\", name: \"\", phone: \"434-326-4786\", notes: \"Apartment Complex\" },\n { location: \"Charlottesville\", name: \"Mews on Little High\", phone: \"434-286-3792\", notes: \"Complex\" },\n { location: \"Albemarle\", name: \"Private units in Eagle's Landing\", phone: \"434-234-3813\", notes: \"Shared\" },\n { location: \"Albemarle\", name: \"Various Properties\", phone: \"434-971-1600 x295\", notes: \"Various\" },\n { location: \"Charlottesville\", name: \"The Gleason\", phone: \"434-202-1852\", notes: \"Agent\" },\n { location: \"\", name: \"University Forum\", phone: \"434-971-1600\" },\n { location: \"Charlottesville\", name: \"Various Properties\", phone: \"434-989-2121\", notes: \"Various\" },\n { location: \"\", name: \"Various Properties\", phone: \"434-951-5155\" },\n { location: \"Charlottesville\", name: \"\", phone: \"434-760-0659\" },\n { location: \"Charlottesville\", name: \"Cavalier Court Apartments\", phone: \"434-979-7307\", notes: \"Apartment Complex\" },\n { location: \"Charlottesville\", name: \"Shamrock Gardens Apartments\", phone: \"434-979-7307\", notes: \"Apartment Complex\" },\n { location: \"Charlottesville\", name: \"\", phone: \"434-979-7307\" },\n { location: \"\", name: \"\", phone: \"434-529-0471\" },\n { location: \"\", name: \"\", phone: \"757-617-3158\" },\n { location: \"Greene\", name: \"Jack Russell Apartments\", phone: \"540-948-3916\" },\n { location: \"Greene\", name: \"Skyline Apartments\", phone: \"540-948-3916\" },\n { location: \"Fluvanna\", name: \"Various Properties\", phone: \"434-245-0894\" },\n { location: \"Lake Monticello\", name: \"Various Properties\", phone: \"434-589-4507\" },\n { location: \"\", name: \"\", phone: \"434-326-2460\" },\n { location: \"Orange\", name: \"Meadow Run Apartments\", phone: \"540-832-5350\", notes: \"Complex\" },\n { location: \"Albemarle\", name: \"Turtle Creek Condos\", phone: \"434-295-4663\" },\n { location: \"Charlottesville\", name: \"Grand Marc\", phone: \"434-293-5358\", notes: \"Apartment Building\" },\n { location: \"Charlottesville/Albemarle County\", name: \"Wade Property Management - Various Properties\", phone: \"434-973-3294\", websiteLabel: \"Wade Rentals in Charlottesville, VA\" },\n { location: \"Charlottesville\", name: \"100 West South Street\", phone: \"434-971-8860\", notes: \"Apartment with shared kitchen\" },\n { location: \"Charlottesville\", name: \"Camden Plaza\", phone: \"434-971-8860\" },\n { location: \"Charlottesville\", name: \"Comyn Hall\", phone: \"434-971-8860\", notes: \"Apartment in House\" },\n { location: \"Charlottesville\", name: \"\", phone: \"434-971-8860\", notes: \"House with apartments\" },\n { location: \"Albemarle\", name: \"Arbor Crest\", phone: \"855-901-1116\" },\n { location: \"Orange\", name: \"Bellview Senior Apartments\", phone: \"(540) 661-3300\" },\n { location: \"Waynesboro\", name: \"Brandon Ladd Apartments\", phone: \"540-949-5000\" },\n { location: \"Albemarle\", name: \"Carriage Hill\", phone: \"434-971-8439\" },\n { location: \"Charlottesville\", name: \"Cavalier Crossing\", phone: \"434-363-9889\" },\n { location: \"Charlottesville\", name: \"Claremont at Carriage Hill\", phone: \"434-989-1559\" },\n { location: \"\", name: \"Eagle's Landing\", phone: \"434-984-5808\" },\n { location: \"Louisa/Gordonsville\", name: \"Eastgate Apartments\", phone: \"540-832-5837\" },\n { location: \"Albemarle\", name: \"Eastham Village\", phone: \"434-977-2650\" },\n { location: \"Charlottesville City/Albemarle County\", name: \"Various Properties (MSC)\", phone: \"434-423-5400\", websiteLabel: \"MSC UVA\" },\n { location: \"Louisa\", name: \"Epworth Manor Apartments\", phone: \"540-967-1696\", website: \"https://epworthmanorapartments.com\" },\n { location: \"Albemarle\", name: \"Fountain Court\", phone: \"434-977-2650\", websiteLabel: \"Fountain Court Apartments\" },\n { location: \"Charlottesville\", name: \"Ivy Gardens\", phone: \"434-220-6650\", websiteLabel: \"Ivy Garden Apartments\" },\n { location: \"Charlottesville\", name: \"Jeffersonian Apartments\", phone: \"434-977-3070 or 833-698-1081\", website: \"https://www.thejeffersonianapts.com\" },\n { location: \"Albemarle\", name: \"Mallside Forest Apartments\", phone: \"434-424-0371\", websiteLabel: \"Security Properties\" },\n { location: \"Albemarle\", name: \"North Woods at the Four Seasons\", phone: \"434-688-4966\", website: \"https://www.livewithnorthwoods.com\" },\n { location: \"Albemarle\", name: \"Park View at South Pantops\", phone: \"434-923-0200\", website: \"https://southpantops.enterpriseresidential.org\" },\n { location: \"Charlottesville\", name: \"The Crossings and Fourth and Preston\", phone: \"434-227-4251\", websiteLabel: \"Communities We Serve | SupportWorks Housing\" },\n { location: \"Charlottesville\", name: \"The Flats @ West Village\", phone: \"844-236-1118\", website: \"https://www.flatsatwestvillage.com\" },\n { location: \"Albemarle\", name: \"University Heights Apartments\", phone: \"434-326-1337\", website: \"https://www.uheights.net\" },\n { location: \"Albemarle\", name: \"Woodlands of Charlottesville\", phone: \"434-421-3191\", website: \"https://www.woodlandsofcharlottesville.com\" },\n];\n",[],[193,294],"bbb2850c-428e-43ea-9b40-5a23b66d1238","discover.ts","8dc14ce0-85ec-11f1-a849-1607ee4eb77e",23,["D",1784739385811],"import { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\nimport type { Listing } from \"./db.ts\";\n\nexport interface DiscoveredListing {\n name: string;\n location: string;\n phone: string;\n website: string;\n notes: string;\n}\n\n/**\n * Build the system instructions that tell the model what we're looking for\n * and what's already in the directory so it doesn't duplicate.\n */\nfunction buildInstructions(existing: Listing[]): string {\n const names = existing\n .filter((l) => l.name.trim())\n .map((l) => `- ${l.name} (${l.location})`)\n .join(\"\\n\");\n\n const phones = existing\n .filter((l) => l.phone.trim())\n .map((l) => l.phone)\n .join(\", \");\n\n return `You are a housing researcher for The Haven, a nonprofit in Charlottesville, Virginia that helps clients find rental housing.\n\nYour job: search the web for rental properties, apartment complexes, and property management companies in the Charlottesville, VA region and nearby counties that are NOT already in our directory.\n\nTarget areas: Charlottesville, Albemarle County, Crozet, Louisa, Gordonsville, Orange, Greene, Fluvanna, Lake Monticello, Nelson, Lovingston, Waynesboro, Staunton, Culpeper, Ruckersville, Scottsville, and Harrisonburg.\n\nFor each new property or company you find, provide:\n- name: The name of the apartment complex or property management company\n- location: The city or county area (e.g. \"Charlottesville\", \"Albemarle\", \"Louisa\")\n- phone: A phone number with area code (e.g. \"434-555-1234\"). Use empty string if you can't find one.\n- website: The full URL (e.g. \"https://example.com\"). Use empty string if you can't find one.\n- notes: A brief description (e.g. \"Apartment complex\", \"Property management company\", \"Senior housing\"). Use empty string if nothing notable.\n\nRules:\n1. Only include properties you actually found via web search — do not make things up.\n2. CRITICAL — Do not return any property that is already in our directory. This includes near-matches:\n - \"The Flats @ West Village\" and \"The Flats at West Village\" are the SAME property\n - \"Carlton View Apartments\" and \"Carlton Views Apartments\" are the SAME property\n - \"Montague Miller & Co.\" and \"Montague Miller and Co.\" are the SAME company\n - Punctuation differences (@ vs at, & vs and), plural vs singular, and minor word variations are NOT different properties\n - When in doubt, skip it — it's better to miss one than to create a duplicate\n3. Do NOT include any property whose phone number matches an existing listing (compare digits only).\n4. Aim for 5-15 genuinely new listings. If you can't find that many new ones, return fewer — quality over quantity.\n5. Skip national listing sites (Zillow, Apartments.com, Trulia, etc.) — we want the actual property or management company.\n\nEXISTING LISTINGS (do not duplicate any of these, including near-matches):\n${names}\n\nEXISTING PHONE NUMBERS: ${phones}`;\n}\n\nconst SCHEMA = {\n type: \"object\",\n properties: {\n new_listings: {\n type: \"array\",\n items: {\n type: \"object\",\n properties: {\n name: { type: \"string\" },\n location: { type: \"string\" },\n phone: { type: \"string\" },\n website: { type: \"string\" },\n notes: { type: \"string\" },\n },\n required: [\"name\", \"location\", \"phone\", \"website\", \"notes\"],\n additionalProperties: false,\n },\n },\n },\n required: [\"new_listings\"],\n additionalProperties: false,\n} as const;\n\n/**\n * Calls OpenAI with web_search + structured outputs to discover new rental\n * listings not already in the directory.\n */\nexport async function discoverNewListings(\n existing: Listing[],\n): Promise {\n const openai = new ValTownOpenAI({});\n\n const response = await openai.responses.create({\n model: \"gpt-5.4-nano\",\n tools: [{ type: \"web_search\" }],\n instructions: buildInstructions(existing),\n input:\n \"Search the web for apartment complexes and property management companies in the Charlottesville, Virginia area that accept rentals. Find ones NOT already in our existing list above. Return up to 15 new listings.\",\n text: {\n format: {\n type: \"json_schema\",\n name: \"new_rental_listings\",\n schema: SCHEMA,\n },\n },\n });\n\n const parsed = JSON.parse(response.output_text) as {\n new_listings: DiscoveredListing[];\n };\n\n return parsed.new_listings;\n}\n\n/**\n * Deduplicate discovered listings against existing ones by name (case-insensitive)\n * or phone number. Also removes entries with empty names.\n */\nexport function filterNew(\n discovered: DiscoveredListing[],\n existing: Listing[],\n): DiscoveredListing[] {\n const existingNames = new Set(\n existing.map((l) => l.name.trim().toLowerCase()).filter(Boolean),\n );\n const existingPhones = new Set(\n existing.map((l) => l.phone.replace(/\\D/g, \"\")).filter(Boolean),\n );\n\n return discovered.filter((d) => {\n if (!d.name.trim()) return false;\n if (existingNames.has(d.name.trim().toLowerCase())) return false;\n const phoneDigits = d.phone.replace(/\\D/g, \"\");\n if (phoneDigits && existingPhones.has(phoneDigits)) return false;\n return true;\n });\n}\n",[],[193,301],"f7d7f36b-b947-44b9-80c9-351ef36f7f9f","db.ts","2c1523d0-7c97-11f1-83ac-1607ee4eb77e",21,["D",1784739362631],5,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { seedListings } from \"./seed.ts\";\n\nconst TABLE = \"listings_v1\";\n\nexport interface Listing {\n id: number;\n location: string;\n name: string;\n phone: string;\n website: string;\n website_label: string;\n notes: string;\n contact_updated: string;\n created_at: string;\n updated_at: string;\n}\n\nexport async function ensureTableAndSeed() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n location TEXT NOT NULL DEFAULT '',\n name TEXT NOT NULL DEFAULT '',\n phone TEXT NOT NULL DEFAULT '',\n website TEXT NOT NULL DEFAULT '',\n website_label TEXT NOT NULL DEFAULT '',\n notes TEXT NOT NULL DEFAULT '',\n contact_updated TEXT NOT NULL DEFAULT '',\n created_at TEXT NOT NULL DEFAULT (date('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`);\n const count = await sqlite.execute(`SELECT COUNT(*) AS n FROM ${TABLE}`);\n if (Number((count.rows[0] as { n: number }).n) > 0) return;\n for (const l of seedListings) {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (location, name, phone, website, website_label, notes)\n VALUES (?, ?, ?, ?, ?, ?)`,\n args: [l.location, l.name, l.phone, l.website ?? \"\", l.websiteLabel ?? \"\", l.notes ?? \"\"],\n });\n }\n}\n\nconst COLS = \"id, location, name, phone, website, website_label, notes, contact_updated, created_at, updated_at\";\n\nexport async function listListings(): Promise {\n const result = await sqlite.execute(\n `SELECT ${COLS} FROM ${TABLE} ORDER BY created_at DESC, CASE WHEN name = '' THEN 1 ELSE 0 END, name COLLATE NOCASE`,\n );\n return result.rows as unknown as Listing[];\n}\n\nexport type ListingInput = Omit;\n\nexport async function createListing(input: ListingInput): Promise {\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE} (location, name, phone, website, website_label, notes, contact_updated)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [\n input.location ?? \"\",\n input.name ?? \"\",\n input.phone ?? \"\",\n input.website ?? \"\",\n input.website_label ?? \"\",\n input.notes ?? \"\",\n input.contact_updated ?? \"\",\n ],\n });\n}\n\nexport async function updateListing(id: number, input: ListingInput): Promise {\n await sqlite.execute({\n sql: `UPDATE ${TABLE}\n SET location = ?, name = ?, phone = ?, website = ?, website_label = ?, notes = ?,\n contact_updated = ?, updated_at = datetime('now')\n WHERE id = ?`,\n args: [\n input.location ?? \"\",\n input.name ?? \"\",\n input.phone ?? \"\",\n input.website ?? \"\",\n input.website_label ?? \"\",\n input.notes ?? \"\",\n input.contact_updated ?? \"\",\n id,\n ],\n });\n}\n\nexport async function deleteListing(id: number): Promise {\n await sqlite.execute({ sql: `DELETE FROM ${TABLE} WHERE id = ?`, args: [id] });\n}\n",[],[193,309],"3dd8122b-7e63-4674-b9a9-3631245813fc","cron.ts","9124a6e8-85ec-11f1-9db7-1607ee4eb77e",15,["D",1784738659416],"interval","import {\n ensureTableAndSeed,\n listListings,\n createListing,\n} from \"./db.ts\";\nimport { discoverNewListings, filterNew } from \"./discover.ts\";\n\n/**\n * Weekly cron job: uses OpenAI web search to discover new rental properties\n * and property management companies in the Charlottesville, VA area that aren't\n * already in the directory. New finds are inserted into the database with a\n * \"AI-discovered — verify contact info\" note so staff can review them.\n */\nexport default async function (interval: Interval) {\n await ensureTableAndSeed();\n\n const existing = await listListings();\n console.log(`Existing listings: ${existing.length}`);\n\n console.log(\"Searching the web for new rental listings...\");\n const discovered = await discoverNewListings(existing);\n console.log(`AI returned ${discovered.length} candidate listings`);\n\n const fresh = filterNew(discovered, existing);\n console.log(\n `After dedup: ${fresh.length} new listings to add`,\n );\n\n if (fresh.length === 0) {\n console.log(\"No new listings found this run.\");\n return;\n }\n\n const today = new Date().toISOString().slice(0, 10);\n let added = 0;\n for (const l of fresh) {\n await createListing({\n location: l.location,\n name: l.name,\n phone: l.phone,\n website: l.website,\n website_label: l.website ? l.name : \"\",\n notes: l.notes\n ? `${l.notes} — AI-discovered ${today}, verify contact info`\n : `AI-discovered ${today}, verify contact info`,\n contact_updated: \"\",\n });\n added++;\n console.log(` + ${l.name} (${l.location}) — ${l.phone}`);\n }\n\n console.log(`Done. Added ${added} new listings.`);\n}\n",[],[193,318],["D",1783712386625],[208,209,210,211],[193],["D",1783712246617],["D",1789525245864],{"_112":111,"_119":-5},{"_112":111,"_113":114,"_115":-5,"_19":-5,"_116":117,"_118":67},{"_13":97,"_38":98,"_50":49,"_99":51,"_100":101,"_102":103,"_104":57,"_105":106,"_107":108,"_109":52,"_110":111},"ctx",{"_90":-5,"_141":367,"_368":369,"_370":371,"_372":31,"_373":31,"_374":31,"_375":67,"_376":-5,"_377":-7,"_378":-7,"_379":71,"_380":31,"_381":31,"_382":-5,"_383":31,"_384":31,"_385":31,"_386":-5},"ENV",{"_338":339,"_340":341,"_342":98,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v27