Data Layouts
Parent topic: Data Layouts

Property Attributes Data

This section describes the output fields that are returned for each Property Attributes dataset. For more details, refer to the Excel® spreadsheet that is provided with your Property Attributes dataset download.

All Variables Dataset

Note: An italicized field name is only returned by the All Variables dataset.

The All Variables dataset contains all of the fields in the following table.

Duplicate Data Handling

Addresses with duplicate pbKey™ values are delivered in a separate tab delimited file. The layout is the same as the main file and can be searched by the pbKey™. The record that is identified as the Survivor record is in both versions of the data; it is the record in the duplicate group with the highest property value.

Field Name Length Description Insurance Basic Insurance Extended Owner Financial Services Retail/Real Estate
pbKey 12 Pitney Bowes proprietary lookup key. X X X X X
FNAME 70 Owner first name X X X X X
MNAME 70 Middle name X X X X X
LNAME 70 Owner surname X X X X X
SUFFIX 10 Owner suffix X X X X X
FNAME2 50 Additional owner first name X X X X X
MNAME2 50 Additional middle dame X X X X X
LNAME2 50 Additional owner surname X X X X X
SUFFIX2 10 Additional owner suffix X X X X X
BUSNAME 255 Company name (owner) X X X X X
RECTYPE 1 Record type:
B
Business
R
Residential
 X X X X X
PHONE 10 Property owner phone number X X X X X
PHONE2 10 Property owner secondary phone number X X X X X
Property Address
HOUSE 10 Physical street number X X X X X
PREDIR 2 Physical street pre-directional X X X X X
STREET 28 Physical street name X X X X X
STRTYPE 4 Physical street suffix X X X X X
POSTDIR 2 Physical street post-directional X X X X X
APTTYPE 4 Unit designator X X X X X
APTNBR 8 Unit number X X X X X
CITY 28 USPS city name X X X X X
STATE 2 USPS state abbreviation X X X X X
ZIP 5 USPS ZIP Code X X X X X
Z4 4 USPS ZIP+4 Code X X X X X
VACANT 1
Y
Physical address identified by USPS as vacant
N
Someone living at the address
Blank
Unknown
 X X    
Alternate Address
HOUSE2 10 Physical street number   X X    
PREDIR2 2 Physical street pre-direction   X X    
STREET2 28 Physical street name   X X    
STRTYPE2 4 Physical street suffix   X X    
POSTDIR2 2 Physical street post-direction   X X    
APTTYPE2 4 Unit designator   X X    
APTNBR2 8 Unit number   X X    
CITY2 28 USPS city name   X X    
STATE2 2 USPS state abbreviation   X X    
ZIP2 5 USPS ZIP Code   X X    
Z42 4 USPS ZIP+4 Code   X X    
VACANT2 1
Y
Physical address identified by USPS as vacant
N
Someone living at that address
Blank
Unknown
          
