I have an excel sheet that I use to put in all of the data when looking at a deal to evaluate if it's worth purchasing.

What's everyone's favorite solution to find real estate data.

Being that it’s a new home in an undeveloped neighborhood the home could be cheaper but when neighborhood is complete home goes up in value.

The low income tenants and welfare crowd tend also like to sue more often, this is backed up by data insurance companies use when quoting your property based on poverty rates of neighborhood. 

I ideally hope to be able to target property up to around $1M in value, with 25% down, unless I purchase as a primary with FHA.

I'm sure there are other ways but this way seems to be popular for real estate investors who only want one subscription.There definitely will be some manual data entry work with doing it this way on a weekly/monthly basis for you but it sounds like you don't mind doing that anyway. 

However, because this data was collected over the past year and we just had the eviction moratorium lifted recently, my hunch is that the majority of the data attributing to this data set are the new asking rents once there is a vacancy.

Airdna and pricelabs have data on expected STR revenue for your location.

We have a trailing 12 data set that shows all the transaction pricing for each zip code in San Diego over the past 12 months I'd be happy to send along. 

Then you'll have an answer.For future listings, I believe you can connect Zillow to your CRM so that you collect the data automatically.