Inventory position

I have seen a number of posts on inventory, but no real data — only anecdotes. Zillow does provide the statistics for all major metropolitan areas here. It is not enough for micro-segmentation, but does provide a clear macro picture. I took that data and summarized it below for 40 or so big markets which took 10 mins. If any one wants to do other analysis, I can post relevant python code. The take away, is that overall the US inventory is still very low, but it looks like it is ticking up in the last couple of months — although the picture is very market dependent. For example, it shows that San Fran never had an inventory dip even during the pandemic. Some other areas are actually back to pre-pandemic inventory. Here is the data — if you need clarification, you can ask.

I added the mean yearly inventory (only for first 10 months of 2021), mean for summer season (April-August) and the inventory for October 2021 (the last month of stats available).

Region: United States

2018 mean: 1622601 2018 summer mean: 1681032 2018 october: 1750118.0

2019 mean: 1646678 2019 summer mean: 1709802 2019 october: 1742627.0

2020 mean: 1378345 2020 summer mean: 1429977 2020 october: 1336655.0

2021 mean: 1030291 2021 summer mean: 1018395 2021 october: 1103788.0

Region: New York, NY

2018 mean: 83553 2018 summer mean: 88229 2018 october: 90008.0

2019 mean: 87638 2019 summer mean: 92964 2019 october: 92042.0

2020 mean: 75086 2020 summer mean: 73891 2020 october: 80472.0

2021 mean: 62319 2021 summer mean: 63055 2021 october: 62220.0

Region: Los Angeles-Long Beach-Anaheim, CA

2018 mean: 26537 2018 summer mean: 27216 2018 october: 30882.0

2019 mean: 29159 2019 summer mean: 30873 2019 october: 30336.0

2020 mean: 23593 2020 summer mean: 23422 2020 october: 26280.0

2021 mean: 20728 2021 summer mean: 20979 2021 october: 20776.0

Region: Chicago, IL

2018 mean: 52401 2018 summer mean: 55348 2018 october: 58210.0

2019 mean: 55275 2019 summer mean: 58710 2019 october: 60755.0

2020 mean: 48032 2020 summer mean: 49397 2020 october: 49571.0

2021 mean: 37212 2021 summer mean: 37484 2021 october: 40272.0

Region: Dallas-Fort Worth, TX

2018 mean: 30213 2018 summer mean: 31446 2018 october: 34264.0

2019 mean: 35277 2019 summer mean: 36864 2019 october: 38689.0

2020 mean: 31602 2020 summer mean: 33497 2020 october: 30087.0

2021 mean: 22887 2021 summer mean: 22723 2021 october: 24094.0

Region: Philadelphia, PA

2018 mean: 28963 2018 summer mean: 30608 2018 october: 29842.0

2019 mean: 28452 2019 summer mean: 30209 2019 october: 29191.0

2020 mean: 21579 2020 summer mean: 21682 2020 october: 21399.0

2021 mean: 18194 2021 summer mean: 18693 2021 october: 20041.0

Region: Houston, TX

2018 mean: 37755 2018 summer mean: 39539 2018 october: 40148.0

2019 mean: 41086 2019 summer mean: 42703 2019 october: 43763.0

2020 mean: 37596 2020 summer mean: 39796 2020 october: 35014.0

2021 mean: 27836 2021 summer mean: 27116 2021 october: 28997.0

Region: Washington, DC

2018 mean: 25347 2018 summer mean: 27711 2018 october: 25843.0

2019 mean: 22865 2019 summer mean: 24814 2019 october: 24281.0

2020 mean: 18723 2020 summer mean: 19383 2020 october: 19257.0

2021 mean: 17760 2021 summer mean: 18747 2021 october: 20374.0

Region: Miami-Fort Lauderdale, FL

2018 mean: 64227 2018 summer mean: 65527 2018 october: 63210.0

2019 mean: 66906 2019 summer mean: 68900 2019 october: 63654.0

2020 mean: 61015 2020 summer mean: 61352 2020 october: 59112.0

2021 mean: 40978 2021 summer mean: 37846 2021 october: 33031.0