Property Location Information
FIPSCD 5 Federal Information Processing Standards codes used nationally to numerically identify a specific county or political jurisdiction. First 2 pos = Numeric State Code, Last 3 pos = County Code X X X X X
PROP_CENSUSTRACT 10 Comprises Census Tract, Census Block and Census Block suffix. These numbers are established by the US Department of Commerce (Bureau Of the Census).          
PROP_MUNINAME 30 Name of the municipality where the parcel is located.   X   X X
PROP_TOWNSHIPCD 3 The "township" portion of the geographical coordinates based on local surveys. Townships typically run north or south of a pre-determined "meridian" in six-mile intervals. (e.g., 7, 11S, 1N, 36S).   X   X X
PROP_SUBDIVISION 30 If the property is in a specific subdivision so noted on deed recordings; used for 'look ups' etc. on advanced searches within some counties.   X   X X
PROP_ZONING 10 The data contained in this field is based on county and/or locally-established Zoning Codes. (e.g., R, PD, R2, RM15)   X   X X
PROP_RANGE 3 The "range" portion of the geographical coordinates based on local surveys. Ranges typically run east or west of a pre-determined "meridian" in six-mile intervals. (e.g., 3W, 8, 89,31E)   X   X X
PROP_SECTION 3 The "section" portion of the geographical coordinates based on local surveys. Sections are 1 square mile and there are 36 sections within the intersection of a Range/Township. (e.g., 27, 40, 16, 11)   X   X X
PROP_LANDUSE 3 A Land Use code converted from various county Land Use codes to aid in search and extract functions. (e.g., 112, 138, 100, 102) X X X X X
PROP_APN 45 Assessor's Parcel Number in a formatted form. Dashes and decimals are commonly used to break an APN down into logical components (e.g., 101-32-021.A) X X X X X
PROP_APNSEQNBR 3 This internal sequence number is used to ensure uniqueness of the Assessor's Parcel Number (e.g., 10132021A seq 001) X X X X X
Additional Information
PROP_OWNEROCC 1 Absentee owner code descriptions:
A
Absentee (Mail And Situs not equal)
M
Situs Address taken from mail
O
Owner occupied
S
Situs from sale (occupied)
T
Situs from sale (absentee)   
 X X X X X
PROP_ADDRIND 1 Indicates whether the Situs data (i.e., property location) was obtained directly from a county or local source or was derived by the owners mailing address:
M
Mailing address
S
Local source
   X      
PROP_CORPIND 1 Property owner business indicator:
Y
The name of the property owner has been recognized as a corporation or business.
   X X X X
PROP_RESCD 1 Iindicates whether the property is residential based on individual ZIP Codes and values.
Y
Yes
N
No
   X      
PROP_IND 3 A general code used to easily recognize specific property types (e.g., residential, condominium, commercial). X   X X
PROP_MOBHOME 1 Mobile home indicator:
Y
A mobile home is present on the parcel
 X   X X
PROP_NRBBLD 3 Total number of buildings on the parcel. X X   X X
PROP_STYLE 3 Type of building style (e.g., colonial, Cape Cod, bungalow). X X   X X
PROP_STORIESCD 3 Type/number of stories (e.g., split foyer, tri-level, 2-story). X X   X X
PROP_STORIESNBR 5 Number of stories associated with the building (e.g., 2, 1.5) X X   X X
PROP_APTNBR 10 Number of residential, apartment or business units.   X   X X
PROP_QLTY 3 Quality level of building construction:
QAV
Average
QBA
Below average
QVV
Above average
QPO
Poor
QEX
Excellent
QLU
Luxury
999
Bypass
QGO
Good
QLO
Low
QFA
Fair
QEC
Economical
   X   X X
PROP_BLDGCD 3 The primary building type (e.g., bowling alley, supermarket). X   X X
PROP_BLDGIMPCD 3 The primary improvement type (e.g., grain silo, hangar, marina).   X   X X
PROP_COND 3 The physical condition of the mail improvement (e.g., good, fair, under construction). X   X X
PROP_CNSTRTYPE 3 Primary method of construction (e.g., steel /glass, concrete block, log). X X    
PROP_EXTNW 3 Type and/or finish of the exterior walls (e.g., vinyl siding, brick veneer, frame / stone). X X      
PROP_VALCALC 11 The "TOTAL" (i.e., land + improvement) value closest to current market value used for assessment by county or local taxing authorities.   X   X X
PROP_VAL_CALCIND 1 The type of values used to seed the total value calculated field:
A
Assessed
M
Market
P
Appraised
T
Transitional
   X   X X
PROP_LAND_VALCALC 11 The "LAND" Value closest to current market value used for assessment by county or local taxing authorities.   X   X X
PROP_LAND_VALCALC_IND 1 The "LAND" Value closest to current market value used for assessment by county or local taxing authorities:
A
Assessed
M
Market
P
Appraised
T
Transitional
   X   X X
