Data Layout

Introduction

Property and Mortgage data for Insight and Analytics. Add Property and Mortgage Data to Your Records for Data-Driven Insight and Analytics. Our custom property data solutions give you fresh, accurate real estate and property data on more than 140 million U.S. properties including parcel and building information, calculated value, deed information and history, and more. Along with comprehensive information on the property, you also get detailed information on the homeowner and all other properties that owner has ever owned.

When you add more than 400 fields of detailed property data to your in-house records, you’ll gain the competitive edge and capitalize on market opportunities. The Property API is ideal for lenders, real estate professionals, investors and insurance agents.

Sample File

Click here to download the sample file.

Layout and Definitions

Grouping	Column Name	Type	Definition
	PropertySuite	varchar(50)	Suite
	MailingSuite	varchar(50)	Suite
Primary Owner	Owner1FullName	varchar(255)	Owner 1 Full Name
	Owner1FirstName	varchar(166)	Owner 1 First Name
	Owner1MiddleName	varchar(166)	Owner 1 Middle Name
	Owner1LastName	varchar(166)	Owner 1 Last Name
	Owner1NameSuffix	varchar(50)	Owner 1 Name Suffix
	Owner2FullName	varchar(255)	Owner 2 Full Name
	Owner2FirstName	varchar(166)	Owner 2 First Name
	Owner2MiddleName	varchar(166)	Owner 2 Middle Name
	Owner2LastName	varchar(166)	Owner 2 Last Name
	Owner2NameSuffix	varchar(50)	Owner 2 Name Suffix
PropertyAddress	PropertyMelissaAddressKey	bigint	10-digit unique key assigned to each address.
	PropertyBaseMelissaAddressKey	bigint	Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment
	PropertyAddressLine	varchar(150)	Address line
	PropertyCity	varchar(100)	City
	PropertyState	varchar(2)	State
	PropertyZIPCode	varchar(5)	ZIP Code
	PropertyPlus4	varchar(4)	Plus4
	PropertyDeliveryPoint	varchar(2)	A specific location where mail is delivered to an individual or entity. It is a precise point of delivery for a particular address.
	PropertyAddressKey	varchar(11)	Address key is a combination of a location’s ZIPCode + Plus4 + DeliveryPoint
	PropertyAddressStreetNumber	varchar(50)	Address street number. Ex. ‘6450’
	PropertyAddressDirectionPrefix	varchar(10)	Address directional prefix. Ex. ‘e’
	PropertyAddressStreetName	varchar(100)	Street name. Ex. ‘Side’
	PropertyAddressStreetSuffix	varchar(10)	Suffix of address. Ex. ‘Dr’
	PropertyAddressDirectionSuffix	varchar(10)	Address directional suffix. Ex. ‘Ne’
	PropertyAddressSuiteName	varchar(50)	Suite. Ex. ‘Apt’
	PropertyAddressSuiteNumber	varchar(50)	Suite number. Ex. ‘Q’
	PropertyRBDI	varchar(1)	Business/residential indication
	PropertyCarrierRoute	varchar(4)	The carrier route for the location address as assigned by the USPS.
	PropertyFIPSCode	varchar(5)	The FIPSCode indicates the location of the address at both the state and county level.
	PropertyAddressType	varchar(1)	Address type
	PropertyResultCodes	varchar(100)	Melissa result codes
PropertyGeo	PropertyCensusKey	varchar(16)	Census key is a 15 or 16-character key combination of the state FIPS code + county FIPS code + tract number + block number + block suffix. The Census key was created by the US Government to correctly identify, classify, and pull statistical data from areas across the United States.
	PropertyLatitude	decimal(18,6)	The latitude in decimal degrees using the WGS84 datum for the address
	PropertyLongitude	decimal(18,6)	The longitude in decimal degrees using the WGS84 datum for the address
Parcel	UDParcelNumberRaw	varchar(45)	Undecorated Assessor’s Parcel Number or Parcel Identification Number.
	ParcelNumberRaw	varchar(45)	Assessor’s Parcel Number or Parcel Identification Number.
	ParcelNumberYearAdded	int	The year that the current Parcel Number was created by the Assessor.
	ParcelNumberAlternate	varchar(60)	In addition to the primary parcel number, an alternate property identifier.
	ParcelAccountNumber	varchar(30)	When provided in the assessment files, an arbitrary parcel identifier usually assigned by the County Treasurer for tax purposes.
