Total Property Profiles

Spreadsheet Version

# Field Number
Field Name Field Name
Length Length
Description Description
1
ID
50
Internal Infutor Inventory Number
2
PID
50
Persistent ID
3
PID2
50
Persistent ID 2
4
FNAME
50
First Name
5
MNAME
50
Middle Name
6
LNAME
50
Surname
7
SUFFIX
10
Jr., Sr., I, II, II, etc
8
FNAME2
50
First Name 2
9
MNAME2
50
Middle Name 2
10
LNAME2
50
Surname 2
11
SUFFIX2
10
Jr., Sr., I, II, II, etc
12
BUSNAME
255
Business Name
13
RECTYPE
1
Record Type: R – Residential, B – Business
14
PHONE
10
Phone
15
PHONE2
10
Phone 2

Property Address

# Field Number
Field Name Field Name
Length Length
Description Description
16
HOUSE
10
House Number
17
PREDIR
2
Street Pre Directional: N, S, E, W, NE, etc
18
STREET
28
Street Name or PO Box name, or RR # Box name, or HC # Box name
19
STRTYPE
4
Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
20
POSTDIR
2
Street Post Direction: N, S, E, W, NE, etc
21
APTTYPE
4
Unit Designator
22
APTNBR
8
Unit Number
23
CITY
28
City Name
24
STATE
2
State Abbreviation
25
ZIP
5
Zip Code
26
Z4
4
Zip+4 Code
27
DPC
3
Delivery Point Code with Check Digit
28
CRTE
4
Carrier Route Code
29
CNTYCD
3
County Code
30
Z4TYPE
1
Zip+4 Type: F – Firm or company address, G – General delivery address, H – High-rise or business complex, P – PO Box address, R – Rural route address, S – Street or residential address
31
DPV
1
Delivery Point Validation Code:
Y – Address DPV confirmed for both primary and (if present) secondary numbers, D – Address DPV confirmed for the primary number only, and secondary number information was missing, S – Address DPV confirmed for the primary number only, and secondary number information was present but unconfirmed, N – Both Primary and (if present) Secondary number information failed to DPV Confirm
32
VACANT
1
“Vacant: Y – Physical Address Identified by USPS as Vacant, N – Someone living at that address”

Alternate Address

# Field Number
Field Name Field Name
Length Length
Description Description
33
HOUSE2
10
House Number 2
34
PREDIR2
2
Street PreDirectional: N, S, E, W, NE, etc
35
STREET2
28
Street Name or PO Box name, or RR # Box name, or HC # Box name
36
STRTYPE2
4
Physical Street Suffix: ST, AVE, PL, BLVD, PKWY, etc
37
POSTDIR2
2
Street Post Direction: N, S, E, W, NE, etc
38
APTTYPE2
4
Unit Designator 2
39
APTNBR2
8
Unit Number 2
40
CITY2
28
City Name 2
41
STATE2
2
State Abbreviation
42
ZIP2
5
Zip Code 2
43
Z42
4
Zip+4 Code 2
44
DPC2
3
Delivery Point Code with Check Digit 2
45
CRTE2
4
Carrier Route Code 2
46
CNTYCD2
3
County Code 2
47
Z4TYPE2
1
“Zip+4 Type 2: F – Firm or company address, G – General delivery address, H – High-rise or business complex, P – PO Box address, R – Rural route address, S – Street or residential address”
48
DPV2
1
“Delivery Point Validation Code 2: Y – Address DPV confirmed for both primary and (if present) secondary numbers, D – Address DPV confirmed for the primary number only, and secondary number information was missing, S – Address DPV confirmed for the primary number only, and secondary number information was present but unconfirmed, N – Both Primary and (if present) Secondary number information failed to DPV Confirm”
49
VACANT2
1
“Vacant: Y – Physical Address Identified by USPS as Vacant, N – Someone living at that address”

Property Location Information

