For the S.H. engineers reading the thread, I just thought of another thing I need it to do (instantly and for free of course. I'm not paying for your app)
I want to be able to say "give me a list of up to 5 single-family homes for sale in the city I'm currently in that are among the lowest-priced 10 or so homes in the three categories of price per total square foot, price per finished square foot and price per above-grade finished square foot that also have at least 1800 sqft, 4 beds and 2 or more 3/4 or bigger bathrooms, are in the matriculation area of a good middle school and cost around $350k or less.". Then, when it gives me the list, I want it to explain to me:
* Where the heck did you get that data. County records? How do you know they're accurate? Did any of the properties make the cut because of a data-entry error? How do you know there aren't properties excluded from the list because they've been updated (i.e. the basement was finished) but that never made it into whatever source you got your records from. Acceptable answers would include "I screen-scraped 27 websites, including, zillow, trulia, realtor.com, remax.com, .com, the county assessor's website, etc.). I aggregated the data and identified and corrected or excluded probable incorrect data based on the most common data point among all my data sources, text provided by the seller/listing agent and asking prices that are high or low compared to similar houses on the market, taking into account sales history for each property, that might indicate inaccurate data."
* What makes the middle school a "good" middle school. "greatschools.com said so" isn't good enough. "70% of students made greater than the state average gains on last year's 8th grade state test in both reading and math" would be somewhat acceptable. But what I really want is that plus a summary of forum posts and such from parents and former students and teachers what make a good case for a school that everyone agrees is pretty good.
Actually, if it could do stuff like that, I would pay for it. Quite a lot, actually. I'd also welcome our AI overloards.