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 |