Tax	TaxYearAssessed	varchar(4)	Relates to the current lien date for which the values contained in (Assessed Land Value, Assessed Improvement Value and Total Assessed Value) were established. If a fiscal year (Mar’95 - Feb’96), this is the beginning year (i.e. 1995).
	TaxAssessedValueTotal	int	The total current assessed value of both Land and Improvements (before exemptions, if any) as reported on the current county tax/assessment roll. Whole dollars only.
	TaxAssessedValueImprovements	int	The current assessed value of the improvements only (before exemptions) as reported on the current county tax/assessment roll. Whenever separate fields are provided for additional improved values, this will be the total of all improvement values.
	TaxAssessedValueLand	int	The current assessed value of the land only (before exemptions) as reported on the current county tax/assessment roll.
	TaxMarketValueYear	varchar(4)	The year the market values were established. Normally, this is a constant year for all records with a market value > zero, although there are cases where the county file contains the year each parcel was physically appraised and in such cases we move the Market Value year specific to each parcel resulting in several different values per county.
	TaxMarketValueTotal	int	When available from the county, the Total Market Value as determined by the Assessor. See also Total Assessed Value
	TaxMarketValueImprovements	int	When available from the county, the Market Improvement Value as determined by the Assessor. See also Assessed Improvement Value
	TaxMarketValueLand	int	When available from the county, the Market Land Value as determined by the Assessor. See also Assessed Land Value
	TaxFiscalYear	varchar(4)	This is the year in which the amount shown in Tax Amount was levied.
	TaxRateArea	varchar(18)	Represents separate tax jurisdictions within the county as provided on the county tax/assessment roll.
	TaxBilledAmount	decimal(11,2)	This field contains the amount of tax on the property expressed in dollars and cents
	TaxDelinquentYear	varchar(4)	This is the year in which the property tax became delinquent (unpaid).
	PropertyEstimatedValue	int	Property estimated value
CurrentDeed	Mortgage1Amount	int	Mortgage (purchase money) recorded concurrently with the conveying instrument.
	Mortgage1InterestRate	decimal(10,2)	When available, initial rate as given on the trust deed or rider.
	Mortgage1InterestRateType	varchar(1)	When available will indicate the type of interest rate terms for the concurrent TD
	Mortgage1LenderInfoSellerCarryBackInd	bit	Indicating if a lender is a seller
	Mortgage1LenderNameFullStandardized	varchar(40)	Name of the beneficiary to the first trust deed (mortgage).
	Mortgage1RecordingDate	date	The official date of the document recordation.
	Mortgage1Type	varchar(3)	Indicates the type of loan, if able to determine from the recorded document. See Code Description table.
	Mortgage2Amount	int	Loan amount of second trust deed concurrent (subject to) to the original (1st) loan.
	Mortgage2InterestRate	varchar(1)	When available, initial rate as given on the trust deed or rider.
	Mortgage2InterestRateType	varchar(1)	When available will indicate the type of interest rate terms for the concurrent TD
	Mortgage2LenderInfoSellerCarryBackInd	varchar(1)	Indicator for lender type
	Mortgage2LenderNameFullStandardized	varchar(1)	Name of the beneficiary to the first trust deed (mortgage).
	Mortgage2RecordingDate	date	The official date of the document recordation.
	Mortgage2Type	varchar(1)	Indicates the type of loan, if able to determine from the recorded document. See Code Description table.
SaleInfo	AssessorLastSaleAmount	int	Whole dollars only without commas (,) and NO Cents
	AssessorLastSaleDate	date	Recording Date of the latest sale in the transaction history.
	VestingTypeCode	varchar(3)	When available, either identifies how the Assessee took title (vesting) OR describes the type of entity (ID) based on conversion. See Code Description table.
	TrustDescription	varchar(50)	Identifies whether the ownership type is a trust or not.
	CompanyInd	varchar(1)	Indicating the property is company owned
PropertyUseInfo	YearBuilt	varchar(4)	Year the primary structure on the property was built
	EffectiveYearBuilt	varchar(4)	The date that reflects the condition of an improvement. It is the same or later than Year Built.
	PropertyUseStandardized	varchar(3)	Land Use code standardized for all counties. See Separate Land Use Table.
ExteriorAmendities	AreaBuilding	int	The building area of the primary structure on the property.When multiple building areas are given for a structure, the preferred data for this field is Living Area for residential properties and Total Area for all others.
	AreaLotAcres	decimal(18,7)	This field contains the total area measurement of the land in acres. If the lot size is provided by the county assessor in square feet, this field will contain a conversion of square feet to acres.
	AreaLotSF	int	This field contains the total area measurement of the land in square feet. If the lot size is provided by the county assessor in acres, this field will be show the conversion to square feet.
	Pool	varchar(3)	Indicates if a pool exists on the property and any additional information about the pool.
	Foundation	varchar(3)	Indicates the type of foundation for the primary structure on the property.
	Construction	varchar(2)	Indicates the material used in the construction of the framework for the primary structure on the property.
	RoofConstruction	varchar(3)	Indicates the primary roof framing structure (A-Frame, Gable, Mansard, etc.).
	ContentOverheadDoorInd	bit	Indicates the existence of an Overhead Door.
	ViewDescription	varchar(3)	Identifies features or characteristics of a location which might influence the value or desirability of a parcel, such as waterfront or traffic patterns. The field can contain up to two codes.
	PorchCode	varchar(3)	This indicates if a proch is present, and if so, potentially what type of porch.
	PorchArea	int	The total square footage of the porch(s) on the property .
	PatioArea	int	The square footage of the patio(s) for all structures on a property.
	DeckInd	bit	Code indicating the presence of a deck on the property. It, alternatively, can also indicate if the deck is covered.
	DeckArea	int	If a deck is present, this details the size of the deck in square feet.
