Add recent_commercial_deals view — closed commercial deals feed (classified commercial parcels x sale events, >250k, 18mo) for the RENTV news pipeline. Surfaces $100M+ deals (Brickell offices, Collins Ave hotels)

06c2d3a6ddfff7773ad0e46b9cab81b01362a460 · 2026-07-31 08:10:32 -0700 · steve@designerwallcoverings.com

Files touched

A db/views/recent_commercial_deals.sql

Diff

commit 06c2d3a6ddfff7773ad0e46b9cab81b01362a460
Author: steve@designerwallcoverings.com <steve@designerwallcoverings.com>
Date:   Fri Jul 31 08:10:32 2026 -0700

    Add recent_commercial_deals view — closed commercial deals feed (classified commercial parcels x sale events, >250k, 18mo) for the RENTV news pipeline. Surfaces $100M+ deals (Brickell offices, Collins Ave hotels)
---
 db/views/recent_commercial_deals.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

diff --git a/db/views/recent_commercial_deals.sql b/db/views/recent_commercial_deals.sql
new file mode 100644
index 0000000..811cd1a
--- /dev/null
+++ b/db/views/recent_commercial_deals.sql
@@ -0,0 +1,16 @@
+CREATE OR REPLACE VIEW recent_commercial_deals AS
+ SELECT pe.event_date AS sale_date,
+    pe.amount AS sale_price,
+    cp.ctype,
+    cp.address,
+    cp.city,
+    cp.county_fips,
+    r.name AS county_name,
+    cp.sqft,
+    cp.year_built,
+    pe.doc_number
+   FROM parcel_event pe
+     JOIN commercial_parcel cp ON cp.county_fips = pe.county_fips AND cp.ain = pe.source_id
+     LEFT JOIN region r ON r.fips = pe.county_fips AND r.region_type = 'county'::text
+  WHERE pe.event_type = 'sale'::text AND pe.amount > 250000::numeric AND pe.event_date >= (CURRENT_DATE - '1 year 6 mons'::interval)
+  ORDER BY pe.event_date DESC, pe.amount DESC;

← ed1e697 Add Alameda CA/Oakland (1460, descriptive) + Oregon counties · back to Nationalrealestate · Fix column resize on markets/brokers grids (adjust column no 3dfd37e →