Weekly lifecycle tracking across 5.8M+ Canadian residential properties. 135+ public fields covering property identifiers, listing status, pricing history, attributes, and detected lifecycle signals.
Each record represents one property tracked across its full listing lifecycle. Fields are organised into logical groups below. 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 |
mailable | Text | Postal deliverability indicator |
streetnumber | Text | Street number component |
streetname | Text | Street name component |
streettype | Text | Street suffix (St, Ave, Blvd, etc.) |
streetdir | Text | Directional suffix (N, S, E, W) |
suite | Text | Unit, apartment, or suite number |
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 | Current listing lifecycle status (NEW, STILL, PRICE_CHANGED, RELISTED, DROPPED, SOLD) |
newdate | Text | Date property was first classified as NEW |
first_seen_date | Text | Earliest date this property appeared in any weekly snapshot |
last_seen_date | Text | Most recent date this property appeared in a weekly snapshot |
solddate | Text | Date of most recent sold event |
relisteddate | Text | Date of most recent relist event |
timeslisted | Integer | Total number of times the property has been listed |
times_sold | Integer | Total number of confirmed sold events for this property |
dom | Integer | Days on market for current listing cycle |
cumulative_dom | Integer | Total days on market across all listing cycles |
listingstartdate | Text | Start date of current listing cycle |
listingenddate | Text | End date of current listing cycle |
backonmarket | Text | Indicator that the property has returned to market after prior removal |
last_snapshot_date | Text | Date of the most recent weekly snapshot containing this property |
weeks_tracked | Integer | Number of weekly snapshots in which this property has appeared |
| Field | Type | Description |
|---|---|---|
pricenum | Number | Current asking price (numeric) |
originalpricenum | Number | Original asking price when first listed |
prevpricenum | Number | Previous asking price before most recent change |
pricechanged | Text | Indicator of whether price has changed in current cycle |
pricechangeamt | Number | Dollar amount of most recent price change |
cumpricechgamt | Number | Cumulative dollar change across the full listing cycle |
pricechangepct | Number | Percentage of most recent price change |
cumpricechgpct | Number | Cumulative percentage change across the full listing cycle |
pricesqft | Number | Price per square foot |
price_change_count | Integer | Total number of price changes observed |
price_tax_indicated | Text | Indicator of whether price includes tax |
price_raw | Text | Raw asking price as originally listed |
| 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 |
baths_total | Number | Total bathroom count (numeric) |
bathrooms_partial | Text | Number of partial bathrooms |
built_in | Text | Year built |
age_of_building | Text | Age classification |
construction_status | Text | Construction state (completed, under construction, etc.) |
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 (raw) |
floor_space_sqft | Number | Floor space in square feet |
floor_space_flag | Text | Floor space classification flag |
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 |
cooling | Text | Cooling system |
central | Text | Central air/heat indicator |
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_type | Text | Property access type |
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 |
garage | Text | Garage description |
| 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) |
| Field | Type | Description |
|---|---|---|
total_reno_signals | Integer | Total renovation signals detected across history |
reno_category | Text | Renovation category classification |
has_price_changes | Text | Indicator of price change activity |
has_sold_history | Text | Indicator of prior sold events |
sold_count | Integer | Count of prior sold events for this property |
has_relist_history | Text | Indicator of relist activity |
relist_count | Integer | Count of relist events |
has_reno_signals | Text | Indicator of renovation signals detected |
reno_signal_count | Integer | Count of renovation signals |
has_rental_history | Text | Indicator of rental listing history |
completeness_score | Integer | Record completeness score |
| Field | Type | Description |
|---|---|---|
realtor_name | Text | Listing agent name |
company_name | Text | Listing brokerage |
company_address | Text | Brokerage address |
company_phone | Text | Brokerage phone number |
listing_url | Text | Listing URL |