InteriorAmendities	RoomsBasementArea	int	The total area of the basement, in square feet.
	InteriorStructure	varchar(3)	This field contains a code reflecting the composition of the interior walls
	BathCount	decimal(5,2)	Physical count of all bathrooms (including 1/2 baths). See Code Description table. Input Format: 99v99 (implied decimal)
	BedroomsCount	int	Actual count of bedrooms (with closet). Residential only.
	UnitsCount	int	Number of Units reported on the Assessment Roll. Primarily used for reporting of apartment buildings.
	FireplaceInd	bit	Indicating the presence of fireplace
	ContentStormShutterInd	bit	Indicates the presence of Storm Shutters on the main structure.
	HVACCoolingDetail	varchar(3)	Indicates the method or system used to provide cooling.
	HVACHeatingDetail	varchar(3)	Indicates the method or system used to provide heat.
Foreclosure	ForeclosureLenderNameFullStandardized	varchar(40)	Name of the beneficiary to the first trust deed (mortgage).
	ForeclosureLenderAddressLine	varchar(100)	Lender Address
	ForeclosureLenderAddressCity	varchar(50)	Lender Address City
	ForeclosureLenderAddressState	varchar(2)	Lender Address State
	ForeclosureLenderAddressZIPCode	varchar(10)	Lender Address ZIP Code
	ForeclosureLenderAddressStreetNumber	varchar(25)	Address street number. Ex. ‘6450’
	ForeclosureLenderAddressDirectionPrefix	varchar(10)	Address directional prefix. Ex. ‘e’
	ForeclosureLenderAddressStreetName	varchar(100)	Street name. Ex. ‘Side’
	ForeclosureLenderAddressStreetSuffix	varchar(10)	Suffix of address. Ex. ‘Dr’
	ForeclosureLenderAddressDirectionSuffix	varchar(25)	Address directional suffix. Ex. ‘Ne’
	ForeclosureLenderAddressSuiteNumber	varchar(25)	Suite number. Ex. ‘Q’
	ForeclosureLenderPhone	varchar(15)	Lender Phone Number
	ForeclosureLenderPhoneDNCInd	bit	Do not call Flag for Foreclosure_LenderPhone
	ForeclosureInstrumentNumber	varchar(20)	Sequential number assigned to documents at the time of recording for identification and to establish the order of recordation as listed on the county/tax assessment roll.
	ForeclosureRecordingDate	date	Recording Date for most recent sale as listed on the county tax/assessment roll, if available. The date the property sold to the current ownership. Format provides four positions for the year: YYYYMMDD
	ForeclosureRecordedAuctionOpeningBid	varchar(11)	The minimum bid amount as reported on the Notice of Sale or reflects the total amount due on the loan.
	ForeclosureAuctionDate	date	The scheduled Auction Date as reported on the Notice of Sale.
	ForeclosureAuctionTime	varchar(5)	The scheduled Auction Time as reported on the Notice of Sale.
	ForeclosureAuctionAddress	varchar(60)	The Street Address where the auction is scheduled to take place, usually reported on the Notice of Sale
	ForeclosureAuctionCity	varchar(40)	The City where the auction is scheduled to take place as reported on the Notice of Sale
	ForeclosureServicerAddress	varchar(60)	Full Street Address, City, State, ZIP Code and Plus4
	ForeclosureServicerPhoneNumber	varchar(25)	Foreclosure Servicer Phone Number
	ForeclosureServicerPhoneDNCInd	bit	Do not call Flat for Foreclosure Servicer Phone Number
	ForeclosureTrusteeReferenceNumber	varchar(15)	Number assigned by the Trustee for the purpose of tracking the foreclosure for the given property.
	ForeclosureTrusteeName	varchar(40)	Trustee First Name & Middle Name. Note: In Colorado, the Trustee fields will be blank since Colorado uses a Public Trustee
	ForeclosureTrusteeAddress	varchar(60)	Trustee Full Street Address , City, State, Zip Code, Plus4
	ForeclosureTrusteeAddressCity	varchar(30)	Trustee City
	ForeclosureTrusteeAddressState	varchar(2)	Trustee State
	ForeclosureTrusteeAddressZIPCode	varchar(5)	Trustee ZIP Code
	ForeclosureTrusteePhone	varchar(12)	Trustee Phone Number
	ForeclosureTrusteePhoneDNCInd	bit	Do not call Flag for Foreclosure_TrusteePhone
	ForeclosureJudgmentAmount	int	Whole dollars. Unpaid principal amount of the loan as stated on the foreclosure document.
	ForeclosureBorrowerNameOwner	varchar(40)	#1 - Trustor/Borrower First Name & Middle
	ForeclosureOriginalLoanAmount	int	Loan amount of the original loan in default. Whole dollars only.
	ForeclosureRecordType	varchar(3)	Unique 2 position document type field that identifies the foreclosure record type. Refer to Foreclosure Doc Type by State tab for complete list.
	ForeclosureDefaultAmount	int	Amount that is past due on the loan. First priority is to key the Total Delinquency Amount, if this is not available, then enter the Installment Payment Amount.
	ForeclosureRecordLastUpdated	date	The official date of recordation for the foreclosure document.
