\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",[19,61],"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",[19,68],"0cc88282-5a24-11f1-82ab-ee650bb23af1",7,["D",1779924630488],"directory",[19],{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":75,"_47":48,"_49":92,"_17":51,"_52":77,"_54":-5,"_56":57,"_58":-5,"_89":93,"_18":94},{"_36":81,"_13":82,"_39":83,"_41":-5,"_43":44,"_45":84,"_47":48,"_49":85,"_17":86,"_52":87,"_54":88,"_56":57,"_58":-5,"_89":90,"_18":91},"301ac894-5a24-11f1-82ab-ee650bb23af1","main.ts","ee186322-5a21-11f1-801e-ee650bb23af1",11,["D",1779924689747],6,"interval","import { email } from \"https://esm.town/v/std/email\";\nimport { fetchStreetEasyListings } from \"./src/streeteasy.ts\";\nimport { initDB, filterNewListings, markListingsSeen, cleanOldListings } from \"./src/db.ts\";\nimport { buildEmailHTML } from \"./src/email-template.ts\";\n\nconst MAX_RENT = 4000;\nconst MIN_BEDS = 2;\n\nconst TARGET_NEIGHBORHOODS = new Set([\n \"Lower East Side\", \"East Village\", \"West Village\",\n \"Williamsburg\", \"Greenpoint\", \"Park Slope\",\n \"Carroll Gardens\", \"Cobble Hill\", \"Boerum Hill\",\n \"Brooklyn Heights\", \"Fort Greene\", \"Clinton Hill\",\n \"Prospect Heights\", \"Prospect Park South\", \"Kensington\", \"South Slope\",\n]);\n\nexport default async function main(interval: Interval) {\n const today = new Date().toLocaleDateString(\"en-US\", {\n weekday: \"long\", year: \"numeric\", month: \"long\", day: \"numeric\",\n });\n console.log(\"Fetching listings for\", today);\n\n await initDB();\n\n // Fetch from StreetEasy API\n const allListings = await fetchStreetEasyListings(MAX_RENT, MIN_BEDS);\n\n // Filter to target neighborhoods\n const neighborhoodFiltered = allListings.filter(\n (l) => TARGET_NEIGHBORHOODS.has(l.neighborhood)\n );\n console.log(`${neighborhoodFiltered.length} listings in target neighborhoods (of ${allListings.length} total)`);\n\n // Filter to only new (unseen) listings\n const newListings = await filterNewListings(neighborhoodFiltered);\n console.log(`${newListings.length} new listings (not previously seen)`);\n\n // Mark them as seen for next run\n await markListingsSeen(newListings);\n\n // Clean up old records\n await cleanOldListings(30);\n\n // Send email digest\n const html = buildEmailHTML(newListings, today);\n await email({\n subject: `🗽 NYC Apt Digest — ${newListings.length} new listings · ${today}`,\n html,\n });\n console.log(\"Email sent!\");\n}\n","children",[],[82],["D",1779924630488],[95,96,97],[19],{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":104,"_17":51,"_52":53,"_54":72,"_56":57,"_58":-5,"_89":105,"_18":106},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":101,"_17":51,"_52":53,"_54":65,"_56":57,"_58":-5,"_89":102,"_18":103},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":98,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_89":99,"_18":100},["D",1779924641900],[],[19,38],["D",1779924677485],[],[19,61],["D",1779924648198],[],[19,68],"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,"_163":159},"org",{"_11":12,"_156":157,"_158":159,"_116":117,"_160":161,"_162":57},"branch",{"_17":84,"_13":16,"_36":44,"_148":107,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":14,"_155":12},"isOwned","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",{"_36":107,"_13":14,"_49":215,"_109":-5,"_110":57,"_111":112,"_113":112,"_114":14,"_115":-5,"_116":117,"_118":-5,"_119":57,"_120":-5,"_121":-5,"_122":51,"_123":124,"_125":126,"_127":128,"_129":216,"_131":-5,"_132":133,"_134":133,"_135":136,"_137":136,"_138":136,"_139":133,"_140":133,"_141":217,"_143":218,"_145":219,"_147":57},[200,204],"files",[200,201,202,203,204],"counts",{"_190":51,"_191":192,"_193":51,"_32":194,"_195":196},[184,185,186],{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":75,"_47":48,"_49":76,"_17":51,"_52":77,"_54":-5,"_56":57,"_58":-5,"_18":183},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":71,"_17":51,"_52":53,"_54":72,"_56":57,"_58":-5,"_18":189},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":51,"_52":53,"_54":65,"_56":57,"_58":-5,"_18":188},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":187},[19,38],[19,61],[19,68],"pulls","branches",1,"forks",{"_197":51,"_199":51},"connections",{"_197":51,"_198":51},"count","unfilledCount","emptyCount",{"_36":74,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":75,"_47":48,"_49":92,"_17":51,"_52":77,"_54":-5,"_56":57,"_58":-5,"_89":213,"_18":214},{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":104,"_17":51,"_52":53,"_54":72,"_56":57,"_58":-5,"_89":211,"_18":212},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":101,"_17":51,"_52":53,"_54":65,"_56":57,"_58":-5,"_89":209,"_18":210},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":98,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_89":207,"_18":208},{"_36":81,"_13":82,"_39":83,"_41":-5,"_43":44,"_45":84,"_47":48,"_49":85,"_17":86,"_52":87,"_54":88,"_56":57,"_58":-5,"_89":205,"_18":206},[],[82],[],[19,38],[],[19,61],[],[19,68],[201,202,203],[19],["D",1779923719999],["D",1789509672838],{"_11":12,"_163":159},{"_11":12,"_156":157,"_158":159,"_116":117,"_160":161,"_162":57},{"_17":84,"_13":16,"_36":44,"_148":107,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":14,"_155":12},"ctx",{"_141":-5,"_180":253,"_254":255,"_256":257,"_258":57,"_259":57,"_260":57,"_261":48,"_262":-5,"_263":-7,"_264":-7,"_265":51,"_266":57,"_267":57,"_268":-5,"_269":57,"_270":57,"_271":57,"_272":-5},"ENV",{"_224":225,"_226":227,"_228":16,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252},"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"]