LeadGen Property:List/File

From Melissa Data Wiki
Revision as of 17:08, 12 May 2016 by Admin (talk | contribs) (Admin moved page LeadGen:Property:List/File to LeadGen Property:List/File)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

← LeadGen Cloud API

LeadGen Property Navigation
Introduction
Request Parameters
XML Response
List/File
Property Result Codes



File Types

File Format Value to Specify in URL
Zipped .txt file=2
Zipped .csv file=3
Zipped .xls file=5
.txt file=7
.csv file=8
.xls file=10


Columns in File

Column Max Length Description Frequency %
OwnerName1 30 Property owner name 100
OwnerName2 30 Additional owner name 43
MailAddress 75 Mailing street address 97
MailCity 28 Mailing city 97
MailState 2 Mailing state 97
MailZip 5 Mailing Zip 97
MailPlus4 4 Mailing Zip plus 4 95
MailCRRT 4 Mailing carrier route 95
MailDPB 4 Mailing delivery point 95
SiteAddress 75 Property street address 87
SiteCity 28 Property city 85
SiteState 2 Property state 100
SiteZip 5 Property Zip 85
SitePlus4 4 Property Zip plus 4 74
SiteCRRT 4 Property carrier route 74
SiteDPB 4 Property delivery point 74
OccupantType 1

You must append “occu-d=#” to the URL for this.

True (1): Absentee

False (0): Not absentee

71
MailOptOut 1 A "Y" represents a record where the property owner has contacted the DMA (i.e., Direct Marketing Association) and has asked not to be contacted by mail for solicitation. opt=0 or opt=1. 3
FIPSCode 5 Federal Information Processing Standards codes used nationally to numerically identify a specific county or political jurisdiction. opt=0 or opt=1. 100
FormattedAPN 45 Assessor's Parcel Number in a formatted form. Dashes and 100 decimals are commonly used to break an APN down into logical components (e.g., 101-32-021.A). opt=0 or opt=1. 100
FIPSSubCode 3 A secondary classification of a jurisdiction within a FIPS. opt=1. 100
UnformattedAPN 45 Assessor's Parcel Number in an unformatted form. This is most often used by the county and others as a unique key (e.g.,10132021A). opt=1. 100
APNSequenceNo 3 This internal sequence number is used to ensure "uniqueness" of the Assessor's Parcel Number (e.g., 10132021A seq 001). opt=1. 100
OriginalAPN 45 Assessor's Parcel Number exactly as received by source (e.g., 10132-021A00000). opt=1. 66
CensusTract 10 Comprised of Census Tract, Census Block and Census Block Suffix. These numbers are established by the US Department of Commerce (Bureau Of The Census). opt=1. 93
Zoning 10 The data contained in this field is based upon County and/or Local established Zoning Codes and are not converted by FARES. opt=1. 41
Range 3 The "range" portion of geographical coordinates based on local surveys. Ranges typically run east or west of predetermined "meridian" in six mile intervals. opt=1. 38
Township 3 The "township" portion of geographical coordinates based on local surveys. Townships typically run north or south of pre-determined "meridian" in six mile intervals. opt=1. 39
Section 3 The "section" portion of geographical coordinates based on local surveys. Sections are 1 square mile and there are 36 sections within the intersection of a Range / Township. opt=1. 38
QuarterSection 3 A section that has been divided into four "sub" sections (e.g., NE, NW, SE, SW). opt=1. 9
HomesteadExempt 1 This field will be set with an "Y" if the owner has qualified for a Homeowner/Homestead exemption. opt=1. 24
LandUseCode 10 A FARES established Land Use code converted from various county Land Use codes to aid in search and extract functions. opt=1. 100
CountyLandUse1 10 Primary (i.e., highest) Land Use as established by the county or local taxing administration. opt=1. 98
CountyLandUse2 10 Secondary Land Use as established by the county or local taxing administration. opt=1. 17
PropertyIndicatorCode 3 A FARES general code used to easily recognize specific property types (e.g, Residential, Condominium, Commercial). opt=1. 100
MunicipalityName 30 Name of the Municipality where parcel is located. opt=1. 60
ViewCode 3 View from building (e.g., Gulf, Mountains, Pool). opt=1.