MailingAddress	MailingMelissaAddressKey	bigint	10-digit unique key assigned to each address.
	MailingBaseMelissaAddressKey	bigint	Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment
	MailingAddressLine	varchar(150)	Address line
	MailigCity	varchar(100)	Mailing city
	MailingState	varchar(2)	State
	MailingZIPCode	varchar(5)	ZIP Code
	MailingPlus4	varchar(4)	Plus4
	MailingDeliveryPoint	varchar(2)	A specific location where mail is delivered to an individual or entity. It is a precise point of delivery for a particular address.
	MailingResultCodes	varchar(100)	Melissa result codes
	MailingAddressStreetNumber	varchar(50)	Address street number. Ex. ‘6450’
	MailingAddressDirectionPrefix	varchar(20)	Address directional prefix. Ex. ‘e’
	MailingAddressStreetName	varchar(100)	Street name. Ex. ‘Side’
	MailingAddressStreetSuffix	varchar(20)	Suffix of address. Ex. ‘Dr’
	MailingAddressDirectionSuffix	varchar(20)	Address directional suffix. Ex. ‘Ne’
	MailingAddressSuiteName	varchar(50)	Suite. Ex. ‘Apt’
	MailingAddressSuiteNumber	varchar(50)	Suite number. Ex. ‘Q’
	MailingRBDI	varchar(1)	Business/residential indication
	MailingCarrierRoute	varchar(4)	The carrier route for the location address assigned by the USPS.
	MailingFIPSCode	varchar(5)	The FIPSCode indicates the location of the address at both the state and county level.
	MailingAddressType	varchar(1)	Address type
MailingAddressGeo	MailingCensusKey	varchar(16)	Census key is a 15 or 16-character key combination of the state FIPS code + county FIPS code + tract number + block number + block suffix. The Census key was created by the US Government to correctly identify, classify, and pull statistical data from areas across the United States.
	PlaceCode	varchar(5)	Place Codes, Place as defined by the US Census Bureau. Supplemental geographical definition provided to assist with data analysis.
Phone	FullPhoneNumber	varchar(10)	Full phone number
	FullPhoneNumber_DNCInd	bit	Do not call Flag for Phone
	CellPhoneNumber	varchar(10)	Cell phone number
Emaill	CellPhoneNumber_DNCInd	bit	Do not call Flag for Cell Phone
	Email	varchar(450)	Email
	EmailResultLevel	int	EmailResultLevel

Code and Definitions

Column Name	Code	Definition
Mortgage1InterestRateType	1	Adjustable Rate
	0	Unknown
	2	Fixed Rate
PropertyRBDI	B	Business
	P	P.O. Box
	R	Residential
	U	Unknown
PropertyAddressType	A	Alias
	F	Firm or Company Address
	G	General Delivery Address
	H	High Rise or Business Complex
	P	P.O. Box Address
	R	Rural Route Address
	S	Street or Residential Address
	U	Unique
	Z	Unique
Mortgage1Type	126	Stand Alone First
	128	Stand Alone Second
	123	Arm (Adjustable Rate Mortgage)
	0	Unknown
	101	USDA - US Department of Agriculture Loan
	124	Closed End Mortgage
	133	Small Business Association
	121	Assumption
	3	Building or Construction
	134	Cash
	130	Second Mortgage To Cover Down Payment
	6	Line of Credit
	8	FHA
	122	Balloon
	102	Farmers Home Administration
	135	Negative Amortization
	131	Land Contract (Arrangement Of Sale)
	132	Loan Modification
	10	Conventional
	103	Commercial
	127	Stand Alone Refinance
	125	Seller Take-Back
	16	Veterans Administration Loan
	105	Reverse Mortgage
Mortgage2InterestRateType	1	Adjustable Rate
	0	Unknown
	2	Fixed Rate
Mortgage2Type	126	Stand Alone First
	128	Stand Alone Second
	123	Arm (Adjustable Rate Mortgage)
	0	Unknown
	101	USDA - US Department of Agriculture Loan
	124	Closed End Mortgage
	133	Small Business Association
	121	Assumption
	3	Building or Construction
	134	Cash
	130	Second Mortgage To Cover Down Payment
	6	Line of Credit
	8	FHA
	122	Balloon
	102	Farmers Home Administration
	135	Negative Amortization
	131	Land Contract (Arrangement Of Sale)
	132	Loan Modification
	10	Conventional
	103	Commercial
	127	Stand Alone Refinance
	125	Seller Take-Back
	16	Veterans Administration Loan
	105	Reverse Mortgage
