[object Object]

← back to Commercialrealestate

auto-save: 2026-07-07T08:59:49 (2 files) — scripts/export-residential-snapshots.js scripts/serve.js

809771f99441272ab74b7bb77105c175bd2dd51c · 2026-07-07 08:59:55 -0700 · Steve Abrams

Files touched

Diff

commit 809771f99441272ab74b7bb77105c175bd2dd51c
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jul 7 08:59:55 2026 -0700

    auto-save: 2026-07-07T08:59:49 (2 files) — scripts/export-residential-snapshots.js scripts/serve.js
---
 scripts/export-residential-snapshots.js | 2 +-
 scripts/serve.js                        | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/scripts/export-residential-snapshots.js b/scripts/export-residential-snapshots.js
index 4b6c443..ed700b4 100644
--- a/scripts/export-residential-snapshots.js
+++ b/scripts/export-residential-snapshots.js
@@ -33,7 +33,7 @@ const WHERE = `WHERE price > 0 AND (status='active' OR off_market_at > now() - i
     SELECT id, address, city, zip, price, hoa, beds, baths, sqft, year_built, project_name,
            warrantable_status, warrant_source, warrant_signals, broker_name, firm_name, source, created_at,
            status, off_market_at, disposition, sold_price, sold_date, last_seen,
-           days_on_market, listed_date, market_status, prev_market_status
+           days_on_market, listed_date, market_status, prev_market_status, prev_price, price_changed_at
       FROM condo_card ${WHERE} ORDER BY (status='active') DESC, created_at DESC, price DESC`)).rows;
   fs.writeFileSync(path.join(ROOT, 'data', 'condos-redfin.json'), JSON.stringify({
     meta: { source: 'Redfin LA County condos — feed-first (gis-csv), local Chrome',
diff --git a/scripts/serve.js b/scripts/serve.js
index dee7727..896d245 100644
--- a/scripts/serve.js
+++ b/scripts/serve.js
@@ -311,7 +311,7 @@ app.get('/api/residential', async (req, res) => {
         `SELECT id, address, city, zip, price, beds, baths, sqft, year_built,
                 firm_name, broker_name, source, lat, lng,
                 status, off_market_at, disposition, sold_price, sold_date, created_at,
-                days_on_market, listed_date, market_status, prev_market_status
+                days_on_market, listed_date, market_status, prev_market_status, prev_price, price_changed_at
            FROM sfr WHERE price > 0 AND (status='active' OR off_market_at > now() - interval '180 days')
           ORDER BY (status='active') DESC, created_at DESC, price DESC LIMIT $1`, [limit]);
       if (r.rows.length) return res.json({ sfr: r.rows, label: SFR_LABEL, source: 'db' });

← 18bf3fc auto-save: 2026-07-07T08:59:35 (4 files) — scripts/export-re  ·  back to Commercialrealestate  ·  residential: price-drop tracking — 💸 Price Cut chip + repor d8dc3ea →