PropRaven CRE

PropRaven CRE is the commercial slice — every commercial, industrial, multifamily, mixed-use, and small multifamily parcel — pre-joined to the canonical owner graph and intelligence signals. The same PRPV_* identifiers as the rest of the catalog so investigations port cleanly into your downstream workflows.

• 11.05M parcels filtered to property_type_class IN ('COMMERCIAL','INDUSTRIAL','MF','MIXED','MF_SMALL').
• Property attributes (year built, building area, units), tax history, owner records.
• Edge graph: owner-to-parcel ownership edges.
• Pre-computed signals: PARCEL_ABSENTEE, PARCEL_INSTITUTIONAL_OWNED, PARCEL_RECENT_TRANSFER, OWNER_PORTFOLIO.

• Acquisitions sourcing: target institutional-owned MF + commercial in active CBSAs.
• Owner-portfolio mapping: surface every CRE asset held by a canonical entity across states.
• Recent-transfer tracking: monitor CRE deal velocity per market, with confidence-tiered last-sale data.
• Cohort baselining: compare per-MSA CRE inventory mix and institutional share.

SELECT
  o.name_normalized AS owner,
  op.primary_state,
  op.parcel_count,
  ROUND(op.total_assessed_value / 1e6, 1) AS total_av_m,
  o.entity_type
FROM PROPRAVEN_CRE.CRE.OWNER o
JOIN PROPRAVEN_CRE.CRE.OWNER_PORTFOLIO op USING (prpv_owner_id)
JOIN PROPRAVEN_CRE.CRE.PARCEL_INSTITUTIONAL_OWNED pio USING (prpv_owner_id)
WHERE pio.is_institutional_owned = TRUE
  AND op.parcel_count >= 25
ORDER BY op.total_assessed_value DESC
LIMIT 50;