VestingTypeCode	174	Also Known As (a/k/a)
	103	Company
	149	Community Property
	227	Contract Owner
	175	Doing Business As (dba)
	216	Domestic Partner
	218	Et Al (and Others) - Vendor Data Only
	150	Estate
	219	Et Ux (and Wife) - Vendor Data Only
	151	Executor
	178	Formerly Known As (f/k/a)
	220	Family Living Trust
	221	Family Trust
	222	Family Revocable Trust
	179	Government
	223	Her Husband
	109	Husband And Wife
	204	Irrevocable Living Trust
	203	Irrevocable Trust
	153	Joint Tenant/joint Tenant W/ Right Of Survivorship
	205	Joint Tenants
	154	Joint Venture
	156	Life Estate
	182	Life Tenant (holds A Life Estate Interest Only)
	159	Living Trust
	183	Minor, Ward Or Client (represented By Trustee)
	206	Married Man As His Sole And Separate Property
	207	Married Woman As Her Sole & Separate Property
	208	Partnership
	189	Revocable Living Trust
	164	Right Of Survivorship
	165	Revocable Trust
	125	Single Man
	167	Sole Owner
	127	Single Woman
	169	Tenants In Common
	209	Transfer Of Death
	171	Tenant By Entirety
	210	Tenant
	211	Trustee/conservator
	129	Trustee
	215	Tax Payer
	195	Widow Or Widower
TrustDescription		Not Available
	Name is a Trust	Name is a Trust
CompanyInd		Not Available
	N	N
	Y	Y
PropertyUseStandardized	315	Miscellaneous (General)
	246	Pipeline Or Right-of-way
	248	Rail (Right-Of-Way & Track)
	249	Road (Right-Of-Way)
	255	Utilities (Right-Of-Way Only)
	252	Sub-surface Rights (Mineral)
	253	Surface Rights (Grazing, Timber, Coal, Etc.)
	438	Leasehold Rights (Misc.)
	431	Possessory Interest (Misc.)
	456	Petroleum & Gas Wells (Misc.)
	435	Water Rights (Misc.)
	251	Right-of-way (Not Rail, Road Or Utility)
	465	Easement (Misc.)
	440	Homestead (Misc.)
	407	Common Area (Misc.)
	250	Royalty Interest
	257	Working Interest
	463	Parcels With Improvements, Use Not Specified
	411	Personal Property (General)
	441	Vehicles (General)
	420	Motor Vehicles (Cars, Trucks, Etc.)
	460	Recreational Vehicles / Travel Trailers
	432	Watercraft (Ships, Boats, Pwcs, Etc.)
	415	Aircraft
	434	Rolling Stock (Railroad)
	427	Spacecraft
	444	Misc Vehicles Not Otherwise Classed (Antiques, Etc.)
	445	Business Personal Property (General)
	455	Equipment / Supplies
	419	Inventory
	425	Goods In Transit
	466	Livestock (Animals, Fish, Birds, Etc.)
	413	Crops (In Ground)
	446	Crops (Harvested)
	439	Misc. Business Personal Property Not Otherwise Classed
	414	Structures (General)
	429	Structures On Leased Land
	408	Temporary Structures
	422	Misc Structures Not Otherwise Classed (Billboards, Etc.)
	437	Intangible Personal Property
	436	Misc Personal Property Not Otherwise Classed
	181	Single Family Residential
	385	Single Family Residential
	386	Townhouse
	364	Cluster Home
	366	Condominium
	367	Cooperative
	373	Mobile Home
	382	Row House
	118	Agricultural/rural (General)
	377	Planned Unit Development (PUD)
	365	Common Area (Residential)
	387	Timeshare
	384	Seasonal, Cabin, Vacation Residence
	363	Bungalow (Residential)
	390	Zero Lot Line (Residential)
	375	Miscellaneous (Residential)
	371	Manufactured, Modular, Pre-fabricated Homes
	376	Patio Home
	452	Garden Home
	416	Landominium
	423	Barndominium
	447	Tiny House
	381	Residential Income (General/Multi-Family)