# Field Number
Field Name Field Name
Length Length
Description Description
50
PROP_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”
51
PROP_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)
52
PROP_MUNINAME
30
Municipality name of where parcel is located
53
PROP_TOWNSHIPCD
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)
54
PROP_SUBDIVISION
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
55
PROP_ZONING
10
The data contained in this field is based upon County and/or Local established Zoning Codes. (e.g., R, PD, R2, RM15)
56
PROP_RANGE
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)
57
PROP_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. (e.g., 27, 40, 16, 11)
58
PROP_LATITUDE
11
Geo Positioning Latitude
59
PROP_LONGITUDE
11
Geo Positioning Longitude
60
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).
61
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)
62
PROP_APNSEQNBR
3
Internal sequence number used to ensure “unique-ness” of the Assessor’s Parcel Number (e.g., 10132021A seq 001)

Additional Information

# Field Number
Field Name Field Name
Length Length
Description Description
63
PROP_OWNEROCC
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)”
64
PROP_ADDRIND
1
“Indicates whether the property was obtained directly from a county or local source: M – Mailing Address, S – Local Source”
65
PROP_CORPIND
1
Y – Name of the property owner has been recognized as a corporation or business
66
PROP_RESCD
1
“Code to indicate whether the property is residential based on individual zipcodes and values: Y – Yes, N – No”
67
PROP_IND
3
A general code used to easily recognize specific property types (e.g, Residential, Condominium, Commercial).
68
PROP_MOBHOME
1
Y – Mobile Home present on the Parcel
69
PROP_NRBBLD
3
Total number of buildings on the parcel
70
PROP_STYLE
3
Type of building style (e.g., Colonial, Cape Code, Bungalow).
71
PROP_STORIESCD
3
Type / number of stories (e.g., Split Foyer, Tri Level, 2 Story).
72
PROP_STORIESNBR
5
Number of stories associated with the building (e.g., 2, 1.5)
73
PROP_APTNBR
10
Unit Number
74
PROP_QLTY
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”
75
PROP_BLDGCD
3
The primary building type (e.g., Bowling Alley, Supermarket).
76
PROP_BLDGIMPCD
3
The primary improvement type (e.g., Grain Silo, Hanger, Marina).
77
PROP_COND
3
This represents the physical condition of the building (e.g., Good, Fair, Under Construction).
78
PROP_CNSTRTYPE
3
The primary method of construction (e.g., Steel / Glass, Concrete Block, Log).
79
PROP_EXTNW
10
The type and/or finish of the exterior walls (e.g., Vinyl Siding, Brick Veneer, Frame / Stone).
80
PROP_VALCALC
11
The total (e.g., Land + Improvement) Value closest to current market value used for assessment by county or local taxing authorities
81
PROP_VAL_CALCIND
1
“Type of values used to seed the total value calculated field: A – Assessed, M – Market, P – Appraised, T – Transitional”
82
PROP_LAND_VALCALC
11
The “LAND” Value closest to current market value used for assessment by county or local taxing authorities
83
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”
84
PROP_IMP_VALCALC
11
The “IMPROVEMENT” Value closest to current market value used for assessment by county or local taxing authorities
85
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”
86
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
87
PROP_ASSED_LANDVAL
11
The Assessed Land Values as provided by the county or local taxing/assessment authority
88
PROP_ASSED_IMPVAL
11
The Assessed Improvement Values as provided by the county or local taxing/assessment authority
89
PROP_MRKTVAL
11
Total Market Value of the Parcel’s Land & Improvement values as provided by the county or local taxing/assessment authority
90
PROP_MRKT_LANDVAL
11
Market Land Values as provided by the county or local taxing/assessment authority
91
PROP_MRKT_IMPVAL
11
Market Improvement Values as provided by the county or local taxing/assessment authority
92
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
93
PROP_APPRAISED_LANDVAL
11
The Appraised Land Values as provided by the county or local taxing/assessment authority
94
PROP_APPRAISED_IMPVAL
11
The Appraised Improvement Values as provided by the county or local taxing/assessment authority

Property Attributes Information

