Skip to content
Pillow Documentation

Systems

These attributes describe the mechanical, electrical, plumbing, and technology systems in a property.

HVAC (Heating, Ventilation, Air Conditioning)

Section titled “HVAC (Heating, Ventilation, Air Conditioning)”

hvac_type

Section titled “hvac_type”
  • Type: VARCHAR(100)
  • Description: Type of HVAC system
  • Values: "central_air", "forced_air", "radiant", "heat_pump", "window_units", "none"
  • Example: "central_air"
  • Required: No

heating_system

Section titled “heating_system”
  • Type: VARCHAR(100)
  • Description: Heating system type
  • Values: "forced_air", "radiant", "baseboard", "heat_pump", "wood_stove"
  • Example: "forced_air"
  • Required: No

heating_fuel

Section titled “heating_fuel”
  • Type: VARCHAR(50)
  • Description: Fuel source for heating
  • Values: "natural_gas", "electric", "propane", "oil", "wood"
  • Example: "natural_gas"
  • Required: No

cooling_system

Section titled “cooling_system”
  • Type: VARCHAR(100)
  • Description: Cooling system type
  • Values: "central_air", "heat_pump", "window_units", "evaporative", "none"
  • Example: "central_air"
  • Required: No

air_conditioning_type

Section titled “air_conditioning_type”
  • Type: VARCHAR(50)
  • Description: Air conditioning system type
  • Example: "split_system"
  • Required: No

has_central_air

Section titled “has_central_air”
  • Type: BOOLEAN
  • Description: Whether property has central air conditioning
  • Example: true
  • Required: No

has_heat_pump

Section titled “has_heat_pump”
  • Type: BOOLEAN
  • Description: Whether property has heat pump system
  • Example: true
  • Required: No

has_radiant_heating

Section titled “has_radiant_heating”
  • Type: BOOLEAN
  • Description: Whether property has radiant heating
  • Example: false
  • Required: No

has_forced_air

Section titled “has_forced_air”
  • Type: BOOLEAN
  • Description: Whether property has forced air system
  • Example: true
  • Required: No

has_boiler

Section titled “has_boiler”
  • Type: BOOLEAN
  • Description: Whether property has boiler system
  • Example: false
  • Required: No

has_furnace

Section titled “has_furnace”
  • Type: BOOLEAN
  • Description: Whether property has furnace
  • Example: true
  • Required: No

has_fireplace

Section titled “has_fireplace”
  • Type: BOOLEAN
  • Description: Whether property has fireplace(s)
  • Example: true
  • Required: No

fireplaces_total

Section titled “fireplaces_total”
  • Type: INT
  • Description: Total number of fireplaces
  • Example: 2
  • Required: No

fireplace_types

Section titled “fireplace_types”
  • Type: VARCHAR(200)
  • Description: Types of fireplaces (comma-separated)
  • Example: "wood_burning,gas"
  • Required: No

hvac_age_years

Section titled “hvac_age_years”
  • Type: INT
  • Description: Age of HVAC system in years
  • Example: 8
  • Required: No

hvac_zones

Section titled “hvac_zones”
  • Type: INT
  • Description: Number of HVAC zones
  • Example: 3
  • Required: No

has_programmable_thermostat

Section titled “has_programmable_thermostat”
  • Type: BOOLEAN
  • Description: Whether property has programmable thermostat
  • Example: true
  • Required: No

has_smart_thermostat

Section titled “has_smart_thermostat”
  • Type: BOOLEAN
  • Description: Whether property has smart/WiFi thermostat
  • Example: true
  • Required: No

Electrical

Section titled “Electrical”

electrical_panel_type

Section titled “electrical_panel_type”
  • Type: VARCHAR(50)
  • Description: Type of electrical panel
  • Values: "circuit_breaker", "fuse_box", "smart_panel"
  • Example: "circuit_breaker"
  • Required: No

electrical_amps

Section titled “electrical_amps”
  • Type: INT
  • Description: Electrical service amperage
  • Example: 200
  • Required: No
  • Unit: Amperes

electrical_voltage

Section titled “electrical_voltage”
  • Type: INT
  • Description: Electrical service voltage
  • Example: 240
  • Required: No
  • Unit: Volts

has_220v_service

Section titled “has_220v_service”
  • Type: BOOLEAN
  • Description: Whether property has 220V service
  • Example: true
  • Required: No

has_whole_house_generator

Section titled “has_whole_house_generator”
  • Type: BOOLEAN
  • Description: Whether property has whole-house backup generator
  • Example: false
  • Required: No

has_backup_generator

Section titled “has_backup_generator”
  • Type: BOOLEAN
  • Description: Whether property has backup generator
  • Example: true
  • Required: No

has_solar_panels

Section titled “has_solar_panels”
  • Type: BOOLEAN
  • Description: Whether property has solar panels
  • Example: true
  • Required: No

solar_owned_leased

Section titled “solar_owned_leased”
  • Type: VARCHAR(20)
  • Description: Whether solar panels are owned or leased
  • Values: "owned", "leased"
  • Example: "owned"
  • Required: No

solar_kw_capacity