PROP_IMP_VALCALC 11 The "IMPROVEMENT" Value closest to current market value used for assessment by county or local taxing authorities.   X   X X
PROP_IMP_VALCALC_IND 1 The "IMPROVEMENT" Value closest to current market value used for assessment by county or local taxing authorities.
A
Assessed
M
Market
P
Appraised
T
Transitional
   X      
PROP_ASSED_VAL 11 The Total Assessed Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority. X X   X X
PROP_ASSED_LANDVAL 11 The Assessed Land Values as provided by the county or local taxing/assessment authority. X X   X X
PROP_ASSED_IMPVAL 11 The Assessed Improvement Values as provided by the county or local taxing/assessment authority. X X   X X
PROP_MRKTVAL 11 The Total Market Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority.   X   X X
PROP_MRKT_LANDVAL 11 The Market Land Values as provided by the county or local taxing/assessment authority.   X   X X
PROP_MRKT_IMPVAL 11 The Market Improvement Values as provided by the county or local taxing/assessment authority.   X   X X
PROP_APPRAISED_VAL 11 The Total Appraised Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority.   X   X X
PROP_APPRAISED_LANDVAL 11 The Appraised Land Values as provided by the county or local taxing/assessment authority.   X   X X
PROP_APPRAISED_IMPVAL 11 The Appraised Improvement Values as provided by the county or local taxing/assessment authority.   X   X X
Property Attributes Information
PROP_YRBLD 4 The construction year of the original building. (e.g., YYYY). X X   X X
PROP_EFFYRBLD 4 The first year the building was assessed with its current components (e.g., YYYY, 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). X   X X
PROP_VIEW 3 View from building (e.g., gulf, mountains, pool).          
PROP_LCTN_INFL 3 Positive or negative aspects associated with the location of the parcel (e.g., waterfront, flood plain, airport).          
PROP_FRONTFT 7 The linear feet across the front of the lot facing the street.   X      
PROP_DEPTHFT 7 The linear feet between the front and back of the lot.   X      
PROP_ACRES 13 Total land mass in acres. (4 decimal points) Example: 13000 = 1.3 acres          
PROP_LANDSQFT 9 Total land mass in square feet. X X      
PROP_UNVBLDSQFT 9 The building square footage that can most accurately be used for assessments or comparables (e.g., living, adjusted, gross). X X   X X
PROP_BLDSQFTIND 1 The source used to populate the Universal Building Square Feet field (e.g., living, adjusted, gross):
R
Ground floor level
H
Heated area
M
Main or base area
B
Building
A
Adjusted
L
Living
G
Gross
 X X   X X
PROP_BLDSQFT 9 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. X   X X
PROP_LIVINGSQFT 7 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. X   X X
PROP_GRDFLRSQFT 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.   X   X X
PROP_GROSSSQFT 7 Total square footage for the entire building. Typically this represents all square footage under the roof.   X   X X
PROP_ADJGROSSSQFT 7 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.   X   X X
PROP_BSMTSQFT 7 Total square footage associated with the basement portion of a building. This would include both finished and unfinished areas.   X   X X
PROP_PRKGSQ FT 7 Total square footage of the primary garage or parking area (i.e., commercial). This includes both finished and unfinished areas. X   X X
PROP_RMS 5 Total number of rooms contained in the primary building. X X   X X
PROP_BEDRMS 5 Total number of bedroom contained in the primary building. X X   X X
PROP_BATHSCALC 7 Total number of bathrooms 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). (e.g., 200, 300, 400) X X   X X
PROP_BATHS 7 Total number of bathrooms as provided by our data sources (e.g., 4.00, 2.50, 1.75) X X   X X
PROP_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.   X      
PROP_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.   X      
PROP_1QTRBATHS 5 Total number of quarter baths (typically comprised only of a sink, as found in many laundry rooms).   X      
PROP_3QTRBATHS 5 Total number of 3/4 baths (typically comprised of a sink, toilet & shower stall).   X      
PROP_BATHFIXS 5 Total number of bathroom fixtures (typically a full bath would have 4 fixtures - 1 = sink, 1 = toilet, 1 = bathtub, 1 = shower head)   X      
PROP_AC 3 Type of air conditioning method used to cool the building (e.g., central, wall unit, evaporative). X   X X
PROP_BSMTF 3 Type of basement in the building (e.g., finished, half, crawl). X X   X X
PROP_FRPL 1 Fireplace indicator:
Y
A fireplace is located within the building
 X X   X X
