Searching Instructions

Type the comparison operator and the value you wish to search for in the rightmost column. If you do not include a comparison operator then "=" will be used. Valid comparison operators and examples are listed below: Do not type in the quotation marks.

Typing "=1234 Main" in "Property Address" will get the property at that address if it exists.
Typing "1234 Main" in "Property Address" will get the same result as "=1234 Main".
Typing ">1234 Main" in "Property Address" will get properties Greater than "1234 Main".
Typing ">=1234 Main" in "Property Address" will get properties Greater Than OR Equal to "1234 Main".
Typing "<1234 Main" in "Property Address" will get properties Less Than "1234 Main".
Typing "<=1234 Main" in "Property Address" will get properties Less Than OR Equal to "1234 Main".
Typing "$SMITH" in "Owner Name" will get properties where the owner name Contains "SMITH".
Typing a COMMA in a search means OR. "Smith, Jim" means "Jim" OR "Smith", not "JIM SMITH".
Typing "$SMITH,JONES" in "Owner Name" will get properties where the owner name Contains "Smith" OR is Equal To "Jones".
Typing "01/01/93" in "Sale Date" will get properties that sold on that date.
Typing ">01/01/93" in "Sale Date" will get properties that sold after that date.
Typing ">=01/01/93" in "Sale Date" will get properties that sold on OR after that date.
Typing "01/01/93,01/02/93" in "Sale Date" will get properties that sold on one of those dates.
Typing "01/01/93-02/01/93" in "Sale Date" will get properties that sold within that date Range.
Typing "01/01/93!-02/01/93" in "Sale Date" will get properties that Did NOT sell within that date Range.
Typing "!1234 Main" in "Property Address" will get properties NOT Equal to "1234 Main".
Typing "!$1234 Main" in "Property Address" will get properties NOT Containing "1234 Main".
Dates must be in the form "01/01/96" not "1/1/96" (We'll get rid of this requirement soon)
All searches are converted to UPPERCASE automatically.
Please note that addresses are often non-standard. If you don't find what you're looking for using "=", try "Contains".
Some searches are meaningless (Contains on a numeric value) and will be converted to Equals .
We now support standard wildcards. The * symbol will match any number of any character, and the ? will match any single character. For example, typing "1228*BROAD*" would match "1228 SE BROAD ST" while "SM?TH*" would match any names that start with something like "SMITH" or "SMYTH" etc.
Starting a text search with " (the double quote character) will search for EXACTLY what comes after that
Be creative.