I am looking to take what I have currently but and add additional features and make it more user friendly.
This website can take a CSV file of available for sale properties and compares it to a CSV file of sold properties for sale using several criteria and filters.
Here is the site to show how it currently works:
This is what I currently do
I upload a CSV file of available for sale properties (usually done once per day) that I get from our MLS.
I upload a CSV file of sold properties (usually done once per month).
I click on the Results for ARMLS properties and it calculates the results and put the results in an ascending order based on a certain field that is calculated.
If it meets the criteria, then I move it to In Review (out of Results and into another section).
In the In Review section, I can input several fields and have an email generated with a PDF attachment.
This is what I would like the process to be:
NEW - Available for sale properties are automatically added as they become available for sale. Properties are updated several times per day. This is to be done thru a RETS license with the MLS.
NEW - Available for sale properties are removed based on filters set by the user
NEW - Sold properties are automatically added as they are sold. Properties are updated several times per day. This is to be done thru a RETS license with the MLS.
ALREADY BUILT - Each available for sale properties is compared to the list of sold properties and must match all criteria set by the user in order to be determined a comparable property.
ALREADY BUILT - Properties that meet certain minimum criteria are put into a Results section
conditions are moved automatically into In Review (or a section where they are put so someone knows to review them).
NEW - A notification email is sent to a user who wants notifications of properties that meet certain criteria.
ALREADY BUILT - From the In Review, able to write an offer (similar to current process), review the offer history and remove the property.
ALREADY BUILT - If active, for sale properties are deleted, those same properties are deleted from the Results section, BUT if that property was moved into the IN REVIEW section, that property WOULD NOT be deleted, only can be deleted from the In Review section.
ALREADY BUILT BUT NEEDS IMPROVEMENT - I would like a similar setup to work with Zillow posted properties as well, scraping or pulling results from a search and having it compared in a similar way. These results would be kept separate from the MLS properties.
NEW - If a property changes status from Active, there is a field showing this.
ALREADY BUILT BUT NEEDS IMPROVEMENT - For the manual entry process, a property would be entered and a similar screen for results would show and the ability to make an offer from this Results page (don't need an In Review section since doing 1 at a time). Can insert multiple properties at once and they would continue to save until they are chosen to be removed by user.
The properties that are available for sale would be filtered using the following criteria:
Price - Low
Price - High
Property Sqft - Low
Property Sqft - High
Land Sqft - Low
Land Sqft - High
Year Built - Low
Year Built - High
Total Covered Spaces - Low
Total Covered Spaces - High
Special Listing Condition
Status of Active
# of Interior Levels
% of Market Value - Low
% of Market Value - High
By Pool Type (None, Both, Community, Private)
Those properties that make it past the filters above are compared to sold properties. In order for a sold property to be considered a comparable property must meet the criteria below. Each of these have options to pick from a drop down.
1) Distance (1/4 mi, 1/2 mile (default), 1 mile, 2 miles)
2) Property Sqft (5%, 10%, 15% (default), 20%, 25%) - this is to be within +/- of active property sqft
3) Year Built (5, 10, 15, 20, 25, 30) - this is to be within +/- years of active property
4) Same interior levels (yes (default), no)
5) Match pool type (yes (default), no)
6) Sold property must be within 6 months of today's date
NEW - I would like to have the property value showing up on a range, like a sliding bar, with the image of the active property on that range and the comparable properties also on that range. For example, the range of comparable sales are $100,000 to $250,000 and this property is for sale at $125,000, there would be a picture of each comparable property, it's price.
ALREADY BUILT BUT NEEDS IMPROVEMENT - The PDF in the email needs to take the data inputted when submitting an offer and inserted into the PDF document. The PDF document must look identical to the original document.