PROP_FRPLNBR 3 Number of fireplace openings located within the building (1-10).   X      
PROP_FRPLTYPE 3 Type of fireplace (e.g., 2-story / 3 openings, 2-story brick). X      
PROP_FND 3 Type of foundation (e.g., continuous footing, pier, mud sill). X X      
PROP_FLR 3 Type of floor construction (e.g., concrete, plywood). X      
PROP_FRAME 3 Type of roof framing used (e.g., bar joist, reinforced concrete, Flexicore). X      
PROP_GAR 3 Type of garage or carport present (e.g., attached finished, enclosed carport, basement garage). X X   X X
PROP_HEAT 3 Type or method of heating (e.g., hot water, heat pump, baseboard, radiant). X      
PROP_PRKGSPACES 5 Total number of parking spaces or car capacity associated with the garage or parking type. X X      
PROP_PRKGTYPE 3 Type of parking found on the parcel. This is typically commercial or communal (e.g., Condos) in nature. X   X X
PROP_POOL 1 Pool indicator:
Y
A pool is present on the parcel
 X X   X X
PROP_POOLCD 3 Type of pool construction or pool amenities (e.g., kidney, gunite, vinyl, Jacuzzi, heated). X      
PROP_ROOFCOVER 3 Type of roof covering (e.g., clay tile, aluminum, shake). X X      
PROP_ROOFTYPE 3 Type of roof shape (e.g., gambrel, gable, flat, mansard). X X      
PROP_ENERGY 3 Type of electricity or energy use within the building (e.g., average wiring, underground wired, private source). X      
PROP_FUEL 3 Type of fuel used for heating of water and building (e.g., solar, gas, oil). X      
PROP_SEWER 3 Type of sewer system on the parcel:
0
None
999
Bypass
SPU
Public
SCE
Cesspool
SSE
Septic
SPR
Private
STR
Storm
SCO
Commercial
   X      
PROP_WATER 3 Type of water service on the parcel:
0
None
999
Bypass
WPU
Public
WSC
Spring/Creek
WWE
Well
WPR
Private
WCO
Commercial
WPW
Public well
WCI
Cistern
   X      
Assessor/Deed Information
PROP_HOMESTEAD 1 Homeowner/Homestead exemption indicator:
Y
Owner has qualified for a Homeowner/Homestead exemption
          
PROP_XMTVET 10 If the state has such an exemption and it has been granted then a flag: either Combat Vet or Veteran.          
PROP_XMT_DISABLED 10 If the state has such an exemption and it has been granted then a flag: either Disabled or Blind.          
PROP_TAXAMT 11 Total tax amount provided by the county or local taxing/assessment authority.          
PROP_TAXYR 4 The tax or assessment year for which the taxes were billed. (e.g., YYYY)          
PROP_DOCYR 4 The year a sales transaction document was recorded (e.g., YYYY)          
PROP_SALESDEEDCD 1 Type of deed used to record the sales transaction:
U
Foreclosure
Q
Quitclaim
X
Multi county/state or open-end-mtg
T
Deed of Trust
G
Deed
D
Release of Deed of Trust/Mtg
F
Final Judgement
J
Mechanic Liens
L
Lis Pendens
N
Notice of Default
R
Release/Recision
S
Loan Assignment
          