Region: Atlanta, GA

2018 mean: 33279 2018 summer mean: 34083 2018 october: 36061.0

2019 mean: 37542 2019 summer mean: 38615 2019 october: 40622.0

2020 mean: 34718 2020 summer mean: 36957 2020 october: 32668.0

2021 mean: 23582 2021 summer mean: 22854 2021 october: 23607.0

Region: Boston, MA

2018 mean: 14170 2018 summer mean: 14920 2018 october: 17091.0

2019 mean: 15501 2019 summer mean: 16810 2019 october: 17061.0

2020 mean: 12752 2020 summer mean: 13157 2020 october: 14446.0

2021 mean: 10405 2021 summer mean: 10987 2021 october: 11341.0

Region: San Francisco, CA

2018 mean: 7128 2018 summer mean: 7567 2018 october: 8888.0

2019 mean: 8150 2019 summer mean: 8914 2019 october: 9181.0

2020 mean: 7619 2020 summer mean: 7496 2020 october: 9964.0

2021 mean: 7954 2021 summer mean: 8303 2021 october: 8816.0

Region: Detroit, MI

2018 mean: 18298 2018 summer mean: 18331 2018 october: 21973.0

2019 mean: 20457 2019 summer mean: 20483 2019 october: 23877.0

2020 mean: 17044 2020 summer mean: 17125 2020 october: 17332.0

2021 mean: 13300 2021 summer mean: 13167 2021 october: 16320.0

Region: Riverside, CA

2018 mean: 20442 2018 summer mean: 20847 2018 october: 22087.0

2019 mean: 20951 2019 summer mean: 21545 2019 october: 21063.0

2020 mean: 15513 2020 summer mean: 15921 2020 october: 13953.0

2021 mean: 11505 2021 summer mean: 11355 2021 october: 13361.0

Region: Phoenix, AZ

2018 mean: 26688 2018 summer mean: 27790 2018 october: 25592.0

2019 mean: 26766 2019 summer mean: 28743 2019 october: 24468.0

2020 mean: 22056 2020 summer mean: 22715 2020 october: 21484.0

2021 mean: 18133 2021 summer mean: 17914 2021 october: 19718.0

Region: Seattle, WA

2018 mean: 11430 2018 summer mean: 11717 2018 october: 15044.0

2019 mean: 12447 2019 summer mean: 13807 2019 october: 13695.0

2020 mean: 9839 2020 summer mean: 10183 2020 october: 12118.0

2021 mean: 9434 2021 summer mean: 10144 2021 october: 10471.0

Region: Minneapolis-St Paul, MN

2018 mean: 13766 2018 summer mean: 14667 2018 october: 16442.0

2019 mean: 14441 2019 summer mean: 15287 2019 october: 17198.0

2020 mean: 13166 2020 summer mean: 13960 2020 october: 14468.0

2021 mean: 11145 2021 summer mean: 11552 2021 october: 13504.0

Region: San Diego, CA

2018 mean: 8924 2018 summer mean: 9180 2018 october: 10605.0

2019 mean: 9664 2019 summer mean: 10243 2019 october: 9928.0

2020 mean: 7361 2020 summer mean: 7605 2020 october: 7580.0

2021 mean: 6008 2021 summer mean: 6235 2021 october: 6123.0

Region: St. Louis, MO

2018 mean: 14475 2018 summer mean: 15049 2018 october: 15634.0

2019 mean: 13524 2019 summer mean: 13910 2019 october: 14533.0

2020 mean: 11213 2020 summer mean: 11437 2020 october: 11108.0

2021 mean: 8383 2021 summer mean: 8333 2021 october: 9024.0

Region: Tampa, FL

2018 mean: 21479 2018 summer mean: 22208 2018 october: 21502.0

2019 mean: 22225 2019 summer mean: 22815 2019 october: 21573.0

2020 mean: 18420 2020 summer mean: 19370 2020 october: 16244.0

2021 mean: 12144 2021 summer mean: 11559 2021 october: 12355.0

Region: Baltimore, MD

2018 mean: 14167 2018 summer mean: 15028 2018 october: 14568.0

