BrightCat Data TransactIQ — Canadian Real Estate Transaction History

BrightCat Data TransactIQ is the most comprehensive Canadian residential real estate transaction and home sales dataset available on Snowflake Marketplace. Over 5.3 million sold property records nationwide, with weekly updates and over a decade of historical real estate sales data back to 2014.

Every sale event is preserved. A property that sold three times since 2014 has three distinct records, each with the full transaction detail and property profile from that point in time. This is a complete Canadian home sales history, not a latest-sale-only snapshot.

**Transaction Detail**

- Sold price
- Sale-to-list ratio
- Days on market
- Cumulative price change history
- Original list price
- Price per square foot
- Relist tracking and prior listing attempts

Understand how every property moved through the Canadian real estate market before it sold — how long it took, how many price cuts it endured, and whether it had failed listing attempts before the successful sale.

**Full Transaction Timeline**

Track every sale a property has gone through over the past decade-plus:

- How the sold price changed between transactions
- How days on market shifted over time
- How the sale-to-list ratio evolved
- Which properties flip frequently vs. long hold periods
- Complete chain of ownership transitions

**Complete Property Profile With Every Transaction**

Every real estate transaction carries the full property profile from the original listing:

- Building type, storeys, architecture style
- Year built, age of building
- Lot frontage, lot depth, land size
- Floor space, total finished area
- Heating type, heating fuel
- Pool type, pool features
- Fireplace type, fireplace fuel
- Roofing material, exterior finish, flooring
- Parking spaces, parking type
- Zoning, waterfront status, waterfront name
- Annual property taxes
- Community name, community features, amenities nearby
- Fencing, foundation type
- And 80+ additional property data attributes

**National Scale, Historical Depth**

Over a decade of Canadian residential real estate transaction history across all provinces, updated weekly. Analyse home sales trends at the national, provincial, city, or neighbourhood level with consistent data structure throughout.

**Data Quality**

- All property records deduplicated by address and postal code
- Linked through BrightCat Data's universal PROPERTY_ID
- No MLS number dependency — proprietary matchkey system tracks properties through relists, reappearances, and multiple sales
- Accurate linkage even when MLS numbers change

**Use Cases**

- Build automated property valuation models with rich comparable sales data and full repeat-sale history
- Power mortgage underwriting with granular sale-to-list and DOM analysis across multiple transaction cycles
- Train machine learning models on property-level real estate transaction features with decade-plus depth
- Run housing market health diagnostics using relist rates, flip frequency, and price change patterns
- Support portfolio risk assessment with complete transaction timelines per property

**Built For**

Anyone who needs the full story behind a home sale, not just a price and a date. Financial institutions, property valuation teams, insurance underwriters, data science teams, and mortgage lenders who need real estate transaction depth and complete history at national scale.