Property data fields for banking and mortgage workflows
Specific BrightCat fields and products relevant to this vertical. Every field listed below is queryable through Snowflake SQL, MCP natural language, or available in the weekly flat-file delivery.
| Signal | Product | Field / Logic | What it tells you |
|---|---|---|---|
| Pre-mover signal | Listings | listing_status = NEW | Borrower about to sell collateral — pre-qualify for new mortgage |
| Price change tracking | Listings | asking_price, pricechangeamt, pricechangepct | Real-time collateral value movement |
| Sold price verification | Sold | sold_price, sold_date, listing_price_at_sale | Actual transaction price vs appraisal |
| Repeat-sale HPI pairs | Core | 194K+ verified pairs, both dates and prices | AVM training data for portfolio valuation |
| Days on market | Listings | days_on_market, cum_dom | Market liquidity indicator for collateral properties |
| Rental conversion | Listings + Rentals | Sale → rent within 180 days | Investment property detection in mortgage portfolio |
Sample query
-- Mortgage portfolio: detect listed collateral properties
SELECT m.loan_id, m.borrower_name, m.collateral_address,
m.outstanding_balance, m.ltv_ratio,
b.asking_price, b.days_on_market, b.pricechangepct
FROM mortgage_portfolio m
JOIN BRIGHTCAT_LISTINGS.PRODUCT.listings_weekly b
ON m.postal_code = b.postal_code
AND m.street_number = b.street_number
WHERE b.listing_status IN ('NEW', 'PRICE CHANGED')
AND b.file_date = (SELECT MAX(file_date)
FROM BRIGHTCAT_LISTINGS.PRODUCT.listings_weekly);Abstract example. Exact column names provided with access provisioning.