Thank you all for the detailed feedback and personal stories! I did some on the ground research and asked a few neighbors, some of which have lived in the neighborhood for over 50 years, all said they've never had issues with flooding, even in Monsoon season the street flows a bit but is heavily supported by storm water drains and never near the homes. I got an initial estimate and it came in way higher than I was hoping, my agent dug a little further and spoke to FEMA underwriters and they corrected his quote and reduced it by 4x!! needless to say, the flood insurance is now under budget and fits within my overall insurance budget (after getting a few additional discounts on my home insurance quote ;) )
The deal now definitely pencils for me. I get that it could be a matter when but the home is far enough from the street that is troublesome that I am fairly confident it will be fine. This home will be a personal residence (which I will be house hacking with 2 roommates), then an airbnb or rental in a few years with great supporting comps and favorable cash flows. Thanks again everyone for all your valuable insight!!