# Field Number
Field Name Field Name
Length Length
Description Description
95
PROP_YRBLD
4
Original Year Building Construction – YYYY
96
PROP_EFFYRBLD
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)
97
PROP_VIEW
3
View from building (e.g., Gulf, Mountains, Pool).
98
PROP_LCTN_INFL
3
Positive or negative aspects associated with the location of the parcel (e.g., waterfront, flood plane, airport).
99
PROP_FRONTFT
7
The linear feet across the front of the lot – facing the street
100
PROP_DEPTHFT
7
The linear feet between the front and back of the lot
101
PROP_ACRES
13
Total land mass in Acres. (4 decimal points)Example: 13000 = 1.3 Acres
102
PROP_LANDSQFT
9
Total land mass is Square Feet
103
PROP_UNVBLDSQFT
9
The Building Square Footage that can most accurately be used for assessments or comparables (e.g., Living, Adjusted, Gross)
104
PROP_BLDSQFTIND
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
105
PROP_BLDSQFT
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
106
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
107
PROP_GRDFLRSQFT
7
PROP_GRDFLRSQFT
108
PROP_GROSSSQFT
7
Square footage for the entire building. Typically this represents all square feet under the roof
109
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
110
PROP_BSMTSQFT
7
Total square footage associated with Basement portion of a building. This would include both finished and unfinished areas
111
PROP_PRKGSQFT
7
Total square footage of the primary garage or parking area (e.g., commercial). This includes both finished and unfinished areas
112
PROP_RMS
5
Total number of rooms contained in the primary building
113
PROP_BEDRMS
5
Total number of bedrooms contained in the primary building
114
PROP_BATHSCALC
5
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)
115
PROP_BATHS
5
Total number of Bathrooms as provided by our data sources (e.g., 4.00, 2.50, 1.75)
116
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
117
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
118
PROP_1QTRBATHS
5
Total number of Quarter Baths (typically comprised only of a sink, as found in many laundry rooms)
119
PROP_3QTRBATHS
5
Total number of 3 Quarter Baths (typically comprised of a sink, toilet & shower stall)
95
PROP_YRBLD
4
Original Year Building Construction – YYYY
120
PROP_BATHFIXS
5
The total number of bathroom fixtures (Typically a Full Bath would have 4 fixtures. 1 – sink, 1 – toilet, 1 – bathtub, 1 – shower head)
121
PROP_AC
3
The type of air conditioning method used to cool the building (e.g., Central, Wall Unit, Evaporative).
122
PROP_BSMTF
3
The type of basement found in the building (e.g., Finished, Half, Crawl).
123
PROP_FRPL
1
Y – Fireplace is located within the building
124
PROP_FRPLNBR
3
This represent the number of fireplace openings located within the building, indicator between 1 to 10
125
PROP_FRPLTYPE
3
The type of fireplace (e.g., 2 Story / 3 Openings, 2 Story Brick).
126
PROP_FND
3
The type of foundation (e.g., Continuous Footing, Pier, Mud Sill).
127
PROP_FLR
3
The type of floor construction (e.g., Concrete, Plywood).
128
PROP_FRAME
3
The type of roof framing used (e.g., Bar Joist, Reinforced Concrete, Flexicore).
129
PROP_GAR
3
Type of garage or carport present (e.g., Attached Finished, Enclosed Carport, Basement Garage).
130
PROP_HEAT
3
Type or method of heating (e.g., Hot Water, Heat Pump, Baseboard, Radiant).
131
PROP_PRKGSPACES
5
Total number of Parking Spaces or Car Capacity associated with the Garage or Parking Type
132
PROP_PRKGTYPE
3
Type of parking found on the parcel. This is typically commercial or communal (e.g., Condos) in nature.
133
PROP_POOL
1
Y – Pool Present in Parcel
134
PROP_POOLCD
3
Type of pool, construction or pool amenities (e.g., Kidney, Gunite, Vinyl, Jacuzzi, Heated).
135
PROP_ROOFCOVER
3
Type of roof covering (e.g., Clay Tile, Aluminum, Shake).
136
PROP_ROOFTYPE
3
Type of roof shape (e.g., Gambrel, Gable, Flat, Mansard).
137
PROP_ENERGY
3
Type of electricity or energy use within the building (e.g., Average Wiring, Underground Wired, Private Source).
138
PROP_FUEL
3
Type of fuel used for heating of water and building (e.g., Solar, Gas, Oil).
139
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”
140
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”

