GET comps/export

Download the list of closed assets

Request

URL ( requires authentication )

https://api.crexi.com/comps/export?term={term}&types=types[0]&types=types[1]&sortOrder={sortOrder}&sortDirection={sortDirection}&askingPriceMin={askingPriceMin}&askingPriceMax={askingPriceMax}&capRateMin={capRateMin}&capRateMax={capRateMax}&brokerIds=brokerIds[0]&brokerIds=brokerIds[1]&latitudeMin={latitudeMin}&latitudeMax={latitudeMax}&longitudeMin={longitudeMin}&longitudeMax={longitudeMax}&country={country}&brokerOrBrokerage={brokerOrBrokerage}&states=states[0]&states=states[1]&counties=counties[0]&counties=counties[1]&cities=cities[0]&cities=cities[1]&zips=zips[0]&zips=zips[1]&sqFtMin={sqFtMin}&sqFtMax={sqFtMax}&unitType={unitType}&unitMin={unitMin}&unitMax={unitMax}&leaseTypes=leaseTypes[0]&leaseTypes=leaseTypes[1]&tenancies=tenancies[0]&tenancies=tenancies[1]&tenantCredits=tenantCredits[0]&tenantCredits=tenantCredits[1]&remainingTermMin={remainingTermMin}&remainingTermMax={remainingTermMax}&geometry={geometry}&classes=classes[0]&classes=classes[1]&includeUnpriced={includeUnpriced}&occupancyMin={occupancyMin}&occupancyMax={occupancyMax}&acreageMin={acreageMin}&acreageMax={acreageMax}&pricePerSqFtMin={pricePerSqFtMin}&pricePerSqFtMax={pricePerSqFtMax}&closedPeriod={closedPeriod}&closedDateMin={closedDateMin}&closedDateMax={closedDateMax}&salePriceMin={salePriceMin}&salePriceMax={salePriceMax}&includeSaleUnpriced={includeSaleUnpriced}&saleCapRateMin={saleCapRateMin}&saleCapRateMax={saleCapRateMax}&salePricePerSqFtMin={salePricePerSqFtMin}&salePricePerSqFtMax={salePricePerSqFtMax}

Parameters

acreageMax

decimal number

Optional

acreageMin

decimal number

Optional

askingPriceMax

decimal number

Maximum asking price

Optional

askingPriceMin

decimal number

Minimum asking price

Optional

brokerIds

Collection of integer

Array of broker ids

Optional

brokerOrBrokerage

string

BrokerOrBrokerage

Optional

capRateMax

decimal number

Maximum cap rate

Optional

capRateMin

decimal number

Minimum cap rate

Optional

cities

Collection of string

Cities

Optional

classes

Collection of string

Classes

Optional

Possible values are: 'A', 'B', 'C', 'D'

closedDateMax

date

Closed date maximum

Optional

closedDateMin

date

Closed date minimum

Optional

closedPeriod

string

Closed period

Optional

Possible values are: 'TwoMonths', 'FourMonths', 'SixMonths', 'TwelveMonths', 'TwoYears', 'Custom'

counties

Collection of string

Counties

Optional

country

string

Country

Optional

geometry

GeometryParameters

Polygons and Circles spatial filters. JSON object.

Optional

JSON: {"Polygons":[{"Coordinates":[{"Lt":41.849923,"Lg":-119.915771},{"Lt":38.973076,"Lg":-119.915771},{"Lt":35.99223,"Lg":-115.982666},{"Lt":36.098826,"Lg":-114.071045},{"Lt":41.882649,"Lg":-114.0271},{"Lt":41.849923,"Lg":-119.915771}]}],"Circles":[{"Coordinates":{"Lt":34.052234,"Lg":-118.243685},"Radius":0.34567}]}

includeSaleUnpriced

boolean

Include sold and unpriced

Optional

includeUnpriced

boolean

Include Unpriced

Optional

latitudeMax

decimal number

Maximum latitude

Optional

latitudeMin

decimal number

Minimum latitude

Optional

leaseTypes

Collection of string

Lease types

Optional

Possible values are: 'Net', 'Absolute Net', 'Gross', 'Modified', 'Ground'

longitudeMax

decimal number

Maximum longitude

Optional

longitudeMin

decimal number

Minimum longitude

Optional

occupancyMax

decimal number

Optional

occupancyMin

decimal number

Optional

pricePerSqFtMax

decimal number

Maximum of price per square footage

Optional

pricePerSqFtMin

decimal number

Minimum of price per square footage

Optional

remainingTermMax

integer

Maximum remaining term

Optional

remainingTermMin

integer

Minimum remaining term

Optional

saleCapRateMax

decimal number

Sale cap rate maximum

Optional

saleCapRateMin

decimal number

Sale cap rate minimum

Optional

salePriceMax

decimal number

Sale price maximum

Optional

salePriceMin

decimal number

Sale price minimum

Optional

salePricePerSqFtMax

decimal number

Sale price per square foot maximum

Optional

salePricePerSqFtMin

decimal number

Sale price per square foot minimum

Optional

sortDirection

string

Sort direction

Optional

Possible values are: 'Ascending', 'Descending'

sortOrder

string

Sort order

Optional

Possible values are: 'Relevance', 'Rank', 'SqFt', 'NOI', 'Units', 'Price', 'CreatedOn', 'UpdatedOn', 'CapRate', 'SalePrice', 'SaleCapRate', 'SaleNOI'

sqFtMax

integer

Maximum square footage

Optional

sqFtMin

integer

Minimum square footage

Optional

states

Collection of string

Optional

tenancies

Collection of string

Tenancies

Optional

Possible values are: 'Vacant', 'Single', 'Multi'

tenantCredits

Collection of string

Tenant credits

Optional

Possible values are: 'Credit Rated', 'Franchisee', 'Corporate Guarantee', 'No Credit Rating'

term

string

Asset search term

Optional

types

Collection of string

List of asset type names

Optional

Possible values are: 'Other', 'Multifamily', 'Retail', 'Office', 'Industrial', 'Self Storage', 'Mobile Home Park', 'Mixed Use', 'Hospitality', 'Land', 'Senior/Assisted Living', 'Development Site', 'Student Housing', 'Special Purpose', 'Medical Office', 'Note/Loan', 'Single Family Rental Portfolio'

unitMax

integer

Maximum unit value

Optional

unitMin

integer

Minimum unit value

Optional

unitType

string

Unit type

Optional

Possible values are: 'Units', 'Keys', 'Beds', 'Pads', 'Pumps'

zips

Collection of string

Zips

Optional

Response

Details

Returns an HTTP 200 OK and excel file for download if operation was successful. Returns 400 Bad Request and an error message otherwise.