Listings
Retrieve the available Listings in HubSpot.
Table Specific Information
In HubSpot, listings represent real estate properties or other items being offered for sale or rent. Listing records help users track inventory, pricing, and status through pipeline stages.
SELECT
When selecting listings, filtering can be applied to columns marked as "Filterable." For these columns, the only supported server-side operator is =.
SELECT * FROM Listings WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'
INSERT
INSERT INTO Listings ([Name]) VALUES ('Luxury Downtown Condo')
UPDATE
UPDATE Listings SET [Name] = 'Updated Property Name' WHERE ID = '25151'
DELETE
DELETE FROM Listings WHERE ID = '25151'
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | Long | True | True |
Unique identifier of the object. | |
| Archived | Bool | True | False |
Whether the object is archived or not. | |
| CreatedAt | Datetime | True | False |
When the object was created. | |
| UpdatedAt | Datetime | True | False |
When the object was last updated. | |
| Address 1 | String | False | True |
Primary street address line. | |
| Address 2 | String | False | True |
Secondary address info (apartment, suite, unit). | |
| All teams | String | True | False |
The team IDs, including the team hierarchy, of all default and custom owner properties for this record. | |
| Business units | String | False | False |
The business units this record is assigned to. | |
| All owner IDs | String | True | False |
Values of all default and custom owner properties for this record. | |
| All team IDs | String | True | False |
The team IDs of all default and custom owner properties for this record. | |
| Bathroom(s) | Decimal | False | True |
Number of bathrooms (full/partial) in the property. | |
| Bedroom(s) | Decimal | False | True |
Number of bedrooms in the property. | |
| City | String | False | True |
City where listing is located. | |
| Created by user ID | Decimal | True | True |
The user who created this record. This value is set automatically by HubSpot. | |
| Object create date/time | Datetime | True | True |
The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified. | |
| Date entered 'Closed Stage (Listing Pipeline)' | Datetime | True | True |
The date and time when the Listing entered the 'Closed Stage' stage, 'Listing Pipeline' pipeline. | |
| Date entered 'Open Stage (Listing Pipeline)' | Datetime | True | True |
The date and time when the Listing entered the 'Open Stage' stage, 'Listing Pipeline' pipeline. | |
| Date exited 'Closed Stage (Listing Pipeline)' | Datetime | True | True |
The date and time when the Listing exited the 'Closed Stage' stage, 'Listing Pipeline' pipeline. | |
| Date exited 'Open Stage (Listing Pipeline)' | Datetime | True | True |
The date and time when the Listing exited the 'Open Stage' stage, 'Listing Pipeline' pipeline. | |
| Object last modified date/time | Datetime | True | True |
Most recent timestamp of any property update for this object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically. | |
| Listing Type | String | False | False |
Type of listing (for sale / rent / lease). | |
| Lot Size | Decimal | False | True |
Size of the land lot (outside area). | |
| Merged record IDs | String | True | False |
The list of record IDs that have been merged into this record. This value is set automatically by HubSpot. | |
| Name | String | False | True |
Name/title of the listing, such as '3-bed house on Main Street'. | |
| Neighborhood | String | False | True |
Name of the neighborhood or local area. | |
| Record ID | Decimal | True | True |
The unique ID for this record. This value is set automatically by HubSpot. | |
| Record creation source | String | True | True |
Raw internal PropertySource present in the RequestMeta when this record was created. | |
| Record source detail 1 | String | True | True |
First level of detail on how this record was created. | |
| Record source detail 2 | String | True | True |
Second level of detail on how this record was created. | |
| Record source detail 3 | String | True | True |
Third level of detail on how this record was created. | |
| Record creation source ID | String | True | True |
Raw internal sourceId present in the RequestMeta when this record was created. | |
| Record source | String | True | False |
How this record was created. | |
| Record creation source user ID | Decimal | True | True |
Raw internal userId present in the RequestMeta when this record was created. | |
| Owning Teams | String | False | False |
The teams that are attributed to this record. | |
| Pipeline | String | False | False |
The pipeline that contains this listing. | |
| Pipeline Stage | String | False | False |
The pipeline stage that contains this listing. | |
| Price | Decimal | False | True |
Listing price (currency). | |
| Price/sqft | Decimal | True | True |
Price per square foot (or per unit area). | |
| Read only object | Bool | True | True |
Determines whether a record can be edited by a user. | |
| Shared teams | String | False | False |
Additional teams whose users can access the record based on their permissions. This can be set manually or through Workflows or APIs. | |
| Shared users | String | False | False |
Additional users that can access the record based on their permissions. This can be set manually or through Workflows and APIs. | |
| Square Footage | Decimal | False | True |
Size of the interior living space. | |
| State/Province | String | False | True |
State or province region of the listing. | |
| Time in 'Closed Stage (Listing Pipeline)' | Decimal | True | True |
The total time in seconds spent by the Listing in the 'Closed Stage' stage, 'Listing Pipeline' pipeline. | |
| Time in 'Open Stage (Listing Pipeline)' | Decimal | True | True |
The total time in seconds spent by the Listing in the 'Open Stage' stage, 'Listing Pipeline' pipeline. | |
| Unique creation key | String | True | True |
Unique property used for idempotent creates. | |
| Updated by user ID | Decimal | True | True |
The user who last updated this record. This value is set automatically by HubSpot. | |
| User IDs of all notification followers | String | True | False |
The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications. | |
| User IDs of all notification unfollowers | String | True | False |
The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications. | |
| User IDs of all owners | String | True | False |
The user IDs of all owners of this record. | |
| Performed in an import | Bool | True | True |
Object is part of an import. | |
| Year Built | Decimal | False | True |
Year when the property was constructed. | |
| Zip | Decimal | False | True |
Postal or ZIP code. | |
| Owner assigned date | Datetime | True | True |
The most recent timestamp of when an owner was assigned to this record. This value is set automatically by HubSpot. | |
| Owner | String | False | True |
The owner of the object. | |
| Owner's main team | String | True | False |
The main team of the record owner. This value is set automatically by HubSpot. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.
| Name | Type | Description |
| ExternalIdColumn | String |
The name of the column to be used as the unique key in a bulk UPSERT statement. |