The Advanced search allows you to search based on any of the property attributes that are available in the CEO database.  This allows you to perform more complicated queries, such as “all colonial homes onMain St. with 4 bedrooms that sold in 2005”, or “homes on more than 5 acres with more than 5000 square feet of living space”.

To perform an advanced search, you enter one or more search conditions, and indicate whether you want to see properties that meet ALL of your search conditions, or that match ANY of your search conditions.  To choose ALL search conditions, pick the “AND” option, and to choose properties that meet ANY search condition, pick the “OR” option.

To enter a search condition, you pick a field name, an operator, and enter a search value.

• Field name.  This is a list of available data about each property.
• Operator.  This allows you to pick the type of query you want to perform.  Most of these operators are straightforward, such as “=”, “<”, “>”, etc.  The “LIKE” operator allows you to perform a “fuzzy” search on textual
• Value.  This is a value that you enter.

To enter an addition search condition, click on the “Add Criteria” link and another row will appear.

 When you have completed entering your search criteria, click on the “Submit Search” link.