\n ${l.bedrooms} bed · ${l.bathrooms} bath · $${l.rent.toLocaleString()}/mo · ${l.neighborhood}\n ${l.noFee ? ' · NO FEE' : \"\"}\n

\n \n `).join(\"\")\n : `No new listings today. Check back tomorrow!`;\n\n return `\n\n\n

🗽 NYC Apartment Digest

${date}

${count}

new listings

$4K

max rent

2BR+

bedrooms

\n Today's Matches\n

\n ${listingRows}

🔍 Search directly on:

\n \n StreetEasy →\n \n \n Zillow →\n \n \n RentHop →\n \n

\n Watching: ${NEIGHBORHOODS.join(\" · \")}\n

\n\n`;\n}\n",[],[129,165],"17567524-5a24-11f1-82ab-ee650bb23af1","db.ts","175675d8-5a24-11f1-82ab-ee650bb23af1",9,["D",1779924648198],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Listing } from \"./streeteasy.ts\";\n\nexport async function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS seen_listings (\n id TEXT PRIMARY KEY,\n address TEXT,\n neighborhood TEXT,\n rent INTEGER,\n bedrooms INTEGER,\n url TEXT,\n source TEXT,\n first_seen_at TEXT DEFAULT (datetime('now'))\n )\n `);\n}\n\nexport async function filterNewListings(listings: Listing[]): Promise {\n if (listings.length === 0) return [];\n\n const placeholders = listings.map(() => \"?\").join(\",\");\n const ids = listings.map((l) => l.id);\n const result = await sqlite.execute({\n sql: `SELECT id FROM seen_listings WHERE id IN (${placeholders})`,\n args: ids,\n });\n\n const seenIds = new Set(result.rows.map((r: any) => r.id));\n return listings.filter((l) => !seenIds.has(l.id));\n}\n\nexport async function markListingsSeen(listings: Listing[]) {\n if (listings.length === 0) return;\n\n const statements = listings.map((l) => ({\n sql: `INSERT OR IGNORE INTO seen_listings (id, address, neighborhood, rent, bedrooms, url, source) VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [l.id, l.address, l.neighborhood, l.rent, l.bedrooms, l.url, l.source],\n }));\n\n await sqlite.batch(statements);\n}\n\nexport async function cleanOldListings(daysToKeep = 30) {\n await sqlite.execute({\n sql: `DELETE FROM seen_listings WHERE first_seen_at < datetime('now', ?)`,\n args: [`-${daysToKeep} days`],\n });\n}\n",[],[129,173],["D",1779924630488],[147,148,149],[129],["D",1779923719999],["D",1789509672838],{"_16":17,"_84":80},{"_16":17,"_77":78,"_79":80,"_32":33,"_81":82,"_83":26},{"_65":66,"_20":67,"_18":68,"_69":19,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":21,"_76":17},"ctx",{"_58":-5,"_105":221,"_222":223,"_224":225,"_226":26,"_227":26,"_228":26,"_229":118,"_230":-5,"_231":-7,"_232":-7,"_233":39,"_234":26,"_235":26,"_236":-5,"_237":26,"_238":26,"_239":26,"_240":-5},"ENV",{"_192":193,"_194":195,"_196":67,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220},"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"]