Skip to content
Pillow Documentation

Basic Information Attributes

These attributes describe the fundamental characteristics and classification of a property.

Property Classification

Section titled “Property Classification”

property_type

Section titled “property_type”
  • Type: VARCHAR(50)
  • Description: Primary classification of the property
  • Common Values: "house", "apartment", "condo", "townhouse", "multi_family", "commercial", "land", "other"
  • Example: "house"
  • Required: Yes
  • Indexed: Yes
  • Use Case: Primary filter for property searches

property_subtype

Section titled “property_subtype”
  • Type: VARCHAR(100)
  • Description: More specific classification within the property type
  • Examples:
    • For property_type="house": "detached", "semi_detached", "duplex", "triplex"
    • For property_type="apartment": "studio", "loft", "penthouse"
  • Required: No
  • Use Case: Refined filtering and categorization

property_style

Section titled “property_style”
  • Type: VARCHAR(50)
  • Description: Architectural style of the property
  • Examples: "colonial", "ranch", "contemporary", "victorian", "modern", "craftsman", "mediterranean"
  • Required: No
  • Use Case: Style-based searches and recommendations

property_use

Section titled “property_use”
  • Type: VARCHAR(50)
  • Description: Intended or current use of the property
  • Values: "primary_residence", "investment", "vacation", "commercial", "mixed_use"
  • Example: "investment"
  • Required: No
  • Use Case: Investment analysis and filtering

Property Names & Descriptions

Section titled “Property Names & Descriptions”

property_name

Section titled “property_name”
  • Type: VARCHAR(200)
  • Description: Name or title of the property (if it has one)
  • Example: "Oceanview Estate", "Sunset Villa"
  • Required: No
  • Note: Not all properties have names; many use addresses

title

Section titled “title”
  • Type: VARCHAR(500)
  • Description: Marketing title or headline for the listing
  • Example: "Stunning 3 Bedroom House with Ocean Views"
  • Required: No
  • Use Case: Display in search results and listings

description

Section titled “description”
  • Type: TEXT
  • Description: Full text description of the property
  • Example: "Beautiful family home in prime location with modern amenities..."
  • Required: No
  • Use Case: Full-text search and detailed property pages

Status Attributes

Section titled “Status Attributes”

status

Section titled “status”
  • Type: VARCHAR(50)
  • Description: Current status of the property listing
  • Common Values: "active", "pending", "sold", "off_market", "withdrawn", "expired"
  • Example: "active"
  • Required: Yes
  • Indexed: Yes
  • Use Case: Filter active listings, track sales

listing_status

Section titled “listing_status”
  • Type: VARCHAR(50)
  • Description: Detailed listing status (more granular than status)
  • Values: "for_sale", "for_rent", "auction", "pre_auction", "under_contract", "sold", "rented"
  • Example: "for_sale"
  • Required: No
  • Note: More specific than status; can coexist

Usage Examples

Section titled “Usage Examples”

Filter by Property Type

Section titled “Filter by Property Type”
SELECT * FROM properties
WHERE property_type = 'house'
AND status = 'active';

Search by Style

Section titled “Search by Style”
SELECT * FROM properties
WHERE property_style IN ('contemporary', 'modern')
AND property_type = 'house';

Find Investment Properties

Section titled “Find Investment Properties”
SELECT * FROM properties
WHERE property_use = 'investment'
AND status = 'active'
ORDER BY price_current;

Full-Text Search in Description

Section titled “Full-Text Search in Description”
SELECT * FROM properties
WHERE description LIKE '%ocean view%'
OR title LIKE '%ocean view%';

Data Quality Notes

Section titled “Data Quality Notes”
  • property_type should always be set; it’s a required field
  • property_subtype provides additional detail but may not be available for all properties
  • status should be kept current; stale statuses reduce data quality
  • description quality varies by source; some harvesters provide rich descriptions, others minimal
Section titled “Related Attributes”