Where is the best city for house hacking in Maryland?

[Account Closed]

We are looking for the house for sale to start house hacking in Maryland. The affordable price range is 500-800k and never mind the area as long as located in Maryland. I was looking for a duplex but could find few in this area. I think split foyer is the best style to keep each privacy (There looks not so many supply in the market in Maryland though).

For me, there looks some areas I should consider and they have pros and cons.
My big question is “ Which place do many people want to rent even if owner is living together?”

My impression for each town is as follows:

Columbia, Ellicott City - Great to live and Great school district, but looks like the area for family (not ideal for house hacking?)

Rockville, Gaithersburg - Great area to live and more affordable than Bethesda area, but a little expensive than other areas and most homes are older

Frederick - Most affordable but a little far from DC and Baltimore

Towson - Great for house hacking but less supply

Silver Spring, Kensington - Great access to DC but less home ideal for house hacking

If you have other opinions about my opinions, it would be appreciated if you could tell me.
Looking forward to hearing from your advice!