Morgan - this is a sample of the report format that we email out each month. The Community List is static, Total # homes is static, Available Homes (pull from active listings by advanced snippet criteria), and percentage is a computation we would like the system to make. I would like this to be dynamic against the current IDX feed.
To effectively select the 'Avaliable Homes' we will need to be able to restrict our search by the following criteria;
City(s)
Sub-Division Name(s)
MLS Area(s)
Street(s)
Waterfront Description(s)
Property Type(s)
We would also want the abiltiy to manually override the computed number (the number available would be static until we change it in this case).
FYI - we would have each community name hyperlinked to the specific page on the website that displays the description and search results from our snippet with community listings.
Mirasol
Community | Total Homes | Available Homes | Percentage Available |
Andalusia | 70 | 4 | 6% |
Bianca | 41 | 0 | 0% |
Capri | 18 | 1 | 6% |
Esperanza | 68 | 5 | 7% |
Florenza | 33 | 2 | 6% |
Magdalena | 29 | 9 | 31% |
Mariposa | 38 | 0 | 0% |
Monte Carlo | 49 | 4 | 8% |
Olivera | 41 | 3 | 7% |
Palacio | 70 | 6 | 9% |
Paradisio | 46 | 2 | 4% |
Playa Rienta | 35 | 5 | 14% |
Porto Vecchio | 135 | 13 | 10% |
Riviera | 78 | 8 | 10% |
Quantera | 38 | 0 | 0% |
San Remo | 56 | 11 | 20% |
Siesta | 29 | 2 | 7% |
Talavera | 25 | 2 | 8% |
Terra Linda | 31 | 3 | 10% |
Tranquilla | 40 | 3 | 8% |
Via Verde | 34 | 2 | 6% |
Villa Vasari | 27 | 7 | 26% |
Villa Vizcaya | 79 | 3 | 4% |
Vizcaya Estates | 54 | 9 | 17% |
| |||
Total Homes | 1164 | 104 | 9% |