297K+ commercial properties tracked weekly with sale and lease activity combined. Dual-listing detection identifies properties on both tracks and infers transaction outcomes. 114+ fields per record.
Each record represents one commercial property with separate sale and lease tracks. When both tracks are active, the record includes dual-listing signals and transaction outcome inference. 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 |
streetnumber | Text | Street number component |
streetname | Text | Street name component |
streettype | Text | Street suffix (St, Ave, Blvd, etc.) |
streetdir | Text | Directional suffix |
suite | Text | Unit, suite, or office number |
community_name | Text | Real estate community name |
neighbourhood_name | Text | Neighbourhood designation |
latitude | Text | Geocoded latitude |
longitude | Text | Geocoded longitude |
| Field | Type | Description |
|---|---|---|
listing_type | Text | Listing type: sale, lease, or dual-listed |
dual_listed | Boolean | Flag indicating property is listed for both sale and lease simultaneously |
transaction_signal | Text | Inferred outcome signal (LIKELY_SOLD, LIKELY_LEASED, LIKELY_TRANSACTED) |
first_seen_any | Text | Earliest date property appeared in any track (sale or lease) |
last_seen_any | Text | Most recent date property appeared in any track |
total_weeks_combined | Integer | Total weeks tracked across sale and lease tracks |
| Field | Type | Description |
|---|---|---|
sale_status | Text | Current sale listing status |
sale_first_seen | Text | Date sale listing first appeared |
sale_last_seen | Text | Date sale listing last appeared |
sale_dropped_date | Text | Date sale listing was removed (if applicable) |
sale_original_price | Number | Original sale asking price |
sale_current_price | Number | Current or most recent sale asking price |
sale_cumulative_price_change | Number | Cumulative dollar change in sale price |
sale_price_change_count | Integer | Count of sale price changes observed |
sale_relist_count | Integer | Count of sale relist events |
sale_weeks_on_market | Integer | Weeks listed for sale |
sale_total_appearances | Integer | Total weekly snapshots containing the sale listing |
| Field | Type | Description |
|---|---|---|
lease_status | Text | Current lease listing status |
lease_first_seen | Text | Date lease listing first appeared |
lease_last_seen | Text | Date lease listing last appeared |
lease_dropped_date | Text | Date lease listing was removed (if applicable) |
lease_original_price | Number | Original lease rate |
lease_current_price | Number | Current or most recent lease rate |
lease_cumulative_price_change | Number | Cumulative dollar change in lease rate |
lease_price_change_count | Integer | Count of lease rate changes observed |
lease_relist_count | Integer | Count of lease relist events |
lease_weeks_on_market | Integer | Weeks listed for lease |
lease_total_appearances | Integer | Total weekly snapshots containing the lease listing |
| Field | Type | Description |
|---|---|---|
building_type | Text | Building classification |
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 (where applicable) |
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 |
operating_since | Text | Commercial operation start date |
| 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 |
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 |
appliances_included | Text | Appliances included |
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 |
|---|---|---|
price | Text | Most recent price recorded |
maintenance_fees | Text | Maintenance fees (where applicable) |
maintenance_fees_include | Text | What maintenance fees include |
maintenance_management_company | Text | Property management company |
annual_property_taxes | Text | Annual property taxes |