Properties Summary View

Field NameData TypeLimitsDescription
idIntegerMax value 2147483627

This is an internal serial number assigned for each property

address

String/VarcharMax 255 Characters

address entered into Rently

lockbox

String/VarcharMax 255 Characters

lockbox serial number

showing_hour_name

String/Varchar

Max 255 Characters

The primary showing hour name based on agent showing

price

Float

1E-307 to 1E+308

Latest rental price of property

previous_rent

Float

1E-307 to 1E+308

Previous rental price of property

rent_updated_at

DateTime with zone (eg- 2019-01-08 22:12:05 -0800)

N/A

The date latest rental price is entered, in format of local time of server timezone (PST - 08:00 / PDT - 07:00)

status_title

String/Varchar

Max 255 Characters

Type of showing that is enabled for this property.

created_at

DateTime with zone (eg- 2019-01-08 22:12:05 -0800)

N/A

Date property record is created on Rently, in format of local time of server timezone (PST - 08:00 / PDT - 07:00)

lockbox_assigned_date

prelease_date

autoshowing_date

agentshowing_date

inactive_date

agent_inactive_date

Date

N/A

Records the date property is first set to corresponding status. Will not be set when property enters this status second time.

ready_date

Date

N/A

This date is assigned when adding a property by the assigning of a lockbox to property section

last_7_days_leads

last_8_to_14_days_leads

last_15_to_30_days_leads

greater_than_30_days_leads

claimed_leads

unclaimed_leads

interested

last_7_days_showings

last_8_to_14_days_showings

last_15_to_30_days_showings

greater_than_30_days_showings

upcoming_showings

String/Varchar

Max 255 Characters

Shows corresponding property statistics. Data is updated nightly.

secondary_external_id

String/Varchar

Max 255 Characters

Secondary external id used for sending guestcard for SFH