PropRaven SFR

PropRaven SFR is a pre-filtered residential cohort — every U.S. SFR, small multifamily (≤4 units), condo, and mobile-home parcel — with the signals SFR investors actually use: absentee owner classification, institutional ownership flag, and recent transfer detection.

Every property uses the same stable PRPV_* identifiers as the rest of the PropRaven catalog, so data ports cleanly from a discovery query in SFR straight into your existing portfolio workflows.

• 183M residential parcels filtered to property_type_class IN ('SFR','MF_SMALL','CONDO','MOBILE').
• Property attributes: year built, beds, baths, building area, units, owner-occupancy.
• Tax history: latest year + multi-year trail.
• Permits: building-permit count, recent activity.
• Resolved owners: 27.17M canonical entities with entity-type classification.
• Edge graph: ownership edges to canonical entities.
• Pre-computed signals: absentee, institutional flag, recent transfer, owner portfolio.

• Acquisition pipeline: filter to absentee + out-of-state + last sale > 5 years for off-market lead lists.
• Institutional portfolio tracking: watch SFR funds (e.g., Invitation Homes, AMH, Tricon) expand state-by-state via canonical entity rollups.
• Wholesale targeting: blend distress signals from the Ontology share with SFR cohort for high-intent prospects.
• Market reports: per-MSA absentee % trend, institutional share growth, recent-transfer velocity.

SELECT
  p.prpv_parcel_id,
  pr.year_built,
  pr.bedroom_count,
  pr.bathroom_count,
  pa.last_sale_date,
  pa.last_sale_price,
  ab.absentee_class
FROM PROPRAVEN_SFR.SFR.PARCEL p
JOIN PROPRAVEN_SFR.SFR.PROPERTY pr USING (prpv_parcel_id)
JOIN PROPRAVEN_SFR.SFR.PARCEL_ABSENTEE ab USING (prpv_parcel_id)
LEFT JOIN PROPRAVEN_SFR.SFR.PARCEL_RECENT_TRANSFER pa USING (prpv_parcel_id)
WHERE p.state_fips = '13'                    -- Georgia
  AND pr.property_type_class = 'SFR'
  AND ab.is_absentee = TRUE
  AND ab.absentee_class IN ('OUT_OF_COUNTY', 'OUT_OF_STATE')
  AND ab.confidence_score >= 0.95
  AND (pa.days_since_sale IS NULL OR pa.days_since_sale > 1825)
LIMIT 500;