2019 mean: 13819 2019 summer mean: 14642 2019 october: 14693.0

2020 mean: 10396 2020 summer mean: 10732 2020 october: 9853.0

2021 mean: 8127 2021 summer mean: 8347 2021 october: 9346.0

Region: Denver, CO

2018 mean: 14797 2018 summer mean: 15602 2018 october: 17725.0

2019 mean: 17059 2019 summer mean: 18393 2019 october: 19514.0

2020 mean: 14207 2020 summer mean: 15670 2020 october: 14944.0

2021 mean: 8128 2021 summer mean: 8007 2021 october: 9036.0

Region: Pittsburgh, PA

2018 mean: 11260 2018 summer mean: 11695 2018 october: 11708.0

2019 mean: 10163 2019 summer mean: 10477 2019 october: 10583.0

2020 mean: 8347 2020 summer mean: 8403 2020 october: 8473.0

2021 mean: 6460 2021 summer mean: 6454 2021 october: 7497.0

Region: Portland, OR

2018 mean: 10010 2018 summer mean: 10334 2018 october: 12200.0

2019 mean: 10873 2019 summer mean: 11527 2019 october: 12122.0

2020 mean: 9014 2020 summer mean: 9641 2020 october: 9419.0

2021 mean: 7154 2021 summer mean: 7382 2021 october: 8242.0

Region: Charlotte, NC

2018 mean: 12244 2018 summer mean: 12995 2018 october: 13170.0

2019 mean: 13526 2019 summer mean: 14245 2019 october: 14810.0

2020 mean: 11160 2020 summer mean: 11813 2020 october: 10319.0

2021 mean: 7484 2021 summer mean: 7327 2021 october: 8021.0

Region: Sacramento, CA

2018 mean: 7697 2018 summer mean: 8017 2018 october: 9302.0

2019 mean: 7977 2019 summer mean: 8377 2019 october: 9028.0

2020 mean: 6535 2020 summer mean: 6979 2020 october: 6705.0

2021 mean: 4914 2021 summer mean: 4775 2021 october: 6079.0

Region: San Antonio, TX

2018 mean: 13174 2018 summer mean: 13783 2018 october: 13920.0

2019 mean: 15134 2019 summer mean: 15660 2019 october: 16470.0

2020 mean: 14368 2020 summer mean: 15193 2020 october: 13478.0

2021 mean: 9113 2021 summer mean: 8595 2021 october: 9262.0

Region: Orlando, FL

2018 mean: 13525 2018 summer mean: 13781 2018 october: 14184.0

2019 mean: 14367 2019 summer mean: 14816 2019 october: 14338.0

2020 mean: 13074 2020 summer mean: 13328 2020 october: 13013.0

2021 mean: 10050 2021 summer mean: 9558 2021 october: 9654.0

Region: Cincinnati, OH

2018 mean: 9151 2018 summer mean: 9361 2018 october: 10208.0

2019 mean: 8948 2019 summer mean: 9218 2019 october: 9565.0

2020 mean: 7149 2020 summer mean: 7343 2020 october: 7091.0

2021 mean: 5600 2021 summer mean: 5508 2021 october: 6462.0

Region: Cleveland, OH

2018 mean: 13355 2018 summer mean: 13923 2018 october: 14386.0

2019 mean: 13118 2019 summer mean: 13678 2019 october: 14295.0

2020 mean: 10136 2020 summer mean: 10160 2020 october: 10231.0

2021 mean: 6256 2021 summer mean: 5823 2021 october: 6886.0

Region: Raleigh, NC

2018 mean: 7347 2018 summer mean: 7820 2018 october: 7636.0

2019 mean: 8074 2019 summer mean: 8358 2019 october: 8851.0

2020 mean: 7146 2020 summer mean: 7684 2020 october: 6379.0

2021 mean: 3603 2021 summer mean: 3385 2021 october: 3635.0

submitted by /u/Antique-Water-3898
[link] [comments]

