[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_297":298,"_299":300},"routes/_app.x.$handle.$name",{"_105":104,"_32":45,"_113":91,"_27":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_20":-5,"_125":126,"_127":128,"_129":49,"_130":131,"_132":25,"_133":-5,"_134":-5,"_135":136},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":49},"version",9,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",true,"deletedHere","path","frontend/components/Counter.tsx","latestPath","fileId","019f4d88-ebd3-7218-9091-fdebced2e420","name","Counter.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function Counter() {\n const [count, setCount] = useState(0);\n return (\n

\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n","createdAt",["D",1783712761138],"branchVersion","branchId","cb93a182-7d33-477a-951e-56f9a7b9bf82","id","6d79585e-4f87-4a0f-9f9e-e0782f6ee9c5","haven-housing-directory",["D",1783712246617],"deletedAt","legacyEnvVars",false,"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","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",{"_105":104,"_112":-5},"org",{"_105":104,"_106":107,"_108":-5,"_18":-5,"_109":110,"_111":25},"branch",{"_13":90,"_32":91,"_43":42,"_92":44,"_93":94,"_95":96,"_97":51,"_98":99,"_100":101,"_102":45,"_103":104},"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",{"_43":44,"_32":45,"_38":292,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":293,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":294,"_85":295,"_87":296,"_89":49},"tree",[191,194,203,204],"files",[191,192,193,194,195,196,197,198,199,200,201,202,203,204],"counts",{"_181":64,"_182":158,"_183":64,"_184":185,"_186":187},"contents",[148,149,150,151],"upstreamProject",{"_43":99,"_32":144,"_53":145,"_55":56,"_50":51,"_83":146},"upstreamBranch",{"_43":94,"_38":137,"_138":139,"_32":91,"_92":99,"_13":140,"_93":-5,"_95":-5,"_141":142,"_47":-5,"_89":49,"_50":51,"_103":143,"_65":101,"_102":144},"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",{"_105":143,"_112":147},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789567199&sig=d8af4f1d5d6ef07a152f6225f86a0227f22fe92650a7f9572d94a5f64256bba9",{"_43":175,"_32":176,"_30":177,"_154":-5,"_41":42,"_40":178,"_156":25,"_38":179,"_13":64,"_34":173,"_36":-5,"_24":49,"_161":-5,"_27":180},{"_43":169,"_32":170,"_30":171,"_154":-5,"_41":42,"_40":158,"_156":25,"_38":172,"_13":64,"_34":173,"_36":-5,"_24":49,"_161":-5,"_27":174},{"_43":163,"_32":164,"_30":165,"_154":-5,"_41":42,"_40":158,"_156":49,"_38":166,"_13":64,"_34":20,"_36":167,"_24":49,"_161":-5,"_27":168},{"_43":152,"_32":153,"_30":59,"_154":-5,"_41":42,"_40":155,"_156":49,"_38":157,"_13":158,"_34":159,"_36":160,"_24":49,"_161":45,"_27":162},"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",[153],"4665d232-5036-4814-85c2-bc26f2a309b8","README.md","019f4d88-ebd3-7218-9092-1474528366c9",["D",1783712246617],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/index.html`** loads Twind and the React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n",[164],"e500cffe-1cb9-4041-9dd5-9f74efd2410a","frontend","019f4d88-ebd3-7218-9092-104a308a0db8",["D",1783712246617],"directory",[170],"83688e9c-c04c-4cea-8600-2b3d4f973f05","backend","102650c1-16df-4425-91f4-ad09aa6fdd92",2,["D",1783712386625],[176],"pulls","branches","forks","envVars",{"_188":158,"_190":64},"connections",{"_188":64,"_189":64},"count","unfilledCount","emptyCount",{"_43":175,"_32":176,"_30":177,"_154":-5,"_41":42,"_40":178,"_156":25,"_38":289,"_13":64,"_34":173,"_36":-5,"_24":49,"_161":-5,"_206":290,"_27":291},{"_43":281,"_32":282,"_30":283,"_154":177,"_41":42,"_40":284,"_156":49,"_38":285,"_13":64,"_34":35,"_36":286,"_24":49,"_161":-5,"_206":287,"_27":288},{"_43":274,"_32":275,"_30":276,"_154":177,"_41":42,"_40":178,"_156":25,"_38":277,"_13":64,"_34":35,"_36":278,"_24":49,"_161":-5,"_206":279,"_27":280},{"_43":169,"_32":170,"_30":171,"_154":-5,"_41":42,"_40":158,"_156":25,"_38":271,"_13":64,"_34":173,"_36":-5,"_24":49,"_161":-5,"_206":272,"_27":273},{"_43":267,"_32":250,"_30":244,"_154":171,"_41":42,"_40":158,"_156":25,"_38":268,"_13":64,"_34":173,"_36":-5,"_24":49,"_161":-5,"_206":269,"_27":270},{"_43":259,"_32":260,"_30":261,"_154":244,"_41":42,"_40":262,"_156":49,"_38":263,"_13":158,"_34":35,"_36":264,"_24":49,"_161":-5,"_206":265,"_27":266},{"_43":251,"_32":252,"_30":253,"_154":244,"_41":42,"_40":254,"_156":49,"_38":255,"_13":64,"_34":35,"_36":256,"_24":49,"_161":-5,"_206":257,"_27":258},{"_43":241,"_32":242,"_30":243,"_154":244,"_41":42,"_40":245,"_156":49,"_38":246,"_13":64,"_34":35,"_36":247,"_24":49,"_161":-5,"_206":248,"_27":249},{"_43":234,"_32":235,"_30":236,"_154":171,"_41":42,"_40":158,"_156":25,"_38":237,"_13":64,"_34":20,"_36":238,"_24":49,"_161":-5,"_206":239,"_27":240},{"_43":227,"_32":228,"_30":229,"_154":171,"_41":42,"_40":158,"_156":49,"_38":230,"_13":64,"_34":20,"_36":231,"_24":49,"_161":-5,"_206":232,"_27":233},{"_43":220,"_32":221,"_30":222,"_154":171,"_41":42,"_40":158,"_156":25,"_38":223,"_13":64,"_34":35,"_36":224,"_24":49,"_161":-5,"_206":225,"_27":226},{"_43":212,"_32":213,"_30":214,"_154":171,"_41":42,"_40":215,"_156":49,"_38":216,"_13":64,"_34":35,"_36":217,"_24":49,"_161":-5,"_206":218,"_27":219},{"_43":163,"_32":164,"_30":165,"_154":-5,"_41":42,"_40":158,"_156":49,"_38":209,"_13":64,"_34":20,"_36":167,"_24":49,"_161":-5,"_206":210,"_27":211},{"_43":152,"_32":153,"_30":59,"_154":-5,"_41":42,"_40":155,"_156":49,"_38":205,"_13":158,"_34":159,"_36":160,"_24":49,"_161":45,"_206":207,"_27":208},["D",1783712432496],"children",[],[153],["D",1783712246617],[],[164],"93e5715b-541e-4f54-9403-3c95efbe8d2a","types.ts","d290824a-7c97-11f1-a7f6-1607ee4eb77e",5,["D",1783712693955],"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 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",[],[170,213],"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();",[],[170,221],"c1449a16-6107-4533-ac87-c9bd8a09296c","index.html","019f4d88-ebd3-7218-9092-0bf6e7622fee",["D",1783712246617],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[170,228],"dcdea6f9-7810-432f-9ba2-4cc857d89a29","favicon.svg","019f4d88-ebd3-7218-9092-072314b1de7e",["D",1783712246617],"\n",[],[170,235],"14e29ab5-b882-46c8-82cb-63697e56e6bd","ListingsTable.tsx","ded182a2-7c97-11f1-8c37-1607ee4eb77e","019f4d88-ebd3-7218-9092-021606bdd3ce",6,["D",1783712714524],"/** @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",[],[170,250,242],"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",[],[170,250,252],"3842a1dc-0521-4459-8741-0676d21b5420","App.tsx","019f4d88-ebd3-7218-9091-fa024ee09187",8,["D",1783712753722],"/** @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 [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 return 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 }, [listings, query, area]);\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",[],[170,250,260],"ae887443-2e14-4b3e-9163-23d32458cece",["D",1783712246617],[196,197,198],[170,250],["D",1783712246617],[195,199,200,201,202],[170],"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",[],[176,275],"92ca7768-ce31-4301-b956-6b04564b7530","db.ts","2c1523d0-7c97-11f1-83ac-1607ee4eb77e",3,["D",1783712414649],"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 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 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][0]) > 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\nfunction rowToListing(row: unknown[]): Listing {\n const [id, location, name, phone, website, website_label, notes, contact_updated, updated_at] = row as [\n number,\n ...string[],\n ];\n return { id, location, name, phone, website, website_label, notes, contact_updated, updated_at } as Listing;\n}\n\nconst COLS = \"id, location, name, phone, website, website_label, notes, contact_updated, updated_at\";\n\nexport async function listListings(): Promise {\n const result = await sqlite.execute(\n `SELECT ${COLS} FROM ${TABLE} ORDER BY CASE WHEN name = '' THEN 1 ELSE 0 END, name COLLATE NOCASE`,\n );\n return result.rows.map((r) => rowToListing(r as unknown[]));\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",[],[176,282],["D",1783712386625],[192,193],[176],["D",1783712246617],["D",1789525245864],{"_105":104,"_112":-5},{"_105":104,"_106":107,"_108":-5,"_18":-5,"_109":110,"_111":25},{"_13":90,"_32":91,"_43":42,"_92":44,"_93":94,"_95":96,"_97":51,"_98":99,"_100":101,"_102":45,"_103":104},"ctx",{"_83":-5,"_134":330,"_331":332,"_333":334,"_335":49,"_336":49,"_337":49,"_338":25,"_339":-5,"_340":-7,"_341":-7,"_342":64,"_343":49,"_344":49,"_345":-5,"_346":49,"_347":49,"_348":49,"_349":-5},"ENV",{"_301":302,"_303":304,"_305":91,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329},"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 · v9