@Harsh Poshti Some of my investment focus in the past few years has been geared towards mix-use assets. As a general rule of thumb if the property has a ground level commercial requirement in order to show sufficient hardship to seek a residential use change the property should be located in a location that is not conducive to commercial use i.e residential street, close but not as marketable as properties located on neighborhood's primary commercial corridor etc.
You received some feedback from @Mija Aguilera who has local expertise and knowledge of the area and I am interpreting his comments as the location is viable for commercial use. Therefore you should speak with a local zoning attorney and architect to determine the viability of a use change. It is also helpful to determine the precise commercial uses that are allowed. Most municipalities have different mix-use categories which dictate the precise commercial use that's allowed.
A few additional observations on mix-use assets and how I approach them
(1) they are generally more difficult to finance than multi-family assets so expect lower leverage terms even if the property performs just as well if not better than a multi-family property and therefore price this into your acquisition
(2) I focus on mix-use assets where at least 80% of the income is generated through the residential component. I prefer properties that are heavily focused on the residential component because mix-use assets receive far less attention than multi-family assets. For illustration purposes, it's quite normal to acquire a mix use building consisting of 9 residential units + 1 commercial space for less than a 9 unit multi-family building would trade in the equivalent location because the commercial space is an automatic disqualifier for many investors. This is something I've found in Philadelphia where I invest and the same holds true in many markets. Also having a higher proportion of revenue generated through the residential component of the building does make financing easier.
(3) The exception to the 80% rule I abide by is when the commercial space is leased to a credit tenant with a proven & sustainable business or where the space presents the opportunity to attract a neighborhood amenity F&B operator (this is most beneficial in instances where you have a larger localized portfolio where these commercial tenants can positively impact the value of your overall residential portfolio). This may not be a worthwhile pursuit if you don't fall under that category because there is some added risk involved.
4. To reinforce what I said about making sure the credit tenant is proven and sustainable all you have to do is look back on the past 15 years or so:
2009-2012: frozen yogurt
2012-2014: “new and improved burger” spots
2014-2015: spin class
2015-2016: megaformer and Pilates
2016-2017: poke bowl
2021-2022: "new and improved cookie" spots
2021-2023: indoor golf
2024: pickleball
(5) If you are in a situation where seeking an F&B operator, be aware at this time these operators are seeking very high T&I allowances which may not be a worthwhile investment for you to make.