899K+ confirmed sold events across Canada since 2014. Each record captures the full transaction history at the property level, with complete listing cycle coverage — 200+ columns.
Each record represents one property with its full sold history across every listing cycle. The schema is delivered via Snowflake Marketplace, Secure Data Share, MCP connector, or structured file export.
| Field | Type | Description |
|---|---|---|
address | Text | Street address of the property |
city | Text | City name |
prov | Text | Province (two-letter code) |
pcode | Text | Canadian postal code |
fulladdress | Text | Complete formatted address |
street_number | Text | Street number component |
street_name | Text | Street name component |
street_type | Text | Street suffix (St, Ave, Blvd, etc.) |
street_dir | Text | Directional suffix |
community_name | Text | Real estate community name |
neighbourhood_name | Text | Neighbourhood designation |
latitude | Text | Geocoded latitude |
longitude | Text | Geocoded longitude |
| Field | Type | Description |
|---|---|---|
status | Text | Listing status for this cycle |
listed_date | Text | Date the property was first listed in this cycle |
listed_price | Text | Asking price in this cycle |
sold_price | Text | Final sold price for this cycle (if sold) |
end_date | Text | Date the listing closed or expired |
| Field | Type | Description |
|---|---|---|
price | Text | Most recent price recorded for the property |
| Field | Type | Description |
|---|---|---|
building_type | Text | Building classification (e.g., House, Condo, Townhouse) |
property_type | Text | Property type classification |
architecture_style | Text | Architectural style |
style | Text | General property style |
other_style | Text | Additional style descriptor |
split_level_style | Text | Split level configuration |
storeys | Text | Number of stories or levels |
beds | Text | Number of bedrooms |
baths | Text | Number of bathrooms |
bathrooms_partial | Text | Number of partial bathrooms |
built_in | Text | Year built |
age_of_building | Text | Age classification |
construction_status | Text | Construction state |
title | Text | Title/ownership type |
zoning_id | Text | Zoning designation |
zoning_description | Text | Zoning description |
transaction_type | Text | Sale or rental indicator |
| Field | Type | Description |
|---|---|---|
land_size | Text | Lot size (raw) |
land_depth | Text | Lot depth |
frontage | Text | Street frontage |
floor_space | Text | Floor space |
total_finished_area | Text | Total finished interior area |
exterior_building_size | Text | Exterior dimensions |
ceiling_type | Text | Ceiling type |
flooring | Text | Flooring materials |
| Field | Type | Description |
|---|---|---|
features | Text | General feature list |
community_features | Text | Community amenities |
building_amenities | Text | Building amenities |
amenities_nearby | Text | Nearby amenities |
landscape_features | Text | Landscape features |
structures | Text | Additional structures on property |
storage | Text | Storage features |
fencing | Text | Fencing description |
property_view | Text | Property view (e.g., lake, mountain, city) |
waterfront | Text | Waterfront indicator |
waterfront_name | Text | Body of water name (if waterfront) |
surface_water | Text | Adjacent water feature |
farm_type | Text | Farm classification (if applicable) |
fixtures_included | Text | Fixtures included in sale |
appliances_included | Text | Appliances included in sale |
easements | Text | Easement details |
rights | Text | Property rights |
sign_type | Text | Signage type |
| Field | Type | Description |
|---|---|---|
heating | Text | Heating system |
heating_type | Text | Heating type classification |
heating_fuel | Text | Heating fuel source |
fireplace | Text | Fireplace indicator |
fireplace_type | Text | Fireplace type |
fireplace_fuel | Text | Fireplace fuel source |
pool_type | Text | Pool type |
pool_features | Text | Pool features |
utility_sewer | Text | Sewer/septic system |
utility_type | Text | Utility type classification |
utility_hydro | Text | Hydro/electrical service |
utility_communications | Text | Communications infrastructure |
water | Text | Water source |
roof | Text | Roof details |
roofing_material | Text | Roofing material |
foundation_type | Text | Foundation type |
exterior_finish | Text | Exterior finish material |
fire_protection | Text | Fire protection systems |
road_type | Text | Road access type |
access | Text | Property access |
rental_equipment | Text | Rental equipment on premises |
| Field | Type | Description |
|---|---|---|
total_parking_spaces | Text | Total parking spaces |
any_parking_spaces | Text | Parking availability |
parking_type | Text | Parking type |
| Field | Type | Description |
|---|---|---|
maintenance_fees | Text | Monthly maintenance or condo fees |
maintenance_fees_include | Text | What maintenance fees include |
maintenance_management_company | Text | Property management company |
annual_property_taxes | Text | Annual property taxes |
operating_since | Text | Commercial operation date (if applicable) |