{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 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":291,"_13":63,"_33":172,"_35":-5,"_23":24,"_160":-5,"_206":292,"_26":293},{"_42":283,"_31":284,"_29":285,"_153":176,"_40":41,"_39":286,"_155":24,"_37":287,"_13":63,"_33":34,"_35":288,"_23":24,"_160":-5,"_206":289,"_26":290},{"_42":276,"_31":277,"_29":278,"_153":176,"_40":41,"_39":177,"_155":59,"_37":279,"_13":63,"_33":34,"_35":280,"_23":24,"_160":-5,"_206":281,"_26":282},{"_42":168,"_31":169,"_29":170,"_153":-5,"_40":41,"_39":157,"_155":59,"_37":273,"_13":63,"_33":172,"_35":-5,"_23":24,"_160":-5,"_206":274,"_26":275},{"_42":269,"_31":250,"_29":244,"_153":170,"_40":41,"_39":157,"_155":59,"_37":270,"_13":63,"_33":172,"_35":-5,"_23":24,"_160":-5,"_206":271,"_26":272},{"_42":262,"_31":263,"_29":264,"_153":244,"_40":41,"_39":157,"_155":24,"_37":265,"_13":63,"_33":34,"_35":266,"_23":24,"_160":-5,"_206":267,"_26":268},{"_42":255,"_31":256,"_29":257,"_153":244,"_40":41,"_39":157,"_155":24,"_37":258,"_13":63,"_33":34,"_35":259,"_23":24,"_160":-5,"_206":260,"_26":261},{"_42":251,"_31":32,"_29":30,"_153":244,"_40":41,"_39":14,"_155":24,"_37":252,"_13":63,"_33":34,"_35":36,"_23":24,"_160":-5,"_206":253,"_26":254},{"_42":241,"_31":242,"_29":243,"_153":244,"_40":41,"_39":245,"_155":24,"_37":246,"_13":63,"_33":34,"_35":247,"_23":24,"_160":-5,"_206":248,"_26":249},{"_42":234,"_31":235,"_29":236,"_153":170,"_40":41,"_39":157,"_155":59,"_37":237,"_13":63,"_33":20,"_35":238,"_23":24,"_160":-5,"_206":239,"_26":240},{"_42":227,"_31":228,"_29":229,"_153":170,"_40":41,"_39":157,"_155":24,"_37":230,"_13":63,"_33":20,"_35":231,"_23":24,"_160":-5,"_206":232,"_26":233},{"_42":220,"_31":221,"_29":222,"_153":170,"_40":41,"_39":157,"_155":59,"_37":223,"_13":63,"_33":34,"_35":224,"_23":24,"_160":-5,"_206":225,"_26":226},{"_42":212,"_31":213,"_29":214,"_153":170,"_40":41,"_39":215,"_155":24,"_37":216,"_13":63,"_33":34,"_35":217,"_23":24,"_160":-5,"_206":218,"_26":219},{"_42":162,"_31":163,"_29":164,"_153":-5,"_40":41,"_39":157,"_155":24,"_37":209,"_13":63,"_33":20,"_35":166,"_23":24,"_160":-5,"_206":210,"_26":211},{"_42":151,"_31":152,"_29":57,"_153":-5,"_40":41,"_39":154,"_155":24,"_37":205,"_13":157,"_33":158,"_35":159,"_23":24,"_160":44,"_206":207,"_26":208},["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,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();",[],[169,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",[],[169,228],"dcdea6f9-7810-432f-9ba2-4cc857d89a29","favicon.svg","019f4d88-ebd3-7218-9092-072314b1de7e",["D",1783712246617],"\n",[],[169,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",[],[169,250,242],"components","cf4e1a3f-5c2c-4a58-93e8-e2d4b99e7600",["D",1783712729449],[],[169,250,32],"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,250,256],"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,250,263],"ae887443-2e14-4b3e-9163-23d32458cece",["D",1783712246617],[195,196,197,198],[169,250],["D",1783712246617],[194,199,200,201,202],[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,277],"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,284],["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":332,"_333":334,"_335":336,"_337":24,"_338":24,"_339":24,"_340":59,"_341":-5,"_342":-7,"_343":-7,"_344":63,"_345":24,"_346":24,"_347":-5,"_348":24,"_349":24,"_350":24,"_351":-5},"ENV",{"_303":304,"_305":306,"_307":90,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331},"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 · v7