$500k Preapproval- Austin TX House Hack Duplex POSSIBLE?

[Account Closed]

Preapproved for $500k looking to buy 1st house hack duplex in Austin TX or neighboring areas. When I run the math it’s always a huge negative cash flow… and I don’t have many options within my budget for places in nicer area in Austin. Any suggestions of how I can make a profitable investment play in/near ATX? 

Hustling for off market? Or single family house hacking? Foreclosures?  

(I understand this is not legal investment advice just looking for insight from experienced investors.)