Difference between revisions of "LeadGen Property V2:Request Parameters"

From Melissa Data Wiki
Jump to navigation Jump to search
(Created page with "{{LGXPropertyV2Nav}} {{CustomTOC}} ==Standard Components== {|class="alternate01" cellspacing="0" !Parameter !style="border-right:0px;"|Definition |- |Domain | |- |Version |...")
 
 
(11 intermediate revisions by the same user not shown)
Line 35: Line 35:
*[[#Property Options|Property Options]]
*[[#Property Options|Property Options]]
*[[#Mortgage Options|Mortgage Options]]
*[[#Mortgage Options|Mortgage Options]]
*[[#Absentee/Owner Type Options|Absentee/Owner Type Options]]
*[[#Occupant/Owner Options|Occupant/Owner Options]]
*[[#Demographic Options|Demographic Options]]
*[[#Demographic Options|Demographic Options]]
*[[#General Options|General Options]]
*[[#Number of Records in File|Number of Records in File]]
*[[#Columns in File|Columns in File]]
*[[#File Format|File Format]]
*[[#Other Options|Other Options]]
|}
|}


Line 83: Line 86:
|ZIP(s)
|ZIP(s)
|
|
*5-digit ZIPs
5-digit ZIPs
*Multiple ZIP can be requested, comma separated with no space or period.
 
Multiple ZIP can be requested, comma separated with no space or period.
|-
|-
|ZIP in Radius
|ZIP in Radius
|
|
*5-digit ZIP
5-digit ZIP
*Miles of radius from any given ZIP (mile in decimal).
 
Miles of radius from any given ZIP (mile in decimal).
|-
|-
|ZIP(s) in City
|ZIP(s) in City
|
|
*5-digit ZIP, City, and 2-digit State.
5-digit ZIP, City, and 2-digit State.
|-
|-
|address
|address
|
|
|
|
Address, City and State or ZIP.
Miles of radius from a given address. (mile in decimal)
|-
|street
|
|Street name and ZIP or city and state, with street number range being optional
|-
|city
|
|
Format: 2-digit state;city name, i.e. TX;Dallas
Multiple cities be requested, comma separated with no space, or period
|-
|-
|city?
|town
|City
|
|
|
Format: 2-digit state;city name
Multiple town or place be requested, comma separated with no space, or period


Multiple cities be requested, comma separated with no space.
Format: 2-digit state;town name, i.e. CA:Adelanto


Ex. city=TX;Dallas,TX;Houston,TX;Austin
Town name and State
|-
|rowspan="2"|county
|by FIPS
|
Format: 2-digit state;county name, or FIPS
|-
|by County, State
|
Multiple counties be requested, comma separated with no space or period, i.e. CA:Lake, 06029
|-
|state
|
|
2-digit state name
|-
|-
|county?
|circle
|County
|
|
|
Format: 2-digit state;county name
Miles of radius from a point defined as “latitude;longitude” with a semi colon delimiter, i.e.“-117.597760116333;33.63565170564778”


Multiple counties be requested, comma separated with no space.
0.25 miles radius min., 25 miles radius max.
 
|-
Ex. county=CA;Lake,AZ;Mohave,AZ;Maricopa
|polygon
|
|A set of points (latitude /longitude)within 0.25 miles square and 25 miles square. Each point is defined as “latitude;longitude” with a semi colon delimiter, use comma delimiter between each set of latitude;longitude. For example, 33.649656850987895;-117.59544268774414, 33.636509228993326;-117.6109780423584, 33.63222152688031;-117.59518519567871”
|-
|-
|radius?
|rectangle
|Radius
|
|
|
Miles of radius from a given address, or the closest records to a given address.
Southwest and northeast points (latitude /longitude). Each point is defined as “latitude;longitude” with a semi colon delimiter, use comma delimiter between each set of latitude;longitude. For example, “33.63565170564778;-117.597760116333, 33.649513952846554;-117.58685961889648”
 
0.25 miles square min., 25 miles square max.
|}
|}




==Options==
==Options==
Each request takes a set of geographic input. Property and other input are optional with default values, as well as purchase options. See [[LeadGen:Property:List/File#Columns in File|Columns in File]] for the format of all columns appended to file.
Each request takes a set of geographic input. Property and other input are optional with default values, as well as purchase options. See [[#Columns in File|Columns in File]] for the format of all columns appended to file.
 
<h3 class="h3grey">Geographic Options</h3>
:An example of this parameter in the URL:
<pre class="indent">
https://list.melissadata.net/v2/Property/buy_city?id=123456&ctyst=CA;Tustin,CA;Irvine
</pre>


===Geographic Options===
:{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!URL Parameter
!URL Parameter
!Geographic Type
!Geographic Type
Line 137: Line 179:
Required: zip
Required: zip


Optional: radius
Optional: address, street, circle, rectangle
|
|Each five-digit ZIP is validated.
Each five-digit ZIP is validated. Plus4 is a filter in the data section.
|-
|addr
|Require: Address
|No validation.
|-
|ctyst
|Required: city
|Format: state;city
|-
|-
|city
|city
|Required: city
|Optional: address, street, ZIP
 
|If ZIP is given, city is not necessary.
Optional: radius
|-
|Each city and state combinations is validated.
|town
|Required: town
|Not validated.
|-
|-
|county
|cntyst
|Required: county
|Required: county
|Each county and state combination is validated. FIPS is retrieved if valid.
|The value could be .a variety of state;county and/or FIPS.
|-
|-
|addr
|state
|Required: radius
|
|Exact street number and street name are used in the data section. No validation.
Required: state
 
Optional: address, county, street, zip
|
For state type, 2-digit state is required.


Latitude and longitude are retrieved if the address exists.
For other types, if ZIP or FIPS is given, state is not necessary.
|-
|-
|mile
|mile
|rowspan="2"|Optional: radius
|
Required: address, street, circle


(One of the two should be given, not required together.)
Option: zip
|Mile is used to find out the latitudes/longitudes of a parameter so many miles from the given address.
|Radius of miles from a given street, address or ZIP.
|-
|street
|Required: street
|Exact street name is required. No validation.
|-
|num1
|rowspan="2"|Optional: street
|rowspan="2"|Start and end of the range of street numbers. Either end can be left unspecified.
|-
|num2
|-
|-
|records
|pt
|Number of records that are the closest to the given address.
|Required: circle, rectangle. polygon
|
Each point is defined as “latitude;longitude” with a semi colon delimiter.
 
For multiple points, use comma delimiter between each set of latitude;longitude. For example, “33.63565170564778;-117.597760116333, 33.649513952846554;-117.58685961889648”
 
Rectangle takes 2 points: 1) southwest, 2) northeast.
 
Polygon takes at least 3 points, counter clockwise.
|}
|}




===Property Options===
<h3 class="h3grey">Property Options</h3>
 
{|class="alternate01 indent" cellspacing="0"
!URL Parameter
!Description
!style="border-right:0px;"|Values
|-
|propertype
|
Property codes & types:
 
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|00
|Miscellaneous
|-
|000
|Not Available/None
|-
|10
|Single Family Residence
|-
|11
|Condominium(Residential)
|-
|20
|Commercial
|-
|21
|Duplex, Triplex, Quadplex
|-
|22
|Apartment
|-
|23
|Hotel, Motel
|-
|24
|Condominium(Commercial)
|-
|25
|Retail
|-
|26
|Service(general public)
|-
|27
|Office Building
|-
|28
|Warehouse
|-
|29
|Financial Institution
|-
|30
|Hospital(medical complex, clinic)
|-
|31
|Parking
|-
|32
|Amusement-Recreation
|-
|33
|Mobile Home
|-
|50
|Industrial
|-
|51
|Industrial Light
|-
|52
|Industrial Heavy
|-
|53
|Transport
|-
|54
|Utility
|-
|70
|Agricultural
|-
|80
|Vacant Lot (Land)
|-
|90
|Exempt
|}
|
Default: all.
Otherwise specify the index; use ‘-‘ dash to specify multiple choices, e.g. propertype =10-11 means Single Family Residence and Condominium(Residential)
|-
|bedrooms
|Number of bedrooms
|rowspan="9"|
Default: no filter.
To specify a range, use min-max, e.g. 2-4. Use <code>0</code> if either end has no preference. For example, <code>2-0</code> means at least 2.
|-
|bathrooms
|Number of bathrooms
|-
|units
|Unit number
|-
|yearbuilt
|Year built. Format. YYYY.
|-
|pval
|Property value ($)
|-
|equity
|Equity ($)
|-
|lvratio
|Loan to value ratio (%).
|-
|sqft
|Square footage
|-
|bsqft
|Basement square footage
|-
|lot
|
Lot size. It can be a range. The unit can be:
*<code>a</code> for acre, or
*<code>f</code> for sq. ft.
Format: unit;size.
|
Default: no filter.
Unit: default is sq. ft (f).
Size: To specify a range, use min-max. 2-4 means 2-4 acres. Use 0 if either end has no preference. For instance, f;2000-0 means at least 2000 sq. ft.
|-
|samt
|Range of sale amounts in thousands ($)
|
Default: no filter.
To specify a range, use min-max, i.e. 2-4. Use 0 if either end has no preference. For instance, 2-0 means at least $2,000.
|-
|sdt
|Range of sale dates
|
Default: no filter.
To specify a period, use MYYYY-MYYYY. The start month starts on the 1st; the end month ends on the last day, i.e. sdt=32010-122014, this covers 3/1/2010 to 12/31/2014.
|-
|pool
|Has pool or not.
|rowspan="4"|
<code>1</code> means using it as a filter while <code>0</code> means no preference. For example, <code>pool=1</code>.
If not specified, it means no preference.
|-
|heat
|Has heater or not.
|-
|ac
|Has A/C or not.
|-
|fireplace
|Has fireplace or not.
|}
<h3 class="h3grey">Mortgage Options</h3>
{|class="alternate01 indent" cellspacing="0"
!URL Parameter
!URL Parameter
!Description
!Description
!Default Value
!style="border-right:0px;"|Values
!style="border-right:0px;"|Optional Output Parameter
|-
|mtgAmt
|
(Range of) amount in thousands ($)
Combined amount for 1st and 2nd mortgages
|rowspan="3"|
Default: no filter
 
To specify a range of amounts, use min-max. Use 0 if either end has no preference. For instance, 2-0 means at least $2000, 5-10 means between$5000 and $10000.
 
It’s an OR relationship when more than one of the three parameters have values.
|-
|mtgAmt1
|1st Mortgage Amount
|-
|mtgAmt2
|2nd Mortgage Amount
|-
|mtgRt
|
Rate (range)
Rate for either 1st or 2nd mortgage
|rowspan="3"|
Default: no filter.
 
To specify a range of rates, use min-max. Use 0 if either end has no preference. For instance, 2.5-0 means 2.5% at least, 3-5.5 means between 3% and 5.5%.
 
It’s an OR relationship when more than one of the three parameters have values.
|-
|mtgRt1
|1st Mortgage Rate
|-
|mtgRt2
|2nd Mortgage Rate
|-
|mtgRtTp
|
Interest rate type for 1st or 2nd mortgage. Types are:
 
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|-
|opt
|2
|Extra data added to the file returned: basic or detailed.
|fixed rate
When not mentioned, the simplest set of data is returned for those who have not opted out mail: owner names, property and mailing addresses.
|-
|opt=0 (Basic)
|1
|opt=1 (Detailed)
|adjustable rate
|-
|0
|unknown
|}
|rowspan="3"|
Default: no filter.
 
To include a variety of types, use <code>-</code>. For instance, 2-1 means to include fixed and adjustable rate.
 
It’s an OR relationship when more than one of the three parameters have values.
|-
|mtgRtTp1
|
|-
|mtgRtTp2
|
|-
|mtgTm
|Term (years)
|rowspan="3"|
Default: no filter
 
To specify a range of terms, use min-max. Use 0 if either end has no preference. For instance, 5-0 means at least 5-year term, 15-30 means between 15-year to 30-year term
 
It’s an OR relationship when more than one of the three parameters have values.
|-
|mtgTm1
|1st mortgage term
|-
|mtgTm2
|2nd Mortgage Term
|-
|mtgLender
|
Mortgage lender(s). Exact names are needed.
 
Use – as the delimiter for multiple lenders.
|
Default: no filter
 
Example: America Bank-America Bank and Trust
|-
|mtgRecDt
|Recording date (range)
|rowspan="3"|
Default: no filter.
 
To specify a period, use MYYYY-MYYYY. The start month starts on the 1st; the end month ends on the last day. For instance, 12015-112018 means between 1/1/2015 and 11/30/2018.
 
It’s an OR relationship when more than one of the three parameters have values.
|-
|mtgRecDt1
|1st Mortgage Recording Date
|-
|mtgRecDt2
|2nd mortgage recording date
|-
|mtgTp
|
Mortgage type(s). Multiple mortgages are separated by comma.
 
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|0
|Unknown
|-
|3
|Building or Construction
|-
|5
|Conventional
|-
|6
|Line of Credit
|-
|8
|FHA
|-
|10
|Conventional
|-
|16
|Veterans Administration Loan
|-
|101
|USDA - US Department of Agriculture Loan
|-
|102
|Regional Government Programs
|-
|103
|Commercial
|-
|104
|Regional Government Programs
|-
|105
|Reverse Mortgage
|-
|120
|Private Party Loan
|}
|rowspan="3"|
Default: no filter
 
For instance, 5-8 means conventional or FHA
 
It’s an OR relationship when more than one of the three parameters have values.
|-
|mtgTp1
|1st Mortgage type
|-
|mtgTp2
|2nd mortgage type
|-
|mtgScb
|Seller Carry Back (Is the seller is also the lender?)
|rowspan="3"|
Default: no filter.
 
Including or excluding – true or false.
 
It’s an OR relationship when more than one of the three parameters have values.
|-
|mtgScb1
|1st Mortgage Seller Carry back
|-
|mtgScb2
|2nd mortgage seller carry back
|}
 
 
<h3 class="h3grey">Occupant/Owner Options</h3>
{|class="alternate01 indent" cellspacing="0"
!URL Parameter
!Description
!style="border-right:0px;"|Values
|-
|-
|occu
|occu
|Append OccupantType to file.
|
|occu=0
Occupant types
|To append: occu=1
 
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|1
|Owner occupied
|-
|2
|Absentee owner (all types)
|-
|3
|Absentee Owner - In County
|-
|4
|Absentee Owner – In State
|-
|-
|occu-d
|5
|Occupant types:
|Absentee Owner – Out of County
1 = Absentee only
|-
|6
|Absentee Owner – Out of State
|}
|
Default: no preference.


2 = Owner occupied
For multiple absentee owner types, use – as the delimiter. It’s an OR relationship between the selected types. For instance, 3-6 means in county or out of state.
|All, including unknown.
|-
|owntrs
|Trustee owner
|rowspan="3"|
Default: no preference.
Including or excluding – true or false.
|-
|owncorp
|Corporate owner
|-
|vacant
|Vacant property
|}
 
 
<h3 class="h3grey">Demographic Options</h3>
{|class="alternate01 indent" cellspacing="0"
!URL Parameter
!Description
!style="border-right:0px;"|Values
|-
|hhage
|
|
Household age:
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|1
|18 - 24 Years
|-
|2
|25 - 34 Years
|-
|3
|35 - 44 Years
|-
|4
|45 - 54 Years
|-
|5
|55 - 64 Years
|-
|6
|65 - 74 Years
|-
|7
|75+ Years
|}
|
Default: all.
Otherwise specify the index; use ‘-‘ dash to specify multiple choices, i.e. 1-2 means 18-34 years old
|-
|-
|mval
|gender
|Market value. Specify with the index and use ‘-‘ dash to specify multiple choices: mval=2-3-4
|all
|
|
Gender:
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|f
|female
|-
|m
|male
|-
|u
|unisex
|}
|
Default: all.
Otherwise specify the index; use ‘-‘ dash to specify multiple genders, i.e. f-m mean female and male
|-
|hhinc
|
Household income:
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!Value
!Value
Line 203: Line 724:
|-
|-
|1
|1
|$1 - 49,999
|Under $10,000
|-
|-
|2
|2
|$50,000 - 99,999
|$10,000 - $14,999
|-
|-
|3
|3
|$100,000 - 149,999
|$15,000 - $19,999
|-
|-
|4
|4
|$150,000 - 199,999
|$20,000 - $24,999
|-
|-
|5
|5
|$200,000 - 249,999
|$25,000 - $29,999
|-
|-
|6
|6
|$250,000 - 299,999
|$30,000 - $34,999
|-
|-
|7
|7
|$300,000 - 349,999
|$35,000 - $39,999
|-
|-
|8
|8
|$350,000 - 399,999
|$40,000 - $44,999
|-
|-
|9
|9
|$400,000 - 449,999
|$45,000 - $49,999
|-
|A
|$50,000 - $54,999
|-
|B
|$55,000 - $59,999
|-
|C
|$60,000 - $64,999
|-
|D
|$65,000 - $69,999
|-
|E
|$70,000 - $99,999
|-
|F
|$100,000 - $149,999
|-
|-
|10
|G
|$450,000 - 499,999
|$150,000 - $174,999
|-
|-
|11
|H
|$500,000 - 574,999
|$175,000 - $199,999
|-
|-
|12
|I
|$575,000 - 649,999
|$200,000 - $249,999
|-
|-
|13
|J
|$650,000 - 724,999
|$250,000+
|}
|
Default: all.
 
Otherwise specify the index; use ‘-‘ dash to specify multiple choices, i.e. 1-2 means $14,999 or less
|-
|-
|14
|marital
|$725,000 - 799,999
|
Marital status
 
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|-
|15
|a
|$800,000 - 899,999
|inferred married
|-
|-
|16
|b
|$900,000 - 999,999
|inferred single
|-
|-
|17
|m
|$1,000,000 - 1,999,999
|married
|-
|-
|18
|s
|$2,000,000+
|single
|}
|}
|
Default: all.
Otherwise specify the index; use ‘-‘ dash to specify multiple choices, i.e. b-s means inferred single or single
|-
|-
|ptype
|lores
|Property type. To specify the index; use ‘-‘ dash to specify multiple choices, i.e. ptype =1-2
|all
|
|
Length of residence
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!Value
!Value
!Definition
!Definition
|-
|0
|Less than 1 year
|-
|-
|1
|1
|Single Family Residence/Townhouse
|1 Year
|-
|-
|2
|2
|Condominium (residential)
|2 Years
|-
|-
|3
|3
|Commercial
|3 Years
|-
|-
|4
|4
|Duplex, Triplex, Quadplex
|4 Years
|-
|-
|5
|5
|Apartment
|5 Years
|-
|-
|6
|6
|Hotel, Motel
|6 Years
|-
|-
|7
|7
|Commercial (condominium)
|7 Years
|-
|-
|8
|8
|Retail
|8 Years
|-
|-
|9
|9
|Service (general public)
|9 Years
|-
|-
|10
|10
|Office Building
|10 Years
|-
|-
|11
|11
|Warehouse
|11 Years
|-
|-
|12
|12
|Financial Institution
|12 Years
|-
|-
|13
|13
|Hospital (medical complex, clinic)
|13 Years
|-
|-
|14
|14
|Parking
|14 Years
|-
|-
|15
|15
|Amusement-Recreation
|Over 14 Years
|}
|
Default: all.
 
Otherwise specify the index; use ‘-‘ dash to specify multiple choices, i.e. 0-1-2 means 2 years or under
|-
|people
|
Persons in household (number of people in household):
 
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|1
|1 Person
|-
|2
|2 Persons
|-
|3
|3 Persons
|-
|4
|4 Persons
|-
|5
|5 Persons
|-
|6
|6 Persons
|-
|-
|16
|7
|Industrial
|7 Persons
|-
|-
|17
|8
|Industrial Light
|8 Persons
|-
|-
|18
|9
|Industrial Heavy
|9+ Persons
|}
|rowspan="3"|
Default: all.
 
Otherwise specify the index; use ‘-‘ dash to specify multiple choices, i.e. 1-2 means 2 or less
|-
|-
|19
|adults
|Transport
|
Adults in household:
 
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|-
|20
|1
|Utilities
|1 Adult
|-
|-
|21
|2
|Agricultural
|2 Adults
|-
|-
|22
|3
|Vacant
|3 Adults
|-
|-
|23
|4
|Exempt
|4 Adults
|-
|-
|24
|5
|Miscellaneous
|5 Adults
|-
|-
|25
|6
|Not Available / None
|6+ Adults
|}
|}
|-
|-
|sdt
|kids
|Sale date.
|
|no filter
Children in household:
|To specify a period, use MYYYY. The start month starts on the 1st; the end month ends on the last day, i.e. sdt=32010-122014, this covers 3/1/2010 to 12/31/2014.
 
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|1
|1 Child
|-
|2
|2 Children
|-
|3
|3 Children
|-
|4
|4 Children
|-
|5
|5 Children
|-
|6
|6 Children
|-
|7
|7 Children
|-
|-
|mdt
|8
|Mortgage date
|8+ Children
|no filter
|}
|To specify a period, use MYYYY. The start month starts on the 1st; the end month ends on the last day, i.e. mdt=32010-122014, this covers 3/1/2010 to 12/31/2014.
|}
|}




===Purchase Options===
<h3 class="h3grey">Number of Records in File</h3>
The following options are for buy requestes only.
:Each purchase allows 100,000 records at most.


{|class="alternate01" cellspacing="0"
{|class="alternate01 indent" cellspacing="0"
!URL Parameter
!URL Parameter
!Description
!Description
!Default Value
!style="border-right:0px;"|Values
!style="border-right:0px;"|Optional Output Parameter
|-
|qty
|Number of records to buy
|Default: no preference.
|}
 
 
 
<h3 class="h3grey">Columns in File</h3>
:Owner names, mailing address and property address are included in the list by default.
:Additional fields can be added by setting each of the URL parameters’ value to “true.”
 
{|class="alternate01 indent" cellspacing="0"
!Column Name!!Max Length!!URL Value to Append!!Description
|-
|-
|ID|| || ||
|-
|ContactMak|| || ||
|-
|FullName1||150|| ||party owner 1 full name
|-
|FirstName1||50|| ||party owner 1 first name
|-
|MiddleName1||20|| ||party owner 1 middle name
|-
|LastName1||50|| ||party owner 1 last name
|-
|Suffix1||20|| ||party owner 1 name suffix
|-
|-
|multi
|FullName2||150|| ||party owner 2 full name
|Buy Requests Only. By default, purchased lists may be used once. With this parameter included in the Buy call, you can purchase the right to use a list for multiple mailings. Specify the number of uses like this: multi=4. The maximum number of uses allowed for any purchased list is 5.
|-
|multi=1
|FirstName2||50|| ||party owner 2 first name
|multi=(1 through 5)
|-
|MiddleName2||20|| ||party owner 2 middle name
|-
|LastName2||50|| ||party owner 2 last name
|-
|Suffix2||20|| ||party owner 2 name suffix
|-
|MailAddr||100|| ||mailing address
|-
|MailCity||100|| ||mailing city
|-
|MailState||15|| ||mailing state
|-
|MailZip||10|| ||mailing ZIP
|-
|MailPlus4||4|| ||mailing ZIP 4
|-
|MailCRRT||4|| ||mailing carrier route
|-
|MailDPB||2|| ||mailing delivery point
|-
|MailFIPS||5|| ||mailing FIPS
|-
|SiteAddr||50|| ||property address
|-
|SiteCity||35|| ||property city
|-
|SiteState||15|| ||property state
|-
|SiteZip||10|| ||property ZIP
|-
|SitePlus4||4|| ||property ZIP 4
|-
|SiteCRRT||4|| ||property carrier route
|-
|SiteDPB||2|| ||property delivery point
|-
|SiteFIPS||5|| ||property FIPS
|-
|SiteMak|| || ||
|-
|PropertyType||250||fpropertype||
|-
|BedroomsCount||10||fbedrooms||
|-
|BathCount||10||fbathrooms||
|-
|AreaSqft||10||fsqft||
|-
|LotSqft||10||flot||
|-
|LotAcre||15|| ||
|-
|Units||5||funits||
|-
|YearBuilt||4||fyearbuilt||
|-
|EstimatedPropertyValue||15||fpval||
|-
|EquityAmount||15||fequity||
|-
|LoanToValueRatio||15||flvratio||
|-
|LastSaleDate||10||fsdt||
|-
|LastSaleAmount||15||fsamt||
|-
|BasementAreaSqft||10||fbsqft||
|-
|Pool||3||fpool||
|-
|Heater||3||fheat||
|-
|AC||3||fac||
|-
|Fireplace||3||ffireplace||
|-
|Mortgage1Amount||15||fmtgAmt||
|-
|Mortgage2Amount||15|| ||
|-
|Mortgage1InterestRate||10||fmtgRt||
|-
|Mortgage2InterestRate||10|| ||
|-
|Mortgage1InterestRateType||15||fmtgRtTp||
|-
|Mortgage2InterestRateType||15|| ||
|-
|Mortgage1Term||10||fmtgTm||
|-
|Mortgage2Term||10|| ||
|-
|Mortgage1LenderName||250||fmtgLender||
|-
|Mortgage2LenderName||250|| ||
|-
|Mortgage1RecordingDate||10||fmtgRecDt||
|-
|Mortgage2RecordingDate||10|| ||
|-
|Mortgage1Type||250||fmtgTp||
|-
|Mortgage2Type||250|| ||
|-
|Mortgage1SellerCarryBack||3||fmtgScb||
|-
|Mortgage2SellerCarryBack||3|| ||
|-
|PrimaryAbsenteeOwner||13||foccu||
|-
|TrusteeOwner||3||fowntrs||
|-
|CorporateOwner||3||fowncorp||
|-
|HouseholdAge||11||fhhage||
|-
|IncomeEstimatedHousehold||250||fgender||
|-
|MaritalStatus||250||fhhinc||
|-
|HomeLengthofResidence||250||fmartial||
|-
|HouseholdSize||250||flores||
|-
|NumberOfAdults||250||fpeople||
|-
|NumberOfChildren||250||fadults||
|}
 
 
<h3 class="h3grey">File Format</h3>
{|class="alternate01 indent" cellspacing="0"
!URL Parameter
!Values
|-
|-
|file
|file
|Buy Requests Only. Defines the desired file format of a purchased list.
|file= 8
|
|
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!Value
!Value
!File Format
!Definition
|-
|-
|2
|1
|Zipped .txt
|Zipped .dbf
|-
|-
|3
|3
|Zipped .csv
|Zipped .csv
|-
|-
|4
|5
|Zipped .xls (Excel)
|Zipped .xls
|-
|-
|7
|6
|.txt
|.dbf
|-
|-
|8 (Default)
|8
|.csv
|.csv (default)
|-
|-
|10
|10
|.xls (Excel)
|.xls
|}
|}
|-
|po
|Buy Requests Only. Defines the customer’s purchase order number.
|N/A
|To specify: po=xxxx
|}
|}




===General Options===
<h3 class="h3grey">Other Options</h3>
{|class="alternate01" cellspacing="0"
{|class="alternate01 indent" cellspacing="0"
!URL Parameter
!URL Parameter
!Description
!Description
!Default Value
!style="border-right:0px;"|Values
!style="border-right:0px;"|Optional Output Parameter
|-
|-
|dbug
|one
|Parameter check. If a parameter in the url is spelled wrong or not suited for the given call, the request will be rejected.
|
|dbug=0
{|class="alternate01" cellspacing="0"
|To check: dbug=1
!Value
!Definition
|-
|false
|all properties owned by owner
|-
|true
|One property per owner
|}
|Default: true
|-
|xml
|
{|class="alternate01" cellspacing="0"
!Value
!Definition
|-
|true
|response in xml
|-
|false
|response in json
|}
|Default: false
|}
|}




[[Category:LeadGen]]
[[Category:LeadGen]]
[[Category:LeadGen Property] V2]
[[Category:LeadGen Property V2]]

Latest revision as of 01:31, 4 March 2023

← LeadGen Cloud API

LeadGen Property V2 Navigation
Introduction
Request Parameters
Response
Property Result Codes



Standard Components

Parameter Definition
Domain
Version V2
Web Service Property
Protocol REST
Action "Get Count" or "Buy List"
Geographic type ZIP, City, County, or Radius. See Geographic Types for more info.
Customer ID The requester’s Customer ID, License Key, or Email Address.
Options


Actions

The following actions are supported by the web service:

Action Service Description
Get Get the count of customers who fit the geographic and property criteria.
Buy Buy a list of customers' info that fit the geographic and property criteria.


An example of this action in the URL:

https://list.melissadata.net/v2/Property/buy_zip?id=123456&zip=92688&propertype=10-11-22&bedrooms=2-4&occu=3


Authentication

Each Customer ID, License Key, or Email Address is passed in as id in the URL. This is checked against the list of registered customers.


Geographic Types

An example of this parameter in the URL

https://list.melissadata.net/v2/Property/count_zip?id=123456&zip=92688&propertype=10-11-22&bedrooms=2-4&occu=3

Each request must specify one of the following geographic types:

Type Sub Types Description
zip ZIP(s)

5-digit ZIPs

Multiple ZIP can be requested, comma separated with no space or period.

ZIP in Radius

5-digit ZIP

Miles of radius from any given ZIP (mile in decimal).

ZIP(s) in City

5-digit ZIP, City, and 2-digit State.

address

Address, City and State or ZIP.

Miles of radius from a given address. (mile in decimal)

street Street name and ZIP or city and state, with street number range being optional
city

Format: 2-digit state;city name, i.e. TX;Dallas

Multiple cities be requested, comma separated with no space, or period

town

Multiple town or place be requested, comma separated with no space, or period

Format: 2-digit state;town name, i.e. CA:Adelanto

Town name and State

county by FIPS

Format: 2-digit state;county name, or FIPS

by County, State

Multiple counties be requested, comma separated with no space or period, i.e. CA:Lake, 06029

state

2-digit state name

circle

Miles of radius from a point defined as “latitude;longitude” with a semi colon delimiter, i.e.“-117.597760116333;33.63565170564778”

0.25 miles radius min., 25 miles radius max.

polygon A set of points (latitude /longitude)within 0.25 miles square and 25 miles square. Each point is defined as “latitude;longitude” with a semi colon delimiter, use comma delimiter between each set of latitude;longitude. For example, 33.649656850987895;-117.59544268774414, 33.636509228993326;-117.6109780423584, 33.63222152688031;-117.59518519567871”
rectangle

Southwest and northeast points (latitude /longitude). Each point is defined as “latitude;longitude” with a semi colon delimiter, use comma delimiter between each set of latitude;longitude. For example, “33.63565170564778;-117.597760116333, 33.649513952846554;-117.58685961889648”

0.25 miles square min., 25 miles square max.


Options

Each request takes a set of geographic input. Property and other input are optional with default values, as well as purchase options. See Columns in File for the format of all columns appended to file.

Geographic Options

An example of this parameter in the URL:
https://list.melissadata.net/v2/Property/buy_city?id=123456&ctyst=CA;Tustin,CA;Irvine
URL Parameter Geographic Type Description
zip

Required: zip

Optional: address, street, circle, rectangle

Each five-digit ZIP is validated.
addr Require: Address No validation.
ctyst Required: city Format: state;city
city Optional: address, street, ZIP If ZIP is given, city is not necessary.
town Required: town Not validated.
cntyst Required: county The value could be .a variety of state;county and/or FIPS.
state

Required: state

Optional: address, county, street, zip

For state type, 2-digit state is required.

For other types, if ZIP or FIPS is given, state is not necessary.

mile

Required: address, street, circle

Option: zip

Radius of miles from a given street, address or ZIP.
street Required: street Exact street name is required. No validation.
num1 Optional: street Start and end of the range of street numbers. Either end can be left unspecified.
num2
pt Required: circle, rectangle. polygon

Each point is defined as “latitude;longitude” with a semi colon delimiter.

For multiple points, use comma delimiter between each set of latitude;longitude. For example, “33.63565170564778;-117.597760116333, 33.649513952846554;-117.58685961889648”

Rectangle takes 2 points: 1) southwest, 2) northeast.

Polygon takes at least 3 points, counter clockwise.


Property Options

URL Parameter Description Values
propertype

Property codes & types:

Value Definition
00 Miscellaneous
000 Not Available/None
10 Single Family Residence
11 Condominium(Residential)
20 Commercial
21 Duplex, Triplex, Quadplex
22 Apartment
23 Hotel, Motel
24 Condominium(Commercial)
25 Retail
26 Service(general public)
27 Office Building
28 Warehouse
29 Financial Institution
30 Hospital(medical complex, clinic)
31 Parking
32 Amusement-Recreation
33 Mobile Home
50 Industrial
51 Industrial Light
52 Industrial Heavy
53 Transport
54 Utility
70 Agricultural
80 Vacant Lot (Land)
90 Exempt

Default: all.

Otherwise specify the index; use ‘-‘ dash to specify multiple choices, e.g. propertype =10-11 means Single Family Residence and Condominium(Residential)

bedrooms Number of bedrooms

Default: no filter.

To specify a range, use min-max, e.g. 2-4. Use 0 if either end has no preference. For example, 2-0 means at least 2.

bathrooms Number of bathrooms
units Unit number
yearbuilt Year built. Format. YYYY.
pval Property value ($)
equity Equity ($)
lvratio Loan to value ratio (%).
sqft Square footage
bsqft Basement square footage
lot

Lot size. It can be a range. The unit can be:

  • a for acre, or
  • f for sq. ft.

Format: unit;size.

Default: no filter.

Unit: default is sq. ft (f).

Size: To specify a range, use min-max. 2-4 means 2-4 acres. Use 0 if either end has no preference. For instance, f;2000-0 means at least 2000 sq. ft.

samt Range of sale amounts in thousands ($)

Default: no filter.

To specify a range, use min-max, i.e. 2-4. Use 0 if either end has no preference. For instance, 2-0 means at least $2,000.

sdt Range of sale dates

Default: no filter.

To specify a period, use MYYYY-MYYYY. The start month starts on the 1st; the end month ends on the last day, i.e. sdt=32010-122014, this covers 3/1/2010 to 12/31/2014.

pool Has pool or not.

1 means using it as a filter while 0 means no preference. For example, pool=1. If not specified, it means no preference.

heat Has heater or not.
ac Has A/C or not.
fireplace Has fireplace or not.


Mortgage Options

URL Parameter Description Values
mtgAmt

(Range of) amount in thousands ($) Combined amount for 1st and 2nd mortgages

Default: no filter

To specify a range of amounts, use min-max. Use 0 if either end has no preference. For instance, 2-0 means at least $2000, 5-10 means between$5000 and $10000.

It’s an OR relationship when more than one of the three parameters have values.

mtgAmt1 1st Mortgage Amount
mtgAmt2 2nd Mortgage Amount
mtgRt

Rate (range) Rate for either 1st or 2nd mortgage

Default: no filter.

To specify a range of rates, use min-max. Use 0 if either end has no preference. For instance, 2.5-0 means 2.5% at least, 3-5.5 means between 3% and 5.5%.

It’s an OR relationship when more than one of the three parameters have values.

mtgRt1 1st Mortgage Rate
mtgRt2 2nd Mortgage Rate
mtgRtTp

Interest rate type for 1st or 2nd mortgage. Types are:

Value Definition
2 fixed rate
1 adjustable rate
0 unknown

Default: no filter.

To include a variety of types, use -. For instance, 2-1 means to include fixed and adjustable rate.

It’s an OR relationship when more than one of the three parameters have values.

mtgRtTp1
mtgRtTp2
mtgTm Term (years)

Default: no filter

To specify a range of terms, use min-max. Use 0 if either end has no preference. For instance, 5-0 means at least 5-year term, 15-30 means between 15-year to 30-year term

It’s an OR relationship when more than one of the three parameters have values.

mtgTm1 1st mortgage term
mtgTm2 2nd Mortgage Term
mtgLender

Mortgage lender(s). Exact names are needed.

Use – as the delimiter for multiple lenders.

Default: no filter

Example: America Bank-America Bank and Trust

mtgRecDt Recording date (range)

Default: no filter.

To specify a period, use MYYYY-MYYYY. The start month starts on the 1st; the end month ends on the last day. For instance, 12015-112018 means between 1/1/2015 and 11/30/2018.

It’s an OR relationship when more than one of the three parameters have values.

mtgRecDt1 1st Mortgage Recording Date
mtgRecDt2 2nd mortgage recording date
mtgTp

Mortgage type(s). Multiple mortgages are separated by comma.

Value Definition
0 Unknown
3 Building or Construction
5 Conventional
6 Line of Credit
8 FHA
10 Conventional
16 Veterans Administration Loan
101 USDA - US Department of Agriculture Loan
102 Regional Government Programs
103 Commercial
104 Regional Government Programs
105 Reverse Mortgage
120 Private Party Loan

Default: no filter

For instance, 5-8 means conventional or FHA

It’s an OR relationship when more than one of the three parameters have values.

mtgTp1 1st Mortgage type
mtgTp2 2nd mortgage type
mtgScb Seller Carry Back (Is the seller is also the lender?)

Default: no filter.

Including or excluding – true or false.

It’s an OR relationship when more than one of the three parameters have values.

mtgScb1 1st Mortgage Seller Carry back
mtgScb2 2nd mortgage seller carry back


Occupant/Owner Options

URL Parameter Description Values
occu

Occupant types

Value Definition
1 Owner occupied
2 Absentee owner (all types)
3 Absentee Owner - In County
4 Absentee Owner – In State
5 Absentee Owner – Out of County
6 Absentee Owner – Out of State

Default: no preference.

For multiple absentee owner types, use – as the delimiter. It’s an OR relationship between the selected types. For instance, 3-6 means in county or out of state.

owntrs Trustee owner

Default: no preference. Including or excluding – true or false.

owncorp Corporate owner
vacant Vacant property


Demographic Options

URL Parameter Description Values
hhage

Household age:

Value Definition
1 18 - 24 Years
2 25 - 34 Years
3 35 - 44 Years
4 45 - 54 Years
5 55 - 64 Years
6 65 - 74 Years
7 75+ Years

Default: all.

Otherwise specify the index; use ‘-‘ dash to specify multiple choices, i.e. 1-2 means 18-34 years old

gender

Gender:

Value Definition
f female
m male
u unisex

Default: all.

Otherwise specify the index; use ‘-‘ dash to specify multiple genders, i.e. f-m mean female and male

hhinc

Household income:

Value Definition
1 Under $10,000
2 $10,000 - $14,999
3 $15,000 - $19,999
4 $20,000 - $24,999
5 $25,000 - $29,999
6 $30,000 - $34,999
7 $35,000 - $39,999
8 $40,000 - $44,999
9 $45,000 - $49,999
A $50,000 - $54,999
B $55,000 - $59,999
C $60,000 - $64,999
D $65,000 - $69,999
E $70,000 - $99,999
F $100,000 - $149,999
G $150,000 - $174,999
H $175,000 - $199,999
I $200,000 - $249,999
J $250,000+

Default: all.

Otherwise specify the index; use ‘-‘ dash to specify multiple choices, i.e. 1-2 means $14,999 or less

marital

Marital status

Value Definition
a inferred married
b inferred single
m married
s single

Default: all.

Otherwise specify the index; use ‘-‘ dash to specify multiple choices, i.e. b-s means inferred single or single

lores

Length of residence

Value Definition
0 Less than 1 year
1 1 Year
2 2 Years
3 3 Years
4 4 Years
5 5 Years
6 6 Years
7 7 Years
8 8 Years
9 9 Years
10 10 Years
11 11 Years
12 12 Years
13 13 Years
14 14 Years
15 Over 14 Years

Default: all.

Otherwise specify the index; use ‘-‘ dash to specify multiple choices, i.e. 0-1-2 means 2 years or under

people

Persons in household (number of people in household):

Value Definition
1 1 Person
2 2 Persons
3 3 Persons
4 4 Persons
5 5 Persons
6 6 Persons
7 7 Persons
8 8 Persons
9 9+ Persons

Default: all.

Otherwise specify the index; use ‘-‘ dash to specify multiple choices, i.e. 1-2 means 2 or less

adults

Adults in household:

Value Definition
1 1 Adult
2 2 Adults
3 3 Adults
4 4 Adults
5 5 Adults
6 6+ Adults
kids

Children in household:

Value Definition
1 1 Child
2 2 Children
3 3 Children
4 4 Children
5 5 Children
6 6 Children
7 7 Children
8 8+ Children


Number of Records in File

Each purchase allows 100,000 records at most.
URL Parameter Description Values
qty Number of records to buy Default: no preference.


Columns in File

Owner names, mailing address and property address are included in the list by default.
Additional fields can be added by setting each of the URL parameters’ value to “true.”
Column Name Max Length URL Value to Append Description
ID
ContactMak
FullName1 150 party owner 1 full name
FirstName1 50 party owner 1 first name
MiddleName1 20 party owner 1 middle name
LastName1 50 party owner 1 last name
Suffix1 20 party owner 1 name suffix
FullName2 150 party owner 2 full name
FirstName2 50 party owner 2 first name
MiddleName2 20 party owner 2 middle name
LastName2 50 party owner 2 last name
Suffix2 20 party owner 2 name suffix
MailAddr 100 mailing address
MailCity 100 mailing city
MailState 15 mailing state
MailZip 10 mailing ZIP
MailPlus4 4 mailing ZIP 4
MailCRRT 4 mailing carrier route
MailDPB 2 mailing delivery point
MailFIPS 5 mailing FIPS
SiteAddr 50 property address
SiteCity 35 property city
SiteState 15 property state
SiteZip 10 property ZIP
SitePlus4 4 property ZIP 4
SiteCRRT 4 property carrier route
SiteDPB 2 property delivery point
SiteFIPS 5 property FIPS
SiteMak
PropertyType 250 fpropertype
BedroomsCount 10 fbedrooms
BathCount 10 fbathrooms
AreaSqft 10 fsqft
LotSqft 10 flot
LotAcre 15
Units 5 funits
YearBuilt 4 fyearbuilt
EstimatedPropertyValue 15 fpval
EquityAmount 15 fequity
LoanToValueRatio 15 flvratio
LastSaleDate 10 fsdt
LastSaleAmount 15 fsamt
BasementAreaSqft 10 fbsqft
Pool 3 fpool
Heater 3 fheat
AC 3 fac
Fireplace 3 ffireplace
Mortgage1Amount 15 fmtgAmt
Mortgage2Amount 15
Mortgage1InterestRate 10 fmtgRt
Mortgage2InterestRate 10
Mortgage1InterestRateType 15 fmtgRtTp
Mortgage2InterestRateType 15
Mortgage1Term 10 fmtgTm
Mortgage2Term 10
Mortgage1LenderName 250 fmtgLender
Mortgage2LenderName 250
Mortgage1RecordingDate 10 fmtgRecDt
Mortgage2RecordingDate 10
Mortgage1Type 250 fmtgTp
Mortgage2Type 250
Mortgage1SellerCarryBack 3 fmtgScb
Mortgage2SellerCarryBack 3
PrimaryAbsenteeOwner 13 foccu
TrusteeOwner 3 fowntrs
CorporateOwner 3 fowncorp
HouseholdAge 11 fhhage
IncomeEstimatedHousehold 250 fgender
MaritalStatus 250 fhhinc
HomeLengthofResidence 250 fmartial
HouseholdSize 250 flores
NumberOfAdults 250 fpeople
NumberOfChildren 250 fadults


File Format

URL Parameter Values
file
Value Definition
1 Zipped .dbf
3 Zipped .csv
5 Zipped .xls
6 .dbf
8 .csv (default)
10 .xls


Other Options

URL Parameter Description Values
one
Value Definition
false all properties owned by owner
true One property per owner
Default: true
xml
Value Definition
true response in xml
false response in json
Default: false