{"id":502,"date":"2016-04-09T12:07:06","date_gmt":"2016-04-09T17:07:06","guid":{"rendered":"http:\/\/opencomps.com\/blog\/?p=502"},"modified":"2016-08-23T00:15:34","modified_gmt":"2016-08-23T05:15:34","slug":"feature-review-advanced-search","status":"publish","type":"post","link":"https:\/\/www.opencomps.com\/blog\/2016\/04\/feature-review-advanced-search\/","title":{"rendered":"PRO Feature Review: Advanced Search"},"content":{"rendered":"

In OpenComps, easy and intuitive design is on top of our minds. To find something on OpenComps, we have a large search bar persistently on top of every page. It is big, it’s easy, it’s quick. (And did you know that\u00a0pressing “\/<\/strong>” on your keyboard on any<\/em><\/strong> screen, brings you inside that search bar? Type “?<\/strong>” (Shift+\/) to see all keyboard shortcuts<\/a>.)<\/p>\n

However, this basic search is like shooting with a canon; it searches for the given keywords in all<\/strong><\/em> database fields at once. Sometimes to kill the right bird, you need to shoot with a rifle, a more refined and precise instrument. This is where Advanced Search — available to all PRO subscribers — comes into play.<\/p>\n

\"Advanced<\/a><\/p>\n

You can find Advanced Search in the More dropdown<\/strong> at the end of the basic search field. On mobile, it is on the rightmost on the home row of buttons at the bottom of the screen. Or, you can type “a<\/strong> \/<\/strong>” (a<\/strong> followed by \/<\/strong>) as a keyboard shortcut (because you are a power user!).<\/p>\n

Let’s review each field:<\/p>\n

Transaction\u00a0Type<\/strong>
\nChoose between a Comp<\/strong> (property sale), For Sale<\/a><\/strong>, Development<\/a><\/strong> or Debt Comp<\/strong>.<\/p>\n

Transaction Status<\/strong>
\nOnly applicable for For Sale<\/em> or Development<\/em> transaction types. For For Sale<\/em>, you can choose between Active<\/em>, In Contract<\/em>, Closed<\/em> or Delisted<\/em>. For Development<\/em>, you can choose Planning<\/em>, Permitted<\/em>, In Construction<\/em>, Opened<\/em> or Cancelled<\/em>.<\/p>\n

Property Name<\/strong>
\nEnter keywords to search only within the Property Name<\/em> field.<\/p>\n

City<\/strong>
\nEnter keywords to search only within the City<\/em> field.<\/p>\n

Country<\/strong>
\nSelect a country from the dropdown list.<\/p>\n

State<\/strong>
\nIf you selected a country in the prior field that has associated states, you will be able to select them here.<\/p>\n

Address<\/strong>
\nEnter keywords to search only within the Street Address<\/em>\u00a0field.<\/p>\n

Postal Code<\/strong>
\nEnter keywords to search only within the Postal Code<\/em> (zipcode)\u00a0field.<\/p>\n

Proximity<\/strong>
\nEnter a radius (in miles) around an address to limit your search results around a specific geolocation. The Address field here takes anything that Google can recognize (so things like “union sq, nyc” or “jfk airport” or “staples center, la” are ok; don’t need to enter a full postal address, but you can if you wish.) For dense cities or places, like Manhattan, feel free to enter distances less than 1 mile, like 0.2 miles.<\/p>\n

Price\/Value (in US$)<\/strong>
\nUse this field to set a lower or upper limit of the transaction price or value. Enter full value (3000000) without abbreviations\u00a0(not 3M or 3 million) or thousands separator (no: 3,000,000). If you want to set only a lower limit, enter it in the From field and leave the To field empty (e.g. From $10 million or up – From: 3000000 \/ To: [blank]). If you want to set only an upper limit, enter it in the To field and leave the From field empty (e.g. Smaller than $50 million, From: [blank] \/ To: 50000000).<\/p>\n

Rooms<\/strong>
\nUse this field to set a lower or upper limit of the number of rooms.\u00a0Enter full value (1000) without thousands separator (no: 1,000). If you want to set only a lower limit, enter it in the From field and leave the To field empty.\u00a0If you want to set only an upper limit, enter it in the To field and leave the From field empty.<\/p>\n

Transaction Date<\/strong>
\nUse this field to set a limit on the dates of transactions. Enter transactions in the mm\/dd\/yyyy<\/em> format (e.g. 3\/1\/2016 for March 1st, 2016). If you want to capture transactions only after<\/em>\u00a0a given date, enter it in the From field and leave the To field empty.\u00a0If you want to capture transactions only before<\/em> a given date, enter it in the To field and leave the From field empty.<\/p>\n

Price\/Value Per Room (in US$)<\/strong>
\nUse this field to set a lower or upper limit of the transaction price or value per key. Enter full value (100000) without thousands separator (no: 100,000). If you want to set only a lower limit, enter it in the From field and leave the To field empty. If you want to set only an upper limit, enter it in the To field and leave the From field empty.<\/p>\n

Yield<\/strong>
\nUse this field to set a lower or upper limit of the transactions’ yield (or cap rate). Enter full value (7, for 7%) without percentage sign\u00a0(no: 7%). If you want to set only a lower limit, enter it in the From field and leave the To field empty. If you want to set only an upper limit, enter it in the To field and leave the From field empty.<\/p>\n

Year Built<\/strong>
\nUse this field to set a lower or upper limit of the transactions’ year – either year built (for comps, for sale or debt comps) or year to be build (for developments). Enter full value (2016). If you want to set only a lower limit, enter it in the From field and leave the To field empty. If you want to set only an upper limit, enter it in the To field and leave the From field empty.<\/p>\n

Brand<\/strong>
\nEnter keywords to search only within the Brand<\/em>\u00a0field.<\/p>\n

Property Manager<\/strong>
\nEnter keywords to search only within the Property Manager<\/em>\u00a0field.<\/p>\n

Buyer\/Developer<\/strong>
\nEnter keywords to search only within the Buyer<\/em> (aka Developer<\/em> for developments)\u00a0field.<\/p>\n

Buyer’s Broker<\/strong>
\nEnter keywords to search only within the Buyer’s Broker<\/em> field.<\/p>\n

Buyer’s Origin<\/strong>
\nSelect a country from the dropdown list.<\/p>\n

Owner<\/strong>
\nEnter keywords to search only within the Owner<\/em>\u00a0(aka\u00a0Seller<\/em>)\u00a0field.<\/p>\n

Owner’s\u00a0Broker<\/strong>
\nEnter keywords to search only within the Owner’s Broker<\/em> field.<\/p>\n

Owner’s\u00a0Origin<\/strong>
\nSelect a country from the dropdown list.<\/p>\n

Mortgage\u00a0Broker<\/strong>
\nEnter keywords to search only within the Mortgage Broker<\/em>\u00a0field. Mortgage Broker is the entity that arranged the acquisition or construction loan for a transaction, or refinances an existing loan.<\/p>\n

Lender<\/strong>
\nEnter keywords to search only within the Lender<\/em>\u00a0field. Lender is the financial organization that provided the acquisition or construction loan, or a new loan to an existing property.<\/p>\n

Notes<\/strong>
\nEnter keywords to search only within the Notes<\/em>\u00a0field.<\/p>\n

Ownership Type<\/strong>
\nSelect an ownership type (e.g. fee simple or ground lease) from the dropdown list to limit your search to only that type.<\/p>\n

Property\u00a0Type<\/strong>
\nSelect a property type (e.g. luxury, upper upscale or independent-upscale) from the dropdown list to limit your search to only that type.<\/p>\n

Building\u00a0Type<\/strong>
\nSelect a building\u00a0type (e.g. high-, mid- or low-rise) from the dropdown list to limit your search to only that type.<\/p>\n

Location\u00a0Type<\/strong>
\nSelect a location\u00a0type (e.g. urban, suburban or resort) from the dropdown list to limit your search to only that type.<\/p>\n

Conversion\u00a0Type<\/strong>
\nSelect a conversion\u00a0type (e.g. hotel-to-residential, hotel-to-office) from the dropdown list to limit your search to only that type. This field describes if the property will undergo any conversion following<\/em> the transaction.<\/p>\n

These are all the fields! We would love to hear if you have any suggestions on how we can improve the Advanced Search. And don’t forget that, if you are PRO subscriber, you can save your Advanced Search<\/a> for easy, one-click access to it or to receive automatic email updates with new matches.<\/p>\n","protected":false},"excerpt":{"rendered":"

In OpenComps, easy and intuitive design is on top of our minds. To find something on OpenComps, we have a large search bar persistently on top of every page. It is big, it’s easy, it’s quick. (And did you know that\u00a0pressing “\/” on your keyboard on any screen, brings you inside that search bar? Type […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"An overview of the Advanced Search feature.","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[33,51],"class_list":["post-502","post","type-post","status-publish","format-standard","hentry","category-general","tag-features","tag-pro-subscription"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.opencomps.com\/blog\/wp-json\/wp\/v2\/posts\/502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.opencomps.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.opencomps.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.opencomps.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.opencomps.com\/blog\/wp-json\/wp\/v2\/comments?post=502"}],"version-history":[{"count":5,"href":"https:\/\/www.opencomps.com\/blog\/wp-json\/wp\/v2\/posts\/502\/revisions"}],"predecessor-version":[{"id":566,"href":"https:\/\/www.opencomps.com\/blog\/wp-json\/wp\/v2\/posts\/502\/revisions\/566"}],"wp:attachment":[{"href":"https:\/\/www.opencomps.com\/blog\/wp-json\/wp\/v2\/media?parent=502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.opencomps.com\/blog\/wp-json\/wp\/v2\/categories?post=502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.opencomps.com\/blog\/wp-json\/wp\/v2\/tags?post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}