369	Duplex (2 Units, Any Combination)
388	Triplex (3 Units, Any Combination)
378	Quadplex (4 Units, Any Combination)
361	Apartment House (5+ Units)
359	Apartment House (100+ Units)
357	Garden Apt, Court Apt (5+ Units)
358	High-rise Apartments
362	Boarding/rooming House, Apt Hotel
162	Mobile Home Park, Trailer Park
372	Multi-family Dwellings (Generic, Any Combination)
370	Fraternity House, Sorority House
360	Apartments (Generic)
368	Dormitory, Group Quarters (Residential)
379	Condominium Development (Association Assessment)
421	Condominium Building (Residential)
461	Cooperative Building (Residential)
418	Residential Parking Garage
448	Residential Storage Space
135	Commercial (General)
178	Retail Stores (Personal Services, Photography, Travel)
143	Department Store (Multi-Story)
140	Store/office (Mixed Use)
141	Department Store (Apparel, Household Goods, Furniture)
151	Grocery, Supermarket
179	Regional: Shopping Center, Mall (w/Anchor)
183	Community: Shopping Center, Mini-mall
167	Neighborhood: Shopping Center, Strip Center, Enterprise Zone
182	Shopping Center Common Area (Parking Etc)
192	Veterinary, Animal Hospital
148	Restaurant
146	Drive-thru Restaurant, Fast Food
189	Take-out Restaurant (Food Preparation)
128	Bakery
129	Bar, Tavern
158	Liquor Store
124	Convenience Store (7-11)
137	Convenience Store (w/Fuel Pump)
186	Service Station (Full Service)
185	Service Station w/Convenience Store (Food Mart)
190	Truck Stop (Fuel And Diner)
127	Vehicle Sales, Vehicle Rentals (Auto/Truck/RV/Boat/etc)
126	Auto Repair, Garage
193	Car Wash
147	Dry Cleaner
191	Service Shop (TV, Radio, Electric, Plumbing)
168	Nursery, Greenhouse, Florist (Retail, Wholesale)
194	Wholesale Outlet, Discount Store (Franchise)
173	Printer - Retail (Pip, Qwikcopy, etc.)
229	Mini-warehouse, Storage
175	Day Care, Pre-School (Commercial)
163	Motel
155	Hotel
172	Parking Garage, Parking Structure
174	Parking Lot
133	Cemetery, Funeral Home, Mortuary (Commercial)
132	Casino
154	Hotel-Resort
153	Hotel/motel
180	Gas Station
130	Commercial Building, Mail Order, Show Room (Non-Auto), Warehouse
171	Commercial Office/residential (Mixed Use)
125	Appliance Store (Bix Box Appliance)
156	Kennel
157	Laundromat (Self-Service)
166	Nightclub (Cocktail Lounge)
149	Farm Supply & Equipment (Commercial)
144	Garden Center, Home Improvement (Do-It-Yourself)
138	Commercial Condominium (Not Offices)
145	Drug Store, Pharmacy
131	Bed & Breakfast
464	Barber/Hair Salon
412	Pet Boarding & Grooming
449	Roadside Market
458	Car Wash - Automated
433	Car Wash - Self-Serve
459	Cannabis Dispensary
136	Commercial Office (General)
177	Professional Building (Legal, Insurance, Real Estate, Business)
176	Professional Building (Multi-Story)
169	Office Building
170	Office Building (Multi-Story)
142	Dental Building
160	Medical Building
150	Financial Building
139	Condominium Offices
184	Skyscraper/high-rise (Commercial Offices)
161	Mixed Use (Commercial/Industrial)
134	Common Area (Commercial, Not Shopping Center)
159	Mobile Commercial Units
334	Recreational/Entertainment (General)
332	Recreational Center
326	Public Swimming Pool
311	Marina, Boat Slips, Yacht Club, Boat Landing
264	Bowling Alley
259	Arcades (Amusement)
343	Skating Rink, Ice Skating, Roller Skating
270	Clubs, Lodges, Professional Associations
316	Museum, Library, Art Gallery (Recreational)
267	Country Club
346	Stadium
260	Arena, Convention Center
261	Auditorium
290	Driving Range (Golf)
350	Race Track (Auto, Dog, Horse)
296	Gym, Health Spa
279	Dance Hall
337	Riding Stable, Trails
273	Campground, RV Park
285	Fairgrounds
348	Theater (Movie)
281	Drive-in Theater
327	Amusement Park, Tourist Attraction
323	Piers, Wharf (Recreation)
287	Fish Camps, Game Club Target Shooting
262	Outdoor Recreation: Beach, Mountain, Desert
263	Pool Hall, Billiard Parlor
322	Park, Playground, Picnic Area
293	Golf Course
331	Racquet Court, Tennis Court
355	Zoo
292	Go-carts, Miniature Gold, Water Slides
410	Sports Complex
212	Industrial (General)
220	Manufacturing (Light)
215	Light Industrial (10% Improved Office Space; Machine Shop)
238	Warehouse, Storage
236	Storage Yard, Open Storage (Light Equipment, Material)
208	Food Packing, Packing Plant (Fruit, Vegetable, Meat, Dairy)
195	Assembly (Light Industrial)
206	Food Processing
232	Recycling (Metal, Paper, Glass)
272	Communications
201	Condominiums (Industrial)
231	R&d Facility, Laboratory, Research Facility, Cosmetics, Pharmaceutical
213	Industrial Park
224	Multi-tenant Industrial Building
219	Marine Facility/board Repairs (Small Craft, Sailboat)
218	Lumber & Wood Product Mfg (Including Furniture)
225	Paper Product Mfg & Related Products
227	Printing & Publishing (Light Industrial)
216	Industrial Loft Building, Loft Building
198	Construction/contracting Services (Industrial)
200	Common Area (Industrial)
210	Heavy Industrial (General)
291	Transportation (General)
280	Distribution Warehouse (Regional)
222	Mining, Mineral, Quarries
235	Storage Yard (Junk, Auto Wrecking, Salvage)
203	Distillery, Brewery, Bottling
226	Refinery, Petroleum Products
221	Mill (Feed, Grain, Paper, Lumber, Textile, Pulp)
205	Factory (Apparel, Textile, Leather, Medium Mfg)
228	Processing Plant (Minerals, Cement, Rock, Gravel, Glass, Clay)
217	Lumberyard, Building Materials
233	Shipyard - Built Or Repaired (Seagoing Vessels)
234	Slaughter House, Stockyard
240	Waste Disposal, Sewage (Processing, Disposal, Storage, Treatment)
230	Quarries (Sand, Gravel, Rock)
211	Heavy Manufacturing
214	Labor Camps (Industrial)
239	Winery
199	Chemical
207	Foundry, Industrial Plant (Metal, Rubber, Plastic)
197	Cannery
196	Bulk Storage, Tanks (Gasoline, Fuel, Etc)
209	Grain Elevator
204	Dump Site
202	Cold Storage
237	Sugar Refinery
258	Airport & Related
330	Railroad & Related
289	Freeways, State Hwys
338	Roads, Streets, Bridges
265	Bus Terminal
347	Telegraph, Telephone
340	Radio Or TV Station
351	Truck Terminal (Motor Freight)
276	Cable TV Station
300	Harbor & Marine Transportation
313	Microwave
266	Commercial Auto Transportation/Storage
324	Pollution Control
451	Cellular
105	Farm (Irrigated Or Dry)
114	Ranch
117	Range Land (Grazing)
103	Farm, Crops
110	Orchard (Fruit, Nut)
121	Vineyard
113	Poultry Farm (Chicken, Turkey, Fish, Bees, Rabbits)
101	Dairy Farm
120	Timberland, Forest, Trees
123	Wildlife (Refuge)
102	Desert Or Barren Land
112	Pasture
109	Miscellaneous Structures - Ranch, Farm Fixtures
111	Orchards, Groves
104	Feedlots
108	Livestock, Animals
106	Horticulture, Ornamental (Agricultural)
122	Well Site (Agricultural)
119	Truck Crops
115	Reservoir, Water Supply
107	Irrigation, Flood Control
317	Natural Resources
116	Rural Improved / Non-residential
450	Cannabis Grow Facility
389	Vacant Land
401	Residential - Vacant Land
393	Vacant Commercial
395	Industrial - Vacant Land
399	Private Preserve, Open Space - Vacant Land
396	Institutional - Vacant Land
394	Government - Vacant Land
398	Multi-family - Vacant Land
392	Agricultural (Unimproved) - Vacant Land
404	Waste Land, Marsh, Swamp, Submerged - Vacant Land
400	Recreational - Vacant Land
406	Water Area (Lakes, River, Shore) - Vacant Land
403	Unusable Land (Remnant, Steep, Etc.)
391	Abandoned Site, Contaminated Site
402	Under Construction
453	Vacant Land - Destroyed/Uninhabitable Improvement
462	Vacant Land - Unspecified Improvement
409	Vacant Land - Exempt
345	Special Purpose
333	Regulating Districts & Assessments; Tax Abatement
335	Redevelopment Agency Or Zone
268	Centrally Assessed
284	Exempt (Full Or Partial)
309	Indian Lands
310	Institutional (General)
336	Religious, Church, Worship (Synagogue, Temple, Parsonage)
328	Parochial School, Private School
274	College, University, Vocational School - Private
152	Hospital - Private
312	Medical Clinic
339	Homes (Retired, Handicap, Rest, Convalescent, Nursing)
320	Children’s Home, Orphanage
282	Cemetery (Exempt)
275	Crematorium, Mortuary (Exempt)
269	Charitable Organization, Fraternal
318	Recreational Non-taxable (Camps, Boy Scouts)
353	Private Utility (Electric, Water, Gas, Etc.)
294	Governmental / Public Use (General)
314	Military (Office, Base, Post, Port, Reserve, Weapon Range, Test Sites)
288	Forest (Park, Reserve, Recreation, Conservation)
342	Public School (Administration, Campus, Dorms, Instruction)
352	Colleges, University - Public
325	Post Office
298	Cultural, Historical (Monuments, Homes, Museums, Other)
295	Govt. Administrative Office (Federal, State, Local, Court House)
283	Emergency (Police, Fire, Rescue, Shelters, Animal Shelter)
356	Other Exempt Property
277	City, Municipal, Town, Village Owned (Exempt)
278	County Owned (Exempt)
344	State Owned (Exempt)
286	Federal Property (Exempt)
321	Public Health Care Facility (Exempt)
271	Community Center (Exempt)
329	Public Utility (Electric, Water, Gas, Etc.)
354	Welfare, Social Service, Low Income Housing (Exempt)
319	Correctional Facility, Jails, Prisons, Insane Asylum
302	Hospital - Public
304	Historical - Private (General)
306	Historical Residence
307	Historical Retail
308	Historical Warehouse
301	Historical Office
299	Historical Transient Lodging (Hotel, Motel)
305	Historical Recreation, Entertainment
303	Historical Park, Site, Misc.
297	Historical District
Pool	110	Above-ground Pool
	502	Pool w/Hot Tub/Spa
	101	Public/Municipal/Commercial
	610	Pool (Unspecified), Enclosed
	121	In-ground Vinyl Pool
	401	Pool (Unspecified), Heated
	130	Indoor Pool
	402	Pool, Solar Heated
	999	Type Unspecified
	904	Spa/Hot Tub (only)