For a list of possible values and their descriptions, see the View Code table.

2
LocationInfluenceCode 3 Positive or negative aspects associated with the location of the parcel (e.g., waterfront, flood plane, airport). opt=1.

For a list of possible values and their descriptions, see the LOCIN Code table.

8
NumberOfBuildings 3 Total number of buildings on the parcel. opt=1. 67
CorporateOwner 1 The Name of the property owner has been recognized as a corporation or business. opt=1. 17
Phone 10 Phone number of property owner (e.g., 9095551212). opt=1. 0
PhoneOptOut 1 A "Y" represents a record where the property owner has contacted the DMA (i.e., Direct Marketing Association) and has asked not to be contacted by phone for solicitation. opt=1. 24
Matchcode 4 See "MATCH” code in table 4.3 for descriptions. opt=1. 97
CalculatedTotalValue 11 The "TOTAL" (i.e., Land + Improvement) Value closest to current market value used for assessment by county or local taxing authorities. opt=0 or opt=1. 97
CalculatedImprovementValue 11 The "IMPROVEMENT" Value closest to current market value used for assessment by county or local taxing authorities. opt=0 or opt=1. 69
AssessedTotalValue 11 The Total Assessed Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority. opt=0 or opt=1. 96
TaxAmount 11 The Total Tax amount provided by the county or local taxing/assessment authority. opt=0 or opt=1. 93
CalculatedLandValue 11 The "LAND" Value closest to current market value used for assessment by county or local taxing authorities. opt=1. 88
CalculatedTotalValueCode 1 The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the TOTAL VALUE CALCULATED field. opt=1.

For a list of possible values and their descriptions, see the VALTY Code table.

100
CalculatedLandValueCode 1 The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the LAND VALUE CALCULATED field. opt=1.

For a list of possible values and their descriptions, see the VALTY Code table.

100
CalculatedImprovementValueCode 1 The code appearing in this indicator field reflects the type of values (e.g., Market, Appraised) used to seed the IMPROVEMENT VALUE CALCULATED field. opt=1.

For a list of possible values and their descriptions, see the VALTY Code table.

100
AssessedLandValue 11 The Assessed Land Values as provided by the county or local taxing/assessment authority. opt=1. 73
AssessedImprovementValue 11 The Assessed Improvement Values as provided by the county or local taxing/assessment authority. opt=1. 57
MarketTotalValue 11 The Total Market Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority. opt=1. 75
MarketLandValue 11 The Market Land Values as provided by the county or local taxing/assessment authority. opt=1. 63
MarketImprovementValue 11 The Market Improvement Values as provided by the county or local taxing/assessment authority. opt=1. 49
AppraisedTotalValue 11 The Total Appraised Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority. 12
AppraisedLandValue 11 The Appraised Land Values as provided by the county or local taxing/assessment authority. opt=1. 8
AppraisedImprovementValue 11 The Appraised Improvement Values as provided by the county or local taxing/assessment authority. opt=1. 6
TaxYear 4 The tax or assessment year for which the taxes were billed. opt=1. 93
SaleDate 8 The date the sales transaction was legally completed (i.e., contact signed) (e.g., 19621025). opt=0 or opt=1. 52
SalePrice 11 Price of the sale as depicted on the recorded sales transaction. opt=0 or opt=1. 50
TransactionId 17 This is a FARES internal number used to identify a specific transaction. This number may aid customers in the creation of unique keys. opt=0. 68
DocumentYear 4 The year a sales transaction document was recorded (e.g., 1984). opt=0. 47
DeedCategoryCode 3 The type of deed used to record the sales transaction (e.g., Grant, Quit, Foreclosure). opt=0.

For a list of possible values and their descriptions, see the DEEDC Code table.

68
RecordingDate 8 The date the sales transaction was recorded at the county (e.g., 19621028). opt=0. 58
SaleCode 1 This field indicates what the financial consideration is. opt=0.

For a list of possible values and their descriptions, see the SCODE Code table.

13
SellerName 60 The seller's name as it appears on the recorded sales transaction. opt=0. 60
MultiAPNCode 1 The data contained in this field depicts multiple or split parcel sales. opt=0.

