← back to Rentv 2026
auto-data-snapshot: 2026-08-06T10:21:57 (6 data files) — data/deals-registry.json data/deals.json data/markets.json data/news.json data/ticker.json
f4d659e3bb8623f3c016c42e0e22f7f79c476be3 · 2026-08-06 10:22:25 -0700 · auto-commit-fleet
Files touched
M data/deals-registry.jsonM data/deals.jsonM data/markets.jsonM data/news.jsonM data/ticker.jsonA src/pr/migrations/008_notes.sql
Diff
commit f4d659e3bb8623f3c016c42e0e22f7f79c476be3
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date: Thu Aug 6 10:22:25 2026 -0700
auto-data-snapshot: 2026-08-06T10:21:57 (6 data files) — data/deals-registry.json data/deals.json data/markets.json data/news.json data/ticker.json
---
data/deals-registry.json | 122 ++++++++++++++++++++--------------------
data/deals.json | 2 +-
data/markets.json | 10 ++--
data/news.json | 2 +-
data/ticker.json | 6 +-
src/pr/migrations/008_notes.sql | 39 +++++++++++++
6 files changed, 110 insertions(+), 71 deletions(-)
diff --git a/data/deals-registry.json b/data/deals-registry.json
index 8f3a5c27..1c9e4693 100644
--- a/data/deals-registry.json
+++ b/data/deals-registry.json
@@ -1,5 +1,5 @@
{
- "updated_at": "2026-08-06T16:57:02.047Z",
+ "updated_at": "2026-08-06T17:17:04.781Z",
"total": 47,
"deals": {
"34086": {
@@ -808,8 +808,8 @@
"summary": "Eagle Partners and The Vistria Group have purchased Crystal View Apartments, a 402-unit apartment mixed-income workforce housing community located in Garden Grove, for $132. 5 mil, or $329."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 1,
"history": [
{
@@ -934,8 +934,8 @@
"summary": "Intercontinental Real Estate Corporation has acquired Lakeland Town Center, a 125. 2k sf grocery-anchored retail center located in the Seattle/Tacoma suburb of Auburn, WA, for $69."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 2,
"history": [
{
@@ -1016,8 +1016,8 @@
"summary": "Meta Housing, with R. D."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 2,
"history": [
{
@@ -1098,8 +1098,8 @@
"summary": "In a major Arizona multifamily trade, Camden Property Trust acquired The Tyler, a 320-unit multifamily community located in the Agritopia master-planned community in Gilbert. The asset was sold by StreetLights Residential in a deal worth $124."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 1,
"history": [
{
@@ -1147,8 +1147,8 @@
"summary": "Shorenstein has closed on a Bay Area office buy, acquiring 550 Allerton, a 76. 6k sf, Class A property in the heart of Downtown Redwood City."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 2,
"history": [
{
@@ -1229,8 +1229,8 @@
"summary": "CentrePoint Properties has purchased a three-property Colorado retail portfolio, including Cottonwood Square in Parker, Bristol Pointe in Aurora and Foothill Green in Littleton. The assets were sold by Western Centers Inc in a $30."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 3,
"history": [
{
@@ -1344,8 +1344,8 @@
"summary": "A 90. 5k sf, industrial distribution facility in the city of Carson traded hands in a $23 mil ($254/sf) transaction."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 2,
"history": [
{
@@ -1426,8 +1426,8 @@
"summary": "MG Properties has acquired Tupelo Alley, a 188-unit mixed use apartment community in Portland, OR. Located at 3850 N."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 1,
"history": [
{
@@ -1475,8 +1475,8 @@
"summary": "Tailwind Investment Group has acquired two multifamily properties totaling 419 units in Sacramento for a combined price of $65 mil. The properties include Bent Tree Apartments (208 units) and California Place Apartments (211 units)."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 1,
"history": [
{
@@ -1524,8 +1524,8 @@
"summary": "Mosaic, a six building, 148. 4k sf retail portfolio spanning multiple city blocks in Downtown Long Beach, traded hands in a recent $30 mil ($202/sf transaction."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 3,
"history": [
{
@@ -1634,8 +1634,8 @@
"summary": "RENTV. com - Commercial real estate news and property information window."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 3,
"history": [
{
@@ -1744,8 +1744,8 @@
"summary": "A joint venture between Phoenix Capital Management and P. B."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 3,
"history": [
{
@@ -1854,8 +1854,8 @@
"summary": "In a Fresno multifamily trade, Maroa Park Apartments, a 248-unit community, was purchased by a private investor for $44 mil ($177. 4k/unit)."
},
"first_seen": "2026-07-23T04:07:13.798Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 65,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 66,
"revisions": 3,
"history": [
{
@@ -1969,8 +1969,8 @@
"summary": "Velo3D has leased a 288. 7k sf facility in Livermore, CA in a $55."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 2,
"history": [
{
@@ -2051,8 +2051,8 @@
"summary": "SFF Realty recently acquired a four-story, 104. 5k sf, Class A office/R&D building in Sunnyvale."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 3,
"history": [
{
@@ -2166,8 +2166,8 @@
"summary": "Granite Towers Equity Group purchased Hathaway at Willow Bend, a 229-unit multifamily community located at 2525 Preston Road in Plano, TX. The property was sold by S2 Capital."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 2,
"history": [
{
@@ -2243,8 +2243,8 @@
"summary": "Building 1 at CapRock Central Point III, a four-building, 2. 7 msf speculative industrial development in Visalia, has been fully leased to an undisclosed global corporate tenant."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 3,
"history": [
{
@@ -2353,8 +2353,8 @@
"summary": "A 782. 8k sf industrial facility in Frederickson, WA traded hands in a recent $174 mil ($222/sf) transaction."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 2,
"history": [
{
@@ -2435,8 +2435,8 @@
"summary": "Clearwater at Riverpark, a 136-unit Class A independent living community in Oxnard, was acquired by an unnamed S&P 500 company focused on senior housing. Built in 2018 within the master-planned Riverpark development, Clearwater at Riverpark is located at 750 Clyde River Place."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 4,
"history": [
{
@@ -2573,8 +2573,8 @@
"summary": "Atlas Peakview, a recently completed 330-unit multifamily community in the Denver suburb of Centennial, has been refinanced with a new $81 mil short-term, first-mortgage loan provided by Mesa West Capital. The property, delivered in 2025, is owned by a joint venture between The Dinerstein Companies and PGIM."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 2,
"history": [
{
@@ -2655,8 +2655,8 @@
"summary": "A 28-unit coastal multifamily investment property located along Santa Monicas Ocean Avenue corridor sold for $23. 46 mil, with the buyer assuming approximately $2."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 3,
"history": [
{
@@ -2770,8 +2770,8 @@
"summary": "Longpoint Partners has purchased Eastpoint I & II, a two-building, 136. 6k sf institutional-quality industrial business park in the highly sought-after Chandler submarket of Phoenix."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 3,
"history": [
{
@@ -2885,8 +2885,8 @@
"summary": "New York-based Sentinel Real Estate has acquired Talavera, a 293-unit apartment community in Folsom, CA. We�re told that Talavera was the first asset to become available in the Folsom submarket in four years."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 1,
"history": [
{
@@ -2934,8 +2934,8 @@
"summary": "A joint venture between PCCP and Stonemont has acquired a 38-asset, 5. 9 msf industrial portfolio diversified across 14 U."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 2,
"history": [
{
@@ -3016,8 +3016,8 @@
"summary": "GO Industrial has broken ground on a 1. 1 msf industrial building in Phoenix."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 3,
"history": [
{
@@ -3126,8 +3126,8 @@
"summary": "Gemdale USA has obtained a $90 mil mezzanine bridge loan for Aperture Del Mar, a newly constructed, 538k sf Class A life science campus in San Diego. The financing, provided by Breakthrough Properties and Tishman Speyer, will be used to refinance an existing loan."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 2,
"history": [
{
@@ -3208,8 +3208,8 @@
"summary": "Step Up Housing recently acquired two California multifamily communities totaling 406 units -- Copper Creek, a 268-unit community in Sacramento, and Terramonte at Foothill, a 138-unit community in Pomona for a combined price of $91. 35 mil."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 2,
"history": [
{
@@ -3290,8 +3290,8 @@
"summary": "San Diego-based ColRich acquired Avia 266, a 267-unit multifamily community in Mesa, AZ, in a $52. 4 mil ($196k/unit) transaction, including the assumption of an existing HUD loan."
},
"first_seen": "2026-08-05T19:53:22.976Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 64,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 65,
"revisions": 1,
"history": [
{
@@ -3339,8 +3339,8 @@
"summary": "In a major institutional multifamily trade, a BlackRock-managed vehicle acquired an 11-property, 3,620-unit residential portfolio in Southern California for $1. 625 bil ($449k/unit)."
},
"first_seen": "2026-08-06T00:14:52.638Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 51,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 52,
"revisions": 3,
"history": [
{
@@ -3454,8 +3454,8 @@
"summary": "OC-based investor EEW Holdings LLC has purchased Bernardo Executive Center, a three-building, 173. 1k sf office property in Rancho Bernardo, for $26."
},
"first_seen": "2026-08-06T00:14:52.638Z",
- "last_seen": "2026-08-06T16:57:02.047Z",
- "seen_count": 51,
+ "last_seen": "2026-08-06T17:17:04.781Z",
+ "seen_count": 52,
"revisions": 3,
"history": [
{
diff --git a/data/deals.json b/data/deals.json
index 814ff5ca..6080ebac 100644
--- a/data/deals.json
+++ b/data/deals.json
@@ -1,6 +1,6 @@
{
"source": "rentv.com — live deal listings",
- "fetched_at": "2026-08-06T16:57:02.047Z",
+ "fetched_at": "2026-08-06T17:17:04.781Z",
"count": 30,
"deals": [
{
diff --git a/data/markets.json b/data/markets.json
index 631a3e29..4bdfa050 100644
--- a/data/markets.json
+++ b/data/markets.json
@@ -1,5 +1,5 @@
{
- "fetched_at": "2026-08-06T16:57:00.270Z",
+ "fetched_at": "2026-08-06T17:17:03.070Z",
"source": "Yahoo Finance — live (CBOE Treasury yields, Dow Jones/MSCI REIT indices)",
"curve": [
{
@@ -42,8 +42,8 @@
"reits": [
{
"label": "DJ U.S. Real Estate",
- "value": "392.99",
- "change_pct": -0.86,
+ "value": "392.53",
+ "change_pct": -0.97,
"dir": "down"
},
{
@@ -54,8 +54,8 @@
},
{
"label": "Vanguard REIT ETF (VNQ)",
- "value": "$98.07",
- "change_pct": -0.86,
+ "value": "$97.90",
+ "change_pct": -1.03,
"dir": "down"
}
],
diff --git a/data/news.json b/data/news.json
index ffa786d3..c8064f1b 100644
--- a/data/news.json
+++ b/data/news.json
@@ -1,6 +1,6 @@
{
"source": "rentv.com — live",
- "fetched_at": "2026-08-06T16:56:59.905Z",
+ "fetched_at": "2026-08-06T17:17:02.686Z",
"count": 30,
"items": [
{
diff --git a/data/ticker.json b/data/ticker.json
index 1c144e46..149d3a75 100644
--- a/data/ticker.json
+++ b/data/ticker.json
@@ -1,5 +1,5 @@
{
- "fetched_at": "2026-08-06T16:57:00.240Z",
+ "fetched_at": "2026-08-06T17:17:03.040Z",
"la_office_vac": {
"label": "LA OFFICE VAC",
"value": "23.1%",
@@ -14,8 +14,8 @@
},
"cre_index": {
"label": "CRE INDEX",
- "value": "4,130",
- "change_pct": -0.86,
+ "value": "4,125",
+ "change_pct": -0.97,
"dir": "down",
"source": "Dow Jones U.S. Real Estate"
},
diff --git a/src/pr/migrations/008_notes.sql b/src/pr/migrations/008_notes.sql
new file mode 100644
index 00000000..9031abb8
--- /dev/null
+++ b/src/pr/migrations/008_notes.sql
@@ -0,0 +1,39 @@
+-- User notes: timestamped, author-stamped notes attachable to ANY entity
+-- (organization / person / property / broker / deal / …). Generic by (entity_type, entity_id)
+-- so a new record type just works. Tenant-scoped + RLS-guarded like every entity table.
+CREATE TABLE IF NOT EXISTS pr_notes (
+ id bigserial PRIMARY KEY,
+ tenant_id bigint NOT NULL DEFAULT 1 REFERENCES pr_tenants(id) ON DELETE CASCADE,
+ entity_type text NOT NULL, -- organization|person|property|broker|deal|…
+ entity_id bigint NOT NULL,
+ body text NOT NULL,
+ author_user_id bigint REFERENCES pr_users(id) ON DELETE SET NULL,
+ author_name text, -- denormalized (email/name) so a deleted user still shows
+ pinned boolean NOT NULL DEFAULT false,
+ created_at timestamptz NOT NULL DEFAULT now(),
+ updated_at timestamptz NOT NULL DEFAULT now()
+);
+CREATE INDEX IF NOT EXISTS pr_notes_entity_idx ON pr_notes (tenant_id, entity_type, entity_id, created_at DESC);
+
+-- updated_at trigger
+DROP TRIGGER IF EXISTS pr_notes_touch ON pr_notes;
+CREATE TRIGGER pr_notes_touch BEFORE UPDATE ON pr_notes FOR EACH ROW EXECUTE FUNCTION pr_touch_updated_at();
+
+-- RLS (same tenant policy shape as migration 007)
+DO $$
+DECLARE cond text;
+BEGIN
+ cond := $c$(
+ NULLIF(current_setting('app.tenant_id', true), '') IS NULL
+ OR current_setting('app.tenant_id', true) = '0'
+ OR tenant_id = NULLIF(current_setting('app.tenant_id', true), '')::bigint
+ )$c$;
+ EXECUTE 'ALTER TABLE pr_notes ENABLE ROW LEVEL SECURITY';
+ EXECUTE 'ALTER TABLE pr_notes FORCE ROW LEVEL SECURITY';
+ EXECUTE 'DROP POLICY IF EXISTS pr_notes_tenant_pol ON pr_notes';
+ EXECUTE format('CREATE POLICY pr_notes_tenant_pol ON pr_notes USING %s WITH CHECK %s', cond, cond);
+ IF EXISTS (SELECT 1 FROM pg_roles WHERE rolname='pr_app') THEN
+ EXECUTE 'GRANT SELECT, INSERT, UPDATE, DELETE ON pr_notes TO pr_app';
+ EXECUTE 'GRANT USAGE, SELECT ON SEQUENCE pr_notes_id_seq TO pr_app';
+ END IF;
+END $$;
← 2837beed Split nav into TWO hamburgers: upper-left (Explore+Regions)
·
back to Rentv 2026
·
fix(news-dedup): newsSig amount normalization strips commas 14e137d5 →