> ## Documentation Index
> Fetch the complete documentation index at: https://docs.camo.ag/llms.txt
> Use this file to discover all available pages before exploring further.

# Prospecting Using the Mortgages Report

> Find mortgages held by a competitor that are coming up for renewal, then download the list or view them on the map.

*\*Requires an Enterprise subscription with mortgage data*

<Frame>
  <iframe src="https://www.youtube.com/embed/BpOStLvNnWQ" title="Using the Mortgages Report for Prospecting" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen />
</Frame>

**Target audience:** Ag lenders

**Use case:** You want to find mortgages in your market that are held by a competitor and coming up for renewal, so you can start engaging those borrowers before they renew.

The Mortgages report has a lot of filters. This workflow uses just a handful of them to get you started.

## Open the Mortgages Report

<Steps>
  <Step>
    Click **Reports** in the left-hand menu
  </Step>

  <Step>
    Click **Mortgages**
  </Step>
</Steps>

## Filter to Your Market

<Steps>
  <Step>
    In **Mortgage County, State**, select the counties you work in (for example, DeKalb, IL and Boone, IL). This narrows the report from every mortgage in your account down to just the mortgages in those counties.
  </Step>
</Steps>

<Tip>
  The **Borrower State** and **Borrower County, State** filters are based on where the borrower lives, not where the property is. For prospecting in your market, use the **Mortgage** location filters instead.
</Tip>

## Filter to a Competitor

<Steps>
  <Step>
    In **Mortgage Lender**, choose **contains** and type the competitor's name (for example, "Chase")
  </Step>

  <Step>
    Select all of the matching lender names. The same lender is often entered several different ways (for example, "JPMorgan Chase Bank NA" and "JP Morgan Chase Bank"), so **contains** catches every variation.
  </Step>
</Steps>

## Filter to Mortgages Coming Up for Renewal

<Steps>
  <Step>
    In **Mortgage Origination Date**, choose **in the year** and enter the year the mortgages you want to target were taken out. For example, entering 2022 shows mortgages originated four years ago that will be up for renewal in 2027.
  </Step>

  <Step>
    Click **Update**
  </Step>
</Steps>

<Note>
  You can narrow the list further with the **Contact** filters, which let you include or exclude people who are already contacts in CamoAg.
</Note>

## Work the List

The **Borrower and Mortgage Details** table shows each matching mortgage, including the operation, borrower names, lender, location, and mortgage amount.

* **Download the list:** click the three vertical dots at the top right of the table, then **Download**
* **View a mortgage on the map:** open the mortgage in the map to see the parcel it's on, the mortgage details, and other mortgages nearby, so you can spot additional refinancing opportunities

## Related

* [Mortgages Pro: Overview & Use Cases](/training/use-cases/mortgages-pro-overview-use-cases)
* [Using the Mortgages Data Layer](/mortgages/using-the-mortgages-data-layer)
* [Scheduling a Report for Delivery](/reports/scheduling-a-report-for-delivery)