Oregon Affordable Housing Inventory
State of Oregon
@usgov.state_of_oregon_oregon_affordable_housing_inventory
State of Oregon
@usgov.state_of_oregon_oregon_affordable_housing_inventory
The properties in this inventory come from the following agencies and organizations: Oregon Housing and Community Services (OHCS), U.S. Department of Housing and Urban Development (HUD), U.S. Department of Agriculture (USDA), Metro, all 20 of Oregon's Housing Authorities, and many county and city governments. This is meant to be a comprehensive inventory of all affordable rental housing with income or rent restrictions in the state and every effort has been made to delete duplicates. For properties listed as "In Development" in the Status field, please use extra caution as these properties have reached financial closing and begun construction, but are not yet complete making the data subject to change. Every effort has been made to ensure the affordability expiration dates are correct for OHCS funded properties, however, some errors may exist. For properties listed as Scattered Sites, please note that some of the underlying unit counts may be inaccurate; this is an issue we are working to improve. OHCS can not and does not guarantee that there are no errors in this inventory. Please note that certain property types are not included such as: homeless shelters, group homes, transitional housing, assisted living facilities, residential care facilities, on-farm housing, and manufactured home parks. If you have questions, concerns, or corrections, or a need for additional data, please contact Megan Bolton at megan.bolton@hcs.oregon.gov.
Organization: State of Oregon
Last updated: 2025-08-30T21:20:52.823313
CREATE TABLE table_1 (
"property_name" VARCHAR,
"location_name" VARCHAR,
"address" VARCHAR,
"city" VARCHAR,
"zip_code" VARCHAR,
"county" VARCHAR,
"scattered_single_site" VARCHAR,
"status" VARCHAR,
"year_built" DOUBLE,
"rehab_year" DOUBLE,
"management_name" VARCHAR,
"developer_name" VARCHAR,
"owner_name" VARCHAR,
"owner_type" VARCHAR,
"total_units" BIGINT,
"rental_assistance_count" DOUBLE,
"no_accessible_units" DOUBLE,
"visitable_units" DOUBLE,
"psh_units" DOUBLE,
"total_sro_units" DOUBLE,
"total_efficiency_units" DOUBLE,
"total_1_br_units" DOUBLE,
"total_2_br_units" DOUBLE,
"total_3_br_units" DOUBLE,
"total_4plus_br_units" DOUBLE,
"total_30_ami_units" VARCHAR,
"total_40_ami_units" VARCHAR,
"total_50_ami_units" VARCHAR,
"total_60_ami_units" VARCHAR,
"total_80_ami_units" VARCHAR,
"market_rate_units" VARCHAR,
"no_income" VARCHAR,
"financial_closing_date" VARCHAR,
"compliance_start_date" VARCHAR,
"lihtc_4_expiration_date" VARCHAR,
"lihtc_9_expiration_date" VARCHAR,
"home_expiration_date" VARCHAR,
"oahtc_expiration_date" VARCHAR,
"ghap_expiration_date" VARCHAR,
"hdgp_expiration_date" VARCHAR,
"lift_expiration_date" VARCHAR,
"htf_expiration_date" VARCHAR,
"other_ohcs_expiration_date" VARCHAR,
"hud_mf_expiration_date" VARCHAR,
"usda_rd_expiration_date" VARCHAR,
"latest_expiration_date" VARCHAR,
"hud_contract" VARCHAR,
"ohcs_funded" VARCHAR -- OHCS Funded?
);
Anyone who has the link will be able to view this.