\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",[],[78,80],"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",[],[78,88],"0cc88282-5a24-11f1-82ab-ee650bb23af1",7,["D",1779924630488],"directory",[39,40,41],[78],{"_43":95,"_13":78,"_46":70,"_48":-5,"_49":50,"_51":96,"_53":34,"_54":105,"_16":73,"_57":98,"_59":-5,"_61":36,"_62":-5,"_65":106},{"_43":44,"_13":45,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":34,"_54":103,"_16":56,"_57":58,"_59":60,"_61":36,"_62":-5,"_65":104},["D",1779924689747],[45],["D",1779924630488],[78],"pulls","branches",1,"forks","envVars",{"_115":73,"_117":73},"connections",{"_115":73,"_116":73},"count","unfilledCount","emptyCount","ee156744-5a21-11f1-801e-ee650bb23af1",["D",1779923719999],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","ffebef60-80fd-4bcb-99b9-38ef04630988","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019e6bb0-ad75-7217-b266-b5f8954b171f","tursoName","ee1567445a2111f1801eee650bb23af1","tursoHostname","ee1567445a2111f1801eee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789509672838],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_175":171},"org",{"_11":12,"_168":169,"_170":171,"_127":128,"_172":173,"_174":36},"branch",{"_16":52,"_13":159,"_43":50,"_160":118,"_161":-5,"_162":-5,"_163":-5,"_164":-5,"_165":-5,"_166":14,"_167":12},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Brenton","avatar","https://lh3.googleusercontent.com/a/ACg8ocLfAMO6RfM2EQ-e49sWblvciX2G5Gwp-fO3qazIAs6U0F77uRi8aQ=s96-c","tier","free","canRestrictVals","profileImageUrl","","adoptOrgId",{"_43":118,"_13":14,"_54":216,"_120":-5,"_121":36,"_122":123,"_124":123,"_125":14,"_126":-5,"_127":128,"_129":-5,"_130":36,"_131":-5,"_132":-5,"_133":73,"_134":135,"_136":137,"_138":139,"_140":217,"_142":-5,"_143":144,"_145":144,"_146":147,"_148":147,"_149":147,"_150":144,"_151":144,"_152":218,"_154":219,"_156":220,"_158":36},"tree",[201,205],[201,202,203,204,205],{"_107":73,"_108":109,"_110":73,"_111":199,"_113":200},[195,196],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":95,"_13":78,"_46":70,"_48":-5,"_49":50,"_51":96,"_53":34,"_54":105,"_16":73,"_57":98,"_59":-5,"_61":36,"_62":-5,"_65":198},{"_43":44,"_13":45,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":34,"_54":103,"_16":56,"_57":58,"_59":60,"_61":36,"_62":-5,"_65":197},[45],[78],{"_115":73,"_117":73},{"_115":73,"_116":73},{"_43":95,"_13":78,"_46":70,"_48":-5,"_49":50,"_51":96,"_53":34,"_54":97,"_16":73,"_57":98,"_59":-5,"_61":36,"_62":-5,"_63":214,"_65":215},{"_43":87,"_13":88,"_46":89,"_48":70,"_49":50,"_51":90,"_53":34,"_54":91,"_16":73,"_57":74,"_59":92,"_61":36,"_62":-5,"_63":212,"_65":213},{"_43":79,"_13":80,"_46":81,"_48":70,"_49":50,"_51":82,"_53":34,"_54":83,"_16":73,"_57":74,"_59":84,"_61":36,"_62":-5,"_63":210,"_65":211},{"_43":67,"_13":68,"_46":69,"_48":70,"_49":50,"_51":71,"_53":34,"_54":72,"_16":73,"_57":74,"_59":75,"_61":36,"_62":-5,"_63":208,"_65":209},{"_43":44,"_13":45,"_46":47,"_48":-5,"_49":50,"_51":52,"_53":34,"_54":55,"_16":56,"_57":58,"_59":60,"_61":36,"_62":-5,"_63":206,"_65":207},[],[45],[],[78,68],[],[78,80],[],[78,88],[202,203,204],[78],["D",1779923719999],["D",1789509672838],{"_11":12,"_175":171},{"_11":12,"_168":169,"_170":171,"_127":128,"_172":173,"_174":36},{"_16":52,"_13":159,"_43":50,"_160":118,"_161":-5,"_162":-5,"_163":-5,"_164":-5,"_165":-5,"_166":14,"_167":12},"ctx",{"_152":-5,"_192":254,"_255":256,"_257":258,"_259":36,"_260":36,"_261":36,"_262":34,"_263":-5,"_264":-7,"_265":-7,"_266":73,"_267":36,"_268":36,"_269":-5,"_270":36,"_271":36,"_272":36,"_273":-5},"ENV",{"_225":226,"_227":228,"_229":159,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253},"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"]

brentonmsmith

Apartment