Why is housing most expensive in liberal areas and dirt cheap in other areas?

Real estate trends show an huge growth in demand for upscale apartments. Many are within mixed residential and commercial areas, allowing food delivery services to be close by. These new buildings have laundry services, gyms, private conference rooms for zoom meetings, day care centers, etc. Some have nice pools, hot tubs, pet services, and even rooftop bars. The growth of these new apartment buildings is filling a need for the new demand for a safe, comfortable rental, that will allow the occupants to travel without the requirements of a detached residential dwelling. The downside is the amount of rent being paid. As a person in the real estate profession, I see too many people spend over $45,000 per year on rent. The return on investment is just the previously listed intangibles. No equity is being built. The volume of detached single family residential dwellings listed on MLS services is at a very low volume. Therefore, it is a sellers market, with many listings selling above the asking price, with inspections being waived.