All information provided in attached files.
Data analysis test Strictly Private and Confidential | Copyright Beekin Inc 2022 Test Overview Use the attached excel to run queries to produce the following analysis. Please use any language possible and return your results in a document, or a slide deck. Please look to invest no more than 3 hours on these tasks From the attached excel Sheet (Performance Data.xlsx) compute the following: 1. Renewal rent growth 2. Understanding lease terms 3. Any ‘dodgy’ behavior by users based on what the machine /software recommended and what they decided to offer to their residents 4. Renewal probability and rent growth relationships 5. Segment and rank order properties based on which renters are likely to renew most with 3-4 columns of data about these properties. Choose any columns you think are relevant to tell the story about why these properties may have people more likely to renew than others In addition to the above, please perform the following task (code) as Python or SQL queries or VLOOKUPs and return your logic as pasted code The following are 2 example database tables, with some questions below . Table 1 Tenant_Code Property_Code Rent Offer_Cycle abc_123 445 1050 01-01-2022 abc_123 445 1030 02-01-2022 edf_234 445 1000 02-01-2022 asd_999 555 750 02-01-2022 Table 2 1 Strictly Private and Confidential | Copyright Beekin Inc 2022 t_code Renewal_Probability Lease_End_Date OfferCyc abc_123 60 02-01-2022 01-01-2022 abc_123 65 12-01-2022 02-01-2022 edf_234 57 06-01-2022 02-01-2022 Note: - Please refer to the tables as ‘table_1’ and ‘table_2’ in your queries. - All dates are formatted as MM-DD-YYYY Tasks to be completed 1. Get all distinct tenant codes from ‘table_1’ 2. Get the average rent for property 445. 3. Get the average renewal probability for property 445. 4. Return a table with columns [‘Tenant_Code’, ‘Property_Code’, ‘Rent’, ‘Renewal_Probability’ and ‘Offer_Cycle’] using an INNER JOIN. 5. Assuming the current date is 06-01-2022, return the total number of leases expiring on or before the current date for the offer cycle at 02-01-2022. 2 Strictly Private and Confidential | Copyright Beekin Inc 2022 Business Background ● This is a data export for a group of properties’ leasing data. The properties in this instance have a name, property ID, and are apartments (flats) which have renters (residents/ tenants) living inside them with a Tenant_Code ● These renters have leases signed with the company that owns them. The dataset provided has performance data of a price optimization software platform. ● The software platform analyses renewal probability of each resident at the Offered rent, and monitors Achieved Rent. The users of the software can Approve, Override the platform. ● There is an offer cycle, that is, renewal offers are sent in a batch of renewals and not everyday. ● Some residents are on MTM (month to month) leases and others are on leases between 3-18 month duration which the landlord and Beekin’s software offers and optimizes for. ● The software platform also provides a Renewal Probability for a resident based on multiple factors, and generates renewal price (offers) based on terms (duration of leases) which can range from 3 months to 18 months and the resident has a choice to pick one ● In-place Rent is current rent that a resident is paying (these are existing customers who are about to renew their leases). We also have data on contemporary market rent, which is the rent of other properties around where the resident lives. Below is a detailed data dictionary. Please make assumptions where needed. 3 Strictly Private and Confidential | Copyright Beekin Inc 2022 Data Dictionary Tenant_Code Unique id within the property OfferCycle Code given by Beekin to identify which cycle offer was made. Lease_From_Date Date the offered leases started Terms An array of all the lease terms Beekin offered Rents An array of all the lease rents that were finalised after edits by users BeekinOfferRents An array of all the lease terms the software originally offered RenewalProbabilitys An array of all the renewal probabilites for the Beekin offers IsUpdateds An array of whether Rent = BeekinOfferRents (ie whether beekin offer was edited) IsApproveds An array of whether the offer generated was Approved by user Excludes An array of whether the offer was excluded Uploads An array of whether the data was uploaded Property_Code Property where tenant lives Unit_Code Unit Unit or apartment where tenant lives Move_In_Date Move in date of tenant Move_Out_Date Move out date of tenant (if missing, can assume tenant still stays) Notice_Date Date tenant intends to move out, if they have given their notice to vacate. Current_Lease_From_Date These refer to the current lease ON THE DATE THIS NOTEBOOK IS RUN Current_Lease_To_Date > (or last lease if no longer a tenant). 4 Strictly Private and Confidential | Copyright Beekin Inc 2022 Current_Rent / NOT the pre renewal lease, nor necessarily the post renewal lease. Current_Status Status of renter’s lease. Either Past (moved out) Notice (moving out) or Current (still there) Dates Date that events recorded in Events are supposed to happen. DateOccurreds Date that events recorded in Events were recorded (usually same as Dates). Events A record of all Renewals (or canceled renewals) or transitions to MTM for a tenant DateLeaseFroms The lease start date for the active lease at the time of the event in Events DateLeaseTos The lease end date for the active lease at the time of the event in Events RentRecord The lease rent for the active lease at the time of the event in Events MTMs Whether a MTM was recorded at the time of the event. UserName If there was a flag, the user name of the person who created the flag Resolved If there was a flag, whether the flag was resolved Comments If there was a flag, the message that came with the flag isCommentDeleteds If there was a flag, had the comment been deleted? ProposalRents If there is proposal matching this tenant, what are the rents in that proposal ProposalTerms If there is proposal matching this tenant, what are the terms in that proposal 5 Strictly Private and Confidential | Copyright Beekin Inc 2022 Proposal_dates If there is proposal matching this tenant, what dates were those proposals made ProposalStatuses If there is proposal matching this tenant, what are the statuses of those proposals isEmployee Whether the offer was made to someone who is receiving the crc employee concession ContemporaryMarketRent The market rent we have recorded, for that unit, at the time the offer was made ContemporaryInPlaceRent The recorded in place rent we recorded, for that tenant, at the time the offer was made 6 Sheet1 Tenant_CodeOfferCycleLease_From_DateTermsRentsBeekinOfferRentsRenewalProbabilitysIsUpdatedsIsApprovedsExcludesUploadedsProperty_CodeUnit_CodeMove_In_DateMove_Out_DateNotice_DateCurrent_Lease_From_DateCurrent_Lease_To_DateCurrent_RentCurrent_StatusDatesDateOccurredsEventsDateLeaseFromsDateLeaseTosRentRecordMTMsBedRoomsUserNameResolvedCommentsisCommentDeletedsProposalRentsProposalTermsProposal_datesProposalStatusesisEmployeeContemporaryMarketRentContemporaryInPlaceRent gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1374-15.9%122021-08-012022-07-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA122021-08-012022-07-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1380-15.5%112021-08-012022-06-30NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA112021-08-012022-06-30NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1385-15.2%102021-08-012022-05-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA102021-08-012022-05-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1391-14.9%92021-08-012022-04-30NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA92021-08-012022-04-30NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1396-14.6%82021-08-012022-03-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA82021-08-012022-03-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1401-14.3%72021-08-012022-02-28NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA72021-08-012022-02-28NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1407-13.9%62021-08-012022-01-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA62021-08-012022-01-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1412-13.6%52021-08-012021-12-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA52021-08-012021-12-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1418-13.2%42021-08-012021-11-30NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA42021-08-012021-11-30NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1423-12.9%32021-08-012021-10-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA32021-08-012021-10-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES1428-12.6%22021-08-012021-09-30NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA22021-08-012021-09-30NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348RNTRES180610.5%12021-08-012021-08-31NONONO gall1153YES15-305Galleria City Centre214130511ar112018-04-192018-04-192018-07-18316341348MTM300NA12021-08-012021-08-31NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1550NA122021-08-012022-07-31NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1556NA112021-08-012022-06-30NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1562NA102021-08-012022-05-31NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1568NA92021-08-012022-04-30NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1574NA82021-08-012022-03-31NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1580NA72021-08-012022-02-28NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1586NA62021-08-012022-01-31NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1592NA52021-08-012021-12-31NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1599NA42021-08-012021-11-30NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1605NA32021-08-012021-10-31NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES1611NA22021-08-012021-09-30NONONO dels1218YES15-105Del Sol Scottsdale Apartments LLC17710522bpr22016-09-072016-09-072018-09-062401520RNTRES2036NA12021-08-012021-08-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1361-15.8%122021-08-012022-07-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA122021-08-012022-07-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1367-15.4%112021-08-012022-06-30NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA112021-08-012022-06-30NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1372-15.1%102021-08-012022-05-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA102021-08-012022-05-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1377-14.8%92021-08-012022-04-30NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA92021-08-012022-04-30NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1383-14.4%82021-08-012022-03-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA82021-08-012022-03-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1388-14.1%72021-08-012022-02-28NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA72021-08-012022-02-28NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1393-13.8%62021-08-012022-01-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA62021-08-012022-01-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1399-13.4%52021-08-012021-12-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA52021-08-012021-12-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1404-13.1%42021-08-012021-11-30NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA42021-08-012021-11-30NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1409-12.8%32021-08-012021-10-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA32021-08-012021-10-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES1415-12.4%22021-08-012021-09-30NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA22021-08-012021-09-30NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335RNTRES178810.6%12021-08-012021-08-31NONONO hunt1032YES15-003The Huntington0820200311br212015-07-252018-06-252019-02-24816161335PETR35NA12021-08-012021-08-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES138236.6%122021-08-012022-07-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA122021-08-012022-07-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES138737.1%112021-08-012022-06-30NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA112021-08-012022-06-30NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES139237.5%102021-08-012022-05-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA102021-08-012022-05-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES139838.1%92021-08-012022-04-30NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA92021-08-012022-04-30NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES140338.6%82021-08-012022-03-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA82021-08-012022-03-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES140939.2%72021-08-012022-02-28NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA72021-08-012022-02-28NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES141439.7%62021-08-012022-01-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA62021-08-012022-01-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES142040.3%52021-08-012021-12-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA52021-08-012021-12-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES142540.8%42021-08-012021-11-30NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA42021-08-012021-11-30NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES143041.3%32021-08-012021-10-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA32021-08-012021-10-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES143641.9%22021-08-012021-09-30NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA22021-08-012021-09-30NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355RNTRES181579.3%12021-08-012021-08-31NONONO dels1032YES15-105Del Sol Scottsdale Apartments LLC11110511apr12017-05-242018-05-242019-07-231410121355VAL25NA12021-08-012021-08-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES1405-15.9%122021-08-012022-07-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA122021-08-012022-07-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA122021-08-012022-07-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES1411-15.5%112021-08-012022-06-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA112021-08-012022-06-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA112021-08-012022-06-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES1416-15.2%102021-08-012022-05-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA102021-08-012022-05-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA102021-08-012022-05-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES1439-13.8%92021-08-012022-04-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA92021-08-012022-04-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA92021-08-012022-04-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES1448-13.3%82021-08-012022-03-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA82021-08-012022-03-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA82021-08-012022-03-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES1442-13.7%72021-08-012022-02-28NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA72021-08-012022-02-28NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA72021-08-012022-02-28NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES1438-13.9%62021-08-012022-01-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA62021-08-012022-01-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA62021-08-012022-01-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES1479-11.4%52021-08-012021-12-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA52021-08-012021-12-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA52021-08-012021-12-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES1448-13.3%42021-08-012021-11-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA42021-08-012021-11-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA42021-08-012021-11-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES1495-10.5%32021-08-012021-10-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA32021-08-012021-10-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA32021-08-012021-10-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES17333.8%22021-08-012021-09-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA22021-08-012021-09-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA22021-08-012021-09-30NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470RNTRES232939.5%12021-08-012021-08-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470VAL25NA12021-08-012021-08-31NONONO dels1320YES15-105Del Sol Scottsdale Apartments LLC22910522bpr22019-01-222019-01-222020-01-211216701470MTM200NA12021-08-012021-08-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES16404.7%122021-08-012022-07-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA122021-08-012022-07-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES16575.8%112021-08-012022-06-30NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA112021-08-012022-06-30NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES16515.4%102021-08-012022-05-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA102021-08-012022-05-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES16787.2%92021-08-012022-04-30NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA92021-08-012022-04-30NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES16777.1%82021-08-012022-03-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA82021-08-012022-03-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES16696.6%72021-08-012022-02-28NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA72021-08-012022-02-28NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES16757.0%62021-08-012022-01-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA62021-08-012022-01-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES16817.3%52021-08-012021-12-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA52021-08-012021-12-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES16877.7%42021-08-012021-11-30NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA42021-08-012021-11-30NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES173710.9%32021-08-012021-10-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA32021-08-012021-10-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES190321.5%22021-08-012021-09-30NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA22021-08-012021-09-30NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715RNTRES271473.3%12021-08-012021-08-31NONONO rilo1113YES15-001The Ridge at Lowry53900122cr22018-02-192019-03-212020-03-201215661715GAR100NA12021-08-012021-08-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES161912.6%122021-08-012022-07-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA122021-08-012022-07-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES161212.1%112021-08-012022-06-30NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA112021-08-012022-06-30NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES158810.4%102021-08-012022-05-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA102021-08-012022-05-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES166115.5%92021-08-012022-04-30NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA92021-08-012022-04-30NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES167216.3%82021-08-012022-03-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA82021-08-012022-03-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES166415.7%72021-08-012022-02-28NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA72021-08-012022-02-28NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES164414.3%62021-08-012022-01-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA62021-08-012022-01-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES170718.7%52021-08-012021-12-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA52021-08-012021-12-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES164914.7%42021-08-012021-11-30NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA42021-08-012021-11-30NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES172520.0%32021-08-012021-10-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA32021-08-012021-10-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES199038.4%22021-08-012021-09-30NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA22021-08-012021-09-30NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635RNTRES250274.0%12021-08-012021-08-31NONONO dels1272YES15-105Del Sol Scottsdale Apartments LLC21310532apr32017-09-032020-04-012020-06-30314381635VAL25NA12021-08-012021-08-31NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355RNTRES12138.8%122021-08-012022-07-31NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355VAL25NA122021-08-012022-07-31NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355RNTRES12078.3%112021-08-012022-06-30NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355VAL25NA112021-08-012022-06-30NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355RNTRES11886.5%102021-08-012022-05-31NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355VAL25NA102021-08-012022-05-31NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355RNTRES124611.7%92021-08-012022-04-30NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355VAL25NA92021-08-012022-04-30NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355RNTRES125512.6%82021-08-012022-03-31NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355VAL25NA82021-08-012022-03-31NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355RNTRES124912.0%72021-08-012022-02-28NONONO t0001935YES15-105Del Sol Scottsdale Apartments LLC24610511apr12019-08-052019-08-052020-08-041211151355VAL25NA72021-08-012022-02-28NONONO t0001935YES15-105Del Sol Scottsdale