PROP_RECDATE 8 Date the sales transaction was recorded at the county (e.g., YYYYMMDD).          
PROP_SELLERNAME 60 Seller's name as it appears on the recorded sales transaction.   X      
PROP_SALEDATE 8 Date the sales transaction was legally completed (i.e., contact signed) (e.g., YYYYMMDD).   X      
PROP_SALEAMT 11 Price of the sale as depicted on the recorded sales transaction.   X      
PROP_SALECD 1 Indicates the financial consideration:
V
Verified
R
Lease
P
Sale price (partial)
C
Confirmed
N
Stamps on back/non-disclosed
F
Sale price (full)
E
Estimated
L
Committed
          
PROP_APNCD 1 Indicates multiple or split parcel sales:
D
Multi/detail parcel sale
M
Multiple parcel sale
X
Multi/split parcel sale
S
Split parcel sale
          
PROP_APNCNT 4 Number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number).          
PROP_ASMTYR 4 Year of last property assessment by the county (e.g., YYYY). X X X X X
PROP_SALESTRANSCD 2 Situations associated with the sale:
1
Resale
2
Refinance
3
Subdivision/new construction
4
Timeshare
6
Construction loan
7
Seller carryback
9
Nominal
D
Release of deed
S
Assignment of Deed of Trust
          
Prior Sale Information
PROP_RECDATE_PRIOR 8 Date the sales transaction was recorded at the county (e.g., YYYYMMDD).          
PROP_SALEDATE_PRIOR 8 Date the sales transaction was legally completed (i.e., contact signed) (e.g., YYYYMMDD).          
PROP_SALEAMT_PRIOR 11 Price of the sale as depicted on the recorded sales transaction.          
PROP_SALECD_PRIOR 1 Partial or full financial consideration:
F
Full
P
Partial
          
PROP_APNCD_PRIOR 1 Multiple or split parcel sales:
M
Multiple parcel sale
D
Multi/detail parcel sale
X
Multi/split parcel sale
S
Split parcel sale
          
PROP_DEEDCD_PRIOR 2 Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed).          
PROP_DOCYR_PRIOR 4 The year a sales transaction document was recorded (e.g., YYYY).          
PROP_DEEDTYPE_PRIOR 1 Type of deed used to record the prior sales transaction (e.g., Grant, Quit, Foreclosure).          
PROP_SALESTRANSCD_PRIOR 3 Situations associated with the sale:
1
Resale
2
Refinance
3
Subdivision/new construction
4
Timeshare
6
Construction loan
7
Seller carryback
9
Nominal
D
Release of deed
S
Assignment of Deed of Trust
          
Mortgage Information
PROP_MTGAMT_PRIOR 11 Amount associated with the mortgage of the prior sale.          
PROP_OWNERCD 3 Type of ownership in terms of: owners in common; joint.          
PROP_SELLCARRYBACK 1 Seller provided some financing and it was recorded; more per family financing do not record in any timely manner; also often noted more under 'first' or 'second' lender:
Y
Yes
A
Assumed
          
PROP_TITTLECOMPANY 60 Notes Title company          
PROP_LOANTOVAL 3 If provided on the note and recorded, loan-to-value ratio (e.g., 47,118,61,185)          
PROP_MTGAMT 11 Amount of loan          
PROP_MTGDATE 8 Date mortgage was initiated (e.g., YYYYMMDD).          
PROP_MTGLOANCD 5 Code associated with the mortgage type:
WRP
Wrap-around mortgage
VA
Veterans Affairs
FHA
Federal Housing Administration
CNV
Conventional
SBA
Small Business Administration
PP
Private party lender
CDA
Community Development Authority
CNS
Construction
LH
Lease Hold Mortgage
PMM
Purchase Money Mortgage
          