Assessor/Deed Information

# Field Number
Field Name Field Name
Length Length
Description Description
141
PROP_HOMESTEAD
1
Y – Owner qualified for a Homeowner/Homestead exemption
142
PROP_XMTVET
10
If State has such an exemption and it has been granted then a flag: Combat Vet, Veteran
143
PROP_XMT_DISABLED
10
“If State has such an exemption and it has been granted then a flag: Disabled, Blind”
144
PROP_TAXAMT
11
The Total Tax amount provided by the county or local taxing/assessment authority
145
PROP_TAXYR
4
The tax or assessment year for which the taxes were billed – YYYY
146
PROP_DOCYR
4
The year a sales transaction document was recorded (e.g., YYYY)
147
PROP_SALESDEEDCD
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”
148
PROP_RECDATE
8
The date the sales transaction was recorded at the county – YYYYMMDD
149
PROP_SELLERNAME
60
The seller’s name as it appears on the recorded sales transaction
150
PROP_SALEDATE
8
Date the sales transaction was legally completed -YYYYMMDD
151
PROP_SALEAMT
11
Price of the sale as depicted on the recorded sales transaction
152
PROP_SALECD
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
153
PROP_APNCD
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
154
PROP_APNCNT
4
Number of parcels associated with the sale (e.g., 14 parcels recorded on the same document number)
155
PROP_ASMTYR
4
Year of last assessment of property by the County (e.g., YYYY)
156
PROP_SALESTRANSCD
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

Prior Sale Information

# Field Number
Field Name Field Name
Length Length
Description Description
157
PROP_RECDATE_PRIOR
8
The date the sales transaction was recorded at the county – YYYYMMDD
158
PROP_SALEDATE_PRIOR
8
Date the sales transaction was legally completed – YYYYMMDD
159
PROP_SALEAMT_PRIOR
11
Price of the sale as depicted on the recorded sales transaction
160
PROP_SALECD_PRIOR
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
161
PROP_APNCD_PRIOR
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
162
PROP_DEEDCD_PRIOR
2
Type of deed used for recording (e.g., Agreement of Sale, Assumption, Correction Deed).
163
PROP_DOCYR_PRIOR
4
The year a sales transaction document was recorded (e.g., YYYY)
164
PROP_DEEDTYPE_PRIOR
1
The type of deed used to record the prior sales transaction (e.g., Grant, Quit, Foreclosure).
165
PROP_SALESTRANSCD_PRIOR
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”
166
PROP_MTGAMT_PRIOR
11
Amount associated with the mortgage of the prior sale

Mortgage Information

