# Get a paginated result view of new homeowners

This endpoint returns a paginated result view of the request. This can sometimes take awhile and should be used after DoCount has been used to filter down your dataset.

Endpoint: POST /NewHomeowners/doLookup

## Header parameters:

  - `Accept` (string, required)
    Format of the response.
    Enum: "application/json", "*/*"

  - `Content-Type` (string, required)
    Format of the request.
    Enum: "application/json", "application/xml"

## Request fields (application/json):

  - `CustomerID` (string, required)
    The [License Key](https://docs.melissa.com/melissa/license/license-information.html) issued by Melissa.

  - `Includes` (object, required)
    Any parameter you would like to include in the query.

Requires at least one from:
- Zips
- Cities
- Radius
- ShapeWKTs

  - `Includes.Zips` (array)
    A list of Zips objects containing Zip codes and optionally Plus4.

  - `Includes.Zips.Zip` (string, required)

  - `Includes.Zips.Plus4` (string)

  - `Includes.Cities` (array)
    A list of cities objects each containing City and State.

  - `Includes.Cities.City` (string, required)

  - `Includes.Cities.State` (string, required)

  - `Includes.Radius` (object)
    A Radius object containing a Latitude, Longitude, and Distance represented in miles.

  - `Includes.Radius.Latitude` (number, required)

  - `Includes.Radius.Longitude` (number, required)

  - `Includes.Radius.Distance` (number, required)

  - `Includes.ShapeWKTs` (array)
    A list of WKT polygon strings

  - `Includes.MelissaAddressKey` (array)
    A list of Melissa address keys.

  - `Includes.BaseMelissaAddressKey` (array)
    A list of BaseMelissaAddressKeys.

  - `Includes.FirstName` (array)
    A list of FirstNames.

  - `Includes.LastName` (array)
    A list of LastNames.

  - `Includes.RBDI` (array)
    An RBDI code.

  - `Includes.Address` (array)
    A list of Addresses.

  - `Includes.Street` (array)
    A list of Streets.

  - `Includes.State` (array)
    A list of States.

  - `Includes.Plus4` (array)
    A list of Plus4s.

  - `Includes.DeliveryPoint` (array)
    A list of DeliveryPoints.

  - `Includes.AddressKey` (array)
    A list of AddressKeys.

  - `Includes.CarrierRoute` (array)
    A list of CarrierRoutes.

  - `Includes.FIPSCode` (array)
    A list of FIPSCodes.

  - `Includes.CountyName` (array)
    A list of CountyNames.

  - `Includes.PlaceCode` (array)
    A list of PlaceCodes.

  - `Includes.Latitude` (array)
    A list of Latitudes.

  - `Includes.Longitude` (array)
    A list of Longitudes.

  - `Includes.CensusKey` (array)
    A list of CensusKeys.

  - `Includes.PhoneNumber` (array)
    A list of PhoneNumbers.

  - `Includes.PurchasePrice` (array)
    A list of PurchasePrices.

  - `Includes.SellDate` (object)
    A list of SellDates.

  - `Includes.SellDate.StartDate` (string)

  - `Includes.SellDate.EndDate` (string)

  - `Includes.Lender` (array)
    A list of Lenders.

  - `Includes.TransactionType` (array)
    A list of TransactionTypes.

  - `Includes.PublishedDate` (array)
    A date range with start and end dates.

  - `Includes.CondoCode` (array)
    A list of CondoCodes.

  - `Includes.MortgageAmount` (array)
    A list of MortgageAmounts.

  - `Includes.RateType` (array)
    A list of RateTypes.

  - `Includes.LoanType` (array)
    A list of LoanTypes.

  - `Excludes` (object)
    Any parameter you would like to exclude in the query.

  - `Excludes.MelissaAddressKey` (array)
    A list of Melissa address keys.

  - `Excludes.BaseMelissaAddressKey` (array)
    A list of BaseMelissaAddressKeys.

  - `Excludes.FirstName` (array)
    A list of FirstNames.

  - `Excludes.LastName` (array)
    A list of LastNames.

  - `Excludes.RBDI` (array)
    An RBDI code.

  - `Excludes.Address` (array)
    A list of Addresses.

  - `Excludes.Street` (array)
    A list of Streets.

  - `Excludes.Cities` (array)
    A list of cities objects each containing City and State.

  - `Excludes.Cities.City` (string, required)

  - `Excludes.Cities.State` (string, required)

  - `Excludes.State` (array)
    A list of States.

  - `Excludes.Zips` (array)
    A list of Zips objects containing Zip codes and optionally Plus4.

  - `Excludes.Zips.Zip` (string, required)

  - `Excludes.Zips.Plus4` (string)

  - `Excludes.Plus4` (array)
    A list of Plus4s.

  - `Excludes.DeliveryPoint` (array)
    A list of DeliveryPoints.

  - `Excludes.AddressKey` (array)
    A list of AddressKeys.

  - `Excludes.CarrierRoute` (array)
    A list of CarrierRoutes.

  - `Excludes.FIPSCode` (array)
    A list of FIPSCodes.

  - `Excludes.CountyName` (array)
    A list of CountyNames.

  - `Excludes.PlaceCode` (array)
    A list of PlaceCodes.

  - `Excludes.Latitude` (array)
    A list of Latitudes.

  - `Excludes.Longitude` (array)
    A list of Longitudes.

  - `Excludes.CensusKey` (array)
    A list of CensusKeys.

  - `Excludes.PhoneNumber` (array)
    A list of PhoneNumbers.

  - `Excludes.PurchasePrice` (array)
    A list of PurchasePrices.

  - `Excludes.SellDate` (object)
    A list of SellDates.

  - `Excludes.SellDate.StartDate` (string)

  - `Excludes.SellDate.EndDate` (string)

  - `Excludes.Lender` (array)
    A list of Lenders.

  - `Excludes.TransactionType` (array)
    A list of TransactionTypes.

  - `Excludes.PublishedDate` (array)
    A date range with start and end dates.

  - `Excludes.CondoCode` (array)
    A list of CondoCodes.

  - `Excludes.MortgageAmount` (array)
    A list of MortgageAmounts.

  - `Excludes.RateType` (array)
    A list of RateTypes.

  - `Excludes.LoanType` (array)
    A list of LoanTypes.

  - `Columns` (array, required)
    All [NewHomeowners Columns](https://docs.melissa.com/reference-data/data-retriever/data-retriever-reference-guide.html#newhomeowners) you want returned.
    Enum: "MelissaAddressKey", "BaseMelissaAddressKey", "FirstName", "LastName", "AddressLine", "City", "State", "ZIPCode", "Plus4", "DeliveryPoint", "AddressKey", "CarrierRoute", "FIPSCode", "PlaceCode", "Latitude", "Longitude", "CensusKey", "PhoneNumber", "PurchasePrice", "SellDate", "Lender", "TransactionType", "PublishedDate", "CondoCode", "MortgageAmount", "RateType", "LoanType"

  - `Pagination` (object, required)
    Specify the desired page in the results to access. Pages are based on 100 records per page.

  - `Pagination.Page` (integer)

  - `OrderBy` (array)
    Specify the desired column to order the responses by.

  - `OrderBy.column` (string)

  - `OrderBy.sortorder` (string)
    Enum: "ASC", "DESC"

## Response 200 fields (application/json):

  - `Count` (integer)
    Number of records returned by the query.

  - `Results` (array)
    Returned records with requested Columns.

  - `Pagination` (object)
    The current page number and the next page number.

  - `Pagination.CurrentPage` (integer)

  - `Pagination.NextPage` (integer)

  - `Pagination.TotalPages` (integer)

  - `JobId` (string)
    The JobId to be used to purchase and access the full dataset.

  - `ResultCode` (string)
    Success or Error codes based on the response/request.

## Response 400 fields (application/json):

  - `type` (string)
    The type of error that occurred.

  - `title` (string)
    A short summary of the error.

  - `status` (integer)
    The HTTP status code for the error.

  - `errors` (object)

  - `errors.$.<PropertyName>` (array)
    A detailed message about the error.

  - `traceId` (string)
    A unique identifier for the request, useful for debugging.