For a list of possible values and their descriptions, see the SLMLT Code table.

8
MultiAPNCount 4 This reflects the number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number). opt=0. 5
ResidentalModel 1 A code to indicate whether the property is residential based on individual zipcodes and values. "Y" = yes, "N" or blank = no. opt=0. 68
MortgageAmount 11 The amount of the first mortgage as depicted on the recorded document. opt=0 or opt=1. 34
MortgageTerm 5 The length of time before the mortgage matures (e.g., 15yrs, 30 yrs, 45dys). opt=0 or opt=1. 27
MortgageDueDate 8 The date the mortgage amount becomes due. opt=0 or opt=1. 27
MortgageDate 8 The date the Mortgage was initiated. opt=1. 34
MortgageLoanTypeCode 5 Type of load secured (e.g., Conventional, FHA, VA). opt=1.

For a list of possible values and their descriptions, see the MTGTP Code table.

33
MortgageDeedTypeCode 6 Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed). opt=1.

For a list of possible values and their descriptions, see the DOCTY Code table.

30
MortgageTermCode 4 This code is used to identify whether the number stored in the MORTGAGE TERM field is in Days, Months or Years. opt=1.

For a list of possible values and their descriptions, see the MTGTC Code table.

27
MortgageAssumptionAmount 9 The assumption amount related to an existing mortgage. opt=1. 0
LenderCode 10 This is a FARES internal code used to identify the Lending Company that was associated with the sales transaction. opt=1. 27
LenderName 60 This is the name of the lender on the original recorded document. opt=1. 34
SecondMortgageAmount 11 This is the amount associated with the 2nd mortgage. opt=1. 2
SecondMortgageLoanTypeCode 5 Type of load secured as part of the 2nd mortgage (e.g., Conventional, FHA, VA). opt=1.

For a list of possible values and their descriptions, see the MTGTP Code table.

2
SecondMortgageDeedTypeCode 6 Type of deed used for recording the 2nd mortgage (e.g., Agreement of Sale, Assumption, Correction Deed). opt=1.

For a list of possible values and their descriptions, see the DOCTY Code table.

2
PriorTransactionId 13 This is a FARES internal number used to identify a specific transaction. This number may aid customers in the creation of unique keys. opt=1. 35
PriorDocumentYear 4 The year a sales transaction document was recorded (e.g., 1984). opt=1. 22
PriorDeedCategoryCode 1 The type of deed used to record the prior sales transaction (e.g., Grant, Quit, Foreclosure). opt=1.

For a list of possible values and their descriptions, see the DEEDC Code table.

35
PriorRecordingDate 8 The date the sales transaction was recorded at the county (e.g., 19621028). opt=1. 27
PriorSaleDate 8 The date the sales transaction was legally completed (i.e., contact signed) (e.g., 19621025). 27
PriorSalePrice 11 Price of the sale as depicted on the recorded sales transaction. opt=1. 27
PriorSaleCode 1 This field indicates whether the financial consideration is F = Full or P = Partial. opt=1. 8
PriorTransactionCode 3 This identifies situations associated with the sale (e.g., Resale, Construction Loan, Seller Carryback). opt=1.

For a list of possible values and their descriptions, see the TRNTP Code table.

0
PriorMultiAPNCode 1 The data contained in this field depicts multiple or split parcel sales. opt=1.

For a list of possible values and their descriptions, see the SLMLT Code table.

4
PriorMultiAPNCount 4 This reflects the number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number). opt=1. 0
PriorMortgageAmount 11 This is the amount associated with the mortgage of the prior sale. opt=1. 15
PriorDeedType 1 Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed). opt=1.

For a list of possible values and their descriptions, see the DOCTY Code table.

10
Acreage 13 Total land mass in Acres. opt=0 or opt=1. 92
SquareFootage 9 Total land mass is Square Feet. opt=0 or opt=1. 92
FrontFootage 7 The linear feet across the front of the lot - facing the street. opt=1. 27
DepthFootage 7 The linear feet between the front and back of the lot. opt=1. 25
BuildingArea 9 The size of the building in Square Feet. This field is most commonly populated as a cumulative total when a county does not differentiate between Living and Non-living areas. opt=0 or opt=1. 46
LivingSpace 7 This is the area of a building that is used for general living. This is typically the area of a building that is heated or air conditioned and does not include Garage, Porch or Basement square footage. opt=0 or opt=1. 57
UniversalBuilding 9 The Building Square Footage that can most accurately be used for assessments or comparables (e.g., Living, Adjusted,

Gross). opt=1.