Foundation	Null	Null
	501	Raised (Unspecified)
	999	Type Not Specified
	922	Masonry (Unspecified)
	921	Stone (Unspecified)
	924	Brick (Unspecified)
	923	Block (Unspecified)
	300	Pile
	400	Pier/Post & Beam
	930	Retaining Wall
	100	Mat/Raft Foundation (Slab)
	200	FOOTING
	920	Wood (Unspecified)
Construction	Null	Null
	31	Brick
	23	Concrete
	28	Concrete Blocks
	50	Arched/Dome
	2	Frame
	8	Heavy Frame
	7	Light Frame
	42	Log
	43	Manufactured
	1	Type Not Specified
	25	Masonry/Concrete Masonry Units (CMUs)
	19	Metal Frame
	20	Steel Frame
	38	Stone
	46	Tilt-Up Concrete
	10	Wood
	99	Mixed
RoofConstruction	Null	Null
	251	Gable
	313	Bowstring Truss
	329	Reinforced Concrete
	345	Geodesic/Dome
	312	Steel Frm/truss
	197	Flat
	253	Gable/Hip
	258	Hip
	283	Cathedral/Clerestory
	289	Gambrel
	265	Mansard
	320	Prestress Concrete
	311	Rigid Frm Bar Jt
	274	Shed
	282	Sawtooth
	318	Wood Truss
