[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_290":291,"_292":293},"routes/_app.x.$handle.$name",{"_104":103,"_31":44,"_112":90,"_26":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_20":-5,"_124":125,"_126":127,"_128":24,"_129":130,"_131":59,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":54,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":24},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","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","createdAt",["D",1783712714524],"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=1789577999&sig=2ab81189fced4fb576e9436da67acbaf730951eef80212e8dc3c2bf0f6be2f57","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",{"_104":103,"_111":-5},"org",{"_104":103,"_105":106,"_107":-5,"_18":-5,"_108":109,"_110":59},"branch",{"_13":89,"_31":90,"_42":41,"_91":43,"_92":93,"_94":95,"_96":49,"_97":98,"_99":100,"_101":44,"_102":103},"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",{"_42":43,"_31":44,"_37":285,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":54,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":286,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":287,"_84":288,"_86":289,"_88":24},"tree",[190,193,202,203],"files",[190,191,192,193,194,195,196,197,198,199,200,201,202,203],"counts",{"_180":63,"_181":157,"_182":63,"_183":184,"_185":186},"contents",[147,148,149,150],"upstreamProject",{"_42":98,"_31":143,"_51":144,"_53":54,"_48":49,"_82":145},"upstreamBranch",{"_42":93,"_37":136,"_137":138,"_31":90,"_91":98,"_13":139,"_92":-5,"_94":-5,"_140":141,"_46":-5,"_88":24,"_48":49,"_102":142,"_64":100,"_101":143},"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",{"_104":142,"_111":146},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789577999&sig=aa7aec25480c67f41f9650e8445afc21cf1a6c5fd3969752b90fbd3f6a604c46",{"_42":174,"_31":175,"_29":176,"_153":-5,"_40":41,"_39":177,"_155":59,"_37":178,"_13":63,"_33":172,"_35":-5,"_23":24,"_160":-5,"_26":179},{"_42":168,"_31":169,"_29":170,"_153":-5,"_40":41,"_39":157,"_155":59,"_37":171,"_13":63,"_33":172,"_35":-5,"_23":24,"_160":-5,"_26":173},{"_42":162,"_31":163,"_29":164,"_153":-5,"_40":41,"_39":157,"_155":24,"_37":165,"_13":63,"_33":20,"_35":166,"_23":24,"_160":-5,"_26":167},{"_42":151,"_31":152,"_29":57,"_153":-5,"_40":41,"_39":154,"_155":24,"_37":156,"_13":157,"_33":158,"_35":159,"_23":24,"_160":44,"_26":161},"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",[152],"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",[163],"e500cffe-1cb9-4041-9dd5-9f74efd2410a","frontend","019f4d88-ebd3-7218-9092-104a308a0db8",["D",1783712246617],"directory",[169],"83688e9c-c04c-4cea-8600-2b3d4f973f05","backend","102650c1-16df-4425-91f4-ad09aa6fdd92",2,["D",1783712386625],[175],"pulls","branches","forks","envVars",{"_187":157,"_189":63},"connections",{"_187":63,"_188":63},"count","unfilledCount","emptyCount",{"_42":174,"_31":175,"_29":176,"_153":-5,"_40":41,"_39":177,"_155":59,"_37":282,"_13":63,"_33":172,"_35":-5,"_23":24,"_160":-5,"_205":283,"_26":284},{"_42":274,"_31":275,"_29":276,"_153":176,"_40":41,"_39":277,"_155":24,"_37":278,"_13":63,"_33":34,"_35":279,"_23":24,"_160":-5,"_205":280,"_26":281},{"_42":267,"_31":268,"_29":269,"_153":176,"_40":41,"_39":177,"_155":59,"_37":270,"_13":63,"_33":34,"_35":271,"_23":24,"_160":-5,"_205":272,"_26":273},{"_42":168,"_31":169,"_29":170,"_153":-5,"_40":41,"_39":157,"_155":59,"_37":264,"_13":63,"_33":172,"_35":-5,"_23":24,"_160":-5,"_205":265,"_26":266},{"_42":260,"_31":245,"_29":241,"_153":170,"_40":41,"_39":157,"_155":59,"_37":261,"_13":63,"_33":172,"_35":-5,"_23":24,"_160":-5,"_205":262,"_26":263},{"_42":253,"_31":254,"_29":255,"_153":241,"_40":41,"_39":157,"_155":24,"_37":256,"_13":63,"_33":34,"_35":257,"_23":24,"_160":-5,"_205":258,"_26":259},{"_42":246,"_31":247,"_29":248,"_153":241,"_40":41,"_39":157,"_155":24,"_37":249,"_13":63,"_33":34,"_35":250,"_23":24,"_160":-5,"_205":251,"_26":252},{"_42":240,"_31":32,"_29":30,"_153":241,"_40":41,"_39":14,"_155":24,"_37":242,"_13":63,"_33":34,"_35":36,"_23":24,"_160":-5,"_205":243,"_26":244},{"_42":233,"_31":234,"_29":235,"_153":170,"_40":41,"_39":157,"_155":59,"_37":236,"_13":63,"_33":20,"_35":237,"_23":24,"_160":-5,"_205":238,"_26":239},{"_42":226,"_31":227,"_29":228,"_153":170,"_40":41,"_39":157,"_155":24,"_37":229,"_13":63,"_33":20,"_35":230,"_23":24,"_160":-5,"_205":231,"_26":232},{"_42":219,"_31":220,"_29":221,"_153":170,"_40":41,"_39":157,"_155":59,"_37":222,"_13":63,"_33":34,"_35":223,"_23":24,"_160":-5,"_205":224,"_26":225},{"_42":211,"_31":212,"_29":213,"_153":170,"_40":41,"_39":214,"_155":24,"_37":215,"_13":63,"_33":34,"_35":216,"_23":24,"_160":-5,"_205":217,"_26":218},{"_42":162,"_31":163,"_29":164,"_153":-5,"_40":41,"_39":157,"_155":24,"_37":208,"_13":63,"_33":20,"_35":166,"_23":24,"_160":-5,"_205":209,"_26":210},{"_42":151,"_31":152,"_29":57,"_153":-5,"_40":41,"_39":154,"_155":24,"_37":204,"_13":157,"_33":158,"_35":159,"_23":24,"_160":44,"_205":206,"_26":207},["D",1783712432496],"children",[],[152],["D",1783712246617],[],[163],"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",[],[169,212],"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();",[],[169,220],"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",[],[169,227],"dcdea6f9-7810-432f-9ba2-4cc857d89a29","favicon.svg","019f4d88-ebd3-7218-9092-072314b1de7e",["D",1783712246617],"\n",[],[169,234],"14e29ab5-b882-46c8-82cb-63697e56e6bd","019f4d88-ebd3-7218-9092-021606bdd3ce",["D",1783712714524],[],[169,245,32],"components","d12907a8-f4e7-41d6-a005-5c86b68c668d","Counter.tsx","019f4d88-ebd3-7218-9091-fdebced2e420",["D",1783712246617],"/** @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",[],[169,245,247],"19b539d7-83e0-44a5-8f48-d0e9947b489f","App.tsx","019f4d88-ebd3-7218-9091-fa024ee09187",["D",1783712246617],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Counter } from \"./Counter.tsx\";\n\nexport function App() {\n return (\n

React + Hono Starter

\n \n

\n View source\n

\n );\n}\n",[],[169,245,254],"ae887443-2e14-4b3e-9163-23d32458cece",["D",1783712246617],[195,196,197],[169,245],["D",1783712246617],[194,198,199,200,201],[169],"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",[],[175,268],"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",[],[175,275],["D",1783712386625],[191,192],[175],["D",1783712246617],["D",1789525245864],{"_104":103,"_111":-5},{"_104":103,"_105":106,"_107":-5,"_18":-5,"_108":109,"_110":59},{"_13":89,"_31":90,"_42":41,"_91":43,"_92":93,"_94":95,"_96":49,"_97":98,"_99":100,"_101":44,"_102":103},"ctx",{"_82":-5,"_133":323,"_324":325,"_326":327,"_328":24,"_329":24,"_330":24,"_331":59,"_332":-5,"_333":-7,"_334":-7,"_335":63,"_336":24,"_337":24,"_338":-5,"_339":24,"_340":24,"_341":24,"_342":-5},"ENV",{"_294":295,"_296":297,"_298":90,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322},"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 · v6