61
BuildingAreaCode 1 The codes appearing in this field indicates the source used to populate the UNIVERSAL BUILDING SQUARE FEET

field (e.g., Living, Adjusted, Gross). opt=1. For a list of possible values and their descriptions, see the BLDSF Code table.

61
GroundFloor 7 Square footage of the part of the building which is level with the ground (typically the front of the building). This is generally above the basement(s) and below the second floor. opt=1. 30
Gross 7 This is the square footage for the entire building. Typically this represents all square feet under the roof. opt=1. 8
AdjustedGross 7 This is the square footage used by the county or local taxing / assessment authority to determine Improvement Value. This figure is typically 100% of the living area, plus lower percentage of non-living area. opt=1. 9
Basement 7 This is total square footage associated with Basement portion of a building. This would include both finished and unfinished areas. opt=1. 11
GarageOrParking 7 This is the total square footage of the primary garage or parking area (i.e., commercial). This includes both finished and unfinished areas. opt=1. 26
YearBuilt 4 This is the construction year of the original building. opt=0 or opt=1. 59
BedRooms 5 Total number of bedroom contained in the primary building. opt=0 or opt=1. 41
TotalRooms 5 Total number of rooms contained in the primary building. opt=0 or opt=1. 29
TotalBaths 7 Total number of Bathrooms as provided by our data sources (e.g., 4.00, 2.50, 1.75). opt=0 or opt=1. 51
EffectiveYearBuilt 4 This is the first year the building was assessed with its current components (e.g., a building is originally constructed in 1960 and a bedroom and bath was added to the building in 1974. The Year Built would be 1960 and the Effective Year Built would be 1974. opt=1. 26
TotalBathsCalculated 7 Total number of Bath Rooms in whole numbers (e.g., a home containing 2 1/2 baths would have the number 3 stored in this field as, three actual rooms have been designated for this purpose). opt=1. 51
FullBaths 5 Total number of Full Baths (typically comprised of a sink, toilet, and bathtub / shower stall). A home containing 2 1/2 baths would have the number 2 stored in this field. opt=1. 49
HalfBaths 5 Total number of Half Baths (typically comprised of a sink & toilet). A home containing 2 1/2 baths would have the number 1 stored in this field. opt=1. 14
OneQuarterBaths 5 Total number of Quarter Baths (typically comprised only of a sink, as found in many laundry rooms). opt=1. 0
ThreeQuarterBaths 5 Total number of 3 Quarter Baths (typically comprised of a sink, toilet & shower stall). opt=1. 1
BathFixtures 5 The total number of bathroom fixtures (typically a Full Bath would have 4 fixtures - 1 = sink, 1 = toilet, 1 = bathtub, 1 = shower head). opt=1. 13
AirConditioningCode 3 The type of air conditioning method used to cool the building (e.g., Central, Wall Unit, Evaporative). opt=1.

For a list of possible values and their descriptions, see the AC Code table.

34
BasementCode 3 The type of basement found in the building (e.g., Finished, Half, Crawl). opt=1.

For a list of possible values and their descriptions, see the BSMTF Code table.

6
BuildingCode 3 The primary building type (e.g., Bowling Alley, Supermarket). opt=1.

For a list of possible values and their descriptions, see the BLDG Code table.

34
ImprovementCode 3 The primary improvement type (e.g., Grain Silo, Hanger, Marina). opt=1.

For a list of possible values and their descriptions, see the IMPRV Code table.

4
ConditionCode 3 This represent the physical condition of the mail improvement (e.g., Good, Fair, Under Construction). opt=1.

For a list of possible values and their descriptions, see the COND Code table.

31
ConstructionCode 3 The primary method of construction (e.g., Steel / Glass, Concrete Block, Log). opt=1.

For a list of possible values and their descriptions, see the CNSTR Code table.

14
ExteriorWallCode 3 The type and/or finish of the exterior walls (e.g., Vinyl Siding, Brick Veneer, Frame / Stone). opt=1.

For a list of possible values and their descriptions, see the EXTNW Code table.

45
Fireplace 1 This field is populated with a "Y" if a fireplace is located within the building. opt=1. 22
Fireplaces 3 This represent the number of fireplace openings located within the building. opt=1. 20
FireplaceCode 3 The type of fireplace (e.g., 2 Story / 3 Openings, 2 Story Brick). opt=1.

For a list of possible values and their descriptions, see the FIREP Code table.

21
FoundationCode 3 The type of foundation (e.g., Continuous Footing, Pier, Mud Sill). opt=1.

For a list of possible values and their descriptions, see the FOUND Code table.

22
FlooringCode 3 The type of floor construction (e.g., Concrete, Plywood). opt=1.

For a list of possible values and their descriptions, see the FLTYP Code table.

4
RoofFramingCode 3 The type of roof framing used (e.g., Bar Joist, Reinforced Concrete, Flexicore). opt=1.

For a list of possible values and their descriptions, see the RFFRM Code table.

2
GarageCode 3 Type of garage or carport present (e.g., Attached Finished, Enclosed Carport, Basement Garage). opt=1.

For a list of possible values and their descriptions, see the GRGCD Code table.

36
HeatingCode 3 Type or method of heating (e.g., Hot Water, Heat Pump, Baseboard, Radiant). opt=1.

For a list of possible values and their descriptions, see the HEAT Code table.

45
MobileHome 1 This field is populated with a "Y" if a Mobile Home is present on the parcel. opt=1. 2
ParkingSpaces 5 This represents the total number of Parking Spaces or Car Capacity associated with the Garage or Parking type. opt=1. 3
ParkingCode 3 Type of parking found on the parcel. This is typically commercial or communal (e.g., Condos) in nature. opt=1.

For a list of possible values and their descriptions, see the PARKG Code table.

38
Pool 1 This field is populated with a "Y" if a Pool is present on the parcel. opt=1. 5
PoolCode 3 Type of pool, construction or pool amenities (e.g., Kidney, Gunite, Vinyl, Jacuzzi, Heated). opt=1.

For a list of possible values and their descriptions, see the POOL Code table.

5
QualityCode 3 Type of construction quality of building (e.g., excellent, economical). opt=1.

For a list of possible values and their descriptions, see the QUAL Code table.

23
RoofCoverCode 3 Type of roof covering (e.g., Clay Tile, Aluminum, Shake). opt=1.

For a list of possible values and their descriptions, see the RFCOV Code table.

35
RoofTypeCode 3 Type of roof shape (e.g., Gambrel, Gable, Flat, Mansard). opt=1.

For a list of possible values and their descriptions, see the RFSHP Code table.

23
StoriesCode 3 Type / number of stories (e.g., Split Foyer, Tri Level, 2 Story). opt=1.

For a list of possible values and their descriptions, see the STORY Code table.

21
Stories 5 Number of stories associated with the building (e.g., 2, 1.5). opt=1. 51
BuildingStyleCode 3 Type of building style (e.g., Colonial, Cape Code, Bungalow). opt=1.

For a list of possible values and their descriptions, see the STYLE Code table.

28
Units 5 Number of Residential, Apartment or Business Units. opt=1. 14
ElectricityCode 3 Type of electricity or energy use within the building (e.g., Average Wiring, Underground Wired, Private Source). opt=1.

For a list of possible values and their descriptions, see the ELEC Code table.

18
FuelCode 3 Type of fuel used for heating of water and building (e.g., Solar, Gas, Oil). opt=1.

For a list of possible values and their descriptions, see the FUEL Code table.

17
SewerCode 3 Type of sewer system on the parcel (e.g., Public, Septic, Commercial). opt=1.

For a list of possible values and their descriptions, see the SEWER Code table.

23
WaterCode 3 Type of water service on the parcel (e.g., Public, Well, Cistern). opt=1.

For a list of possible values and their descriptions, see the WATER Code table.

23