Listings

Retrieve the available Listings in HubSpot.

Table Specific Information

In HubSpot, listings represent real estate properties or inventory items that can be tracked and managed. Listing records support property management, inventory tracking, and sales processes.

SELECT

When selecting listings, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are: =, !=, <, <=, >, >=, IN

Further filtering is available using AND and OR combinations. A maximum of 3 OR operators are supported server-side, with each of these operators supporting up to 3 AND operators inside of them. For example:

SELECT * FROM Listings WHERE [Price] > 100000 AND [Bedrooms] >= 2
SELECT * FROM Listings WHERE [City] = 'New York' OR [State/Province] = 'NY'

In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:

SELECT * FROM Listings WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Listings WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}
SELECT * FROM Listings WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Listings WHERE ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}) OR ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}) OR ({Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value})

INSERT

INSERT INTO Listings ([Name], [Price], [City], [State/Province]) VALUES ('Modern Downtown Condo', 350000, 'Boston', 'MA')

UPDATE

UPDATE Listings SET [Price] = 375000 WHERE ID = '11111'

DELETE

DELETE FROM Listings WHERE ID = '11111'

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 the 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.

CData Python Connector for HubSpot