[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_110":111,"_112":113},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","logan1","name","corvette","path","cron/craigslist.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":70,"_71":72,"_73":74,"_75":-5,"_76":77,"_78":77,"_79":80,"_81":80,"_82":80,"_83":77,"_84":77,"_85":86,"_87":88,"_89":90,"_91":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/logan1/corvette/code/cron/craigslist.ts","extension","id","663ba0d7-2bcc-446d-82e4-828b7e316eda","craigslist.ts","fileId","381ffdd6-af86-11f1-ae73-1607ee4eb77e","parentId","1b0a73f2-af86-11f1-b58b-1607ee4eb77e","branchId","86e98f95-71bb-401c-ac30-44ee51ed36fc","branchVersion",57,"latest",true,"createdAt",["D",1789344885891],"version",5,"fileType","interval","content","// Craigslist poller (cron, every 20 min). Public search URLs, no login.\r\n// Finding from 2026-09-13 (scripts/fixtures/cl-unified-search.html): the unified\r\n// https://www.craigslist.org/search/city/new-castle-pa?cat=cta&postal=16105&radius=350 search returns\r\n// static

rows from EVERY regional site inside the radius (result hrefs are\r\n// www.craigslist.org/view/d//), so one request replaces the ~40 per-site queries in the plan. The\r\n// per-site URLs (pittsburgh.craigslist.org/search/cta?...&postal=16105&search_distance=350) return the same page.\r\n// Detail pages expose structured attrs (VIN, odometer, title status, transmission, type, paint, condition),\r\n// data-latitude/longitude, and 'categoryAbbr': \"cto\" (by-owner) | \"ctd\" (dealer).\r\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\r\nimport {\r\n ensureSchema, upsertListing, logPoll, inferYear, inferTrans, inferBody, inferTitle, inferSeller, inferMiles, inferTrim, parsePrice, parseMiles,\r\n findVin, decodeEntities, stripTags, distFrom16105, today, UA, NAV_HEADERS, sleep, PRICE_MIN, PRICE_MAX, YEAR_MIN, YEAR_MAX, MAX_INGEST_MI, type Trans, type Body, type Title, type Seller,\r\n} from \"../lib/core.ts\";\r\nimport { applyMissed } from \"../lib/enrich.ts\";\r\n\r\n// CL_RADIUS: 350 during calibration; set the env var to 500 on Nov 1 if nothing has passed PPI (expansion-plan 2b, FAR band)\r\nconst RADIUS = Number(Deno.env.get(\"CL_RADIUS\") || 350);\r\nconst BASE = `https://www.craigslist.org/search/city/new-castle-pa?cat=cta&query=corvette&postal=16105&radius=${RADIUS}`;\r\nexport const QUERIES = [\r\n `${BASE}&min_auto_year=${YEAR_MIN}&max_auto_year=${YEAR_MAX}`, // year attr set, any price (catches \"call for price\")\r\n `${BASE}&min_price=${PRICE_MIN}&max_price=${PRICE_MAX}&srchType=T`, // price in band, TITLE-only match (47 rows / 91 KB instead of 120 rows / 280 KB of dealer spam)\r\n];\r\n// step 0: the sapi JSON behind the search page - odometer, lat/lon, site, owner/dealer and posted time for every row in ~35-75 KB (verified 200 from val.town 2026-09-13)\r\nexport const SAPI = [\r\n `https://sapi.craigslist.org/web/v8/postings/search/full?batch=706-0-360-0-0&cc=US&lang=en&query=corvette&searchPath=cta&min_auto_year=${YEAR_MIN}&max_auto_year=${YEAR_MAX}&postal=16105&search_distance=${RADIUS}`,\r\n `https://sapi.craigslist.org/web/v8/postings/search/full?batch=706-0-360-0-0&cc=US&lang=en&query=corvette&searchPath=cta&min_price=${PRICE_MIN}&max_price=${PRICE_MAX}&postal=16105&search_distance=${RADIUS}`,\r\n];\r\n// Craigslist sites whose territory touches the 350 mi ring (source-inventory CL-4). A reply host outside this set is a relocation scam\r\n// (the Toms River convertible was posted from the honolulu site) -> stored with OUT-OF-REGION SITE, never pushed.\r\nexport const IN_RADIUS_CL_SITES = new Set([\"pittsburgh\", \"youngstown\", \"cleveland\", \"akroncanton\", \"erie\", \"columbus\", \"toledo\", \"dayton\", \"cincinnati\", \"buffalo\", \"rochester\", \"syracuse\", \"ithaca\", \"binghamton\", \"elmira\", \"chautauqua\", \"utica\", \"fingerlakes\", \"twintiers\", \"morgantown\", \"wheeling\", \"parkersburg\", \"charlestonwv\", \"huntington\", \"martinsburg\", \"altoona\", \"statecollege\", \"harrisburg\", \"williamsport\", \"lancaster\", \"york\", \"chambersburg\", \"poconos\", \"scranton\", \"reading\", \"allentown\", \"philadelphia\", \"westmd\", \"smd\", \"baltimore\", \"annapolis\", \"easternshore\", \"frederick\", \"washingtondc\", \"fredericksburg\", \"richmond\", \"charlottesville\", \"harrisonburg\", \"winchester\", \"lynchburg\", \"roanoke\", \"danville\", \"blacksburg\", \"detroit\", \"annarbor\", \"lansing\", \"flint\", \"saginaw\", \"jxn\", \"monroemi\", \"battlecreek\", \"kalamazoo\", \"grandrapids\", \"swmi\", \"centralmi\", \"thumb\", \"fortwayne\", \"indianapolis\", \"muncie\", \"richmondin\", \"kokomo\", \"southbend\", \"bloomington\", \"terrehaute\", \"lexington\", \"louisville\", \"eastky\", \"ashland\", \"delaware\", \"southjersey\", \"cnj\", \"jerseyshore\", \"newyork\", \"hudsonvalley\", \"mansfield\", \"ashtabula\", \"meadville\", \"sandusky\", \"limaohio\", \"zanesville\", \"chillicothe\", \"athensohio\", \"tuscarawas\", \"raleigh\", \"greensboro\", \"winstonsalem\", \"hickory\", \"boone\", \"wv\", \"newjersey\", \"albany\", \"longisland\", \"catskills\", \"oneonta\", \"watertown\", \"plattsburgh\", \"hartford\", \"newhaven\", \"providence\", \"boston\", \"worcester\", \"springfield\", \"westernmass\", \"charlotte\", \"asheville\", \"knoxville\", \"chattanooga\", \"nashville\", \"clarksville\", \"bowlinggreen\", \"owensboro\", \"evansville\", \"lafayette\", \"chicago\", \"peoria\", \"rockford\", \"milwaukee\", \"madison\", \"chambana\", \"columbiamo\"]);\r\n// other-make titles never need a detail fetch; bare titles (\"2000\", \"Corvette\") still do (expansion-plan fix 1: the Easton MD 2000 C5 hid behind a bare title)\r\nexport const OTHER_MAKE_RE = /\\b(jeep|toyota|ford|mustang|camaro|gmc|dodge|chrysler|ram|honda|nissan|hyundai|kia|subaru|mazda|bmw|mercedes|audi|volkswagen|vw|porsche|lexus|acura|infiniti|cadillac|buick|pontiac|oldsmobile|saturn|lincoln|mercury|volvo|jaguar|mini|fiat|tesla|silverado|sierra|tahoe|suburban|equinox|malibu|impala|cruze|trailblazer|blazer|colorado|avalanche|f-?150|f-?250|wrangler|firebird|challenger|charger|viper|miata|boxster|911|c6|c7|c8)\\b/i;\r\nconst TIME_BUDGET_MS = 45_000;\r\nconst MAX_DETAILS_PER_RUN = 20;\r\nconst SEARCH_DELAY_MS = 1500;\r\nconst DETAIL_DELAY_MS = 900;\r\nexport const CORVETTE_TITLE_RE = /corvette|\\bvette\\b|\\bc[45]\\b/i;\r\n\r\nexport interface SearchHit { extId: string; url: string; title: string; price: number | null; location: string; miles?: number | null; lat?: number | null; lon?: number | null; site?: string | null; owner?: boolean | null; posted?: string | null }\r\n\r\n// sapi item: [postingId-min, postedTs-min, categoryId (145 owner / 146 dealer), price, \"locIdx:descIdx~lat~lon\", imgKey, [13, opaqueId], [4, imgs...], [6, slug], [9, odometer], [10, \"$str\"], title]\r\nexport function parseSapi(json: string): SearchHit[] {\r\n let j: any; try { j = JSON.parse(json); } catch { return []; }\r\n const d = j?.data; if (!d || !Array.isArray(d.items)) return [];\r\n const locs: any[] = d.decode?.locations || []; const descs: string[] = d.decode?.locationDescriptions || [];\r\n const minPosted = Number(d.decode?.minPostedDate || 0);\r\n const out: SearchHit[] = [];\r\n for (const it of d.items.slice(0, Number(d.totalResultCount) || d.items.length)) {\r\n if (!Array.isArray(it)) continue;\r\n const title = String(it[it.length - 1] || \"\");\r\n const tagged: Record = {};\r\n for (const x of it) if (Array.isArray(x) && typeof x[0] === \"number\") tagged[x[0]] = x;\r\n const opaque = tagged[13]?.[1]; const slug = tagged[6]?.[1]; if (!opaque || !slug) continue;\r\n const locStr = typeof it[4] === \"string\" ? it[4] : \"\";\r\n const lm = locStr.match(/^(\\d+):(\\d+)~(-?[\\d.]+)~(-?[\\d.]+)/);\r\n const site = lm ? (Array.isArray(locs[Number(lm[1])]) ? String(locs[Number(lm[1])][1]) : null) : null;\r\n const desc = lm ? String(descs[Number(lm[2])] || \"\") : \"\";\r\n const rawPrice = typeof it[3] === \"number\" && it[3] > 0 ? it[3] : parsePrice(tagged[10]?.[1]);\r\n const price = rawPrice != null && rawPrice >= 1000 ? rawPrice : null; // \"$14\" placeholders are not prices\r\n out.push({ extId: String(opaque), url: `https://www.craigslist.org/view/d/${slug}/${opaque}`, title, price, location: desc,\r\n miles: tagged[9] ? Number(tagged[9][1]) || null : null, lat: lm ? Number(lm[3]) : null, lon: lm ? Number(lm[4]) : null, site,\r\n owner: it[2] === 145 ? true : it[2] === 146 ? false : null, posted: minPosted && typeof it[1] === \"number\" ? new Date((minPosted + it[1]) * 1000).toISOString() : null });\r\n }\r\n return out;\r\n}\r\n\r\nasync function fetchText(url: string): Promise<{ status: number; text: string }> {\r\n const res = await fetch(url, { headers: { \"user-agent\": UA, ...NAV_HEADERS } });\r\n return { status: res.status, text: res.ok ? await res.text() : \"\" };\r\n}\r\n\r\nexport function parseSearch(html: string): SearchHit[] {\r\n const out: SearchHit[] = [];\r\n const re = /

]*>([\\s\\S]*?)<\\/li>/g;\r\n let m: RegExpExecArray | null;\r\n while ((m = re.exec(html))) {\r\n const li = m[1];\r\n const href = (li.match(/href=\"([^\"]+)\"/) || [])[1];\r\n if (!href) continue;\r\n const extId = (href.match(/\\/([A-Za-z0-9_-]{8,})\\/?$/) || [])[1] || href;\r\n const title = decodeEntities((li.match(/

([\\s\\S]*?)<\\/div>/) || [, \"\"])[1].trim());\r\n const price = parsePrice((li.match(/

([\\s\\S]*?)<\\/div>/) || [, \"\"])[1]);\r\n const location = decodeEntities((li.match(/

([\\s\\S]*?)<\\/div>/) || [, \"\"])[1]).replace(/\\s+/g, \" \").trim();\r\n out.push({ extId, url: href, title, price, location });\r\n }\r\n return out;\r\n}\r\n\r\nexport interface Detail {\r\n title: string; price: number | null; year: number | null; makemodel: string; vin: string | null; miles: number | null; titleStatus: Title; trans: Trans; body: Body;\r\n paint: string | null; condition: string | null; fuel: string | null; drive: string | null; cylinders: string | null;\r\n lat: number | null; lon: number | null; mapaddress: string | null; posted: string | null; postId: string | null; category: string | null; area: string | null; body_text: string; attrs: Record;\r\n}\r\nexport function parseDetail(html: string): Detail {\r\n const g = (re: RegExp) => (html.match(re) || [])[1];\r\n const title = decodeEntities(g(/([\\s\\S]*?)<\\/span>/) || \"\").trim();\r\n const price = parsePrice(g(/([\\s\\S]*?)<\\/span>/));\r\n const attrs: Record = {};\r\n for (const m of html.matchAll(/

([\\s\\S]*?)<\\/div>/g)) attrs[m[1]] = stripTags(m[2]).replace(/^[^:]*:\\s*/, \"\").trim();\r\n const year = attrs.important ? Number((attrs.important.match(/\\b(19\\d\\d|20\\d\\d)\\b/) || [])[1]) || null : Number(g(/(\\d{4})<\\/span>/)) || null;\r\n const makemodel = stripTags(g(/([\\s\\S]*?)<\\/span>/) || \"\");\r\n const vinRaw = attrs.auto_vin || null;\r\n const rawAddr = stripTags(g(/class=\"mapaddress\">([\\s\\S]*?)<\\/div>/) || \"\").replace(/\\bgoogle map\\b/i, \"\").replace(/\\s+/g, \" \").trim();\r\n const lat = g(/data-latitude=\"([^\"]+)\"/); const lon = g(/data-longitude=\"([^\"]+)\"/);\r\n const bodyText = stripTags((g(/

([\\s\\S]*?)<\\/section>/) || \"\").replace(/

\\s*<\\/div>/, \"\"));\r\n const ts = (attrs.auto_title_status || \"\").toLowerCase();\r\n const titleStatus: Title = /clean/.test(ts) ? \"clean\" : /rebuilt/.test(ts) ? \"rebuilt\" : /salvage|parts only|lien|missing/.test(ts) ? \"salvage\" : \"unknown\";\r\n const tr = (attrs.auto_transmission || \"\").toLowerCase();\r\n const trans: Trans = /automatic/.test(tr) ? \"auto\" : /manual/.test(tr) ? \"manual\" : \"unknown\";\r\n const bt = (attrs.auto_bodytype || \"\").toLowerCase();\r\n const body: Body = /convertible/.test(bt) ? \"convertible\" : /coupe|hatchback/.test(bt) ? \"coupe\" : \"unknown\";\r\n return {\r\n title, price, year, makemodel, vin: vinRaw, miles: parseMiles(attrs.auto_miles), titleStatus, trans, body,\r\n paint: attrs.auto_paint || null, condition: attrs.condition || null, fuel: attrs.auto_fuel_type || null, drive: attrs.auto_drivetrain || null, cylinders: attrs.auto_cylinders || null,\r\n lat: lat ? Number(lat) : null, lon: lon ? Number(lon) : null, mapaddress: rawAddr || null,\r\n posted: g(/ YEAR_MAX) return { ok: false, reason: `year ${year ?? \"?\"}` };\r\n if (d.price != null && (d.price < PRICE_MIN || d.price > PRICE_MAX)) return { ok: false, reason: `price ${d.price}` };\r\n if (d.miles == null && !d.vin) return { ok: false, reason: \"no odometer and no VIN\" };\r\n return { ok: true };\r\n}\r\n\r\nexport default async function (interval?: { lastRunAt?: Date }) {\r\n const started = Date.now();\r\n await ensureSchema();\r\n const stats = { fetched: 0, inserted: 0, updated: 0, pushed: 0 };\r\n const notes: string[] = [];\r\n let failedQueries = 0;\r\n const seen = new Map();\r\n\r\n // step 0: sapi JSON (structured rows); the HTML search stays as the canary/fallback when sapi fails\r\n let sapiOk = 0;\r\n for (const url of SAPI) {\r\n try {\r\n const res = await fetch(url, { headers: { \"user-agent\": UA, accept: \"application/json\", \"accept-language\": \"en-US,en;q=0.9\", referer: \"https://www.craigslist.org/\" } });\r\n const text = res.ok ? await res.text() : \"\";\r\n const hits = res.ok ? parseSapi(text) : [];\r\n if (!hits.length) notes.push(`sapi http ${res.status} (${text.length}b, 0 rows)`);\r\n else { sapiOk++; stats.fetched += hits.length; for (const h of hits) if (!seen.has(h.extId)) seen.set(h.extId, h); }\r\n } catch (e) { notes.push(`sapi error ${String(e).slice(0, 80)}`); }\r\n await sleep(SEARCH_DELAY_MS);\r\n }\r\n for (const url of sapiOk === SAPI.length ? [QUERIES[0]] : QUERIES) { // one HTML canary when sapi worked, both when it did not\r\n try {\r\n const { status, text } = await fetchText(url);\r\n if (status !== 200 || !text.includes(\"cl-static-search-result\")) { failedQueries++; notes.push(`search http ${status} (${text.length}b)`); }\r\n else { const hits = parseSearch(text); if (!sapiOk) stats.fetched += hits.length; for (const h of hits) if (!seen.has(h.extId)) seen.set(h.extId, h); }\r\n } catch (e) { failedQueries++; notes.push(`search error ${String(e).slice(0, 80)}`); }\r\n await sleep(SEARCH_DELAY_MS);\r\n }\r\n if (sapiOk) failedQueries = 0; // sapi delivered the inventory; an HTML canary failure must not block the missed counter\r\n\r\n const ids = [...seen.keys()];\r\n const known = new Set(), skipped = new Set();\r\n const skip = (id: string, reason: string) => sqlite.execute({ sql: `insert or replace into skips (source, external_id, reason, ts) values ('craigslist', ?, ?, ?)`, args: [id, reason, new Date().toISOString()] });\r\n for (let i = 0; i < ids.length; i += 50) {\r\n const chunk = ids.slice(i, i + 50); const ph = chunk.map(() => \"?\").join(\",\");\r\n const r = await sqlite.execute({ sql: `select external_id from listings where source='craigslist' and external_id in (${ph})`, args: chunk });\r\n for (const row of r.rows as any[]) known.add(String(row.external_id));\r\n const sk = await sqlite.execute({ sql: `select external_id from skips where source='craigslist' and external_id in (${ph})`, args: chunk });\r\n for (const row of sk.rows as any[]) skipped.add(String(row.external_id));\r\n }\r\n // refresh known rows: seen again -> last_seen today, missed 0; price changes go through upsert so the trail records them\r\n const now = today();\r\n for (const id of known) {\r\n const h = seen.get(id)!;\r\n const cur = await sqlite.execute({ sql: `select rowid_pk, price, vin, year, gen, trans, body, miles, title, seller, loc, lat, lon from listings where source='craigslist' and external_id=?`, args: [id] });\r\n const row: any = cur.rows[0]; if (!row) continue;\r\n if (h.price != null && h.price >= 1000 && Number(row.price) !== h.price) {\r\n const r = await upsertListing({ vin: row.vin, year: row.year, gen: row.gen, trans: row.trans, body: row.body, miles: row.miles, price: h.price, title: row.title, seller: row.seller, loc: row.loc, lat: row.lat, lon: row.lon,\r\n source: \"craigslist\", externalId: id, url: h.url, notes: `price now $${h.price}` }, { push: true });\r\n stats.updated++; if (r.pushed) stats.pushed++;\r\n } else await sqlite.execute({ sql: `update listings set last_seen=?, missed=0 where rowid_pk=?`, args: [now, row.rowid_pk] });\r\n }\r\n\r\n let details = 0;\r\n for (const id of ids) {\r\n if (known.has(id) || skipped.has(id)) continue;\r\n if (details >= MAX_DETAILS_PER_RUN || Date.now() - started > TIME_BUDGET_MS) { notes.push(\"detail cap/time budget hit; remainder next poll\"); break; }\r\n const h = seen.get(id)!;\r\n if (!CORVETTE_TITLE_RE.test(h.title) && OTHER_MAKE_RE.test(h.title)) { await skip(id, \"title\"); continue; } // no detail fetch for Mustangs that mention a Corvette; bare titles still get one\r\n if (h.price != null && (h.price < PRICE_MIN || h.price > PRICE_MAX)) { await skip(id, `price ${h.price}`); continue; }\r\n const ty = Number((h.title.match(/\\b(19[5-9]\\d|20[0-2]\\d)\\b/) || [])[1]); // a title year outside the window skips the detail fetch (C3s in the price-band query)\r\n if (ty && (ty < YEAR_MIN || ty > YEAR_MAX)) { await skip(id, `title year ${ty}`); continue; }\r\n const sapiDist = distFrom16105(h.lat, h.lon);\r\n if (sapiDist != null && sapiDist > MAX_INGEST_MI) { await skip(id, `dist ${sapiDist}`); continue; } // sapi coordinates: no detail fetch for cars beyond ~600 drive mi\r\n details++;\r\n try {\r\n const { status, text } = await fetchText(h.url);\r\n if (status !== 200 || !text.includes(\"postingbody\")) { notes.push(`detail ${id} http ${status}`); await sleep(DETAIL_DELAY_MS); continue; }\r\n const d = parseDetail(text);\r\n const allText = [d.title, d.makemodel, Object.entries(d.attrs).map(([k, v]) => `${k}: ${v}`).join(\" | \"), d.body_text].filter(Boolean).join(\" \\n \");\r\n const vin = findVin(d.vin || \"\") || findVin(allText);\r\n const miles = d.miles ?? inferMiles(d.body_text);\r\n const year = d.year ?? inferYear(h.title) ?? inferYear(d.title);\r\n const price = d.price ?? h.price;\r\n const a = accept({ title: `${d.title} ${d.makemodel} ${d.attrs.important || \"\"}`, titleFromSearch: h.title, year, price, miles: miles ?? h.miles ?? null, vin });\r\n if (!a.ok) { await skip(id, a.reason!); notes.push(`skip ${id}: ${a.reason}`); await sleep(DETAIL_DELAY_MS); continue; }\r\n const far = distFrom16105(d.lat ?? h.lat, d.lon ?? h.lon); // CL enforces the radius loosely (Providence RI showed up in a 350 mi search)\r\n if (far != null && far > MAX_INGEST_MI) { await skip(id, `dist ${far}`); notes.push(`skip ${id}: ${far} mi`); await sleep(DETAIL_DELAY_MS); continue; }\r\n const site = d.area || h.site || null;\r\n const outOfRegionSite = !!site && !IN_RADIUS_CL_SITES.has(site); // e.g. honolulu reply host with a Toms River pin\r\n const category = d.category || (h.owner === true ? \"cto\" : h.owner === false ? \"ctd\" : null);\r\n const sellerDefault: Seller = category === \"ctd\" ? \"dealer-small\" : \"private\";\r\n const seller = category === \"cto\" ? (inferSeller(allText, \"private\") === \"dealer-franchise\" ? \"dealer-franchise\" : \"private\") : inferSeller(allText, sellerDefault);\r\n const trans = d.trans !== \"unknown\" ? d.trans : inferTrans(allText);\r\n const body = d.body !== \"unknown\" ? d.body : inferBody(allText);\r\n const title = d.titleStatus !== \"unknown\" ? d.titleStatus : inferTitle(allText);\r\n const loc = [(d.mapaddress || \"\").trim(), d.area ? `CL ${d.area}` : \"\"].filter(Boolean).join(\" - \");\r\n const noteBits = [`CL: ${d.title}`.slice(0, 100), category === \"ctd\" ? \"dealer post\" : category === \"cto\" ? \"by owner\" : \"\", d.paint ? `paint ${d.paint}` : \"\", d.condition ? `cond ${d.condition}` : \"\", d.posted ? `posted ${d.posted.slice(0, 10)}` : \"\", outOfRegionSite ? `posted from the ${site} site` : \"\"].filter(Boolean);\r\n const r = await upsertListing({\r\n vin, year, trim: inferTrim(`${d.title} ${h.title} ${d.makemodel}`), trans, body, miles: miles ?? h.miles ?? null, price, title, seller, loc, lat: d.lat ?? h.lat, lon: d.lon ?? h.lon,\r\n source: \"craigslist\", externalId: id, url: h.url, notes: noteBits.join(\" | \"), raw: allText.slice(0, 6000), text: allText, postedAt: d.posted || h.posted || null, outOfRegionSite,\r\n }, { push: true });\r\n if (r.action === \"inserted\") stats.inserted++; else stats.updated++;\r\n if (r.pushed) stats.pushed++;\r\n // expansion-plan fix 3: a hit that merged into another row (VIN or fuzzy match, both posts live) must not be re-fetched every run\r\n if (r.action !== \"inserted\") { const tracked = await sqlite.execute({ sql: `select external_id from listings where rowid_pk=?`, args: [r.rowid] }); const ext = String((tracked.rows[0] as any)?.external_id || \"\"); if (ext && ext !== id) await skip(id, `merged into ${r.id}`); }\r\n } catch (e) { notes.push(`detail ${id} error ${String(e).slice(0, 80)}`); }\r\n await sleep(DETAIL_DELAY_MS);\r\n }\r\n\r\n // missed counter only when every search succeeded (a CL block must not look like delistings); 3 misses -> dead\r\n if (failedQueries === 0 && ids.length > 0) {\r\n const m = await applyMissed(\"craigslist\", new Set(ids));\r\n if (m.inc || m.dead) notes.push(`missed +${m.inc}, dead ${m.dead}`);\r\n await sqlite.execute({ sql: `delete from skips where source='craigslist' and ts < ?`, args: [new Date(Date.now() - 60 * 86400000).toISOString()] });\r\n }\r\n const summary = `${ids.length} unique hits, ${known.size} known, ${skipped.size} skipped, ${details} detail fetches, ${failedQueries} failed queries, ${Math.round((Date.now() - started) / 1000)}s. ${notes.join(\"; \")}`;\r\n await logPoll(\"craigslist\", failedQueries < QUERIES.length, stats, summary);\r\n console.log(\"craigslist\", stats, summary);\r\n return { ...stats, summary };\r\n}\r\n","deleted",false,"label",[47,24],"cron","00cc23ab-c212-43f5-a7c5-1ba797ecaa18",["D",1789312547277],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","C4/C5 Corvette search pipeline (CL, forums, auctions, comps)","imageUrl","userId","87445237-7d14-45c7-b3a2-72e031f10ec1","pinnedFileId","2b16e0f0-af8b-11f1-8152-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a09786-a61b-74b5-8910-af3116d3de5c","tursoName","00cc23abc21243f5a7c51ba797ecaa18","tursoHostname","00cc23abc21243f5a7c51ba797ecaa18-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789486866837],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_109":105},"org",{"_9":10,"_102":103,"_104":105,"_58":59,"_106":107,"_108":44},"branch",{"_37":92,"_11":93,"_22":30,"_94":48,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":12,"_101":10},"isOwned",79,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Logan","avatar","https://lh3.googleusercontent.com/a/ACg8ocIFxddfJftSiTFZN49YShT3nY7q8GOQ7dXYM2vJ6XkajnQMGA=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_85":-5,"_143":144,"_145":146,"_147":148,"_149":44,"_150":44,"_151":44,"_152":34,"_153":-5,"_154":-7,"_155":-7,"_156":66,"_157":44,"_158":44,"_159":-5,"_160":44,"_161":44,"_162":44,"_163":-5},"ENV",{"_114":115,"_116":117,"_118":93,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138,"_139":140,"_141":142},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]