Search Support Docs

Search
Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

Searching Properties – Four ways to find your data

Searching Properties – Four ways to find your data

Introduction (Please Read):
This document will help you to search for property records in the database that meet your criteria. This document is comprised of four sections:

Part 1 - The Lookup Box

Part 2 - The Search Button

Part 3 - Filter By Fields

Part 4 - The List Tab

Part 1 - The Lookup Box
The Lookup box located on the top right-hand side of the Property Overview screen is a quick way to find properties and owners in your database. Type in all or part of an owner’s name, owner company name, property name, address, city, submarket, subregion, type, sub-type, actual use and tenancy type then press the Enter key. The program will pull up every matching record. When you have completed your search select the ALL button to show all of your property records. Don’t forget that the List tab will display the search results in a summary format.
Lookup (2)
TIP: To jump the cursor to the Property Lookup Box anywhere in the program, press Ctrl + P keys.

Part 2 - The Search Button
Click the Search button on the upper middle part of the menu bar to bring up the Search screen. The search screen is where complicated or multi-step searches can be performed. **Remember, EVERY field is searchable!**
Untitled-1 (88)
Example: You wanted to find every apartment building in your database that is 60 units or larger but less than 501 units in the City of Scottsdale. On the Search screen select the Advanced tab and follow the labeled steps 1 through 4 on that screen.

To complete this search:
1) Select the “UNITS” field, “Is Greater or Equal” radio button, type “60” in the “Select a value” field and click the Add Criteria button.

2) Select the “UNITS” field, “Is Less or Equal” radio button, type “500” in the “Select a value” field and click the Add Criteria button.

3) Select the “CITY” field, “Equals” radio button, type or select “Scottsdale” in the “Select a value” field, click the Add Criteria button.

4) Click the Show Properties radio button and New Search radio button in the middle left side of the Search Screen.

5) Click the Search button. Realhound will now display your results. Finally, click the Goto Properties button to query your properties on the Property section of the program and close the Search screen.

Part 3 - Filter By Fields
Right click in any field that you want to filter (AKA “search”) in the database. A menu box pops up and gives you the following filter options for the selected data field:
Filter Drop-down (1)
Filter For: Entering data in this field will filter the selected records for an exact match to the data entered in the field. If you wanted to filter for all records that had the text “LLC” somewhere in the selected field you would enter in “*LLC*”. The asterisks tell the program to include any text strings before or after “LLC” and will be included in the Filter results (ie- Simpson Housing LLC, John Doe, Member). If you wanted to filter for all records that had JUST the text “LLC” in the selected field you would enter in “LLC”.

Filtering is not exactly the same thing as a Search. When a Filter is on, the rest of the records are hidden from view. When you have completed the filter, right click in the field that you were working with and select Remove Filter/Sort to unhide the rest of the records. If you would like to create a Search from a filter, go to the Overview tab and click the Apply Filter button.

Filter by Selection: Selecting this option will filter for records that have the exact matching text in the same field that is currently selected. All of the other records will be hidden until you select Remove Filter/Sort.

Filter Excluding Selection: Selecting this option will HIDE all records that have the exact matching text in the same field that is currently selected. These records will remain hidden until you select Remove Filter/Sort.

Remove Filter/Sort: Selecting this option removes the filter on the selected field.

Here is another practical example of the use of the Filter by field option. Let’s suppose that you needed to find every building on “S Pico Street”. Click the All button at the top of the screen and right-click in the address field on any property record. Select Filter For: and enter “*S Pico*” (again, the asterisks tell the program to include any text strings before or after “S Pico”) in the blank box and press the Enter key. Every property that has “S Pico” in its address will now be displayed. If you would like to create a Search from this filter, go to the Overview tab and click the Apply Filter button.

Part 4 - The List Tab
Click on the List tab located to the far right of the Overview tab. Click the ALL button on the top left side of the screen. At the top of the List screen you will see blank boxes under “Property Name”, “Address”, “City”, “Square Feet Range” “Unit Range”, “Type” and “Status”. Enter the information that you want to search for in the appropriate box and push the Lookup button.
Untitled-1 (89)
The results of your search will populate in the list. Double click on any property in the list to goto that property’s record. If you want to view all of the property records on the list, simply click on the Overview tab and you can click through the records at your leisure.
Untitled-1 (90)

« « Previous | Next » »