ViewDescription	Null	Null
	A	Freeway Proximity
	B	Waterfront-Beach (Ocean, River, or Lake)
	C	Contamination Site
	D	Cul-de-sac
	E	Corner
	VPR	Poor
	VAV	Average
	H	Historical
	I	School Proximity
	VGC	Golf Course
	0	None
	VLA	Lake
	VMN	Mountain
	VCA	Canal
	VOC	Ocean
	P	Proximity To Airport
	VGP	Greenbelt/Park
	R	Proximity To Railroad
	S	Major Street/Thoroughfare
	T	High Traffic Area
	VRR	River
		None
	Z	Flood Plain/Flood Zone
PorchCode	Null	Null
	PC0	Covered Porch
	PE0	Enclosed Porch
	P0Y	Glass Porch
	PO0	Open Porch
InteriorStructure	Null	Null
	410	Brick
	430	Concrete
	402	Block (Unspecified)
	750	Glass
	101	Finished/Painted
	201	Wallboard/Drywall
	102	Custom/Decorative
	401	Masonry (Unspecified)
	350	Log
	210	Cement Board
	104	Composition
	199	Other
	701	Plaster
	110	Paneling (Unspecified)
	420	Stone
	601	Metal
	190	Unfinished
	760	Vinyl Panel/Coating
	301	Wood (Unspecified)
	320	Plywood
HVACCoolingDetail	Null	Null
	136	Evaporative Cooler
	137	Other
	122	Refrigeration AC
	119	Fan Cooling AC
	139	Chilled Wate
HVACHeatingDetail	Null	Null
	103	Baseboard
	113	Electric
	108	Central
	102	Forced Air
	232	Oil
	109	Floor/Wall Furnace
	104	Gravity
	105	Heat Pump
	243	Geo-Thermal
	111	Hot Water
	231	Gas
	226	Partial
	112	Radiant
	219	None
	101	Other
	110	Steam
	229	Coal
	120	Space
	222	Convection
	106	Solar
	122	Wood Furnace
	244	Propane
	236	Yes
	238	Zone
ForeclosureRecordType	Null	Null
		Not Available
	ND	Notice of Default
	NL	Notice of Lis Pendens
	NS	Notice of Foreclosure Sale
	NT	Notice of Trustee Sale
MailingAddressType	Null	Null
		Not Available
	A	Alias
	F	Firm or Company Address
	G	General Delivery Address
	H	High Rise or Business Complex
	P	P.O. Box Address
	R	Rural Route Address
	S	Street or Residential Address
	U	Unique
	Z	Unique