Skip to content
Pillow Documentation

Construction Attributes

These attributes describe the construction details, materials, age, and structural characteristics of a property.

Age & History

Section titled “Age & History”

year_built

Section titled “year_built”
  • Type: INT
  • Description: Year the property was originally built
  • Example: 2010
  • Required: No
  • Indexed: Yes
  • Use Case: Age-based filtering and depreciation calculations

year_renovated

Section titled “year_renovated”
  • Type: INT
  • Description: Year of most recent major renovation
  • Example: 2020
  • Required: No
  • Use Case: Track property updates

effective_year_built

Section titled “effective_year_built”
  • Type: INT
  • Description: Effective build year after major renovations
  • Example: 2020
  • Required: No
  • Note: May differ from year_built if extensively renovated

age_years

Section titled “age_years”
  • Type: INT
  • Description: Current age of property in years (calculated)
  • Example: 14
  • Required: No
  • Calculation: Current year - year_built

Condition & Quality

Section titled “Condition & Quality”

condition_rating

Section titled “condition_rating”
  • Type: VARCHAR(50)
  • Description: Overall condition rating
  • Values: "excellent", "good", "fair", "poor", "needs_renovation"
  • Example: "excellent"
  • Required: No

quality_rating

Section titled “quality_rating”
  • Type: VARCHAR(50)
  • Description: Construction quality rating
  • Values: "luxury", "high", "average", "basic"
  • Example: "high"
  • Required: No

overall_condition

Section titled “overall_condition”
  • Type: VARCHAR(50)
  • Description: Overall property condition assessment
  • Example: "move_in_ready"
  • Required: No

maintenance_level

Section titled “maintenance_level”
  • Type: VARCHAR(50)
  • Description: Level of maintenance required
  • Values: "low", "average", "high"
  • Example: "low"
  • Required: No

renovation_level

Section titled “renovation_level”
  • Type: VARCHAR(50)
  • Description: Level of renovation/updates
  • Values: "fully_renovated", "partially_renovated", "original", "needs_renovation"
  • Example: "fully_renovated"
  • Required: No

Construction Type

Section titled “Construction Type”

construction_type

Section titled “construction_type”
  • Type: VARCHAR(50)
  • Description: Primary construction method
  • Values: "wood_frame", "concrete", "steel_frame", "brick", "stone", "mixed"
  • Example: "wood_frame"
  • Required: No

foundation_type

Section titled “foundation_type”
  • Type: VARCHAR(50)
  • Description: Foundation type
  • Values: "slab", "crawl_space", "basement", "pier_and_beam"
  • Example: "basement"
  • Required: No

Exterior Materials

Section titled “Exterior Materials”

exterior_material

Section titled “exterior_material”
  • Type: VARCHAR(100)
  • Description: Primary exterior material
  • Values: "vinyl_siding", "brick", "stucco", "wood", "fiber_cement", "stone"
  • Example: "brick"
  • Required: No

siding_material

Section titled “siding_material”
  • Type: VARCHAR(100)
  • Description: Siding material (if applicable)
  • Example: "cedar"
  • Required: No

Roof

Section titled “Roof”

roof_material

Section titled “roof_material”
  • Type: VARCHAR(100)
  • Description: Roof material
  • Values: "asphalt_shingle", "tile", "metal", "slate", "wood_shake"
  • Example: "asphalt_shingle"
  • Required: No

roof_style

Section titled “roof_style”
  • Type: VARCHAR(50)
  • Description: Roof style
  • Values: "gable", "hip", "flat", "mansard", "gambrel"
  • Example: "gable"
  • Required: No

roof_age_years

Section titled “roof_age_years”
  • Type: INT
  • Description: Age of roof in years
  • Example: 5
  • Required: No
  • Use Case: Maintenance planning

Windows & Doors

Section titled “Windows & Doors”

window_material

Section titled “window_material”
  • Type: VARCHAR(50)
  • Description: Window frame material
  • Values: "vinyl", "wood", "aluminum", "fiberglass"
  • Example: "vinyl"
  • Required: No

window_type

Section titled “window_type”
  • Type: VARCHAR(50)
  • Description: Window type
  • Values: "double_pane", "triple_pane", "single_pane", "energy_efficient"
  • Example: "double_pane"
  • Required: No

door_material

Section titled “door_material”
  • Type: VARCHAR(50)
  • Description: Exterior door material
  • Values: "wood", "steel", "fiberglass", "glass"
  • Example: "steel"
  • Required: No

Architectural Details

Section titled “Architectural Details”

architectural_style

Section titled “architectural_style”
  • Type: VARCHAR(100)
  • Description: Architectural style
  • Values: "colonial", "ranch", "contemporary", "victorian", "craftsman"
  • Example: "contemporary"
  • Required: No

ceiling_height_main

Section titled “ceiling_height_main”
  • Type: DOUBLE
  • Description: Main floor ceiling height in meters
  • Example: 2.7
  • Required: No
  • Unit: Meters

ceiling_height_max

Section titled “ceiling_height_max”
  • Type: DOUBLE
  • Description: Maximum ceiling height in meters
  • Example: 3.5
  • Required: No
  • Unit: Meters

ceiling_types

Section titled “ceiling_types”
  • Type: VARCHAR(200)
  • Description: Types of ceilings (comma-separated)
  • Example: "vaulted,coffered"
  • Required: No

floor_plan_type

Section titled “floor_plan_type”
  • Type: VARCHAR(50)
  • Description: Floor plan layout type
  • Values: "open", "traditional", "split_level", "loft"
  • Example: "open"
  • Required: No

entry_type

Section titled “entry_type”
  • Type: VARCHAR(50)
  • Description: Entry type
  • Values: "foyer", "direct", "side", "rear"
  • Example: "foyer"
  • Required: No

Usage Examples

Section titled “Usage Examples”

Filter by Age

Section titled “Filter by Age”
SELECT * FROM properties
WHERE year_built >= 2010
AND status = 'active'
ORDER BY year_built DESC;

Find Recently Renovated Properties

Section titled “Find Recently Renovated Properties”
SELECT * FROM properties
WHERE year_renovated >= 2020
ORDER BY year_renovated DESC;

Properties Needing Renovation

Section titled “Properties Needing Renovation”
SELECT * FROM properties
WHERE condition_rating = 'needs_renovation'
OR renovation_level = 'needs_renovation'
ORDER BY year_built;

Filter by Construction Type

Section titled “Filter by Construction Type”
SELECT * FROM properties
WHERE construction_type = 'wood_frame'
AND year_built >= 2000;

Find Properties with New Roofs

Section titled “Find Properties with New Roofs”
SELECT * FROM properties
WHERE roof_age_years <= 5
ORDER BY roof_age_years;

Best Practices

Section titled “Best Practices”
  1. Always set year_built: Essential for age-based analysis
  2. Track renovations: Update year_renovated when major work is done
  3. Set condition ratings: Helps buyers understand property state
  4. Document materials: Detailed material info helps with maintenance estimates
  5. Update roof age: Important for insurance and maintenance planning
Section titled “Related Attributes”