# Field Number
Field Name Field Name
Length Length
Description Description
167
INTERNAL
255
Internal Use
168
PROP_OWNERCD
3
The type of ownership in terms of: owners in common; joint.
169
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
170
PROP_TITLECOMPANY
60
Title Company
171
PROP_LOANTOVAL
3
If provided on the note and recorded, loan to value ratio (e.g., 47,118,61,185)
172
PROP_MTGAMT
11
Amount of Loan
173
PROP_MTGDATE
8
Date Mortgage was initiated – YYYYMMDD
174
PROP_MTGLOANCD
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
175
PROP_MTGDEEDCD
6
Deed used for recording.
176
PROP_MTGTERM
5
The length of time per the mortgage (e.g., 15 years, 30 years, etc)
177
PROP_MTGDUEDATE
8
Date Mortgage becomes due – YYYYMMDD
178
PROP_MTGASSUMPTIONAMT
9
Amount of prior mortgage was assumed and rolled. (e.g., 65750, 130000, 162500, 50000)
179
PROP_LENDERNAME
60
Name of Lender
180
PROP_MTGREFICD
1
Was it a refinance of existing/prior mortgage: Y – Yes, T – Trust
181
PROP_RMSEQUITYCD
1
Y – If equity in property was acknowledged
182
PROP_MTGINTRATE
6
Rate Associated with Mortgage (4 decimal) Example: 47300 – 4.73%
183
PROP_MTGINTRATETYPEE
3
Mortgage Rate Type: FIX – Fixed, ADJ – Adjustable, VAR – Variable, BAL – Balloon
184
PROP_MTGAMT2
11
Amount of 2nd mortgage
185
PROP_MTGDATE2
8
Date 2nd Mortgage was initiated – YYYYMMDD
186
PROP_MTGLOANCD2
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
187
PROP_MTGDEEDCD2
6
2nd Deed used for recording.
188
PROP_MTGTERM2
5
The length of time per the 2nd mortgage (e.g., 15 years, 30 years, etc)
189
PROP_MTGDUEDATE2
8
Date 2nd Mortgage becomes due – YYYYMMDD
190
PROP_MTGASSUMPTIONAMT2
9
Amount of 2nd mortgage was assumed and rolled. (e.g., 65750, 130000, 162500, 50000)
191
PROP_LENDERNAME2
60
Name of Lender 2
192
PROP_MTGREFICD2
1
“Was it a refinance of existing/prior 2nd mortgage: Y – Yes, T – Trust”
193
PROP_RMSEQUITYCD2
1
Y – If 2nd equity in property was acknowledged
194
PROP_MTGINTRATE2
6
“2nd Rate Associated with Mortgage (4 decimal)
Example: 47300 – 4.73%”
195
PROP_MTGINTRATETYPE2
3
Mortgage Rate Type 2: FIX – Fixed, ADJ – Adjustable, VAR – Variable, BAL – Balloon
196
PROP_MTGAMT3
11
Amount of 3rd mortgage
197
PROP_MTGDATE3
8
Date 3rd Mortgage was initiated – YYYYMMDD
198
PROP_MTGLOANCD3
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, MM – Purchase Money Mortgage”
199
PROP_MTGDEEDCD3
6
3rd Deed used for recording.
200
PROP_MTGTERM3
5
The length of time per the 3rd mortgage (e.g., 15 years, 30 years, etc)
201
PROP_MTGDUEDATE3
8
Date 3rd Mortgage becomes due – YYYYMMDD
202
PROP_MTGASSUMPTIONAMT3
9
Amount of 3rd mortgage was assumed and rolled. (e.g., 65750, 130000, 162500, 50000)
203
PROP_LENDERNAME3
60
Name of Lender 3
204
PROP_MTGREFICD3
1
Was it a refinance of existing/prior 3rd mortgage: Y – Yes, T – Trust
205
PROP_RMSEQUITYCD3
1
Y – If 3rd equity in property was acknowledged
206
PROP_MTGINTRATE3
6
“3rd Rate Associated with Mortgage (4 decimal)
Example: 47300 – 4.73%”
207
PROP_MTGINTRATETYPE3
3
Mortgage Rate Type 3: FIX – Fixed, ADJ – Adjustable, VAR – Variable, BAL – Balloon
208
PROP_INPUT_ADDRESS
64
Original Input Address
209
PROP_INPUT_CITY
28
Original Input City Name
210
PROP_INPUT_STATE
2
Original Input State
211
PROP_INPUT_ZIP
5
Original Input Zip
212
ADDRID
50
Address ID – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
213
ADDRID2
50
Address ID2 – “Infutor has synced our addresses to Placekey. Please contact Infutor Sales if you are interested in learning more.”
214
HHID
50
Household ID
215
HHID2
50
Household ID2
216
ODATE
8
Last Seen Date – YYYYMMDD
217
INTERNAL2
255
Internal Use
218
INTERNAL3
255
Internal Use
219
INTERNAL4
255
Internal Use

The information in this document may not be altered, changed, or recreated without written consent of Infutor Data Solutions Inc. – Infutor Confidential and Proprietary