Property Attributes Data
This section describes the output fields that are returned for each Property Attributes dataset. For more details and for highlighted field names, refer to the Excel® spreadsheet that is provided with your Property Attributes dataset download.
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.
Short names for field names are defined below.
- Basic = B*, Standard = S* and Ultimate = U*
Field Name | Short Name | Length | Description | B* | S* | U* |
---|---|---|---|---|---|---|
PbKey | PBKEY | Char (17) | Proprietary unique lookup key that ties to the Pitney Bowes Address Fabric dataset. | X | X | X |
LinkID | LinkID | varchar (50) | ID to Link to Property Attributes Historical Sales Dataset | X | X | X |
OwnerID | OWNID | varchar (50) | Property owner ID | X | X | X |
OwnerFirstName | FNAME | Varchar (50) | First name of the owner of the property | X | X | X |
OwnerMiddleName | MNAME | Varchar (50) | Middle name of the owner of the property | X | X | X |
OwnerLastName | LNAME | Varchar (50) | Last name of the owner of the property | X | X | X |
OwnerSuffix | SUFFIX | Varchar (10) | Jr., Sr., I, II, etc | X | X | X |
Owner2FirstName | FNAME2 | Varchar (50) | First name of the second owner of the property | X | X | X |
Owner2MiddleName | MNAME2 | Varchar (50) | Middle name of the second owner of the property | X | X | X |
Owner2LastName | LNAME2 | Varchar (50) | Last name of the second owner of the property | X | X | X |
Owner2Suffix | SUFFIX2 | Varchar (10) | Jr., Sr., I, II, etc | X | X | X |
BusinessName | BUSNAME | Varchar (255) | Name of the Business owner of the property | X | X | X |
PropOwnerType | RECTYPE | Varchar (1) | Defines whether a residence or business owns the property. R - Residential B - Business *NOTE: This does not represent if the property is residential or commercial | X | X | X |
OwnerPhone | PHONE | Varchar (10) | Phone number for the owner of the property | X | X | X |
Owner2Phone | PHONE2 | Varchar (10) | Phone number for the second owner of the property | X | X | X |
Property Situs Address Information | ||||||
PropAddressFull | ADDRESS | Varchar (64) | Full address for the physical location of the property | X | X | X |
PropHouseNumber | HOUSE | Varchar (10) | House Number | X | X | X |
PropStreetPreDir | PREDIR | Varchar (2) | Street Pre Directional: N, S, E, W, NE, etc | X | X | X |
PropStreetName | STREET | Varchar (28) | Street Name or Post Office (PO) Box name, or Rural Route (RR) # Box name, or Highway Contract (HC) # Box name | X | X | X |
PropStreetSuffix | STRTYPE | Varchar (4) | Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc | X | X | X |
PropStreetPostDir | POSTDIR | Varchar (2) | Street Post Direction: N, S, E, W, NE, etc | X | X | X |
PropUnitType | APTTYPE | Varchar (4) | Unit Designator: Apt, Unit, etc | X | X | X |
PropUnitNumber | APTNBR | Varchar (8) | Unit Number | X | X | X |
PropCity | CITY | Varchar (28) | City Name | X | X | X |
PropState | STATE | Varchar (2) | State Abbreviation | X | X | X |
PropZip | ZIP | Varchar (5) | Zip Code | X | X | X |
PropZip4 | Z4 | Varchar (4) | Zip+4 Code | X | X | X |
PropVacancy | VACANT | Varchar (1) | Vacant: Whether the physical address is determined to be Vacant by USPS. Y - Identified as Vacant N - Someone living at that address | X | X | |
PropCategory | PROP_CAT | Varchar (1) | A code to easily identify the property as Residential or
Commercial. R - Residential C - Commercial V - Vacant O - Other |
X | X | X |
Tax Bill Property Address Information | ||||||
TaxPropAddressFull | TAXADDRESS | Varchar (64) | Full Address for where the tax bill is sent | X | X | |
TaxPropHouseNumber | HOUSE2 | Varchar (10) | House Number | X | X | |
TaxPropStreetPreDir | PREDIR2 | Varchar (2) | Street PreDirectional: N, S, E, W, NE, etc | X | X | |
TaxPropStreetName | STREET2 | Varchar (28) | Street Name or PO Box name, or RR # Box name, or HC # Box name | X | X | |
TaxPropStreetSuffix | STRTYPE2 | Varchar (4) | Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc | X | X | |
TaxPropStreetPostDir | POSTDIR2 | Varchar (2) | Street Post Direction: N, S, E, W, NE, etc | X | X | |
TaxPropUnitType | APTTYPE2 | Varchar (4) | Unit Designator: Apt, Unit, etc | X | X | |
TaxPropUnitNumber | APTNBR2 | Varchar (8) | Unit Number | X | X | |
TaxPropCity | CITY2 | Varchar (28) | City Name | X | X | |
TaxPropState | STATE2 | Varchar (2) | State Abbreviation | X | X | |
TaxPropZip | ZIP2 | Varchar (5) | Zip Code | X | X | |
TaxPropZip4 | Z42 | Varchar (4) | Zip+4 Code | X | X | |
TaxPropVacancy | VACANT2 | Varchar (1) | Vacant: Whether the physical address is determined to be Vacant by USPS. Y - Identified as Vacant N - Someone living at that address | X | X | |
Property Location Information | ||||||
FIPSCode | FIPSCD | Varchar (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 |
CensusTract | PROP_CENSUSTRACT | Varchar (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) | X | ||
MuniName | PROP_MUNINAME | Varchar (30) | Municipality name of where property is located | X | ||
Township | PROP_TOWNSHIPCD | Varchar (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. (e.g., 7, 11S, 1N, 36S) | X | ||
Subdivision | PROP_SUBDIVISION | Varchar (30) | If the property is in a specific subdivision so noted on deed recordings; used for 'look ups' etc on advanced search within some counties | X | ||
ZoningCode | PROP_ZONING | Varchar (10) | The data contained in this field is based upon County and/or Local established Zoning Codes. (e.g., R, PD, R2, RM15) | X | ||
Range | PROP_RANGE | Varchar (3) | The "range" portion of geographical coordinates based on local
surveys. Ranges typically run east or west of pre-determined
"meridian" in six mile intervals. (e.g., 3W, 8, 89, 31E) Note: For
detailed code description refer to the Excel® spreadsheet
provided with your Property Attributes dataset
download.
|
X | ||
Section | PROP_SECTION | Varchar (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. (e.g., 27, 40, 16, 11) | X | ||
LandUseCode | PROP_LANDUSE | Integer | A Land Use code converted from various county Land Use codes to
aid in search and extract functions. (e.g., 112, 138, 100, 102).
Please see "LandUseCode" table for code descriptions and/or click on
the field name to view indivudual codes descriptions. Note: For
detailed code description refer to the Excel® spreadsheet
provided with your Property Attributes dataset
download.
|
X | X | X |
PropertyAPN | PROP_APN | Varchar (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 |
PropertyAPNSeqNumber | PROP_APNSEQNBR | Varchar (3) | Internal sequence number used to ensure "unique-ness" of the Assessor's Parcel Number (e.g., 10132021A seq 001) | X | X | X |
Additional Information | ||||||
OwnerIndicator | PROP_OWNEROCC | Varchar (1) | Absentee Owner Indicator 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 |
AddressIndicator | PROP_ADDRIND | Varchar (1) | Indicates whether the property was obtained directly from a county or local source: M - Mailing Address S - Local Source | X | X | |
CorporationCode | PROP_CORPIND | Varchar (1) | Code to indicate whether the property is owned by a corporation. A property can be owned by a corporation and still be a residential property.: Y - Yes N - No | X | X | |
ResidentialZipCode | PROP_RESCD | Varchar (1) | Code to indicate whether the property is located in a residential zipcode: Y - Yes N - No | X | X | |
LandUseCondensed | PROP_IND | Integer | A general code used to easily recognize specific property types
(e.g, Residential, Condominium, Commercial). Please see
"LandUseCondensed" table for code descriptions and/or click on the
field name to view individual codes descriptions. Note: For detailed
code description refer to the Excel® spreadsheet provided with
your Property Attributes dataset download.
|
X | X | |
MobileHome | PROP_MOBHOME | Varchar (1) | Code to indicate whether the property is a mobile home: Y - Yes N - No | X | X | |
BuildingCount | PROP_NRBBLD | Integer | Total number of buildings on the property | X | X | X |
BuildingStyle | PROP_STYLE | Varchar (3) | Type of building style (e.g., Colonial, Cape Code, Bungalow).
Please see "BuildingStyle" table for code descriptions and/or click
on the field name to view individual codes descriptions. Note: For
detailed code description refer to the Excel® spreadsheet
provided with your Property Attributes dataset
download.
|
X | X | X |
BuildingStoriesCode | PROP_STORIESCD | Varchar(3) | Type / number of stories (e.g., Split Foyer, Tri Level, 2 Story).
Please see "BuildingStoriesCode" table for code descriptions and/or
click on the field name to view individual codes
descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | X | X |
BuildingStoriesCount | PROP_STORIESNBR | Float | Number of stories associated with the building (e.g., 2, 1.5). | X | X | X |
BuildingUnitNumber | PROP_APTNBR | Varchar (10) | Number of units inside the building | X | X | |
BuildingQuality | PROP_QLTY | Varchar (3) | Type of construction quality of building: 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 | |
BuildingType | PROP_BLDGCD | Varchar (3) | The primary building type (e.g., Bowling Alley, Supermarket).
Please see "BuildingType" table for code descriptions and/or click
on the field name to view individual codes descriptions. Note: For
detailed code description refer to the Excel® spreadsheet
provided with your Property Attributes dataset
download.
|
X | X | |
BuildingImproveType | PROP_BLDGIMPCD | Varchar (3) | The primary improvement type (e.g., Grain Silo, Hanger, Marina).
Please see "BuildingImproveType" table for code descriptions and/or
click on the field name to view individual codes
descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | X | |
BuildingCondition | PROP_COND | Varchar (3) | This represents the physical condition of the building (e.g.,
Good, Fair, Under Construction). Please see "BuildingCondition"
table for code descriptions and/or click on the field name to view
individual codes descriptions. Note: For detailed code description
refer to the Excel® spreadsheet provided with your Property
Attributes dataset download.
|
X | X | |
BuildingConstructType | PROP_CNSTRTYPE | Varchar (3) | The primary method of construction (e.g., Steel / Glass, Concrete
Block, Log). Please see "BuildingConstructionType" table for code
descriptions and/or click on the field name to view individual codes
descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | X | X |
BuildingExternalWallsType | PROP_EXTNW | Varchar (3) | The type and/or finish of the exterior walls (e.g., Vinyl Siding,
Brick Veneer, Frame / Stone). Please see "BuildingExternalWallsType"
table for code descriptions and/or click on the field name to view
individual codes descriptions. Note: For detailed code description
refer to the Excel® spreadsheet provided with your Property
Attributes dataset download.
|
X | X | X |
ReplacementCost | PROP_REPLACECALC | Bigint | The approximate cost to insurers should the property be a total loss. Replacement cost is calculated from an algorithm created in-house at Pitney Bowes, based on construction cost data received from Craftsman Book Company. | X | X | |
TotalValueCalculation | PROP_VALCALC | Bigint | The total (e.g., Land + Improvement) Value closest to current market value used for assessment by county or local taxing authorities | X | X | |
TotalValueIndicator | PROP_VAL_CALCIND | Varchar (1) | Type of values used to seed the total value calculated field: A - Assessed M - Market P - Appraised T - Transitional | X | X | |
LandValueCalculation | PROP_LAND_VALCALC | Bigint | The "LAND" Value closest to current market value used for assessment by county or local taxing authorities | X | X | |
LandValueIndicator | PROP_LAND_VALCALC_IND | Varchar (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 | |
ImproveValueCalculation | PROP_IMP_VALCALC | Bigint | The "IMPROVEMENT" Value closest to current market value used for assessment by county or local taxing authorities | X | X | |
ImproveValueIndicator | PROP_IMP_VALCALC_IND | Varchar (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 | X | |
TotalAssessedValue | PROP_ASSED_VAL | Bigint | The Total Assessed Value of the property's Land & Improvement values as provided by the county or local taxing/assessment authority | X | X | X |
LandAssessedValue | PROP_ASSED_LANDVAL | Bigint | The Assessed Land Values as provided by the county or local taxing/assessment authority | X | X | X |
ImproveAssessedValue | PROP_ASSED_IMPVAL | Bigint | The Assessed Improvement Values as provided by the county or local taxing/assessment authority | X | X | X |
TotalMarketValue | PROP_MRKTVAL | Bigint | Total Market Value of the property's Land & Improvement values as provided by the county or local taxing/assessment authority | X | X | |
LandMarketValue | PROP_MRKT_LANDVAL | Bigint | Market Land Values as provided by the county or local taxing/assessment authority | X | X | |
ImproveMarketValue | PROP_MRKT_IMPVAL | Bigint | Market Improvement Values as provided by the county or local taxing/assessment authority | X | X | |
TotalAppraisedValue | PROP_APPRAISED_VAL | Bigint | The Total Appraised Value of the property's Land & Improvement values as provided by the county or local taxing/assessment authority | X | X | |
LandAppraisedValue | PROP_APPRAISED_LANDVAL | Bigint | The Appraised Land Values as provided by the county or local taxing/assessment authority | X | X | |
ImproveAppraisedValue | PROP_APPRAISED_IMPVAL | Bigint | The Appraised Improvement Values as provided by the county or local taxing/assessment authority | X | X | |
Property Attributes Information | ||||||
YearBuilt | PROP_YRBLD | Varchar (4) | Original Year Building Construction - YYYY | X | X | X |
EffectiveYearBuilt | PROP_EFFYRBLD | Varchar (4) | This is 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 | |
BuildingView | PROP_VIEW | Varchar (3) | View from building (e.g., Gulf, Mountains, Pool). Please see
"BuildingView" table for code descriptions and/or click on the field
name to view individual codes descriptions. Note: For detailed code
description refer to the Excel® spreadsheet provided with your
Property Attributes dataset download.
|
X | ||
LocationProCon | PROP_LCTN_INFL | Varchar (3) | Positive or negative aspects associated with the location of the
property (e.g., waterfront, flood plane, airport). Please see
"LocationProCon" table for code descriptions and/or click on the
field name to view individual codes descriptions. Note: For detailed
code description refer to the Excel® spreadsheet provided with
your Property Attributes dataset download.
|
X | ||
FrontFeet | PROP_FRONTFT | Integer | The linear feet across the front of the lot - facing the street | X | X | |
DepthFeet | PROP_DEPTHFT | Integer | The linear feet between the front and back of the lot | X | X | |
LandAcres | PROP_ACRES | Float | Total land mass in Acres. | X | ||
LandSqFt | PROP_LANDSQFT | Integer | Total land mass is Square Feet | X | X | X |
UniBuildingSqFt | PROP_UNVBLDSQFT | Integer | The Building Square Footage that can most accurately be used for assessments or comparables (e.g., Living, Adjusted, Gross) | X | X | X |
UniBuildingSqFtCode | PROP_BLDSQFTIND | Varchar (1) | The codes appearing in this field indicate the source used to populate the Universal Building Square Feet field: R - GROUND FLOOR LEVEL H - HEATED AREA M - MAIN OR BASE AREA B - BUILDING A - ADJUSTED L - LIVING G - GROSS | X | X | X |
BuildingSqFt | PROP_BLDSQFT | Integer | 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 | X | X | |
LivingSqFt | PROP_LIVINGSQFT | Integer | 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 | |
GroundFloorSqFt | PROP_GRDFLRSQFT | Integer | 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 | |
GrossSqFt | PROP_GROSSSQFT | Integer | Square footage for the entire building. Typically this represents all square feet under the roof | X | X | |
GrossSqFtAdjusted | PROP_ADJGROSSSQFT | Integer | 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 | |
BasementSqFt | PROP_BSMTSQFT | Integer | Total square footage associated with Basement portion of a building. This would include both finished and unfinished areas | X | X | |
ParkingSqFt | PROP_PRKGSQ FT | Integer | Total square footage of the primary garage or parking area (e.g., commercial). This includes both finished and unfinished areas | X | X | |
TotalRoomCount | PROP_RMS | Integer | Total number of rooms contained in the primary building | X | X | X |
BedroomCount | PROP_BEDRMS | Integer | Total number of bedrooms contained in the primary building | X | X | X |
BathsCalculated | PROP_BATHSCALC | Float | 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., 2, 3, 4) | X | X | X |
BathsCount | PROP_BATHS | Float | Total number of Bathrooms as provided by our data sources (e.g., 4, 2.5, 1.75). | X | X | X |
FullBathsCount | PROP_FULLBATHS | Integer | 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 | X | |
HalfBathsCount | PROP_HALFBATHS | Integer | 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 | X | |
1QtrBathsCount | PROP_1QTRBATHS | Integer | Total number of Quarter Baths (typically comprised only of a sink, as found in many laundry rooms) | X | X | |
3QtrBathsCount | PROP_3QTRBATHS | Integer | Total number of 3 Quarter Baths (typically comprised of a sink, toilet & shower stall) | X | X | |
BathsFixtureCount | PROP_BATHFIXS | Integer | The total number of bathroom fixtures (Typically a Full Bath would have 4 fixtures. 1 - sink, 1 - toilet, 1 - bathtub, 1 - shower head) | X | X | |
CoolType | PROP_AC | Varchar (3) | The type of air conditioning method used to cool the building
(e.g., Central, Wall Unit, Evaporative). Please see "CoolType" table
for code descriptions and/or click on the field name to view
individual codes descriptions. Note: For detailed code description
refer to the Excel® spreadsheet provided with your Property
Attributes dataset download.
|
X | X | |
BasementType | PROP_BSMTF | Varchar (3) | The type of basement found in the building (e.g., Finished, Half,
Crawl). Please see "BasementType" table for code descriptions and/or
click on the field name to view individual codes
descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | X | X |
Fireplace | PROP_FRPL | Varchar (1) | Y - Fireplace is located within the building | X | X | X |
FireplaceCount | PROP_FRPLNBR | Integer | This represent the number of fireplace openings located within the building | X | X | |
FireplaceType | PROP_FRPLTYPE | Varchar (3) | The type of fireplace (e.g., 2 Story / 3 Openings, 2 Story
Brick). Please see "FireplaceType" table for code descriptions
and/or click on the field name to view individual codes
descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | X | |
FoundationType | PROP_FND | Varchar (3) | The type of foundation (e.g., Continuous Footing, Pier, Mud
Sill). Please see "FoundationType" table for code descriptions
and/or click on the field name to view individual codes
descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | X | X |
FlooringType | PROP_FLR | Varchar (3) | The type of floor construction (e.g., Concrete, Plywood). Please
see "FlooringType" table for code descriptions and/or click on the
field name to view individual codes descriptions. Note: For detailed
code description refer to the Excel® spreadsheet provided with
your Property Attributes dataset download.
|
X | X | |
FramingType | PROP_FRAME | Varchar (3) | The type of roof framing used (e.g., Bar Joist, Reinforced
Concrete, Flexicore). Please see "FramingType" table for code
descriptions and/or click on the field name to view individual codes
descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | X | |
GarageType | PROP_GAR | Varchar (3) | Type of garage or carport present (e.g., Attached Finished,
Enclosed Carport, Basement Garage). Please see "GarageType" table
for code descriptions and/or click on the field name to view
individual codes descriptions. Note: For detailed code description
refer to the Excel® spreadsheet provided with your Property
Attributes dataset download.
|
X | X | X |
HeatType | PROP_HEAT | Varchar (3) | Type or method of heating (e.g., Hot Water, Heat Pump, Baseboard,
Radiant). Please see "HeatType" table for code descriptions and/or
click on the field name to view individual codes
descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | X | |
ParkingCapacity | PROP_PRKGSPACES | Integer | Total number of Parking Spaces or Car Capacity associated with the Garage or Parking Type | X | X | X |
ParkingType | PROP_PRKGTYPE | Varchar (3) | Type of parking found on the property. This is typically
commercial or communal (e.g., Condos) in nature. Please see
"ParkingType" table for code descriptions and/or click on the field
name to view individual codes descriptions. Note: For detailed code
description refer to the Excel® spreadsheet provided with your
Property Attributes dataset download.
|
X | X | |
Pool | PROP_POOL | Varchar (1) | Y - Pool is present on property | X | X | X |
PoolType | PROP_POOLCD | Varchar (3) | Type of pool, construction or pool amenities (e.g., Kidney,
Gunite, Vinyl, Jacuzzi, Heated). Please see "PoolType" table for
code descriptions and/or click on the field name to view individual
codes descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | X | |
RoofCover | PROP_ROOFCOVER | Integer | Type of roof covering (e.g., Clay Tile, Aluminum, Shake). Please
see "RoofCover" table for code descriptions and/or click on the
field name to view individual codes descriptions. Note: For detailed
code description refer to the Excel® spreadsheet provided with
your Property Attributes dataset download.
|
X | X | X |
RoofShape | PROP_ROOFTYPE | Varchar (3) | Type of roof shape (e.g., Gambrel, Gable, Flat, Mansard). Please
see "RoofShape" table for code descriptions and/or click on the
field name to view individual codes descriptions. Note: For detailed
code description refer to the Excel® spreadsheet provided with
your Property Attributes dataset download.
|
X | X | X |
EnergyType | PROP_ENERGY | Varchar (3) | Type of electricity or energy use within the building (e.g.,
Average Wiring, Underground Wired, Private Source). Please see
"EnergyType" table for code descriptions and/or click on the field
name to view individual codes descriptions. Note: For detailed code
description refer to the Excel® spreadsheet provided with your
Property Attributes dataset download.
|
X | X | |
FuelType | PROP_FUEL | Varchar (3) | Type of fuel used for heating of water and building (e.g., Solar,
Gas, Oil). Please see "FuelType" table for code descriptions and/or
click on the field name to view individual codes
descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | X | |
SewerType | PROP_SEWER | Varchar (3) | Type Of Sewer System On The Property: 0 - None 999 - Bypass SPU - Public SCE - Cesspool SSE - Septic SPR - Private STR - Storm SCO - Commercial | X | X | |
WaterType | PROP_WATER | Varchar (3) | Type Of Water Service On The Property: 0 - None 999 - Bypass WPU- Public WSC - Spring/Creek WWE - Well WPR - Private WCO - Commercial WPW - Public Well WCI - Cistern | X | X | |
RecordLastUpdate | PROP_LASTUPDATE | Date | Date on which the property was last updated | X | X | X |
Assessor/Deed Information | ||||||
HomesteadExemption | PROP_HOMESTEAD | Varchar (1) | Y - Owner qualified for a Homeowner/Homestead exemption | X | ||
VeteranExemption | PROP_XMTVET | Varchar (10) | If State has such an exemption and it has been granted then a flag is assigned: - Combat Vet - Veteran | X | ||
DisabledExemption | PROP_XMT_DISABLED | Varchar (10) | If State has such an exemption and it has been granted then a flag is assigned: - Disabled - Blind | X | ||
TaxBillAmount | PROP_TAXAMT | Decimal(11,2) | The Total Tax amount from the tax bill, provided by the county or local taxing/assessment authority. | X | ||
TaxBillYear | PROP_TAXYR | Varchar (4) | The tax or assessment year for which the taxes were billed - YYYY | X | ||
SaleDocumentYear | PROP_DOCYR | Varchar (4) | The year a sales transaction document was recorded (e.g., YYYY) | X | ||
SaleDeedType | PROP_SALESDEEDCD | Varchar (1) | The type of deed used to record the sales transaction: U - Foreclouse Q - Quit Claim X - Multi CNTY/ST 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 | X | ||
SaleTransactionDate | PROP_RECDATE | Date | The date the sales transaction was recorded at the county - YYYYMMDD | X | ||
SellerName | PROP_SELLERNAME | Varchar (60) | The seller's name as it appears on the recorded sales transaction | X | X | |
SaleDate | PROP_SALEDATE | Date | Date the sales transaction was legally completed - YYYYMMDD | X | X | |
SaleAmount | PROP_SALEAMT | Bigint | Price of the sale as depicted on the recorded sales transaction | X | X | |
SaleFinancialCode | PROP_SALECD | Varchar (1) | Financial Consideration Code: V - Verified R - Lease P - Sale Price (Partial) C - Confirmed N - Stamps on Back/Non-Disclosed F - Sale Price (Full)) E - Estimated L - Commited | X | ||
SaleParcelType | PROP_APNCD | Varchar (1) | Depicts multiple or split parcel sales: D - MULTI / DETAIL PARCEL SALE M - MULTIPLE PARCEL SALE X - MULTI / SPLIT PARCEL SALE S - SPLIT PARCEL SALE | X | ||
SaleParcelCount | PROP_APNCNT | Integer | Number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number) | X | ||
SaleLastAssessedYear | PROP_ASMTYR | Varchar (4) | Year of last assessment of property by the County (e.g., YYYY) | X | X | X |
SaleTransactionType | PROP_SALESTRANSCD | Varchar (2) | This identifies 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 | X | ||
Prior Sale Information | ||||||
PriorTransactionDate | PROP_RECDATE_PRIOR | Date | The date the sales transaction was recorded at the county - YYYYMMDD | X | ||
PriorCompletedDate | PROP_SALEDATE_PRIOR | Date | Date the sales transaction was legally completed - YYYYMMDD | X | ||
PriorAmount | PROP_SALEAMT_PRIOR | Bigint | Price of the sale as depicted on the recorded sales transaction | X | ||
PriorFinancialCode | PROP_SALECD_PRIOR | Varchar (1) | Financial Consideration Code: V - Verified R - Lease P - Sale Price (Partial) C - Confirmed N - Stamps on Back/Non-Disclosed F - Sale Price (Full)) E - Estimated L - Commited | X | ||
PriorParcelType | PROP_APNCD_PRIOR | Varchar (1) | Depicts multiple or split parcel sales: D - MULTI / DETAIL PARCEL SALE M - MULTIPLE PARCEL SALE X - MULTI / SPLIT PARCEL SALE S - SPLIT PARCEL SALE | X | ||
PriorDeedCode | PROP_DEEDCD_PRIOR | Varchar (2) | Type of deed used for recording (e.g., Agreement of Sale,
Assumption, Correction Deed). Please see "PriorSaleDeedCode" table
for code descriptions and/or click on the field name to view
individual codes descriptions. Note: For detailed code description
refer to the Excel® spreadsheet provided with your Property
Attributes dataset download.
|
X | ||
PriorDocumentYear | PROP_DOCYR_PRIOR | Varchar (4) | The year a sales transaction document was recorded (e.g., YYYY) | X | ||
PriorDeedType | PROP_DEEDTYPE_PRIOR | Varchar (1) | The type of deed used to record the prior sales transaction
(e.g., Grant, Quit, Foreclosure). Please see "PriorSaleDeedType"
table for code descriptions and/or click on the field name to view
individual codes descriptions. Note: For detailed code description
refer to the Excel® spreadsheet provided with your Property
Attributes dataset download.
|
X | ||
PriorTransactionType | PROP_SALESTRANSCD_PRIOR | Varchar (3) | This identifies 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 | X | ||
PriorMortgageAmount | PROP_MTGAMT_PRIOR | Bigint | Amount associated with the mortgage of the prior sale | X | ||
Mortgage Information | ||||||
OwnerType | PROP_OWNERCD | Varchar (3) | The type of ownership in terms of: owners in common; joint.
Please see "OwnerType" table for code descriptions and/or click on
the field name to view individual codes descriptions. Note: For
detailed code description refer to the Excel® spreadsheet
provided with your Property Attributes dataset
download.
|
X | ||
SellerCarryBack | PROP_SELLCARRYBACK | Varchar (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 | X | ||
MortgageTitleCompany | PROP_TITTLECOMPANY | Varchar (60) | Title Company | X | ||
MortgageLoanToValue | PROP_LOANTOVAL | Integer | If provided on the note and recorded, loan to value ratio (e.g., 47, 118, 61, 185) | X | ||
MortgageAmount | PROP_MTGAMT | Bigint | Amount of Mortgage Loan in USD Dollars$ | X | ||
MortgageDate | PROP_MTGDATE | Date | Date Mortgage was initiated - YYYYMMDD | X | ||
MortgageType | PROP_MTGLOANCD | Varchar (5) | 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 | X | ||
MortgageDeed | PROP_MTGDEEDCD | Varchar (6) | Deed used for recording. Please see "MortgageDeed" table for code
descriptions and/or click on the field name to view individual codes
descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | ||
MortgageTerm | PROP_MTGTERM | Integer | The length of time per the mortgage (e.g., 15 years, 30 years, etc) | X | ||
MortgageDueDate | PROP_MTGDUEDATE | Date | Date Mortgage becomes due - YYYYMMDD | X | ||
MortgageAssumeAmount | PROP_MTGASSUMPTIONAMT | Integer | Amount of prior mortgage that was assumed and rolled in. (e.g., 65750, 130000, 162500, 50000) | X | ||
MortgageLenderName | PROP_LENDERNAME | Varchar (60) | Name of Lender for the Mortgage | X | ||
MortgageRefinance | PROP_MTGREFICD | Varchar (1) | Was it a refinance of existing/prior mortgage: Y - Yes T - Trust | X | ||
MortgageEquity | PROP_RMSEQUITYCD | Varchar (1) | Y - If equity in property was acknowledged | X | ||
MortgageIntRate | PROP_MTGINTRATE | Float | Rate Associated with Mortgage | X | ||
MortgageIntRateType | PROP_MTGINTRATETYPE | Varchar (3) | Mortgage Rate Type: FIX - Fixed ADJ - Adjustable VAR - Variable BAL - Balloon | X | ||
MortgageAmount2 | PROP_MTGAMT2 | Bigint | Amount of 2nd mortgage | X | ||
MortgageDate2 | PROP_MTGDATE2 | Date | Date 2nd Mortgage was initiated - YYYYMMDD | X | ||
MortgageType2 | PROP_MTGLOANCD2 | Varchar (5) | Associated with the 2nd 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 | X | ||
MortgageDeed2 | PROP_MTGDEEDCD2 | Varchar (6) | 2nd Deed used for recording. Please see "MortgageDeed" table for
code descriptions and/or click on the field name to view individual
codes descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | ||
MortgageTerm2 | PROP_MTGTERM2 | Integer | The length of time per the 2nd mortgage (e.g., 15 years, 30 years, etc) | X | ||
MortgageDueDate2 | PROP_MTGDUEDATE2 | Date | Date 2nd Mortgage becomes due - YYYYMMDD | X | ||
MortgageAssumeAmt2 | PROP_MTGASSUMPTIONAMT2 | Integer | Amount of 2nd mortgage that was assumed and rolled in. (e.g., 65750, 130000, 162500, 50000) | X | ||
MortgageLenderName2 | PROP_LENDERNAME2 | Varchar (60) | Name of Lender 2 | X | ||
MortgageRefinance2 | PROP_MTGREFICD2 | Varchar (1) | Was it a refinance of existing/prior 2nd mortgage: Y - Yes T - Trust | X | ||
MortgageEquity2 | PROP_RMSEQUITYCD2 | Varchar (1) | Y - If 2nd equity in property was acknowledged | X | ||
MortgageIntRate2 | PROP_MTGINTRATE2 | Float | 2nd Rate Associated with Mortgage | X | ||
MortgageIntRateType2 | PROP_MTGINTRATETYPE2 | Varchar (3) | Mortgage Rate Type 2: FIX - Fixed ADJ - Adjustable VAR - Variable BAL - Balloon | X | ||
MortgageAmount3 | PROP_MTGAMT3 | Bigint | Amount of 3rd mortgage | X | ||
MortgageDate3 | PROP_MTGDATE3 | Date | Date 3rd Mortgage was initiated - YYYYMMDD | X | ||
MortgageType3 | PROP_MTGLOANCD3 | Varchar (5) | Associated with the 3rd 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 | X | ||
MortgageDeed3 | PROP_MTGDEEDCD3 | Varchar (6) | 3rd Deed used for recording. Please see "MortgageDeed3" table for
code descriptions and/or click on the field name to view individual
codes descriptions. Note: For detailed code description refer to the
Excel® spreadsheet provided with your Property Attributes
dataset download.
|
X | ||
MortgageTerm3 | PROP_MTGTERM3 | Integer | The length of time per the 3rd mortgage (e.g., 15 years, 30 years, etc) | X | ||
MortgageDueDate3 | PROP_MTGDUEDATE3 | Date | Date 3rd Mortgage becomes due - YYYYMMDD | X | ||
MortgageAssumeAmt3 | PROP_MTGASSUMPTIONAMT3 | Integer | Amount of 3rd mortgage was assumed and rolled in. (e.g., 65750, 130000, 162500, 50000) | X | ||
MortgageLenderName3 | PROP_LENDERNAME3 | Varchar (60) | Name of Lender 3 | X | ||
MortgageRefinance3 | PROP_MTGREFICD3 | Varchar (1) | Was it a refinance of existing/prior 3rd mortgage: Y - Yes T - Trust | X | ||
MortgageEquity3 | PROP_RMSEQUITYCD3 | Varchar (1) | Y - If 3rd equity in property was acknowledged | X | ||
MortgageIntRate3 | PROP_MTGINTRATE3 | Float | 3rd Rate Associated with Mortgage | X | ||
MortgageIntRateType3 | PROP_MTGINTRATETYPE3 | Varchar (3) | Mortgage Rate Type 3: FIX - Fixed ADJ - Adjustable VAR - Variable BAL - Balloon | X | ||
Parcel Information | ||||||
ParcelAPN | PARCEL_APN | Varchar (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 reformatted version of the PROP_APN which is also provided. | X | X | X |
DupeQTY | DUPE_QTY | Integer | Number of records associated with the unique pbKey | X | X | X |
DupeUniqueFlag | UNIQUE_FLAG | Char (1) | U – Indicates that the pbKey is Unique S – Indicates that the records is the Survivor record of a duplicate group, and is present in the GEM data and the duplicates file D – Indicates a Duplicate record, and is present only in the duplicates file. | X | X | X |