Section titled “solar_kw_capacity”
  • Type: DOUBLE
  • Description: Solar panel capacity in kilowatts
  • Example: 5.5
  • Required: No
  • Unit: Kilowatts

Plumbing

Section titled “Plumbing”

plumbing_type

Section titled “plumbing_type”
  • Type: VARCHAR(50)
  • Description: Type of plumbing system
  • Values: "copper", "pex", "pvc", "galvanized", "mixed"
  • Example: "copper"
  • Required: No

water_supply

Section titled “water_supply”
  • Type: VARCHAR(50)
  • Description: Water supply source
  • Values: "municipal", "well", "shared_well"
  • Example: "municipal"
  • Required: No

sewer_system

Section titled “sewer_system”
  • Type: VARCHAR(50)
  • Description: Sewer system type
  • Values: "municipal", "septic", "cesspool"
  • Example: "municipal"
  • Required: No

water_heater_type

Section titled “water_heater_type”
  • Type: VARCHAR(50)
  • Description: Water heater type
  • Values: "tank", "tankless", "heat_pump", "solar"
  • Example: "tank"
  • Required: No

water_heater_fuel

Section titled “water_heater_fuel”
  • Type: VARCHAR(50)
  • Description: Water heater fuel source
  • Values: "natural_gas", "electric", "propane", "solar"
  • Example: "natural_gas"
  • Required: No

water_heater_age_years

Section titled “water_heater_age_years”
  • Type: INT
  • Description: Age of water heater in years
  • Example: 5
  • Required: No

has_tankless_water_heater

Section titled “has_tankless_water_heater”
  • Type: BOOLEAN
  • Description: Whether property has tankless water heater
  • Example: true
  • Required: No

has_water_softener

Section titled “has_water_softener”
  • Type: BOOLEAN
  • Description: Whether property has water softener system
  • Example: true
  • Required: No

has_water_filtration

Section titled “has_water_filtration”
  • Type: BOOLEAN
  • Description: Whether property has water filtration system
  • Example: true
  • Required: No

has_sump_pump

Section titled “has_sump_pump”
  • Type: BOOLEAN
  • Description: Whether property has sump pump
  • Example: true
  • Required: No

Internet & Technology

Section titled “Internet & Technology”

internet_available

Section titled “internet_available”
  • Type: VARCHAR(200)
  • Description: Available internet service providers/types
  • Example: "fiber,cable"
  • Required: No

internet_speed_mbps

Section titled “internet_speed_mbps”
  • Type: INT
  • Description: Maximum available internet speed in Mbps
  • Example: 1000
  • Required: No
  • Unit: Megabits per second

has_fiber_internet

Section titled “has_fiber_internet”
  • Type: BOOLEAN
  • Description: Whether fiber internet is available
  • Example: true
  • Required: No

has_cable_internet

Section titled “has_cable_internet”
  • Type: BOOLEAN
  • Description: Whether cable internet is available
  • Example: true
  • Required: No

has_satellite_internet

Section titled “has_satellite_internet”
  • Type: BOOLEAN
  • Description: Whether satellite internet is available
  • Example: false
  • Required: No

has_5g_coverage

Section titled “has_5g_coverage”
  • Type: BOOLEAN
  • Description: Whether 5G cellular coverage is available
  • Example: true
  • Required: No

has_structured_wiring

Section titled “has_structured_wiring”
  • Type: BOOLEAN
  • Description: Whether property has structured wiring (Ethernet, etc.)
  • Example: true
  • Required: No

has_security_pre_wire

Section titled “has_security_pre_wire”
  • Type: BOOLEAN
  • Description: Whether property is pre-wired for security systems
  • Example: true
  • Required: No

has_sound_pre_wire

Section titled “has_sound_pre_wire”
  • Type: BOOLEAN
  • Description: Whether property is pre-wired for sound systems
  • Example: true
  • Required: No

Usage Examples

Section titled “Usage Examples”

Find Properties with Central Air

Section titled “Find Properties with Central Air”
SELECT * FROM properties
WHERE has_central_air = true
AND status = 'active';

Properties with Solar Panels

Section titled “Properties with Solar Panels”
SELECT * FROM properties
WHERE has_solar_panels = true
ORDER BY solar_kw_capacity DESC;

Filter by Internet Speed

Section titled “Filter by Internet Speed”
SELECT * FROM properties
WHERE internet_speed_mbps >= 100
AND has_fiber_internet = true;

Properties Needing HVAC Replacement

Section titled “Properties Needing HVAC Replacement”
SELECT * FROM properties
WHERE hvac_age_years >= 15
ORDER BY hvac_age_years DESC;

Find Properties with Well Water

Section titled “Find Properties with Well Water”
SELECT * FROM properties
WHERE water_supply = 'well';

Best Practices

Section titled “Best Practices”
  1. Document system ages: Track hvac_age_years, water_heater_age_years for maintenance planning
  2. Specify fuel types: Important for operating cost estimates
  3. Note internet availability: Critical for remote work buyers
  4. Track solar details: Ownership vs lease affects property value
  5. Document pre-wiring: Adds value for smart home buyers
Section titled “Related Attributes”