I'm sure you are aware, in typical free markets with typical outside influences, returns move inline with risk and inverse to demand. The higher risk deal - the higher the potential returns and vice-versa. The more demand - the lower the potential returns and vice-versa. So, the higher the return potential, the higher the relative risk and the lower demand, which does not typically equal an "A-Market" ("A-neighborhood"). So, what you are asking for, goes against typical market forces and results - a higher than typical return (7-8%), in a higher demand/lower relative risk area (A-neighborhood). So, what you are seeking is challenging to find. I never say never, because I do believe unicorns eixist. :) But, it is more likely you may need to find an animal with a similar body type and attach a custom horn and paint it purple, pink, rainbow or whatever color/s you choose. Point being, you have a better chance creating the conditions for your preferred returns in a deal, than stumbling upon the unicorn or someone willing to share the unicorn with you.
Additional Brain Droppings:
* SFRs in A-neighborhoods are typically higher priced, with lower returns, since more people want to live there (i.e. higher demand) and are therefore, willing to pay more money (i.e. lower returns), because they value more then cashflow returns in those neighborhoods. These neighborhoods are typically made up of more owner occupied properties, reflecting motivations other than strictly financial returns. So, you'd be competing with those owner-occupant buyers.
* Less owner occupants are typically interested in multi-unit properties, and therefore, there is less outside motivations (emotions, etc) and more emphasis on financial returns (investor motivations). This causes returns to be more inline with risk. Example would be someone who could put cash in a money market account @ 5%, would probably want to have more than a 5% return on a multi-unit property with the potential of more risk.
* The better returns may be found in B/C areas in the path of growth and gentrification. Smartly researched B areas can become A areas over time.
* You point out you don't want to be in a market which has appreciated 50% in the past 24 months, but those are most likely A-neighborhoods, because demand pushed the appreciation in those areas. I personally would be concerned about investing in an area that didn't have a fair amount of recent appreciation, or at least I would try and understand why it didn't and be aware of my goals when investing in those areas. I mean, why would you want to be in an area that nobody else wanted to be in, when they could've purchased with a 3% mortgage? I have owned those properties in those areas and was happy to "dump" them years ago.
* Generally , for what you are looking for, you would have to "create" it, either by moderate to major value-adds, build from ground-up, add additional units (a lot of areas are encouraging adu's now), etc.
* You may be more interested in looking at other investment vehicles instead of real estate, if you need to have those returns you desire. Like syndications or other investment opportunity funds. I know of 2 opportunities right now where they are conservatively projecting 8% cashflow returns (and realistically expecting much higher), with very trustworthy smart people.
* Or, why not do hard money lending or other lending, you could easily get 8%+ on low ltv loans right now, with reduced, controlled risk. I have a client that just got two 12% loans from a lender, with a low ltv, she would've been happy to pay 10% elsewhere.
Good luck with whatever direction you choose.