I have seen a number of posts on inventory, but no real data — only anecdotes. Zillow does provide the statistics for all major metropolitan areas here. It is not enough for micro-segmentation, but does provide a clear macro picture. I took that data and summarized it below for 40 or so big markets which took 10 mins. If any one wants to do other analysis, I can post relevant python code. The take away, is that overall the US inventory is still very low, but it looks like it is ticking up in the last couple of months — although the picture is very market dependent. For example, it shows that San Fran never had an inventory dip even during the pandemic. Some other areas are actually back to pre-pandemic inventory. Here is the data — if you need clarification, you can ask. I added the mean yearly inventory (only for first 10 months of 2021), mean for summer season (April-August) and the inventory for October 2021 (the last month of stats available). Region: United States 2018 mean: 1622601 2018 summer mean: 1681032 2018 october: 1750118.0 2019 mean: 1646678 2019 summer mean: 1709802 2019 october: 1742627.0 2020 mean: 1378345 2020 summer mean: 1429977 2020 october: 1336655.0 2021 mean: 1030291 2021 summer mean: 1018395 2021 october: 1103788.0 Region: New York, NY 2018 mean: 83553 2018 summer mean: 88229 2018 october: 90008.0 2019 mean: 87638 2019 summer mean: 92964 2019 october: 92042.0 2020 mean: 75086 2020 summer mean: 73891 2020 october: 80472.0 2021 mean: 62319 2021 summer mean: 63055 2021 october: 62220.0 Region: Los Angeles-Long Beach-Anaheim, CA 2018 mean: 26537 2018 summer mean: 27216 2018 october: 30882.0 2019 mean: 29159 2019 summer mean: 30873 2019 october: 30336.0 2020 mean: 23593 2020 summer mean: 23422 2020 october: 26280.0 2021 mean: 20728 2021 summer mean: 20979 2021 october: 20776.0 Region: Chicago, IL 2018 mean: 52401 2018 summer mean: 55348 2018 october: 58210.0 2019 mean: 55275 2019 summer mean: 58710 2019 october: 60755.0 2020 mean: 48032 2020 summer mean: 49397 2020 october: 49571.0 2021 mean: 37212 2021 summer mean: 37484 2021 october: 40272.0 Region: Dallas-Fort Worth, TX 2018 mean: 30213 2018 summer mean: 31446 2018 october: 34264.0 2019 mean: 35277 2019 summer mean: 36864 2019 october: 38689.0 2020 mean: 31602 2020 summer mean: 33497 2020 october: 30087.0 2021 mean: 22887 2021 summer mean: 22723 2021 october: 24094.0 Region: Philadelphia, PA 2018 mean: 28963 2018 summer mean: 30608 2018 october: 29842.0 2019 mean: 28452 2019 summer mean: 30209 2019 october: 29191.0 2020 mean: 21579 2020 summer mean: 21682 2020 october: 21399.0 2021 mean: 18194 2021 summer mean: 18693 2021 october: 20041.0 Region: Houston, TX 2018 mean: 37755 2018 summer mean: 39539 2018 october: 40148.0 2019 mean: 41086 2019 summer mean: 42703 2019 october: 43763.0 2020 mean: 37596 2020 summer mean: 39796 2020 october: 35014.0 2021 mean: 27836 2021 summer mean: 27116 2021 october: 28997.0 Region: Washington, DC 2018 mean: 25347 2018 summer mean: 27711 2018 october: 25843.0 2019 mean: 22865 2019 summer mean: 24814 2019 october: 24281.0 2020 mean: 18723 2020 summer mean: 19383 2020 october: 19257.0 2021 mean: 17760 2021 summer mean: 18747 2021 october: 20374.0 Region: Miami-Fort Lauderdale, FL 2018 mean: 64227 2018 summer mean: 65527 2018 october: 63210.0 2019 mean: 66906 2019 summer mean: 68900 2019 october: 63654.0 2020 mean: 61015 2020 summer mean: 61352 2020 october: 59112.0 2021 mean: 40978 2021 summer mean: 37846 2021 october: 33031.0 Region: Atlanta, GA 2018 mean: 33279 2018 summer mean: 34083 2018 october: 36061.0 2019 mean: 37542 2019 summer mean: 38615 2019 october: 40622.0 2020 mean: 34718 2020 summer mean: 36957 2020 october: 32668.0 2021 mean: 23582 2021 summer mean: 22854 2021 october: 23607.0 Region: Boston, MA 2018 mean: 14170 2018 summer mean: 14920 2018 october: 17091.0 2019 mean: 15501 2019 summer mean: 16810 2019 october: 17061.0 2020 mean: 12752 2020 summer mean: 13157 2020 october: 14446.0 2021 mean: 10405 2021 summer mean: 10987 2021 october: 11341.0 Region: San Francisco, CA 2018 mean: 7128 2018 summer mean: 7567 2018 october: 8888.0 2019 mean: 8150 2019 summer mean: 8914 2019 october: 9181.0 2020 mean: 7619 2020 summer mean: 7496 2020 october: 9964.0 2021 mean: 7954 2021 summer mean: 8303 2021 october: 8816.0 Region: Detroit, MI 2018 mean: 18298 2018 summer mean: 18331 2018 october: 21973.0 2019 mean: 20457 2019 summer mean: 20483 2019 october: 23877.0 2020 mean: 17044 2020 summer mean: 17125 2020 october: 17332.0 2021 mean: 13300 2021 summer mean: 13167 2021 october: 16320.0 Region: Riverside, CA 2018 mean: 20442 2018 summer mean: 20847 2018 october: 22087.0 2019 mean: 20951 2019 summer mean: 21545 2019 october: 21063.0 2020 mean: 15513 2020 summer mean: 15921 2020 october: 13953.0 2021 mean: 11505 2021 summer mean: 11355 2021 october: 13361.0 Region: Phoenix, AZ 2018 mean: 26688 2018 summer mean: 27790 2018 october: 25592.0 2019 mean: 26766 2019 summer mean: 28743 2019 october: 24468.0 2020 mean: 22056 2020 summer mean: 22715 2020 october: 21484.0 2021 mean: 18133 2021 summer mean: 17914 2021 october: 19718.0 Region: Seattle, WA 2018 mean: 11430 2018 summer mean: 11717 2018 october: 15044.0 2019 mean: 12447 2019 summer mean: 13807 2019 october: 13695.0 2020 mean: 9839 2020 summer mean: 10183 2020 october: 12118.0 2021 mean: 9434 2021 summer mean: 10144 2021 october: 10471.0 Region: Minneapolis-St Paul, MN 2018 mean: 13766 2018 summer mean: 14667 2018 october: 16442.0 2019 mean: 14441 2019 summer mean: 15287 2019 october: 17198.0 2020 mean: 13166 2020 summer mean: 13960 2020 october: 14468.0 2021 mean: 11145 2021 summer mean: 11552 2021 october: 13504.0 Region: San Diego, CA 2018 mean: 8924 2018 summer mean: 9180 2018 october: 10605.0 2019 mean: 9664 2019 summer mean: 10243 2019 october: 9928.0 2020 mean: 7361 2020 summer mean: 7605 2020 october: 7580.0 2021 mean: 6008 2021 summer mean: 6235 2021 october: 6123.0 Region: St. Louis, MO 2018 mean: 14475 2018 summer mean: 15049 2018 october: 15634.0 2019 mean: 13524 2019 summer mean: 13910 2019 october: 14533.0 2020 mean: 11213 2020 summer mean: 11437 2020 october: 11108.0 2021 mean: 8383 2021 summer mean: 8333 2021 october: 9024.0 Region: Tampa, FL 2018 mean: 21479 2018 summer mean: 22208 2018 october: 21502.0 2019 mean: 22225 2019 summer mean: 22815 2019 october: 21573.0 2020 mean: 18420 2020 summer mean: 19370 2020 october: 16244.0 2021 mean: 12144 2021 summer mean: 11559 2021 october: 12355.0 Region: Baltimore, MD 2018 mean: 14167 2018 summer mean: 15028 2018 october: 14568.0 2019 mean: 13819 2019 summer mean: 14642 2019 october: 14693.0 2020 mean: 10396 2020 summer mean: 10732 2020 october: 9853.0 2021 mean: 8127 2021 summer mean: 8347 2021 october: 9346.0 Region: Denver, CO 2018 mean: 14797 2018 summer mean: 15602 2018 october: 17725.0 2019 mean: 17059 2019 summer mean: 18393 2019 october: 19514.0 2020 mean: 14207 2020 summer mean: 15670 2020 october: 14944.0 2021 mean: 8128 2021 summer mean: 8007 2021 october: 9036.0 Region: Pittsburgh, PA 2018 mean: 11260 2018 summer mean: 11695 2018 october: 11708.0 2019 mean: 10163 2019 summer mean: 10477 2019 october: 10583.0 2020 mean: 8347 2020 summer mean: 8403 2020 october: 8473.0 2021 mean: 6460 2021 summer mean: 6454 2021 october: 7497.0 Region: Portland, OR 2018 mean: 10010 2018 summer mean: 10334 2018 october: 12200.0 2019 mean: 10873 2019 summer mean: 11527 2019 october: 12122.0 2020 mean: 9014 2020 summer mean: 9641 2020 october: 9419.0 2021 mean: 7154 2021 summer mean: 7382 2021 october: 8242.0 Region: Charlotte, NC 2018 mean: 12244 2018 summer mean: 12995 2018 october: 13170.0 2019 mean: 13526 2019 summer mean: 14245 2019 october: 14810.0 2020 mean: 11160 2020 summer mean: 11813 2020 october: 10319.0 2021 mean: 7484 2021 summer mean: 7327 2021 october: 8021.0 Region: Sacramento, CA 2018 mean: 7697 2018 summer mean: 8017 2018 october: 9302.0 2019 mean: 7977 2019 summer mean: 8377 2019 october: 9028.0 2020 mean: 6535 2020 summer mean: 6979 2020 october: 6705.0 2021 mean: 4914 2021 summer mean: 4775 2021 october: 6079.0 Region: San Antonio, TX 2018 mean: 13174 2018 summer mean: 13783 2018 october: 13920.0 2019 mean: 15134 2019 summer mean: 15660 2019 october: 16470.0 2020 mean: 14368 2020 summer mean: 15193 2020 october: 13478.0 2021 mean: 9113 2021 summer mean: 8595 2021 october: 9262.0 Region: Orlando, FL 2018 mean: 13525 2018 summer mean: 13781 2018 october: 14184.0 2019 mean: 14367 2019 summer mean: 14816 2019 october: 14338.0 2020 mean: 13074 2020 summer mean: 13328 2020 october: 13013.0 2021 mean: 10050 2021 summer mean: 9558 2021 october: 9654.0 Region: Cincinnati, OH 2018 mean: 9151 2018 summer mean: 9361 2018 october: 10208.0 2019 mean: 8948 2019 summer mean: 9218 2019 october: 9565.0 2020 mean: 7149 2020 summer mean: 7343 2020 october: 7091.0 2021 mean: 5600 2021 summer mean: 5508 2021 october: 6462.0 Region: Cleveland, OH 2018 mean: 13355 2018 summer mean: 13923 2018 october: 14386.0 2019 mean: 13118 2019 summer mean: 13678 2019 october: 14295.0 2020 mean: 10136 2020 summer mean: 10160 2020 october: 10231.0 2021 mean: 6256 2021 summer mean: 5823 2021 october: 6886.0 Region: Raleigh, NC 2018 mean: 7347 2018 summer mean: 7820 2018 october: 7636.0 2019 mean: 8074 2019 summer mean: 8358 2019 october: 8851.0 2020 mean: 7146 2020 summer mean: 7684 2020 october: 6379.0 2021 mean: 3603 2021 summer mean: 3385 2021 october: 3635.0 submitted by /u/Antique-Water-3898 [link] [comments]

<a href="Read More“>View Full Article

Need More Commercial Real Estate Leads?SAVE 40% this month!

Our commercial valuation calculator was created to evaluate commercial real estate. In 6 quick steps you will know your NOI, CAP RATE, and IRR.

Now you can get your own branded version of our calculator!