PROP_MTGDEEDCD 6 Type of deed used for recording.          
PROP_MTGTERM 5 Length of mortgage, i.e., 15 years, 30 years, etc.          
PROP_MTGDUEDATE 8 Date mortgage becomes due. (e.g., YYYYMMDD)          
PROP_MTGASSUMPTIONAMT 9 Amount of prior mortgage assumed and rolled, if any. (e.g., 65750, 130000, 162500, 50000)          
PROP_LENDERNAME 60 Name of lender.          
PROP_MTGREFICD 1 Indicates refinance of existing/prior mortgage:
Y
Yes
T
Trust
          
PROP_RMSEQUITYCD 1 Equity in property indicator:
Y
Equity in the property was acknowledged
          
PROP_MTGINTRATE 6 Rate associated with mortgage (4 decimal) Example: 47300 = 4.73%          
PROP_MTGINTRATETYPE 3 Type of rate:
FIX
Fixed
ADJ
Adjustable
VAR
Variable
BAL
Balloon
          
PROP_MTGAMT2 11 Amount of 2nd mortgage, if one exists.          
PROP_MTGDATE2 8 See PROP_MTGDATE description for 1st mortgage.          
PROP_MTGLOANCD2 5 See PROP_MTGLOANCD description for 1st mortgage.          
PROP_MTGDEEDCD2 6 See PROP_MTGDEEDCD description for 1st mortgage.          
PROP_MTGTERM2 5 See PROP_MTGTERM description for 1st mortgage          
PROP_MTGDUEDATE2 8 See PROP_MTGDUEDATE description for 1st mortgage          
PROP_MTGASSUMPTIONAMT2 9 See PROP_MTGASSUMPTIONAMT description for 1st mortgage.          
PROP_LENDERNAME2 60 See PROP_LENDERNAME description for 1st mortgage.          
PROP_MTGREFICD2 1 See PROP_MTGREFICD description for 1st mortgage.          
PROP_RMSEQUITYCD2 1 See PROP_RMSEQUITYCD description for1st mortgage.          
PROP_MTGINTRATE2 6 See PROP_MTGINTRATEd description for 1st mortgage.          
PROP_MTGINTRATETYPE2 3 See PROP_MTGINTRATETYPE description for 1st mortgage.          
PROP_MTGAMT3 11 Amount of 3rd mortgage, if one exists.          
PROP_MTGDATE3 8 See PROP_MTGDATE description for 1st mortgage.          
PROP_MTGLOANCD3 5 See PROP_MTGLOANCD description for 1st mortgage.          
PROP_MTGDEEDCD3 6 See PROP_MTGDEEDCD description for 1st mortgage.          
PROP_MTGTERM3 5 See dPROP_MTGTERM description for 1st mortgage          
PROP_MTGDUEDATE3 8 See PROP_MTGDUEDATE description for 1st mortgage.          
PROP_MTGASSUMPTIONAMT3 9 See PROP_MTGASSUMPTIONAMT description for 1st mortgage.          
PROP_LENDERNAME3 60 See PROP_LENDERNAME description for 1st mortgage.          
PROP_MTGREFICD3 1 See PROP_MTGREFICD description for 1st mortgage.          
PROP_RMSEQUITYCD3 1 See PROP_RMSEQUITYCD description for 1st mortgage.          
PROP_MTGINTRATE3 6 See PROP_MTGINTRATE description for 1st mortgage.          
PROP_MTGINTRATETYPE3 3 See PROP_MTGINTRATETYPE description for 1st mortgage.          
Parcel Information
PARCEL_APN 45 Some counties use different values to identify the parcel boundary and the property attributes. This Parcel APN value may be the same or a reformated version of the PROP_APN is also provided. X X X X X
DUPE_QTY 20 Number of records associated with the unique pkKey X X X X X
UNIQUE_FLAG 1
U
The pkKey is unique.
S
The record is the survivor record of a duplicate group, which is in the GeoEnrichment data and the duplicates file.
D
A duplicate record, which is only in the duplicates file.
 X X X X X
Parent topic: Data Layouts